Oracle Dynamic views

The Oracle server provides a number of standard views to obtain information on the database and

instance. These views include:

V$SGA: Queries the size of the size of the instance for the shared pool, log buffer, data buffer

cache, and fixed memory sizes(operating system-dependent).

V$INSTANCE: Queries the status of the instance, such as the instance mode, instance name, startup time, and host name.

V$PROCESS: Queries the background and server processes created for the instance.

V$BGPROCESS: Queries the background processes created for the instance.

V$DATABASE: Lists status and recovery information about the database name, the unique database identifier, the creation data, the control file creation date and time, the last database checkpoint, and other information.

V$DATAFILE: Lists the location and names of the data files that are contained in the database. It includes information relating to the number and name, creation date, status(online or offline), enable(read-only, read-write), last data file checkpoint, size, and other information.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7875565/viewspace-920876/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7875565/viewspace-920876/