DBA常用數據庫查詢語句

1 數據庫信息

1.1 數據庫概要

select a.name "DB Name",e.global_name "Global Name",c.host_name "Host Name",c.instance_name "Instance Name" ,DECODE(c.logins,'RESTRICTED','YES','NO') "Restricted Mode",a.log_mode  "Archive Log Mode"
FROM v$database a, v$version b, v$instance c,global_name e
WHERE b.banner LIKE '%Oracle%';

1.2 參數文件(是spfile還是pfile)

select nvl(value,'pfile') "Parameter_File"
from v$parameter where Name='spfile';

1.3 非默認的參數

select name, rtrim(value) "pvalue"
from v$parameter
where isdefault = 'FALSE'
order by name;

1.4 控制文件及其狀態

select Name,Status from v$controlfile;

1.5 數據庫版本信息

select * from v$version;

1.6 數據庫組件（true：已安裝，false：未安裝）

SELECT PARAMETER, VALUE FROM V$OPTION;

1.7 實例信息

select instance_name,host_name,version,status,database_status from v$instance;

1.8 NLS參數設置

SELECT * FROM NLS_Database_Parameters;

1.9 已裝載的產品選項

select COMP_ID, COMP_NAME, VERSION,STATUS from dba_registry;

1.10 數據庫的并發數

select count(*) as "并發數" from v$session where status='ACTIVE';

1.11 數據庫Session連接數

select count(*) as "連接數" from v$session;

1.12 數據庫總大小（GB）

select round(sum(space)) "總容量/Gb"from (select sum(bytes) / 1024 / 1024 / 1024 spacefrom dba_data_filesunion allselect nvl(sum(bytes) / 1024 / 1024 / 1024, 0) spacefrom dba_temp_filesunion allselect sum(bytes) / 1024 / 1024 / 1024 space from v$log);

1.13 數據庫服務器運行的操作系統

select PLATFORM_NAME from v$database;

1.14 DBID

select dbid from v$database;

1.15 Flashback是否啟動

select decode(flashback_on,'NO','未啟用','啟用') as "閃回模式" from v$database;

2 存儲結構、表空間、數據文件

2.1 表空間及數據文件

select tablespace_name,file_name,
bytes/1024/1024 "Total Size(MB)",autoExtensible "Auto" 
from dba_data_files 
order by tablespace_name,file_id;

2.2 表空間狀態及其大小使用情況

SELECT  d.tablespace_name "Name", d.status "Status", d.contents "Type",ROUND(NVL(a.bytes / 1024 / 1024, 0), 2) "Size (MB)",ROUND(NVL(a.bytes - NVL(f.bytes, 0), 0) / 1024 /1024, 2) "Used (MB)",ROUND(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), 2) "Used%",ROUND(NVL(a.maxbytes / 1024 / 1024, 0), 2) "Max Size (MB)",DECODE(NVL(a.maxbytes,0), 0, 0, ROUND(NVL(a.maxbytes - a.bytes, 0) / 1024 / 1024, 2)) "Unused (MB)",DECODE(NVL(a.maxbytes,0), 0, 0, ROUND((1 - NVL(a.bytes / a.maxbytes, 0))*100, 2)) "Unused%"FROM sys.dba_tablespaces d,(SELECT tablespace_name, SUM(bytes) bytes, SUM(maxbytes) maxbytesFROM dba_data_files GROUP BY tablespace_nameUNION ALLSELECT tablespace_name, SUM(bytes) bytes, SUM(maxbytes) maxbytesFROM dba_temp_files GROUP BY tablespace_name) a,(SELECT tablespace_name, SUM(bytes) bytesFROM dba_free_space GROUP BY tablespace_nameUNION ALLSELECT tablespace_name, SUM(bytes_free) bytesFROM gv$temp_space_header GROUP BY tablespace_name) fWHERE d.tablespace_name = a.tablespace_name(+)AND d.tablespace_name = f.tablespace_name(+);

2.3 數據文件狀態及其大小使用情況

