Ò»¡¢ ÄÚ´æ½á¹¹
¹²Ïí³Ø£º·ÖΪ¿â¸ßËÙ»º´æºÍ×Öµä¸ßËÙ»º³åÇø
¿â¸ßËÙ»º´æ£¬ÓÃÓÚ´æ´¢¾¹ýÓï·¨·ÖÎö²¢ÇÒÕýÈ·µÄSQLÓï¾ä£¬²¢ËæÊ±×¼±¸Ö´ÐС£
×Öµä¸ßËÙ»º³åÇø£¬´æ´¢µÇ½µ½ORACLEµÄÓû§Ãû£¬¼°ÕâЩÓû§ÓÐÄÄЩÊý¾Ý¿â¶ÔÏóÒÔ¼°ÕâЩÊý¾Ý¿â¶ÔÏóµÄλÖá£
Êý¾Ý»º³åÇø£ºÊý¾Ý¸ßËÙ»º³åÇø°üº¬Èý¸öÀàÐ͵ÄÇøÓò
keep»º³å³Ø¡¢recycle»º³å³Ø¡¢ default»º³å³Ø
´æ·ÅORACLEϵͳ×î½üʹÓùýµÄÊý¾Ý¿é
ÈÕÖ¾»º³åÇø£º
ÈκÎÊÂÎñÔڼǼµ½ÖØ×öÈÕ־֮ǰ¶¼±ØÐëÊ×Ïȷŵ½ÖØ×öÈÕÖ¾»º³åÇøÖУ¬È»ºóÓÉÈÕ־дÈë½ø³Ì¶¨ÆÚ½«´Ë»º³åÇøµÄÄÚÈÝдÈëÖØ×öÈÕÖ¾ÖÐ
¶þ¡¢ ºǫ́½ø³Ì
PMON£º
¼à¿ØÓû§½ø³Ì£¬ÓÃÓÚÖÕÖ¹ÄÇЩʧ°ÜµÄÓû§ÒÔ¼°ÊÍ·ÅÓû§ËùÕ¼ÓõÄ×ÊÔ´µÈ
SMON£º
&nb ......
ORACLE Êý¾Ý¿â¶ÔÏó
——Ë÷Òý
q Ë÷ÒýÊÇÓë±íÏà¹ØµÄÒ»¸ö¿ÉÑ¡½á¹¹
q ÓÃÒÔÌá¸ß SQL Óï¾äÖ´ÐеÄÐÔÄÜ
q ¼õÉÙ´ÅÅÌI/O
q ʹÓà CREATE INDEX Óï¾ä´´½¨Ë÷Òý
q ÔÚÂß¼ÉϺÍÎïÀíÉ϶¼¶ÀÁ¢ÓÚ±íµÄÊý¾Ý
q Oracle ×Ô¶¯Î¬»¤Ë÷Òý
Ë÷ÒýµÄÄ¿±ê£ºÌá¸ß²éѯÐÔÄÜ
Ë÷Òý¶ÔÔöɾ¸Ä²éµÄÓ°Ïì
SQLÓï¾ä
¶ÔÐÔÄܵÄÓ°Ïì
SELECT
²éѯÐÔÄÜÌá¸ß
UPDATE
¸üÐÂɾ³ýʱÐèÒªÏȲéѯ£¬´Ó´Ë½Ç¶ÈÐÔÄÜÌá¸ß
¸üÐÂɾ³ýʱÒýÆðË÷ÒýÐ޸ģ¬´Ó´Ë½Ç¶ÈÐÔÄÜϽµ
DELETE
INSERT
Ôö¼ÓÒýÆðË÷Òý¸Ä±ä£¬Ë÷Òý¶ÔÆä¸ºÃæÓ°Ïì¸ü´ó£¬ÐÔÄÜϽµ
ʲôʱºò½¨Á¢Ë÷Òý£¿
1. ÐèҪƵ·±²éѯµÄÊý¾Ý
2. Êý¾ÝÁ¿½Ï¶à
3. ¸ÃÁв»»áƵ·± update/insert/delete
4. ÔÚ where/order by/group by ×Ö¾äÖгöÏÖµ ......
ORACLEÓαê
Óα꣺ÈÝÆ÷£¬´æ·Åµ±Ç°SQLÓï¾äÓ°ÏìµÄ¼Ç¼
ËùÓÐDMLÓï¾ä¶¼»áÓõ½Óαê
ÖðÐд¦ÀíÓ°ÏìµÄÐÐÊý
Óαê
¾²Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐǰ¹ØÁª
¶¯Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐʱ¹ØÁª
Óαê
ÒþʽÓα꣺×Ô¶¯ÉùÃ÷¡¢´ò¿ª¡¢¹Ø±Õ£¬ÆäÃûSQL
ÏÔʽÓα꣺
REFÓα꣺£¨¶¯Ì¬Óα꣩
ÏÔʽÓαê²Ù×÷¹ý³Ì
ÉùÃ÷Óα꣨¹ØÁªSQLÓï¾ä£© cursor Ãû×Ö is/as sqlÓï¾ä£¨DML£©;
´ò¿ªÓαִ꣨ÐÐSQLÓï¾ä£¬Ìî³äÓα꣩ open Ãû×Ö;
´ÓÓαêÖÐÌáȡֵ£¬´æ·Åµ½ÐÐÀàÐͱäÁ¿ÖÐ fetch Ãû×Ö into ÐÐÀàÐͱäÁ¿;
......
³ÌÐò°ü
°üÖ÷Ìå/¹æ·¶Ãû×ÖÒ»Ñù
°üÖ÷Ìå/¹æ·¶ÖеĶÔÓ¦²ÎÊý±ØÐëÀàÐͼ°Ãû×ÖÒ»Ñù
Ö»ÄÜʹÓÃÇ¿ÀàÐ͵ÄREFÓαê
´´½¨³ÌÐò°ü¹æ·¶
create or replace package my_pack
is
procedure find_emp_proc(eno emp.empno%type);
function find_emp_fun(eno emp.empno%type) return emp.ename%type;
end my_pack;
SQL> ed
SQL> /
Package created
µ÷Óú¯Êý
SQL> select my_pack.find_emp_fun(7788) from dual;
select my_pack.find_emp_fun(7788) from dual
ORA-04068: ÒѶªÆú³ÌÐò°ü µÄµ±Ç°×´Ì¬
ORA-04067: δִÐУ¬package body "SCOTT.MY_PACK" ²»´æÔÚ
ORA-06508: PL/SQL: ÎÞ·¨ÔÚµ÷ÓÃ֮ǰÕÒµ½³ÌÐòµ¥Ôª
ORA-06512: ÔÚline 1
Ö´Ðд洢¹ý³Ì
SQL> exec my_pack.find_emp_proc(7788);
begin my_pack.find_emp_proc(7788); end;
ORA-04068: ÒѶªÆú³ÌÐò°ü µÄµ±Ç°×´Ì¬
ORA-04067: δִÐУ¬package body "SCOTT.MY_PACK" ²»´æÔÚ
ORA-06508: PL/SQL: ÎÞ·¨ÔÚµ÷ÓÃ֮ǰÕÒµ½³ÌÐòµ¥Ôª
ORA-06512: ......
/***************************by
garcon1986********************************/
Index.php:
<script type="text/javascript" src="ajax.js" ></script>
<a href="#" onclick="funphp('S')" >S</a>
<a href="for.php?url=E" >E</a>
<div id="idiv"></div>
for.php:
<?php
error_reporting(E_ALL ^ E_NOTICE);
if($url = $_GET[url]){
for($i=1;$i<10;$i++){
echo $url;
}
exit();
}
?>
Ajax.js:
//Ê×ÏÈÉùÃ÷±äÁ¿
var xmlHttp;
//´´½¨¶ÔÏóº¯Êý
function GetXmlHttpObject(){
try{
//Firefox, Opera, Safari
xmlHttp = new XMLHttpRequest();
}
catch(e){
try{
//MS IE 6.0+
xmlHttp = new ActiveXObject(Msxml2.XMLHTTP);
}
catch(e){
try{
//MS IS 5.5+
xmlHttp = new ActiveXObject(Microsoft.XMLHTTP);
}
catch(e){
alert("ÄúµÄä¯ÀÀÆ÷²»Ö§³ÖAJAX£¡");
return false;
}
}
}
}
//·¢ËÍÇëÇóº¯Êý
function funphp(t){
//µ÷ÓÃGetXmlHttpObjectº¯Êý
GetXmlHttpObject();
//open() ·½·¨ÐèÒªÈý¸ö²Î ......
´ÓÖйúÒÆ¶¯¹ã¸æÖ÷Ҫϸ·ÖÊг¡¹æÄ£À´¿´£¬2006ÄêWAP¹ã¸æÊг¡¹æÄ£Îª0.6ÒÚÔª£»ÖÁ2007Ä꣬WAP¹ã¸æÊг¡¹æÄ£Ô¤¼Æ½«´ïµ½1.7ÒÚÔª£¬Ôö³¤183%£»·¢Õ¹µ½2008Ä꣬WAP¹ã¸æÊг¡¹æÄ£Ô¤¼Æ½«´ïµ½3.5ÒÚÔª£¬Ôö³¤106%£»ÖÁ2010Ä꣬ÖйúWAP¹ã¸æÔ¤¼Æ½«´ïµ½7ÒÚÔªÊг¡¹æÄ£¡£2006-2010ÄêÖйúWAP¹ã¸æÊг¡¹æÄ£ÄêÆ½¾ù¸´ºÏÔö³¤ÂÊ´ïµ½85%£¬Êг¡±íÏÖ½«³¬¹ýÕûÌåÒÆ¶¯¹ã¸æÊг¡¡£
×öΪÔÚÊÖ»úýÌåÁìÓòÑо¿ÁË4ÄêµÄÀÖ¹ËÍŶÓÀ´Ëµ£¬ÕâÎÞÒÉÊǸöºÃÏûÏ¢¡£×Ô2005ÄêÒÔÀ´£¬Ò»Ö±ÔÚ×öÊÖ»úýÌåÓ¦ÓõÄÑо¿¿ª·¢£¬Öм䳢ÊÔ¹ý¶àÖÖ¹ã¸æÐÎʽÏò½áºÏµÄÔË×÷Ä££¬Ê½µ«Ã»ÓÐ×îÖÕÕÒµ½Ò»¸ö¿ÉÒÔÒýÁìδÀ´µÚÎåýÌåµÄ×î¼Ñ×éºÏģʽ¡£09Äê8Ô·ݣ¬È«ÐµĸöÈËýÌå½áºÏÊý×Ö³ö°æÏµÍ³µÄÕûºÏÔË×÷ģʽÕýʽÉÏÏߣ¡½áºÏ±¨Éç¡¢³ö°æÉçµÄÄÚÈÝÕûºÏÓÅÊÆ£¬Ó¦ÓÃ×ÔÖ÷Ñз¢µÄÈ«ÇòÁìÏȵŦÄÜÇø¶¨Î»ÏµÍ³ºÍ´¥·¢¹ã¸æ»úÖÆ£¬¿ª´´ÁËÊÖ»úýÌåÍêÉÆµÄÔË×÷»úÖÆ£¬³¹µ×´òÆÆÁË´«Í³Ã½ÌåºÍ»¥ÁªÍøÃ½ÌåµÄ¸ôĤ¡£
¾ß±¸ÊÖ»úä¯ÀÀÆ÷¹¦ÄܵÄÀÖ¹ËÈí¼þ£¬¿ÉÒÔ»ñÈ¡×ʱȨÍþµÄÐÂÎÅ×ÊѶ£¬¼°Ê±Á˽âÖܱßÉú»î¶¯Ì¬£¬ËæÊ±ËæµØ´¥·¢Öܱßʼþ¡£ÏòϵͳÌá½»ÄãµÄ×îÐÂÐèÇó£¬Öܱß3¹«ÀïÄÚÊʺÏÄãµÄÐÅÏ¢Ò»Ò»·¢µ½ÄãµÄÊÖ»ú×ÀÃæ£»Ò²ÐíÄã¸Õ¿ç½øKFCµÄµêÃÅ¡¢¹¦ÄÜÇø¶¨Î»ÏµÍ³²¶×½µ½ÄãµÄ¶¯×÷£¬Á¢¼´½«×îеç×ÓÓÅ»ÝÈ ......