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

Oracle ×ÜÕÊÄ£¿é»á¼ÆÒµÎñÖÜÆÚ

Oracle ×ÜÕÊÄ£¿éµÄÒ»¸ö»á¼ÆÒµÎñÖÜÆÚÈçÏÂ:
             1.´ò¿ª×ÜÕÊ»á¼ÆÆÚ
             2.¼ÈëÊÖ¹¤Æ¾Ö¤,°üÀ¨:· ÊÖ¹¤±ê׼ƾ֤
                           · Íâ±Òƾ֤
                           · ͳ¼Æƾ֤
             3.´Ó×ÓÄ£¿éÒýÈëƾ֤,Èç:Ó¦ÊÕ¡¢Ó¦¸¶¡¢¿â´æµÈÄ£¿é
             4.ÀûÓö¨ÒåºÃµÄ¾­³£ÐÔƾ֤ģ°åÉú³Éƾ֤
                 ¾­³£ÐÔƾ֤ģ°å°üÀ¨:· ¿ò¼Üƾ֤ģ°å—Óй̶¨ÕÊ»§ÎÞ½ð¶î(Éú³ÉÐëÊÖ¹¤Ìîд)
                           · ±ê׼ƾ֤ģ°å—¹Ì¶¨ÕÊ»§ºÍ¹Ì¶¨½ð¶î
                           · ¹«Ê½Æ¾Ö¤Ä£°å—Óй̶¨ÕÊ»§,½ð¶îÓÈÌض¨¼ÆË㹫ʽ»ñµÃ
             5.ÀûÓóÉÅú·ÖÅäƾ֤ģ°åÉú³Éƾ֤,È罫µ±ÔÂÕ۾ɷÑÓ𴲿ÃÅ·Ö̯
             6.ƾ֤¸´ºË:¿ÉÒÔÀûÓÃÁª»ú¼Èë»ò²éѯ½çÃæ½øÐи´ºË,Ò²¿ÉÒÔÔËÐб¨±í³ÌÐò½«Æ¾Ö¤´ò
                Ó¡³öÀ´ºó¸´ºË
             7.ÊÖ¹¤»ò×Ô¶¯¹ýÕÊ(ºǫ́µÇÕÊ)
             8.¼ì²éÊÇ·ñ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

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

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 Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......

oracle²»¿É¸üеÄÊÔͼ

¹Ø¼ü´Ê£ºwith read only
×÷ÓãºÓÃÓÚÖ¸¶¨Ëù´´½¨µÄÊÔͼ²»¿ÉÒÔͨ¹ý±¾ÊÓͼ¸üбí
Ö´ÐÐÒ»ÏÂSQL£¬´´½¨±íT£¬ºÍÁ½¸öÊÔͼV1£¬V2£º
CREATE TABLE T(ID INTEGER);
CREATE VIEW V1 AS SELECT * from T;
CREATE VIEW V2 AS SELECT * from T WITH READ ONLY;
Ö´ÐÐSQL:
INSERT INTO V1 VALUES(1);
--------------------
1 row cre ......

ORACLE·ÖÎöº¯ÊýµÄÓ÷¨

¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order   by   salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order   byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition   by   deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