KMUORADB.ora
---------------------------------------------------------------------------------------------------------------------
*.audit_file_dest='/oracle/app/oracle/admin/KMUORADB/adump'
*.background_dump_dest='/oracle/app/oracle/admin/KMUORADB/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/oradata/KMUORADB/control01.ctl','/oradata/KMUORADB/control02.ctl','/oradata/KMUORADB/control03.ctl'
*.core_dump_dest='/oracle/app/oracle/admin/KMUORADB/cdump'
*.db_block_size=8192
*.db_cache_size=1258291200
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='KMUORADB'
*.java_pool_size=0
*.job_queue_processes=10
*.large_pool_size=0
*.open_cursors=300
*.optimizer_index_caching=100
*.optimizer_index_cost_adj=10
*.optimizer_mode='FIRST_ROWS'
*.pga_aggregate_target=838860800
*.processes=6000
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=6605
#*.shared_pool_size=943718400
*.shared_pool_size=1200m
*.shared_pool_reserved_size=80m
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/app/oracle/admin/KMUORADB/udump'
*.log_archive_dest_1='location=/arch'
*.log_archive_format='%t_%s_%r.arc'
*.query_rewrite_enabled=FALSE
*.session_cached_cursors=200

현재 process count
현재 session count
init 파라메터의 process 수
init 파라메터의 session 수 (processes * 1.1 + 5)
조회

SELECT  TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') as now
,       (select count(*) A_A from v$process) as processCnt
,       (select count(*) B_B from v$session) as sessionCnt
,       (select value from v$parameter where name='processes') as initProcess
,       (select value from v$parameter where name='sessions') as initSession
FROM DUAL;

* 오라클에서 어떤 프로그램이 얼만큼의 커서를 갖는지 조회

select s.sid
, s.program
, ss.value "open_cursor"
from v$sesstat ss, v$session s
where ss.statistic# = 3
and s.sid = ss.sid 
order by 3 desc;

select * from v$sesstat;

select sum(value) from v$sesstat where statistic# = 3;

* 세션정보

select * from v$session;

* 한 sessoion이 한번에 open할 수 있는 cursor의 최대 갯수

select name, value from v$parameter where name = 'open_cursors'; 

* 현재 사용 자원 조회

select * from v$resource_limit;