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.
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: