Monday, June 8, 2009

HER ZAMAN EL ALTINDA OLMASI GEREKENLERDEN BAZILARI

Server/OS Information

Server identification

Representative Query

Host name where the instance is running

select host_name
from v$instance;

Operating system platform

select platform_name from v$database –-(10g)

File Information

Oracle file locations

Representative Query

Control files

select name
from v$controlfile;

Datafiles

select file_name
from Dba_data_files;

Temp files

select file_name
from Dba_temp_files;

Log files

select member
from v$logfile;

Archived logs

select name
from v$archived_log

Flash recovery area

select name
from v$recovery_file_dest

Other points of access on the file system indicated by parameters

select *
from v$parameter where value like '%/%' or value like '%/%';

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
from v$PQ_SLAVE

Memory Information

Memory

Representative Query

Program Global Area

select * from V$PGASTAT

System Global Area

select * from v$sga

No comments: