国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

Oracle 配置參數(shù)查詢語(yǔ)句

Sql代碼

1. SELECT NAME,VALUE FROM v$parameter WHERE NAME IN  
2. ('sga_max_size','db_cache_size',    
3. 'shared_pool_size','shared_pool_reserved_size','large_pool_size','java_pool_size',   
4. 'db_block_size','db_block_buffers','log_buffer','sort_area_size','sort_area_retained_size',   
5. 'hash_area_size','sessions','open_cursors' )ORDER BY NAME;  

SELECT NAME,VALUE FROM v$parameter WHERE NAME IN('sga_max_size','db_cache_size','shared_pool_size','shared_pool_reserved_size','large_pool_size','java_pool_size','db_block_size','db_block_buffers','log_buffer','sort_area_size','sort_area_retained_size','hash_area_size','sessions','open_cursors' )ORDER BY NAME;

 其他參數(shù)設(shè)置

Sql代碼

1. alter system set sort_area_size=10240000 scope=spfile;   
2. alter system set sga_max_size=700m scope=spfile;   
3. alter system set sga_target=700m scope=spfile;  

alter system set sort_area_size=10240000 scope=spfile;alter system set sga_max_size=700m scope=spfile;alter system set sga_target=700m scope=spfile;

 查看目前已經(jīng)建立的索引

Sql代碼

1. select index_name from all_indexes where table_name = 'PICTURE';  

select index_name from all_indexes where table_name = 'PICTURE';

    上面查詢語(yǔ)句里面的table_name必須大寫(xiě)，如果寫(xiě)成'picture'則是沒(méi)有記錄。

查看 索引(index)/ 表(table) 占用表空間大小

Sql代碼

1. select (sum(bytes)/1024/1024)||'MB' from dba_segments where segment_name = 'PR_ID';   
2. select (sum(bytes)/1024/1024)||'MB' from dba_segments where segment_name = 'PATROL_REPORT';  

select (sum(bytes)/1024/1024)||'MB' from dba_segments where segment_name = 'PR_ID';select (sum(bytes)/1024/1024)||'MB' from dba_segments where segment_name = 'PATROL_REPORT';

查看某表空間的所有索引

Sql代碼

1. select sum(bytes),segment_name from dba_segments where tablespace_name='LONGMONITOR' and segment_type='INDEX' group by segment_name order by sum(bytes) desc;  

select sum(bytes),segment_name from dba_segments where tablespace_name='LONGMONITOR' and segment_type='INDEX' group by segment_name order by sum(bytes) desc;