This is not new but I’ve learned about it last week 🙂 from one of developers when reviewing codes with them for the plan to change the sequence’s current value. Normally I would drop the sequence and create it with START WITH to a new desired number. However, my approach will obviously invalidate all dependencies …
Change sequence’s current value (CURRVAL) without dropping it Read More »
Quick bullet points from reading the Transparent Performance Improvement: Real Native Compilation from the PL/SQL Enhancements in Oracle Database 11g white paper: The PL/SQL is an interpreted language but it is not just like other interpreted languages , e.g. BASIC, where the code is processed statement by statement at the run time. The PL/SQL code …
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 …
I must admit that I’ve rarely done database export from a higher version and import into a lower one. Most of the time it will be either same version (between production, UAT, test or development), or to a higher one in the upgrade scenario. I got an import error ORA-39142: incompatible version number when attempting to …
Import Data Pump ORA-39142: incompatible version number Read More »
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 …
Mumbai – Free Performance Analysis Tool for Oracle Database Read More »
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 …
Easy Connect (EZCONNECT) Naming Method with Instance Name Read More »