SELECT  a.tablespace_name "TableSpace Name", a.File_Name "File Name",a.status "Status", a.AutoExtensible "Auto",round(NVL(a.bytes / 1024 / 1024, 0),1) "Size (MB)",round(NVL(a.bytes - NVL(f.bytes, 0),0)/1024/1024, 1) "Used (MB)",round(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), 2) "Used %"
FROM dba_data_files a,(select file_id, sum(bytes) bytesfrom dba_free_space group by File_id) f
WHERE a.file_id=f.file_id(+)
order by a.tablespace_name,a.File_id;

2.4 不使用臨時文件的臨時表空間

select tablespace_name,contents from dba_tablespaces
where contents='TEMPORARY' and tablespace_name not in(select tablespace_name from dba_temp_files);

2.5 無效的數據文件(offline)

select f.tablespace_name,f.file_name,d.status
from dba_data_files f,v$datafile d
where d.status='OFFLINE' and f.file_id=File#(+);

2.6 處于恢復模式的文件

select f.tablespace_name,f.file_name
from dba_data_files f, v$recover_file r
where f.file_id=r.file#;

2.7 含有50個以上的Extent且30%以上碎片的表空間

select s.tablespace_name,round(100 * f.hole_count / (f.hole_count + s.seg_count)) pct_fragmented,s.seg_count segments, f.hole_count holes
from  (Select tablespace_name, count(*) seg_countfrom   dba_segments group by tablespace_name) s,(Select   tablespace_name, count(*) hole_countfrom     dba_free_space  group by tablespace_name) f
where s.tablespace_name = f.tablespace_nameand s.tablespace_name in (Select tablespace_namefrom dba_tablespaces where contents = 'PERMANENT')And s.tablespace_name not in ('SYSTEM')and 100 * f.hole_count / (f.hole_count + s.seg_count) > 30and s.seg_count > 50;

2.8 表空間上的I/O分布

SELECT  t.name   ts_name,f.name  file_name,s.phyrds phy_reads,s.phyblkrd phy_blockreads,s.phywrts phy_writes,s.phyblkwrt phy_blockwrites
FROM    gv$tablespace t,gv$datafile f,gv$filestat s
WHERE   t.ts# = f.ts#andf.file# = s.file#
ORDER BY s.phyrds desc, s.phywrts desc;

2.9 數據文件上的I/O分布

Select   ts.NAME "Table Space", D.NAME "File Name",FS.PHYRDS "Phys Rds",decode(fstot.sum_ph_rds,  0, 0,round(100 * FS.PHYRDS    / fstot.sum_ph_rds,  2)) "% Phys Rds",FS.PHYWRTS "Phys Wrts",decode(fstot.sum_ph_wrts, 0, 0,round(100 * FS.PHYWRTS   / fstot.sum_ph_wrts, 2)) "% Phys Wrts"
FROM   V$FILESTAT FS, V$DATAFILE d, V$tablespace ts,(select sum(phyrds)   sum_ph_rds, sum(phywrts)   sum_ph_wrts,sum(phyblkrd) sum_bl_rds, sum(phyblkwrt) sum_bl_wrtsfrom   V$filestat) fstot
WHERE  D.FILE# = FS.FILE# AND D.TS#   = TS.TS#;

2.10 Next Extent 相對于段當前已分配字節過大(>=2倍)或過小(<10%)的Segments

Select InitCap(SEGMENT_TYPE) "Type", OWNER, SEGMENT_NAME, BYTES, NEXT_EXTENT,ROUND(100 * NEXT_EXTENT / BYTES) "Percent(Next/Bytes)"
FROM   DBA_SEGMENTS
WHERE  ((ROUND(100 * NEXT_EXTENT / BYTES) < 10) OR(ROUND(100 * NEXT_EXTENT / BYTES) >= 200))AND    SEGMENT_TYPE NOT IN ('ROLLBACK', 'TEMPORARY', 'CACHE', 'TYPE2 UNDO')
order by 2,3,1;

2.11 Max Extents(>1)已經有90%被使用了的Segments

