28.4.2 ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ
28.4.2 ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ
OracleÌṩÁË3¸öÎļþ£¬ÓÃÓÚÅäÖÃOracleÊý¾Ý¿â·þÎñµÄ×Ô¶¯Æô¶¯£¬ËüÃÇ·Ö±ðÊÇ/etc/oratab¡¢$ORACLE_HOME/bin/dbstartÒÔ¼°$ORACLE_HOME/bin/dbshut¡£¹ØÓÚÕâ3¸öÎļþµÄ˵Ã÷ÈçÏÂËùʾ¡£
q /etc/oratab£ºÔÚ¸ÃÎļþÖÐÖ¸¶¨ÐèÒª×Ô¶¯Æô¶¯ºÍ¹Ø±ÕµÄÊý¾Ý¿â¡£
q $ORACLE_HOME/bin/dbstart£º¶ÁÈ¡oratabÎļþÖеÄÄÚÈÝ£¬Æô¶¯ÏàÓ¦µÄÊý¾Ý¿â²¢Æô¶¯ÍøÂç¼àÌý³ÌÐò¡£
q $ORACLE_HOME/bin/dbshut£º¶ÁÈ¡oratabÎļþÖеÄÄÚÈÝ£¬¹Ø±ÕÏàÓ¦µÄÊý¾Ý¿â²¢¹Ø±ÕÍøÂç¼àÌý³ÌÐò¡£
¾ßÌåÅäÖò½ÖèÈçÏÂËùÊö¡£
£¨1£©±à¼oratabÎļþ¡£¸ÃÎļþ±£´æÁËϵͳÖÐËùÓÐÒÑ´´½¨µÄÊý¾Ý¿âµÄÐÅÏ¢£¬Ã¿¸öÊý¾Ý¿â¶ÔÓ¦Ò»ÐмǼ£¬ÒÔ#ºÅ¿ªÍ·µÄÊÇ×¢ÊÍÐС£ÀýÈçorclÊý¾Ý¿âµÄ¶ÔÓ¦¼Ç¼ÈçÏÂËùʾ¡£
orcl:/u01/app/oracle/product/11.1.0/db_1:N
Èç¹ûÒªÉèÖÃorclÊý¾Ý¿âÔÚ¿ª»úʱ×Ô¶¯Æô¶¯£¬°Ñ¸Ã¼Ç¼×îºóµÄN¸ÄΪY£¬¸ü¸ÄºóµÄ½á¹ûÈçÏÂËùʾ¡£
orcl:/u01/app/oracle/product/11.1.0/db_1:Y
£¨2£©ÔÚ/etc/init.dĿ¼Ï´´½¨Îļþoracle£¬¼ÓÈëÈçÏÂÄÚÈÝ£º
#!/bin/sh
# chkconfig: 345 90 10
# description: Oracle auto start-stop script.
#
ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
# ʹÓÃORA_HOME±äÁ¿ÉèÖÃOracleÖ÷Ŀ¼µÄλÖÃ
ORA_OWNER=oracle # ʹÓÃORA_OWNER±äÁ¿ÉèÖÃOracleÓû§
# Èç¹ûdbstart½Å±¾Îļþ²»´æÔÚ£¬Ôò·µ»Ø´íÎóÐÅÏ¢
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"# Êä³öOracleÎÞ·¨Æô¶¯µÄ´íÎó
exit
fi
case "$1" in
'start') # Èç¹û²ÎÊýΪstart
# Ö´ÐÐdbstart½Å±¾Æô¶¯OracleÊý¾Ý¿â
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
;;
'stop') &n
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
28.1 Oracle 11g¼ò½é
¾¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......
hints 這個東ʹÓõĺõÄ話ºÜºÃÓá£ÔÚ½øÐÐsqlÖ´Ðйý³ÌÖУ¬ÓÉÓÚÓÐʱºòϵͳ×Ô¶¯ÓÅ»¯µÄ·½Ê½²¢²»ÊÇ×îÓŵġ£ÐèÒªÎÒÃÇÊÖ¹¤Ìí¼ÓhintÀ´Ìá¸ß²éѯЧÂÊ¡£ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñ ......
×î½ü½Ó´¥OracleµÄ¶«Î÷£¬¸Õ¸Õ¿ªÊ¼Ñ§Ï°²¢Í¬Ê±×öµã¶«Î÷£¬×î½üÀÏÊÇʹÓô洢¹ý³Ì¡£ÏÖÔÚͨ¹ýÎÒ¸öÈ˵ÄʹÓüòµ¥ËµÏÂ×Ô¼ºµÄ¸ÐÊÜ£¡
ÔÚÉè¼Æ´æ´¢¹ý³ÌÖУ¬Ò»±¾Í¨¹ý¶þ¸ö·½Ê½ÊµÏÖ£º
1£º¾ÍÊǼòµ¥µÄʵÏÖÓαê
---¹ý³ÌµÄÉùÃ÷---
......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
C ......