This blog post offers proof that you will trigger In-Memory Column Store feature usage with the default INMEMORY_* parameter settings.
What Really Matters?
This is a post about enabling versus using the Oracle Database 12c Release 184.108.40.206 In-Memory Column Store feature which is a part of the separately licensed Database In-Memory Option of 12c. While reading this please be mindful that in this situation all that really matters is what (more...)
Tony Kender, Senior Vice President, leads Oracle’s sales
operations for HCM solutions in North America, including an organization
dedicated to the unique needs of midsize companies.
Q: What is the (more...)
In the Star ETL process there are 2 main types of updates. There is the current data (dimensions and facts) and there is the historical data (_hd, hf, history) - see
The current data is overwritten every ETL update. This will keep your data as up to date as the last ETL. If you worked on a project, deleted a project, updated tasks, deleted tasks, scheduled (more...)
There seems to me to be a relatively simple choice.
Either you except that the Oracle Optimizer has a wealth of complicated strategies and, in this complex effort to get the best executions it can, will inevitably either get it wrong sometimes (or take some extra executions to realise it’s wrong).
Or you stick your head in the sand and raise a bug for every unexpected poor execution or plan flip.
But let’s say that (more...)
Some time ago I had some blog posts introducing some of the basic Statistical function available in Oracle. Here are the links to these.
- Enterprise Manager 12c (EM) installed and agents rolled out to database servers
- Access to EM offered to development teams with the primary purpose of allowing them to investigate application related database performance issues
The EM documentation covers a selection of privileges you might want to grant to users in database targets in order to allow them to be used for accessing EM functionality. The privileges mentioned are:
- SELECT ANY DICTIONARY
- CREATE SESSION
- EXECUTE on (more...)
I’ve popped this note to the top of the stack because I’ve added an index to Randolf Geist’s series on parallel execution skew, and included a reference his recent update to the XPLAN_ASH utility.
This is the directory for a short series I wrote discussing how to interpret parallel execution plans in newer versions of Oracle.
This is a very quick post, because I’m about to log off and take an extended summer holiday (or vacation as my crazy American friends call it… but then they call football “soccer” too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week’s 12.1.o.2 patchset.
Currently a Linux-only feature, the ASM Filter Driver (or AFD) is a replacement for ASMLib (more...)
At last, the long-awaited release of Oracle Database 220.127.116.11 has arrived, including the highly anticipated In-Memory Database Option. I have had the pleasure of being involved in the early beta stages of this feature and I have say: I'm impressed. This is truly game changing technology, and has been extremely well designed and implemented by […]
It is well known thing and you can even find it on MOS, but I have a little more simple script for it, so I want to show little example.
First of all we need to start script on local database:
Enter filters(empty for any)...
Globalid mask :
INST_ID SID SERIAL# USERNAME REMOTE_DB REMOTE_DBID TRANS_ID DIRECTION GLOBALID EVENT
-------- ---- (more...)
The Puppet ORAWLS module has many ensurable WebLogic puppet types and is fast cause of the new WLST domain daemon. Get it here.
WebLogic Partner Community
For regular information become a member in the WebLogic Partner Community please visit: http://www.oracle.com/partners/goto/wls-emea ( OPN account required). If you need support with your account please contact the Oracle Partner Business Center.
Blog Twitter LinkedIn Mix Forum Wiki
Putting the Cart Before the Horse
In my years of experience I’ve had the opportunity to engage
so many different customers that I’ve lost count. In my professional life I have
spent maybe 9 or 10 years total as a contractor. If you assume that I have
engaged one new customer every 4 weeks as a contractor (which seems somewhat
accurate in my head), then that would (more...)
I have a couple scripts for plans comparing:
But they have dependencies on other scripts, so I decided to create a standalone script for more convenient use without the need to download other scripts and to set up the sql*plus environment.
I’ve tested it already with firefox, so you can try it now: http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active_standalone.sql
SQL> @plans_active (more...)
...with the long awaited In-Memory option, plus 21 new features. Oracle Database 12c Release 18.104.22.168 supports Linux and Oracle Solaris (SPARC and x86 64 bit).
Get the download here.
And for those of us who just LOVE *sparknotes, here's a quick index of those new features with quick links from good friends and scribes in the Oracle Doc group. But first, a cool picture.
Sea Dragon photo taken at (more...)
For the last several months Gartner Group has been in contact with PeopleSoft customers using the PeopleSoft Update Manager (PUM). This new capability gives customers a high degree of flexibility to selectively apply new features, patches, and legal/regulatory updates. To understand how customers are utilizing this new capability you can read the full report from Gartner Group here:
PeopleSoft Update Manager Delivers Significant Improvements to Upgrade Tools and Processes
For more information on the PeopleSoft (more...)
Today I was asked about strange problem: xmltable does not return data, if xquery specified by bind variable and xml data has xmlnamespaces:
SQL> var x_path varchar2(100);
SQL> var x_xml varchar2(4000);
SQL> col x format a100;
3 :x_xml :=q'[
4 <table xmlns="http://www.w3.org/tr/html4/">
PL/SQL procedure successfully completed.
2 i, x
3 from (more...)
Oracle E-Business Suite Plug-in 22.214.171.124.0 is now available for use with Oracle Enterprise Manager 12c. Oracle E-Business Suite Plug-in 126.96.36.199 is part of Oracle Enterprise Manager 12 Application Management Suite for Oracle E-Business Suite.
This latest plug-in extends EM 12c Cloud Control with E-Business Suite specific system management capabilities and features enhanced change management support.
The Oracle Enterprise Manager 12c Application Management Suite for Oracle E-Business Suite (more...)