Select segment_type, owner,  Segment_name, Tablespace_name,partition_name, round(bytes /1024/1024) "Size(MB)", extents, max_extents
From   dba_segments
where  segment_type not in ('ROLLBACK', 'TEMPORARY', 'CACHE', 'TYPE2 UNDO')
and    extents >= (1 - ( 10 / 100)) * max_extents  and  max_extents > 1
order by bytes / max_extents desc;

2.12 已經分配超過100 Extents的Segments

Select segment_type, owner, segment_name, extents, partition_name
from dba_segments
where  segment_type not in ('ROLLBACK', 'TEMPORARY', 'CACHE', 'TYPE2 UNDO')and   owner not in ('SYS', 'SYSTEM', 'OUTLN', 'DBSNMP', 'ORDSYS', 'ORDPLUGINS','MDSYS', 'CTXSYS', 'AURORA$ORB$UNAUTHENTICATED', 'XDB')and    extents > 100;

2.13 因表空間空間不夠將導致不能擴展的Objects

Select a.tablespace_name, a.owner,decode(a.partition_name, null, a.segment_name,a.segment_name || '.' || a.partition_name) "Segment Name",a.extents, round(next_extent/1024) next_extent_kb,round(b.free / 1024) ts_free_kb,round(c.morebytes / 1024 / 1024) ts_growth_mb
from   dba_segments a,(Select df.tablespace_name, nvl(max(fs.bytes), 0) freefrom     dba_data_files df,dba_free_space fswhere    df.file_id = fs.file_id (+)group by df.tablespace_name) b,(Select tablespace_name, max(maxbytes - bytes) morebytes,sum(decode(AUTOEXTENSIBLE, 'YES', 1, 0)) autoextensiblefrom     dba_data_filesgroup by tablespace_name) c
where a.tablespace_name = b.tablespace_nameand   a.tablespace_name = c.tablespace_nameand   ((c.autoextensible = 0) or ((c.autoextensible > 0)and (a.next_extent > c.morebytes)))and   a.next_extent > b.free
order by 1;

2.14 表空間碎片化程度分析（FSFI<30,破碎化程度高）

select tablespace_name,round(sqrt(max(blocks) / sum(blocks)) *(100 / sqrt(sqrt(count(blocks)))),2) FSFI,(casewhen sqrt(max(blocks) / sum(blocks)) *(100 / sqrt(sqrt(count(blocks)))) > = 30 then'正常'when sqrt(max(blocks) / sum(blocks)) *(100 / sqrt(sqrt(count(blocks)))) < 30 then'表空間破碎化程度高，請整理'end) Promptfrom dba_free_spacegroup by tablespace_nameorder by 2;

2.15 可傳輸表空間支持的操作系統和字節順序

select * from v$transportable_platform;

2.16 數據庫臨時文件狀態

SELECT FILE_ID ID,FILE_NAME,TABLESPACE_NAME,round(BYTES / 1024 / 1024, 2) "Size/Mb",autoextensibleFROM dba_temp_files;

2.17 臨時表空間使用率

select h.tablespace_name,round(sum(h.bytes_free+h.bytes_used)/1048576, 2) "MB_Alloc",round(sum((h.bytes_free+h.bytes_used)-nvl(p.bytes_used, 0))/1048576, 2) "MB_free",round(sum(nvl(p.bytes_used, 0))/ 1048576, 2) "MB_Used",round((sum((h.bytes_free + h.bytes_used)-nvl(p.bytes_used, 0))/sum(h.bytes_used + h.bytes_free)) * 100,2) "Pct_Free%",100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100,2)
"pct_used%"
from   sys.v_$TEMP_SPACE_HEADER h, sys.v_$Temp_extent_pool p, dba_temp_files f
where  p.file_id(+) = h.file_id
and    p.tablespace_name(+) = h.tablespace_name
and    f.file_id = h.file_id
and    f.tablespace_name = h.tablespace_name
group by h.tablespace_name, f.maxbytes
ORDER BY 4;

2.18 使用最多臨時表空間的SQL

