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

oracle olapº¯Êý£¨Ðø£©

/*connect byº¯Êý*/
CREATE TABLE TBL_TEST
(
  ID    NUMBER,
  NAME  VARCHAR2(100 BYTE),
  PID   NUMBER                                  DEFAULT 0
);
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('1','10','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('2','11','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('3','20','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('4','12','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('5','121','2');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('6','126','2');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('7','127','1');
commit;
--´ÓRootÍùÊ÷Ä©Éҵݹé
select * from TBL_TEST
start with id=1
connect by prior id = pid
order by pid,id
--´ÓÄ©ÉÒÍùÊ÷ROOTµÝ¹é
select * from TBL_TEST
start with id=5
connect by prior pid=id
/*leadÏÂÒ»¸ö  lagÉÏÒ»¸ö*/
create table LEAD_TABLE
(
  CASEID     VARCHAR2(10),
  STEPID     VARCHAR2(10),
  ACTIONDATE DATE
);
  insert into LEAD_TABLE values('Case1','Step1',to_date('20070101','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step2',to_date('20070102','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step3',to_date('20070103','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step4',to_date('20070104','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step5',to_date('20070105','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step4',to_date('20070106','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step6',to_date('20070101','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case1','Step1',to_date('20070201','yyyy-mm-dd'));
  insert into LEAD_TABLE values('Case2','Step2',to_date('20070202','yyyy-mm-dd'));
  insert into LEAD_TABLE valu


Ïà¹ØÎĵµ£º

Oracle¼¼ÇÉ£ºÓÃv$session_longops¸ú×ÙDDLÓï¾ä

OracleÊý×Ö×Öµä°üº¬Ò»¸öÏÊΪÈËÖªµÄv$session_longopsÊÓͼ¡£v$session_longopsÊÓͼ¿ÉÒÔʹOracleר¼Ò¼õÉÙÔËÐÐʱ¼äºÜ³¤µÄDDLºÍDMLÓï¾äµÄÔËÐÐʱ¼ä¡£
¡¡¡¡
¡¡¡¡
¡¡¡¡
¡¡¡¡ÀýÈçÔÚÊý¾Ý²Ö¿â»·¾³ÖУ¬¼´Ê¹Ê¹Óò¢ÐÐË÷Òý´´½¨¼¼Êõ£¬¹¹½¨Ò»¸öºÜ¶àG×Ö½Ú´óµÄË÷ÒýÐèÒªºÄ·ÑºÜ¶à¸öСʱ¡£ÕâÀïÄã¾Í¿ÉÒÔ²éѯv$session_longopsÊÓͼ¿ìËÙÕÒ³öÒ»¸ ......

³õѧORACLEµÄÀ§»ó

     ¶Ô³õѧORACLEµÄÈËһʱºÜÄÑ·ÖÇåORACLEÖйØÓÚ“¿Õ¼ä”µÄ¸ÅÄ±ÈÈç±í¿Õ¼ä ÁÙʱ±í¿Õ¼ä Óû§±í¿Õ¼äµÈ£¬¶ÔÓÚÓÉSQLתµ½ORACLEµÄ¾Í¸ü¼Ó»ìÏýÁË£¬ÈÃÈ˸оõORACLE·±Ëö£»·±ËöÔÚÄĶù£¬ÎÒÕûÀíÂÞÁÐÈçÏ£º
1.ORACLE×Ô´ø¹¤¾ß²»Ê®·ÖÒ×Óã»
2.ORACLEµÚÈý·½¹¤¾ßÒ×ÉÏÊÖ£¬µ«ÄÑÉîÈ룻
   &n ......

ORACLE Êý¾Ý±í´´½¨²½Öè

1.´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE Test_temp
TEMPFILE 'E:\Test\TEST_temp.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
2.´´½¨Óû§±í¿Õ¼ä
create tablespace TEST
datafile 'E:\TEST\TEST.dbf'
size  100M
autoextend on maxsize     ......

oracleÖв鿴Óû§È¨ÏÞ

ORACLEÖÐÊý¾Ý×ÖµäÊÓͼ·ÖΪ3´óÀà,     ÓÃÇ°×ºÇø±ð£¬·Ö±ðΪ£ºUSER£¬ALL ºÍ DBA£¬Ðí¶àÊý¾Ý×ÖµäÊÓͼ°üº¬ÏàËÆµÄÐÅÏ¢¡£
USER_*:ÓйØÓû§ËùÓµÓеĶÔÏóÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóÐÅÏ¢
ALL_*£ºÓйØÓû§¿ÉÒÔ·ÃÎʵĶÔÏóµÄÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóµÄÐÅÏ¢¼ÓÉÏÆäËûÓû§´´½¨µÄ¶ÔÏ󵫸ÃÓû§ÓÐȨ·ÃÎʵÄÐÅÏ¢
DBA_* ......

ɱOracle½ø³Ì

alter system kill session '²é³öµÄsid,²é³öµÄserial#';
ͨ過數據×ÖµäV$SESSION與V$LOCK來瞭½âÕýÔڵȴý鎖資Ô´µÄÓÃ戶
select a.username,a.sid,a.serial#,b.id1 from v$session a ,v$lock b
         Where a.lockwait ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