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

2002-08-10 Thread Babu . Nagarajan
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: Bitmap Header in a Uniform LMT?

2002-08-10 Thread Deshpande, Kirti
Rajesh, I did visit the link you mentioned. Nice and concise information on LMT (and other things as well). Thanks for posting the link. - Kirti -Original Message- Sent: Friday, August 09, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Getting no responses on this, I

FW: URGENT BITMAP MERGE NOT WORKING

2002-08-10 Thread Paula_Stankus
Okay, Again concate. bitmap local prefix index = 9 secs. and I can't get CBO to use bitmap merge even with index_combine hint - so explain plan shows just using by default index with part. key in it (year) and response time is a little over 1 minute. I wish to try bitmap merge - how can I

Encryption of data

2002-08-10 Thread Manavendra Gupta
What is the best way to encrypt data in Oracle (like username/passwords, etc)? Is there a provision to encrypt the entire table/tablespace ? Thanks, Manav. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network

Re: Physical Database Layout

2002-08-10 Thread Manavendra Gupta
Hi Naveen, Thanks for taking the time out to reply. Yes I agree most of the programmers do not bother even to optimize the queries they write, but things get a tad complicated when you are responsible for an enterprise application and you are concerned with each aspect of the system. I

RE: Unix Script Quest : Urgent

2002-08-10 Thread Brian_P_MacLean
Don't forget the lsof command (list open files). Just as invaluable as truss. Get it at http://www.sunfreeware.com/

Lock table table_name in exclusive mode - Performance gain?

2002-08-10 Thread Brian_P_MacLean
Anyone do any bench marking, know of any papers, or using lock table table_name in exclusive mode to get a performance boost. I'm trying to figure out how to do 90,000,000 operations (add/change/delete) on the same table/partitions in a 4 hour period, and it looks like lighting will have to

Re: OPTIMIZER_MODE recommendation for 9.2

2002-08-10 Thread Tim Gorman
Bug #564434, logged against 7.3.3, is not "visible" on MetaLink, but it displayed a lovely row between Oracle Support (advocating the customer logging a TAR) and Oracle Development (paraphrased here): Support: Setting ALL_ROWS or FIRST_ROWS forced the use of CBO, which performs poorly

RE: Bitmap Header in a Uniform LMT?

2002-08-10 Thread Paula_Stankus
Title: RE: Bitmap Header in a Uniform LMT? Please resend link? -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 10, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Bitmap Header in a Uniform LMT? Rajesh, I did visit

RE: Encryption of data

2002-08-10 Thread Amar Kumar Padhi
Title: RE: Encryption of data Try dbms_obfuscation_toolkit.It supports DES, DES3 and MD5 encryption formats. You can use these for storing encrypted information in tables. rgds amar http://amzone.netfirms.com -Original Message- From: Manavendra Gupta [mailto:[EMAIL PROTECTED]]