Re: autospace advisor job and this oracle table: WRI$_ADV_OBJSPACE_TREND_DATA`

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 28 May 2008 19:34:18 -0700 (PDT)
Message-ID: <982453.92280.qm@web38905.mail.mud.yahoo.com>

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.

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_at_gmail.com> To: oracle-l_at_freelists.org 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.
--

http://www.freelists.org/webpage/oracle-l Received on Wed May 28 2008 - 21:34:18 CDT

This message: [ Message body ]
Next message: qihua wu: "Re: direct read is much faster than scattered read, is it reasonable?"
Previous message: Rick Ricky: "autospace advisor job and this oracle table: WRI$_ADV_OBJSPACE_TREND_DATA`"
Maybe in reply to: Rick Ricky: "autospace advisor job and this oracle table: WRI$_ADV_OBJSPACE_TREND_DATA`"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message