锘??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲欧美国产日韩av野草社区,亚洲一级特黄无码片,亚洲伊人久久综合影院http://www.tkk7.com/Jcat/瀹犺頸涓嶆儕錛岄棽鐪嬪涵鍓嶈姳寮鑺辮惤锝烇綖zh-cnSat, 10 May 2025 19:25:51 GMTSat, 10 May 2025 19:25:51 GMT60鍦ｆ枟澹崄浜屽鎬葷粨http://www.tkk7.com/Jcat/archive/2011/10/21/361713.htmlJcatJcatFri, 21 Oct 2011 06:29:00 GMThttp://www.tkk7.com/Jcat/archive/2011/10/21/361713.htmlhttp://www.tkk7.com/Jcat/comments/361713.htmlhttp://www.tkk7.com/Jcat/archive/2011/10/21/361713.html#Feedback1http://www.tkk7.com/Jcat/comments/commentRss/361713.htmlhttp://www.tkk7.com/Jcat/services/trackbacks/361713.html
娌′漢闃詫細鍙屽瓙錛堣糠瀹級銆佸ぉ騫籌紙鍗″鐨勫啺綆憋級銆佸皠鎵嬶紙榪峰錛?br />
鎵撴錛氬法锜癸紙绱緳錛夈佸北緹婏紙绱緳鑷洕錛夈佸弻楸鹼紙闃跨灛錛夈佹按鐡訛紙鍐版渤錛?br />
娌℃墦榪囷紝鏀炬按錛氱嫯瀛愶紙鏄熺煝錛夈佸ぉ铦庯紙鍐版渤錛夈侀噾鐗涳紙鏄熺煝錛夈佸濂籌紙涓杈夛級


榪欐牱鐪嬫潵绱緳鏄渶NB鐨勶紝涓涓漢騫叉帀2涓紝鑰屼笖闈犱粬甯堝倕璧板悗闂ㄥぉ騫充笉鐢ㄦ墦錛岃繕鐢ㄥぉ騫崇殑姝﹀櫒鏁戜簡鍐版渤銆?br />
鍐版渤鍜屼粬甯堝倕騫蹭簡2浠?br />鍐版渤閭ｆ涔熸尯NB錛屽厛鏄湪澶╁鉤琚喕涓崐姝伙紝鐒跺悗鍦ㄥぉ铦庤閽堟墡涓崐姝伙紝鏈鍚庡埌浜嗘按鐡惰繕鑳芥妸浠栧笀鍌呭共鎺?br />鍐版渤鍜屼粬甯堝倕鏄渶浣撶幇瀹炲姏鐨勪竴浠楋紝綰疄鍔涘鎵?br />
鍚堢潃鏄熺煝璋佷篃娌℃潃錛屽氨TM鏉ユ墦閰辨補鐨勩傘傘?br />

