Rlwrap packages for Linux x86_64 and Solaris SPARC 64

According to some requests I built rlwrap packages for Linux (RedHat compatible distributions) 64 bit (x86_64) and for Sun Solaris SPARC 64 bit. Packages for Solaris were built on 9 version but also working on version 10 (tested of course).

download readline package for Solaris (9, 10) SPARC.
(md5 checksum: 523e0169e79e07fab595d778927f7165)

download rlwrap package for Solaris (9, 10) SPARC.
(md5 checksum: 0ea2a86c4e7817a36a5b1d6a25b61269)

download rlwrap package for Redhat EL (3, 4) and Enteprise Linux x86_64 architecture.
(md5 checksum: b2c91b2057f76431d92a788d4e79d42d)

To install rlwrap on Solaris execute following commands:

gunzip readline-5.2-solaris9-sparc.gz

gunzip rlwrap-0.28-solaris9-sparc.gz

pkgadd -d readline-5.2-solaris9-sparc

pkgadd -d rlwrap-0.28-solaris9-sparc

As readline library is located in /usr/local/lib don't forget to add that line to LD_LIBRARY_PATH.
Also put following line to your .bash_profile:

alias sqplus='/usr/local/bin/rlwrap sqlplus'

To install rlwrap on Linux (RH EL, EL, WBL) execute following commands:

rpm -ivh rlwrap-0.28.rh4.x86_64.rpm

Also put following line to your .bash_profile:

alias sqplus='rlwrap sqlplus'

Posted on Friday, February 16, 2007 Comments [1]

9i R2 Installation article for Enterprise Linux

I prepared (as I promised to Jer long time ago on OTN forums) new installation article for 9i release 2 for Enterprise Linux (shipped by Oracle). This paper is valid for x86 and x86_64 architecture.

Hope that helps.

Posted on Thursday, February 15, 2007 Comments [7]

WT_...?: How to check DB link validity

We found this beauty in statspack report. This query was executed 7 times during 15 minutes period. Each execution had 23592 LIO, 23372 PIO and Cost 2144.
As we later found, that query was used to check validity of database link.

SQL> SELECT COUNT(*) FROM SCHEMA_NAME.SOME_BIG_TABLE A1;



Execution Plan

----------------------------------------------------------

   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=2144 Card=1)

   1    0   SORT (AGGREGATE)

   2    1     INDEX (FAST FULL SCAN) OF 'PK_ID_SOME_BIG_TABLE' (UNIQUE

          ) (Cost=2144 Card=2725982)



Statistics

----------------------------------------------------------

        760  recursive calls

          0  db block gets

      23592  consistent gets

      23372  physical reads

      12932  redo size

        200  bytes sent via SQL*Net to client

        240  bytes received via SQL*Net from client

          2  SQL*Net roundtrips to/from client

         28  sorts (memory)

          0  sorts (disk)

          1  rows processed

What can I say? Don't try this at work...

Posted on Wednesday, February 14, 2007 Comments [2]