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

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


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle 11gµÄ±í¿Õ¼ä¼ÓÃÜ

ÒòΪÃ÷°Ú×ŵÄÔµ¹Ê£¬10.2Òý³öµÄTDEЧÄܶÔÁмÓÃÜÒÔºó£¬ÕÐÖÂÏà¸ÉĿ¼ɥʧÁ˶Բ»µÈʽµÄÅжÏÄÜÁ¦¡£
鍫룼
ENCRYPTIONDEMO@fmw//scripts> create table tde_table(id number encrypt no salt,na
me varchar¶þ(30))
¶þ ;
Table created.
Elapsed: 00:00:00.11
ENCRYPTIONDEMO@fmw//scripts> begin
¶þ for i in 1..2 ......

WebspereÅ䱸Oracle RAC Êý¾ÝÔ´µÄÎÊÌâ

WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´£¬OracleË«»úµÄIPΪ10.10.10.121Óë10.10.10.122 £¬·¶ÀýÃûλ±ðΪorclÒ»Óëorcl¶þ£¬·þÎñÃû½Ðoracledbservice£¬²ÉÈ¡Áª½Ó´®Ó¦Îª£º
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10 ......

oracle±í¿Õ¼ä¹ÜÀí

--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 JOBS

Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