ORACLE³£ÓÃÃüÁî´óÈ«

¼ì²éÊý¾Ý¿âÁ¬Í¨
TNSPING
 
Êý¾Ý¿âÕìÌý
lsnrctl
 
²é¿´SID
SQL> SELECT * from V$INSTANCE;
SQL> SELECT * from V$DATABASE;
 
SQL> / Ö´ÐÐÉϸö²Ù×÷ÃüÁî
SQL> EDIT¶ÁÈ¡ÃüÁ´æÇø
 
²é¿´ÓïÑÔÅäÖÃ
SQL> show parameters nls
SQL> select * from V$NLS_PARAMETERS
 
²é¿´Æô¶¯²ÎÊýÎļþ
SQL> show parameters spfile;
 
²é¿´Êý¾Ý¿éÅäÖôóС
SQL> show parameters db;
 
²é¿´ORACLE°æ±¾
SQL> SELECT * from V$VERSION
ÏÔʾËùÓÐ×齨°æ±¾
SQL> select * from product_component_version;
 
ÅäÖÃÊä³öÈÕÖ¾
SQL> spool c:\testora.log
SQL> spool off
 
Çл»¹éµµÈÕÖ¾
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
SQL> ALTER SYSTEM SWITCH LOGFILE;
 
²é¿´Êý¾Ý¿â¶ÔÏó½á¹¹
SQL> desc v$dbfile
 
²é¿´Datafile
SQL>SELECT * from V$DBFILE;
SQL>SELECT * from V$DATAFILE;
 
²é¿´ËùÓеÄÓû§
SQL> SELECT USERNAME from DBA_USERS
 
²é¿´¿ØÖÆÎļþ
SQL> select * from v$controlfile;
 
ÉèÖÃÊä³öµÄÐпí
SQL> set linesize 20000
 
²é¿´REDOLOGÎļþ
SQL> SELECT * from V$LOGFILE;
 
²é¿´±í¿Õ¼ä
SQL> SELECT * from V$tablespace;
 
ÊÖ¶¯É¾³ý¹éµµÈÕÖ¾ºó£¬Í¬²½CATALOG
SQL>CROSSCHECK ARCHIVELOG ALL
SQL>CHANGE ARCHIVELOG ALL CROSSCHECK
¡¡1¡¢  ²é¿´Êý¾Ý¿âµÄÃû×ֺ͹鵵״̬
¡¡¡¡SQL> select name,log_mode from v$database;
¡¡¡¡NAME      LOG_MODE
¡¡¡¡--------- ------------
¡¡¡¡HB130000  ARCHIVELOG
¡¡¡¡2¡¢  ²é¿´Êý¾Ý¿âµÄinstanceÃû×ÖºÍ״̬
¡¡¡¡SQL> select instance_name,status from v$instance;
¡¡¡¡INSTANCE_NAME    STATUS
¡¡¡¡hb130000         OPEN
¡¡¡¡3¡¢²é¿´±í¿Õ¼äÃû³Æ¡¢×´Ì¬ºÍ¹ÜÀí·½Ê½
¡¡¡¡SQL> select tablespace_name,status,extent_management from dba_tablespaces;
¡¡¡¡TABLESPACE_NAME                STATUS    EXTENT_MAN
¡¡¡¡SYSTEM