Seraph Consulting helped China Unicom Americas’ revamp their website. The new website completely reshaped China Unicom Americas’ publicity and received tremendous acceptance from the Headquarters in Beijing.
| Before | After |
 |
 |
» Read more: Seraph Consulting Revamped China Unicom Americas’ Website
Upon Oracle’s release of 11g and noticeably with 11g Release 2, Oracle’s functionality is pretty rock solid. What I considered the most obvious weaknesses of the Oracle database engine are now resolved. Namely, bind peaking is resolved with Adaptive Cursor Sharing, and plan stability issues are resolved with SQL Plan Management.
One weakness still remaining with 11g Release 2(11.2.0.1.0) is the 32 character limit in generating histograms for wide character columns. In a nutshell, if you have a column that is wider than 32 characters AND its values are longer than 32 characters, Oracle will only consider the first 32 characters in the column in generating histograms. » Read more: Oracle’s 32 Character Limit in Generating Histograms
dbms_stats.gather_fixed_objects_stats() fails on 11g Release 2(11.2.0.1.0). The bug is witnessed on Standard Edition databases, but should also apply to Enterprise Edition software, per my speculation.
Upon issuing the command, an error is returned:
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 12 16:49:23 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.1.0 – 64bit Production
SQL> exec dbms_stats.gather_fixed_objects_stats;
BEGIN dbms_stats.gather_fixed_objects_stats; END;
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00439: feature not enabled: Data Guard
Broker
ORA-06512: at “SYS.DBMS_STATS”, line 20508
ORA-06512: at “SYS.DBMS_STATS”, line 20951
ORA-06512: at “SYS.DBMS_STATS”, line 21498
ORA-06512: at line 1
These bugs are involved:
Bug 9180311: GETTING ORA-20011 AND ORA-439 EXECUTING GATHER_FIXED_OBJECTS_STATS
Bug 9056912: GATHERING STATISTICS ON EXTERNAL TABLES REQUIRES NULL FOR ESTIMATE_PERCENT
Patch 9056912 is available for our platform(x86-64). And once applied, the problem is fixed. Note that there are post installation tasks to be carried out.
With the advent of open source relational database platforms, many organizations must be looking at Oracle Enterprise Edition(EE) pricing as outrageous. Not to mention the drying up of budgets in this economy. You can’t do anything for the sunk cost of the existing EE licenses. However, even for new purchases, switching to an entirely different database platform can be impractical. Some companies make compromises and go with Standard Edition, or for single-node installations, Standard Edition ONE.
» Read more: How to live with the Standard Edition of Oracle
Oracle 11g Release 2(11.2.0.1.0) client for x86-64 has a new bug(9496209). I was able to reproduce the issue after about 2-3 days of repeated execution.
With a Java module that uses the thick client(OCI) to connect through JDBC and initializes a C3P0 connection pool, the module would intermittently crash. Here’s an example of how to reproduce the problem. Of course, you would need C3P0 libraries in your environment.
» Read more: Oracle 11g Release 2 client for x86-64 has a new bug(9496209)
As of Oracle 11g Release 2, the Automatic Memory Management(AMM) feature is not compatible with hugepages.
In a nutshell, Hugepages is a way to allow the operating system to reduce the amount of overhead operations needed to map between virtual memory addresses and physical memory addresses. With the default page size of 4KB for the x86 architecture, the amount of mapping operations can be overwhelming when there is a large amount of physical memory in use. With hugepages set, the amount of pages is dramatically reduced and hence the amount of mapping operations also reduced.
© 2013 Seraph Consulting · Proudly powered by WordPress & Green Park 2 by Cordobo.
Valid XHTML 1.0 Transitional | Valid CSS 3
