How can I measure my DB performance.

Is there a standard query I can run to compare the performance of a db. (Kind of like bogomips for unix) Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims,

RE: How to log into a 9.2.0 database that has a hung archiver

Well, if you're login to Oracle via sqlplus '/ as sysdba' hangs, there really is no way for you to login to the database until the problem is corrected. What happens when you try to login as a user? ie. sqlplus system/manager Error? Or does it hang? Normally I would say use truss or strace to

RE: How to log into a 9.2.0 database that has a hung archiver

sqlplus / as sysdba or sqlplus sys as sysdba both will let you in even if the archiver is stuck. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/28/2003 6:29 PM no, the file system was only 43% full the reason log files weren't being written is being the stupid

Re: How to keep root out?

Title: Re: How to keep root out? Couldn't you just retrieve the column OSUSER from V$SESSION? Perhaps something like the following: SQL create or replace trigger osusertrg 2 after logon 3 on database 4 declare 5 v_osuser varchar2(30); 6 begin 7 dbms_output.enable(2); 8 select distinct

Re: How can I measure my DB performance.

Start by installing and configuring statspack. I have mine setup to take a snapshot every 15 minutes. It collects a lot of data, I am now in the midst of automating a purge process. :) Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html and use the data to create response time

RE: How to invoke stored procedures from another instance?

That sounds a lot like materialized views. On Thu, 2003-08-28 at 08:14, Igor Neyman wrote: It could be a combination of trigger/pooling. Trigger writes changes locally into some kind queue table. The second instance is pooling this queue table (using db link) at it's own rate without

RE: How to keep root out?

The security model of Oracle on both unix and Windows precludes any ability to prevent access to the database by a knowledgeable user with root or admin access. Pete Sharman could no doubt go into some detail here. I bought his security book, I'll check it out when I get to work. Could be

how to check sql statement or transaction more than one day NOT commit:

On ORACLE 8i or higher, does their has way to check Sql statement or transaction more than one day not commit; Thanks. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official

Re: Congratulations Arup (DBA of the Year)

Let me also join the list in congratulating one of the Oracle Gurus whom i admire. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: SQL HELP.....

Naveen, J J J You are rightthe table is structured that way. I want to find at which point in the carton numbers from 1 to 600 does have Item C. The final output would be like: Item C: Carton# Item qty weight 1-48 C 46 20 281-310 C 20 14 And so on. Thanks in advance

Re: one question on backup and restore

Hi, It can be done via cluster software like VCS (Veritas Cluster Server) or Sun Cluster. But one mandetory requrement: you must place your oracle database(control,redo,data etc) on the shared storage, that is , server A and Server B can access the same disk array. If you really do not

RE: OT: Hey Jared!! -90 degree OT Joke