Jcat 2011-10-21 14:29 鍙戣〃璇勮
]]>Oracle 11g Release2 鏂扮壒鎬?/title><link>http://www.tkk7.com/Jcat/archive/2011/06/17/352525.html</link><dc:creator>Jcat</dc:creator><author>Jcat</author><pubDate>Fri, 17 Jun 2011 07:35:00 GMT</pubDate><guid>http://www.tkk7.com/Jcat/archive/2011/06/17/352525.html</guid><wfw:comment>http://www.tkk7.com/Jcat/comments/352525.html</wfw:comment><comments>http://www.tkk7.com/Jcat/archive/2011/06/17/352525.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Jcat/comments/commentRss/352525.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Jcat/services/trackbacks/352525.html</trackback:ping><description><![CDATA[ <font color="#a52a2a">綆鍗曡繃涓閬嶏紝璇︾粏鐨勪互鍚庨亣鍒版參鎱㈢爺絀躲?br />涓昏鐨勬洿鏂板湪鍑犱釜鏂歸潰錛?br />1. OUI鐨勬敼榪?br />2. Oracle Restart<br /></font> <b> <font color="#a52a2a">3. ASM鐨勫寮猴紒錛侊紒</font> </b> <br /> <br /> <br /> <font color="#0000ff">New Grid Infrastructure Installation Option</font> <br />聽1. 鍗曠偣鍖呮嫭錛欰SM銆乴istener鍜孫racle Restart錛堢洃鎺с佺鐞嗗茍鑷姩閲嶅惎鍚勪釜緇勪歡錛?br />聽2. 闆嗙兢鍖呮嫭錛欰SM銆乴istener鍜孋lusterware<br /><br /><font color="#0000ff">New Desktop and Server Class Options</font><br />聽1. Desktop Class錛氶傜敤浜庣瑪璁版湰銆佸彴寮忔満<br />聽2. Server Class錛氶傜敤浜庢湇鍔″櫒錛堝姛鑳戒笂娌″尯鍒紝澶氫竴浜涢珮綰ч厤緗夐」錛?br /><br /><font color="#0000ff">Daylight Savings Time Upgrade of Timestamp with Timezone Data Type</font><br />聽鏂扮殑DBMS_DST鍖咃紝浼樺寲瀵筎IMESTAMP WITH TIMEZONE鏁版嵁鐨勭鐞?br /><br /><font color="#0000ff">SYSASM Privilege</font><br />聽綆＄悊ASM闇瑕丼YSASM鏉冮檺錛屾棬鍦ㄥ垎娓匒SM綆＄悊鍜孌B綆＄悊<br /><br /><font color="#0000ff">Fixup Scripts and Prerequisite Checks</font><br />聽瀹夎鍓嶆鏌ユ椂錛屽鏋滈亣鍒頒笉絎﹀悎瑕佹眰鐨勯厤緗紝OUI浼氬涓浜涙鏌ラ」鑷姩鐢熸垚fixup鑴氭湰錛岀敤root鎵ц灝卞彲浠ヨВ鍐崇浉搴旈棶棰樸?br /><br /><font color="#0000ff">New Tool to Configure Custom Installation Options</font><br />聽OUI涓嶅湪鎻愪緵瀵瑰崟涓粍浠剁殑閰嶇疆鍔熻兘錛屽鏋滈渶瑕佸彧鑳界敤$ORACLE_HOME/bin/chopt鍛戒護琛岃繘琛岄厤緗?b>鎴戞兂Oracle鐨勮秼鍔垮氨鏄負浜嗚鏇村宸茬粡鎴愮啛鐨?font color="#ff0000">閰嶇疆鑷姩鍖?/font>錛岀畝鍖栦嬌鐢ㄣ?/b><br /><br /><font color="#0000ff">Deinstallation Tool</font><br />聽OUI涓嶅啀鐢ㄦ潵鍒犻櫎oracle杞歡錛岃浣跨敤$ORACLE_HOME/deinstall<br /><br /><font color="#0000ff">Intelligent Data Placement</font><br />聽鎸囧畾ASM紓佺洏鐨勭鐩樿寖鍥達紝鏃ㄥ湪灝嗛珮棰戣闂殑鏁版嵁鏀懼湪HOT region錛堟瘮濡傜鐩樼殑澶栭亾錛?br /><br /><font color="#0000ff">Oracle Automatic Storage Management Cluster File System (Oracle ACFS)</font><br />聽涓哄叾瀹冩枃浠舵彁渚汚SM鐨勫瓨鍌ㄥ姛鑳?br /><br /><font color="#0000ff">Data Pump Export and Data Pump Import</font><br />聽Data Pump鍏煎Export/Import<br /><font color="#0000ff"><br />Use Oracle Restart to Automatically Restart Your Database</font><br />聽1. 閽堝鍗曠偣鐜<br />聽2. 鑷姩閲嶅惎鍙堥棶棰樼殑緇勪歡錛屽錛歞b instance銆乴istener銆乤sm instance<br /><br /><font color="#0000ff">New Method of Installing Oracle Automatic Storage Management</font><br />聽浠ュ墠錛孉SM鐨勫畨瑁呮槸浼撮殢鐫DB鐨勫畨瑁咃紱鐜板湪鏄即闅忕潃Software鐨勫畨瑁呫?br />聽鍏跺疄錛屽氨鏄妸ASM涓婂崌鍒頒竴涓蔣浠剁殑楂樺害錛堜互鍓嶅彧鏄痙b鐨勪竴涓粍浠訛級<br /><br /><font color="#0000ff">SRVCTL Support for Single Instance Database in a Cluster</font><br />聽SRVCTL緇熶竴綆＄悊鍗曠偣錛坵ith Restart錛夊拰闆嗙兢鏁版嵁搴擄紙with Clusterware錛?br /><br /><strike><font color="#0000ff">Deprecated in Oracle Database 11g Release 2</font></strike><br />聽涓嶆敮鎸佽８璁懼浜嗭細瑕佷箞鐢ㄦ枃浠剁郴緇熴佽涔堢敤ASM錛岃鐧戒簡錛?font color="#ff0000"><b>浼佷笟鐜灝卞繀欏葷敤ASM</b></font><br />聽涓嶆敮鎸丱racle Ultra Search錛?i鐨勪竴涓粈涔堥笩鍔熻兘錛?br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><img src ="http://www.tkk7.com/Jcat/aggbug/352525.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Jcat/" target="_blank">Jcat</a> 2011-06-17 15:35 <a href="http://www.tkk7.com/Jcat/archive/2011/06/17/352525.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Win - 鍚姩緇胯壊鐗圡YSQLhttp://www.tkk7.com/Jcat/archive/2011/06/16/352394.htmlJcatJcatWed, 15 Jun 2011 17:40:00 GMThttp://www.tkk7.com/Jcat/archive/2011/06/16/352394.htmlhttp://www.tkk7.com/Jcat/comments/352394.htmlhttp://www.tkk7.com/Jcat/archive/2011/06/16/352394.html#Feedback1http://www.tkk7.com/Jcat/comments/commentRss/352394.htmlhttp://www.tkk7.com/Jcat/services/trackbacks/352394.html閲嶈瀹岀郴緇燂紝mysql涓嶉渶瑕侀噸瑁咃紝鐩存帴褰撶豢鑹茬増浣跨敤錛岃繕鏇村共鍑

