Extend Oracle SQL Developer (1) – XML extension – RMAN backup over X days

The idea is simple: Visualize RMAN backup from X days ago.

I would like to see these things: backupset size, how long it took, compression ratio and backup type. Well, good enough, We can create Oracle SQL Developer XML extension (Oracle call it). I would rather name it as user defined report, compare to UDM (user defined metrics) in Oracle OEM Grid Control. It allows us to get report with Chart, Table. And such kind of UDR supports drill down and master-details in the simplest way. It is OK but is not powerful enough for DBAs to have more customized functionality.

I created such report as follows, looks good. Why not Oracle give us: RMAN> list backup size 2 days ago? hopefully they would think about this idea in next release. Otherwise, I have to create real SQL Developer extension by JDeveloper Extension SDK.

Steps:
To create UDR in SQL Developer.

Simple but lot of rooms to improve by Oracle.

Advertisements

About Pang

Oracle DBA working in database, fusion middleware and identity management and cloud.
This entry was posted in SQL Developer. Bookmark the permalink.

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