Oracle RACÐÔÄÜ Oracle sequence ÐÔÄܲâÊÔ
ÔÚOracle RAC»·¾³ÖУ¬ÏµÍ³ÐÔÄÜ»áÊܵ½Ó°Ï죬Ö÷Òª¼¯ÖÐÔÚBlockÔÚinstanceÖ®¼äµÄ´«Ê䣬¾¡¹Üoracle 10g ÖвÉÓÃÁËCache FusionÀ´¸ÄÉÆÒÔÇ°ÖØdiskÖжÁÈ¡Êý¾Ý¡£ÆäÖеÄÒ»¸ö²¿·Ö¾ÍÊǹØÓÚoracle sequenceµÄÐÔÄÜÎÊÌâ
ÏÂÃæÊǹØÓÚsequence µÄcacheºÍorder¶Ôrac ÐÔÄܵÄÓ°Ï죬´Ó²âÊÔÖп´µ½Ôö´ócacheºÍ²ÉÓÃnon-orderedµÄsequenceÐÔÄÜÊܵ½µÄÓ°ÏìºÜС¡£
drop sequence test_rac;
create sequence test_rac;
set timing on
declare
dummy number;
begin
for i in 1..50000 loop
select test_rac.nextval into dummy from dual;
end loop;
end;
/
cache 20, non-ordered
one instance - 2.46 seconds
two instance - 6.20 seconds
drop sequence test_rac;
create sequence test_rac order;
set timing on
declare
dummy number;
begin
for i in 1..50000 loop
select test_rac.nextval into dummy from dual;
end loop;
end;
/
cache 20, ordered
one instance - 5.29 seconds
two instance - 13.30 seconds
drop sequence test_rac;
CREATE SEQUENCE test_rac
CACHE 1000;
set timing on
declare
dummy number;
begin
for i in 1..50000 loop
select test_rac.nextval into dummy from dual;
end loop;
end;
/
cache 1000, non-ordered
one instance - 1.16 seconds
two instance - 1.54 seconds
drop sequence test_rac;
CREATE SEQUENCE test_rac
CACHE 1000 ORDER;
set timing on
declare
dummy number;
begin
for i in 1..50000 loop
select test_rac.nextval into dummy from dual;
end loop;
end;
/
cache 1000, ordered
one instance - 3.46 seconds
two instance - 8.47 seconds
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô ......
ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
¡¡¡¡error£º the account is locked
¡¡¡¡È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
¡¡¡¡1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
¡¡¡¡2.´ËÓû§±»¹ ......
oracle ÖÁ½ñûÓÐÍÆ³öÕë¶Ôwin7µÄ°æ±¾£¬ÎÞÄÎ֮ϲéÑ¯ÍøÂç£¬ÍøÉÏ´óϺ±íʾÐÞ¸Ärefhost.xmlÎļþ¼´¿É¡£
½øÈë×Ô¼ºÊµÕ½½×¶Î£¬´Óoracle¹Ù·½ÏÂÔØoracle 10g for vista and windows2K8 x86°æ(for windowsÊÇÖ§³ÖvistaÄں˵ģ¬win7µÄÄÚºËÓë2008ÒÔ¼°vistaµÄÄÚºËÊÇÒ»Ñù)¡£
Ïȵã»÷°²×°£¬ÔÚ°²×°µÄ°æ±¾¼ì²âʱÌáʾĿǰoracle²»Ö§³ÖversionΪ6 ......
°²×°…………
ÒýÓõÄhttp://mamaoyuan625.javaeye.com/blog/617502
°²×°oracle 10gºó£¬µÇ¼ ³öÏÖ
the account is locked
Õâ¸ö´íÎ󼸺õËùÓеijõѧÕß¶¼»áÓöµ½.
Æäʵ½â¾ö°ì·¨·Ç³£¼òµ¥.
ÇëÊäÈëÓû§Ãû: SYSTEM
ÊäÈë¿ÚÁî:admin(×¢Òâ,Õâ¸öÃÜÂëÊÇÄãÔÚ°²×°oracleʱµÚÒ»²½ÉèÖõÄ)
È»ºóϵͳ»áÏÔ ......