SELECT SE.USERNAME,SE.SID,SU.EXTENTS,(SU.BLOCKS * TO_NUMBER(RTRIM(P.VALUE)))/(1024*1024) AS "SPACE",TABLESPACE,SEGTYPE,SQL_TEXTFROM V$SORT_USAGE SU, V$PARAMETER P, V$SESSION SE, V$SQL SWHERE P.NAME = 'DB_BLOCK_SIZE'AND SU.SESSION_ADDR = SE.SADDRAND S.HASH_VALUE = SU.SQLHASHAND S.ADDRESS = SU.SQLADDRORDER BY SU.BLOCKS * TO_NUMBER(RTRIM(P.VALUE)) DESC, SE.SID;

3 重做日志

3.1 重做日志文件信息

select  f.group#, f.member "Redo File", f.Type,l.Status,l.bytes/1024/1024 "Size(MB)"
from v$log l,v$logfile f
where l.group#=f.group#;

3.2 最近7天歸檔日志的生成頻率

select a.recid,to_char(a.first_time, 'yyyy-mm-dd hh24:mi:ss') begin_time,b.recid,to_char(b.first_time, 'yyyy-mm-dd hh24:mi:ss') end_time,round((b.first_time - a.first_time) * 24 * 60, 2) minutesfrom v$log_history a, v$log_history bwhere b.recid = a.recid + 1and a.first_time > sysdate - 7;

3.3 監控當前重做日志文件使用情況（as sysdba）

select le.leseq "Current log sequence No",100 * cp.cpodr_bno / le.lesiz "Percent Full",(cpodr_bno - 1) * 512 "bytes used exclude header",le.lesiz * 512 - cpodr_bno * 512 "Left space",le.lesiz * 512 "logfile size"from x$kcccp cp, x$kccle lewhere LE.leseq = CP.cpodr_seqand bitand(le.leflg, 24) = 8;

3.4 最近7日聯機日志切換頻度

SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'), 1, 5) DAY,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '00', 1, 0)) H00,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '01', 1, 0)) H01,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '02', 1, 0)) H02,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '03', 1, 0)) H03,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '04', 1, 0)) H04,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '05', 1, 0)) H05,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '06', 1, 0)) H06,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '07', 1, 0)) H07,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '08', 1, 0)) H08,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '09', 1, 0)) H09,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '10', 1, 0)) H10,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '11', 1, 0)) H11,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '12', 1, 0)) H12,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '13', 1, 0)) H13,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '14', 1, 0)) H14,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '15', 1, 0)) H15,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '16', 1, 0)) H16,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '17', 1, 0)) H17,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '18', 1, 0)) H18,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '19', 1, 0)) H19,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '20', 1, 0)) H20,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '21', 1, 0)) H21,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '22', 1, 0)) H22,SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'), 10, 2), '23', 1, 0)) H23,COUNT(*) TOTALFROM v$log_history aWHERE (TO_DATE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'), 1, 8),'MM/DD/RR') >= sysdate - 7)AND (TO_DATE(substr(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'), 1, 8),'MM/DD/RR') <= sysdate)GROUP BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'), 1, 5)ORDER BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'), 1, 5);

4 SGA/PGA

4.1 內存分配概況

select name,to_char(value) "value(Byte)"
from v$sga
union all
select name,value
from v$parameter
where name in
('shared pool_size','large_pool_size','java_pool_size','lock_sga');

4.2 Library Cache Reload Ratio(<1%)

Select round((Sum(Reloads) / Sum (Pins)) * 100, 4) "LC_Reload_Ratio%"
From V$Librarycache;
4.3	Data Dictionary Miss Ratio(<15%)
Select Round((((sum(GetMisses)) / sum(Gets)) * 100),4) "DC_Miss_Ratio%"
From V$rowcache;
4.4	共享池使用概況
Select round(sum(a.bytes)/(1024*1024), 2) "Used(MB)",round(max(p.value)/(1024*1024), 2) "Size(MB)",round((max(p.value)/(1024*1024))-(sum(a.bytes)/(1024*1024)), 2) "Avail(MB)",round((sum(a.bytes)/max(p.value))*100, 2) "Used(%)"
from V$sgastat a,(select decode(sign(instr(upper(value), 'K') + instr(upper(value),'M')),0, value,1, decode(sign(instr(upper(value), 'K')),1, to_number(1024 * rtrim(substr(value, 1, instr(upper(value), 'K') - 1))),to_number(1024 * 1024 * rtrim(substr(value, 1,instr(upper(value), 'M') - 1))))) valuefrom v$parameterwhere name like 'shared_pool_size') p
where a.name in( 'reserved stopper', 'table definiti', 'dictionary cache','library cache', 'sql area', 'PL/SQL DIANA', 'SEQ S.O.');

