Language:EN
Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
broken down wait class shows the same information

Broken down wait class shows the same information

Displaying Session-Related Statistics

Displaying Session-Related Statistics

You can display current session information for each user logged on by querying V$SESSION. For example, you can use V$SESSION to determine whether a session represents a user session, or was created by a database server process (BACKGROUND).

You can also query the V$SESSMETRIC view to display the performance metric values for all active sessions. This view lists performance metrics such as CPU usage, number of physical reads, number of hard parses, and the logical read ratio.

Oracle Database 10g: Administration Workshop II 9-13

9-14 Copyright © 2006, Oracle. All rights reserved.

Oracle Database 10g: Administration Workshop II 9-14

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Anaya Agrawal

PageId: ELIFD8A196