Re: Not able to add DB which is ruuning on the local node

so send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing l

Re: events number and meaning

you can find the list of events under $ORACLE_HOME/rdbms/mesg/oraus.msg.   babu - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 26, 2003 7:08 AM Subject: FW: events number and meaning   -Origi

Re: Large Export Problem ......

www.orafaq.net > -- > Author: Darrell Landrum > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ------

Re: Passing DB-Link name in a Loop

to be removed from). You may > > also send the HELP command for other information (like > > subscribing). > > > > > > Hemant K Chitale > http://hkchital.tripod.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Heman

Re: Force to use a tablespace

SUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Ne

Re: File Restoration/Recovery

ROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see

Re: Veritas Quick I/O for Oracle

x27;) and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: How to improve queries remotely

Limit the data you get across the network... Take the query that gets sent across the db link (u can get it from the explain plan or oem sql analyze) and runit on the remote db and check its access path Thanks a lot... Babu

Re: FW: oracle version

did u try the inventory logs ? Babu kommareddy

Re: Oracle Tools

Checkout Oracle Lite Babu Sultan

Performance issues on Sun - solved

Thanks to Cary, Jared, Ferenc whose inputs helped a lot in solving the problem. Ferenc's document did the trick... Once we converted the files to use Qio, the performance was much much better... Thanks a lot... Babu _ This e-mail transmission and any attachments to it are intended s

Re: Statistics on SYS?

I think you are not supposed to collect statistics on sys tables till 9i... Babu Chuck Hamilton

Re: Partitioning

what do you mean by storage size? if you mean the initial, next and so on - yes you can. if you are talking about how big it should be - i dont think you can do it... Babu

Re: performance issues on sun

Ferenc Thanks for the document. I am working with the SAs to try to implement it. Will update the results once complete.. Thanks a lot... Babu

Re: OEM - Automation of Start of Collection for Performance Reports

I have seen some folks record the performance data and then play it back in OEM. I think it is there in the performance manager add in. Is that what you want? How different you expect this to be from STATSPACK? Babu

Re: trace (get) sql script

Run STATSPACK at Level 5 (default). It will capture most of the offending SQL Statements Babu [EMAIL PROTECTED]

RE: performance issues on sun

My bad. I should also have posted the 10046 trace. I did a 10046 trace and also a STATSPACK report. Of the total time, more than 50% of the time is spent waiting on "DIRECT PATH WRITE" and around 40% of the time it waits on "DIRECT PATH READ". This is what prompted me to do a truss and see what i

Re: DBMS_STATS

I think since DBMS_STATS also gathers histograms its taking more time Babu Tim Gorman

RE: performance issues on sun

I did this and its taking the same amount of time. The difference this time is that it does not do the KAIO call. But the time has not improved. Its still doing pwrite calls. TIA Babu

RE: performance issues on sun

- Where is the tablespace of the table? Shared disk with temp or index tablespace? Its on a different mountpoint (and disk) from the index or the temp tablespaces - Check your SORT_AREA_SIZE on both systems. Its 1 Mb. I have done the tests with as much as 250M but same results - Do so

performance issues on sun

All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take < 20 min on T64. I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES

Re: File Table Overflow on Oracle DB Server

Here is Kirti's reply to it (long time back in June). I think it was to you that time also... Babu Vivek, You are right, this is an OS related issue, but a DBA must be aware of why it happens ;) Error 23 means 'File Table Overflow' and it is generated when the system wide limit for the numb

RE: direct path read waits