//鍚姩MYSQL
cd $MYSQL_HOME/bin
D:\JAVA\MYSQL\mysql-5.1.53-win32\bin>mysqld --console聽聽聽聽聽聽
110616聽 1:26:26 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110616聽 1:26:26聽 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110616聽 1:26:26聽 InnoDB: Started; log sequence number 0 44233
110616聽 1:26:27 [Note] Event Scheduler: Loaded 0 events
110616聽 1:26:27 [Note] mysqld: ready for connections.
Version: '5.1.53-community'聽 socket: ''聽 port: 3306聽 MySQL Community Server (GPL
)

//綆鍗曚嬌鐢?/font>
mysql> show databases;
+--------------------+
| Database聽聽聽聽聽聽聽聽聽聽 |
+--------------------+
| information_schema |
| mysql聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| test聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
+--------------------+
3 rows in set (0.03 sec)

mysql> use mysql
Database changed

mysql> show tables;
+---------------------------+
| Tables_in_mysql聽聽聽聽聽聽聽聽聽聽 |
+---------------------------+
| columns_priv聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| db聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| event聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| func聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| general_log聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| help_category聽聽聽聽聽聽聽聽聽聽聽聽 |
| help_keyword聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| help_relation聽聽聽聽聽聽聽聽聽聽聽聽 |
| help_topic聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| host聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 |
| ndb_binlog_index聽聽聽聽聽聽聽聽聽 |


鐧婚檰
D:\JAVA\MYSQL\mysql-5.1.53-win32\bin>mysql.exe -uroot
鍒涘緩鏁版嵁搴?/b>
mysql> create database testdb;






