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

ORACLE ͳ¼ÆÕý¸º¸öÊýsql

select ss.*,
       sum(ss.aa) over (partition by ss.zsid order by ss.zsid) as fu,
       sum(ss.bb) over (partition by ss.zsid order by ss.zsid) as zheng
from
(
select m.zsid,
       sum(n.f0004_028n) over(partition by m.zsid) n011,
       sum(n.f0004_029n) over(partition by m.zsid) n012,
       sum(n.f0004_030n) over(partition by m.zsid) n013,
       sum(n.f0004_031n) over(partition by m.zsid) n014,
       sum(n.f0004_032n) over(partition by m.zsid) n015,
       sum(n.f0004_033n) over(partition by m.zsid) n021,
       sum(n.f0004_034n) over(partition by m.zsid) n022,
       sum(n.f0004_035n) over(partition by m.zsid) n023,
       n.f0004_017n,
       (case when n.f0004_017n>0 then 1  when n.f0004_017n<=0 then 0 end)  aa,
       (case when n.f0004_017n<=0 then 1  when n.f0004_017n>0 then 0 end)  bb
  from (select a.f0055_001n zsid,
               a.f0055_004v zsbm,
               b.f0056_003v code,
               b.f0056_004v zsjycs, --Ö¸Êý½»Ò׳¡Ëù
               b.f0056_005v zszqlb, --Ö¸Êý֤ȯÀà±ð
               c.f0005_005v codezqlb, --³É·Ý¹É֤ȯÀà±ð
               c.f0005_007v codejycs --³É·Ý¹É½»Ò׳¡Ëù
 


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

oracle wait event:reliable message

½ñÌì¿Í»§µÄÒ»Ì×RAC»·¾³³öÏÖÎÊÌâ
Ë«½ÚµãRAC»·¾³ÖУ¬Ò»¸ö½ÚµãÒòÎªËø¾ºÕù¶ø¹ÒÆð£¬shutdownÖ®ºóÎÞ·¨Æô¶¯¡£
¹ÊÕϳöÏÖʱÎÒÕýÔÚ·ÉÏ£¬´Ò´Ò»Øµ½¼ÒÖУ¬´¦Àí¹ÊÕÏ¡£
½â¾öÖ®ºó²éÕÒ¹ÊÕÏÔ­Òò¡£
¼ì²éµ±Ê±µÄAWRÐÅÏ¢·¢ÏÖTop 5 Timed EventsÏÔʾÈçÏÂÐÅÏ¢£º
Top 5 Timed Events         &nb ......

¹ØÓÚoracle mutexºÍlatchµÄÎÊÌâ

¹ØÓÚlatchºÍmutexµÄÎÊÌâ
from:http://www.itpub.net/thread-1004815-1-1.html
A:
latchÊÇãÅËø£¬ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÓÃÀ´±£»¤SGAÖеÄÄÚ´æ½á¹¹¡£
mutexÊÇʲô£¬Ò²ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÊÇ»¥³âËø£¿
¸öÈ˶ÔmutexûÓÐʲô¸ÅÄî¡£Õâ¸öÊÇ10GÐÂÒý½øµÄ£¿9IºÃÏñûÓа¡¡£
ÄÄλÃ÷°×ÈË£¬¸ø°ïæÏêϸ½âÊÍÏÂmutex£¬×îºÃ»¹ÄܺÍlatch ×öϱȽ ......

oracle ȨÏÞ


--ʹÓÃDBA´´½¨Á½¸öÓû§
create user gubo identified by gubo;
create user gubo2 identified by gubo;
--¸øÁ½¸öÓû§Á¬½ÓȨÏÞ
grant create session to gubo;
grant create session to gubo2;
--¸øÆäÖÐÒ»¸öÓû§·ÃÎʱí¿Õ¼äµÄȨÏÞ
grant unlimited tablespace to gubo; 
--Á¬½ÓÆäÖÐÓû§£¬´´½¨±í
--conn gubo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