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

') 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 -- Author: Babu Nagarajan INET

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

Re: Large Export Problem ......

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 Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Passing DB-Link name in a Loop

: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Re: Force to use a tablespace

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 Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Veritas Quick I/O for Oracle

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 Network Services-- 858-538-5051 http://www.fatcity.com San

Re: File Restoration/Recovery

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 list and web

Re: Oracle Tools

Checkout Oracle Lite Babu Sultan

Re: FW: oracle version

did u try the inventory logs ? Babu kommareddy

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: Statistics on SYS?

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

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

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 it

Re: trace (get) sql script

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

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: 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: 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

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

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

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: DBMS_STATS

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

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 number

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

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

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

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

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

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

Re: SQLplus question unusual behavior

Just a thought - is facility a table or is it some synonym/view pointing somewhere else.. Babu |-+--- | | John Shaw | | | John.Shaw@correctio| | | nscorp.com | | |

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

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: 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: 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: Full table scan error

. Please immediately contact the sender if you have received this message in error. Thank you. -- 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

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: 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.. Checkyr max_open_cursor limit

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,

Re: Shared Pool Size

ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Function-based Index

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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

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

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: limiting temp space per user

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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Utl_file and OPENVMS

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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Strange performance problem

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 http://www.fatcity.com San Diego, California-- Mailing

Re: Strange performance problem

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 http://www.fatcity.com San Diego, California-- Mailing

Re: Strange performance problem

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 http://www.fatcity.com San Diego, California-- Mailing

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

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 misassumptions I had made. I have corrected most of the stuff you had mentioned except for these .* I'm less clear on whether

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

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

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

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 ORADEBUG

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

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

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 own

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 seen

oratab file

All On one of the database servers we have, the oratab file has been changed to include a :parameter 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

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 thatcontains the list of all events? TIA Babu

Re: list of events

that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Babu Nagarajan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Subject: list of events

Re: Correcting user sql inside the database

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) 538-5051 San Diego, California

Re: Renaming files on Unix via PL/SQL

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) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: PX Deq: Table Q qref

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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

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 and

Re: PX Deq: Table Q qref

are considered idle. The PQ slave processes arewaiting 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 qref

Re: PX Deq: Table Q qref

://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: Strange problem deleting rows

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: [EMAIL PROTECTED] Fat City Network

Re: not using indexes

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) 538-5051 San Diego, California

Re: Shared pool wait for library cache pin

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) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Moving Oracle software

). -- 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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: insert privilege across db link

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 the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu

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

') 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.com -- Author: Babu Nagarajan INET

Re: insert privilege across db link

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) 538-5051

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