SQL Performance (MOSC)

MOSC Banner

regarding TRCA$_FILE

edited Jul 21, 2016 5:01AM in SQL Performance (MOSC) 4 commentsAnswered

Hi all

After executed [ SQL> @sqltxecute.sql  /tmp/tada_20160330/sql/sample1.sql sqltxplain ] several times,

TRCA$_FILE object (LOB segment) get large. even though purge script was executed.

The purge script below didn't purge TRCA$_FILE table.

SQL> @sqlt_s33190_purge.sql


So why TRCA$_FILE table is not purged by SQLTXADMIN.sqlt$a.purge_repository?


Thanks

Lin

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