Oracle DBA Daily Checklist
发布时间：2023-02-17 09:22:34 所属栏目：Oracle 来源：互联网
导读：There are several routine checklist and tasks to do in Oracle database by DBA ( Database Administrator ). This checklist and tasks are as follows. All scripts are valid for Single and RAC Database and Exadata. If you dont use RAC,then you
|
Streams Pool Size 2.6844E+10 Yes 0 Shared IO Pool Size 536870912 Yes 0 Data Transfer Cache Size 0 Yes 0 Granule Size 536870912 No 0 Maximum SGA Size 2.1445E+11 No 0 Startup overhead in Shared Pool 1180135528 No 0 Startup NUMA Shared Pool memory 1.0737E+10 No 0 Free SGA Memory Available 536870912 0 15 rows selected. sql> select * from v$sgastat; POOL NAME BYTES CON_ID -------------- -------------------------- ---------- ---------- fixed_sga 29906520 0 buffer_cache 1.1489E+11 0 log_buffer 207720448 0 shared_io_pool 536870912 0 shared pool free memory 6701646384 0 shared pool v_inc_meter_info_problem 1728 0 shared pool kghpinfo freelist 192 0 shared pool enqueue_hash 222864 0 shared pool kmgsb circular statistics 162560 0 shared pool SGA Obsolete Param Source 24 0 16-Check Log Switch and Archivelog generation frequency. You can query and list the Log Switch ( Archivelog ) Frequency map according to per hour and daily as follows. select to_char(first_time,'YYYY-MON-DD') day,to_char(sum(decode(to_char(first_time,'HH24'),'00',0)),'9999') "00",'01','9999') "01",'02','9999') "02",'03','9999') "03",'04','9999') "04",'05','9999') "05",'06','9999') "06",'07','9999') "07",'08','9999') "08",'09','9999') "09",'10','9999') "10",'11','9999') "11",'12','9999') "12",'13','9999') "13",'14','9999') "14",'15','9999') "15",'16','9999') "16",'17','9999') "17",'18','9999') "18",'19','9999') "19",'20','9999') "20",'21','9999') "21",'22','9999') "22",'23','9999') "23" from v$log_history group by to_char(first_time,'YYYY-MON-DD'); Query result is as follows. （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
