ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 表空间及字符集

oracle 表空间及字符集

原创 Linux操作系统 作者:pengxia1123 时间:2011-12-05 12:47:42 0 删除 编辑
5). 检查数据文件的状态记录状态不是“online”的数据文件,并做恢复
select file_name from dba_data_files where status=’offline’
(6). 检查表空间的使用情况
select tablespace_name, max_m, count_blocks free_blk_cnt, sum_free_m,to_char(100*sum_free_m/sum_m, 99.99) || % as pct_free
from ( select tablespace_name,sum(bytes)/1024/1024 as sum_m from dba_data_files group by tablespace_name),
( select tablespace_name as fs_ts_name, max(bytes)/1024/1024 as max_m, count(blocks) as count_blocks, sum(bytes/1024/1024) as sum_free_m from dba_free_space group by tablespace_name )
where tablespace_name = fs_ts_name
(7). 检查剩余表空间
select tablespace_name, sum ( blocks ) as free_blk ,
trunc ( sum ( bytes ) /(1024*1024) ) as free_m,
max ( bytes ) / (1024) as big_chunk_k, count (*) as num_chunks
from dba_free_space group by tablespace_name;
查询字符集:
select *  from V$NLS_PARAMETERS
select  userenv('language') from dual

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143346/viewspace-712737/,如需转载,请注明出处,否则将追究法律责任。

下一篇: web services
请登录后发表评论 登录
全部评论

注册时间:2011-08-07

  • 博文量
    4
  • 访问量
    8307