Pense-bête du DBA Oracle (Developpez.com)
FAQ Oracle (Developpez.com)

Permet de voir le status d'une instance, ses fichiers de logs associés etc.

  # lsnrctl status

  # su - oracle
  # export ORACLE_SID=<nom_base>

  # sqlplus system/manager

  SELECT STATUS FROM v$instance;

  ps -ef |grep pmon

  COLUMN column_name format a30 -- a30=alphanumeric30
  SET linesize 150

SELECT USERNAME,
       USER_ID,
       DEFAULT_TABLESPACE,
       TEMPORARY_TABLESPACE,
       PASSWORD,
       ACCOUNT_STATUS,
       PROFILE,
       CREATED
FROM DBA_USERS
ORDER BY USERNAME;

ALTER USER scott ACCOUNT UNLOCK;

SELECT
       substr(a.spid,1,9) pid,
       substr(b.sid,1,5) sid,
       substr(b.serial#,1,5) ser#,
       substr(b.machine,1,6) box,
       substr(b.username,1,10) username,
--       b.server,
       substr(b.osuser,1,8) os_user,
       substr(b.program,1,30) program
FROM v$session b, v$process a
WHERE
b.paddr = a.addr
AND TYPE='USER'
ORDER BY spid; 

SHOW PARAMETER instance_name;

SELECT * FROM V$NLS_PARAMETERS;
 ou 
SELECT parameter, VALUE FROM NLS_DATABASE_PARAMETERS;

Exemple SISMARCHES

sqlplus system/xxxxxxxx
 
EXEC dbms_stats.gather_schema_stats(ownname=>'SYSADM',estimate_percent=>50,method_opt=>'FOR ALL COLUMNS SIZE 100',degree=>1,cascade=>TRUE);