Oracle Exadata Express Service – Kicking the Tires (Part 6 – Managing your Instance)

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

One of my favourite views (that not many people know about apparently) is the Instance Viewer, which gives you a great overview of the current status of your database and what it is doing.

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!).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s