Friday, November 28, 2008

DBA_FREE_SPACE_COALESCED

DBA_FREE_SPACE_COALESCED describes statistics on coalesced space in all tablespaces in the database.

Column

Datatype

NULL

Description

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace

TOTAL_EXTENTS

NUMBER

Total number of free extents in the tablespace

EXTENTS_COALESCED

NUMBER

Total number of coalesced free extents in the tablespace

PERCENT_EXTENTS _COALESCED

NUMBER

Percentage of coalesced free extents in the tablespace

TOTAL_BYTES

NUMBER

Total number of free bytes in the tablespace

BYTES_COALESCED

NUMBER

Total number of coalesced free bytes in the tablespace

TOTAL_BLOCKS

NUMBER

Total number of free Oracle blocks in the tablespace

BLOCKS_COALESCED

NUMBER

Total number of coalesced free Oracle blocks in the tablespace

PERCENT_BLOCKS _COALESCED

NUMBER

Percentage of coalesced free Oracle blocks in the tablespace

Note:

1.

select * from DBA_FREE_SPACE_COALESCED;

TABLESPACE_

NAME

TOTAL_

EXTENTS

EXTENTS_

COALESCED

PERCENT_

EXTENTS_

COALESCED

TOTAL_

BYTES

BYTES_

COALESCED

TOTAL_

BLOCKS

BLOCKS_

COALESCED

PERCENT_

BLOCKS_

COALESCED

SYSAUX

13

13

100

510590976

510590976

31164

31164

100

SYSTEM

2

2

100

338624512

338624512

20668

20668

100

UNDO

3

3

100

3145728

3145728

192

192

100

USERS

1

1

100

52232192

52232192

3188

3188

100

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 11:22:00 AM 0 comments

Labels: ,

DBA_EXP_VERSION

DBA_EXP_VERSION displays the version number of the last export session.

Column

Datatype

NULL

Description

EXP_VERSION

NUMBER(3)

NOT NULL

Version number of the last export session

Note:

1. The DBA_EXP views are only used with incremental exports.

To use the DBA_EXP views to track exports, use the incremental option. Use SYS.INCEXP, SYS.INCFIL, and SYS.INCVID tables to get information regarding table, user, and full exports.

If you are doing an incremental export, and the DBA_EXP views are empty, ensure that the Export parameter RECORD has been set to Y. RECORD controls whether or not entries are made to these tables during incremental exports. The default value for RECORD is Y, but if it has been changed to N you could see this problem on an incremental export.

2. Related views:

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 11:09:00 AM 0 comments

Labels: ,

DBA_EXP_OBJECTS

DBA_EXP_OBJECTS describes objects that have been incrementally exported.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of exported object

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of exported object

OBJECT_TYPE

VARCHAR2(12)

Type of exported object

CUMULATIVE

DATE

Timestamp of last cumulative export

INCREMENTAL

DATE

NOT NULL

Timestamp of last incremental export

EXPORT_VERSION

NUMBER(3)

NOT NULL

The ID of the export session

Note:

1. The DBA_EXP views are only used with incremental exports.

To use the DBA_EXP views to track exports, use the incremental option. Use SYS.INCEXP, SYS.INCFIL, and SYS.INCVID tables to get information regarding table, user, and full exports.

If you are doing an incremental export, and the DBA_EXP views are empty, ensure that the Export parameter RECORD has been set to Y. RECORD controls whether or not entries are made to these tables during incremental exports. The default value for RECORD is Y, but if it has been changed to N you could see this problem on an incremental export.

2. Related views:

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 11:08:00 AM 0 comments

Labels: ,

DBA_EXP_FILES

DBA_EXP_FILES describes export files.

Column

Datatype

NULL

Description

EXP_VERSION

NUMBER(3)

NOT NULL

Version number of the export session

EXP_TYPE

VARCHAR2(11)

Type of export file: complete, cumulative, or incremental

FILE_NAME

VARCHAR2(100)

NOT NULL

Name of the export file

USER_NAME

VARCHAR2(30)

NOT NULL

Name of user who executed export

TIMESTAMP

DATE

NOT NULL

Timestamp of the export session

Note:

1. The DBA_EXP views are only used with incremental exports.

