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;