CODEWITHSUNDEEP
sqloracle-databaseoracle11goracle10g
Peter Penzov
Peter Penzov

Reputation: 1716

Differences between Oracle platform versions

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?

I don't have access to test environments of production systems to check the tables differences.

Upvotes: 0

Views: 104

Answers (2)

Álvaro González
Álvaro González

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

Pavel
Pavel

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

Related Questions