To use the DBA_EXP views to track exports, use the incremental option. Use SYS.INCEXP, SYS.INCFIL, and SYS.INCVID tables to get information regarding table, user, and full exports.

If you are doing an incremental export, and the DBA_EXP views are empty, ensure that the Export parameter RECORD has been set to Y. RECORD controls whether or not entries are made to these tables during incremental exports. The default value for RECORD is Y, but if it has been changed to N you could see this problem on an incremental export.

2. Related views:

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 11:08:00 AM 0 comments

Labels: ,

DBA_EPG_DAD_AUTHORIZATION

DBA_EPG_DAD_AUTHORIZATION describes the DADs (Database Access Descriptor) that are authorized to use different user's privileges.

Related View

USER_EPG_DAD_AUTHORIZATION describes the DADs that are authorized to use the user's privileges. This view does not display the USERNAME column.

Column

Datatype

NULL

Description

DAD_NAME

VARCHAR2(64)

NOT NULL

Name of DAD

USERNAME

VARCHAR2(30)

NOT NULL

Name of the user whose privileges the DAD is authorized to use

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 10:58:00 AM 0 comments

Labels: ,

DBA_ENCRYPTED_COLUMNS

DBA_ENCRYPTED_COLUMNS maintains encryption algorithm information for all encrypted columns in the database. Its columns are the same as those in "ALL_ENCRYPTED_COLUMNS".

Related Views

· ALL_ENCRYPTED_COLUMNS displays encryption algorithm information for the encrypted columns in the tables accessible to the current user.

· USER_ENCRYPTED_COLUMNS displays encryption algorithm information for the encrypted columns in the tables owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column

ENCRYPTION_ALG

VARCHAR2(29)

Encryption algorithm used to protect secrecy of data in this column:

· 3 Key Triple DES 168 bits key

· AES 128 bits key

· AES 192 bits key

· AES 256 bits key

SALT

VARCHAR2(3)

Indicates whether the column is encrypted with SALT (YES) or not (NO)

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 10:46:00 AM 0 comments

Labels: ,

DBA_DATAPUMP_JOBS

DBA_DATAPUMP_JOBS identifies all active Data Pump jobs in the database, regardless of their state, on an instance (or on all instances for Real Application Clusters). It also show all Data Pump master tables not currently associated with an active job.

Related View

USER_DATAPUMP_JOBS displays the Data Pump jobs owned by the current user. This view does not display the OWNER_NAME column.

Column

Datatype

NULL

Description

OWNER_NAME

VARCHAR2(30)

User that initiated the job

JOB_NAME

VARCHAR2(30)

User-supplied name for the job (or the default name generated by the server)

OPERATION

VARCHAR2(30)

Type of job

JOB_MODE

VARCHAR2(30)

Mode of job

STATE

VARCHAR2(30)

Current job state

DEGREE

NUMBER

Number of worker processes performing the operation

ATTACHED_SESSIONS

NUMBER

Number of sessions attached to the job

DATAPUMP_SESSIONS

NUMBER

Number of Data Pump sessions participating in the job

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/28/2008 10:38:00 AM 0 comments

Labels: ,

DBA_CPU_USAGE_STATISTICS


DBA_CPU_USAGE_STATISTICS displays database CPU usage statistics.
Column
Datatype
NULL
Description
DBID
NUMBER
NOT NULL
Database ID
VERSION
VARCHAR2(17)
NOT NULL
Database version
TIMESTAMP
DATE
NOT NULL
Time at which the CPU usage changed
CPU_COUNT
NUMBER
CPU count of the database
CPU_CORE_COUNT
NUMBER
CPU core count of the database
CPU_SOCKET_COUNT
NUMBER
CPU socket count of the database
Note:
1.
select * from DBA_CPU_USAGE_STATISTICS;
DBID
VERSION
TIMESTAMP
CPU_COUNT
CPU_CORE_COUNT
CPU_SOCKET_COUNT
1234567890
10.2.0.3.0
2008-09-05 10:23:01 AM
4

Oracle data dictionary views

Oracle dynamic performance views

More Oracle DBA tips, please visit Oracle DBA Tips  

Posted by Admin at 11/28/2008 10:32:00 AM 0 comments

Labels: ,

Subscribe to: Posts (Atom)