Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
A large percentage of In Oracle time for the object is spent accessing one partition.
| Description | |
| What to do next | Perform the following options: n Examine the In Oracle activity of the partition, in the Partitions tab. Check if the massive activity spent accessing the partition is abnormal. n Examine the activity of statements accessing the partition in the Activity workspace. |
| Advice | Perform one of the following options: If the partition is a table partition: n Create local or global indexes for statements that access the partition. n Subpartition the partitions. n If the partitions are not balanced well, consider building the partitioned table with new partition keys. If the partition is an index partition: n Subpartition the partitions. n Add more columns to the index to improve filtering. |
No comments:
Post a Comment