oracle³£Óñí
dba_users Êý¾Ý¿âÓû§ÐÅÏ¢
dba_segments ±í¶ÎÐÅÏ¢
dba_extents Êý¾ÝÇøÐÅÏ¢
dba_objects Êý¾Ý¿â¶ÔÏóÐÅÏ¢
dba_tablespaces Êý¾Ý¿â±í¿Õ¼äÐÅÏ¢
dba_data_files Êý¾ÝÎļþÉèÖÃÐÅÏ¢
dba_temp_files ÁÙʱÊý¾ÝÎļþÐÅÏ¢
dba_rollback_segs »Ø¹ö¶ÎÐÅÏ¢
dba_ts_quotas Óû§±í¿Õ¼äÅä¶îÐÅÏ¢
dba_free_space Êý¾Ý¿â¿ÕÏпռäÐÅÏ¢
dba_profiles Êý¾Ý¿âÓû§×ÊÔ´ÏÞÖÆÐÅÏ¢
dba_sys_privs Óû§µÄϵͳȨÏÞÐÅÏ¢
dba_tab_privs Óû§¾ßÓеĶÔÏóȨÏÞÐÅÏ¢
dba_col_privs Óû§¾ßÓеÄÁжÔÏóȨÏÞÐÅÏ¢
dba_role_privs Óû§¾ßÓеĽÇÉ«ÐÅÏ¢
dba_audit_trail É󼯏ú×ټǼÐÅÏ¢
dba_stmt_audit_opts Éó¼ÆÉèÖÃÐÅÏ¢
dba_audit_object ¶ÔÏóÉ󼯽á¹ûÐÅÏ¢
dba_audit_session »á»°É󼯽á¹ûÐÅÏ¢
dba_indexes Óû§Ä£Ê½µÄË÷ÒýÐÅÏ¢
Ïà¹ØÎĵµ£º
Oracle Management ServerÅäÖò½ÖèÈçÏ£º
1¡¢Ê¹ÓÃenterprise manager configuration assistant½¨Á¢µµ°¸×ÊÁÏ¿â
ÆäÖпÉÑ¡Ôñн¨Ò»¸öÊý¾Ý¿âʵÀý»òÕßÔÚÒÑÓÐÊý¾Ý¿âʵÀýÖÐн¨×ÊÁϿ⣨н¨±í¿Õ¼ä£©¡£
2¡¢Æô¶¯management server
3¡¢ÔËÐÐenterprise manage console£¬Ñ¡ÔñµÇ¼µ½management server
µÇ ......
Ò»¸ö¼òµ¥µÄoracle·ÖÒ³´æ´¢¹ý³ÌµÄʵÏֺ͵÷Óá£ÔÚ¿´ÁËÖÚ¶àµÄ·ÖÒ³´æ´¢¹ý³ÌÒÔºó·¢ÏÖ¶¼ÊÇÕë¶ÔsqlserverµÄ£¬¶øÃ»ÓÐoracleµÄ£¬Òò´ËÏëдһ¸ö¹ØÓÚoracleµÄ´æ´¢¹ý³Ì£¬ÒòΪÎÒÓõ½µÄÊý¾Ý¿âÊÇoracle¡£
Oracle·ÖÒ³´æ´¢¹ý³ÌµÄ˼·ÓÚsqlserverµÄ˼·ÊÇÒ»ÑùµÄ£¬µ«ÊÇÎÒÕâÀï×öÁ˵ã¸Ä¶¯£¬ÔÚÒòΪOracleµÄÓï·¨ºÍ¹æÔòµÄ²»Í¬ËùÒÔ£¬Oracle·ÖÒ³´æ´¢ ......
1¡¢²éѯµÚ¼¸ÐеļǼ
select sal from emp where rownum=1; //²éѯµÃµ½µÚÒ»ÐмǼ
select sal from emp where rownum=5; //²»¿ÉÒÔ²éѯµ½µÚÎåÐмǼ£¬ÒòΪrownum ×ÜÊÇ´Ó1¿ªÊ¼²éѯµÄ£¬¹ÊÕâÖÖ·½Ê½²»¿ÉÒÔÖ±½ÓµÃµ½µÚ¼¸ÐеļǼ¡£ÈôÏëµÃµ½µÚÎåÐмǼ£¬Ó¦²ÉÓÃÈçÏ·½Ê½£º
select r,sal from (select rownum r,sal from emp) wher ......
1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ôʼ·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾¹ýÎļþϵͳµÄ»º³å¡£
¡¡¡¡
¡¡¡¡2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡× ......