Oracle DBAʵս°à
¿Î³Ì¸ÅÒª
¿Î³Ì±àºÅ
£ºXY-DB-V01
ÅàÑøÄ¿±ê
£º¾ß±¸Êµ¼Ê²Ù×÷ÄÜÁ¦µÄ Oracle Êý¾Ý¿â¹ÜÀíÔ±
רעOracleʵսÄÜÁ¦µÄÇ¿»¯£¬ÍêÈ«¸²¸ÇOCP¿Î³ÌÄÚÈÝ£¬¾ßÓиü´óµÄѧϰǿ¶ÈºÍ¸ü³¤µÄѧϰʱ¼ä¡£
ÈëѧÌõ¼þ
£º¶ÔOracle»òÆäËü¹ØϵÊý¾Ý¿âÓÐÒ»¶¨µÄ»ù´¡Õß
°à±ð¼°ÊÚ¿Îʱ¼ä
£ºÍѲú°àÀúʱ1¸öÔ£¬176Сʱ
ѧ·Ñ
£ºRMB 3500.00Ôª
¿ª°à¼Æ»®
£ºÇëÁôÒâÍøÕ¾Ê×Ò³µÄ“¿ª¿ÎÔ¤¸æ”°å¿é
¿Î³Ì´ó¸Ù
³£ÓÃLinuxÃüÁî¡¢vi±à¼Æ÷µÄʹÓà (8Сʱ)
PL/SQLÓïÑÔ»ù´¡£¬Êý¾Ý²éѯÓï¾äDQL£¬Êý¾Ý²Ù×ÝÓï¾äDML£¬Êý¾Ý¶¨ÒåÓï¾äDDL£¬Êý¾Ý¿ØÖÆÓï¾äDCLµÄʹÓà (16Сʱ)
Oracle10gÊý¾Ý¿âµÄ³£Óú¯Êý (8Сʱ)
Oracle10gÊý¾Ý¿âµÄ°²×°Æô¶¯¹Ø±Õ (8Сʱ)
´´½¨ºÍʹÓÃoracle10gÊý¾Ý¿âʵÀý (8Сʱ)
Oracle10gÊý¾Ý¿âµÄ½á¹¹ (8Сʱ)
Oracle10gÊý¾Ý¿â·þÎñÆ÷µÄ½á¹¹ (8Сʱ)
Êý¾Ý¿â¶ÔÏó±í£¬Ë÷Òý£¬ÊÓͼ£¬Í¬Òå´Ê£¬ÐòÁеĻù±¾²Ù×÷ (8Сʱ)
¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ¹ÜÀí (8Сʱ)
±í¿Õ¼äºÍÊý¾Ý¿âÎļþµÄ¹ÜÀí (8Сʱ)
Êý¾Ý¿â¶ÔÏóµÄ¹ÜÀí (8Сʱ)
Oracle10gÊý¾Ý¿âÓû§È¨ÏÞ£¬½ÇÉ«¹ÜÀí (8Сʱ)
Oracle10gÊý¾Ý¿â×ÊÔ´ÅäÖà (8Сʱ)
PL/SQL±à³Ì»ù´¡£¬PL/SQLÓï¾ä»ù±¾½á¹¹ (8Сʱ)
PL/SQLÌõ¼þ·Ö֧ѻ·Óï¾ä (8Сʱ)
´æ´¢¹ý³Ì (8Сʱ)
´¥·¢Æ÷ (8Сʱ)
º¯ÊýºÍÕýÔò±í´ïʽ (8Сʱ)
Êý¾Ý¿â±¸·ÝÓë»Ö¸´¡¢ÍøÂçÉèÖá¢ÅÅ´í (8Сʱ)
Linux C++¸ß¼¶Èí¼þ¹¤³ÌʦѵÁ·Óª
Q Q£º 570508473
Ö÷ Ò³£ºhttp://www.xuanyuan-soft.cn
ÂÛ Ì³£ºhttp://www.xuanyuan-soft.cn/forums
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Ò». ÀûÓÃrowidÀ´µÃµ½Ïà¹ØÐÅÏ¢
SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
SQL> create table bl(id number);
±íÒÑ´´½¨¡£
SQL> insert into bl values(1);
ÒÑ´´½¨ 1 ÐС£
SQL> select owner,segment_name,file_id,RELATIVE_FNO,block_id from dba_extents wh
ere owner='SYS' and segment_name='B ......
--1²é¿´±í¿Õ¼äÒѾʹÓõİٷֱÈ
select a.tablespace_name,a.bytes/1024/1024
"Sum MB",(a.bytes-b.bytes)/1024/1024 "used MB",b.bytes/1024/1024
"free MB",round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used"
from
(select tablespace_nam ......
ºÎΪÉÁ»Ø»Ö¸´Çø
Oracle 10g ÓÐÒ»Ïîй¦ÄܳÆΪ:×Ô¶¯µÄ»ùÓÚ´ÅÅ̵ı¸·ÝÓë»Ö¸´( Automatic Disk-Based Backup and Recovery )¡£ÊµÏָù¦ÄܵĻù´¡Îª±¾ÎÄÒª½²ÊöµÄÉÁ»Ø»Ö¸´Çø( Flash Recovery Area )¡£ÉÁ»Ø»Ö¸´ÇøÊÇ Oracle 10g ÖеÄÐÂÊÂÎï¡£¼òµ¥µÄ˵£¬ÉÁ»Ø»Ö¸´ÇøÊÇÒ»¿éÓÃÒÔ´æ´¢»Ö¸´Ïà¹ØµÄÎļþµÄ´æ´¢¿Õ¼ä¡£ÔÊÐíÓû§¼¯Öд洢ËùÓлָ ......
×öÊý¾Ý¿â¿ª·¢»ò¹ÜÀíµÄÈ˾³£Òª´´½¨´óÁ¿µÄ²âÊÔÊý¾Ý£¬¶¯²»¶¯¾ÍÐèÒªÉÏÍòÌõ£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¼È룬ÄÇ»áÀË·Ñ´óÁ¿µÄʱ¼ä£¬±¾ÎĽéÉÜÁËOracleÖÐÈçºÎͨ¹ýÒ»ÌõSQL¿ìËÙÉú³É´óÁ¿µÄ²âÊÔÊý¾ÝµÄ·½·¨¡£
²úÉú²âÊÔÊý¾ÝµÄSQLÈçÏ£º
SQL> select rownum as id,
2 &nbs ......