Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Geneate report from OEM Grid
NAVEEN KP
post Feb 6 2012, 01:27 AM
Post #1


Member
**

Group: Members
Posts: 23
Joined: 25-September 10
From: Bangalore
Member No.: 43,913



Hi Experts,
Can we collect information(generate report) about user sessions connected, database hit ratios, memory usage and other system metrics of all target databases from OEM grid control repository database. Which tables/views in repository DB will be holding these informations. suggestions much appriciated. thanks
Go to the top of the page
 
+Quote Post
burleson
post Feb 6 2012, 07:12 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,537
Joined: 26-January 04
Member No.: 13



Hi Naveen,

>> Which tables/views in repository DB will be holding these informations

From OEM, who knows?

My Guess is that you may be referrring to the statspack hostory tables or the dba_hist tables if you have purchased the required performance and disgnostic packs:

http://dba-oracle.com/googlesearchsite_pro...awr%7Cstatspack



Remember OEM is a "crutch" for beginners who don't know the dictionary.

Click here and I'll mail you a free dictionary poster with these tables:

http://www.rampant-books.com/poster_oracle_database.htm

PLEASE, take the time to leran the basic structures and don;t reply on GUI like OEM!!

Good Luck!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st October 2014 - 11:14 AM