Database Administration (MOSC)

MOSC Banner

my database has 2 default buffer pools ?

edited Aug 25, 2022 6:47AM in Database Administration (MOSC) 5 commentsAnswered

Im sure thats not right ?

how do I remove the one ?


SQL> l

 1* select * from v$buffer_pool

SQL> /


    ID NAME         BLOCK_SIZE RESIZE_STA CURRENT_SIZE  BUFFERS

---------- -------------------- ---------- ---------- ------------ ----------

TARGET_SIZE TARGET_BUFFERS PREV_SIZE PREV_BUFFERS  LO_BNUM  HI_BNUM

----------- -------------- ---------- ------------ ---------- ----------

 LO_SETID  HI_SETID SET_COUNT   CON_ID

---------- ---------- ---------- ----------

     3 DEFAULT          8192 STATIC       3840   470040

    3840     470040     0      0     0     0

     9     12     4     0


     8 DEFAULT          32768 STATIC        64    2020

     64      2020     0      0     0     0

    29     32     4     0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center