Database Tuning (MOSC)

MOSC Banner

"alter session set "_swrf_test_action" = 72" does not work on my DB, old AWR cannot be purged

edited Jul 8, 2015 10:04AM in Database Tuning (MOSC) 4 commentsAnswered

Hi DBAs,

I need some help here, I'm currently running with several Oracle 11.2.0.3/4 database on HP UNIX,and SYSAUX tablespace's size always grows, so I followed ID 387914.1 to split my AWR data into smaller partitions and to drop those partition out of date, however, "alter session set "_swrf_test_action" = 72"  never works on my DBs, It returns no error and no trace file, but I just cannot see any new partion created after the "_swrf_test_action", for example WRH$_ACTIVE_SESSION_HISTORY still has only one patrtion contains all awr data before, "_swrf_test_action" = 72  only adds new empty partiotion on the table.

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