Jcat 2011-06-16 01:40 鍙戣〃璇勮
]]>鍒嗗尯琛?- 涓婚敭涓烘湰鍦扮儲寮?/title><link>http://www.tkk7.com/Jcat/archive/2010/09/15/332074.html</link><dc:creator>Jcat</dc:creator><author>Jcat</author><pubDate>Wed, 15 Sep 2010 07:26:00 GMT</pubDate><guid>http://www.tkk7.com/Jcat/archive/2010/09/15/332074.html</guid><wfw:comment>http://www.tkk7.com/Jcat/comments/332074.html</wfw:comment><comments>http://www.tkk7.com/Jcat/archive/2010/09/15/332074.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Jcat/comments/commentRss/332074.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Jcat/services/trackbacks/332074.html</trackback:ping><description><![CDATA[ <font color="#006400">--涓婚敭鏄潪鍒嗗尯绱㈠紩錛屼篃鍙互鐪嬩綔鏄叏灞</font> <br />create table test_par1<br />(<br />聽 tdate聽聽 varchar2(8) <font color="#ff0000">primary key</font><br />)<br />partition by range ( tdate )<br />(<br />聽聽聽聽 partition p1 values less than ('20090201'),<br />聽聽聽聽 partition p2 values less than ('20090301'),<br />聽聽聽聽 partition pm values less than (MAXVALUE) 聽<br />) tablespace test;<br /><br /><br /><font color="#006400">--涓婚敭鏄垎鍖虹儲寮?/font><br />create table test_par2<br />(<br />聽 tdate聽聽 varchar2(8)<br />)<br />partition by range ( tdate )<br />(<br />聽聽聽聽 partition p1 values less than ('20090201'),<br />聽聽聽聽 partition p2 values less than ('20090301'),<br />聽聽聽聽 partition pm values less than (MAXVALUE) 聽<br />) tablespace test;<br /><br /><font color="#ff0000">create index</font> i_tdate2 on test_par2(tdate) <b><font color="#ff0000">local</font></b>;<br /><br />alter table test_par2 <font color="#ff0000">add constraint</font> pk_tdate2 <font color="#ff0000">primary key</font>(tdate);<br /><br /><br /><br /><font color="#006400">--鏌ョ湅test_par2鐨凞DL<br /></font>select dbms_metadata.get_ddl( 'TABLE', 'TEST_PAR2' ) from dual;<br /><font color="#006400">--鏁寸悊濡備笅</font><br />create table test_par3<br />(<br />聽 tdate聽聽 varchar2(8),<br />聽 constraint pk_tdate3 primary key (tdate) <font color="#ff0000">using index <b>local</b></font><br />)<br />partition by range ( tdate )<br />(<br />聽聽聽聽 partition p1 values less than ('20090201'),<br />聽聽聽聽 partition p2 values less than ('20090301'),<br />聽聽聽聽 partition pm values less than (MAXVALUE) 聽<br />) tablespace test;<br /><br /><br /><font color="#a52a2a">榪欎釜妗堜緥涔熷憡璇夋垜浠紝鍦ㄥ仛DDL鏃訛紝灝介噺榪樻槸鏄劇ず鐨勫啓鍑哄睘鎬э紝涓浜涚畝鏄撹娉曚細寮曡搗涓嶅彲鐭ョ殑瀹氫箟銆傛渶鍚庨兘鐢?get_ddl 鍐嶆煡涓涓嬶紝榪欐墠鏄疧racle鐪熸鎵ц鐨凞DL銆?/font><br /><img src ="http://www.tkk7.com/Jcat/aggbug/332074.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Jcat/" target="_blank">Jcat</a> 2010-09-15 15:26 <a href="http://www.tkk7.com/Jcat/archive/2010/09/15/332074.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>DB2鍩虹鍛戒護http://www.tkk7.com/Jcat/archive/2010/07/09/325651.htmlJcatJcatFri, 09 Jul 2010 06:32:00 GMThttp://www.tkk7.com/Jcat/archive/2010/07/09/325651.htmlhttp://www.tkk7.com/Jcat/comments/325651.htmlhttp://www.tkk7.com/Jcat/archive/2010/07/09/325651.html#Feedback0http://www.tkk7.com/Jcat/comments/commentRss/325651.htmlhttp://www.tkk7.com/Jcat/services/trackbacks/325651.html鍒楀嚭鎵鏈夊疄渚?/font>
[db2inst1@dcm ~]$ db2ilist
db2inst1

鍒楀嚭褰撳墠瀹炰緥涓嬬殑鎵鏈夋暟鎹簱
[db2inst1@dcm ~]$ db2 list db directory

聽System Database Directory

聽Number of entries in the directory = 1

Database 1 entry:

聽Database alias聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 = SAMPLE
聽Database name聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 = SAMPLE
聽Local database directory聽聽聽聽聽聽聽聽聽聽聽聽 = /home/db2inst1
聽Database release level聽聽聽聽聽聽聽聽聽聽聽聽聽聽 = d.00
聽Comment聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 =
聽Directory entry type聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 = Indirect
聽Catalog database partition number聽聽聽 = 0
聽Alternate server hostname聽聽聽聽聽聽聽聽聽聽聽 =
聽Alternate server port number聽聽聽聽聽聽聽聽 =

鍚姩瀹炰緥
[db2inst1@dcm ~]$ db2start
07/09/2010 14:24:36聽聽聽聽 0聽聽 0聽聽 SQL1063N聽 DB2START processing was successful.
SQL1063N聽 DB2START processing was successful.

榪炴帴鍒版暟鎹簱
[db2inst1@dcm ~]$ db2 connect to sample

聽聽 Database Connection Information

聽Database server聽聽聽聽聽聽聽 = DB2/LINUX 9.7.1
聽SQL authorization ID聽聽 = DB2INST1
聽Local database alias聽聽 = SAMPLE

鎵цSQL
[db2inst1@dcm ~]$ db2
db2 => select * from staff where dept=20

