flashback pour annuler en tant qu'utilisateur
redolog pour annuler en tant qu'admin

startora (Dans Demarrer) pour démarrer la base

connect sys/dbufr as sysdba

dbca pour configurer

show parameter pfile

select * from v$background
select * from v$parameter
select * from v$bgprocess

setlines[132]

COL option_ FORMAT A60 HEAD 'Options installées'

show sga

desc v$instance

col instance_name for A15
col host_name for A15
col version for A15
col database_status for A15
col status for A15
col status for A10
col archiver for A15

select instance_name,host_name,version,database_status,status,archiver,
TO_CHAR(startup_time,'DD/MM/YYYY HH24:MI:SS')
timestartup,logins
FROM v$instance;

set head of
select "total system global area",sum(value),'bytes' from v$sga
union all
select name,value,'bytes' from v$sga

desc dict