Advertisement
ExaGridDba

v$sgastat pools appear per con_id, but not the buffer cache

Oct 4th, 2015
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. One buffer cache per instance IS reported:
  2.  
  3. SQL*Plus: RELEASE 12.1.0.2.0 Production ON Sun Oct 4 15:34:44 2015
  4.  
  5. Copyright (c) 1982, 2014, Oracle.  ALL rights reserved.
  6.  
  7. Connected TO:
  8. Oracle DATABASE 12c Enterprise Edition RELEASE 12.1.0.2.0 - 64bit Production
  9. WITH the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  10. AND REAL Application Testing options
  11.  
  12. SQL> SELECT pool, NVL(pool,name), COUNT( DISTINCT con_id) FROM v$sgastat GROUP BY pool, NVL(pool,name) ORDER BY 1,2;
  13.  
  14. POOL         NVL(POOL,NAME)             COUNT(DISTINCTCON_ID)
  15. ------------ -------------------------- ---------------------
  16. JAVA pool    JAVA pool                                      1
  17. large pool   large pool                                     2
  18. shared pool  shared pool                                    4
  19.              buffer_cache                                   1
  20.              fixed_sga                                      1
  21.              log_buffer                                     1
  22.              shared_io_pool                                 1
  23.  
  24. 7 ROWS selected.
  25.  
  26. Shared pool components break OUT BY container:
  27.  
  28. SQL> SELECT con_id, pool, name, bytes FROM v$sgastat WHERE name = 'SQLA' ORDER BY con_id;
  29.  
  30.     CON_ID POOL         NAME                            BYTES
  31. ---------- ------------ -------------------------- ----------
  32.          1 shared pool  SQLA                         32205512
  33.          2 shared pool  SQLA                          1476168
  34.          4 shared pool  SQLA                         35735376
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement