unix 与 linux 查看机器性能

13年前

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;