查看linux机器性能,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;