4.5 共享池建議

select shared_pool_size_for_estimate "Shared Pool Size(estimate)",SHARED_POOL_SIZE_FACTOR "Factor",estd_lc_size "Libarary Cache Size",estd_lc_time_saved "time Saved"
from v$shared_pool_advice;

4.6 DB Buffer Cache(Default) Hit Ratio(>90%)

Select round(100 * (1-(physical_reads/(db_block_gets+consistent_gets))), 4) "BC_Hit _Ratio"
FROM    v$buffer_pool_statistics
WHERE   name = 'DEFAULT';

4.7 DB Buffer Cache Advice

select Name "Pool Name",Block_size,SIZE_FOR_ESTIMATE "Buffer Size",SIZE_FACTOR "Factor",ESTD_PHYSICAL_READ_FACTOR "Phy_Read_Factor",ESTD_PHYSICAL_READS "ESTD_PHY_READS"
from v$db_cache_advice where ADVICE_STATUS='ON';

4.8 磁盤排序(<5%)

select a.value "Sort(Disk)", b.value "Sort(Memory)",round(100*(a.value/decode((a.value+b.value), 0,1,(a.value+b.value))),2) "Disk_Sort_Ratio%"
from v$sysstat a, v$sysstat b
where a.name = 'sorts (disk)' and b.name = 'sorts (memory)';

4.9 Log Buffer latch Contention(<1%)

SELECT name "Redo Name", gets, misses, immediate_gets, immediate_misses,Decode(gets,0,0,round(misses/gets*100,3)) "Miss_Ratio%",Decode(immediate_gets+immediate_misses,0,0,round( immediate_misses/(immediate_gets+immediate_misses)*100,3)) "Immediate Misses Ratio%"
FROM v$latch WHERE name IN ('redo allocation', 'redo copy');

4.10 數據緩沖區高速緩存

SELECT physical_reads, db_block_gets, consistent_gets, NAME,100 * ( 1 - ( physical_reads / (consistent_gets + db_block_gets - physical_reads))) "Data Buffer Hit Ratio"
FROM v$buffer_pool_statistics;

4.11 重做日志緩沖區

SELECT a.VALUE redo_entries,b.VALUE redo_buffer_allocation_retries,ROUND((1 - b.VALUE / a.VALUE) * 100, 4) log_buffer_ratioFROM v$sysstat a, v$sysstat bWHERE a.NAME = 'redo entries'AND b.NAME = 'redo buffer allocation retries';

4.12 數據字典高速緩存

SELECT a.VALUE redo_entries,b.VALUE redo_buffer_allocation_retries,ROUND((1 - b.VALUE / a.VALUE) * 100, 4) log_buffer_ratioFROM v$sysstat a, v$sysstat bWHERE a.NAME = 'redo entries'AND b.NAME = 'redo buffer allocation retries';

4.13 高速緩存

SELECT ROUND((1 - SUM(getmisses) / SUM(gets)) * 100, 1) "Dictionary Cache Hit Ratio"FROM v$rowcache;

4.14 排序（磁盤/內存）

SELECT b.VALUE memory_sort,a.VALUE disk_sort,ROUND((1 - a.VALUE / (a.VALUE + b.VALUE)) * 100, 4) sort_ratioFROM v$sysstat a, v$sysstat bWHERE a.NAME = 'sorts (disk)'AND b.NAME = 'sorts (memory)';

4.15 SGA Memory Map (overall)

