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

Oracleϵͳ¹ÜÀíºÍϵͳ×ÊÁÏ»ñÈ¡µÄһЩ»ù±¾ÃüÁî

×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æÖ®Ê±.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,version from v$instance;
3. »ñÈ¡×é¼þ°æ±¾ÐÅÏ¢.
SELECT * from v$version;
4.»ñÈ¡¿ØÖÆÎļþÐÅÏ¢.
SELECT * from v$controlfile;
5.»ñÈ¡ÈÕÖ¾ÎļþÐÅÏ¢.
SELECT * from v$logfile;
              ºÍ
SELECT group#, members, bytes, status, archived from v$log;
6. »ñÈ¡±¸·ÝºÍ»Ö¸´²ßÂÔ,ÒÔ¼°¹éµµÎļþλÖÃ.(Ò²ÐèÒªsysdbaȨÏÞ)
archived log list
7. Èç¹ûÉÏÃæÊä³öÖеĴ浵ÖÕµãµÄÖµ²»ÊÇÖ±½ÓµÄĿ¼¶øÊÇ USE_DB_RECOVERY_FILE_DEST µÄ»°,ÓÃÒÔÏÂÓï¾ä»ñÈ¡×îÖÕÐÅÏ¢.
SELECT name,value from v$parameter WHERE name = 'db_recovery_file_dest';
8.»ñÈ¡±í¿Õ¼äÐÅÏ¢.
SELECT tablespace_name, block_size, status, contents, logging from dba_tablespaces;
9. »ñÈ¡Êý¾ÝÎļþÐÅÏ¢.
SELECT file_id, file_name, tablespace_name, status, bytes from dba_data_files;
10. ÔÚûÓÐsysdbaȨÏÞʱ,¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´»ñÈ¡Êý¾ÝÎļþµÄ´¢´æÎ»ÖÃÐÅÏ¢.
SELECT name from v$datafile;
11. »ñÈ¡Óû§ÐÅÏ¢.
SELECT username,created from dba_users;


Ïà¹ØÎĵµ£º

oracle »Ö¸´±íµ½ÒÔǰµÄij¸ö״̬

 select * from sys.smon_scn_time;
--scn Óëʱ¼äµÄ¶ÔÓ¦¹ØÏµ
ÿ¸ô5·ÖÖÓ£¬ÏµÍ³²úÉúÒ»´Îϵͳʱ¼ä±ê¼ÇÓëscnµÄÆ¥Åä²¢´æÈësys.smon_scn_time±í¡£
select * from student as of scn 592258
¾Í¿ÉÒÔ¿´µ½ÔÚÕâ¸ö¼ì²éµãµÄ±íµÄÀúÊ·Çé¿ö¡£
È»ºóÎÒÃǻָ´µ½Õâ¸ö¼ì²éµã
insert into student  select * from student a ......

Oracle Óï·¨Ö® OVER (PARTITION BY ..) ¼°¿ª´°º¯Êý


oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÍ¨¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ¦Óᣠ          &nb ......

oracle ±Ê¼Ç VII Ö® ´óÊý¾ÝÁ¿ÏµķÖÒ³

 ÔÚORACLE ´óÊý¾ÝÁ¿ÏµķÖÒ³½â¾ö·½·¨¡£Ò»°ãÓýØÈ¡ID ·½·¨£¬»¹ÓÐÊÇÈý²ã ǶÌ×·½·¨
Ò»ÖÖ·ÖÒ³·½·¨
<%
    int i = 1;
    int numPages = 14;
    String pages = request.getParameter("page");
    int currentPage = 1;
    cu ......

Oracle SQLÓï¾ä²Ù×÷Êý×Ö£ºÈ¡Õû¡¢ËÄÉáÎåÈë¼°¸ñʽ»¯

 http://cheneyph.javaeye.com/blog/453492
ÓÃoracle sql¶ÔÊý×Ö½øÐвÙ×÷: È¡ÉÏÈ¡Õû¡¢ÏòÏÂÈ¡Õû¡¢±£ÁôNλСÊý¡¢ËÄÉáÎåÈë¡¢Êý×Ö¸ñʽ»¯
È¡Õû£¨ÏòÏÂÈ¡Õû£©£º 
select floor(5.534) from dual;
select trunc(5.534) from dual;
ÉÏÃæÁ½ÖÖÓ÷¨¶¼¿ÉÒÔ¶ÔÊý×Ö5.534ÏòÏÂÈ¡Õû£¬½á¹ûΪ5.
Èç¹ûÒªÏòÉÏÈ¡Õû £¬µÃµ½½á¹ûÎ ......

OracleµÄ¼¯ºÏÔËËã·û

±í1£ºtemp1
AA    BB    CC
1      1      1
1      1      2
1      1      3
±í2£ºtemp2
AA    BB  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