ID聽聽聽聽 NAME聽聽聽聽聽 DEPT聽聽 JOB聽聽 YEARS聽 SALARY聽聽聽 COMM聽聽聽 聽
------ --------- ------ ----- ------ --------- ---------
聽聽聽 10 Sanders聽聽聽聽聽聽 20 Mgr聽聽聽聽聽聽聽 7聽 98357.50聽聽聽聽聽聽聽聽 -
聽聽聽 20 Pernal聽聽聽聽聽聽聽 20 Sales聽聽聽聽聽 8聽 78171.25聽聽聽 612.45
聽聽聽 80 James聽聽聽聽聽聽聽聽 20 Clerk聽聽聽聽聽 -聽 43504.60聽聽聽 128.20
聽聽 190 Sneider聽聽聽聽聽聽 20 Clerk聽聽聽聽聽 8聽 34252.75聽聽聽 126.50

聽 4 record(s) selected.

閫鍑?/font>
db2 => quit
DB20000I聽 The QUIT command completed successfully.

鏂紑榪炴帴錛堜笉鏂紑灝變笉鑳絛b2stop錛?/font>
[db2inst1@dcm ~]$ db2 connect reset
DB20000I聽 The SQL command completed successfully.

鍏抽棴瀹炰緥
[db2inst1@dcm ~]$ db2stop
07/09/2010 14:29:32聽聽聽聽 0聽聽 0聽聽 SQL1064N聽 DB2STOP processing was successful.
SQL1064N聽 DB2STOP processing was successful.



Jcat 2010-07-09 14:32 鍙戣〃璇勮
]]>鏁版嵁搴撱佸疄渚?on Oracle/DB2http://www.tkk7.com/Jcat/archive/2010/07/08/325584.htmlJcatJcatThu, 08 Jul 2010 10:26:00 GMThttp://www.tkk7.com/Jcat/archive/2010/07/08/325584.htmlhttp://www.tkk7.com/Jcat/comments/325584.htmlhttp://www.tkk7.com/Jcat/archive/2010/07/08/325584.html#Feedback0http://www.tkk7.com/Jcat/comments/commentRss/325584.htmlhttp://www.tkk7.com/Jcat/services/trackbacks/325584.html鏈榪戝垵鎺簡涓涓婦B2錛屽彂鐜板叧浜庘滄暟鎹簱鈥濄佲滃疄渚嬧濈殑姒傚康鍙婂叾鍏崇郴瀹規槗鎶婁漢寮勬檿錛岃繖閲屽皬灝忔葷粨涓涓嬶紝騫舵妸Oracle涔熸媺榪涙潵涓璧鋒暣銆?br />鍙﹀錛屽彂鐜癘racle鍜孖BM鑰佹悶涓浜涚悊璁轟笂灝遍拡閿嬬浉瀵圭殑浜嬫儏錛屽RAC vs DPF (database partitioning feature)錛屽緢鏄湁瓚ｃ?/font>


鍩烘湰姒傚康榪樻槸鐩稿悓鐨?/b>
鏁版嵁搴撹蔣浠訛紙涓嬮潰綆縐?b>杞歡錛?/font>錛氳蔣浠舵湰韜紝涓鍙頒富鏈哄畨瑁呬竴濂楀氨鍙互浜嗐傦紙鎶涘紑浣犳晠鎰忓湪涓鍙版湇鍔″櫒涓婂畨瑁?閬峅racle/DB2榪欑涓嶆甯告濈淮錛?br />
瀹炰緥錛氭暟鎹簱杞歡鍚姩鍚庣殑鈥滆繘紼?鍐呭瓨鈥?br />
杞歡+瀹炰緥鐨勫叧緋伙細涓鍙扮數鑴戝彧闇瑕佹寜鐓т竴濂桻Q錛堣蔣浠訛級錛屼絾鏄垜浠彲浠ュ鐢ㄦ埛鐧誨綍錛堝疄渚嬶級銆傛崲鍒板摬瀛︾殑瑙掑害錛屽氨鏄娊璞″拰鍏蜂綋鐨勫叧緋匯?br />
鏁版嵁搴擄紙鐙箟錛屼笅闈㈢畝縐?b>搴?/b>錛?/font>錛氫竴鍫嗘枃浠訛紙鏁版嵁鏂囦歡銆佹帶鍒舵枃浠躲佹棩蹇楁枃浠躲佸弬鏁版枃浠訛級
瀹冨拰杞歡鐨勫尯鍒細杞歡鏄巶鍟嗗崠緇欎綘鐨勪笢瑗匡紱搴?/b>鏄綘鑷繁鐨勪笢瑗匡紙涓氬姟銆佸簲鐢級
瀹冨拰瀹炰緥鐨勫叧緋伙細鐢ㄦ埛闇瑕佸熷姪瀹炰緥錛堟墍鎻愪緵鐨勫悇縐嶆墜孌碉級鏉ヨ闂?b>搴?/b>
搴?/b>灝辯浉褰撲簬鏄疩Q鑱婂ぉ璁板綍

