Re: Experiences with Automatic Undo Management

. -Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, January 27, 2003 8:49 AM Subject: RE: Experiences with Automatic Undo Management Dan, We are using AUM on ALL our PROD/DEVL/TEST environments

Re: Statspack Viewer

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: Shaleen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: NVL and index usage

Title: NVL and index usage In a quick test on 9013 it changed the index which it was using and went from Range scan to fast full scan. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, January 02, 2003 9:48 AM

Re: Extremely Slow Query

Title: Extremely Slow Query Doesnt seem to be a problem in my 9013 instance. returned 240 rows in 1.26 elapsed seconds - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, January 02, 2003 12:51 PM Subject:

db_files and file descriptors on solaris7

. Reducing db_files to 400 did not give this message. Interesting thing is that we increased file descriptors very recently from 64 to 1024. Does anyone have more information on this? Thanks Shaleen

Re: db_files and file descriptors on solaris7

the message is shown. Try a value for db_files, which is little below than ½ the OS limit . Thank you Giridhar - Original Message - From: Shaleen To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 31, 2002 11:40 AM Subject: db_files and file

Re: this doesn't look right

# and col.obj# = ac.obj#(+) and col.intcol# = ac.intcol#(+) -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 30, 2002 12:23 PM As part of the process of making sure that null/not null constraints are consistent across

Re: this doesn't look right

#(+) -Shaleen - Original Message - From: Rachel Carmichael [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 30, 2002 12:23 PM Subject: this doesn't look right As part of the process of making sure that null/not null constraints

Re: unable to create stored outline for sql inside a procedure --Resolved

here. Thanks Shaleen - Original Message - To: [EMAIL PROTECTED]; Shaleen [EMAIL PROTECTED] Sent: Wednesday, December 25, 2002 11:09 PM procedure --Resolved Shaleen, This is done to preserve security. User A owns a table MY_TABLE. Role A_STUFF allows insert, select, update, delete

Re: Cache on sysdate? --From 9i performance planning manual

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: Shaleen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: unable to create stored outline for sql inside a procedure --

Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 12:39 PM This may be more convincing: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=1031418.6 regards, Waleed

Re: unable to create stored outline for sql inside a procedure --

the procedure. This administration raises the complexity of this process to the nth degree and as such the decision was made to ignore roles. Thanks Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 12:39 PM

Re: Re:RE: Deadlock

except one which corresponds to a static master table containing PO TYPES. That table is not being updated. How can I dig deeper into this issue. Thanks Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 1:58 AM

unable to create stored outline for sql inside a procedure --Resolved

this limitation beats me!! Thanks for help Jared Raj. Shaleen

Re: Re:RE: Deadlock

. I am unable to understand why the update statements are requesting SSX lock on the table. This is not a case of primary/forign key issue with a missing index in child table where primary key is change in master table because master table is not being updated. Thanks Shaleen Deadlock graph

Re: Out of topic -Unx question

my unix sysadmin was kind enough to give me following few monts ago. Works great and can be used for creating any date in dd-mon-yy format DAY=`perl -e 'use POSIX qw(strftime); print strftime(%d-%b-%y, localtime(time() - 86400)) . \n ;'` HTH Shaleen - Original Message - To: Multiple

standby crashed while opening readonly ora-604

accessFri Dec 20 12:57:11 2002Error 604 happened during db open, shutting down databaseUSER: terminating instance due to error 604Instance terminated by USER, pid = 17612ORA-1092 signalled during: alter database open read only... Thanks Shaleen

Re: ora_sql_txt system defined event attribute

Title: RE: ora_sql_txt system defined event attribute couldn't find anything abt ora_sql_text on metalink. What is this? How do you capture ddl from ksdwrt? Thanks Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent

Re: Purging Managed Standby Database Archive Logs

procedure HTH Shaleen - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 12:38 AM Subject: Re: Purging Managed Standby Database Archive Logs Hello Steve If you

Re: sql with bind variable in stored procedure doesnt use

this by deleting the statistics for that particular table and I am never going to analyze that table again. Thanks Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 13, 2002 12:14 PM John, Shaleen mentioned to me, in a direct e-mail

Re: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],

This error happens when 8i jdbc driver is used to connect to 9i database. we reolved this by using 9i jdbc classes file. This error prevents the client from opening connection to database. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

Re: sql with bind variable in stored procedure doesnt use stored

John, Thanks for the input. As far as I can see that sql's are exactly same in my example. Morover none of the initialization parameters have been changed. Need input from all Gurus Thanks Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent