Monday, July 28, 2008

DBA_XML_TABLES

Oracle 11gR1

DBA_XML_TABLES describes all XML tables in the database. Its columns are the same as those in ALL_XML_TABLES.

Related Views

· ALL_XML_TABLES describes the XML tables accessible to the current user.

· USER_XML_TABLES describes the XML tables owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

Owner of the XML table

TABLE_NAME

VARCHAR2(30)

Name of the XML table

XMLSCHEMA

VARCHAR2(700)

Name of the XML Schema that is used for the table definition

SCHEMA_OWNER

VARCHAR2(30)

Owner of the XML Schema that is used for the table definition

ELEMENT_NAME

VARCHAR2(2000)

Name of the XML SChema element that is used for the table

STORAGE_TYPE

VARCHAR2(17)

Storage option for the XMLtype data:

· OBJECT-RELATIONAL

· BINARY

· CLOB

ANYSCHEMA

VARCHAR2(3)

If storage is BINARY, indicates whether the column allows ANYSCHEMA (YES) or not (NO), else NULL

NONSCHEMA

VARCHAR2(3)

If storage is BINARY, indicates whether the column allows NONSCHEMA (YES) or not (NO), else NULL

Note:

You can check the contents of ALL_XML_SCHEMAS and ALL_XML_TABLES views to check if XDB is being used in the database. If there is anything there which is owned by any user other than XDB then you may be using the XDB feature.

You may see following standard schemas under EXFSYS, MDSYS, ORDSYS, and SYS, e.g. -

OWNER SCHEMA_URL
---------- --------------------------------------------------------------------
EXFSYS http://xmlns.oracle.com/rlmgr/rclsprop.xsd
EXFSYS http://xmlns.oracle.com/rlmgr/rulecond.xsd
MDSYS http://www.opengis.net/cartographicText.xsd
MDSYS http://www.opengis.net/gml/feature.xsd
MDSYS http://www.opengis.net/gml/geometry.xsd
MDSYS http://www.w3.org/1999/xlink/xlinks.xsd
MDSYS http://xmlns.oracle.com/spatial/georaster/georaster.xsd
ORDSYS http://xmlns.oracle.com/ord/meta/dicomImage
ORDSYS http://xmlns.oracle.com/ord/meta/exif
ORDSYS http://xmlns.oracle.com/ord/meta/iptc
ORDSYS http://xmlns.oracle.com/ord/meta/ordimage
ORDSYS http://xmlns.oracle.com/ord/meta/xmp
SYS http://xmlns.oracle.com/streams/schemas/lcr/streamslcr.xsd

These are standard schemas which relate to Oracle Intermedia EXIF metadata, Oracle GEORASTER, EXFSYS, Oracle Locator components and may appear in the list if you have any of these components installed. These can easily be recreated by running the standard supplied scripts.

Metalink Note: 558834.1: How To Re-register XML Schemas After XDB Has Been Re-installed?

Oracle data dictionary views

Posted by Admin at 7/28/2008 03:14:00 PM 0 comments

Labels: ,

DBA_XML_SCHEMAS

Oracle 11gR1

DBA_XML_SCHEMAS describes all registered XML schemas in the database. Its columns are the same as those in ALL_XML_SCHEMAS.

Related Views

· ALL_XML_SCHEMAS describes the registered XML schemas accessible to the current user.

· USER_XML_SCHEMAS describes the registered XML schemas owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

Owner of the XML schema

SCHEMA_URL

VARCHAR2(700)

Schema URL of the XML schema

LOCAL

VARCHAR2(3)

Indicates whether the XML schema is local (YES) or global (NO)

SCHEMA

XMLTYPE

XML schema document

INT_OBJNAME

VARCHAR2(4000)

Internal database object name for the schema

QUAL_SCHEMA_URL

VARCHAR2(767)

Fully qualified schema URL

HIER_TYPE

VARCHAR2(11)

Type of hierarchy for which the schema is enabled:

· NONE

· RESMETADATA

· CONTENTS

BINARY

VARCHAR2(3)

Indicates whether the XML Schema is registered for binary encoding usage (YES) or not (NO)

SCHEMA_ID

RAW(16)

Opaque schema identifier (16 bytes)

HIDDEN

VARCHAR2(3)

Indicates whether the XML Schema has been deleted in hidden mode (YES) or not (NO)

Note:

You can check the contents of ALL_XML_SCHEMAS and ALL_XML_TABLES views to check if XDB is being used in the database. If there is anything there which is owned by any user other than XDB then you may be using the XDB feature.

You may see following standard schemas under EXFSYS, MDSYS, ORDSYS, and SYS, e.g. -

OWNER SCHEMA_URL
---------- --------------------------------------------------------------------
EXFSYS http://xmlns.oracle.com/rlmgr/rclsprop.xsd
EXFSYS http://xmlns.oracle.com/rlmgr/rulecond.xsd
MDSYS http://www.opengis.net/cartographicText.xsd
MDSYS http://www.opengis.net/gml/feature.xsd
MDSYS http://www.opengis.net/gml/geometry.xsd
MDSYS http://www.w3.org/1999/xlink/xlinks.xsd
MDSYS http://xmlns.oracle.com/spatial/georaster/georaster.xsd
ORDSYS http://xmlns.oracle.com/ord/meta/dicomImage
ORDSYS http://xmlns.oracle.com/ord/meta/exif
ORDSYS http://xmlns.oracle.com/ord/meta/iptc
ORDSYS http://xmlns.oracle.com/ord/meta/ordimage
ORDSYS http://xmlns.oracle.com/ord/meta/xmp
SYS http://xmlns.oracle.com/streams/schemas/lcr/streamslcr.xsd

These are standard schemas which relate to Oracle Intermedia EXIF metadata, Oracle GEORASTER, EXFSYS, Oracle Locator components and may appear in the list if you have any of these components installed. These can easily be recreated by running the standard supplied scripts.

Metalink Note: 558834.1: How To Re-register XML Schemas After XDB Has Been Re-installed?

Oracle data dictionary views

Posted by Admin at 7/28/2008 03:13:00 PM 0 comments

Labels: ,

DBA_REFRESH_CHILDREN

Oracle 11gR1

DBA_REFRESH_CHILDREN lists all of the objects in all refresh groups in the database.

Related Views

· ALL_REFRESH_CHILDREN lists all the objects in refresh groups that are accessible to the current user.

· USER_REFRESH_CHILDREN describes the objects in all refresh groups owned by the current user.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object in the refresh group

NAME

VARCHAR2(30)

NOT NULL

Name of the object in the refresh group

TYPE

VARCHAR2(30)

Type of the object in the refresh group

ROWNER

VARCHAR2(30)

NOT NULL

Name of the owner of the refresh group

RNAME

VARCHAR2(30)

NOT NULL

Name of the refresh group

REFGROUP

NUMBER

Internal identifier of refresh group

IMPLICIT_DESTROY

VARCHAR2(1)

(Y| N) If Y, then destroy the refresh group when its last item is subtracted

PUSH_DEFERRED_RPC

VARCHAR2(1)

(Y |N) If Y then push changes from snapshot to master before refresh

REFRESH_AFTER _ERRORS

VARCHAR2(1)

If Y, proceed with refresh despite error when pushing deferred RPCs

ROLLBACK_SEG

VARCHAR2(30)

Name of the rollback segment to use while refreshing

JOB

NUMBER

Identifier of job used to refresh the group automatically

NEXT_DATE

DATE

Date that this job will next be refreshed automatically, if not broken

INTERVAL

VARCHAR2(200)

A date function used to compute the next NEXT_DATE

BROKEN

VARCHAR2(1)

(Y |N) Y means the job is broken and will never be run

PURGE_OPTION

NUMBER(38)

The method for purging the transaction queue after each push. 1 indicates quick purge option; 2 indicates precise purge option

PARALLELISM

NUMBER(38)

The level of parallelism for transaction propagation

HEAP_SIZE

NUMBER(38)

The size of the heap

Oracle data dictionary views

Posted by Admin at 7/28/2008 03:12:00 PM 0 comments

Labels: ,

DBA_FREE_SPACE

Oracle 11gR1

DBA_FREE_SPACE describes the free extents in all tablespaces in the database.

Note that if a datafile (or entire tablespace) is offline in a locally managed tablespace, you will not see any extent information. If an object has extents in an online file of the tablespace, you will see extent information about the offline datafile. However, if the object is entirely in the offline file, a query of this view will not return any records.

Related View

USER_FREE_SPACE describes the free extents in the tablespaces accessible to the current user.

Column

Datatype

NULL

Description

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace containing the extent

FILE_ID

NUMBER

File identifier number of the file containing the extent

BLOCK_ID

NUMBER

Starting block number of the extent

BYTES

NUMBER

Size of the extent (in bytes)

BLOCKS

NUMBER

Size of the extent (in Oracle blocks)

RELATIVE_FNO

NUMBER

Relative file number of the file containing the extent

Oracle data dictionary views

Posted by Admin at 7/28/2008 03:10:00 PM 0 comments

Labels: ,

DBA_DATA_FILES

Oracle 11gR1

DBA_DATA_FILES describes database files.

Column

Datatype

NULL

Description

FILE_NAME

VARCHAR2(513)


Name of the database file

FILE_ID

NUMBER

NOT NULL

File identifier number of the database file

TABLESPACE_NAME

VARCHAR2(30)

NOT NULL

Name of the tablespace to which the file belongs

BYTES

NUMBER


Size of the file in bytes

BLOCKS

NUMBER

NOT NULL

Size of the file in Oracle blocks

STATUS

VARCHAR2(9)


File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)

RELATIVE_FNO

NUMBER


Relative file number

AUTOEXTENSIBLE

VARCHAR2(3)


Autoextensible indicator

MAXBYTES

NUMBER


Maximum file size in bytes

MAXBLOCKS

NUMBER


Maximum file size in blocks

INCREMENT_BY

NUMBER


Number of tablespace blocks used as autoextension increment. Block size is contained in the BLOCK_SIZE column of the DBA_TABLESPACES view.

USER_BYTES

NUMBER


The size of the file available for user data. The actual size of the file minus the USER_BYTES value is used to store file related metadata.

USER_BLOCKS

NUMBER


Number of blocks which can be used by the data

ONLINE_STATUS

VARCHAR2(7)


Online status of the file:

· SYSOFF

· SYSTEM

· OFFLINE

· ONLINE

· RECOVER

Oracle data dictionary views

Posted by Admin at 7/28/2008 03:04:00 PM 0 comments

Labels: ,

V$LOGFILE

Oracle 11gR1

V$LOGFILE contains information about redo log files.

Column

Datatype

Description

GROUP#

NUMBER

Redo log group identifier number

STATUS

VARCHAR2(7)

Status of the log member:

· INVALID - File is inaccessible

· STALE - File's contents are incomplete

· DELETED - File is no longer used

· null - File is in use

TYPE

VARCHAR2(7)

Type of the logfile:

· ONLINE

· STANDBY

MEMBER

VARCHAR2(513)

Redo log member name

IS_RECOVERY_DEST_FILE

VARCHAR2(3)

Indicates whether the file was created in the flash recovery area (YES) or not (NO)

Oracle dynamic performance views

Posted by Admin at 7/28/2008 02:39:00 PM 0 comments

Labels: ,

Subscribe to: Posts (Atom)