• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to find session details in Oracle database

Query to get session details in oracle database

August 8, 2021 by techgoeasy 1 Comment

Many times DBA need to look at the session details for analysis. The details include sql_id, stats, locking, wait events. Here I am giving Query to get session details in oracle database, how to get the sql text from sid in oracle, how to check inactive sessions in oracle, how to check active sessions in […]

Filed Under: Oracle, Oracle Database, Oracle Ebuisness Suite Tagged With: How to find session details in Oracle database

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle
  • How to find concurrent request id from Sid or spid
  • how to check recycle bin in oracle: Purge, enable/disable
  • how to check fra size in oracle: Location, usage, change size

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us