Oracle´Ó·Ç¹éµµÄ£Ê½±ä³É¹éµµÄ£Ê½
http://www.cuijie.net.cn/?cat=6
¸ü¸ÄÊý¾Ý¿âµÄ¹éµµÄ£Ê½ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿â£¬ÔÚmountģʽÏÂÐ޸쬼òÒª²½Öè
1 ÒÔshutdown immediate ·½Ê½¹Ø±ÕÊý¾Ý¿â
2 Æô¶¯ÊµÀýµ½mount״̬
3 ¸ü¸ÄÔËÐÐģʽ²¢´ò¿ªÊý¾Ý¿â
²Ù×÷²½Ö裺
1 µÇ¼Êý¾Ý¿â²é¿´Êý¾Ý¿âµÄ¹éµµ×´Ì¬
SQL> archive log list;
Èç¹û³öÏÖÐÅÏ¢£º
Database log mode No Archive Mode
Automatic archival Disabled
ÔòΪ·Ç¹éµµÄ£Ê½
2 ¹Ø±ÕÊý¾Ý¿â
SQL>shutdown immediate;
3 Æô¶¯Êý¾Ý¿âµ½mount״̬
SQL>startup mount;
4 Æô¶¯¹éµµÄ£Ê½
SQL>alter database archivelog; (·Ç¹éµµÄ£Ê½Îª£ºalter database noarchivelog)
5 ´ò¿ªÊý¾Ý¿â
SQL>alter database open;
²é¿´¹éµµÄ£Ê½×´Ì¬
SQL>archive log list
Èç¹û³öÏÖÐÅÏ¢£º
Database log mode Archive Mode
Automatic archival Enabled
³É¹¦¸Ä³É¹éµµÄ£Ê½
http://uplinux.com/online/dodev/sjk/2009/1103/243.html
OracleÊý¾Ý¿â¿ÉÒÔÔËÐÐÔÚ2ÖÖģʽÏÂ:¹éµµÄ£Ê½(archivelog)ºÍ·Ç¹éµµÄ£Ê½(noarchivelog)
¹éµµÄ£Ê½¿ÉÒÔÌá¸ßOracleÊý¾Ý¿âµÄ¿É»Ö¸´ÐÔ£¬Éú²úÊý¾Ý¿â¶¼Ó¦¸ÃÔËÐÐÔÚ´ËģʽÏ£¬¹éµµÄ£Ê½Ó¦¸ÃºÍÏàÓ¦µÄ±¸·Ý²ßÂÔÏà½áºÏ£¬Ö»Óй鵵ģʽûÓÐÏàÓ¦µÄ±¸·Ý²ßÂÔÖ»»á´øÀ´Âé·³¡£
±¾Îļòµ¥½éÉÜÈçºÎÆôÓú͹رÕÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
1.shutdown normal»òshutdown immediate¹Ø±ÕÊý¾Ý¿â
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
Ïà¹ØÎĵµ£º
15. /*+USE_CONCAT*/
¶Ô²éѯÖеÄWHEREºóÃæµÄORÌõ¼þ½øÐÐת»»ÎªUNION ALLµÄ×éºÏ²éѯ. (ã¶®°¡,ÏÈ´æ×Å)
ÀýÈç:
select /*+use_concat */ * from emp where deptno=10 OR empno=7788;
Execution Plan
----------------------------------------------------------
0 S ......
--ÈçºÎÓÃgrade±íµÄ×ÊÁÏÈ¥¸üÐÂusertable±íµÄ×ÊÁÏ£¨ÓйØÁªµÄ×Ö¶Îuserid£©
update usertable u set u.grade =
(select g.grade from grade g where g.userid = u.userid);
--ÈçºÎʹ²éѯ½á¹û×Ö¶ÎÉú³ÉÐòºÅ
select rownum, t.* from sm_t_pad_new t
--ÈçºÎ¿ìËÙ×öÒ»¸öºÍÔ±íÒ»ÑùµÄ±¸·Ý±í
create ......
SQL*LOADERÊÇORACLEµÄÊý¾Ý¼ÓÔØ¹¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþÇ¨ÒÆµ½ORACLEÊý¾Ý¿âÖС£SQL*LOADERÊÇ´óÐÍÊý¾Ý
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨¡£
¡¡¡¡ÔÚNTÏ£¬SQL*LOADERµÄÃüÁîΪSQLLDR£¬ÔÚUNIXÏÂÒ»°ãΪsqlldr/sqlload¡£
¡¡¡¡ÈçÖ´ÐУºd:\oracle>sqlldr
SQL*Loader: Release 8.1.6.0.0 - Production on ÐÇÆÚ¶þ 1ÔÂ 8 11:06:42 2 ......
Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scattered Read Indicates many full table scans—tune the code; cache small tables ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......