Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to check Total memory used by Oracle and which user are using more memo

608897Jul 30 2009 — edited Jul 30 2009
Hi,

I am using oracle version 10.2.0.4 on Windows 2003 server SP2.

1. How can i check the "Total memory" used by Oracle

2. Which users are using more CPU resources.

Thanks and Regards
Amit
This post has been answered by Chandan Tanwani on Jul 30 2009
Jump to Answer

Comments

Ahmer Mansoor
Try this,
SELECT SYS_CONNECT_BY_PATH(ID,' '), SYS_CONNECT_BY_PATH(name, ' ') "Name"
FROM testtable
where level=(select count(*) from testtable)
START WITH id=1
coNNECT BY PRIOR id+1 = id;
Rgds,

Ahmer

N.B.: To make a good reputation on forums, and if you want that your questions will be answered timely. Kindly adopt the habit of marking your questions closed as soon as you get the answer. and be courteous to the people who trying to help.
814929
Thanks for your reply. But, No. This is not the output of my requirement.

output should be ....

ID 1 2 3 4
Name John Mckensy Valneech Zeebra

Each value should be inside the columns...
Ahmer Mansoor
Pls See

http://oracletuts.net/tutorials/three-ways-to-transpose-rows-into-columns-in-oracle-sql/

Rgds,

Ahmer


N.B.: To earn a good reputation on forums, and if you want that your questions will be answered timely. Kindly adopt the habit of marking your questions closed as soon as you get the answer. and be courteous to the people who trying to help.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 27 2009
Added on Jul 30 2009
2 comments
142,282 views