SQL Navigator for Oracle should have a Add a Datafiles screen that lists all the data files and temporary files in the database.
This screen should contain same info as on the Oracle 10g OEM Storage/Datafiles screen.
The columns should be sortable.
Used (M) should be a bar graph.
Adding this screen will allow DBAs to quickly identify what file systems are used by what datafiles and tablespaces.
This will assist DBAs is planning tablespace/datafile layout across file systems.
If user clicks on a datafile, this should take them to a screen that lists the detail for that particular datafile. See uploaded attachment.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center