Hi,
You should not compare tkprof outputs with V$SQL,V$SQLAREA. Because,
recursive/child statistics are included in their parent statements in these
views. But, tkprof substructs recursive statistics. I mean tkprof reports real
values for statements, but dictionary doesn't.
regards...
Orr,
Here's the scene:
1) I have a 400,000 row table table which is cached.
2) I have a query against that table and no other with one column referenced
in the WHERE clause. (This column is indexed and of course I don't really
need the index since the table is cached but it's there so ho hum...)
3)
What is the degree of parallelism on this table?
Waleed
-Original Message-
Sent: Monday, July 01, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Here's the scene:
1) I have a 400,000 row table table which is cached.
2) I have a query against that table and no other with one
What version of Oracle?
1) I have a 400,000 row table table which is cached.
How has the table been cached? Alter table XXX cache? Or with a KEEP
buffer?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network
Orr, Steve wrote:
Here's the scene:
1) I have a 400,000 row table table which is cached.
2) I have a query against that table and no other with one column referenced
in the WHERE clause. (This column is indexed and of course I don't really
need the index since the table is cached but
The degree is 4 and it is cached via alter table, not the KEEP buffer. On
Oracle 8.1.7.2 on Linux RedHat 7.2
Thanks for clues...
-Original Message-
Sent: Monday, July 01, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
What is the degree of parallelism on this table?
Waleed
Steve,
Query V$SESSION_EVENT for the SID of that session. If you see the
wait-event db file scattered read change during the query, then it truly
is doing I/O, like it or not. It is more likely that the CACHE attribute is
not working as you've apparently assumed it does, rather than there