Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE NLS_LANG²ÎÊýÏê½â

NLS_LANG²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG= <Language>_ <Territory>. <Clients Characterset>
ÆäÖУº
LANGUAGEÖ¸¶¨:
-OracleÏûϢʹÓõÄÓïÑÔ
-ÈÕÆÚÖÐÔ·ݺÍÈÕÏÔʾ
TERRITORYÖ¸¶¨
-»õ±ÒºÍÊý×Ö¸ñʽ
-µØÇøºÍ¼ÆËãÐÇÆÚ¼°ÈÕÆÚµÄϰ¹ß
CHARACTERSET:
-¿ØÖƿͻ§¶ËÓ¦ÓóÌÐòʹÓõÄ×Ö·û¼¯


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

¡¾×ª¡¿oracle ¶¯Ì¬ÐÔÄÜ(V$)ÊÓͼ

C.1 ¶¯Ì¬ÐÔÄÜÊÓͼ
Oracle ·þÎñÆ÷°üÀ¨Ò»×é»ù´¡ÊÓͼ£¬ÕâЩÊÓͼÓÉ·þÎñÆ÷ά»¤£¬ÏµÍ³¹ÜÀíÔ±Óû§ SYS ¿ÉÒÔ
·ÃÎÊËüÃÇ¡£ÕâЩÊÓͼ±»³ÆÎª¶¯Ì¬ÐÔÄÜÊÓͼ£¬ÒòΪËüÃÇÔÚÊý¾Ý¿â´ò¿ªºÍʹÓÃʱ²»¶Ï½øÐиüУ¬
¶øÇÒËüÃǵÄÄÚÈÝÖ÷ÒªÓëÐÔÄÜÓйء£
ËäÈ»ÕâЩÊÓͼºÜÏñÆÕͨµÄÊý¾Ý¿â±í£¬µ«ËüÃDz»ÔÊÐíÓû§Ö±½Ó½øÐÐÐ޸ġ£ÕâЩÊÓͼÌṩ
ÄÚ²¿´ÅÅ̽ṹºÍ ......

Oracle 10gR2°²×°

Ò»¡¢ÏµÍ³Ó²¼þÐèÇó
1¡¢ÖÁÉÙ1024MBÎïÀíÄÚ´æ(3114848)
        # grep MemTotal /proc/meminfo
2¡¢¿ÉÓý»»»ÇøÒªÇóÈçÏÂ±í£º
        # grep SwapTotal /proc/meminfo
¿ÉÓÃÄÚ´æ
½»»»Çø´óС
Between 1024 MB and 2048 MB
1.5 times the size of ......

Èý²½½ÌÄãÕÆÎÕOracleÍⲿ±í

Íâ±í(external table)¾ÍÏñÆÕͨµÄ±í¶ÔÏñÒ»Ñù£¬¿ÉÒÔselectµÈ£¬Ö»ÊÇËüÊÇÖ»¶ÁµÄ£¬Êý¾Ý¿âÖÐÖ»±£´æÁ˱í½á¹¹µÄÃèÊö£¬±íÊý¾ÝȴûÓдæ·ÅÔÚÊý¾Ý¿âÄÚ£¬¶øÊÇ´æ·ÅÔÚÁËÎļþϵͳÉÏ¡£µ±Óû§Ïëż¶ûʹÓÃÊý¾Ý¿âÍâµÄ½á¹¹»¯Êý¾Ýʱ£¬ÓÃÆðÍâ±íÀ´¾Í·Ç³£·½±ã£¬ÉõÖÁ±Èsqlldr¶¼Òª·½±ãµÄ¶à¡£ÔÚÕâÆªÎÄÕÂÀÎÒÃÇΪ´ó¼ÒÑÝʾÁË
¡¡¡¡Èý²½¾ÍÕÆÎÕoracleÍâ±í¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