Geneate report from OEM Grid Options

[NAVEEN KP]

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

[burleson]

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!