Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: SQL Text for a Particular Session SID/ users current sql

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    SQL Text for a Particular Session SID/ users current sql

    select sql_text from v$sqltext t, v$session s
    where t.address = s.sql_address
    and s.sid = &SID
    order by piece
    /

+ Reply to Thread

Similar Threads

  1. To find the current status of database
    By devesh_ocp in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 04-25-2012, 11:02 AM
  2. Query to display all current database locks for Oracle Applications users
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-04-2011, 12:24 PM
  3. Get the OS Process ID from the SID for a Database session
    By Hemant in forum Database Scripts
    Replies: 0
    Last Post: 11-02-2011, 07:41 PM
  4. Count Current Forms Application Users Connected to the Application
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 03:25 PM
  5. Find Current Patchset Level For Oracle Application Modules
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-30-2011, 12:42 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics