Lista acestor view-uri se poate obţine cu instrucţiunea:
Select name from V$FIXED_TABLE where name like 'V$%';
iar definiţia acestora se poate obţine cu view-ul V$FIXED_VIEW_DEFINITION.
Exemple:
select * from v$version;
select name from v$controlfile;
select member from v$logfile;
select name from v$datafile;
Schimbarea caracteristicilor acestor fişiere se face cu comenzi alter database.
Informaţii suplimentare.
select * from v$lock; select * from v$locked_object;
select * from v$option;
select * from v$parameter;
select SQL_TEXT, ROWS_PROCESSED, OPTIMIZER_MODE, OPTIMIZER_COST, CPU_TIME, BUFFER_GETS, DISK_READS, SORTS, EXECUTIONS from v$sqlarea;
select SID,SERIAL#,USERNAME,STATUS,SERVICE_NAME,OSUSER,MACHINE,TERMINAL,PROGRAM,LOGON_TIME from v$session;
ALTER SYSTEM KILL SESSION 'sid,serial#';
unde sid şi serial# sunt furnizate de instrucţiunea de la punctul precedent.
select username from v$session;