- 博客(38)
- 资源 (13)
- 收藏
- 关注
翻译 Benefits for Data Warehousing Applications【每日一译】--1229
Bitmap indexing benefits data warehousing applications which have large amounts ofdata and ad hoc queries but a low level of concurrent transactions. For suchapplications, bitmap indexing provides
2012-12-31 22:40:29 550
翻译 Bitmap Indexes【每日一译】--20121228
The purpose of an index is to provide pointers to the rows in a table that contain agiven key value. In a regular index, this is achieved by storing a list of rowids for eachkey corresponding to t
2012-12-31 20:30:09 434
翻译 External Table Restrictions【每日一译】--1227
This section lists what the external tables feature does not do and also describes someprocessing restrictions.这部份列出了外部表的一些不能做的功能和另外描述了一些处理的限制■ Exporting and importing of external tables with
2012-12-29 17:17:59 496
翻译 Parallel Access with ORACLE_LOADER【每日一译】--20121226
The ORACLE_LOADER access driver attempts to divide large datafiles into chunks thatcan be processed separately.The following file, record, and data characteristics make it impossible for a file to
2012-12-29 16:30:41 523
翻译 Unloading Data Using the ORACLE_DATAPUMP Access Driver【每日一译】--20121225
To unload data, you use the ORACLE_DATAPUMP access driver. The data stream that isunloaded is in a proprietary format and contains all the column data for every rowbeing unloaded.An unload opera
2012-12-29 15:37:43 717
原创 ORA-39109: Unprivileged users may not operate upon other users' schemas
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-31631: privileges are required
2012-12-27 17:26:04 5662 2
翻译 Reverse Key Indexes【每日一译】--20121224
Creating a reverse key index, compared to a standard index, reverses the bytes of eachcolumn indexed (except the rowid) while keeping the column order. Such anarrangement can help avoid performanc
2012-12-27 10:08:35 800
翻译 Uses of Key Compression【每日一译】--20121223
Key compression is useful in many different scenarios, such as:■ In a nonunique regular index, Oracle stores duplicate keys with the rowidappended to the key to break the duplicate rows. If key co
2012-12-27 09:05:22 495
翻译 About classic capture【每日一译】--20121222
In classic capture mode, the Oracle GoldenGate Extract process captures data changesfrom the Oracle redo or archive log files on the source system or from shipped archivelogs on a standby system.
2012-12-26 09:42:53 669
翻译 Index Range Scan【每日一译】--20121221
Index range scan is a common operation for accessing selective data. It can bebounded (bounded on both sides) or unbounded (on one or both sides). Data isreturned in the ascending order of index c
2012-12-25 14:44:07 581
翻译 Moving a Table to a New Segment or Tablespace【每日一译】--20121220
The ALTER TABLE...MOVE statement enables you to relocate data of anon-partitioned table or of a partition of a partitioned table into a new segment, andoptionally into a different tablespace for w
2012-12-25 11:56:48 448
翻译 Advantages of B-tree Structure【每日一译】--20121219
The B-tree structure has the following advantages:■ All leaf blocks of the tree are at the same depth, so retrieval of any record fromanywhere in the index takes approximately the same amount of t
2012-12-24 08:44:29 581
翻译 The Internal Structure of Indexes【每日一译】--20121217
Oracle uses B-trees to store indexes to speed up data access. With no indexes, you haveto do a sequential scan on the data to find a value. For n rows, the average number ofrows searched is n/2. T
2012-12-24 08:44:06 696
翻译 Monitoring Index Usage【每日一译】--20121216
Oracle Database provides a means of monitoring indexes to determine whether theyare being used. If an index is not being used, then it can be dropped, eliminatingunnecessary statement overhead.O
2012-12-21 09:31:15 525
翻译 Monitoring Space Use of Indexes【每日一译】--20121217
--监控索引空间的使用If key values in an index are inserted, updated, and deleted frequently, the index canlose its acquired space efficiently over time. Monitor index efficiency of space usage atre
2012-12-20 17:17:39 365
翻译 Rebuilding an Existing Index【每日一译】--1215
Before rebuilding an existing index, compare the costs and benefits associated withrebuilding to those associated with coalescing indexes as described in Table 16–1 onpage 16-5.在重建一个已存在索引前,比较成本和
2012-12-20 16:38:13 434
翻译 Format of Index Blocks【每日一译】--20121214
Space available for index data is the Oracle block size minus block overhead, entryoverhead, rowid, and one length byte for each value indexed.When you create an index, Oracle fetches and sorts th
2012-12-20 09:18:56 378
翻译 Resolve Dependencies of Function-Based Indexes【每日一译】--20121213
Resolve Dependencies of Function-Based Indexes A function-based index depends on anyfunction that it is using. If the function or the specification of a package containing thefunction is redefined
2012-12-17 11:00:01 753
原创 ORA-30553: The function is not deterministic
在自定义的函数上建立function-based索引;SQL> create index idx_001 on a(func_ib(comoon));create index idx_001 on a(func_ib(comoon)) *ERROR at line 1:ORA-30553: The function is n
2012-12-17 10:29:59 891
翻译 Dependencies of Function-Based Indexes【每日一译】--20121212
Function-based indexes depend on the function used in the expression that defines theindex. If the function is a PL/SQL function or package function, the index is disabledby any changes to the fun
2012-12-17 08:55:40 510
翻译 Indexes and Nulls【每日一译】--20121211
NULL values in indexes are considered to be distinct except when all the non-NULLvalues in two or more rows of an index are identical, in which case the rows areconsidered to be identical. Therefo
2012-12-14 17:10:32 513
翻译 Composite Indexes【每日一译】--20121210
A composite index (also called a concatenated index) is an index that you create onmultiple columns in a table. Columns in a composite index can appear in any orderand need not be adjacent in the
2012-12-14 09:16:21 461
翻译 Overview of Indexes【每日一译】--20121209
Indexes are optional structures associated with tables and clusters. You can createindexes on one or more columns of a table to speed SQL statement execution on thattable. Just as the index in thi
2012-12-12 17:20:35 356
翻译 Overview of Synonyms【每日一译】--20121208
A synonym is an alias for any table, view, materialized view, sequence, procedure,function, package, type, Java class schema object, user-defined object type, or anothersynonym. Because a synonym
2012-12-12 08:48:21 410
翻译 Overview of the Sequence Generator【每日一译】--20121207
The sequence generator provides a sequential series of numbers. The sequencegenerator is especially useful in multiuser environments for generating uniquesequential numbers without the overhead of
2012-12-11 14:50:18 544
原创 子池share pool的空闲空间内存查询
from:DBA手记select subpool, name, sum(bytes), round(sum(bytes) / 1048576, 2) mbfrom (select 'shared pool(' ||decode(to_char(ksmdsidx), '0', '0-unused', ksmdsidx) || '):' subpool,ksmssnam name,
2012-12-10 11:36:30 853
翻译 Overview of Dimensions【每日一译】--20121206
A dimension defines hierarchical (parent/child) relationships between pairs ofcolumns or column sets. Each value at the child level is associated with one and onlyone value at the parent level. A
2012-12-10 09:54:42 420
翻译 The Listener (concept)【每日一译】--20121205
When an instance starts, a listener process establishes a communication pathway toOracle. When a user process makes a connection request, the listener determineswhether it should use a shared serv
2012-12-07 10:16:44 427
翻译 materialized view Define Constraints on Views【每日一译】--20121204
Data warehousing applications recognize multidimensional data in the Oracledatabase by identifying Referential Integrity (RI) constraints in the relational schema.RI constraints represent primary
2012-12-07 09:28:33 396
翻译 Overview of Materialized Views【每日一译】--20121203
Materialized views are schema objects that can be used to summarize, compute,replicate, and distribute data. They are suitable in various computing environmentssuch as data warehousing, decision s
2012-12-06 09:13:46 441
翻译 Updatable Join Views【每日一译】--20121202
A join view is defined as a view that has more than one table or view in its FROMclause (a join) and that does not use any of these clauses: DISTINCT, aggregation,GROUP BY, START WITH, CONNECT BY,
2012-12-05 16:04:21 551
翻译 Parallel Access to External Tables【每日一译】--20121201
After the metadata for an external table is created, you can query the external datadirectly and in parallel, using SQL. As a result, the external table acts as a view, whichlets you run any SQL q
2012-12-05 14:20:09 377
翻译 EXTERNAL TABLE The Access Driver【每日一译】--20121130
When you create an external table, you specify its type. Each type of external table hasits own access driver that provides access parameters unique to that type of externaltable. The access drive
2012-12-04 15:32:04 441
翻译 External Tables【每日一译】--20121129
External tables access data in external sources as if it were in a table in the database.You can connect to the database and create metadata for the external table using DDL.The DDL for an externa
2012-12-04 15:06:54 343
翻译 temporary tables Segment Allocation【每日一译】--20121128
Temporary tables use temporary segments. Unlike permanent tables, temporary tablesand their indexes do not automatically allocate a segment when they are created.Instead, segments are allocated wh
2012-12-04 09:03:49 361
翻译 Temporary Tables 【每日一译】--20121227
In addition to permanent tables, Oracle can create temporary tables to hold session-private data that exists only for the duration of a transaction or session.The CREATE GLOBAL TEMPORARY TA
2012-12-03 21:53:07 457
翻译 Nulls Indicate Absence of Value【每日一译】--20121126
A null is the absence of a value in a column of a row. Nulls indicate missing,unknown, or inapplicable data. A null should not be used to imply any other value,such as zero. A column allows nulls
2012-12-01 21:11:58 469
翻译 Using Table Compression【每日一译】--20121125
Compression occurs while data is being bulk inserted or bulk loaded. These operationsinclude:压缩在数据在整批插入或者导入时发生。这些操作包括:■ Direct path SQL*Loader■ CREATE TABLE and AS SELECT statements■ Paral
2012-12-01 20:33:03 361
KFC系列之 - Oracle DBA入门Mysql(下)
2017-12-11
精通Oracle.10g.Pl.SQL编程
2009-03-15
经典linux sed与awk(第二版)
2009-03-13
linux与unix shell 编程(下)
2009-03-04
linux与unix shell编程(上)
2009-03-03
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人