Sorry,
This is out of scope of this group.But I require the clarification pretty urgently.
My Oracle database is parallely enabled.
Still,in a particular table queries do not work "parallely" always.
How is this?
since i don't do oracle --- i suggest you check here to see if it helps or Google it for more info if nobody gets back to you with the correct answer
Do you know about the /*+ parallel */ hint?
If you want to see what the query is doing, try EXPLAIN PLAN or use tkprof on a session with ALTER SESSION SET SQLTRACE TRUE;
For small tables joined against larger tables, parallel may not be part of the the possible optimizer choices.
Read Tom Kite's: 'Expert One on One ORACLE' or visit his website:
Thanks Folks for your suggestions,
The trouble is the same table is running parallely when partitioned on a key.
It does not when run as a whole table
Has the table been analysed lately ???
Tried Analysing,session is getting expired as the table size is around 200 million
what analye command are you using ??? If you have a version of Oracle 8.1.7 or above - you don't need to analyse the entire table - 10% to 15% is enough to give the optimiser stats to do the job.
I am using 9.2
How to determine the statistics using 10-15% of the table contents
Ok 9.2 that's good - I would suggest using DBMS_STATS - I'm not a DBA - have a chat with them.