Oracle 7.3 Performance Long Raw vs. Long

From: Steffen Zgodzaj <steffen.zgodzaj_at_snafu.de>
Date: Mon, 24 Aug 1998 22:25:37 +0100
Message-ID: <35E1DA51.DB4D4631@snafu.de>

Hi All,

I'm using Oracle Server 7.3.2 on Siemens OSD2. All our tables will include a long raw column. Because PL/SQL 2.3 doesn't work on long raws, I want to use the column type long. I make sure, that database and client-programms (running on the server to) use identical nls-parameters. So I avoid character set conversation. This scenario enables the use of pl/sql via fetching longs by use of dbms_sql package.

Did anyone test the performance in a long raw / long enviroment? Did you test to compare PL/SQL-trigger (Long) and and OCI-Calls (Long Raw)?

I'm very interested in your experience.

Regards, Steffen Received on Mon Aug 24 1998 - 16:25:37 CDT