see DBA_HIST_SQLSTAT and DBA_HIST_ACTIVE_SESS_HISTORY
http://orastory.wordpress.com/2012/06/19/flippin-witch-hunt-adaptive-direct-path-read/
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum 6 ore
Niciun comentariu:
Trimiteți un comentariu