Web Development

Ask something
Discussion Locked

VARRAYs

0 helpful
1 reply

by arvind.narasimhan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
1. Does the use of VARRAYs pose any known performance bottleneck? We are developing a system where we pass data to an Oracle stored procedure (Oracle 8.1.7) from the middle layer (Weblogic 5.1) in a multi-tier system and carrying out INSERTs into multiple tables in a loop.

2. When connecting to the DB, we make use of oracle's thin driver. I was told that the use of OCI to connect to the DB would enhance performance. Is that true?

Thanks in advance

1 reply

by saurabhambekar

i dont think use of varray has any adverse performance problems, only make sure that while designing database/tables the parameter pct_free is defined properly (accroding to your system needs)....

Thax

This discussion is closed to new replies.