large pool resize
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: large pool resize

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    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?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Whats the version of Oracle and The Operating System

    regards
    Hrishy

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Oracle Version is 9.2.07
    O/S is RHEL 4

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you show the output of

    show sga and also tell us
    how much real memory you have on your server

    regards
    Hrishy

  5. #5
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    When you are carrying out the resize operation do you see something being written to the alert log ? anything strange there

    regards
    Hrishy

  8. #8
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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.

  9. #9
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Next time you face this try Pandos suggestion and update this thread we will take it from there

    regards
    Hrishy

  10. #10
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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
  •  



Click Here to Expand Forum to Full Width