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

oracleºÍsqlserver²éѯʱ×èÈûÇé¿ö

1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(ʵ¼ÊÉÏǰһ¸ösessionÔÚupdate»òdeleteʱ¾ù»á×èÈû±¾´Î²éѯ,µ±È»,Èç¹û¼ÓÉÏwith (nolock),Ò²²»»á±»×èÈû)


Ïà¹ØÎĵµ£º

Oracle Data blocks £¬Extents£¬Segment

£¨Ò»£©Data blocks £¬Extents£¬Segment
    Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼­½á¹¹¡£
    ÏÈ¿´Data blocks£¨Ò²½ÐÂß¼­¿é£¬oracle¿é£¬Ò³£©°É£¬oracle´æ´¢Êý¾Ý¶¼ÊÇÔÚÕâЩÊý¾Ý¿éÖУ¬Ò»¸öÊý¾Ý¿éÊÇ´ÅÅÌÉÏÊý¾Ý¿âÎïÀí¿Õ¼äһϵÁÐÎïÀí×Ö½ÚµÄ×é³É¡£
    ±ÈData blocks¸ü¸ßÒ»²ãµÄÂß¼­Êý¾Ý¿é¿Õ¼äÊÇe ......

Êý¾Ý¿âtimestenÓë oracle ´¦ÀíÈÕÆÚÉÏд·¨ÉϵIJ»Í¬

     ÓÉÓÚ¹«Ë¾ÒµÎñÔö³¤½Ï¿ì£¬Êý¾Ý¿âoracleѹÁ¦Ô½À´Ô½´ó£¬¹«Ë¾¿¼ÂÇÔÚÓ¦Ó÷þÎñÆ÷ Websphere ºÍ Êý¾Ý¿âoracleÖ®¼äÔö¼Ó timestenÊý¾Ý¿âÀ´ÊµÏÖÊý¾ÝµÄ¶Áд·ÖÀ룬ÁíÍâÓÉÓÚtimestenÊÇÄÚ´æÊý¾Ý¿â£¬ËùÒÔ²éѯËÙ¶ÈÉÏÒªÓÅÓÚ oracle Êý¾Ý¿â£¬Á½¸öÊý¾Ý¿âËäÈ»¶¼ÊÇoracle¹«Ë¾µÄ²úÆ·£¬µ«ÊÇÔںܶàsqlµÄд·¨ÉÏÊDz»ÏàͬµÄ£¬Ï ......

ORA 00054´íÎó OracleÊý¾Ý¿âµÄËø²Î¿¼×ÊÁÏ

½â¾ö·½°¸£º
    select session_id from v$locked_object;  --Ê×Ïȵõ½±»Ëø¶ÔÏóµÄsession_id
    SELECT sid, serial#, username, osuser from v$session where sid = session_id;   --ͨ¹ýÉÏÃæµÃµ½µÄsession_idȥȡµÃv$sessionµÄsidºÍserial#£¬È»ºó¶Ô¸Ã½ø³Ì½øÐÐÖÕÖ¹¡£
&n ......

oracle dbtimezoneÐÞ¸Ä

select dbtimezone from dual ;  --²é¿´Êý¾Ý¿âÊ±Çø
select sessiontimezone from dual ;  --²é¿´»á»°Ê±Çø
1.select u.name || '.' || o.name || '.' || c.name TSLTZcolumn
       from sys.obj$ o, sys.col$ c, sys.user$ u
      &nbs ......

SQLServerͨÓ÷ÖÒ³´æ´¢¹ý³Ì£¬×Ö·û·Ö¸ôº¯Êý

·ÖÒ³´æ´¢¹ý³Ì
sp_QueryPaging
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:
-- Create date:
-- Description: ·ÖÒ³²éѯ
-- ·µ»ØµÄÊý¾ÝÖÐ×ÜÊÇÔÚÿÌõ¼Ç¼ǰ¼ÓÉÏÐкÅRowNumberÁС£
-- Èç¹ûδָ¶¨@StrSelect²ÎÊý£¬Ï൱ÓÚÉèÖÃËüΪ'*'
-- Èç¹ûδ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