demo01.sql

Expert Oracle Database Architecture 9i and 10g sql源码

select count(status) from big_table;
explain plan for
select count(status) from big_table;
select * from table(dbms_xplan.display);
alter table big_table parallel 4;
alter table big_table parallel;
explain plan for
select count(status) from big_table;
select * from table(dbms_xplan.display);
host  ps -auxww | grep '^ora10gr1.*ora_p00._ora10g'
select count(status) from big_table;
host  ps -auxww | grep '^ora10gr1.*ora_p00._ora10g'
select sid from v$mystat where rownum = 1;
select sid, qcsid, server#, degree
from v$px_session
where qcsid = 162
/
select sid, username, program
from v$session
where sid in ( select sid
                 from v$px_session
                where qcsid = 162 )
/