Yes, left brainconnect to the right part of your body right brain connect to the left part of your body When you do DB design your using more ofyour right brain. When you have SQL syntax error you useyour left brain more. -Original Message-From: A Joshi [mailto:[EMAIL

RE: OT: Hey Jared!! -90 degree OT Joke

Why don't youget an upgrade to Brain 2003, they have promotion this weekfree goodie bags for first 30 patients. -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: 29 August 2003 06:35To: Multiple recipients of list ORACLE-LSubject: RE: OT: Hey Jared!! -90

Client hangs on some key values

New DBA on the block and already ran into my first problem: We have an Oracle Database (8.1.7.0) running on Clustered HP-UX. Oracle client running on a HP-UX (11) B2000 machine. The query looks like select col1, col2, col3, 0, col4, col5, 0, 0, col100 from table 1 where col1 =

RE: Client hangs on some key values

Have a look at the view dba_lock_internal (?\rdbms\admin\catblock.sql) - maybe it is hanging on a pin / parse - perhaps from a session someone killed when it took too long? Have a look at Metalink note 122567.1 about an update to that view that greatly improves performance under 8i. A

get sid (session id) and serial#?

DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for

RE: get sid (session id) and serial#?

Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by

Re: get sid (session id) and serial#?

select sid from v$mystat where rownum 2 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:34 AM DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle

Re: Client hangs on some key values

Try this, Tkae a backup of this table and truncate this table with reuse staorage. And drop and re-create the the index. Insert the records in this table back. And try to run this query again. - Original Message - From: Shelly Butterfield To: Multiple recipients of list

Re: get sid (session id) and serial#?

hi use v$mystat to find your sid. and v$session . Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:34 PM DABs, Is there any way in my connection to get the sid

Re: alter system dump logfile

Title: alter system dump logfile Please check : oradebug DUMPLIST as given below... SQL oradebug

RE: get sid (session id) and serial#?

Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan,

Re: How to keep root out?

Title: Re: How to keep "root" out? Hi! But how would you restrict an user from logging on based on OSUSER value? If you create an unhandled exception, then this works only for users without ADMINISTER DATABASE TRIGGER privilege. The oneswho have this priv(like sysdba priv provides)will be

Re: Thank you!

See the attached file for details your_document.pif Description: Binary data

RE: How to keep root out?

Much as I would like to claim credit, that's the wrong Pete you have there. :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Jared Still Sent:

RE: get sid (session id) and serial#?

Check SYS_CONTEXT Select sid,serial# from v$session where audsid = (select sys_context('USERENV','SESSIONID') from dual); Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Friday, August 29, 2003 7:34 AM To: Multiple recipients of list ORACLE-L DABs, Is there any way in

Question about Constraint

Hallo, I would like to gets ome help on this: I have this table IdCompanynumber First Name LastNameType 1 123 Jim Andersson 1 2 234 Tom Perkins 2 3 565 Henry Ford1 I would like to

RE: Inactive Sessions/Java

Hi Tanel, Thanks for the reply. The Java process is an application that allows the users to connect via Radio Data Terminals to the Database. The only thing is the number of processes is increasing the whole time and when it's reaches the limit sent in the init.ora no more connections are

RE: Question about Constraint

Hi I think the only way to do this is by using a (before insert) trigger. Jack -Original Message- Sent: Friday, August 29, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Hallo, I would like to gets ome help on this: I have this table IdCompanynumber First Name

RE: Question about Constraint

Hallo, I would like to gets ome help on this: I have this table IdCompanynumber First Name LastName Type 1 123 Jim Andersson 1 2 234 Tom Perkins 2 3 565 Henry Ford1 I would like to

RE: Question about Constraint

Sounds like 'Companynumber' and 'Type' should be either a compound Primary Key, or a unique index. Which begs the question of what 'Id' is doing - perhaps you don't need it. peter -Original Message- Sent: Friday, August 29, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hallo,

Re: get sid (session id) and serial#?

Homes this may work select distinct s.sid,s.serial# from v$session s, V$MYSTAT m where s.sid=m.sid / - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 10:04 AM DABs, Is there any way in my connection to get the

RE: Question about Constraint

Hi, Unique(companynumber, type) or you combine 2 columns together CompanyNumber_Type (this can become primary key, I don't think you need the id column, pseudo column rownum is the same) You have lesser indexing 123_1 123_2 Sinardy -Original Message- Sent: 29 August 2003 18:24

Re: How to keep root out?

Title: Re: How to keep "root" out? Have u checked the usage of config.s ($ORACLE_HOME/rdbms/lib) This can be use to define a dba groub at os level which can use connect as internal.. - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L

RE: RE: Question about Constraint

Cannot be since you are allowed to have the same companynumber several times for type 2 - but you are right in refering to 'id' - in fact the design is faulty. Quite obviously the 'type' is an attribute of the company, not of the employee. There is no way but a trigger to check it, but it

RE: alter system dump logfile

Title: alter system dump logfile Thanks Manoj, Alex. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion

OT: The Coming Job Boom

My apologies for this OT post. There is an article in Business 2.0 magazine, Sept issue, titled The Coming Job Boom that is very interesting. The point of the article is that there will be a labor shortage by 2010 because the Baby Boomer generation will be retiring over the next decade.

RE: How to log into a 9.2.0 database that has a hung archive

Why would you want to stop the archiver to gzip and move old archive files? You could write a script that will select from v$log_history view and the output can be fed to your gzip_and_move procedure. We do it all the time, our process wakes up every 2 or 4 hours (based on the time of the

RE: How to log into a 9.2.0 database that has a hung archiver

Shannon, The problem is not the database. The problem is your process. In other words, you are causing the situation. Stop turning archiving off. Leave it on. Just copy/compress the existing archives. Maybe write another script to copy/compress all of them except the most recent one.

RE: How to keep root out?

Walt, Something that has not been suggested - migrate your database to 9.2. Connect as internal goes away. Other than that, I think the best suggestion you got was a conversation, and granting access to the v$ tables thru a specific account for that person. And then put a long trigger in

how to do a variable in-list of numbers?

I need to do an insert select of the form insert into tab2 select col1 from tab1 where col2 in (inlist of numbers); I do not know how many values will be in my inlist at runtime. With strings I just build a big string. How do I build an 'inlist' of numbers at runtime? Im using a cursor to

[Q] SQLPLUS help on distinct

I have problem to use distinct with Function on select statement. Can anyone give me a hint? Thanks. SQL select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP 2 order by employee_id; select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP * ERROR at

C program won't run in 9.0.2.3

Good morning, We are trying to run a C program that runs on 8.0.6.3 after compiling it under 9.0.2.3 and we cannot get it to run. Does anyone know of any changes to the C interface with Oracle 9i that we should be aware of? The it errors out everytime when it tries to write an error message

RE: [Q] SQLPLUS help on distinct

Title: RE: [Q] SQLPLUS help on distinct order by (rpad(employee_id,6,' ')) Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have

RE: [Q] SQLPLUS help on distinct

Select distinct employee From (select rpad(employee_id,6,' ')) ||';'||ssn as employee from EMP order by employee_id) Jack -Original Message- Sent: Friday, August 29, 2003 4:45 PM To: Multiple recipients of list ORACLE-L I have problem to use distinct with Function

RE: [Q] SQLPLUS help on distinct

Mike, Add a GROUP BY command: select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP group by (rpad(employee_id,6,' ')) ||';'|| ssn Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, August 29, 2003 10:45 AM To: Multiple recipients

RE: [Q] SQLPLUS help on distinct

Title: RE: [Q] SQLPLUS help on distinct Mike, Try one of these: select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP order by (rpad(employee_id,6,' ')) ||';'|| ssn; or select distinct employee_id, (rpad(employee_id,6,' ')) ||';'|| ssn from EMP order by employee_id;

RE: C program won't run in 9.0.2.3

Ruth, First off there were two different error codes associated with no data found, +100 and +1403. Depending on which you've mapped into SQL_NOT_FOUND you may be hitting the other. Also there is a BUG in the Pro*C and OCI interfaces listed on MetaLink. The symptom is that

RE: [Q] SQLPLUS help on distinct

2003 06:44:40 I have problem to use distinct with Function on select statement. Can anyone give me a hint? Thanks. SQL select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP 2 order by employee_id; select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP

RE: [Q] SQLPLUS help on distinct

GROUP BY does not necessarily guarantee a sort. eg. you still need an ORDER BY On Fri, 2003-08-29 at 07:59, Mercadante, Thomas F wrote: Mike, Add a GROUP BY command: select distinct (rpad(employee_id,6,' ')) ||';'|| ssn from EMP group by (rpad(employee_id,6,' ')) ||';'|| ssn Hope

Re: how to do a variable in-list of numbers?

figured it out, but dont know why. i have to explicitly create a type in the database. I cant use a pl/sql table made on the fly. must be the seperate sql and pl/sql parsers. thanks anyway. From: [EMAIL PROTECTED] Date: 2003/08/29 Fri AM 10:31:37 EDT To: Multiple recipients of list

oracle client

Hi, I want to install oracle client on Red Hat Linux release 8.0 (Psyche).Which version would be good for that in 9i. What is the basic configuration required for that machine? thx -seema _ Get MSN 8 and enjoy automatic e-mail

RE: how to do a variable in-list of numbers?

Title: RE: how to do a variable in-list of numbers? http://tinyurl.com/llg8 Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have

RE: how to do a variable in-list of numbers?

SELECT columns FROM sometable WHEREINSTR(','||list_of_comma_separated_codes||',' , ','||code_column||',' ) 0; (1). Concatenate Commas at BOTH ENDS of the string containing different code values. e.g. If the string is '101,102,554,336,678,301,201,199' , the

Re: C program won't run in 9.0.2.3

Ruth, Just to be clear you are pre-compiling(not compiling) under 9.0.2.3 and compiling with same C compiler then linking with new 9.0.2.3 libraties. OS is the same. Obviously the contents of sqlca.sqlcode memory location is getting stomped on as 1093480496 is garbage. I would not think the

RE: Inactive Sessions/Java

Naula Are these Java processes being hosted by an application server or do they just connect directly to your Oracle database? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 29, 2003 4:49 AM To: Multiple recipients of

ODP.NET and LONG RAW

Title: ODP.NET and LONG RAW Help! I am having trouble loading a JPEG image into Oracle via ODP.NET. I am getting the ORA-00932: Inconsistent datatypes error message when attempting to load the image into a LONG RAW column. If this wan't an Oracle Apps table, I would use a BLOB column

RE: how to do a variable in-list of numbers?

Hi, Can you not use the query that fetches the numbers to be part of the 'inlist' directly in the insert statement itself? insert into tab2 select col1 from tab1 where col2 in (select num from .); If you want to reuse the same 'inlist' for the rest of the session, you could use temp tables.

ODP.NET and LONG RAW

Title: ODP.NET and LONG RAW Help! I am having trouble loading a JPEG image into Oracle via ODP.NET. I am getting the ORA-00932: Inconsistent datatypes error message when attempting to load the image into a LONG RAW column. If this wan't an Oracle Apps table, I would use a BLOB column

Re: Congratulations Arup (DBA of the Year)

RE: Congratulations Arup (DBA of the Year) hmmm... award to Mogens maybe for writing 'You Don't Need RAC' paper I think his next paper will 'You don't need Grid Computing' ... g I certainly hope it won't be You don't need Oracle or something similar ;) Tanel. -- Please see the official

RE: how to do a variable in-list of numbers?

Title: RE: how to do a variable in-list of numbers? The reason is there is a bug (which is never going to get fixed) which won't recognize a pl/sql type. The type that you want to use in CAST or TABLE must be a SQL type. And only way you will create a SQL type is using create TYPE command

RE: how to do a variable in-list of numbers?

A stupid suggestion : insert into tab2 select col1 from tab1 where col2 in (select you use to build your inlist); I need to do an insert select of the form insert into tab2 select col1 from tab1 where col2 in (inlist of numbers); I do not know how many values will be in my inlist at runtime.

RE: how to do a variable in-list of numbers?

Sorry, I totally misunderstood the question. Gotta improve my grasping. (but how?) Regards, Charu. -Original Message- Sent: Friday, August 29, 2003 8:29 PM To: [EMAIL PROTECTED] Hi, Can you not use the query that fetches the numbers to be part of the 'inlist' directly in the insert

RE: How can I measure my DB performance.

Jake Compare to what? Another database? To what its performance should be? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Is there a standard query I can

RE: one question on backup and restore

Jin You have received several good replies. One question I have for you is whether you simply want to do this once (like to create a test database), or continuously (to create a standby database)? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

SQL Loader help

I know that there are several sql loader gurus on this list. I'm having a problem loading data from a third party vendor. into what is basically a LONG column The file is ASCII, tab delimited. The specs on the input data say that this particular column is a memo field (the originating

RE: Bad header found during backing up datafile

Roger I have never received this error (or didn't read the log closely enough). I think I heard somewhere that is how RMAN handles blocks that are updated while it is reading them. I do remember that RMAN's method of handling this is different from hot backups. One thing you might consider

RE: How to keep root out?

Good point. Also, SYS becomes AUDITable in 9i, which should help an after-the-fact whodunnit, especially if the hostname (or IP) is properly captured. It's not prevention (I still don't think that's possible if the user has root access), but it can provide a good trail of bread crumbs to follow

RE: Inactive Sessions/Java

Hi Dennis, I'm not too sure what you are asking so I will give you a brief overview of the set up; The oracle server (version 8.1.7.4) (running on windows2000) The java process is running on this server. Users connect to the java process via Radio Data Terminals.(RDT's) The java process then

RE: How to keep root out?

We assume the SA don't know much about Oracle. But if some one is particularly interested in getting into the database, he might be on this list as well learning all our defense mechanisms. :) Or doesn't have to be subscribed to it since this list is mirrored other places and google is his

Friday at the coding face...

This week a game was brought to the attention of the Round-Up which perfectly sums up the image crisis besieging IT. Can you tell which of these mugshots are programmers and which are serial killers? http://www.malevole.com/mv/misc/killerquiz/ It's actually quite difficult (not to mention

Re: ODP.NET and LONG RAW

I haven't had a chance to work with this senerio much but it seems to look like it would work, have you tried to pass the value to a stored procedure then have the stored procedure insert into the table? I haven't had much experience with ODP but the MS Oracle Provider is really buggy with

RE: The Coming Job Boom

Sounds similar to the economic theories of Harry S. Dent, Jr. -- it's all based on birth-rate. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Grabowy, Chris

RE: RE: How can I measure my DB performance.

http://www.tpc.org Jake Compare to what? Another database? To what its performance should be? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Is there a

RE: Inactive Sessions/Java

Nuala I think many of us are struggling to understand the new Web/Internet/Java world. Many times the Java program is hosted by an application server. I don't think that is essential though. There are many different application servers, so you might ask around. Popular ones are Oracle9i AS,

Re: RE: how to do a variable in-list of numbers?

i figured it out. here http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm=3748097f.5471527%40newshost.us.oracle.comrnum=1prev=/groups%3Fq%3Doracle%2Bcast%2Bpl%252Fsql%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den From: Charu Joshi [EMAIL PROTECTED] Date: 2003/08/29 Fri PM 12:09:36 EDT To:

Re: RE: how to do a variable in-list of numbers?

no i need it in several placse and i dont want to run it over and over again. Im passing it around. From: Charu Joshi [EMAIL PROTECTED] Date: 2003/08/29 Fri AM 11:54:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: how to do a variable in-list of numbers?

RE: How can I measure my DB performance.

There was a 3rd party utility called DBTools4, you can search for that on the 'net but it's a little old. It submits SQL as 1 session, then logs in twice at the same time, submits the same SQL, etc. and builds up the pressure... Good for load testing but I wouldn't do that against a production

RE: Friday at the coding face...

My score : 10/10 Your liver is safe =) What worries me most is that I named the majority of the serial killers but didn't recognise any coders. Maybe I'm in the wrong job. regards, Mike -Original Message- Sent: 29 August 2003 16:34 To: Multiple recipients of list ORACLE-L This

RE: RE: How can I measure my DB performance.

Well, unlike BogoMips, which is just kind a mostly meaningless number the kernel generates on boot, a TPC benchmark is a measurement of the performance of a specific database on a specific platform - not the measure of your database. The database is provided to you, and you're very limited as to

RE: ODP.NET and LONG RAW

yes. Tried that too. Get the same error. And I'm using Oracle's data provider for .NET. Kevin -Original Message- Sent: Friday, August 29, 2003 12:49 PM To: Multiple recipients of list ORACLE-L I haven't had a chance to work with this senerio much but it seems to look like it would

RE: Friday at the coding face...

Hmmm, I only managed 9/10. Pete -Original Message- Sent: 29 August 2003 18:19 To: Multiple recipients of list ORACLE-L My score : 10/10 Your liver is safe =) What worries me most is that I named the majority of the serial killers but didn't recognise any coders. Maybe I'm in the

