- 博客(86)
- 收藏
- 关注
RSS订阅转载 ggsci: error while loading shared libraries: libnnz11.so
[oracle@oracle goldgate]$ ggsciggsci: error while loading shared libraries: libnnz11.so: cannot open shared obje...
2016-03-21 21:47:00
312
转载 oracle grid install 6 of steps 13
INFO:INFO: Copy remotefile: /home/grid/.ssh/identity.pub to localfile: /home/grid/.ssh/identity.pub.rac01...
2016-02-18 16:33:20
156
转载 limits.conf
# /etc/security/limits.conf##Each line describes a limit for a user in the form:##<domain> &l...
2016-02-14 15:10:08
166
转载 warning: rpmts_HdrFromFdno:
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID*****这是由于yum安装了旧版本的GPG key或者key文件不存在s造成的，解决办法如...
2016-01-27 13:23:33
197
转载 tkprof
C:\Users\cj>tkprofUsage: tkprof tracefile outputfile [explain= ] [table= ] [print= ] [insert...
2014-06-02 14:46:31
113
转载 Shrinking Database Segments Online
Shrinking Database Segments Online You use online segment shrink to reclaim fragmented free space...
2014-04-05 18:33:45
139
转载 Analyzing Tables, Indexes, and Clusters
1.Analyzing Tables, Indexes, and Clusters You analyze a schema object (table, index, or cluster) to:...
2014-04-04 14:54:35
116
转载 Managing Datafile
1.Creating Datafiles and Adding Datafiles to a Tablespace You can create datafiles and as...
2014-03-30 19:38:22
72
转载 Altering and Maintaining Tablespaces
1.Increasing the Size of a Tablespace You can increase the size of a tablespace by either incre...
2014-03-30 16:02:20
95
转载 Creating Tablespaces
1.Locally Managed Tablespaces Locally managed tablespaces track all extent information in the ta...
2014-03-30 15:43:07
141
转载 Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
Use the DBMS_SPACE_ADMIN package to migrate the SYSTEM tablespace from dictionary-managed to locally managed. T...
2014-03-29 14:52:26
110
转载 Managing Archive redo log
1. Archive redo logOracle Database lets you save filled groups of redo log files to one or more offline destin...
2014-03-26 14:33:07
85
转载 Managing Redo File
1、How Oracle Database Writes to the Redo Log The redo log of a database consists of two or more redo lo...
2014-03-25 19:57:55
86
转载 Control Files
一、Multiplex Control Files on Different Disks Every Oracle Database should have at ...
2014-03-25 10:45:49
99
转载 alert and trace
Monitoring Errors with Trace Files and the Alert Log Each server and background process can write ...
2014-03-18 18:36:11
138
转载 Summary of Memory Management Methods
summarizes the various memory management methods. If you do not enable automatic memory management, then you mus...
2014-03-16 19:47:54
77
转载 Oracle Database Background Processes
Oracle Database Background Processes Process Name Description ...
2014-03-16 10:31:52
89
转载 quiesce,suspend
Quiescing a Database Occasionally you might want to put a database in a state that allows only DBA tran...
2014-03-10 18:24:46
110
转载 Sample Initialization Parameter File
Oracle Database provides generally appropriate values in a sample text initialization parameter file. You can...
2014-03-08 12:35:53
192
转载 Create database a part
CREATE DATABASE mynewdb USER SYS IDENTIFIED BY sys_password USER SYSTEM IDENTIFIED BY system_password LOGFILE ...
2014-03-08 12:34:43
64
转载 Creating a Database with Noninteractive/Silent DBCA
Creating a Database with Noninteractive/Silent DBCA See Appendix A of the installation guide for your pla...
2014-03-06 19:14:16
105
转载 EXP-00056: ORACLE error 12514 encountered解决方法
[oracle@cj emp_imp]$ exp scott/tiger@cj01 tables=scott.dept, file='/db/ora11g/test/emp_imp/dept.dmp', log='/db/ora...
2014-02-26 21:46:49
1162
转载 SGA
Overviewof the System Global Area The SGA is a read/write memory area that,along with the Ora...
2014-01-06 22:13:12
104
转载 UGA,PGA
Introductionto Oracle Database Memory Structures When an instance isstarted, Oracle Database ...
2014-01-06 21:55:59
92
转载 instance structure
DatabaseInstance Structure When an instanceis started, Oracle Database allocates a memory are...
2014-01-02 09:49:02
120
转载 Undo Segments
Undo Segments Oracle Database maintains records of the actions oftransactions, collectively known as un...
2013-12-30 17:19:15
194
转载 Overview of Tablespaces
Overview of Tablespaces A tablespace is a logicalstorage container for segments. Segments are database ...
2013-12-30 17:16:14
100
转载 Logical Space Management
Logical Space Management Oracle Database must use logical space management to track and allocatethe ext...
2013-12-28 21:46:12
71
转载 Chained and Migrated Rows
Chained and Migrated Rows Oracle Database must managerows that are too large to fit into a single block...
2013-12-26 15:35:31
154
转载 Transactions
一，Enqueued Transactions Depending on the scenario, transactions waiting for previouslylocked...
2013-12-21 23:54:02
95
转载 Overview of LOBs
Overview of LOBs The large object (LOB) data types enable you to store and manipulate large blocks o...
2013-12-09 19:09:03
91
转载 PL/SQL Subprograms and Packages
一Advantagesof PL/SQL SubprogramsAs explained in"Introduction to Server-Side Programming", server-side ...
2013-12-05 08:35:51
86
转载 Partitions
Overview of PartitionsPartitioning enables you to decompose very large tables and indexes into smaller and m...
2013-11-27 13:44:05
105
转载 Bitmap Indexes
Bitmap IndexesIn a bitmap index, the database stores a bitmap for each index key. In a conventional B-tree ind...
2013-11-27 13:12:47
101
转载 Hash Cluster
About Hash ClustersOracle Database uses a hash function to generate a distribution of numeric values, called h...
2013-11-21 19:13:40
128
转载 Cluster Table
Overview of Table ClustersA table cluster is a group of tables that share common columns and store related dat...
2013-11-20 15:39:42
141
转载 Advanced Compression
OracleAdvancedCompression TheOracleDatabase11gAdvancedCompressionOptionintroducesacomprehens...
2013-11-20 10:48:30
202
转载 Compression One
Table Compression The database can use table compression to reduce the amount of storage required for the table....
2013-11-20 00:13:00
61
转载 Compression Two
As your database grows in size, consider using table compression. Compression saves disk space, reduces memory u...
2013-11-19 19:57:17
159
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人