DBAORACLE

»¶Ó­À´µ½DBAORACLE>>¡¡¡¡ | Ê×Ò³ ×ÊÔ´ÖÐÐÄ | OracleÊý¾Ý¿â | С·É·É | ÆäËû | ²Ù×÷ϵͳ | »³¾É¾­µä | ITPUBÂÛ̳

Using Flashback Drop and Managing the Recycle Bin

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2007ÄêÈýÔÂ13ÈÕ, 11:39

ÕâÁ½ÌìÓõ½ÁË10GµÄÐÂÌØÐÔflashback drop£¬Ìؽ«OracleÎĵµÖн²Êö¹ØÓÚÈçºÎ¹ÜÀíºÍʹÓøÃÌØÐԵIJ¿·Öժ¼ÈçÏ£¬ÒÔ±¸²é¿¼¡£

 ²é¿´È«ÎÄ

ÔÙ¼ûÁË£¬ÎÒµÄ2006

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÊ®¶þÔÂ30ÈÕ, 12:08

²»Öª²»¾õÒѵ½Äêµ×ÁË£¬½è´Ë»ú»áÀ´×ܽáÒ»ÏÂ×Ô¼ºÒ»ÄêÀ´µÄÊÕ»ñ£º

1¡¢ÓÐÁËÉî°®×Ô¼ºµÄÅ®ÓÑ£¬ÈËÉú´Ó´Ë²»Ôٹµ¥£»

2¡¢ÓÐÁËÒ»·Ýнˮ¸ü¸ßµÄ¹¤×÷£¬ÎïÖÊÉú»îµÃµ½Ò»¶¨µÄ±£ÕÏ£»

3¡¢¿ªÊ¼Á˽â¹ÉƱ£¬½áʶÁËÕâ¸ö¼ÈÊǵØÓüÓÖÊÇÌìÌÃµÄ¹ÉÆ±Êг¡¡£


×¼±¸Ñо¿Ò»ÏÂ10G

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêʮһÔÂ14ÈÕ, 17:32

Oracle 10GÍÆ³öºÃ³¤Ê±¼äÁË£¬Ò»Ö±Ã»Óлú»áʹÓã¬Ò²¾ÍûÓÐѧϰ10GµÄ¶¯Á¦£¬ÏÖÔÚʹÓÃ10GµÄÆóÒµÔ½À´Ô½¶àÁË£¬³ÃÏÖÔÚÓеã¶ùÏÐϾ£¬×¼±¸Ñо¿Ò»Ï£¬µ«Ô¸×Ô¼ºÄܼá³ÖÏÂÈ¥¡£

ºÃ¾ÃûÀ´Ð´¶«Î÷ÁË

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêʮһÔÂ14ÈÕ, 17:17

×î½üÒ»¶Îʱ¼äÒ»Ö±ÔÚ¸ãOracleµÄһЩDDLÓï¾ä£¬ÀÛµÃÔÎͷתÏò£¬µ½½ñÌìÔÝʱ¸æÒ»¶ÎÂ䣬±¾ÖÜÓàϵļ¸Ìì¿ÉÒÔÐÝÏ¢Ò»ÏÂÁË£¬ÌØ´ËÁôÄ

¶à±í²åÈëÖÐÉæ¼°sequenceÁеÄÎÊÌâ

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006Äê°ËÔÂ07ÈÕ, 17:34

°´ÕÕOracleÎĵµÖеÄ˵·¨£¬µ±Ê¹Óöà±í²åÈ루Multi-table-insert£©Óï¾äʱ×Ó²éѯÖв»ÄÜʹÓÃsequence£º
SQL> create sequence seq ;

ÐòÁÐÒÑ´´½¨¡£

SQL> insert all
2 INTO T1
3 (C1)
4 VALUES
5 (C1)
6 INTO T2
7 (C1)
8 VALUES
9 (C1)
10 select seq.nextval AS C1 from EMP;
select seq.nextval AS C1 from EMP
*
ERROR λÓÚµÚ 10 ÐÐ:
ORA-02287: ´Ë´¦²»ÔÊÐíÐòºÅ

