Friday, January 23, 2015

What is the difference between a BEQUEATH connection and an IPC connection?

›
A bequeath connection runs on your local host bypasses the listener the protocol creates the server process for you directly An IPC (I...
1 comment:
Thursday, January 22, 2015

A complete script for gathering system, data dictionary and fixed objects stats

›
alter session set nls_language='AMERICAN'; set timing on set serveroutput on set lines 200 col pname format a20 BEGIN DBMS_STATS.GA...
Wednesday, January 21, 2015

How to relocate the block change tracking file

›
To relocate the block change tracking file you have two options: 1) shutdown database, mount database, update control file, open database ...
Tuesday, January 20, 2015

Query the registry!

›
To view the different options installed in the database, you should use DBA_REGISTRY, as follows: set lines 200 pages 100 col comp_name f...
Friday, January 16, 2015

How to use regexp_substring to extract the 5-digit version

›
SELECT BANNER, REGEXP_SUBSTR(BANNER, '[[:digit:]]+[[:punct:]]+.[^-]{1,}',1,1) "5 digit Version" FROM V$VERSION WHERE BAN...
Monday, January 12, 2015

Getting ORA-01031: insufficient privileges when data dictionary table is being used in a view

›
I must admit I have been consulted in these situations before, but since then I had forgotten how it worked and failed to take notes on how ...
Tuesday, January 6, 2015

How to use multiple delimiters in awk

›
When creating a script for cloning, I wanted to perform some initial checks. One of them was to make sure the listener for the source datab...