Database Administration (MOSC)

MOSC Banner

Why ASH has no new data?

edited Jun 13, 2011 2:03PM in Database Administration (MOSC) 5 commentsAnswered
   I want to produce ASH report,but ASH has no new data.

SQL> select min(sample_time),max(sample_time) from V$ACTIVE_SESSION_HISTORY;

MIN(SAMPLE_TIME)                MAX(SAMPLE_TIME)
------------------------------ ------------------------------
25-MAR-11 01.02.28.447 AM        25-MAR-11 09.30.12.103 AM

the ASH parameter set as follow:

_ash_sampling_interval     1000
_ash_size                  1048618
_ash_enable                TRUE
_ash_disk_write_enable  TRUE
_ash_disk_filter_ratio  10
_ash_eflush_trigger   66
_ash_sample_all    FALSE
_ash_dummy_test_param  0

 

who can tell me what is the matter.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center