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

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ
ÔÚOracleµ÷ÕûÖÐÎÒÃÇ»¹»áÉæ¼°µ½SQL Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄÐÔÄÜ¡£ SQL µ÷ÓŵÄÄ¿±êÊǼòµ¥µÄ£º
Ïû³ý²»±ØÒªµÄ´ó±íÈ«±íËÑË÷£º²»±ØÒªµÄÈ«±íËÑË÷µ¼Ö´óÁ¿²»±ØÒªµÄ I/O £¬´Ó¶øÍÏÂýÕû¸öÊý¾Ý¿âµÄÐÔÄÜ¡£µ÷ÓÅר¼ÒÊ×ÏÈ»á¸ù¾Ý²éѯ·µ»ØµÄÐÐÊýÄ¿À´ÆÀ¼Û SQL ¡£ÔÚÒ»¸öÓÐÐòµÄ±íÖУ¬Èç¹û²éѯ·µ»ØÉÙÓÚ 40% µÄÐУ¬»òÕßÔÚÒ»¸öÎÞÐòµÄ±íÖУ¬·µ»ØÉÙÓÚ 7% µÄÐУ¬ÄÇôÕâ¸ö²éѯ¶¼¿ÉÒÔOracleµ÷ÕûΪʹÓÃÒ»¸öË÷ÒýÀ´´úÌæÈ«±íËÑË÷¡£
¶ÔÓÚ²»±ØÒªµÄÈ«±íËÑË÷À´Ëµ£¬×î³£¼ûµÄµ÷ÓÅ·½·¨ÊÇÔö¼ÓË÷Òý¡£¿ÉÒÔÔÚ±íÖмÓÈë±ê×¼µÄ B Ê÷Ë÷Òý£¬Ò²¿ÉÒÔ¼ÓÈë bitmap ºÍ»ùÓÚº¯ÊýµÄË÷Òý¡£Òª¾ö¶¨ÊÇ·ñÏû³ýÒ»¸öÈ«±íËÑË÷£¬Äã¿ÉÒÔ×Ðϸ¼ì²éË÷ÒýËÑË÷µÄ I/O ¿ªÏúºÍÈ«±íËÑË÷µÄ¿ªÏú£¬ËüÃǵĿªÏúºÍÊý¾Ý¿éµÄ¶ÁÈ¡ºÍ¿ÉÄܵIJ¢ÐÐÖ´ÐÐÓйأ¬²¢½«Á½Õß×÷¶Ô±È¡£
ÔÚһЩÇé¿öÏ£¬Ò»Ð©²»±ØÒªµÄÈ«±íËÑË÷µÄÏû³ý¿ÉÒÔͨ¹ýÇ¿ÖÆÊ¹ÓÃÒ»¸ö index À´´ïµ½£¬Ö»ÐèÒªÔÚ SQL Óï¾äÖмÓÈëÒ»¸öË÷ÒýµÄÌáʾ¾Í¿ÉÒÔÁË¡£
ÔÚÈ«±íËÑË÷ÊÇÒ»¸ö×î¿ìµÄ·ÃÎÊ·½·¨Ê±£¬½«Ð¡±íµÄÈ«±íËÑË÷·Åµ½»º´æÖУ¬µ÷ÓÅר¼ÒÓ¦¸ÃÈ·±£ÓÐÒ»¸öרÃŵÄÊý¾Ý»º³åÓÃ×÷Ðлº³å¡£ÔÚ Oracle7 ÖУ¬Äã¿ÉÒÔʹÓà alter table xxx cache Óï¾ä£¬ÔÚ Oracle8 »òÒÔÉÏ£¬Ð¡±í¿ÉÒÔ±»Ç¿ÖÆÎª·Åµ½ KEEP ³ØÖлº³å¡£
È·±£×îÓŵÄË÷ÒýʹÓà £º¶ÔÓÚ¸ÄÉÆ²éѯµÄËÙ¶È£¬ÕâÊÇÌØ±ðÖØÒªµÄ¡£ÓÐʱ Oracle ¿ÉÒÔÑ¡Ôñ¶à¸öË÷ÒýÀ´½øÐвéѯ£¬µ÷ÓÅר¼Ò±ØÐë¼ì²éÿ¸öË÷Òý²¢ÇÒÈ·±£ Oracle ʹÓÃÕýÈ·µÄË÷Òý¡£Ëü»¹°üÀ¨ bitmap ºÍ»ùÓÚº¯ÊýµÄË÷ÒýµÄʹÓá£
È·±£×îÓÅµÄ JOIN ²Ù×÷£ºÓÐЩ²éѯʹÓà NESTED LOOP join ¿ìһЩ£¬ÓÐЩÔòÊÇ HASH join ¿ìһЩ£¬ÁíÍâһЩÔòÊÇ sort-merge join ¸ü¿ì¡£
ÕâЩ¹æÔò¿´À´¼òµ¥£¬²»¹ýËüÃÇÕ¼ SQL µ÷ÓÅÈÎÎñµÄ 90% £¬²¢ÇÒËüÃÇÒ²ÎÞÐèÍêÈ«¶®µÃ Oracle SQL µÄÄÚ²¿ÔË×÷¡£ÒÔÏÂÎÒÃÇÀ´¼òµ¥¸ÅÀÀÒÔÏ Oracle SQL µÄÓÅ»¯¡£
ÎÒÃÇÊ×ÏȼòÒª²é¿´ Oracle µÄÅÅÐò£¬²¢ÇÒ¿´Ò»¿´ÅÅÐò²Ù×÷ÊÇÈçºÎÓ°ÏìÐÔÄܵġ£
µ÷Õû Oracle µÄÅÅÐò²Ù×÷
ÅÅÐòÊÇ SQL Óï·¨ÖÐÒ»¸öСµÄ·½Ã棬µ«ºÜÖØÒª£¬ÔÚ Oracle µ÷ÕûÖУ¬Ëü³£³£±»ºöÂÔ¡£µ±Ê¹Óà create index ¡¢ ORDER BY »òÕß GROUP BY µÄÓï¾äʱ£¬ Oracle Êý¾Ý¿â½«»á×Ô¶¯Ö´ÐÐÅÅÐòµÄ²Ù×÷¡£Í¨³££¬ÔÚÒÔϵÄÇé¿öÏ Oracle »á½øÐÐÅÅÐòµÄ²Ù×÷£º
ʹÓà Or


