RE: 10g AWR question

Peter,

The SYSAUX table contains more than just AWR data. You can determine size/usage from the V$SYSAUX_OCCUPANTS view and customize AWR settings to keep it down to a manageable size (lesser number of days to retain data and snapshots at longer periods). It is a mandatory tablespace, but you should be able to size it down depending on these parameters as tested/seen on a test database. Be aware that if you are in archivelog mode, there will be steady stream of logs just because of AWR/ASH and other collections as well.... If you do want to play around with undoc parameters, there are ways to switch off some of these collections. More in Ch 11/Section III in the book noted below.

Regards,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910  

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Dixon Sent: Wednesday, December 07, 2005 7:32 AM To: Oracle-L_at_freelists.org
Subject: 10g AWR question

We are at present performing a sizing exercise for diskspace required to migrate our 150 development database from 8i to 10g. Does anybody have any information on how to size the database for Automatic Workload Respository using the sysaux tablespace. I have read that the sysaux tablespace should be about 1gb in size but the database is only 500m so that we mean quite alot of additional diskspace.

Anybody got any comments?

Peter Dixon
DBA
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 07 2005 - 11:47:28 CST