×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
BMC PATROL for Oracle Database Monitoring 9.7 ... Configuring after installation Configuring in a BMC PATROL environment Additional configuration information

PATROL for Oracle tables

The PATROL tables are described in the following table-the following table.



P$AUTOEXT table

Name

Null?

Data type

Definition

TABLESPACE_NAME

NOT NULL

VARCHAR2(30)

name of the tablespace

FILE#

NOT NULL

NUMBER

absolute file number

AUTOEXTEND

VARCHAR2(5)

whether the tablespace has autoextended or not

MONITORING

VARCHAR2(10)

whether the tablespace is INCLUDED or EXCLUDED from monitoring



P$AUTOEXTEND table

Name

Null?

Data type

Description

TABLESPACE_NAME

VARCHAR2(30)

name of the tablespace

MAX_SEG_NEXT_EXTENT

NUMBER

maximum size (in bytes) of the next extent for the segments in the tablespace

MAX_FREE_BYTES

NUMBER

size (in bytes) of the largest free extent

MAX_FILE_AVAIL

NUMBER

maximum available space (in bytes) in an autoextensible file of the tablespace

OS_AVAIL

NUMBER

maximum number of free operating system bytes

FILE_INC_BYTES

NUMBER

size (in bytes) that the file can allocate when more space is required

FILE_ID

NUMBER

ID of the file

FILE_NAME

VARCHAR2(513)

name of the file



P$AUTOEXTFILE table

Name

Null?

Data type

Description

FILE#

NOT NULL

NUMBER

number of the file

BYTES

NUMBER

file size (in bytes) of the autoextensible data/temp files

FILE_TYPE

NOT NULL

NUMBER

decides the type of the file: datafile (0) or tempfile (1)



P$AUTOEXTTS table

Name

Null?

Data type

Description

TABLESPACE_NAME

VARCHAR2(30)

name of the tablespace

ALLOCATION_TYPE

VARCHAR2(9)

name of the tablespace allocation type



P$BUFFERCACHE table

Name

Null?

Data type

Definition

OBJECT_NAME

NOT NULL

VARCHAR2(60)

name of the object currently in the buffer cache

OBJECT_TYPE

NOT NULL

VARCHAR2(16)

type of the object currently in the buffer cache

HEADER_BLOCKS

NOT NULL

NUMBER(38)

number of headers in the buffer cache

DATA_BLOCKS

NOT NULL

NUMBER(38)

number of data blocks in the buffer cache

CR_BLOCKS

NOT NULL

NUMBER(38)

number of consistent blocks in the buffer cache



P$CANTEXTFILE table

Name

Null?

Data type

Description

FILE_ID

NUMBER

ID of the file

FILE_NAME

VARCHAR2(513)

name of the file

TABLESPACE_NAME

VARCHAR2(30)

name of the tablespace

FILE_INC_BYTES

NUMBER

size (in bytes) that the file can allocate when more space is required

FILE_AVAIL

NUMBER

available space (in bytes)



P$CANTEXTMAXFILE table

Name

Null?

Data type

Description

TABLESPACE_NAME

VARCHAR2(30)

name of the tablespace

MAX_FILE_AVAIL

NUMBER

maximum available space (in bytes) in an auto extensible file of the tablespace



P$CANTEXTMAXTBSP table

Name

Null?

Data type

Description

TABLESPACE_NAME

VARCHAR2(30)

name of the tablespace

MAX_SEG_NEXT_EXTENT

NUMBER

maximum size (in bytes) of the next extent for the segments in the tablespace

MAX_FREE_BYTES

NUMBER

size (in bytes) of the largest free extent



P$DATA_OS_SPACE table

Name

Null?

Data type

Description

FILESYSTEM

N/A

VARCHAR2(513)

name of the file system

OSAVAIL

N/A

NUMBER

space left according to the operating system



P$DATA_TS_SPACELEFT table

Name

Null?

Data type

Description

TABLESPACE_NAME

N/A

VARCHAR2(30)

name of the permanent tablespace

FREESPACE

N/A

NUMBER

free space left in table

TOTALSPACE

N/A

NUMBER

total amount of space in table



P$EXTENTMAP table

Name

Null?

Data type

Definition

FILE#

