Oracle ×ÜÕÊÄ£¿é»á¼ÆÒµÎñÖÜÆÚ
Oracle ×ÜÕÊÄ£¿éµÄÒ»¸ö»á¼ÆÒµÎñÖÜÆÚÈçÏÂ:
1.´ò¿ª×ÜÕÊ»á¼ÆÆÚ
2.¼ÈëÊÖ¹¤Æ¾Ö¤,°üÀ¨:· ÊÖ¹¤±ê׼ƾ֤
· Íâ±Òƾ֤
· ͳ¼Æƾ֤
3.´Ó×ÓÄ£¿éÒýÈëƾ֤,Èç:Ó¦ÊÕ¡¢Ó¦¸¶¡¢¿â´æµÈÄ£¿é
4.ÀûÓö¨ÒåºÃµÄ¾³£ÐÔƾ֤ģ°åÉú³Éƾ֤
¾³£ÐÔƾ֤ģ°å°üÀ¨:· ¿ò¼Üƾ֤ģ°å—Óй̶¨ÕÊ»§ÎÞ½ð¶î(Éú³ÉÐëÊÖ¹¤Ìîд)
· ±ê׼ƾ֤ģ°å—¹Ì¶¨ÕÊ»§ºÍ¹Ì¶¨½ð¶î
· ¹«Ê½Æ¾Ö¤Ä£°å—Óй̶¨ÕÊ»§,½ð¶îÓÈÌض¨¼ÆË㹫ʽ»ñµÃ
5.ÀûÓóÉÅú·ÖÅäƾ֤ģ°åÉú³Éƾ֤,È罫µ±ÔÂÕ۾ɷÑÓ𴲿ÃÅ·Ö̯
6.ƾ֤¸´ºË:¿ÉÒÔÀûÓÃÁª»ú¼Èë»ò²éѯ½çÃæ½øÐи´ºË,Ò²¿ÉÒÔÔËÐб¨±í³ÌÐò½«Æ¾Ö¤´ò
Ó¡³öÀ´ºó¸´ºË
7.ÊÖ¹¤»ò×Ô¶¯¹ýÕÊ(ºǫ́µÇÕÊ)
8.¼ì²éÊÇ·ñ
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄ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 ......
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý 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 Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
¹Ø¼ü´Ê£º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 ......
¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order by salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition by deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......