航天金税开票软件下载:Oracle 配置参数查询语句、索引查询 -
来源:百度文库 编辑:九乡新闻网 时间:2024/04/27 16:39:47
Oracle 配置参数查询语句
Sql代码- 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;
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;
其他参数设置
Sql代码- 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;
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;
查看目前已经建立的索引
Sql代码- select index_name from all_indexes where table_name = 'PICTURE';
select index_name from all_indexes where table_name = 'PICTURE';
上面查询语句里面的table_name必须大写,如果写成'picture'则是没有记录。
查看 索引(index)/ 表(table) 占用表空间大小
Sql代码- 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';
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代码- 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;
Oracle 配置参数查询语句、索引查询 -
从Select语句看Oracle查询原理
查询 mysql,oracle 注释
三极管参数查询2
oracle使用二(sql查询)
常用三极管参数查询表
介绍一些oracle查询语句了解数据库情况(oracle连接数、表空间大小等)_淘 资 讯...
wildfire s手机参数查询,产地查询方法
ORACLE错误一览表,方便大家查询
教你查询Oracle中的表空间
Dvbbs.7.1.0变量参数查询表
vb+oracle+mapx实现的最短路径查询
Oracle 索引 详解
股票行情查询 股票代码查询
百事查询查询大全
911查询-实用查询
Oracle 数据库监听配置
Oracle数据库监听配置
Oracle数据库监听配置
Oracle关于进程会话的查询 - 若水上善的日志 - 网易博客
在SQL Server 2005中连接Oracle,完成查询、插入操作
资料查询
万能查询
综合查询