NOT NULL

NUMBER

number of the file

LOWB

NOT NULL

NUMBER

block number

HIGHB

NOT NULL

NUMBER

block number plus the length of the extent (in blocks) minus 1

EXT#

NOT NULL

NUMBER

number of the extent

OBJ_NAME

NOT NULL

VARCHAR2(30)

name of the object

OWN_NAME

NOT NULL

VARCHAR2(30)

name of the owner of the object

KIND

NOT NULL

VARCHAR2(12)

kind of object

OBJ#

NUMBER

number of the object



P$JOBACTION table

Name

Null?

Data type

Definition

JOBNAME

NOT NULL

VARCHAR2(64)

unique name of the job

CATEGORY

NOT NULL

VARCHAR2(12)

type of job:

  • PSL
  • SQL
  • OS

OUTPUTMODE

NUMBER

how to output the job:

  • Text Window
  • Annotation
  • Log File

WHENTONOTIFY

NUMBER

criteria to use for notifying the job results:

  • Always
  • Job Succeeds
  • Job Fails
  • Job Completes

JOBTERMINATE

NUMBER

time the job is supposed to terminate

PARAM1

VARCHAR2(1024)

parameter to use for the job

PARAM2

VARCHAR2(32)

parameter to use for the job

PARAM3

VARCHAR2(32)

parameter to use for the job

LOGNAME

VARCHAR2(16)

name of the log file on the agent computer

TEXT

VARCHAR2(2000)

text of the job results



P$JOBGENERAL table

Name

Null?

Data type

Definition

JOBNAME

NOT NULL

VARCHAR2(64)

unique name of the job

CREATED

NUMBER

timestamp showing when the job was created

LASTMODIFIED

NUMBER

timestamp showing when the job was last changed

OWNER

VARCHAR2(20)

owner of the job

DBNAME

VARCHAR2(32)

database where the job is set to run



P$JOBHISTORY table

Name

Null?

Data type

Definition

JOBNAME

NOT NULL

VARCHAR2(64)

unique name of the job

RUNAT

NUMBER

timestamp that shows when the job should run

NOTIFMODE

NUMBER

mode to use to notify of any errors

DURATION

NUMBER

number of iterations the job is supposed to run

RESULT

VARCHAR2(32)

whether the job ran successfully



P$JOBSCHEDULE table

Name

Null?

Data type

Definition

JOBNAME

NOT NULL

VARCHAR2(64)

unique name of the job

ENABLED

NUMBER

whether the job is set to run

SCHTYPE

NOT NULL

NUMBER

type of schedule the job is set to:

  • Once
  • Daily Once
  • Daily Recur
  • Weekly Once
  • Weekly Recur

SCHOCCURS

NUMBER

number of iterations the job is supposed to run

SCHDAY

CHAR(3)

day of the week the job is scheduled to run

SCHFREQ

NUMBER

how frequently the job is supposed to run

STARTING

NOT NULL

NUMBER

time the job is scheduled to start

ENDING

NUMBER

time the job is scheduled to stop

STARTDATE

NUMBER

date the job is scheduled to start

ENDDATE

NUMBER

date the job is scheduled to end

DESCRIPTION

VARCHAR2(256)

description of the job



P$LOCKCONFLICTTX table

Name

Null?

Data type

Definition

WAIT_USERNAME

N/A

VARCHAR2(30)

name of the user that is waiting for a lock

WAIT_UID

N/A

NUMBER

ID of the user that is waiting for a lock

LOCK_TYPE

N/A

VARCHAR2(5)

type of lock the object is waiting for

LOCK_OBJECT

N/A

VARCHAR2(40)

object that is locked

HOLD_USERNAME

N/A

VARCHAR2(30)

name of the user that is holding the lock

HOLD_UID

N/A

NUMBER

ID of the user that is holding the lock

LOCK_FILE#

N/A

NUMBER

the file that the lock is on

LOCK_BLOCK

N/A

NUMBER

the block in the file that has the lock

LOCK_ROW

N/A

NUMBER

the row in the file that has the lock



P$LOCKCONFLICTUSER table

Name

Null?

Data type

Definition

WAIT_USERNAME

N/A

VARCHAR2(30)

name of the user that is waiting for a lock

