Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

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
post Feb 6 2012, 01:27 AM
Post #1


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
post Feb 6 2012, 07:12 AM
Post #2

Advanced Member

Group: Members
Posts: 13,577
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:


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:


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: 22nd October 2017 - 09:38 PM