Database - RAC/Scalability (MOSC)

MOSC Banner

global cache statistics missing in 10g

edited Feb 18, 2009 9:18PM in Database - RAC/Scalability (MOSC) 5 comments
 Hi all,

there are missing global cache statistics in v$sysstats in Oracle 10g compared to 9i - e.g. "global cache gets" and many others. Query

select count(*) from v$sysstat where name like 'global%'

returns on Oracle 9i '31', on Oracle 10g only '7'.

Do I need to setup some parameter or do these stats no  more exists? Regarding the documentation there should be still available.

Thanks

Richard

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center