WAIT_UID

N/A

NUMBER

ID of the user that is waiting for a lock

LOCK_TYPE

N/A

VARCHAR2(5)

type of lock the object is waiting for

LOCK_OBJECT

N/A

VARCHAR2(40)

object that is locked

WAIT_LOCK_MODE

N/A

VARCHAR2(16)

mode of waiting the object is using

HOLD_USERNAME

N/A

VARCHAR2(30)

name of the user that is holding the lock

HOLD_UID

N/A

NUMBER

ID of the user that is holding the lock

HOLD_LOCK_MODE

N/A

VARCHAR2(16)

mode of the holding lock



P$OBJ_EXCLUSION table

Name

Null?

Data type

Definition

TS#

NOT NULL

NUMBER

tablespace identifier

FILE#

N/A

NUMBER

file identifier

BLOCK#

N/A

NUMBER

starting block location

OWNER

N/A

VARCHAR2(30)

name of the owner of the object

OBJECT_TYPE

N/A

VARCHAR2(30)

type of object that is excluded

OBJECT_NAME

N/A

VARCHAR2(30)

name of the object



P$SQL table

Name

Null?

Data type

Definition

ADDRESS

RAW(4)

address of the handle to the parent for this cursor

HASH_VALUE

NUMBER

hash value of the parent statement in the library cache

TIME_STAMP

DATE

time stamp of the SQL command

PARSING_USER_ID

NUMBER

ID of the first user that parses the SQL

FIRST_LOAD_TIME

VARCHAR2(19)

date and time that the SQL was first loaded

SHARABLE_MEM

NUMBER

amount of sharable memory in the shared pool consumed by the object

PERSISTENT_MEM

NUMBER

amount of persistent memory, in bytes used by this child cursor

RUNTIME_MEM

NUMBER

size of the ephemeral frame used by this child cursor

SORTS

NUMBER

number of sorts that was done for this child cursor

LOADED_VERSIONS

NUMBER

1 if context heap is loaded, 0 otherwise

EXECUTIONS

NUMBER

number of times that a SQL statement is executed

USERS_EXECUTING

NUMBER

number of users executing the statement

LOADS

NUMBER

number of times that a SQL statement is reloaded into cache. The number of reloads increases, for example, when there is inadequate Shared Global area.

INVALIDATIONS

NUMBER

number of times this child cursor has been invalidated

PARSE_CALLS

NUMBER

number of times that a SQL statement is parsed

DISK_READS

NUMBER

number of disk reads for this child cursor

BUFFER_GETS

NUMBER

number of buffers that are read for a SQL statement

CURSOR_COUNT

NUMBER

current number of cursors (whether they are in use or not)



P$SQLID table

Name

Null?

Data Type

Definition

SQL_ID

NUMBER

ID of the SQL statement

ADDRESS

RAW(4)

used with HASH_VALUE to identify uniquely a cached cursor

HASH_VALUE

NUMBER

hash value always unique



P$SQLTEXT table

Name

Null?

Data Type

Definition

ADDRESS

RAW(4)

used with HASH_VALUE to identify uniquely a cached cursor

HASH_VALUE

NUMBER

hash value always unique

COMMAND_TYPE

NUMBER

A code for the type of SQL statement (such as SELECT and INSERT) being executed

PIECE

NUMBER

number used to order the pieces of SQL text

SQL_TEXT

VARCHAR2(64)

line of SQL text



P$TEMP_TS_SPACELEFT table

Name

Null?

Data type

Definition

TABLESPACE_NAME

N/A

VARCHAR2(30)

name of the temporary tablespace

FREESPACE

N/A

NUMBER

free space left in table

TOTALSPACE

N/A

NUMBER

total amount of space in table



P$TEMP_OS_SPACE table

Name

Null?

Data type

Definition

FILESYSTEM

N/A

VARCHAR2(513)

name of the file system

OSAVAIL

N/A

NUMBER

space left according to the operating system

Was this page helpful? Yes No Submitting... Thank you
Last modified by Shashi Kumar on Feb 22, 2016

Comments

Log in or register to comment.

PATROL for Oracle database objects
Storage parameters for PATROL tables
© Copyright 2014 - 2018, 2022 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.