Data from the buffer pool is written to the disk
Data from the buffer pool is written to the page
Fetching data from hard disk to buffer pool
Fetching data from page to buffer pool
Once a week
Depending on frequency of table updates.
Once a Month
In Logical Partition
In Primary Partition
In Secondary Partition
Database partition consists its own data, index, config files and transaction logs
Database partition consists its own data, index, config files except transaction logs
Database partition consists its own data, index and transaction logs except config files
Massively Parallel Processing
Maximum Parallel Processing
Minimum Parallel Processing
Marginal Parallel Processing
B+ tree index
No page cleaners
It is the Communication buffer between the local application and its associated Agent.
Local Error Handler
For heavy update transactions, decrease this value below default.
Percentage of changed pages in Buffer pool at which the asynchronous page cleaners will be started, if they are not currently active.
For heavy update transactions, increase this value below default.
Allocates space on demand
The File Manager of operating system allocates and manages space
System Managed Space
Increase this value if there is a problem with lock escalation.
Memory that holds information about locks held by all applications concurrently connected to the database
Decrease this value if there is a problem with lock escalation.
Report display form
Report layout form
A hierarchy can be used as a drill path
The destination is shown as part of the other.
A hierarchy cannot be used as a drill path
The Source is shown as part of the other.