Home » RDBMS Server » Server Administration » Monitoring Table Growth
Monitoring Table Growth [message #53654] Thu, 03 October 2002 08:22 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
Does anyone have a suggestion on how to monitor table growth? I am already monitoring free space fragmentation as well as extents and segments, however, I want to have a script that will alarm for unusual table growth and am not sure how to monitor it.
Thank you in advance.

Joe

Report message to a moderator

Re: Monitoring Table Growth [message #53688 is a reply to message #53654] Fri, 04 October 2002 20:31 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Since tables reside in tablespaces and datafiles tends to run out of extents, you better monitor the tablespace growth over a time period.

If you are on UNIX scripts like That one could do the job.

Otherwise, OEM has Tuning Pack which can do the same thing.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Instance crashed... unable to restart the instance
Next Topic: OCP test SQL/PL-SQL. Need to share reading and practice materials
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 00:46:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.