sql2005 Á´½Ó·þÎñÆ÷ Á¬½ÓOracle...
Ò»¡¢½¨Á¢Á´½Ó·þÎñÆ÷
ÓÐÈËϲ»¶µ÷ÓÃϵͳ¹ý³ÌÀ´½¨Á¢£¬µ«ÎÒ¸öÈ˶Ôϵͳ¹ý³ÌûÓÐÌØ±ðµÄѧϰ £¬ËùÒÔÓõÄÊǽçÃæÉèÖ㬵±È»ÓÐÐËȤҲ¿ÉÒÔÑо¿Ò»Ïµģ¬ÒòΪ¿ÉÒÔ°ÑSQLÖ´Ðе¼³öÀ´¡£
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver @server = N'TEST2', @srvproduct=N'ORCL', @provider=N'OraOLEDB.Oracle', @datasrc=N'TEST2'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST2', @optname=N'use remote collation', @optvalue=N'true'
GO
USE [master]
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'TEST2', @locallogin = N'sa', @useself = N'False', @rmtuser = N'IFSAPP', @rmtpassword = N'IFSAPP'
GO
USE [master]
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'TEST2', @locallogin = NULL , @useself = N'False', @rmtuser = N'IFSAPP', @rmtpassword = N'IFSAPP'
GO
ÈçÉÏ£¬EXEC master.dbo.sp_addlinkedserver @server = N'TEST2', @srvproduct=N'ORCL', @provider=N'OraOLEDB.Oracle', @datasrc=N'TEST2' ÊÇÔÚϵͳÀィÁ¢Á´½Ó¡£
×¢Ò⣬Ҫ½¨Á¢Á´½Ó֮ǰ£¬ÒªÔÚSQLÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÏȰ²×°OracleµÄ¿Í»§¶Ë£¬²¢ÅäÖúÃOracleµÄʵÀýÁ¬½Ó¡£
@server = N'TEST2' Õâ¸öÊDzÎÊýÉ趨Á´½Ó·þÎñÆ÷Ãû³Æ¡£
&nbs
Ïà¹ØÎĵµ£º
SELECT EXECUTIONS , DISK_READS, BUFFER_GETS,
¡¡¡¡ROUND((BUFFER_GETS-DISK_READS)/BUFFER_GETS,2) Hit_radio,
¡¡¡¡ROUND(DISK_READS/EXECUTIONS,2) Reads_per_run,
¡¡¡¡SQL_TEXT
¡¡¡¡from V$SQLAREA
¡¡¡¡WHERE EXECUTIONS>0
¡¡¡¡AND BUFFER_GETS > 0
¡¡¡¡AND (BUFFER_GETS-DISK_READS)/BUFFER_GETS ......
¹ØÓÚPL/SQLÖжԴ洢¹ý³Ìadd debug information
http://space.itpub.net/13129975/viewspace-626245
Èç¹ûʹÓÃPL/SQL DeveloperÖÐÑ¡ÔñÒ»¸ö´æ´¢¹ý³Ìdebugµ«ÓÖdebug²»½øÈ¥£¡
½â¾öÕâ¸öÎÊÌâÊǺܼòµ¥µÄ£¬Ö»ÐèÒªÔÚPL/SQL DeveloperÖÐÑ¡ÔñÒªdebugµÄ´æ´¢¹ý³Ì£¬È»ºóµãÓÒ¼ü£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡Ôñ"Add debug information"ºóÔÙÖ ......
TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98  ......
¡¡Ò»¡¢OracleÊý¾Ý¿âÖ§³ÖµÄ´ó¶ÔÏóÊý¾ÝÀàÐÍ¡£
¡¡¡¡ÔÚOracleÊý¾Ý¿âÖÐΪÁ˸üºÃµÄ¹ÜÀí´óÈÝÁ¿µÄÊý¾Ý£¬×¨ÃÅ¿ª·¢ÁËһЩ¶ÔÓ¦µÄ´ó¶ÔÏóÊý¾ÝÀàÐÍ¡£¾ßÌåµÄÀ´Ëµ£¬ÓÐÈçϼ¸ÖÖ£º
¡¡¡¡Ò»ÊÇBLOBÊý¾ÝÀàÐÍ¡£ËüÊÇÓÃÀ´´æ´¢¿É±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý¡£ÓÉÓÚÆä´æ´¢µÄÊÇͨÓõĶþ½øÖÆÊý¾Ý£¬Îª´ËÔÚÊý¾Ý¿âÖ®¼ä»òÕßÔÚ¿Í»§¶ËÓë·þÎñÆ÷Ö®¼ä½øÐд«ÊäµÄʱºò£¬ ......