wait events not as v$sql_plan
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Mar 2005 16:37:29 +0000
I have got a Plan as below
-----------------------------------------------------------------
| Operation | Name |
-----------------------------------------------------------------
| SELECT STATEMENT | |
| SORT UNIQUE | |
| NESTED LOOPS | |
| NESTED LOOPS | |
| NESTED LOOPS | |
| NESTED LOOPS | |
| HASH JOIN | |
| TABLE ACCESS FULL | KDD_BREAK_BINDING |
| PARTITION RANGE ALL | |
| TABLE ACCESS FULL | FIRM_ACCT_POSN |
| TABLE ACCESS BY INDEX ROWID | KDD_BREAK |
| INDEX UNIQUE SCAN | PK_KDD_BREAK |
| TABLE ACCESS BY INDEX ROWID | KDD_BREAK_BINDING |
| INDEX UNIQUE SCAN | PK_BREAK_BINDING |
| INDEX RANGE SCAN | PK_KDD_BREAK_MTCHS |
| VIEW | TRADE_EXCTN_DTLS_VW |
| UNION-ALL PARTITION | |
| TABLE ACCESS BY GLOBAL INDEX ROWID| TRADE |
| INDEX UNIQUE SCAN | PK_TRADE |
| TABLE ACCESS BY GLOBAL INDEX ROWID| EXECUTION |
| INDEX UNIQUE SCAN | PK_EXECUTION |
According to the plan the Trade table is being Scanned using an Index.
But the Wait events show a DB file scattered read on the Trade Table
which indicates a Full Table scan.
These are also Paralel processes Trampling on Each Other i.e. i have
Got p001 trying to read the same block as P002 and P001 waiting on
Buffer Busy waits.
Any help is greatly appreciated.
Rgds,
Ganesh
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: wait events not as v$sql_plan
- From: Igor Neyman
- Re: wait events not as v$sql_plan
- From: K Gopalakrishnan
Other related posts:
- » wait events not as v$sql_plan
- » RE: wait events not as v$sql_plan
- » Re: wait events not as v$sql_plan
- » Re: wait events not as v$sql_plan
- RE: wait events not as v$sql_plan
- From: Igor Neyman
- Re: wait events not as v$sql_plan
- From: K Gopalakrishnan