-
Notifications
You must be signed in to change notification settings - Fork 1
Home
SQL Developer Reports
The SQL Developer Reports are provided as is without any warranty, please review them before using them. These reports are targeted for DBA task in mind, I use them on my day to day activity so I hope they are useful to anyone else.
The reports run on the following version: Version 4.1.3.20
Some of the reports are modified to work on RAC (gv$ views) but others don't. If you need to make it work on RAC please modify them accordingly.
These are standard user reports and they can be imported in the standard way.
Please the read how to do it in the following links:
http://www.thatjeffsmith.com/archive/2015/03/how-to-share-reports/
Allows you to see the log switches on the database per day/hour. The top panel it will show all the history of log switches aggregated by hour. The bottom panel will show the detail of log switches for a day clicked on the top panel.
Supports RAC
Display the long operations happening in the database, nothing complicated.
Allows you to see all the sessions currently running on the database plus more detailed information for a selected session.. The top panel show all the sessions in the database with some generic information. SYSTEM and BACKGROUND sessions are filtered. The bottom panel show session, process, waits, locks and more for a selected session. ##session_browser_unfiltered.xml The same as session_browser.xml but without any filtering.
RAC Supported
Display current locked objects.
Display tablespace total, used, free, %used, %free space usage. Top panel will list tablespaces and their space usage. Bottom panel will show the datafiles for a selected tablespace.
Temporary segments by a user.
Hash, sort segments by a user.
Just a top 10 schemas based on their size.
RAC Supported
Display the list of log sequences already applied to a standby plus other related information.
** RAC Supported **
Display the list of processes (Arch, MRP, RFS, LNS) status. This will display different values if is run in the primary or standby.
** RAC Supported **
Just display the status for the MRP process.
Display standby log file information.
Display lag information, similar to DGMGRL show database. Notice that in RAC environments it might not show accurate results.
Display lag information, similar to DGMGRL show database. Notice that in RAC environments it might not show accurate results.
The following reports are to be run under the sysman user.
Display all the targets registered inside OEM.
List ASM targets.
List cluster and non-cluster databases.
List all the hosts.
List listeners.
List PDBs.
List a target properties like contact, lifecycle Status, platform,etc.
List OEM target types supported.