Re: oracle full table scan

2003-04-04 Thread Igor Neyman
the web if anyone wants them. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/03/2003 11:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan If you can change

Re: oracle full table scan

2003-04-04 Thread Jared . Still
PROTECTED] cc: Subject:Re: oracle full table scan Would you please? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 3:28 PM Sorry, the attachments didn't make

Re: oracle full table scan

2003-04-03 Thread Peter . McLarty
: Subject:oracle full table scan Dear All, is there any way to find which tables (table name) are suffering from full table scan ,so that i can create indexes on them to enhance the performance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: oracle full table scan

2003-04-03 Thread Richard Foote
Hi Arvind, A little test for you. You have a table that contains 10,000,000 rows that is packed tightly into 1,000,000 data blocks. You have an index that has a level of 4 and has 10,000 leaf blocks. The table is well striped across a number of devices and you have 4 CPUs on the box. You

RE: oracle full table scan

2003-04-03 Thread Jamadagni, Rajendra
Title: RE: oracle full table scan To answer the original question ... 1. use following query to see which tables are part of FTS ... it is a point in time information. (Query from www.ixora.com I think). SELECT usr.name oowner, ob.name oname FROM ( SELECT obj FROM sys.X_$BH WHERE

Re: oracle full table scan

2003-04-03 Thread Joan Hsieh
Hi Arvind, I don't judge full table scan is good or not necessary bad. this is the script might answer your question. -joan The following scripts provide information on the full table scan activity. If your application is OLTP only, having long full table scans can be an indicator of having

Re: oracle full table scan

2003-04-03 Thread Alex Andriyashchenko
Hello Arvind, Thursday, April 3, 2003, 5:58:38 AM, you wrote: AK Dear All, AK is there any way to find which tables (table name) are suffering from AK full table scan ,so that i can create indexes on them to enhance the AK performance. AK Thanks AK Arvind AK -- AK Please see the

RE: oracle full table scan

2003-04-03 Thread Gogala, Mladen
Tables are not suffering, they're rather cruel and coldhearted. As in the Tom Godwin's story, The Cold Equations, it's always the users who pay the price. You might try with tuning the SQL statements that access tables. Occasionally, that does the trick. -Original Message- Sent:

RE: oracle full table scan

2003-04-03 Thread DENNIS WILLIAMS
Arvind - If you want to locate tables that are being scanned and the SQL statement, I have found the following script posted by Mohammed to work quite effectively. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] REM From: Mohammed Shakir [mailto:[EMAIL PROTECTED] REM

RE: oracle full table scan

2003-04-03 Thread Jared . Still
Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan To answer the original question ... 1. use following query to see which tables are part of FTS ... it is a point in time information

RE: oracle full table scan

2003-04-03 Thread Jamadagni, Rajendra
Title: RE: oracle full table scan Thanks Jared, What if my developer is selecting all or most of the records from the table and not all the columns in the select list are in the index that should have been used? I understand your point, in fact to use Jonathan's words .. should a small

RE: oracle full table scan

2003-04-03 Thread Jared . Still
PROTECTED] cc: Subject:RE: oracle full table scan Tables are not suffering, they're rather cruel and coldhearted. As in the Tom Godwin's story, The Cold Equations, it's always the users who pay the price. You might try with tuning the SQL statements that access tables

RE: oracle full table scan

2003-04-03 Thread Gogala, Mladen
PROTECTED] Sent by: [EMAIL PROTECTED] 04/03/2003 07:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan Tables are not suffering, they're rather cruel and coldhearted

Re: oracle full table scan

2003-04-03 Thread Stephane Faroult
Jamadagni, Rajendra wrote: PS: Stephane, you probably have this on the top of your Oracle Myth list ... right? YMMV Raj Indeed, together with 'always replace NOT IN with NOT EXISTS ...' - another case today ... -- Regards, Stephane Faroult Oriole Software -- Please see the official

RE: oracle full table scan

2003-04-03 Thread Rachel Carmichael
AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan Tables are not suffering, they're rather cruel and coldhearted. As in the Tom Godwin's story, The Cold Equations, it's

RE: oracle full table scan

2003-04-03 Thread Jared . Still
] 04/03/2003 10:05 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan Thanks Jared, What if my developer is selecting all or most of the records from the table and not all

RE: oracle full table scan

2003-04-03 Thread Jared . Still
[EMAIL PROTECTED] cc: Subject:RE: oracle full table scan If you can change it to an IOT, it may be beneficial. There's no blanket clause to be used that says 'Always do this'. I higly encourage folks on this list to setup and use the run_stats method of comparing different

RE: oracle full table scan

2003-04-03 Thread Rachel Carmichael
to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: oracle full table scan If you can change it to an IOT, it may be beneficial. There's no blanket clause to be used that says 'Always do this'. I higly

RE: oracle full table scan

2003-04-03 Thread Ron Thomas
] Sent by: cc: [EMAIL PROTECTED] Subject: RE: oracle full table scan

RE: oracle full table scan

2003-04-03 Thread Rachel Carmichael
by: cc: [EMAIL PROTECTED] Subject: RE: oracle full table scan

oracle full table scan

2003-04-02 Thread Arvind Kumar
Dear All, is there any way to find which tables (table name) are suffering from full table scan ,so that i can create indexes on them to enhance the performance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL

Re: oracle full table scan

2003-04-02 Thread Mark Richard
] rintl.comcc: Sent by: Subject: oracle full table scan [EMAIL PROTECTED

RE: oracle full table scan

2003-04-02 Thread Stephane Faroult
Dear All, is there any way to find which tables (table name) are suffering from full table scan ,so that i can create indexes on them to enhance the performance. Thanks Arvind A time for indexed access; and a time for full scans. A time for nested loops; a time for hash joins.