Hi all!

Working on Oracle v8i with OS as Win2k/NT!

Many thanks for the info!

I am again facing a similar problem:

My Temporary Tablespace which was sized at 200m with autoextend on has once again shot upto 1.65GB all on a sudden.My DB is on NOarchivelog Mode and Temporary Tablespace is Dictionary managed.

Do I need to reduce the SHARED_POOL_SIZE which is at present 27MB,with LARGE_POOL_SIZE at 20mb and JAVA_POOL_SIZE at 20MB.

What I believe I am experiencing paging and Swapping because of over usage of memory and disksorting to memory sorting is less than 3% as per your query which you sent me recently!

So what should be done to avoid this problem as this is really eating my head!

Loking forward to hearing from you at the earliest!