SELECT 1 dummy, 'DB Buffer Cache' area, name, round(sum(bytes)/1024/1024,2) "Size/Mb"FROM v$sgastatWHERE pool is nulland name = 'db_block_buffers'group by name
union all
SELECT 2, 'Shared Pool', pool, round(sum(bytes)/1024/1024,2)FROM v$sgastatWHERE pool = 'shared pool'group by pool
union all
SELECT 3, 'Large Pool', pool, round(sum(bytes)/1024/1024,2)FROM v$sgastatWHERE pool = 'large pool'group by pool
union all
SELECT 4, 'Java Pool', pool, round(sum(bytes)/1024/1024,2)FROM v$sgastatWHERE pool = 'java pool'group by pool
union all
SELECT 5, 'Redo Log Buffer', name, round(sum(bytes)/1024/1024,2)FROM v$sgastatWHERE pool is nulland name = 'log_buffer'group by name
union all
SELECT 6, 'Fixed SGA', name, round(sum(bytes)/1024/1024,2)FROM v$sgastatWHERE pool is nulland name = 'fixed_sga'group by nameORDER BY 4 desc;

4.16 SGA Memory Map (shared pool)

SELECT 'Shared Pool' area,name,round(sum(bytes) / 1024 / 1024, 2) "Size/Mb"FROM v$sgastatWHERE pool = 'shared pool'and name in('library cache', 'dictionary cache', 'free memory', 'sql area')group by name
union all
SELECT 'Shared Pool' area,'miscellaneous',round(sum(bytes) / 1024 / 1024, 2) "Size/Mb"FROM v$sgastatWHERE pool = 'shared pool'and name not in('library cache', 'dictionary cache', 'free memory', 'sql area')group by poolorder by 3 desc;

4.17 查看SGA的使用

select COMPONENT,CURRENT_SIZE from V$SGA_DYNAMIC_COMPONENTS;

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/pingmian/90840.shtml
繁體地址，請注明出處：http://hk.pswp.cn/pingmian/90840.shtml
英文地址，請注明出處：http://en.pswp.cn/pingmian/90840.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

【c++深入系列】：萬字詳解priority_queue（附模擬實現的源碼）

【c++深入系列】：萬字詳解priority_queue（附模擬實現的源碼）

&#x1f525; 本文專欄&#xff1a;c &#x1f338;作者主頁&#xff1a;努力努力再努力wz &#x1f4aa; 今日博客勵志語錄&#xff1a; 真正的強大&#xff0c;不是從不跌倒&#xff0c;而是每次跌倒后都能笑著站起來 ★★★ 本文前置知識&#xff1a; 模版 引入 那么pri…
閱讀更多...
分享一個腳本，從mysql導出數據csv到hdfs臨時目錄

分享一個腳本，從mysql導出數據csv到hdfs臨時目錄

想從mysql導出一個表到csv文件&#xff0c;然后上傳到hdfs&#xff0c;開始使用sqoop&#xff0c;結果各種問題頻出&#xff1a; https://blog.csdn.net/weixin_45357522/article/details/149498030 https://blog.csdn.net/weixin_45357522/article/details/149449413 特別是那…
閱讀更多...
OpenLayers 綜合案例-區域掩膜

OpenLayers 綜合案例-區域掩膜

看過的知識不等于學會。唯有用心總結、系統記錄&#xff0c;并通過溫故知新反復實踐&#xff0c;才能真正掌握一二 作為一名摸爬滾打三年的前端開發&#xff0c;開源社區給了我飯碗&#xff0c;我也將所學的知識體系回饋給大家&#xff0c;助你少走彎路&#xff01; OpenLayers…
閱讀更多...
30天打牢數模基礎-神經網絡基礎講解

30天打牢數模基礎-神經網絡基礎講解

一、代碼說明本代碼基于模擬房價數據集&#xff0c;使用scikit-learn庫中的MLPRegressor&#xff08;多層感知器回歸&#xff09;實現神經網絡模型&#xff0c;解決房價預測問題。代碼邏輯清晰&#xff0c;適合數模小白入門&#xff0c;包含數據預處理、模型構建、訓練評估、新…
閱讀更多...
Linux應用開發基礎知識——LInux學習FreeType編程（七）

