Oracle view parallel SQL statement number of concurrent

1. Execute sql:select/*+ Parallel (a,4) * * from Tf_f_user a where rownum<100000;

2. How to view the parallel number of the SQL statement:

Select T.sql_text,t.sql_id,s.sid from V$sql t,v$session s where t.sql_id=s.sql_id and t.sql_text like '%rownum<100000% ‘;

Executing the above SQL statement found to be 4 articles.

3, if the execution sql:select/*+ parallel (a,4) * * from Tf_f_user a where rownum<100000;

To view the parallel number of SQL statements:

Select T.sql_text,t.sql_id,s.sid from V$sql t,v$session s where t.sql_id=s.sql_id and t.sql_text like '%rownum<100000% ‘;

Execute the above SQL statement to find that the parallel number becomes: 40, so default parallelism is 40

Oracle view parallel SQL statement number of concurrent