Archive | Tool

Oracle 11g SQL Error Logging

We’re working on the installation scripts for an internal PL/SQL applications. Multiple scripts are called from the main one. To capture errors from script execution, normally the spool syntax will be used in the scripts to pipe out all executions into log files, and then later the deployment team members will examine them using find/search […]

Continue Reading 5

Mumbai – Free Performance Analysis Tool for Oracle Database

I found this tool via Karl Arao’s TiddlyWiki under the Performance Database Tools.  This free tool written by Marcus Mönnig called Mumbai has many nifty features focusing on data visualization including session profiling, alert & trace file viewing, 10046 tracing/viewing within the tool, etc. It also integrates with snapper and orasrp. Here are some introductory […]

Continue Reading 1

Easy Connect (EZCONNECT) Naming Method with Instance Name

Oftentimes I use the Easy Connect (EZCONNECT) to connect to a new database just to quickly verify database connectivity. The syntax I usually use is as follows: CONNECT username/password@[//]host[:port][/service_name] CONNECT scott/tiger@host1-vip:1522/RACDB In RAC, this will connect to whatever instance based on the service’s load balancing goal. I just learned that with the 11g net services […]

Continue Reading 3

Book Review: Oracle SQL Developer 2.1 by Sue Harper

I must admit that I rarely use the Oracle SQL Developer because I’m using SQL*Plus, Toad from Quest and PL/SQL Developer from Allround Automations as primary tools for database administration and PL/SQL programming. They’re already providing all functionalities I need. I have nothing against Oracle SQL Developer. Actually it is quite opposite. I really want […]

Continue Reading 1

Powered by WordPress. Designed by WooThemes