The basic format of the The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.
But it seems that I will need to download and install Oracle client software also, which one do I use if I am on Windows 10?
everyone, Just a little update on this old (but quite helpfull) post : don't try to use a symbolic link on Windows. I downloaded and installed the Oracle SQL Developer to connect to an already existing Oracle 11g database.
By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.
They are just for client access, so it is possible for the database to be created properly and the files not exist.
SQL developper doesn't seem to know how to use it. But it seems that I will need to download and install Oracle client software also, which one do I use if I am on Windows 10?
SQL Developer will look in the following location in this order for a file $HOME/.$TNS_ADMIN/TNS_ADMIN lookup key in the registry /etc/( non-windows ) $ORACLE_HOME/network/admin/Local Machine\SOFTWARE\ORACLE\ORACLE_HOME_KEY Local Machine\SOFTWARE\ORACLE\ORACLE_HOME If your file is not getting recognized, use the following procedure: Define an environmental variable called TNS_ADMIN to point to the folder that contains your file.
The landmark book "Linux for the Oracle DBA" is a complete guidebook of expert tips and secrets for automating Oracle database administration.
It's packed with working Linux scripts and tools to make any DBA look like a guru.