Data File Interval (PI_PIDF)
- Organization of this page
Function
The Data File Interval (PI_PIDF) record stores performance data, taken at specific intervals, about data files. PFM - Agent for Oracle creates one record for each data file in the database. This is a multi-instance record.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
300 |
Y |
Collection Offset |
40 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PI_PIDF_FILE_NUM
-
PI_PIDF_NAME
Lifetime
From the creation to the deletion of a data file
Record size
-
Fixed part: 678 bytes
-
Variable part: 892 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Blocks (BLOCKS) |
Oracle block size #1 |
COPY |
double |
No |
All |
|
Checkpoint Change # (CHECKPOINT_CHANGE_NUM) |
System change number (SCN) at the last checkpoint #1 |
COPY |
double |
No |
All |
V$DATAFILE.CHECKPOINT_CHANGE# |
Enabled (ENABLED) |
This field contains one of the following values as the method for accessing a file using SQL: #1 DISABLED READ ONLY READ WRITE UNKNOWN |
COPY |
string(10) |
No |
All |
|
File # (FILE_NUM) |
File identification number #1 |
COPY |
long |
No |
All |
|
File Name (NAME) |
File name #1 |
COPY |
string(513) |
No |
All |
|
Free % (PERCENT_FREE) |
Percentage ratio of free space #2 |
AVG |
double |
No |
All |
|
Free Change (FREE_CHANGE) |
Change to the free space (the difference between the value obtained this time and the value obtained the last time) in megabytes#2 |
AVG |
double |
No |
All |
|
Free Mbytes (FREE_BYTES) |
Size of free space in megabytes #2 |
AVG |
double |
No |
All |
|
I/O Ops/sec (IO_RATE) |
Number of I/O operations per second#2 |
AVG |
double |
No |
All |
|
Mbytes (BYTES) |
Disk space in megabytes required on the file system#1 |
COPY |
double |
No |
All |
|
Physical Blocks Read (PHYSICAL_BLOCKS_READ) |
Number of physical block write operations during the interval#2 |
AVG |
double |
Yes |
All |
|
Physical Blocks Written (PHYSICAL_BLOCKS_WRITTEN) |
Number of physical block read operations during the interval#2 |
AVG |
double |
Yes |
All |
|
Physical Reads (PHYSICAL_READS) |
Number of physical block read operations that were completed during the interval#2 |
AVG |
double |
Yes |
All |
|
Physical Writes (PHYSICAL_WRITES) |
Number of physical block write operations that were completed during the interval#2 |
AVG |
double |
Yes |
All |
|
Read Time (READ_TIME) |
If the value of the TIMED_STATISTICS parameter in the init.ora file is TRUE, this field indicates the read operation time during the interval. If the parameter value is FALSE, this field contains 0. In centiseconds (1/100 of a second).#2 |
AVG |
double |
Yes |
All |
|
Reads/sec (READ_RATE) |
Number of read operations per second#2 |
AVG |
double |
No |
All |
|
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PIDF)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Status (STATUS) |
File type (system file or user file) and file status (OFFLINE, SYSOFF, ONLINE, SYSTEM, or RECOVER)#1 |
COPY |
string(7) |
No |
All |
|
Tablespace Name (TABLESPACE_NAME) |
Tablespace name associated with the file #1 |
COPY |
string(30) |
No |
All |
|
Used Change (USED_CHANGE) |
Size of used area (the difference between the value obtained this time and the value obtained the last time) in megabytes #2 |
AVG |
double |
No |
All |
|
Used Mbytes (USED_BYTES) |
Change to the used space in megabytes. #2 |
AVG |
double |
No |
All |
|
Write % (WRITE_PERCENTAGE) |
Percentage ratio of write operations #2 |
AVG |
double |
No |
All |
|
Write Time (WRITE_TIME) |
If the value of the TIMED_STATISTICS parameter in the init.ora file is TRUE, this field indicates the write operation time during the interval. If the parameter value is FALSE, this field contains 0. In centiseconds (1/100 of a second).#2 |
AVG |
double |
Yes |
All |
|
Writes/sec (WRITES_RATE) |
Number of write operations per second#2 |
AVG |
double |
No |
All |
|