When I took a real good look at? Both tablespaces can be customized, but you have to make sure the tablespaces exist in you database before running this script. For later tuning more easily, you may want to gather statistics more deeply at segment level which is more meaningful and helpful, please change the snapshot level into 7 instead of the default level 5.
This statement will modify the snap level to 7 and it will also take a snapshot at the same time. Here I quote a paragraph from Oracle documentation about performance monitoring that can supplement this idea. However, Statspack is available for backward compatibility.
Statspack provides reporting only. Below is the list of online tablespaces in this database which can store user data. Below is the list of online tablespaces in this database which can store temporary data e. Make sure there were no errors in the process by accessing the spcpkg. Comments feed for this article. Ben Eastaugh and Chris Sternal-Johnson. Subscribe to feed. Helios's Blog. So What is Oracle Statspack?
How does Oracle Statspack work? How We can install Oracle Statspack? Here is the steps: Create a unique tablespace for Statspack. Skip to content Oracle Diagnostic Pack: The Oracle Diagnostic Pack provides automatic performance diagnostic and advanced system monitoring functionality.
Share this: Twitter Facebook. Like this: Like Loading Previous Previous post: Move Indexes to 16k Tablespaces. Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:.
Email required Address never made public. Name required.
0コメント