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

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Wed, 28 May 2008 22:13:07 -0400
Message-ID: <81f4c0700805281913kd27e88ay6e34eb816833d90e@mail.gmail.com>

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:13:07 CDT

This message: [ Message body ]
Next message: Robert Freeman: "Re: autospace advisor job and this oracle table: WRI$_ADV_OBJSPACE_TREND_DATA`"
Previous message: Tanel Poder: "RE: direct read is much faster than scattered read, is it reasonable?"
Next in thread: Robert Freeman: "Re: autospace advisor job and this oracle table: WRI$_ADV_OBJSPACE_TREND_DATA`"
Maybe reply: Robert Freeman: "Re: 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