1. display cpu quantity: hp-unix: ioscan-Cprocessor | grepprocessor | wc-lSolais: psrinfo-v | grep & quot; Statusofprocessor & quot; | wc-llinux: cat/proc/cpuinfo | grepprocessor... 1. display the number of CPUs:
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. display the memory quantity (top ):
Solaris: prtconf | grep-I mem
AIX: root> lsdev-C | grep mem
Memo: Available 00-00 Memory
LINUX: free
HP-UNIX: swapinfo-tm
3. storage space:
Df-h
4. run the following command to view the kernel version:
Cat/proc/version
Uname-
5. view the linux version:
Lsb_release-
Cat/etc/issue
6. Database Status:
SGA: show sga
Archive: archive log list
Temporary tablespace:
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;
Tablespace:
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),
(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;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.