Re: autospace advisor job and this oracle table: WRI$_ADV_OBJSPACE_TREND_DATA`
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: ricks12345@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 May 2008 19:34:18 -0700 (PDT)
You should be able to turn it off without any dire consequences ... I'd open a
SR with Oracle first just to make sure there isn't some patch available for
your problem.
RF
Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
----- Original Message ----
From: Rick Ricky <ricks12345@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Wednesday, May 28, 2008 8:13:07 PM
Subject: autospace advisor job and this oracle table:
WRI$_ADV_OBJSPACE_TREND_DATA`
Does anyone know if there are consequences to disabling the
AUTO_SPACE_ADVISOR_JOB ? ts causing performance problems.
Also, when i check my locked objects, I find that this table is locked alot
(same with a few other WRI$ tables) WRI$_ADV_OBJSPACE_TREND_DATA
are these tables used by the auto_space_advisor_job? Nothing really on google
about it.
I checked google and i saw a few posts asking about turning this off. Its
causing performance problems. What are the consequences? I can't find anything.
Other related posts: