Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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, ±íʾÓɶ¯Ì¬Öµ¾ö¶¨É¨ÃèÄö·ÖÇø£©

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


Ïà¹ØÎÊ´ð£º

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

OracleÖв鿴×Ô¼º´´½¨µÄ±í - Oracle / ¸ß¼¶¼¼Êõ

Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ­´´½¨µÄ±í£¿
select tname from tab;

SQL code:

--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = 'Óû§Ãû';
--2.ËùÓÐÓû§
select * from tab; ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

CREATE OR REPLACE PROCEDURE usp_refreshTopN
 IS
 BEGIN
 
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