Posted: February 11, 2012 in Random Posts

Java Tutorials

To know the current user in Oracle

select user from dual;

Steps to know list of users in the Oracle database.

Connec to dba user

conn sys/password as sysdba;

execute below query to get list of users

select * from dba_users;

To select only user names:

select username from dba_users;

To know the full details about the user:

select * from dba_users where username=’scott’;

To get the Table space name:

select tablespace_name from dba_tablespaces;

To list the username and size of the user:

select owner,sum(bytes) from dba_segments group by owner;

View original post

  1. Hipolito Handelsman says:

    I don’t normally comment but I gotta say thankyou for the post on this great one : D.


  2. credit card consolidation says:

    certainly like your website but you have to check the spelling on quite a few of your posts. Several of them are rife with spelling issues and I in finding it very bothersome to tell the truth then again I’ll certainly come again again.


  3. Eva Angelina says:

    Very good info can be found on site.


  4. blackjack strategy card says:

    Its such as you read my thoughts! You appear to understand so much about this, like you wrote the e-book in it or something. I believe that you can do with a few p.c. to power the message home a little bit, however instead of that, this is excellent blog. A fantastic read. I will certainly be back.


  5. physician assistant job description says:

    You have remarked very interesting details! ps nice internet site.


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s