Tag Archives: SQL Developer

Purge a single sql_id from the shared pool

By | |
Leave a comment

When you want to flush or purge just a single (or a few) statement from the Shared Pool you can use the following query (all on a single line in SQL Developer e.g.):

exec for c in (select address, hash_value from v$sqlarea where sql_id='3hab0nxcfsxyj') loop sys.dbms_shared_pool.purge(c.address||','||c.hash_value,'C'); end loop;

-- If and only if the first argument is a cursor address and hash-value,
--        the flag parameter should be set to 'C' (or 'c').

Happy flushing!

Oracle SQL Developer and a SQL Server Instance

By | | ,
9 Comments

Sometimes… as Oracle DBA you need to connect to SQL Server (with Oracle SQL Developer and jTDS plug-in installed).

When using ‘SQL Server Management Studio’, the ‘Server name’ is in the format:

SERVERNAME\INSTANCE.

This won’t work in SQL Developer:

Status : Failure -Unknown server host name 'SERVERNAME\INSTANCE'.

This can be solved using the ‘hostname’ in the next format in SQL Developer:

SERVERNAME;instance=INSTANCE

For me it worked :)