oracle Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡
oracle
Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡
½â¾ö·½·¨±³¾°
1
ÕûÀíc
Å̵ÄÀ¬»øÎļþ£¬°Éoralce
µÄ¡£log
ÈÕÖ¾Îļþɾ³ý¡£
2
È»ºóoralce
Ò»Ö±²»ÄÜʹÓã¬Ìáʾtns
ÓÐÎÊÌ⣬
È»ºóÔÙÍùÉÏÕÒ×ÊÁÏ£¬Ò»Ö±Ã»Óнâ¾öµô£¬ºóÀ´¿´µ½Ò»±ßÎÄÕÂÈçÏ£¬ÎÊÌâ½â¾öµôÁË£¬Ìغʹó¼Ò·ÖÏí£¡
===================================================
ÏÂÊôÄÚÈÝΪת
===================================================
×Ô¼º»úÆ÷°²×°µÄoracle
£¬ÍêÈ«ÊÇΪÁË·½±ãѧϰ£¬µ«ÊÇÈç¹ûstartup
£¬»úÆ÷Ê®·ÖÂý£¨ÄÚ´æ512M
£©,
ËùÒԺþÃûÓÐstartup
ÁË£¬½ñÌìstartup
£¬³öÎÊÌâÁË£º
Microsoft Windows XP [
°æ±¾ 5.1.2600] (C)
°æÈ¨ËùÓÐ 1985-2001 Microsoft Corp. C:\Documents and Settings\5201314
>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on
ÐÇÆÚÎå 5
ÔÂ 26 10:14:25 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/dd as sysdba
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£
SQL> statrup SP2-0042:
δ֪ÃüÁî "statrup" -
ÆäÓàÐкöÂÔ¡£
SQL> startup ORACLE
Àý³ÌÒѾÆô¶¯¡£ Total System Global Area 205520896 bytes Fixed Size 1248092 bytes Variable Size 88081572 bytes Database Buffers 109051904 bytes Redo Buffers 7139328 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£ ORA-00313:
ÎÞ·¨´ò¿ªÈÕÖ¾×é 1 (
ÓÃÓÚÏß³Ì 1)
µÄ³ÉÔ± ORA-00312:
Áª»úÈÕÖ¾ 1
Ïß³Ì 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\MYDB\REDO01.LOG'
SQL> alter database open resetlogs; alter database open resetlogs *
µÚ 1
ÐгöÏÖ´íÎó: ORA-01139: RESETLOGS
Ñ¡Ïî½öÔÚ²»ÍêÈ«Êý¾Ý¿â»Ö¸´ºóÓÐЧ
SQL> alter database open&nb
Ïà¹ØÎĵµ£º
1. select * from emp;
2. select empno, ename, job from emp;
3. select empno ±àºÅ, ename ÐÕÃû, job ¹¤×÷ from emp;
4. select job from emp;
5. select distinct job from emp;
6. select distinct empno, job from emp;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......
author£ºskate
time£º2010/03/16
µ±ÏµÍ³³öÏÖÐÔÄÜÆ¿¾±Ê±£¬¾¡Á¿½ÏÉÙ²»±ØÒªµÄ×ÊÔ´ÏûºÄ£¬×îºó¾ÍÊÇÆ½ºâcpu£¬Äڴ棬io£¬networkµÈ×ÊÔ´£¬Ê¹Êý¾Ý¿â
¿ÉÒÔÎȶ¨µÄÔËÐС£
oracleÊý¾Ý¿âÓÅ»¯µÄ¸ù±¾ÊÇ
1.¾¡Á¿¼õÉÙ×ÊÔ´ÏûºÄ£¬ÀýÈçÓÅ»¯sql£¬¼õÉÙsql±¾ÉíµÄ×ÊÔ´ÏûºÄ
2.Èç¹ûÎÞ·¨½øÒ»²½¼õÉÙ×ÊÔ´µÄÏûºÄ£¬ÄǾÍÈÃÊý¾Ý¾¡Á¿¿¿½ücpu£¬Ò²¾ÍÊǰÑÊý¾Ý ......
SELECT ID,
col_name,
SUBSTR(col_name, 1, INSTR(col_name || ',', ',', 1, 1) - 1) C1,
SUBSTR(col_name,
......
´´½¨OracleÊý¾Ý¿â£¨ÒÔOracle10gΪÀý£©
ÓÐÁ½ÖÖ´´½¨Êý¾Ý¿âµÄ·½Ê½£¬Ò»ÖÖÊÇÒÔÃüÁîÐнű¾·½Ê½£¬¼´ÊÖ¶¯·½Ê½´´½¨£»ÁíÒ»ÖÖÊÇÀûÓÃOracleÌṩµÄÊý¾Ý¿âÅäÖÃÏòµ¼À´´´½¨¡£±¾ÆªÖ÷Òª½éÉÜÔÚUnixºÍWindowsÏÂÒÔÃüÁîÐнű¾·½Ê½´´½¨OracleÊý¾Ý¿â¡£
Ò»¸öÍêÕûµÄÊý¾Ý¿âϵͳ£¬Ó¦°üÀ¨Ò»¸öÎïÀí½á¹¹¡¢Ò»¸öÂß¼½á¹¹¡¢Ò»¸öÄÚ´ ......