SAP ʹÓÃSQL Trace£¨ST05£©
SAP ʹÓÃSQL Trace£¨ST05£©
SAP R/3 Ìṩ±ê×¼ABAP SQL ¸ú×Ù¹¤¾ß¡£Ê¹ÓÃT-Code:ST05 ¿ÉÒÔ½øÈë×·×ÙÉ趨»Ã棺
ÔÚTrace Modes ÇøÓòÖÐÑ¡ÔñÐèÒªÔÚSAP R/3 Server ÉÏtrace µÄ·¶Î§£º
SQL Trace: ×·×Ù¸ÃAP Server ÉÏÒѹýÂ˵ÄSQL Óï¾ä¡£
Enqueue Trace: ×·×ÙEnqueue Server ÉϵĶÓÁС£
RFC Trace: ×·×Ù¸ÃAP Server ÉÏRFC ÐÐΪ¡£
Buffer Trace: ×·×Ù¸ÃAP Server ÉÏBuffer ÖеÄÐÐΪ¡£
ÕâÀïÈôҪ׷×ÙSQL ÔòֻҪѡÖÐSQL Trace¡£È»ºóÔÚTrace Requests ÇøÓòÖеãÑ¡ Trace on with Filter ½øÐÐÊä³ö¹ýÂË:
ÕâÀï½ö×·×ÙSBA Õ˺ŶÔÓÚMB03 ËùÓеÄSQL²Ù×÷¡£Ò²¿ÉÒÔÌîÈë³ÌÐòÃû³ÆÉõÖÁAP Server ÉϵĽø³Ì´úºÅÀ´×·×Ù¡£»¹¿ÉÒÔÔÚTable name ÇøÓòÑ¡¶¨°üº¬/ÅųýµÄ±íÃû¡£µã»÷¶Ô¹³Ö®ºó¼´Æô¶¯×·×Ù¡£
ÔÚÐèÒª²é¿´×·×Ù½á¹ûʱÐèÒªÏÈÍ£Ö¹×·×Ù(Trace off) È»ºóÔÙµã»÷Display trace ÏÔʾÈçÏ£º
ÐèÒªÖØжԽá¹û½øÐйýÂË£¨ÒòΪSAP R/3Ö»ÓÐÒ»¸ö»òÁ½¸öLog Îļþ£¬ÏµÍ³²»»á×Ô¶¯·Ö½â¶ÔÓ¦³ÌÐòµÄLog ÐÅÏ¢£©¡£Trace modes ֻѡÔñSQL Trace ¡£SQL Trace Period ϵͳÒÑ×Ô¶¯ÉèÖúÃÎÞÐè¸ü¸Ä¡£User name ¿ÉÒÔ×ÔÐÐÉ趨£¬ÕâÀïÉ趨¿ÕÖµ±íʾÈκÎÕ˺ţ¨ÒòΪ¿ªÊ¼×·×Ùʱ½ö¹ýÂËÒ»¸öÕ˺ţ¬ËùÒÔÕâÀïÎÞÐè½øÒ»²½¹ýÂË£©¡£Objectname ±£ÁôϵͳÉ趨£¨ÕâÑù¿ÉÒÔÅųý×·×ÙLog ±¾ÉíËù²úÉúµÄLog ÐÅÏ¢£©¡£
Duration: Ö´ÐÐÕâÌõ²Ù×÷ËùÏûºÄµÄʱ¼ä£¬µ¥Î»ÊÇ΢Ãë¡£1΢Ãë=1£¯1000000Ãë¡£
Objectname: ָʾ¸ÃÌõ²Ù×÷µÄ¶ÔÏ󣬶ÔÓÚSQL Trace Ò»°ã¾ÍÊÇTable name¡£
Op.: ָʾ¸ÃÌõ²Ù×÷µÄÀàÐÍ¡£ÆäÖжÔÓ¦OPENµÄÌõÄ¿¶ÔSQL ÐÔÄܾßÓкܴóµÄ²Î¿¼¼ÛÖµ¡£
&nbs
Ïà¹ØÎĵµ£º
1.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺
select id from t where num is null
¿ÉÒÔÔÚnumÉÏÉèÖÃĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâÑù²éѯ£º
select id from t where num=0
2.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖÐʹÓÃ!=»ò<>²Ù×÷·û£¬·ñÔò½«ÒýÇæ·ÅÆúÊ ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBac ......
SQLÌṩÁËËÄÖÖÄ£ºýÆ¥Å䷽ʽ
1£¬%£º±íʾÈÎÒâ0¸ö»ò¶à¸ö×Ö·û¡£¿ÉÆ¥ÅäÈÎÒâÀàÐͺͳ¤¶ÈµÄ×Ö·û£¬ÓÐЩÇé¿öÏÂÈôÊÇÖÐÎÄ£¬ÇëÔËÓÃÁ½¸ö°Ù·ÖºÅ£¨%%£©±íʾ¡£
±ÈÈç SELECT * from [user] WHERE u_name LIKE '%Èý%'
½«»á°Ñu_nameΪ“ÕÅÈý”£¬“ÕÅèÈý”¡¢“Èý½Å蔣¬“ÌÆÈý²Ø”µÈµÈÓГÈý& ......
1¡¢±à³ÌÓïÑÔÓëOracleÊý¾Ý¿â
1.1¡¢´æ´¢µÄÓëÄäÃûµÄPL/SQL³ÌÐò¿é
Óë´æ´¢µÄPL/SQL³ÌÐò¿éÏà±È£¬ÄäÃûµÄPL/SQL³ÌÐò¿éЧÂʽϵͣ¬´ËÍâÓÉÓÚ¿ÉÄÜÔÚ¶ą̀»úÆ÷Öй«²¼Ô´´úÂ룬»¹»áÒý·¢¹ÜÀíÎÊÌâ¡£
1.2¡¢PL/SQL¶ÔÏó
PL/SQL¶ÔÏó¾ßÓÐÏÂÁÐ5ÖÖÀàÐÍ£º
¹ý³Ì
º¯Êý
³ÌÐò°ü
³ÌÐò°üÖ÷Ìå
´¥·¢Æ÷
2¡¢¹ý³Ì¡¢º¯ÊýÒÔ¼°³ÌÐò°ü
2.1¡¢¹ý³ÌÓëº¯Ê ......
SQL Server 2005 ºÍ2008ÌṩÁ˺ܶàеĺÍÔöÇ¿µÄÉÌÎñÖÇÄܹ¦ÄÜ,°üÀ¨ÀûÓü¯³É·þÎñ(SSIS)ÕûºÏ¶àÖÖÊý¾ÝÔ´;ÀûÓ÷ÖÎö·þÎñ(SSAS)ʹÊý¾ÝÄÚÈݸü·á¸»²¢ÇÒ½¨Á¢¸´ÔÓµÄÉÌÒµ·ÖÎö; ÒÔ¼°ÀûÓñ¨±í·þÎñ(SSRS)±à¼,¹ÜÀí,ºÍÌá½»·á¸»µÄ±¨±í. Èç¹ûÄãÏÖÔÚ»¹²»Çå³þÕâЩ¹¦ÄÜ,ÄÇô½ÓÏÂÀ´Ò»ÏµÁеĽéÉÜ»áÈÃÄã¶ÔSQL ServerÏÖÔÚµÄÉÌÎñÖÇÄÜÖ§³Ö´ó³ÔÒ»¾ª.²»¹ý ......