-
编辑 删除
Share pool内存调整
share pool的调整主要在2个方面,library cache和dictionary cache的调整，调整需要先确定调整的关键目标指标，主要通过以上两个内容的视图（v$librarycache）或计算而来。library cache和dictionary cache不能单独进行调整，主要是调整share pool大小，减少分析时间。[@more@]SQL> desc v$librarycacheName---------------------------NAMESPACEGETS GETHITSGETHITRATIOPINSPINHITSPINHITRATIORELOADSINVALIDATIONSDLM_LOCK_REQUESTSDLM_PIN_REQUESTSDLM_PIN_RELEASESDLM_INVALIDATION_REQUESTSDLM_INVALIDATIONS1、share pool8i:一般不
-
编辑 删除
How many partitions can Oracle partitioned?
Oracle9iR2: Tables can be partitioned into up to 64,000 separate partitions. Oracle10gR2： Tables can be partitioned into up to 1024K-1 separate partitions. ■ Tables greater than 2GB should always be considered for partitioning. ■ Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only.[@more@]The end.
