Gangainathan

10+ Years Oracle APPS DBA

Thursday, 30 June 2016

Current Database Account

set termout off
set head off
set termout on

select 'User: '|| user || ' on database ' || global_name,
       '(Terminal='||USERENV('TERMINAL')||
       ', Session-Id='||USERENV('SESSIONID')||')'
from   global_name;

set head on feed on
Posted by Gangainathan at 10:43
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Pages

  • RedHat Enterprise Linux 5.4 Installation
  • How to install Oracle 10g R2 on RHEL 5
  • How to Install Companion On RHEL 5
  • Oracle Database 11g Release 2 (11.2) Installation On RedHat Enterprise Linux 5
  • INSTALLING ORACLE APEX 3.1 ON ORACLE 10g

About Me

My photo
Gangainathan
View my complete profile

Blog Archive

  • ▼  2016 (8)
    • ▼  June (7)
      • Show_user_with_top_io
      • Show_statistics_of_connected_users
      • Rac_balance_delta
      • Logged on Users
      • Invalieds
      • Current Database Account
      • Asadmin with Remote GlassFish
    • ►  March (1)
  • ►  2015 (5)
    • ►  September (1)
    • ►  July (1)
    • ►  March (3)
  • ►  2014 (4)
    • ►  June (1)
    • ►  May (3)
  • ►  2012 (1)
    • ►  May (1)
Simple theme. Powered by Blogger.