Linux應用開發基礎知識——LInux學習FreeType編程（七）

目錄 一、使用freetype 顯示一個文字 二、使用 freetype 顯示一行文字 1. 了解笛卡爾坐標系 2. 每個字符的大小可能不同 3. 怎么在指定位置顯示一行文字 4. freetype 的幾個重要數據結構 4.1、FT_Library結構體 4.2、FT_Face結構體 4.3、FT_GlyphSlot結構體 4.4、FT_G…
閱讀更多...
Kotlin中Flow

Kotlin中Flow

Kotlin Flow 深度解析&#xff1a;從原理到實戰一、Flow 核心概念體系1. Flow 的本質與架構Flow 是 Kotlin 協程庫中的異步數據流處理框架&#xff0c;核心特點&#xff1a;響應式編程&#xff1a;基于觀察者模式的數據處理協程集成&#xff1a;無縫融入 Kotlin 協程生態背壓支…
閱讀更多...
Java程序員學從0學AI（七）

Java程序員學從0學AI（七）

一、前言 上一篇文章圍繞 Spring AI 的 Chat Memory&#xff08;聊天記憶&#xff09;功能展開&#xff0c;先是通過代碼演示了不使用 Chat Memory 時&#xff0c;大模型因無狀態無法記住上下文&#xff08;如用戶姓名&#xff09;的情況&#xff0c;隨后展示了使用基于內存的 …
閱讀更多...
ESP32S3 防貓逃脫監測系統

ESP32S3 防貓逃脫監測系統

在辦公室里&#xff0c;兩只可愛的貓咪給大家帶來了不少歡樂&#xff0c;但其中一只總愛趁人不注意溜出房間&#xff0c;有時下班后還會被鄰居告知它被鎖在了外面。為了解決這個問題&#xff0c;我開發了一個基于 SeeedStudio XIAO ESP32S3 Sense 的貓咪逃脫監測預警系統&#…
閱讀更多...
Python|OpenCV-實現快速處理圖像的方法(23)

Python|OpenCV-實現快速處理圖像的方法(23)

前言 本文是該專欄的第25篇，后面將持續分享OpenCV計算機視覺的干貨知識，記得關注。 在視覺算法落地流程中，數據預處理往往占用 60 % 以上的工程時間。以某沿海城市智慧旅游項目為例，我們從無人機錄制的 4K 海灘視頻中抽幀得到 10 000 張 PNG 原圖，分辨率 38402160，單張體…
閱讀更多...
Redis四種GetShell方式完整教程

Redis四種GetShell方式完整教程

Redis作為高性能內存數據庫&#xff0c;若未正確配置認證和訪問控制&#xff0c;可能被攻擊者利用實現遠程代碼執行&#xff08;GetShell&#xff09;。本文詳細講解四種常見的Redis GetShell方式&#xff0c;涵蓋原理、操作步驟及防御建議。方式一&#xff1a;直接寫入Shell腳…
閱讀更多...
clock_nanosleep系統調用及示例

clock_nanosleep系統調用及示例

41. clock_nanosleep - 高精度睡眠 函數介紹 clock_nanosleep系統調用提供納秒級精度的睡眠功能&#xff0c;支持絕對時間和相對時間兩種模式&#xff0c;比傳統的nanosleep更加靈活。 函數原型 #include <time.h>int clock_nanosleep(clockid_t clock_id, int flags,con…
閱讀更多...
用了Flutter包體積增大就棄用Flutter嗎？包體積與開發效率，這兩者之間如何權衡？

用了Flutter包體積增大就棄用Flutter嗎？包體積與開發效率，這兩者之間如何權衡？

是否因包體積增大而棄用 Flutter&#xff0c;本質上是 “短期成本&#xff08;包體積&#xff09;” 與 “長期價值&#xff08;跨平臺效率、體驗一致性等&#xff09;” 的權衡 。這一決策沒有絕對答案&#xff0c;需結合項目階段、用戶群體、業務需求等具體場景分析。以下從核…
閱讀更多...
80道面試經典題目

