Over at the ColdFusion Muse by Mark Kruger he posted an interesting blog entry titled “Coldfusion and Oracle 8i Performance”. It is an interesting read and shows how important it is to fine tune any Enterprise system.
To see all the defined parameters and other settings we like to recommend the use of Oracle’s own SQLDeveloper application. It is a great tool, not only for setting up tables, but for reporting as well. In my works with other developers I have seen that many people don’t know the report functionality of SQLDeveloper.
With the Reports one is able to fine tune all the parameters of the Oracle database and also see the connected users, see the most used SQL’s and other things. Here is a screenshot of the “All Parameters” of the Reports.
This is taken from the current 1.2.x release of SQLDeveloper which is available for free. You can also define your own reports and have them spiced up with some nice graphics. To read more about it I suggest you head over to the product side of SQLDeveloper.