Oracle Êý¾ÝÉú³É Ë÷Òý
1.½¨±í
CREATE TABLE qq(
qq_num integer
);
2.²åÈëÊý¾Ý
²åÈëÊý¾ÝµÄ·½·¨ÓкܶàÖÖ£¬µ«ÊÇÒª²åÈë3ÒÚÊý¾Ý£¬±ØÐëÒªÓиßЧµÄËã·¨¡£ÔÚ²åÈëÊý¾ÝʱÎÒÓÃÁË×µÄ°ì·¨£¬²ÉÓÃPL/SQLÀûÓÃÁ÷³Ì¿ØÖƵÄLOOPÓï¾ä²åÈ롣ͬʱÎÒÒ²¿´ÁËÍøÉϵIJåÈëЧÂʵÄÓÅ»¯£¬ÔõÑùÀûÓýÏÉÙµÄʱ¼äÉú³É½Ï¶àµÄ²âÊÔÊý¾Ý¡£¸øÎÒÓ¡ÏóÉî¿ÌµÄÊÇÀûÓÃÖÖ×Ó±íÀ´Éú³É½Ï¶àµÄÊý¾Ý¡£
ÕâÑù×öµÄºÃ´¦ÊDZ¾ÉíÊý¾Ý¾ÍÔÚ±¾µØ´ÅÅÌ£¬¼õÉÙÁË´æÈ¡µÄI/O²Ù×÷£¬Êý¾ÝÉú³É½Ï¿ì¡£
ÎÒ²ÉÓÃ×µÄ°ì·¨ÀûÓÃ8СʱÉú³ÉÁË2ÒÚ¶àÌõÊý¾Ý¼Ç¼¡£
3.Ë÷ÒýµÄ½¨Á¢
ÓÉÓÚÒÑ´æÔڵļǼÓÐ2ÒÚÌõ£¬²ÉÓÃCREATE INDEX qq_num_index ON qq(qq_num);ºÄ·Ñʱ¼ä½ü1Сʱ¡£
Ë÷ÒýµÄºÃ´¦:²éѯЧÂÊÌá¸ß£¬Ë÷ÒýÏà¹ØµÄ“Ìî³äÒò×Ó”¡£
count£¨£©º¯ÊýʼÖÕ²»×ßË÷Òý£¬¶¼ÊÇÈ«ÅÌɨÃ裬»¹Î´ÕÒµ½½â¾ö°ì·¨¡£Ò²¾ÍÊÇÒÔÏÂPL/SQLÖ´ÐеÄʱ¼äÔÚ½¨Á¢Ë÷ÒýǰºóÊÇÒ»ÑùµÄ¡£
DECLARE
count_num NUMBER;
BEGIN
dbms_output.put_line('Óï¾äÖ´ÐпªÊ¼Ê±¼ä:'||systimestamp);
SELECT COUNT(qq_num) INTO count_num from qq WHERE qq_num IS NOT NULL;
dbms_output.put_line('½á¹û:'||count_num);
dbms_output.put_line('Óï¾äÖ´ÐнáÊøÊ±¼ä:'||systimestamp);
END;
/
µ«Êǽ¨Á¢Ë÷Òýºó£¬SELECT MAX£¨qq_num£© ºÍÆäËûÏà¹ØµÄÓï¾äµÄÖ´ÐÐʱ¼äÁ¢¼´¼õÉÙÁ˺ܶࡣ
ÒÔÏÂÊÇ´úÂ룺
DECLARE
count_num NUMBER;
BEGIN
dbms_output.put_line('Óï¾äÖ´ÐпªÊ¼Ê±¼ä:'||systimestamp);
SELECT MAX(qq_num) INTO count_num from qq;
dbms_output.put_line('½á¹û:'||count_num);
dbms_output.put_line('Óï¾äÖ´ÐнáÊøÊ±¼ä:'||systimestamp);
END;
/
½¨Á¢Ë÷Òýǰ£ºÖ´ÐÐʱ¼äΪ1·Ö7Ãë,Ë÷Òýºó0.2ÃëÄÚÍê³É¡£
½¨Á¢Ë÷ÒýÊÇÒÔ´æ´¢¿Õ¼äΪ´ú¼Û»»È¡Ê±¼äЧÂʵÄÌá¸ß¡£
Õâµ±ÖÐÓÐautotrace¿ÉÒÔ×Ô¶¯ÏÔʾSQLÓï¾äµÄÖ´Ðмƻ®£¬ÕâÖֲ鿴±ØÐëÔÚSQL *PLUSÏÂ.
¿ªÆôautotraceµÄ²½ÖèÈçÏÂ:
--DBA³õ´Î±ØÐëÖ´ÐÐ
CREATE ROLE plustrace;--ÐèÒªÓµÓÐȨÏÞ
GRANT SELECT ON v_$sesstat TO plustrace;--ÐèÒªÓÐGRANTȨÏÞ
GRANT SELECT ON v_$mystat TO plustrace;
GRANT SELECT ON v_$statname TO plustrace;
--¿ªÆô×Ô¶¯¸ú×Ù
SET AUTOTRACE ON;
Ïà¹ØÎĵµ£º
OracleÖÐKill sessionµÄÑо¿
×÷Õߣºeygle |English Version ¡¾×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2004/06/kill_session.html
ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial# ......
2008-09-02
J2EE²Ù×÷OracleµÄclobÀàÐÍ×Ö¶Î
¹Ø¼ü×Ö: java
OracleÖУ¬Varchar2Ö§³ÖµÄ×î´ó×Ö½ÚÊýΪ4KB£¬ËùÒÔ¶ÔÓÚijЩ³¤×Ö·û´®µÄ´¦Àí£¬ÎÒÃÇÐèÒªÓÃCLOBÀàÐ͵Ä×ֶΣ¬CLOB×Ö¶Î×î´óÖ§³Ö4GB¡£
»¹ÓÐÆäËû¼¸ÖÖÀàÐÍ£º
blob:¶þ½øÖÆ,Èç¹ûexe,zip
clob:µ¥×Ö½ÚÂë,±ÈÈçÒ»°ãµÄÎı¾Îļþ.
nlob:¶à×Ö½ÚÂë,ÈçUTF¸ñʽµÄÎļþ.
ÒÔÏÂ¾Í ......
±¾ÎÄÀ´×Ôhttp://www.cnblogs.com/rootq/articles/1177562.html
Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ ......
×î½ü´ÓExcelÖе½ÁËһЩÊý¾Ý£¬½á¹ûÒ»¸öÁеÄÊý¾ÝÊÇÒÔ¶ººÅ·Ö¸ôµÄ×Ö·û´®£¬Ïë°ÑËü²ð·Ö¿ªÕÒµ½ÁËϱߵķ½·¨£¬Ìù³öÀ´·ÖÏíһϣº
CREATE OR REPLACE PROCEDURE sptstr (srcstr varchar2) as
stmp varchar2(2000);
begin &n ......