80道面試經典題目

1.OSI參考模型七層網絡協議？ 物理層：定義計算機、網絡設備、以及直接連接的介質、接口類型的標準，建立比特流的傳輸，用來組件物理網絡的連接。 數據鏈路層:建立邏輯連接、進行硬件地址尋址，差錯校驗、差錯恢復等功能。 網絡層：進行邏輯地址尋址，實現不同網絡之間的通…
閱讀更多...
本周大模型新動向：KV緩存壓縮、低成本高性能推理框架、多智能體協作

本周大模型新動向：KV緩存壓縮、低成本高性能推理框架、多智能體協作

點擊藍字關注我們AI TIME歡迎每一位AI愛好者的加入&#xff01;01Compress Any Segment Anything Model (SAM)受SAM在零樣本分割任務上卓越表現的驅動&#xff0c;其各類變體已被廣泛應用于醫療、智能制造等場景。然而&#xff0c;SAM系列模型體量巨大&#xff0c;嚴重限制了在…
閱讀更多...
利用frp實現內網穿透功能（服務器）Linux、（內網）Windows

利用frp實現內網穿透功能（服務器）Linux、（內網）Windows

適用于&#xff1a; 本地電腦&#xff08;windows&#xff09;或者Linux(本篇未介紹&#xff09; 工具&#xff1a;FRP&#xff08;fast reverse proxy&#xff09; 系統&#xff1a;Linux、Windows 架構&#xff1a;x86、amd Frp版本&#xff1a;frp_0.62.1_windows_amd64準備…
閱讀更多...
結合二八定律安排整塊時間

結合二八定律安排整塊時間

你是不是常常感覺一天到晚忙忙碌碌&#xff0c;卻總覺得沒干成幾件“要緊事”&#xff1f;時間仿佛從指縫間溜走&#xff0c;成就感卻遲遲不來&#xff1f;其實&#xff0c;高效能人士的秘訣往往藏在最簡單的原則里。今天&#xff0c;我們就來聊聊如何巧妙運用“二八定律”&…
閱讀更多...
波形發生器AWG硬件設計方案

波形發生器AWG硬件設計方案

目錄 簡介 設計需求 設計方案 核心原理圖展示 簡介 波形發生器是一種數據信號發生器&#xff0c;在調試硬件時&#xff0c;常常需要加入一些信號&#xff0c;以觀察電路工作是否正常。用一般的信號發生器&#xff0c;不但笨重&#xff0c;而且只發一些簡單的波形&#xff…
閱讀更多...
11.Dockerfile簡介

11.Dockerfile簡介

1.是什么&#xff1f; dockerfile是用來構建鏡像的文本文件&#xff0c;是由一條條構建鏡像所需的指令和參數構成的腳本。 構建三步驟 編寫dockerfile文件docker build命令構建鏡像docker run依鏡像運行的容器實列 2.dockerfile構建過程解析 1)dockerfile內容的基礎知識 …
閱讀更多...
C# 接口（interface 定義接口的關鍵字）

C# 接口（interface 定義接口的關鍵字）

目錄 使用接口案例 接口繼承 練習 定義一個接口&#xff0c;在語法中與定義一個抽象類是沒有區別的&#xff0c;但是不允許提供接口中任意成員的實現方式&#xff0c;一般接口只會包含方法 、索引器和事件的聲明&#xff0c; 不允許聲明成員的修飾符&#xff0c; public都不…
閱讀更多...
5190 - 提高：DFS序和歐拉序:樹上操作（區域修改1）

5190 - 提高：DFS序和歐拉序:樹上操作（區域修改1）

題目傳送門 時間限制 : 2 秒 內存限制 : 256 MB 有一棵點數為 N 的樹&#xff0c;以點 1 為根&#xff0c;且樹點有邊權。然后有 M 個 操作&#xff0c;分為三種&#xff1a; 操作 1 &#xff1a;把某個節點 x 的點權增加 a 。 操作 2 &#xff1a;把某個節點 x 為根的子樹中…
閱讀更多...
最新文章

Copyright @ 2022~2023