How to check Data source:
Login to weblogic console. In Domain structure tree, Go to Services, then select Data Sources,
On the Summary of Data Sources page, click the data source name.
Select the Monitoring: Statistics tab.
Statistics are displayed for each deployed instance of the data source.
How to check Database connection:
YOu need to have db permission to access below query:
select sid, serial#, osuser, machine, program, module from v$session;
SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time FROM V$Session WHERE Status='ACTIVE' AND UserName IS NOT NULL;
History Table:
v$active_session_history
Login to weblogic console. In Domain structure tree, Go to Services, then select Data Sources,
On the Summary of Data Sources page, click the data source name.
Select the Monitoring: Statistics tab.
Statistics are displayed for each deployed instance of the data source.
How to check Database connection:
YOu need to have db permission to access below query:
select sid, serial#, osuser, machine, program, module from v$session;
SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time FROM V$Session WHERE Status='ACTIVE' AND UserName IS NOT NULL;
History Table:
v$active_session_history
No comments:
Post a Comment