ORACLE, Performances, PL/SQL, SQL, TUNING
ORA-01031: insufficient privilegesORA-06512: at "SYS.DBMS_SESSION", line 276ORA-06512: at line 3,
begin
dbms_session.session_trace_enable();end;
grant CONNECT_9I from YourOracleUser ;
.bmp)
DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session history of recent system activity. This view contains snapshots of V$ACTIVE_SESSION_HISTORY. See "V$ACTIVE_SESSION_HISTORY" for further interpretation details for many of these columns (except SNAP_ID,DBID, and INSTANCE_NUMBER).DBA_HIST_BASELINE displays information on baselines taken in the system. For each baseline, this view displays the complete time range and whether the baseline is the default baseline.DBA_HIST_BG_EVENT_SUMMARY displays the historical summary background event activity. This view contains snapshots from V$SESSION_EVENT.DBA_HIST_DB_CACHE_ADVICE displays historical predictions of the number of physical reads for the cache size corresponding to each row. This view contains snapshots of V$DB_CACHE_ADVICE.