반응형
ORA-04031 에러 발생후 Shared Pool Size가 적정한지 확인할때 사용.
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
-- ************************************************
-- Display shared pool advice
--
-- ************************************************
set lines 100
set pages 999
column c1 heading 'Pool |Size(M)'
column c2 heading 'Size|Factor'
column c3 heading 'Est|LC(M) '
column c4 heading 'Est LC|Mem. Obj.'
column c5 heading 'Est|Time|Saved|(sec)'
column c6 heading 'Est|Parse|Saved|Factor'
column c7 heading 'Est|Object Hits' format 999,999,999
SELECT shared_pool_size_for_estimate c1
, shared_pool_size_factor c2
, estd_lc_size c3
, estd_lc_memory_objects c4
, estd_lc_time_saved c5
, estd_lc_time_saved_factor c6
, estd_lc_memory_object_hits c7
FROM v$shared_pool_advice
;
SELECT shared_pool_size_for_estimate AS "Size of Shared Pool in MB"
, shared_pool_size_factor AS "Size Factor"
, estd_lc_time_saved AS "Time Saved in sec"
FROM v$shared_pool_advice
;
|
cs |
https://docs.oracle.com/cd/E18283_01/server.112/e17110/dynviews_3037.htm
V$SHARED_POOL_ADVICE
V$SHARED_POOL_ADVICE V$SHARED_POOL_ADVICE displays information about estimated parse time in the shared pool for different pool sizes. The sizes range from 10% of the current shared pool size or the amount of pinned library cache memory (whichever is highe
docs.oracle.com
반응형
'[DATABASE] ORACLE > Etc...' 카테고리의 다른 글
| [Oracle] 설치시 무료 XWindow 프로그램 (0) | 2023.03.06 |
|---|---|
| [Oracle] 전체 테이블 건수 구하기 (0) | 2022.10.28 |
| [Oracle] Trigger (0) | 2022.09.15 |
| [Oracle] Database Limits (0) | 2022.08.31 |
| [Oracle] Kill 가능한 Background Process list (0) | 2022.08.31 |
댓글