Checking parallel query execution in Oracle

To check the parameters configuration in the init.ora parameter file: SQL> show parameter parallel To check for tables and indexes created with the parallel option: FOR TABLES: select owner,table_name,degree,instances from dba_tables where (trim (degree)not in ( ’1′,’0′) or trim(instances) not in ( ’1′,’0′) ) and owner not in (‘SYSTEM’,’SYS’,’OUTLN’,’DBSNMP’,’OPS$ORACLE’) / FOR INDEXES: select owner,index_name,degree,instances from […]