鏈鍚庯細鏁版嵁搴擄紙騫夸箟錛? 杞歡 + 瀹炰緥 + 搴?/font>
涓鍙版湇鍔″櫒錛堝嵆涓濂楁暟鎹簱杞歡錛夊彲浠ュ緩澶氫釜瀹炰緥錛屽涓簱錛屼笖浜掍笉鐩稿共


浣撶郴緇撴瀯鐨勪笉鍚屼箣澶?/b>
Oracle聽 瀹炰緥鍜屽簱涓涓瀵瑰簲
DB2聽聽聽聽 涓涓疄渚嬪彲浠ユ寕澶氫釜搴?br />

楂樼駭鎯呭喌錛堢畝鍗曟彁涓涓嬶紝浠ュ悗鍐嶆參鎱㈢爺絀訛級
Oracle錛歊AC涓涓簱琚涓疄渚嬫寕
DB2錛欴PF涓涓疄渚嬪涓簱
鍦ㄦ暟鎹簱闆嗙兢妯″紡璁捐鏂歸潰錛屾湁Share everything鏋舵瀯鍜孲hare nothing鏋舵瀯錛屽墠鑰呬互ORACLE RAC涓轟唬琛紝IBM DB2 Purescale涓烘寫鎴樿咃紱鍚庤呬互IBM DB2 DPF涓轟唬琛ㄣ?br />



Jcat 2010-07-08 18:26 鍙戣〃璇勮
]]>琛岄摼鎺?鍜?琛岃縼縐?/title><link>http://www.tkk7.com/Jcat/archive/2010/06/13/323511.html</link><dc:creator>Jcat</dc:creator><author>Jcat</author><pubDate>Sun, 13 Jun 2010 06:08:00 GMT</pubDate><guid>http://www.tkk7.com/Jcat/archive/2010/06/13/323511.html</guid><wfw:comment>http://www.tkk7.com/Jcat/comments/323511.html</wfw:comment><comments>http://www.tkk7.com/Jcat/archive/2010/06/13/323511.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Jcat/comments/commentRss/323511.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Jcat/services/trackbacks/323511.html</trackback:ping><description><![CDATA[ <font size="5">琛岄摼鎺ワ細</font> <br />1. 涓鏉¤褰曠殑澶у皬澶т簬block size錛屽垯浜х敓琛岄摼鎺?br />2. 瀹規槗鍙戠敓鍦ㄦ瘮杈冨ぇ鐨勮涓?br />3. 鍥犱負琛岄摼鎺ユ槸鐢眃b_block_size涓嶅澶у紩璧風殑錛屾墍浠ュ宸叉湁鐨勮閾炬帴鏄棤娉曟竻闄ょ殑<br />4. 9i浠ュ悗錛屽彲浠ュ涓嶅悓鐨勮〃絀洪棿璁劇疆涓嶅悓鐨刣b_block_size錛屽彲浠ュ皢涓浜涚壒孌婄殑瀹借〃鏀懼湪澶lock size鐨勮〃絀洪棿<br /><br />渚嬪瓙錛?br />琛ㄧ┖闂碽lock size涓?k錛?192錛夛紝鍥犱負鏁版嵁鍧楀ご涔熻鍗犱竴瀹氱┖闂達紝鎵浠ュ涓嬩緥錛屽疄闄呭彧鑳芥斁7948鐨勬暟鎹紝涓鏃﹁秴榪囷紝灝變駭鐢熻閾炬帴<br /><br />--鏃?br />create table test7948(a char(2000),b char(2000),c char(2000),d char(1948))<br />tablespace test;<br /><br />insert into test7948 values('a','b','c','d');<br />commit;<br /><br />--鏈?br />create table test7949(a char(2000),b char(2000),c char(2000),d char(1949))<br />tablespace test;<br /><br />insert into test7949 values('a','b','c','d');<br />commit;<br /><br /><br /><br /><font size="5">琛岃縼縐伙細</font><br />1. 鏈潵鏄斁鐨勪笅鐨?br />2. 鍥犱負鏇存柊浣縭ow size鍙樺ぇ浜嗭紝涓涓猙lock閲屽張涓嶈凍浠ユ斁涓嬪鍔犵殑絀洪棿錛圥CTFREE鐩稿叧錛夛紝鍒欎駭鐢熻榪佺Щ<br />3. 瀹規槗鍙戠敓鍦≒CTFREE杈冨皬錛屽綾諱技varchar綾誨瀷鐨剈pdate鍙堝緢澶氱殑琛ㄤ笂<br />4. 鏃犳硶閬垮厤錛屼絾閫氳繃鎶婃暟鎹鍑哄鍏ヨ繘琛屾竻闄?br /><br />渚嬪瓙錛?br />--鏃?br />create table test7948_vchar(a char(2000),b char(2000),c char(2000),d char(1940), e varchar(9))<br />tablespace test;<br /><br />insert into test7948_vchar values('a','b','c','d','12345678');<br />commit;<br /><br />涓鏇存柊錛屼嬌寰梤ow size澶т簬7948浜嗭紝浜х敓琛岃縼縐?br />--鏈?br />update test7948_vchar set e='123456789'<img src ="http://www.tkk7.com/Jcat/aggbug/323511.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Jcat/" target="_blank">Jcat</a> 2010-06-13 14:08 <a href="http://www.tkk7.com/Jcat/archive/2010/06/13/323511.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鏀惰喘錛孖T姝ｅ湪鍚戝瀯鏂寲鍙戝睍http://www.tkk7.com/Jcat/archive/2010/05/14/320964.htmlJcatJcatFri, 14 May 2010 03:24:00 GMThttp://www.tkk7.com/Jcat/archive/2010/05/14/320964.htmlhttp://www.tkk7.com/Jcat/comments/320964.htmlhttp://www.tkk7.com/Jcat/archive/2010/05/14/320964.html#Feedback0http://www.tkk7.com/Jcat/comments/commentRss/320964.htmlhttp://www.tkk7.com/Jcat/services/trackbacks/320964.html
鐜扮姸錛?br />Oracle鍜孖BM宸茬粡鎴愪負璇轟簹鏂硅垷綰х殑鍘傚晢錛屽暐閮芥湁銆?br />寰蔣錛孲AP鎴愪負鑸瘝綰х殑鍘傚晢錛岃蔣浠舵柟闈㈠暐閮芥湁錛屼絾鐩墠娌℃湁紜歡銆?br />
鐚滄兂錛歸ho's next? Dell? HP?
涓嶇劧寰蔣鎶奃ell鏀朵簡鍚э紝緇勬垚BDll鍏徃錛?br />鐒跺悗SAP鍜孒P鍚堝茍涓篠HP


