ÓÅ»¯select count(*) (תoracleÅàѵÀÏʦµÄÎÄÕÂ)
select count(*) from t1;
Õâ¾ä»°±È½Ï¼òµ¥£¬µ«ºÜÓÐÐþ»ú£¡¶ÔÕâ¾ä»°ÔËÐеÄÀí½â£¬·´Ó³ÁËÄã¶ÔÊý¾Ý¿âµÄÀí½âÉî¶È£¡
½¨Á¢ÊµÑéµÄ´ó±íËût1
SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL> drop table t1 purge;
±íÒÑɾ³ý¡£
SQL> create table t1 as select * from emp where 0=9;
±íÒÑ´´½¨¡£
SQL> insert into t1 select * from emp;
ÒÑ´´½¨14ÐС£
SQL> insert into t1 select * from t1;
ÒÑ´´½¨14ÐС£
SQL> /
ÒÑ´´½¨28ÐС£
SQL> /
ÒÑ´´½¨56ÐС£
SQL> /
ÒÑ´´½¨112ÐС£
SQL> /
ÒÑ´´½¨224ÐС£
SQL> /
ÒÑ´´½¨448ÐС£
SQL> /
ÒÑ´´½¨896ÐС£
SQL> /
ÒÑ´´½¨1792ÐС£
SQL> /
ÒÑ´´½¨3584ÐС£
SQL> /
ÒÑ´´½¨7168ÐС£
SQL> /
ÒÑ´´½¨14336ÐС£
SQL> /
ÒÑ´´½¨28672ÐС£
SQL> /
ÒÑ´´½¨57344ÐС£
SQL> commit;
Ìá½»Íê³É¡£
ÊÕ¼¯Í³¼ÆÐÅÏ¢
SQL> execute dbms_stats.gather_table_stats('SCOTT','T1');
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
SQL> SET AUTOT TRACE EXP
SQL> SELECT COUNT(*) from T1;
Ö´Ðмƻ®
--------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 124 (4)| 00:00:02 |
Ïà¹ØÎĵµ£º
ÔÚ Windows ÉÏ°²×° Oracle Êý¾Ý¿â 11g
°²×°Oracle Èí¼þ£¬±ØÐëʹÓà Oracle Universal Installer¡£
1.ÔÚÕâÒ»°²×°ÖУ¬ÄúÐèҪʹÓà DVD »òÏÂÔØ DVD °æ±¾¡£ÔÚ±¾½Ì³ÌÖУ¬½«´ÓÒÑÏÂÔصİ汾½øÐа²×°¡£ÔÚ½âѹËõ DVD ÎļþµÄĿ¼ÖУ¬´ò¿ª Windows ×ÊÔ´ä¯ÀÀÆ÷²¢Ë«»÷ \db\Disk1 Ŀ¼µÄ setup.exe¡£
2.°²×°µÄ²úƷΪ Oracle Da ......
ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......
Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
¶ÔÓڷǹ鵵ģʽµÄÊý¾Ý¿â¸ÃΪ¹éµµÄ£Ê½£¨Ö÷ÒªÒÔOracle 10gΪ²Î¿¼£©Ê¹ÓÃÒÔϲ½Ö裺
1. SQL> alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive ......
±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷; ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......
The DB File Scattered Read wait event generally indicates waits related to full table scans or fast
full index scans. As full table scans are pulled into memory, they are scattered throughout the
buffer cache, since it is usually unlikely that they fall into contiguous buffers. A large numb ......