Solved

can't see SQL for a session

Posted on 2011-02-15
9
1,049 Views
Last Modified: 2012-05-11
Hello,

In oracle 11g, why maybe I can't see sql for a session.

Thanks

Regards

bibi
0
Comment
Question by:bibi92
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
I don't understand.  What are you asking?
0
 
LVL 51

Expert Comment

by:HainKurt
Comment Utility
"see sql for a session" ????
0
 

Author Comment

by:bibi92
Comment Utility
SQLADRESS is null but a query is running.
0
 
LVL 51

Expert Comment

by:HainKurt
Comment Utility
what does this mean?

"SQLADRESS is null but a query is running"
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:bibi92
Comment Utility
SQLADRESS is 000000 but a query is running.
0
 
LVL 51

Expert Comment

by:HainKurt
Comment Utility
sorry but we are not watching your monitor :) we dont know what you are talking about...
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
How do you know the session with sql address 000000 is the one you need to be looking at?
0
 
LVL 5

Accepted Solution

by:
manzoor_dba earned 500 total points
Comment Utility
Hi,

You need to used sql_address as well as sql_hash_value...

Query the below inorder get the sqls which are currently running.

select s.sid, s.serial#, t.sql_text from v$session s, v$sqltext t
where s.sql_address = t.address
and s.sql_hash_value = t.hash_value;

Thanks..
0
 

Author Closing Comment

by:bibi92
Comment Utility
Thanks bibi
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now