unix & linux 查看机器性能

 

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;