OraFAQ Forum: SQL & PL/SQL » Parallel Query Option

Home » SQL & PL/SQL » SQL & PL/SQL » Parallel Query Option

Tue, 20 August 2002 07:39

Akash
Messages: 4
Registered: August 2002

Junior Member

Hi ,

How can I get a list of all tables in my database which have the Parallel option turned on.

Thanks,
A

Tue, 20 August 2002 09:04

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select table_name, degree
  from dba_tables
 where degree > 1;

Previous Topic:	Using MAX() on a VARCHAR2 Column
Next Topic:	DML Statement in Function !

Goto Forum:

]

Current Time: Tue Apr 23 04:40:46 CDT 2024