Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable parallel query for specified table?

656310Oct 1 2009 — edited Oct 5 2009

Hallo everybody,
does anybody know, if it's possible to disable parallel query execution for specified table?

DB version Oracle 10g - 10.2.0.4.0
DB type: Datawarehouse

I know how to disable parallel queries for whole database (using parallel_max_servers=0).

Table has 0 degree of paralellism and I would like to achive to not use parallel query, even in case if somebody use --+ parallel hint in SELECT query.

Maybe it's possible via some table trigger?

Thanks for ideas.
Filip

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2009

Added on Oct 1 2009

#general-database-discussions

4 comments

10,307 views