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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÒòΪÃ÷°Ú×ŵÄÔµ¹Ê£¬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¼¯ÈºÊý¾ÝÔ´£¬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 ......
--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 ......
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý 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 Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......