technology, because the table compression technology is an oracle feature that is more suitable for the data warehouse environment. That is, data is mainly used for query purposes and seldom involves DML operations.
Compression methods and features provided by oracle
Oracle improves the total compression mode by 4, which is applicable to different scenarios. They are:
Basic compression: high compression, the lowest CPU overhead, applicable to DDS.
OLTP compression: high compression, the lowest
: dbms_compression.get_compression_ratio('Usedtbs',new 11: dbms_compression.get_compression_ratio('USERS',Sampling table: DEXTER.ACCOUNTEstimated compression ratio: 1Compression Type: "Compress For OLTP" PL/SQL procedure successfully completed.
Because there are very few duplicate values in the table,In the previous article, Estimated compression ratio: 1, indicating that there is no compression effect.Advanced compression, based on intra-block compression. So even if there is a duplicate val
mode by 4, which is applicable to different scenarios. They are:
Basic compression: high compression, the lowest CPU overhead, applicable to DDS.
OLTP compression: high compression, the lowest CPU overhead, applicable to OLTP and DDS.
Note: compression can be specified at the tablespace level, table level, and partition level. If the tablespace has the compression attribute, the tables in the table also have the compression attribute by default, but the table-level compression attribute can ove
-making due to the non-real-time data extraction. Hana was born to solve this problem.
Based on the experience of Nongfu Spring, simply changing the database to Hana can improve the performance by hundreds or even thousands of times. Even if the data warehouse and analysis system are added on this basis, it may also improve the performance by 10 times. This is very helpful for the management to understand the operational status of the enterprise in a timely manner.
Of course, there are many adva
the data blocks are not stored in the row-major format, but instead use a combination of a row and cylinder (columnar) method
Hybrid types of columnar compression
Warehouse compression
Online Archival compression
These two classes also need to use direct path loads, ALTER TABLE ... Move action or online table redefinition
Hybrid Columnar compression optimizes data warehousing and decision support applications in
Edition and Oracle GoldenGate.
OracleData Integrator Enterprise Edition
Oracle Data Integrator Enterprise Edition is an important part of Oracle Data integration solutions. It provides the same kind of best batch Data mobile and conversion technology with a performance of 10 times higher than traditional ETL, it can efficiently move data between source and target across heterogeneous systems, improving performance while reducing the cost of data integration. And the fastest conversion speed in
Cost and performance of Oracle new-generation virtual computing All-in-One Machine
To promote hardware sales, a new generation of integrated systems, including Oracle virtual computing All-in-One OVCA, and other integrated devices, were launched after Oracle's core dual-slot server market.
At this point, Oracle first focuses on high-end and more professional integrated systems, such as Exadata and Exalytics, tim Shetler, vice president of Oracle
: = 2;
Comp_for_query_high CONSTANT Number: = 4;
Comp_for_query_low CONSTANT Number: = 8;
Comp_for_archive_high CONSTANT Number: =;
Comp_for_archive_low CONSTANT Number: = 32;
Query high Below is the content of HCC (Hybridcolumnar Compression) because it is associated with exadata storage nodes, so it is not available in a non-exadata integrated environ
the hype, with more and more it giants focusing on the technology of private cloud, IBM, Oracle, EMC, Microsoft and so on have all been exerting and speeding up the "enclosure" in the private cloud domain, this article is concerned about the Oracle private cloud.
Oracle in the field of cloud computing is painstaking, has spent the purchase of a number of well-known enterprises. Advanced Middleware (WEBLOGIC) technology has been acquired through BEA to gain advanced Server and storage technolog
Http://www.idevelopment.info/6. This site has a lot of information, enough for you to see the http://community.dbapool.com/index.php 7. The veteran foreign Technical website HTTP://WWW.IXORA.COM.AU/8. Foreign Daniel, ACE Director, can be seen Bo master very profound HTTP://WWW.ORACLE-BASE.COM/9. This guy is also studying Oracle for many years, there are a lot of paper very good, worth sharing http://gavinsoorma.com/10. Julian Dyke's blog, there are several books written well http://www.juliandy
View, there was an exhibition that once software was tied to hardware, software was not an industry at the time, and IBM released programs that ran only on IBM hardware. Software not only charges, at the software level there is no competition.
What we now know about the software industry is actually after the decoupling of hardware and software, the US enforcing anti-trust legislation for proprietary software and hardware vendors. Hana, as an application and database coupling, is controlled
. For example, if the data of a table changes very frequently, we can lock up its statistics (using Dbms_stats. Lock_table_stats, for Oracle 10g and above, will no longer take the time to collect statistics, but the premise here is that locked statistics can get the SQL accessing the table out of the ideal execution plan.In short, how to correctly collect statistical information is a complex topic, there are many points of knowledge to pay attention to, but the principle of only one: tailor-made
operating system. This certification expertise is only for Oracle Linux distributions, which are specifically tailored for Oracle products and can run Oracle-designed systems, including Oracle Exadata database servers, Oracle Exalytics in-memory Servers, Oracle Exalogic equalization Cloud, Oracle database applications, and more. Oracle Linux's "Indestructible Enterprise core" brings high performance, scalability, and stability to enterprise applicati
Oracle patch is also an Oracle patch. Oracle patches also contain several kinds, small patches are simply difficult to count, it is inevitable to dazzle people. However, Oracle patch is still in order. And Oracle's Opatch tools are handy for installing Oracle patch and viewing the patch that the current system has installed. This article lists several types of patch and describes the patch application of the current database through the Opatch tool. Refer to the official Oracle documentation for
memory, Dbim nearly 800 times times faster, a single core processing 3 billion rows of data every 1/6 seconds, unbelievable?!SimdThe previous technology used in high-performance computing and image processing, that is, single instruction multiple data, is actually a batch processing of the information, except that it is well suited for column-based data.Storage IndexStorage index In fact in the exadata, in fact, is the column partition for IMCU, pre-
transaction, with OLTP characteristics
Logical Read
Number of units per block, equivalent to "people * times", such as the 196,888 * db_block_size=1538mb/s, logical reading CPU, the main frequency and CPU core is very important, logical reading high DB CPU is often high, you can often see the Latch:cache buff ER chains wait. A large number of OLTP systems (such as Siebel) can be as high as dozens of or hundreds of gbytes.
Block changes
Number of units per block,
large business. redo approximately 1mbnbsp per second, per transaction 800 byte, OLTP characteristics logicalread Unit number of blocks * , equivalent to "people * times", The above example 196,888*db_block_size=1538mb/s, logic read CPU, the main frequency and CPU core is very important, logical reading high dbcpu often high, also can often see latch:cachebuffer Chains wait. a large number of OLTP systems (such as Siebel) can be as high as dozens of or hundreds of gbytes. blockchanges Unit
data synthesis analysis and processing environment. Of course, it needs to use a relational database system that supports MPP technology to mask the complexity of load balancing and scheduling between nodes. In addition, this parallel processing ability also has a great relationship with the node internetwork. Obviously, the MPP server, which adapts to the data Warehouse environment, should be very prominent in the I/O performance of the node internetwork in order to realize the performance of
block reaches a value.When a transaction causes the data in the block to reach its value, the contents of all blocks are compressed. Then, more data is added to the block, once again reaching the value, the entire block will be re-compressed to achieve the maximum level of compression. This process repeats until the Oracle database determines that no more benefits can be gained from compression. Only certain transactions that trigger the compression condition experience a slight compression ove
Tags: blog http using strong data OSHttp://blog.sina.com.cn/s/blog_7ca5799101013dtb.htmlAt present, although big data and database all are very hot, but quite a few people can not understand the essential difference between the two. Here's a comparison between big data technologies (such as Hadoop, primarily MapReduce and NoSQL) and database integration (the next generation of mainstream relational databases):Hardware architectureIn essence, the hardware architecture of the two is basically the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.