In the previous post I covered connecting SQLDeveloper to your Exadata Express instance, but how do you do basic DBA level tasks?
Well, SQLDeveloper to the rescue – it has a very nice (albeit fairly minimal) DBA interface.
Assuming you already have a connection to your Instance (this will need to be a user with sufficient privileges – in this case I’ll use the PDB_ADMIN user).
In SQLDeveloper clicking the view menu reveals a DBA menu item.
once you click this you can select your Exadata Express connection and you’ll see a new DBA panela become visible.
From here you can view Database Configuration details such as the Initialisation Parameters, Database Feature Usage etc
since I’m running in a PDB, I’m not sure about the accuracy of some of these figures, since it shows me I’m currently using 262Gb of SGA (but the X20 service should only have 3GB PGA and 3GB SGA). I’m assuming I’m getting insight into the figures from the CDB. I must admit when I first saw these figures I raced back to check I’d signed up for the X20 service and not an entire Exadata Instance to myself!
So how about Importing and Exporting data? Well we can do Datapump Imports and Exports right out of SQLDeveloper
Under the Performance option we can also view ASH and AWR reports – you’ll get a warning about checking licence but the Exadata Express instance allows that option (at the time of writing!).
Under the Security section we can create users
You can create tablespaces directly from SQLDeveloper too
As you can see SQLDeveloper offers a rich enviroment for GUI DBA control over your Exadata Express Instance (and you can always drop down into the SQLcl command-line to perform manual DBA tasks!).