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:

http://asktom.oracle.com/pls/ask

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

try www.orafaq.org this is not really an Oracle forum and I haven't played DBA for years.

Has the table been analysed lately ???