-
large pool resize
I have issue the following command.
alter system set large_pool_size=160m;
After 35 minites this command was not complited and I have to cancel the command.
will it be take time to resize?
-
Hi
Whats the version of Oracle and The Operating System
regards
Hrishy
-
Oracle Version is 9.2.07
O/S is RHEL 4
-
Hi
Can you show the output of
show sga and also tell us
how much real memory you have on your server
regards
Hrishy
-
Thanks for your reply.
2GB memory on server and output of show sga is
Total System Global Area 1581849220 bytes
Fixed Size 453252 bytes
Variable Size 486539264 bytes
Database Buffers 1073741824 bytes
Redo Buffers 21114880 bytes
-
query
V$SGA_CURRENT_RESIZE_OPS
V$SGA_RESIZE_OPS
V$SGA_DYNAMIC_COMPONENTS
V$SGA_DYNAMIC_FREE_MEMORY
look session waits
check the alert
-
Hi
When you are carrying out the resize operation do you see something being written to the alert log ? anything strange there
regards
Hrishy
-
Just I have try to resize, It will immediately resized.
So I was not able to query the view as PANDO says.
HRISHY :
When I was facing this problem at that time I had checked in alert log. But there is no problem found or any message found in that.
I have faced this problem 2nd time. Both the time user complaing ORA-04031.
-
Hi
Next time you face this try Pandos suggestion and update this thread we will take it from there
regards
Hrishy
-
Sure i will check and post here.
Thanks to Hrishy and Pando.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|