Re: 10g on unix. Partitions... Tablespaces... and best practices

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Tue, 7 Jul 2009 16:15:09 +0100
Message-ID: <OF40BD2FD2.0CE31639-ON802575EC.00539935-802575EC.0053C8B8_at_ons.gsi.gov.uk>



You don't say what version of Oracle you are currently but there were a few bugs with the DBA_EXTENTS view in early versions of 10gR2. I believe they are all fixed in 10.2.0.4 but you may want to do a metalink search on "dba_extents slow" to see if you are running into one of them.

Cheers,

Ian

|---------+----------------------------->

| | madhusreeram_at_gmail|
| | .com |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 07/07/2009 15:57 |
| | Please respond to |
| | madhusreeram |
| | |
|---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: awells_at_netspend.com | | cc: oracle-l_at_freelists.org | | Subject: Re: 10g on unix. Partitions... Tablespaces... and best practices | >--------------------------------------------------------------------------------------------------------------|

I work with database that has >500 tablespaces, and of course it is all fine. The only problem is queries hitting dba_extents is slow, but that could be due to many datafiles, not necessarily due to many tablespaces.

When you have a database using raw partitions, the number of tablespaces is a big restriction, since the Linux allowed only 256 raw devices (not sure about the current versions, but at least the versions that came during 9i). For database systems on 9i RAC , where majority of them were based of raw partitions, this was a serious restriction. I think the consolidation of tablespaces in ERP, to my knowledge, was driven by this limitation.

-Madhu Sreeram

This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.

For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk


Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications


Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics


The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. i0zX+n{+i^ Received on Tue Jul 07 2009 - 10:15:09 CDT

Original text of this message