Database Tuning (MOSC)

MOSC Banner

capture report no data(database replay)

edited Dec 10, 2013 6:19AM in Database Tuning (MOSC) 2 commentsAnswered
-- set filter user : silence

begin
dbms_workload_capture.ADD_FILTER(fname =>'FILTER_TEST',fattribute =>'USER',fvalue =>'SILENCE');
end;
/

-- create 'CAP' directory

-- startup capture

exec dbms_workload_capture.start_capture('sample_cap_name', 'CAP', NULL, 'INCLUDE');

-- check capture
select dbms_workload_capture.report(71, 'TEXT') from dual;

but no data abort workload captured, why not gather workload info ?

For Example:


Database Capture Report For TEST

DB Name         DB Id    Release     RAC Capture Name               Status    
------------ ----------- ----------- --- -------------------------- ----------
TEST          2128451948 11.2.0.3.0  NO  sample_cap_name            COMPLETED 


                   Start time: 05-Nov-13 09:30:52 (SCN = 1273166)
                     End time: 05-Nov-13 09:32:33 (SCN = 1278969)
                     Duration: 1 minute 41 seconds
                 Capture size: 2.44 KB

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