Viewing the currently executing SQL in Oracle

Sometimes if you are having a performance problem you might want to know what SQL statements are being run - you can trawl through these to work out what is causing the problem. The v$sql table can be used to view all queries that are being run. [Read More]
Tags: oracle plsql

Script parameters with Oracle

Sometimes you need to pass parameters into your database scripts for variable object names. For example, if your tablespace names are different on live to development, you could do the following for your installation scripts: [Read More]
Tags: oracle plsql