Oracle Database Discussions

Hi,

Installing a demo peoplesoft HRMS 9.1 on peopletools 8.51 - Oracle 10g \windows 1GB ram

Last part of creating temp table is giving this error


Building required indexes for GPJP_RAW4_TAO
- SQL Error. Error Position: 41 Return: 604 - ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck","seg:kggfaAllocSeg")

I did try to increase but no luck. New or Oracle so any steps \ advice would be greatly appreciated. Thanks in advanced



SQL> alter system set shared_pool_size=90000000;
alter system set shared_pool_size=90000000
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool


SQL> show parameter size

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
bitmap_merge_area_size
integer 1048576
create_bitmap_area_size
integer 8388608
db_16k_cache_size
big integer 0
db_2k_cache_size
big integer 0
db_32k_cache_size

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
big integer 0
db_4k_cache_size
big integer 0
db_8k_cache_size
big integer 0
db_block_size
integer 8192
db_cache_size
big integer 48M

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
db_keep_cache_size
big integer 0
db_recovery_file_dest_size
big integer 0
db_recycle_cache_size
big integer 0
global_context_pool_size
string
hash_area_size

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
integer 131072
java_max_sessionspace_size
integer 0
java_pool_size
big integer 24M
large_pool_size
big integer 0
max_dump_file_size
string UNLIMITED

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
object_cache_max_size_percent
integer 10
object_cache_optimal_size
integer 102400
olap_page_pool_size
big integer 0
parallel_execution_message_size
integer 2148
sga_max_size

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
big integer 148M
shared_pool_reserved_size
big integer 3774873
shared_pool_size
big integer 72M
sort_area_retained_size
integer 0
sort_area_size
integer 65536

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
streams_pool_size
big integer 0
workarea_size_policy
string AUTO
SQL>