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
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
:
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
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
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
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
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
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:
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
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
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
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
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
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
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
]
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
[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
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
]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: oracle full table scan
by: cc:
[EMAIL PROTECTED] Subject: RE: 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
--
Author: Arvind Kumar
INET: [EMAIL
]
rintl.comcc:
Sent by: Subject: oracle full table scan
[EMAIL PROTECTED
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.
23 matches
Mail list logo