Sunday, February 9, 2014

Important Dynamic Performance View

Some Important Dynamic Performance  View ,

• V$CONTROLFILE: Lists the names of the control files
• V$DATABASE: Contains database information from the control file.
• V$DATAFILE: Contains data file information from the control file
• V$INSTANCE: Displays the state of the current instance
• V$PARAMETER: Lists parameters and values currently in effect for the session
• V$SESSION: Lists session information for each current session
• V$SGA: Contains summary information on the system global area (SGA)
• V$SPPARAMETER: Lists the contents of the SPFILE
• V$TABLESPACE: Displays tablespace information from the control file
• V$THREAD: Contains thread information from the control file
• V$VERSION: Version numbers of core library components in the Oracle server
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...

  • Lock Script
    Hii All  Today i'm posting  lock script. sometime some session block to other session. This situation is very critical because our wh...
  • IMPOTED Excel/Text File Data USING TOAD
    IMPOTED Excel/Text File Data Into Oracle Table Using TOAD Step 1 :  Open TOAD. Step 2 :  Write the following query to create a test tabl...
  • Audit - Enabling or Disabling Audit Trail
    Auditing in Oracle Database The Oracle Server provides several auditing options. The following three types of audits are provi...