Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Get list of all queries on specific instance

Hi,

I'm new, so i hope it's not a duplicate question, but i can't find the answer...is it possible to get a list of all the queries processed in the last month by one specific oracle instance i'm monitoring?

Thanks

Giulio

Find more posts tagged with

Accepted answers

All comments

Since DPA is not an auditing product, we can get you all of the queries that we OBSERVED running against an Oracle instance. Since we poll once a second, there may be quick, infrequent running queries that are missed. DPA being a performance-centric product, we nor you should really care about those.

Now, for a complete list of queries that we caught that ran against your Oracle instance in the past month, you can query directly against the repo instance:

Step 1: Get the instance ID in question

select id, name from cond -- replace the <id> below with the id value from this query

Step 2: Get the list of queries by SQL_ID

select si.sqlid from con_orasqlid_<id> si, consw_<id> sw where si.hash in (select izho from consw_<id>)

NOTE: This is assuming you have your detail days set to out of the box of 30 days.

Quick Links