Saturday, December 24, 2016

SQL Developer: DBA

Recently, I came across DBA Navigator feature in SQL Developer, that really helps DBA or Developers to administer Oracle Database right from your desktop.

How to access DBA Navigator:
Open SQL Developer --> Go to View --> DBA

What are all features, it enables to users:
  • View database instance overall status using Instance Viewer(IO, wait events, storage, log switches, and processes)
  • Access ADDM/AWR/ASH reports
  • Security(Users/Roles) Administration
  • Storage(Datafiles/Tablespaces) Administration
  • Many more....

No comments:

Post a Comment

Provide your thoughts !