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

²¹³ä£ºv$sql,v$sqlarea,v$sqltextÓÐʲôÇø±ð

http://inthirties.com:90/thread-1202-1-1.html
Ç°ÃæÎÄÕ ”v$sql,v$sqlarea,v$sqltextÓÐʲôÇø±ð“ ¼û http://blog.csdn.net/inthirties/archive/2010/03/10/5364777.aspx
ÕâÀï²¹³äÒ»ÏÂ
²¹³ä£º
1¡¢²éÒ»ÏÂÕâЩÊÓͼµÄ¶¨ÒåÄã¾ÍÄÜÀí½â£¬ËüÃǵÄÔ´¶¼ÊÇÒ»¸ö¡£
SELECT view_definition from v$fixed_view_definition WHERE view_name='GV$SQL';
SELECT view_definition from v$fixed_view_definition WHERE view_name='GV$SQL_AREA';
2¡¢Êµ¼ÊÉÏ×îÄ£ºýµÄÊÇv$sqlÓëv$sqlarea,Çø±ðÓëÁªÏµ³ýbiti˵µÄ»¹ÓУº
a¡¢v$sql_areaÏ൱ÓÚÊÇ°´INST_ID, KGLNAOBJ, KGLHDPAR, KGLNAHSH, KGLNATIM,
GLOBTS0,GLOBT19, KGLOBTS1, KGLOBT20,DECODE(KGLOBT33, 1, 'Y',
'N'),KGLHDCLTÕâЩÁеÄ×Ôv$sqlµÄgroup
by£¬Ò²¾ÍÊÇ˵v$sqlµÄÿһÐбíʾµÄÊÇÿһ¸ösqlÓï¾äµÄÒ»¸översiion£¬¶øv$sqlarea´æ·ÅµÄÊÇÏàͬÓï¾ä²»Í¬versionÒ»¸ö»ã×Ü¡£
b¡¢ v$sqlÓëv$sqlareaµÄÔ´¶¼ÊÇÒ»¸ö£ºX$KGLCURSOR
c¡¢Êµ¼Êµ÷ÓÅÖн¨ÒéʹÓÃv$sql,Ïà¶ÔÀ´Ëµ±Èv$sqlarea¿ì£¬¶øÇÒ»¹²»»á²úÉúshare pool latchµÄÕùÓá£
3¡¢Òòv$sql¼°v$sqlarea´æ·Å×Åͳ¼ÆÐÅÏ¢ÔÚµ÷ÓÅʱʹÓþӶ࣬µ«ÆäsqlÊDz»È«µÄ£¬Èç¹ûÏë»ñµÃÍêÕûµÄsql¾ÍÒªÓÃv$sqltextÁË¡£
ÌṩOracle¹ÜÀí/¹ÊÕÏ´¦Àí/ÓÅ»¯/°²×°/RAC/±¸·Ý»Ö¸´¼¼Êõ·þÎñ,ÌṩרҵµÄOracleÅàѵºÍ×Éѯ·þÎñ¡£

Óʼþ: inthirties@gmail.com
MSN: inthirties@hotmail.com
QQ: inthirties@qq.com
רҵÂÛ̳ http://www.inthirties.com
¼¼Êõ²©¿Í http://blog.csdn.net/inthirties
¸öÈËÕ¾µã http://blog.inthirties.com



Ïà¹ØÎĵµ£º

SQL Óï¾äÓÅ»¯ hust ei

JOINÓÅ»¯
MySQLÖÐjoinµÄʵÏÖ²ÉÓõÄÊÇNested Loop JoinËã·¨¡£Í¨¹ýÇý¶¯±íµÄ½á¹û¼¯×÷Ϊѭ»·»ù´¡Êý¾Ý£¬È»ºó½«¸Ã½á¹û¼¯ÖеÄÊý¾Ý×÷Ϊ¹ýÂË
Ìõ¼þÒ»ÌõÌõµÄµ½ÏÂÒ»¸ö±íÖвéѯÊý¾Ý£¬×îºóºÏ²¢½á¹û£¬Èç¹û´æÔÚºóÐø±í£¬¹ý³ÌÒ²Èç´Ë¡£
¾¡Á¿¼õÉÙjoinÓï¾äÖÐnested loopÑ­»·µÄ´ÎÊý¡£×îÓÐЧµÄ·½·¨ÊÇÈÃÇý¶¯±íµÄ½á¹û¼¯¾¡¿ÉÄܵÄС
ÓÅÏÈÓÅ»¯nested ......

SQLÖÐ CAST Óë CONVERTת»¯º¯ÊýµÄÓ÷¨

 ½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËƵŦÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......

ת£ºsqlÓï¾äʵÏÖ·ÖÒ³»ã×Ü

Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
  (SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
  from ±íÃû
  ORDER BY ID))
  O ......

SQLÓαê¿ìËÙÉÏÊÖ

ÎÊÌâÃèÊö£ºÓÐÒÔÏÂ2ÕÅ±í£¬
     ±íA
     0_id           0_name      0_Salary
   Y2007001     ´ï¸ç         &nbs ......

SQL Server×Ô´ø±¸·ÝÕû¸öÊý¾Ý¿â½Å±¾¹¤¾ß scptxfr.exe


Ê×ÏÈÔÚsqlserverµÄ°²×°Â·¾¶Ï£¬È磺D:\Program Files\Microsoft SQL
Server\MSSQL\£¬ÕÒµ½ÎļþÃûÊÇscptxfr.exeµÄÎļþ,ÀûÓÃÃüÁîÐй¤¾ß£º¾ßÌåÓ÷¨ÈçÏ£º
D:\PROGRA~1\MICROS~2\MSSQL\>scptxfr/?
ÃüÁîÐÐÓï·¨:
SCPTXFR /s
<·þÎñÆ÷> /d <Êý¾Ý¿â> {[/I] | [/P <ÃÜÂë>]}
    &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