SQL Optimizer for Oracle comes in 32-bit and 64-bit versions to match your Oracle client. One will need the 32-bit version of SQL Optimizer if one is using the 32-bit Oracle client and the 64-bit version of SQL Optimizer if one is using the 64-bit Oracle client.
The user account that one uses with SQL Optimizer will need to have certain permissions set depending on the tasks you wish to perform. One can find a list of these permissions by accessing the Help menu item and choosing the Database Privileges item in the Welcome to SQL Optimizer category. If one are not able to grant these permissions on your own, one can show this help screen to your database administrator and they can grant them for you. There is also a Database Privileges Script available which contains the SQL code for granting the desired privileges. Once one has their SQL Optimizer user account ready on your database, one is ready to set up the connection.
SQL Optimizer for Oracle supports TNS, Direct and LDAP connections to your Oracle database. In this example, is going to show how to create a connection using TNS. To setup the connection, open the Connection Manager by clicking on the Connection item and choosing Open Connection Manager. Enter the username and password and choose the database one wishes to connect to. One can also choose how to connect to the database - as a normal user, SYSDBA or SYSOPER. One can instruct SQL Optimizer to remember one’s database password. If using multiple Oracle homes, choose which home one wants to use. Once finished, click on Create and the new connection is ready to be used. Once the user is created, validate that one has privileges to access the functions needed to by opening the dropdown in the Privileges column. This dropdown shows exactly what privileges need granted should one want to access these modules in the future.