Yes.. I did it multiple times... With same results though :-( Babu Henry Poras

RE: direct path read waits

We actually had lengthy discussions with our SAs and convinced them that we need different mountpoints on different disks. We have our SA's guarantee that no physical disk is used by the two mountpoints... Will try to get a "sar -d" output from them.. Babu

RE: direct path read waits

John All the tablespaces are on different disks - Sorry I should have mentioned this in the original post itself... Babu

direct path read waits

All We are doing some performance testing while moving from one server to another. I was trying to time some index rebuilds and noticed something that I cant explain. I am rebuilding an index on a 1 million row table. Lets say its on tablespace A and when I rebuild it to tablespace B it does in

Re: max block size on sun solaris

I forgot to mention that the Oracle version is 8.1.7.4 TIA Babu babu.nagarajan@Cu

max block size on sun solaris

Hi Is anyone running ORacle on Sun solaris with db_block_size > 16K? We are getting an error while creating a 32K block size database on Sun and Oracle says 16K is the max on Sun solaris.. Thanks a lot... Babu _ This e-mail transmission and any attachments to it are intended solely

HyperRoll Experience (http://www.hyperroll.com)

All Have any of you worked with this product that is supposed to improve the performance of a RDBMS or a OLAP database... Damagement heard about this product form somewhere and wants us to investigate... Any feedback is appreciated.. TIA Babu _ This e-mail transmission and any att

Re: SQLplus question unusual behavior

Just a thought - is facility a table or is it some synonym/view pointing somewhere else.. Babu |-+---> | | John Shaw | | || | | Sent by:| | | [EMAIL PROT

Re: Database tracking

A more comprehensive solution would be statspack. A simpler solution would be to get the sum of wait time (not counting the idle ones) . it could provide you with some measure of database performance... You need to arrive at a baseline wait time as being normal for your database and any deviati

Re: Cant install statspack !

I remember seing a script on Steve Adam's site that will delete the views created so that STATSPACK can install correctly Babu

Re: Cant install statspack !

I think the SQL_PATH is not pointing to $ORACLE_HOME/rdbms/admin - so its unable to find the scripts... Open a DOS window, cd to the folder and try running using "sqlplus" and not "sqlplusw".. Or edit the SQL_PATH in yr registry.. Or edit the STATSCRE.SQL to include the full path Babu

Re: email out of oracle

$> oerr ora 29540 29540, 0, "class %s does not exist" // *Cause: Java method execution failed to find a class with the indicated name. // *Action: Correct the name or add the missing Java class. Looks like you are missing some Java Class... Do you actually get the email it sends? Also if you

RE: Prevent FTS

Read Tim Gorman's The Search For Intelligent Life in the Cost-Based Optimizer. I think its on his website - http://www.evdbt.com/papers.htm Babu

Re: Centralized StatsPack Repository

Title: RE: Centralized StatsPack Repository Raj   I did this sometime back but later on somehow this went on to the backburner.. (I also had half-developed XL based interface to the central statspack data)   In the central repository create the set of tables that statspack uses to store data

Re: Full table scan error

able access > error on Historie table? Any help in this regard is very much appreciated. > > Thanks and Regards, > > Ranganath > > <> > > > WARNING: The information in this message is confidential and may be legally > privileged. It is intended solely for the add

Re: ORA-1410 Silliness

Title: ORA-1410 Silliness Lisa   I dont recollect exactly but I think I have seen this happen when you start getting too close to the max_open_cursor limit... something like Oracle cant open a cursor as it is at the max limit and a fetch call might be issued..   Check yr max_open_cursor limi

Re: Oracle 8i (8.1.7) for Windows XP Home Edition

Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition i was able to install 8.1.5 sometime back.. but it made my xp terribly slow.. some jdk issues, i guess..   babu - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, D

Re: Shared Pool Size

> To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing lis

Re: Common PL/SQL package to truncate tables

Title: Common PL/SQL package to truncate tables Of the top of my head, there is a way where you can run a procedure under the invoker's rights rather than the procedure owner's rights. if u create it that way, you need not bother checking if the user who is calling the procedure has the right

Re: Function-based Index

'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://ww

Re: limiting temp space per user

> > Sent: Monday, December 09, 2002 06:24 AM > > > > > > > All > > > > > > Is it possible to limit the temp space used per user - either by using > > > profiles or some other method? I tried using profiles but it would not > > allow &g

limiting temp space per user

All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET

Re: Utl_file and OPENVMS

nd web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L

Re: Strange performance problem

ng list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other info

Re: Strange performance problem

ng list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other info

Re: Strange performance problem

ng list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other info

Re: To_Char Problem

Why would you want to do that - convert two dates into a char and then compare them ? This is not a problem but it is how char comparisions work. They are compared char by char to see which one is greater on the ASCII chart. See this : SQL > select '1' from dual where '3' > '10'; ' - 1 Babu

Re: SAN

But inside a Oracle datafile a table may not lie in contigious blocks. so I you are doing a full table scan 2 extents can lie next to each other than then the remaining 2 can sit at the end of the datafile. Will the non-Oracle process be able to decipher this and do a read ahead of those two exte

Re: SAN

Tim, Jared and Kirti Jared, Kirti : Thanks a lot for your input. and yes, I read the Sane SAN paper. Tim : Many thanks to you for pointing out some of the big "mis"assumptions I had made. I have corrected most of the stuff you had mentioned except for these >.* I'm less clear on whether S

SAN

All I have a meeting tomorrow where I am going to point out why SAN and Oracle does not go very well together. Here are my thoughts. Can you pick holes in this argument, modify it or suggest any changes TIA Babu SAN and Oracle ? Conflicting IO behavior * There are four types of IO in O

Re: set sql*trace VB/Crystal

Try to find out the sid and serial# of her session. >From a dba user use "exec dbms_system.set_sql_trace_in_session(sid, serial#,true); Babu "Baker, Barbara" <[EMAIL PROTECTED]>@fatcity.com on 08/12/2002 03:23:23 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:

SAN issues

All I an trying to get our management understand the issues related to SAN. These are my thoughts. Let me know what you think about it... (PS : Apologies if you recv this twice. I posted it but I never saw it come through the list and so I posted again) Babu SAN Issues SAN and Oracle ? Confl

RE: Which table to check whether my SQL_TRACE is on for the user

It should be run from svrmgr Babu "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>@fatcity.com on 08/09/2002 10:53:19 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: user Hi KG, Is "OR

RE: Oracle Heterogenous Services

I think I am jumping into this thread a bit late. Take a look at http://www.unixodbc.com for some good info on ODBC on Unix. I am not sure where to get Oracle ODC drivers for Unix. Try installing a Unix client and see if it comes along with it... Babu Robertson Lee - lerobe <[EMAIL PROTECTE

Re: Host System Commands from PL/SQL blocks

Take a look at Doc Id 50868.1 on metalink Babu John Weatherman <[EMAIL PROTECTED]>@fatcity.com on 07/30/2002 02:56:37 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: OK, I checked Google and my ow

Re: Space Contention and LOG_BUFFER size

More than the number of time you are waiting for 'redo log space requests' its more important to find out how long you are waiting for that. 27 times out of a million might not be a big deal for you to tune. having said that, here is a posting by Steve Adams on this topic "Q : Every day our pro

Re: order by in subquery workaround

For databases < 8i you need to run statsrep80.sql Babu Jack van Zanen <[EMAIL PROTECTED]>@fatcity.com on 07/12/2002 02:53:21 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Hi I have in the past

oratab file

All   On one of the database servers we have, the oratab file has been changed to include a : after each entry and that parameter is used to determine whether the database is supposed to be shutdown at a certain time.   It kind of struck me as a odd way to do this... This created problems

Re: list of events

t; > > Rajendra Jamadagni MIS, ESPN Inc. > > > Rajendra dot Jamadagni at ESPN dot com > > > Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. > > > QOTD: Any clod can have facts, but having an opinion is an art! > > &

Re: list of events

---| > > > > $ORACLE_HOME/rdbms/admin/mesg/oraus.msg > > > > Raj > > __ > > > > Rajendra Jamadagni MIS, ESPN Inc. > > > > Rajendra

list of events

All   I know this has been mentioned on this list before but I forget...   Which is the script in $ORACLE_HOME/rdbms/admin folder that contains the list of all events?   TIA   Babu

Re: Correcting user sql inside the database

City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PRO

Re: Renaming files on Unix via PL/SQL

] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message &g

Re: PX Deq: Table Q qref

ling Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L &g

Re: PX Deq: Table Q qref

7;) and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: htt

Re: PX Deq: Table Q qref

are considered idle. The PQ slave processes are waiting for work to do.   - Kirti  -Original Message-From: Babu Nagarajan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 10, 2002 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: PX Deq: Table Q

PX Deq: Table Q qref

All   What does this wait event mean? I have a process that connects to the database through ODBC and this process is waiting on this event and SQL*Net message from client.   Often this process waits for an unreasonable amout of time (4 seconds or more) on SQL*Net MEssage from client an

Re: Strange problem deleting rows

-- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may >

Re: Why "metastink" {or "fetidstink" !} ??

--- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the

Re: not using indexes

istGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.ora

Re: insert privilege across db link

; to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). &

Re: root.sh wasn't run, help!

e BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET:

Re: insert privilege across db link

list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Moving Oracle software

> the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nag

Re: Shared pool wait for library cache pin

> > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name

Re: METABLINK on the Fritz?

Title: METABLINK on the Fritz? u are not alone... i've been trying since about 3:00 pm est... its crawling.. - Original Message - From: Mohan, Ross To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 30, 2001 4:06 PM Subject: METABLINK on the Fritz?