Archive

Archive for June, 2014

view dbms profiler

view dbms_profiler data:
select * from plsql_profiler_runs order by run_date desc;
select * from plsql_profiler_data order by total_time desc;

Cleanup dbms_profiler data:
delete from plsql_profiler_data;

delete from PLSQL_PROFILER_UNITS;
delete from plsql_profiler_runs;

Advertisements
Categories: Uncategorized

Partition an Existing table in Oracle

Alter Session Force Parallel Dml Parallel 32;
alter session force parallel query parallel 32;

Categories: Uncategorized