How to view the database have long link statements-CodePudding

How to view the oracle database in the presence of long links statements?

CodePudding user response:

The

refer to the original poster qq_21815305 response:

how to check for long link statements in the oracle database?

Don't quite understand your question, to know more,

CodePudding user response:

It is recommended to use oracle's own em management page to view the relevant session, may look up to

CodePudding user response:

In the V $SESSION have a login time fields: LOGON_TIME, of course, if the RAC, please use the GV $SESSION view

CodePudding user response:

If it is pure connection SESSION on the view of time, such as the upstairs said, direct view V $SESSION LOGON_TIME fields,

If you want to view the long running SQL session, you can also query the v $session_longops, reference script: sess_longops