Ïà¹ØÎĵµ£º

Sql Server »ù´¡

Èí¼þ £º Sql Server 2005
 
    ÕâÀï²¢²»ÊÇSQLÓï·¨´óÈ«£¬ÒÔÏÂÊdz£ÓõÄÓï¾ä£¬¶Ô£¨Êý¾Ý¿â¡¢±í¡¢×ֶΡ¢Êý¾Ý£©µÄÔöɾ¸Ä²é£¬Èç¹ûÐèÒªÏêÏ¸È«ÃæµÄTransact-SQLÓï¾ä£¬¿ÉÒÔ²éSql ServerÁª»ú´ÔÊ飬ÄÇÀïÊÇ×îÈ«µÄ×ÊÁÏ£¬Ò»°ã°²×°Sql Server¶¼»áĬÈϰ²×°¡£
´ò¿ªSql ServerÁª»ú´ÔÊé
¿ªÊ¼ à ³ÌÐò à&n ......

oracle dg µÄ»ù±¾ÃüÁî

1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
 select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
 select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
 alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
&nb ......

oracle ĬÈÏÁÙʱ±í¿Õ¼ä

¡¡¡¡ ÎÒÃÇ¿ÉÒÔͨ¹ýÏÂÃæµÄÓï¾äÀ´²éѯÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ä£º
¡¡¡¡
¡¡¡¡SQL> select * from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE'£»
¡¡¡¡¡¡
¡¡¡¡ ĬÈÏÁÙʱ±í¿Õ¼äµÄÏÞÖÆ£º
¡¡¡¡
¡¡¡¡1. ĬÈÏÁÙʱ±í¿Õ¼ä±ØÐëÊÇTEMPORARYµÄ:
¡¡¡¡
¡¡¡¡SQL> alter database default temporary t ......

(ת)SQL Server¶àÌõ¼þ²éѯ¾­µäÀý×Ó

ÕâÊÇÒ»¸ö²»´íµÄÀý×Ó£¬ÌØ×ªÔØ·ÖÏíÖ®¡£
 
------------±íÖеÄ×Ö¶Î---------------
CREATE TABLE [dbo].[stuInfo] (
[FNumber] [int] IDENTITY(1,1) NOT NULL ,
[FName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FNameen] [varchar] (35) COLLATE Chinese_PRC_CI_AS ,
[FSex] [char] (1) COLLATE C ......

SQLʹÓÃÁ´½Ó·þÎñÆ÷Ö´ÐÐÔ¶³ÌÊý¾Ý¿âÉϵĴ洢¹ý³Ì

 
--´´½¨Á´½Ó·þÎñÆ÷
exec sp_addlinkedserver 'server_tmp','','SQLOLEDB','Ô¶³Ì·þÎñÆ÷Ãû»òipµØÖ·'
exec sp_addlinkedsrvlogin 'server_tmp','false',null,'Óû§Ãû','ÃÜÂë'
exec sp_serveroption 'server_lnk','rpc out','true' --Õâ¸öÔÊÐíµ÷ÓÃÁ´½Ó·þÎñÆ÷ÉϵĴ洢¹ý³Ì
go
 
--µ÷Óãº
exec server_tmp.Êý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