Improve company productivity with a Business Account.Sign Up

x
?
Solved

can't see SQL for a session

Posted on 2011-02-15
9
Medium Priority
?
1,064 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 79

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34897061
I don't understand.  What are you asking?
0
 
LVL 61

Expert Comment

by:HainKurt
ID: 34897417
"see sql for a session" ????
0
 

Author Comment

by:bibi92
ID: 34900004
SQLADRESS is null but a query is running.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
LVL 61

Expert Comment

by:HainKurt
ID: 34900204
what does this mean?

"SQLADRESS is null but a query is running"
0
 

Author Comment

by:bibi92
ID: 34900986
SQLADRESS is 000000 but a query is running.
0
 
LVL 61

Expert Comment

by:HainKurt
ID: 34901138
sorry but we are not watching your monitor :) we dont know what you are talking about...
0
 
LVL 79

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34902514
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 2000 total points
ID: 34903459
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
ID: 34905544
Thanks bibi
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

595 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