REPOST: Re: shared pool size

On Sat, 29 Dec 2001 19:59:58 +0100, "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote:

>Now in my database (Oracle8i PE, v8.1.7.0.0) shared pool size is 4MB.
>During the process of creating Designer6i (Rev 4) repository while
>installing "RM_ELEMENT" view I get error message that there is not
>enough shared pool (memory)! So, how to enlarge the shared pool? BTW,
>what is this shared pool for?

It appears you are consistently asking RTFM questions. You can easily find the definition of what the shared pool is in the Oracle Concepts Manual , you can find recommendations on sizing the shared pool in the Designer Installation documentation, and that will learn you 4 Mb is just plain ridiculous. You can from the docs also learn which parameter in init<sid>.ora you have to change to resize the shared pool.
Please start reading docs or take some courses, please use http://tahiti.oracle.com as I advised you before, please stop boring this group to death

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

• WAS CANCELLED BY =======: Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed.direct.ca!look.ca!wn1feed!wn3feed!worldnet.att.net!198.6.0.123!uunet!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: Sybrand Bakker <oradba_at_sybrandb.demon.nl> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <q9bs2uo9pimbnodgounaujhuk9upsa3otb_at_4ax.com> Control: cancel <q9bs2uo9pimbnodgounaujhuk9upsa3otb_at_4ax.com> Date: Mon, 31 Dec 2001 07:18:43 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.q9bs2uo9pimbnodgounaujhuk9upsa3otb_at_4ax.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788891 26548 166.102.15.34 (31 Dec 2001 08:54:51 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:54:51 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Sat Dec 29 2001 - 14:59:03 CST