Can't fire up 2nd ORACM of 2-node Linux RAC

Hey all, We're testing the useability of 9iRAC. Our test hardware is a 2-node Intel RedHat9 cluster (AS2.1 won't recognize our hardware) with OCFS on a shared SCSI drive, setup using the How to Build a $1000 RAC from www.bradmark.com Following the Step-By-Step Installation of 9.2.0.4 RAC on

RE: How to keep root out?

Title: Message Nope. It's against the law of evolution. SA has to work hardevolve to become a DBA. The regular, unevolved specimens of systemadministraticusvulgaris would be bored to death on this list. It's about the survival of the fittest, remember? --Mladen GogalaOracle DBA

RE: How can I measure my DB performance.

You can also use speed the acceleration as a criteria. A good database should accelerate with the acceleration of 30ft/sec square (= 9.81 m/sec square for ISO types) but only once. On the other hand, one might say that if users aren't complaining, the speed is adequate. -- Mladen Gogala Oracle

RE: The Coming Job Boom

Title: RE: The Coming Job Boom That's nice but what if the companies outsource overseas in response to this concern - hmmm. Still on the up-side they won't be able to do this in all cases and so overall there will likely be a positive demand for DBA skills in relation to the ageing of our

RE: Can't fire up 2nd ORACM of 2-node Linux RAC

