Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1063
  • Last Modified:

can't see SQL for a session

Hello,

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

Thanks

Regards

bibi
0
bibi92
Asked:
bibi92
  • 3
  • 3
  • 2
  • +1
1 Solution
 
slightwv (䄆 Netminder) Commented:
I don't understand.  What are you asking?
0
 
HainKurtSr. System AnalystCommented:
"see sql for a session" ????
0
 
bibi92Author Commented:
SQLADRESS is null but a query is running.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
HainKurtSr. System AnalystCommented:
what does this mean?

"SQLADRESS is null but a query is running"
0
 
bibi92Author Commented:
SQLADRESS is 000000 but a query is running.
0
 
HainKurtSr. System AnalystCommented:
sorry but we are not watching your monitor :) we dont know what you are talking about...
0
 
slightwv (䄆 Netminder) Commented:
How do you know the session with sql address 000000 is the one you need to be looking at?
0
 
manzoor_dbaCommented:
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
 
bibi92Author Commented:
Thanks bibi
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now