In case you need to analyze some complex queries you can do quick visualization of the query using nice feature of sqldeveloper: Query Builder.

Just enter your query to sqldeveloper tab “Worksheet” and switch to second tab “Query Builder” so you can see visualization of your query.

You can also build your query directly in “Query Builder” by drag and drop tables from Connections Navigator display.

Have a fun 🙂

Tomasz

This article presents how you can control access path for a table.

Access path – how Oracle will read data from a single table. If a hint specifies an unavailable access path, then the optimizer ignores it.

it’s recommended to read following article:

Hints to control Join Operations 11g

Continue reading →

In case you don’t have Oracle Enterprise Manager at hand you can always generate quick reports in sqldeveloper that will show activity on your database.

Oracle metrics

There are tones of metrics which are collected by database on regular bases and a lot of them are very interesting.

Metrics definition can be found in view V$METRIC. There are about 200 metrics in 11g some examples of them below

Continue reading →

There are a lot of options which can be used in database. Not all are available in your database. It depends which version of database you are using (standard/enterprise or else)  or if a given option is active/tuned off/on. You can find details in V$OPTION.

select * from v$option;

PARAMETER                                 VALUE
----------------------------------------- -----
Active Data Guard                         FALSE  
Advanced Compression                      TRUE  
Backup Encryption                         TRUE  
Basic Compression                         TRUE  
...
Spatial                                   TRUE  
Streams Capture                           TRUE  
Unused Block Compression                  TRUE  
XStream                                   TRUE  

 64 rows selected

Continue reading →