Jcat 2010-05-14 11:24 鍙戣〃璇勮
]]>鍒囨崲TEMP琛ㄧ┖闂?/title><link>http://www.tkk7.com/Jcat/archive/2010/04/30/319765.html</link><dc:creator>Jcat</dc:creator><author>Jcat</author><pubDate>Fri, 30 Apr 2010 03:05:00 GMT</pubDate><guid>http://www.tkk7.com/Jcat/archive/2010/04/30/319765.html</guid><wfw:comment>http://www.tkk7.com/Jcat/comments/319765.html</wfw:comment><comments>http://www.tkk7.com/Jcat/archive/2010/04/30/319765.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Jcat/comments/commentRss/319765.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Jcat/services/trackbacks/319765.html</trackback:ping><description><![CDATA[--鍒涘緩涓涓ぇ涓鐐圭殑TEMP琛ㄧ┖闂?br />create temporary tablespace temp1<br />tempfile '/oracledatafile/temp01.dbf' SIZE 100m autoextend on next 100m maxsize 5000m;<br />聽<br />--鍒囨崲榛樿TEMP琛ㄧ┖闂?br />alter database default temporary tablespace temp1;<br /><br />--鍒犳帀浠ュ墠鐨凾EMP琛ㄧ┖闂?br />drop tablespace temp including contents and datafiles;<img src ="http://www.tkk7.com/Jcat/aggbug/319765.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Jcat/" target="_blank">Jcat</a> 2010-04-30 11:05 <a href="http://www.tkk7.com/Jcat/archive/2010/04/30/319765.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鐗╁寲瑙嗗浘http://www.tkk7.com/Jcat/archive/2010/01/13/309251.htmlJcatJcatTue, 12 Jan 2010 16:04:00 GMThttp://www.tkk7.com/Jcat/archive/2010/01/13/309251.htmlhttp://www.tkk7.com/Jcat/comments/309251.htmlhttp://www.tkk7.com/Jcat/archive/2010/01/13/309251.html#Feedback2http://www.tkk7.com/Jcat/comments/commentRss/309251.htmlhttp://www.tkk7.com/Jcat/services/trackbacks/309251.html 1. 鐗╁寲瑙嗗浘鐢變簬鏄墿鐞嗙湡瀹炲瓨鍦ㄧ殑錛屾晠鍙互鍒涘緩绱㈠紩銆?




