Avatar of A_HASSAN
A_HASSAN asked on

Extract the Oracle, and OID performance counters to extrnal flat files

I would like to extract the performance graphs in the Oracle Enterprise manager, and the OID web interface to flat files to display them on an external system, I would be pleased to know how feasable is that?
Oracle DatabaseJava App Servers

Avatar of undefined
Last Comment
Sean Stuber

8/22/2022 - Mon
Sean Stuber

if you mean the graphs from the work load management and tuning pack type information, you can query it directly from the underlying tables,  not however, those are separately licensed.  Even if you don't use the Oracle's tools to view them, just querying them requires a license.
Sean Stuber

oops, I meant to say AWR, not work load manangement,  however the views do overlap.  (DBA_WORKLOAD_*)
ASKER
A_HASSAN

So You mean that by querying such views (DBA_WORKLOAD_*) I can get the the data in the Oracle enterprise manager? what user I can use?
And If I want to get the same for OID performance graphs, what shall I do?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Sean Stuber

you may have to include more than just those views.  There is a lot in OEM, so, exactly what query and which tables/views may vary a lot.  Some of the AWR stuff comes from packages too.

Can you be specific about what information you're looking for? Then maybe we can figure out which table/view(s) you need to query.  Also, check the Oracle Reference manual.  It has descrptions of most of the views and can help you figure out which might contain the information you're interested in.

And last, remember,  just running a SELECT statement on some of these requires you to purchase a license.  Don't try to query them yourself in order to avoid licensing.
ASKER
A_HASSAN

I am intereseted about the CPU, and memory figures in the oracle enterprise manager, as well as the OID statiscs, as response time, number of wrong queries (not found).
ASKER CERTIFIED SOLUTION
Sean Stuber

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question