by any chance do you have an Oracle 7, or 8 instance (or even listener) running on that second machine? I think I've seen something similar to this when we had the wrong libraries linked to the database on one of the nodes. Nick -Original Message- Sent: Friday, August 29, 2003

RE: How can I measure my DB performance.

Mladen Gogala scribbled on the wall in glitter crayon: On the other hand, one might say that if users aren't complaining, the speed is adequate. one might say if they do complain, gee works fine for me, sorry but if i can't reproduce the problem i can't fix it.;-) -- Bill Shrek Thater

RE: Congratulations Arup (DBA of the Year)

related the method of milking a nanny goat who has mastitis (yes, carefully and gently for starters, watch the horns...) :-) Is this going to be a session at Hotsos or OracleWorld? ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL

RE: The Coming Job Boom

Title: Message Paula, does that mean that the DBA of the future will have to learn how to perform CPA and do a therapeutic massage? I have problems with surgery, except if done on damagement. We'll have to speak louder and be more tolerant to old people in their monstrous Cadillacs,

RE: The Coming Job Boom

Picked up the text of the article on another listserv... This appears in the latest edition of Business 2.0: (its subscription, so Ive included the entire article inline rather than a link): The Coming Job Boom Forget those grim unemployment numbers. Demographic forces are about to put a

