Server/OS Information
Server identification | Representative Query |
Host name where the instance is running | select host_name |
Operating system platform | select platform_name from v$database –-(10g) |
File Information
Oracle file locations | Representative Query |
Control files | select name |
Datafiles | select file_name |
Temp files | select file_name |
Log files | select member |
Archived logs | select name |
Flash recovery area | select name |
Other points of access on the file system indicated by parameters | select * |
Programmatic access to the file system | select directory_path from dba_directories |
Process Information
Processor/Processes | Representative Query |
Session Processes | select p.spid, s.username, s.program from v$process p, v$session s where p.addr=s.paddr order by 2, 3, 1 |
Processes related to parallelism | select slave_name, status |
Memory Information
Memory | Representative Query |
Program Global Area | select * from V$PGASTAT |
System Global Area | select * from v$sga |
No comments:
Post a Comment