PL / SQL Developer 6 Session Management
The session management function of PL / SQL Developer 6 is excellent, and all commonly used session management functions can be completed, the main features are:
The session management function of PL / SQL Developer 6 is excellent, and all commonly used session management functions can be completed, the main features are:
The session management function of PL / SQL Developer 6 is excellent, and all commonly used session management functions can be completed, the main features are:
Query session list information
End session
Session tracking
Export session information
Query the specific details of the session
Currenuals currently open
SQL that session is currently executing
Session all statistics
Session Currently locked object
You can also customize information-related information according to your personal requirements.
Below I will fully introduce the PL / SQL Developer 6 session management function:
Open the Tools / Sessions menu, the session window is shown below:
The intermediate main area shows a list of user session information of the current Oracle database
The bottom is displayed in the selection of sessions.
User session information list compares common field information description
UserName: Oracle User Name of Session Login
SID: Session SID number
STATUS: Session: Active: Inactive: Univered; Kill: End;)
Osuser: Concital Login Machine Operating System User Name
Machine: Grunge login machine name
Program: The program name of the session login
Module: Session Registration Module Name
Action: Active name for session registration
Logon Time: Session Login Time
Process: Session in the operating system process number
Session Management Toolbar Description
Session Management Toolbar Description
Session Management Toolbar Description
Each tool corresponds to the order
l refresh
l Auto refresh (let the current session window to refresh once every few seconds)
l End the session (end the currently selected session, equivalent to the alter system kill session)
l Start tracking (debug tracking on the currently selected session)
Equivalent to execution process sys.dbms_system.set_sql_trace_in_session
Note: To perform this function, the current login user must use sys.dbms_system execution permission.
You can empower you through the following statement. Grant Execute on dbms_system to yourusername;
l End Track (Commissioning Tracking for the currently selected session)
l Custom session query (used to customize session query information, strong extension)
Session inquiry information description
Note: The following red marks are places where you customize queries or modifications.
l Cursors: Returns the current selection session to open a cursor
Corresponding SQL statement:
SELECT * FROM V $ OPEN_CURSOR WHERE SID =: SID
l SQL TEXT: Return to the current selection session is executing SQL
Corresponding SQL statement:
SELECT SQL_TEXT FROM V $ SQLTEXT_WITH_NEWLINES
Where address = hexToraw (: sql_address)
And hash_value =: SQL_HASH_VALUE
ORDER by Piece
l Statics: Returns the SQL statement corresponding to the database statistics of the current selection session:
Select name, stats.name, stats.statistic #, stats.value
From V $ SESSSTAT Stats, V $ STATNAME NAMES
Where stats.sid =: sID
And names.statistic # = stats.statistic #
Order by Stats.Value DESC
llics (SQL statement Optimization): Return to the current selection session lock object
Corresponding SQL statement:
Select * from sys.all_Objects a, v $ locked_object b where a.object_id = B.Object_id and b.session_id =: sID
l Wait (I personally customize query): Return to the current selection session waiting for information
Corresponding SQL statement:
Select * from v $ session_wait where sid =: sID
l Event (I personally customized query): Returns event information of the current selection session
Corresponding SQL statement:
SELECT * FROM V $ SESSION_EVENT
WHERE SID =: SID ORDER by Total_Waits DESC
Advanced features: custom session query
You can add session monitoring information. Wait and EVENT information in this article are increasing by custom session queries. After adding a project, you will automatically add a tab in the session window, and the caption is the tab of the tab. Query is returned Monitoring information query statements, query statements can use all fields in the V $ SESSION view to bind variables such as SID,: Username,: SQL_Address, and more.
2005-03-17
Yasheng