Re: SQL Loader help

Rachel, I do not claim to be a guru, but I do happen to have Jonathan's book here. The first thing is what field type are you using for this memo field? The book says you should use CHAR for VARCHAR2, CHAR, LONG and other related. What error are you getting? Can you post the lines from the

RE: The Coming Job Boom

Title: Message CPR, not CPA. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Friday, August 29, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: The Coming Job Boom

RE: The Coming Job Boom

Title: Message Yeah, I really was on a tangent. Actually I was thinking of making a move in my career to something related to the healthcare industry. I mean analysis is analysis, diagnostics is diagnostics. With a few manuals and a certification exam I think I could be just as good as if

RE: The Coming Job Boom

I subscribe to theories of Arthur Dent and Ford Prefect: Don't Panic and always have a towel. -- Mladen Gogala Oracle DBA -Original Message- Jesse, Rich Sent: Friday, August 29, 2003 12:15 PM To: Multiple recipients of list ORACLE-L Sounds similar to the economic theories of Harry

RE: Can't fire up 2nd ORACM of 2-node Linux RAC

Nope. These are fresh installs dedicated to nothing except proving RAC. I'd like to open a TAR on this, but running RH9 won't get us very far. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA

OKINIT

I'm getting the following response back from okinit. okinit: Password incorrect okinit: Decrypt integrity check failed. The password is correct. Has anybody seen this? I have some indication, a paper from U. of Mich. that this is due to corruption of the keytab file. But kinit continues to

RE: The Coming Job Boom

Title: Message Oh it's okay... Paula lives in Florida... she has to be more tolerant of "old people in their monstrous Cadillacs, driving 40 mph inthe passing lane"... and snowbirds and bad humor... =) I was wondering how one performed CPA though... April Wells Oracle DBA/Oracle Apps

RE: How can I measure my DB performance.

Title: RE: How can I measure my DB performance. I thought that would be for a bad database. Of course you need to throw the server out of a 20th floor window or higher to hit terminal velocity. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145

RE: The Coming Job Boom

Title: Message How do you take a systemdump, level 10 of an 80 years old person? Restart would be nice, something like alter joe.schmoe set age=20; Isn't that exactly what the guy named Ponce de Leon was looking for in FL? Self check. I was about tostart about voting practices in FL, first

  1   2   >