Hi,
Asked you sys admin to boost the maximum memory
allowable for a process.
I had that error on a hp box. I do not remember the
name of the parameters. Once the sys admin had changed
the memory process parameters, processes were able to
use way more than 150M of ram.
You can increase the sort_area_size for a particular
session with alter session instead of bouncing the db.
What I've done at a previous client was to change the
session parameters using a database logon trigger who
was checking in a table what sort/hash values to put
for each user.
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> a
écrit : > This weekend I was rebuilding a large table
and when
> it came time to rebuild
> the indexes, I cranked the SORT_AREA_SIZE up to 1/2
> gig. It bombed off with
> an ORA-04030. I kept reducing the SORT_AREA_SIZE
> (bouncing the instance to
> make the change) until I got it down to 150-meg.
> Then everything ran fine. I
> discussed this with my Unix system administrator and
> he felt everything was
> fine from his end. I ran Oracle's maxmem utility and
> received:
>
> oracle.fin7>maxmem
> Memory starts at: 5369596416 (1400d8a00)
> Memory ends at: 6399795195 (17d751ffb)
> Memory available: 1030198779 (3d6795fb)
>
> So it seems like I could have SORT_AREA_SIZE much
> higher than 150-meg. The
> indexes built fine, but I am curious about the
> problem. Any ideas?
>
> Oracle 8.1.6 (until Oracle gets a good 8.1.7
> version)
> Compaq Tru64 4.0E
> 4-cpu.
> 4-gig. of system memory.
> shared_pool_size = 400-meg
> This is the only instance on this server.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail :
http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue May 28 2002 - 13:44:24 CDT
