Re: Huge Database - Performance Problem

Larry (104105.3062_at_CompuServe.COM) wrote:

: re-link applications? That is, if I have compiled and linked C
: programs, and the sgapad is re-sized, do I have to re-compile and
: re-link each C program? This has been a huge debate at our site.
: Our dba's were cautioned by Oracle that re-sizing the pad was a
: risky, huge task, and all our applications would have to be
: re-validated! I don't think this is true. I've trying for about
: 3 months to get straight truth about this.

I've relinked the SGAPAD a number of times to fit the SGA and have never had to relink the applications again. Anyone care to correct me?

Leng.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344
WWW: http://www.vut.edu.au/voug