RE: Oracle 10g Partitioning AWR

  • From: "Karla, Srini \(HAS-SAT\)" <Srini_Karla@xxxxxxxxxxxx>
  • To: <smishra_97@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Jun 2007 11:14:05 -0500

Enterprise Manager 10g can function without partitioning, but it is much
less efficient without it. So it is strongly recommended using
partitioning. 
The license for the partitioning option is not needed if the option is
used for Enterprise Manager 10g only. This means that if you are not
licensed for the Partitioning Option, you can install it in the database
hosting the Grid Repository, but this database must be dedicated to the
Grid Repository and must not be used for any other applications data.

 

Thanks, 
Srini Karla 
Sr. Database Administrator, 
Harcourt Assessments, Inc., 
San Antonio, TX 78259 
210-339-5252 work 
210-683-3936 cell 
--------------------------------------------------- 
Our Sharepoint: http://hassatappp022/sites/epa/ea/default.aspx 
--------------------------------------------------- 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra
Sent: Wednesday, June 27, 2007 10:39 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle 10g Partitioning AWR 

 

Hi

 

If I am installing Oracle 10g Enterprise edition and uncheck the Oracle
Partitioning option [ Means nO Partitioning], does that mean that AWR
will not work or will not utilize partitioning. I don't have any test
box to test it and our company docs which was created for Old version
says that Uncheck Partitioning due to License restriction.

 

If AWR will work without partitioning then it means it will be big
performance hit to purge older that 7 days data as been done.

 

TIA

Sanjay

  

________________________________

Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.
<http://us.rd.yahoo.com/evt=48224/*http:/sims.yahoo.com/> 

Other related posts: