DBAORACLE

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

½ñÌìÊÕµ½Oracle¼ÄÀ´µÄOCPÖ¤Êé

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2009Äê¶þÔÂ20ÈÕ, 16:27

¸ãÁË7ÄêµÄOracle£¬µ½ÏÖÔÚËãÊÇÕýʽ±»OracleÈÏ¿ÉÁË£¬ÊÕµ½ÁËÅÎÍûÒѾõÄOCPÖ¤Êé¡£

È¥Äê11Ô·ݲμÓÍêOCP¿¼ÊÔ£¬ÔÚOracleÍøÕ¾Ìá½»hands onºóµÚ9ÌìÊÕµ½OracleµÄÈ·ÈÏÐÅ£¬È»ºó¾ÍÊǵȴý¼ÄËÍÖ¤ÊéÁË£¬¿ÉÒ»Ö±µÈÁËÁ½¸öÔ»¹ÊÇûÓÐÏûÏ¢¡£ÎÞÄÎÖ®ÏÂÏòOracle·¢ÁË·âÓʼþÒªÇóÖØ¼Ä£¬Õâ´Îµ¹Í¦¿ì£¬2ÔÂ4ÈÕ·¢µÄÓʼþ£¬½ñÌì¾ÍÊÕµ½ÁËÖ¤Ê飬DHLË͹ýÀ´µÄ£¬ÎªÉ¶µÚÒ»´Î¾ÍûË͵½ÄØ£¿


Ten Principles of Economics__How The Economy as a Whole Works

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2009Äê¶þÔÂ20ÈÕ, 16:06

Principle#8: A Country's Standard of Living Depends on its Ability to Produce Goods and Services;

Principle#9: Prices Rise When the Government Prints Too Much Money;

Principle#10: Society Faces a Short-Run Tradeoff between Inflation and Unemployment.


Ten Principles of Economics__How People Interact

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2009Äê¶þÔÂ20ÈÕ, 16:01

Principle#5: Trade Can Make Everyone Better Off;

Principle#6: Markets Are Usually a Good Way to Organize Economic Activity;

Principle#7: Governments Can Sometimes Improve Market Outcomes;


Ten Principles of Economics__How People Make Decisions

·¢±íÈË:dbaoracle | ·¢±íʱ¼ä: 2009Äê¶þÔÂ20ÈÕ, 10:19

Principle#1: People Face Tradeoffs;

Principle#2: The Cost of Someting Is What You Give Up to Get It;

Principle#3: Rational People Think at the Margin;

Principle#4: People Respond to Incentives;


Using Flashback Drop and Managing the Recycle Bin

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

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

 ²é¿´È«ÎÄ

¶à±í²åÈëÖÐÉæ¼°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

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

 ²é¿´È«ÎÄ

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