RE: FW: Oracle Options

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Tue, 24 May 2005 14:43:51 -0700
Message-ID: <960A9B249C99994AA3C7FCA016A0DA8902AA0999@ussccem08.corp.hds.com>

On a 10.1.0.3 database

1 select owner, object_type,count(*)
2 from dba_objects where object_type like '%PARTI%' 3* group by owner, object_type
SQL> /

OWNER                          OBJECT_TYPE           COUNT(*)
------------------------------ ------------------- ----------
SH                             INDEX PARTITION            196
SH                             TABLE PARTITION             56
SYS                            LOB PARTITION               14
SYS                            INDEX PARTITION            312
SYS                            TABLE PARTITION            298
SYSTEM                         INDEX PARTITION             31
SYSTEM                         TABLE PARTITION             27

7 rows selected

The SH tables are for Demo only, the SYS ones consist of WRH (Workload Repository History AWR related) objects and the SYSTEM entries are for Log Miner. As long as you are using partitioning for these only, you are still in conformance!

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

http://tahiti.oracle.com - Manuals for DBAs (English only) http://www.bibleserver.com - Manual for Life (in English, Deutsch, French, Italian, Spanish, Portugese, Turkish,...)

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Thursday, May 19, 2005 9:43 AM
To: John.Hallas_at_gb.vodafone.co.uk
Cc: oracle-l_at_freelists.org
Subject: Re: FW: Oracle Options

On 5/19/05, Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk> wrote:
>
> Funnily enough even on a non partitioned installed installation there
> = are partitioned tables. Weird hey.
>

Indeed

SYS>select banner from v$version;

BANNER

Oracle Database 10g Release 10.1.0.4.0 - Production PL/SQL Release 10.1.0.4.0 - Production CORE 10.1.0.4.0 Production TNS for 32-bit Windows: Version 10.1.0.4.0 - Production NLSRTL Version 10.1.0.4.0 - Production

5 rows selected.

/* std edition */

SYS>select comp_name
2 from dba_registry;

COMP_NAME

Oracle Ultra Search
Oracle Enterprise Manager
Oracle Text
Oracle XML Database
Oracle interMedia
Oracle Expression Filter
Oracle Workspace Manager
Oracle Data Mining
Oracle Database Catalog Views
Oracle Database Packages and Types
JServer JAVA Virtual Machine
Oracle XDK
Oracle Database Java Packages

/* No AQ, No Partitioning etc */

SYS>select object_type,count(*)
2 from dba_objects
3 group by object_type;

/* edited only to remove irrelevant stuff */

OBJECT_TYPE COUNT(*)

------------------- ----------

INDEX PARTITION 80
LOB PARTITION 2
QUEUE 23
TABLE PARTITION 73 SYS>

--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

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

Received on Tue May 24 2005 - 17:48:42 CDT