--涓哄熀琛ㄥ垱寤篗LOG
--鍒涘緩鐗╁寲瑙嗗浘鏃跺簲鍏堝垱寤哄瓨鍌ㄧ殑鏃ュ織絀洪棿錛屽惁鍒欏緩MV鏃舵姤閿?br />--ORA-23413: table "SCOTT"."EMP" does not have a materialized view log
create materialized view log on scott.emp
tablespace test
/


--鍒涘緩鐗╁寲瑙嗗浘
create materialized view test_mv
tablespace test
parallel (degree 4)
build immediate refresh fast
enable query rewrite
as
select * from scott.emp
/


--鏌ョ湅涓涓嬬粨鏋滐紝鏋滅劧寰堢鍚堢墿鍖栬鍥劇殑瀹氫箟錛屼竴涓〃+涓涓鍥?/font>
SQL> select object_name, object_type from user_objects where object_name = 'TEST_MV';
OBJECT_NAME聽聽聽 OBJECT_TYPE
-----------聽聽聽 --------
TEST_MV聽聽聽 聽聽聽 TABLE
TEST_MV聽聽聽 聽聽聽 MATERIALIZED VIEW

SQL> select mview_name, container_name from user_mviews;
MVIEW_NAME聽聽聽聽聽聽 CONTAINER_NAME
---------------- ------------------------------
TEST_MV聽聽聽聽聽聽聽聽聽 TEST_MV聽 錛堣繖灝辨槸閭ｄ釜瀛樺偍琛級

--鏌ョ湅MLOG鐨勬儏鍐?/font>
--娉ㄦ剰錛歁LOG鐨勬墍灞炲拰MV鐨勬墍灞炲茍涓嶆槸鍚屼竴涓?/font>
SQL> select log_owner, master, log_table from dba_mview_logs
LOG_OWNER聽聽聽 MASTER聽聽聽 LOG_TABLE
---------------------------------
SCOTT聽聽聽 聽聽聽 EMP聽聽聽 MLOG$_EMP 錛圡LOG鍏跺疄涔熷氨鏄竴涓〃錛?/font>

SQL> desc scott.mlog$_emp;
Name聽聽聽 聽聽聽 聽聽聽 Type
-------------------------------
EMPNO聽聽聽 聽聽聽 聽聽聽 NUMBER(4)
SNAPTIME$$聽聽聽 聽聽聽 DATE
DMLTYPE$$聽聽聽 聽聽聽 VARCHAR2(1)
OLD_NEW$$聽聽聽 聽聽聽 VARCHAR2(1)
CHANGE_VECTOR$$聽聽聽 聽聽聽 RAW(255)



--鍒犻櫎MLOG
drop materialized view log on 鐗╁寲瑙嗗浘鎵渚濊禆鐨勮〃鍚?聽
--鍒犻櫎鐗╁寲瑙嗗浘
drop materialized view 鐗╁寲瑙嗗浘鍚?


Jcat 2010-01-13 00:04 鍙戣〃璇勮
]]> 主站蜘蛛池模板： 久久不见久久见免费影院www日本| 国产偷国产偷亚洲清高APP| 99精品免费视频| 国产亚洲人成A在线V网站| 青青草国产免费国产是公开| 免费日韩在线视频| 成人精品国产亚洲欧洲| 无码国产亚洲日韩国精品视频一区二区三区| 亚洲AV成人影视在线观看| 嫩草视频在线免费观看| 爱情岛论坛亚洲品质自拍视频网站| 国产精品色午夜视频免费看| 黄色免费在线网址| 狠狠亚洲婷婷综合色香五月排名| 两个人看的www高清免费视频| 亚洲AV无码一区二区三区DV | yy一级毛片免费视频| 亚洲精品国产字幕久久不卡| 一级毛片aaaaaa免费看| 亚洲成人网在线播放| 午夜成人免费视频| 亚州**色毛片免费观看| 亚洲大尺度无码专区尤物| 四虎成年永久免费网站 | www亚洲精品久久久乳| 精品国产亚洲一区二区在线观看| 99麻豆久久久国产精品免费| 亚洲黄色在线电影| 日韩中文字幕免费| 精品一区二区三区高清免费观看| 久久精品国产亚洲av日韩| 国内自产少妇自拍区免费| 精选影视免费在线 | 亚洲午夜久久久精品电影院| 免费一级毛片在线观看| 欧洲人成在线免费| 亚洲成在人线在线播放无码| 亚洲精品你懂的在线观看| 可以免费看黄视频的网站| 麻豆一区二区三区蜜桃免费| 亚洲成在人天堂在线|