Reputation: 1716
I want to monitor Oracle database using SQL queries from internal tables. Are there any differences between Oracle for UNIX/Windows/Linux/OS?
In particular, do these tables exist and have the same structure in every platform? Do they change between 10g and 11g?
V$SYSSTAT
V$SESSTAT
v$session
I don't have access to test environments of production systems to check the tables differences.
Upvotes: 0
Views: 104
Reputation: 146630
You can look for the information in Oracle documentation. It's hard to find anything there but since it's published on-line you can use Google or any other search engine and search for "Oracle 10g V$SYSSTAT", "Oracle 11g V$SYSSTAT", etc.
For instance, docs for V$SYSSTATon 10g show the table exists and gives a list of column names, types and other relevant details. It doesn't mention that this information depends on the OS so we can assume it's universal.
Upvotes: 0
Reputation: 61
Yes, internal system views for the same Oracle version are the same on different platforms. System views might be different between Oracle releases.
Upvotes: 2