ÎÒÃÇ¿ÉÒÔͨ¹ýʹÓÃÒ»¸öº¯ÊýÀ´Èƹý¸ÃÏÞÖÆ¡£

 ²é¿´È«ÎÄ

SOX requirements for Database Change Management

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006Äê°ËÔÂ06ÈÕ, 12:57

  • Changes to the database are widely communicated, and their impacts are known beforehand.
  • Installation and maintenance procedure documentation for the DBMS is current.
  • Data structures are defined and built as the designer intended them to be.
  • Data structure changes are thoroughly tested.
  • Users are apprised, and trained if necessary, when database changes imply a change in application behavior.
  • The table and column business definitions are current and widely known.
  • The right people are involved throughout the application development and operational cycles.
  • Any in-house tools are maintained and configured in a disciplined way.
  • Application impacts are known prior to the migration of database changes to production.
  • Performance is maintained at predefined and acceptable levels.
  • The database change request and evaluation system is rational.
  • Turn-around time on database changes is predictable.
  • Any change to the database can be reversed.
  • Database structure documentation is maintained.
  • Database system software documentation is maintained.
  • Migration through development, test, and especially, production environments is rational.
  • Security controls for data access is appropriate and maintained.
  • Database reorganizations are planned to minimize business disruption.
 ²é¿´È«ÎÄ

dbms_jobµÄµ÷ÓÃ

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006Äê°ËÔÂ05ÈÕ, 19:05

ÎÊÌâÈçÏ£¬Ò»¸öÿ¸ô1¸öСʱRunÒ»´ÎµÄjob£¬Èç¹ûij´ÎjobÖ´Ðл¨·ÑÁË2¸öСʱ£¬ÔòÏ´ÎjobÊÇÔÚʲôʱºòÔËÐУ¿ÊÇÂíÉÏÔËÐУ¬»¹ÊǵÈÒ»¸öСʱºóÔÙÔËÐУ¿

ÒÔǰÎÒÏ뵱ȻµÄÒ»Ö±ÒÔΪÊǵȴý1¸öСʱºóÔÙÔËÐУ¬¾ÍÊÇNext_date°´ÕÕjobÖ´ÐÐÍê±ÏºóÔÙ¼ÆËã¡£

ÊÂʵÊÇ£¬Next_dateÊÇÔÚjob֮ǰ¿ªÊ¼RunµÄʱºò¼ÆË㣬Èç¹ûjobÑÓÆÚ½áÊø£¬Ôòjob½ø³Ì·¢ÏÖµ±Ç°ÈÕÆÚÒѾ­³¬¹ýÁËNext_date£¬Ôò»áÂíÉÏÔËÐиÃjob£¬²¢ÇÒÒÔµ±Ç°ÈÕÆÚ¼ÆËãÏ´εÄNext_date.

 ²é¿´È«ÎÄ

foreign key and nullable column

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ30ÈÕ, 14:11

It's strange and interesting... It's designed by Oracle ^_^ ²é¿´È«ÎÄ

pratical IOT

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ30ÈÕ, 11:33

  • Online move IOT table
  • Performance(reduce I/O) IOT vs HEAP
  • Create as select synax
  • Overflow segment (INCLUDING and PCTTHRESHOLD)

 ²é¿´È«ÎÄ

ÐÔÄÜÓÅ»¯°¸Àý

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ20ÈÕ, 17:31

×î½üÕâ¶Îʱ¼ä¸Õ×öÁËÒ»ÏîÐÔÄÜÓÅ»¯µÄ¹¤×÷£¬¸ù¾ÝÒ»ÖܵÄstatspack±¨¸æ£¬Ð´ÁËÒ»¸öÓÅ»¯·½°¸¡£ ²é¿´È«ÎÄ

solaris³£ÓÃÃüÁî_1

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ19ÈÕ, 10:04

¸ÃÎĵµ¼òµ¥½éÉÜÁËsolarisϵͳµÄһЩ³£ÓÃÃüÁÀýÈç²ì¿´cpu£¬memory£¬diskÐÅÏ¢µÄÃüÁîµÈ¡£

¸ÃÎÄÕÂת×Ôhttp://art.21e.cn/tec/system/solaris/3731.html

 ²é¿´È«ÎÄ

sort_area_retained_size

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ18ÈÕ, 20:08

ÔĶÁPractical Oracle 8i £¬¾ÀÕýÎÒÒÔǰ¶Ôsort_area_size,sort_area_retained_sizeµÄ²»Í¸³¹µÄÀí½â¡£

Ô­À´ÈÏΪ£¬Ò»¸ö½ø³ÌÔÚÖ´Ðи´ÔÓSQLµÄʱºò£¬¿ÉÒÔͬʱ·ÖÅä¶à¸ösort_area_sizeÔÚPGAÖУ»Æäʵ²»È»¡£

ÏÖÔÚÎÒµÄÀí½âÊÇ£¬Ò»¸ö½ø³ÌÔÚÖ´Ðи´ÔÓSQLµÄʱºò£¬×î¶àÖ»ÄÜ·ÖÅäÒ»¸ösort_area_sizeµÄÄÚ´æ¿Õ¼äÓÃÀ´ÅÅÐò(sort operation)£¬µ«¿ÉÒÔͬʱ·ÖÅä¶à¸ösort_area_retained_size´óСµÄÄÚ´æ¿Õ¼äÓÃÀ´±£´æÅÅÐòÍê±ÏºóµÄ½á¹û¼¯¡£

Ò²Àí½âÁËΪʲôÄÚ´æÅÅÐòÓÐʱºò»¹ÐèҪдÁÙʱ±í¿Õ¼ä£¨See example in È«ÎÄ£©¡£

 ²é¿´È«ÎÄ

statistics while exchange truncate

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ18ÈÕ, 16:50

×î³õÔÚ¶ÁCost Based Oracle Fundamentals¿´µ½µÄ¡£

Exchange partition/truncate partition »áÓ°Ïì±íµÄͳ¼ÆÐÅÏ¢¡°¹ýʱ¡±¡£

 ²é¿´È«ÎÄ

×÷±¸·ÝÈÝÔÖºÜÓÐǰ;µÄְҵȥ°É

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ16ÈÕ, 09:31

http://www.cnn.com/2006/TRAVEL/07/13/couchsurfing.ap/index.html

Êг¡°¡£¬»ú»á°¡~

 ²é¿´È«ÎÄ

ÎÒûÂú×ã

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2006ÄêÆßÔÂ13ÈÕ, 10:42

¿´ÁË2006ÊÀ½ç±­µÄ×îºó¾öÈü£¬2µãÄÖÁå½ÐÆðÀ´£¬¿´ÁË3¸öСʱ£¬¼Óʱ£¬µãÇò¡£µ«²¢Ã»Óеõ½Âú×㣻¾¹È»Èñ°±ÉµÄÒâ´óÀû¶Ó¸øÓ®ÁË£¬Æë´ïÄÚ±»Ï·¾çÐԵķ£ÏÂÁË¡£

Æë´ïÄÚ¹»MAN. ·¨¹ú¶ÓÊÇÎÞÃáÖ®Íõ¡£·¨¹ú¶ÓÍòË꣬Æë´ïÄÚÍòËê¡£

ÑÏÖØ±ÉÊÓÒ»´ó¶ÑÅ®È˵ÄÒâ´óÀû¶Ó£¬Ò»µã¼¼Êõº¬Á¿¶¼Ã»ÓС£


Valid XHTML 1.0 Strict and CSS. Powered by pLog
Design by Blog.lvwo.com