I'm trying to figure out some security parameter but I'm not sure how meaningful they are.
I've put together some script to get information like the Buffer Cache Hit Ratio (v$sysstat), Index Hit Ratio (v$sql), Sort Ratio (v$sysstat), Library Cache Hit Ratio (v$librarycache), Dictionary Cache Hit Ratio (v$rowcache), latch contention (v$latch, v$latchholder, v$latchname), shared pool reloads (v$librarycache) and so on. The mentioned Views are the base to get the information.
Are the information from these views meaningful or do I have to take snapshots and generate reports with Statspack to get useful information. I'm afraid that the information are just information for that point in time rather than for a long time period (since the SID is installed). So, they are not really useful to tune the database due to this information.
What's the best way to get useful information(parameter)? And how get Statspack the information for the reports?
Thanks a million for your help!