Oracle ¿Í»§¶ËÅäÖüàÌý(TNSNames.oraÉèÖÃ)
¢Ù Ö»ÐèÔÚÎļþ TNSNames.ora ÖмÓÈëÒÔϽڵ㣬¼´¿É³É¹¦ÅäÖüàÌý
ORCL190 = //ºìÉ«²¿ÃÅΪÁ¬½Ó¼àÌýÃû×Ö
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.190)(PORT = 1521)) //ºìÉ«²¿ÃÅΪ·þÎñÆ÷ËùÔÚIPµØÖ· 1521Ϊ¶Ë¿ÚºÅ
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl) //ºìÉ«²¿ÃÅΪÊý¾Ý¿âÃû
)
)
¢Ú ÓÃDOS Á¬½ÓOracleÊý¾Ý¿â,¿´¿´ÊÇ·ñÄÜÁ¬ÉÏÊý¾Ý¿â
>CMD
>sqlplus Óû§Ãû/ÃÜÂë@½Ó¼àÌýÃû×Ö
Ïà¹ØÎĵµ£º
The DB File Sequential Read wait event generally indicates a single block read (an index read,
for example). A large number could indicate poor joining orders of tables or unselective indexing.
This number will certainly be large (normally) for a high-transaction, well-tuned system. You ......
1.LVM:
[root@vmfs ~]# pvdisplay
--- Physical volume ---
PV Name /dev/sdg
VG Name db_v4
PV Size  ......
http://www.javaeye.com/topic/366991#
×÷Ϊһ¸ö¿ª·¢ÈËÔ±£¬¿ªÊ¼ÈÏÕæÏµÍ³Ñ§Ï°
Oracle SQLÒ²Ö»ÓÐÔÂÓ֮࣬ǰµÄ
SQLÖª
ʶ½ö½öÊÇÏîÄ¿ÀïÃæÓõ½Ê²Ã´¾ÍÈ¥¿´Ê²Ã´£¬¼òµ¥Ëµ¾ÍÊÇ
Read The Fxxking Guide¡£ÔÚϵͳѧϰ
Oracle
SQL֮ǰ£¬°³µÄÏë·¨¾ÍÊÇ“°´ÕÕÐèÇóÍê³É¹¦ÄÜ£¬Ê£ÏµĽ»¸ø
DBAÀ´´¦À픡£Õâ¸öÏë·¨´ÓÕûÌåÀ´¿´ÏÔ ......
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¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......