O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Intelligent Segment Resource Estimation

The DBA can use the following dynamic performance queries to find performance problems associated with individual segments. Using segment-level statistics, you can identify top tables or indexes in the database instance and pinpoint the resource-intensive database objects. This information will help to allocate more resources to the database for various processing cycles or job schedules.

  • V$SEGSTAT_NAM has the segment statistics being collected, along with properties of each statistic.

  • V$SEGSTAT is a real-time view that shows the statistic value, statistic name, and other basic information on all segments including the top segments causing buffer busy waits.

  • V$SEGMENT_STATISTICS has all the information from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required