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

Çó½ÌoracleÖ´Ðмƻ®ÖеÄÒâ˼ - Oracle / ·Ç¼¼ÊõÇø

oracleÖ´Ðмƻ®ÖÐһЩÊý×ÖÊÇʲôÒâ˼£¬Ë­ÓÐÕâ·½ÃæµÄ×ÊÁϸøÎÒѧϰѧϰ
±ÈÈç

PSTART,PSTOPµÈµÄÊý×ÖÊÇʲôÒâ˼°¡
---------------------------------------------------------------------------------------------------- 

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | 

---------------------------------------------------------------------------------------------------- 

| 0 | SELECT STATEMENT | | 6 | 168 | 126 (4)| 00:00:02 | | | 

| 1 | HASH GROUP BY | | 6 | 168 | 126 (4)| 00:00:02 | | | 

| 2 | NESTED LOOPS | | 3683 | 100K| 125 (4)| 00:00:02 | | | 

|* 3 | TABLE ACCESS FULL | TIMES | 6 | 90 | 18 (0)| 00:00:01 | | | 

| 4 | PARTITION RANGE ITERATOR| | 629 | 8177 | 18 (6)| 00:00:01 | KEY | KEY | 

|* 5 | TABLE ACCESS FULL | SALES | 629 | 8177 | 18 (6)| 00:00:01 | KEY | KEY |

>PSTART,PSTOPµÈµÄÊý×ÖÊÇʲôÒâ˼°¡

ÓзÖÇø±íʱ»áÓÐÕâ2¸öÊýÖµ£¬pstart±íʾ¿ªÊ¼É¨ÃèµÄ·ÖÇø£¬pstop±íʾ½áÊøÉ¨ÃèµÄ·ÖÇø¡£

|* 5 | TABLE ACCESS FULL | SALES | 629 | 8177 | 18 (6)| 00:00:01 | KEY | KEY |
£¨ÕâÒ»¾ä±íʾ£¬È«±íɨÃè±í·ÖÇø£¬pstart:key, pstop:key, ±íʾÓɶ¯Ì¬Öµ¾ö¶¨É¨ÃèÄö·ÖÇø£©

-------------------------------------------------
Ö´Ðмƻ®


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

asp.net·¢²¼Ê±£¬Oracle±¨´í - .NET¼¼Êõ / ASP.NET

1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
  vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