1) Buffer Cache hit ratio. This should be high as the data is needs to be read from cache. Also the disk i/o is less if it is read from cache.
2) Cache hit ratio
3) Library cache.. where sql,pl/sql, re-usable sql are placed
4)soft parsing should be high compared to hard parsing... as the time spent in parsing sqls is less softparsing. (Softparsing->hardParsing->Explain plan)
2) Cache hit ratio
3) Library cache.. where sql,pl/sql, re-usable sql are placed
4)soft parsing should be high compared to hard parsing... as the time spent in parsing sqls is less softparsing. (Softparsing->hardParsing->Explain plan)
