- 博客(13)
- 资源 (6)
- 收藏
- 关注
RSS订阅转载 What Is The Maximum Tablespace Size And Database Limit For An Oracle Database ? (文档 ID 1372905.1)
What Is The Maximum Tablespace Size And Database Limit For An Oracle Database ? (文档 ID 1372905.1)转到底部In this DocumentGoal Solu
2015-12-28 10:54:24
742
转载 maximum data file size of Oracle Databa
What is the Maximum Datafile Size Limit In an Oracle Database? (文档 ID 804733.1)转到底部In this DocumentGoal Solution
2015-12-28 10:53:18
1030
转载 ASM Mirroring and Disk Partnership
Let's say you have a RAID10 disk array with 50 disks. I'm offering you to play the following game. You'll spin a wheel of fortune divided into 50 equal slots with numbers ranging from 1 to 50. After
2015-12-27 14:43:52
388
转载 insert mode and logging
Table Mode Insert Mode ArchiveLog mode result----------- ------------- ----------------- ----------LOGGING APPEND ARCHIVE LOG redo generatedNOLOGGING
2015-12-20 09:33:01
519
原创 关于direct insert 里的reference key及trigger
11.2.0.4在SQL Reference里面描述direct insert 的限制：The target table cannot have any triggers or referential integrity constraints defined on it在这里实验了一下：create table t as select * from dba_objects w
2015-12-19 16:42:32
479
转载 Direct Path Insert - APPEND HINT and TM Enqueue LOCK Behaviour (文档 ID 1317447.1)
Direct Path Insert - APPEND HINT and TM Enqueue LOCK Behaviour (文档 ID 1317447.1)转到底部In this DocumentSymptoms Changes
2015-12-18 10:25:30
829
原创 ORA-12838
11.2.0.4direct path insert ■ If any serial or parallel statement attemptsto access a table that has alreadyQueries that access the same table, partition, or index are allowed before the direct-p
2015-12-17 20:25:41
595
转载 Dropping and creating tables in read only tablespaces?!
You probably already know that it’s possible to drop tables in Oracle read only tablespaces… (You did know that already, right? ;-) Here’s a little example:SQL> create tablespace ronly datafile '/u0
2015-12-14 22:03:03
489
转载 如何手工执行segment advisor(10g/11g)
begindeclareid number;name varchar2(100);descr varchar2(500);obj_id number;beginname:='Manual_Employees';descr:='Segment Advisor Example';dbms_advisor.create_task(advisor_name => 'Se
2015-12-10 20:29:52
654
转载 The Secrets of Oracle Row Chaining and Migration
http://www.akadia.com/services/ora_chained_rows.html The Secrets of Oracle Row Chaining and MigrationMartin Zahn, Akadia AG, Information Technology, CH-3672 OberdiessbachEM
2015-12-08 21:28:46
487
转载 Memory used by a single oracle server process
https://community.oracle.com/thread/2274306Memory used by a single oracle server processThis question is Not Answered.Sreejith_Nair Aug 23, 2011 4:09 AMWe have memory free ve
2015-12-05 11:12:56
515
转载 How to use the Linux top command
http://alvinalexander.com/linux/unix-linux-top-command-cpu-memoryHow to use the Linux top commandBy Alvin Alexander. Last updated: Feb 14, 2014Linux processes FAQ: Is there a utili
2015-12-05 08:58:36
494
转载 Finding open files with lsof
http://www.ibm.com/developerworks/aix/library/au-lsof.htmlLearn more about your system by seeing which files are open. Knowing which files an application has open, or which application
2015-12-02 22:05:38
620
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人