知识屋:更实用的电脑技术知识网站
所在位置:首页 > 操作系统 > linux

unix & linux 查看机器性能

发布时间:2014-09-05 16:35:12作者:知识屋

1、显示cpu数量:
        hp-unix:ioscan -C processor | grep processor | wc -l
        Solais:psrinfo -v | grep "Status of processor" | wc -l
        linux :cat  /proc/cpuinfo | grep processor | wc -l
        AIX:lsdev -C | grep -i processor | wc -l
2、显示内存数量(top):
        solaris:prtconf | grep -i mem
        AIX:root>lsdev -C |grep mem
        memo:    Available  00-00 Memory
        LINUX:free
        HP-UNIX:swapinfo -tm
3、存储空间:
        df -h
4、查看内核版本命令:
        cat /proc/version
        uname -a
5、查看linux版本:
        lsb_release -a
        cat /etc/issue
 
6、数据库情况:
        SGA:show sga
        归档:archive log list
        临时表空间:
         select * from database_properties d where d.PROPERTY_NAME = 'DEFAULT_TEMP_TABLESPACE';
         select TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024 "SIZE(MB)"  from dba_temp_files;
       表空间:
    select a.tablespace_name TABLESPACE_NAME,
       a.all_space ALL_SPACE,
       a.all_space - b.free_space USED_SPACE,
       substr(to_char((a.all_space - b.free_space) / a.all_space * 100),
              1,
              4) || '%' "%USED",
       b.free_space FREE_SPACE,
       substr(to_char(b.free_space / a.all_space * 100), 1, 4) || '%' "%FREE"
  from (select sum(bytes / 1024 / 1024) all_space, tablespace_name
          from dba_data_files
         group by tablespace_name
         order by tablespace_name) a,
       (select sum(bytes / 1024 / 1024 ) free_space, tablespace_name
          from dba_free_space
         group by tablespace_name
         order by tablespace_name) b
 where a.tablespace_name = b.tablespace_name;

摘自 润明 blog
(免责声明:文章内容如涉及作品内容、版权和其它问题,请及时与我们联系,我们将在第一时间删除内容,文章内容仅供参考)
收藏
  • 人气文章
  • 最新文章
  • 下载排行榜
  • 热门排行榜