This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. Goodness knows I do – a few weeks ago I had to analyse 2,304 of them in one (long) day. But for anyone (more...)
Delphix 4.1 just came out last week. It may sound only like a point release but there is an amazing amount of new technology:
- AWS: Amazon Web Services / EC2 Support
- Oracle 12c: Pluggable Database Support
- Windows: Application Data Virtualization
- Developers: Jetstream
- Sybase: and SAP ASE Support
I’m most excited about Amazon AWS support, Oracle 12c PDB support and developer jet pack , aka Jetstream. More coming on these features in upcoming blogs.
Seems like it’s going to be a week of new releases only. Last night only, I downloaded and installed Oracle database 12c patchset(12102) and today, Oracle Linux’s latest release OL7 is released. The download is available from E-Delivery portal and mine is going on. I don’t think it would take long before 12c would be certified for Oracle Linux 7 but I would do the installation of both, database and Linux, as soon as my (more...)
I’m going to kick this post off by taking sides in a long-standing feud.
Apple is amazing.
There. Edgy, right? Okay, so maybe you don’t agree with me, but you have to admit that a whole lot of people do. Why is that?Sure, there’s the snarky few that believe Apple products are successful due to an (more...)
1. Advanced Index Compression
Advanced Index Compression works well on all supported indexes, including those indexes that are not good candidates for the existing prefix compression feature; including indexes with no, or few, duplicate values in the leading columns of the index.
Advanced Index Compression improves the compression ratios significantly while still providing efficient access to the index.
2. Approximate Count Distinct
The new and optimized SQL function, APPROX_COUNT_DISTINCT(), provides approximate count distinct aggregation. Processing (more...)
I did a quick check of some facts I’m studying about Oracle 12c and its new threaded execution mode. I set this parameter:
alter system set THREADED_EXECUTION=true scope=spfile;
I had to connect SYS as SYSDBA with a password to get the system to bounce.
Then it had these processes only:
oracle 1854 1 0 09:17 ? 00:00:00 ora_pmon_orcl oracle 1856 1 0 09:17 ? 00:00:00 ora_psp0_orcl oracle 1858 1 2 09:17 ? 00:00:00 ora_vktm_orcl (more...)
Today I noticed strange thing in predicate section of execution plan for simple query with regexp_like, where was not specified 3rd parameter “MODIFIER”:
SQL> select * from dual where regexp_like(dummy,'.'); D - X SQL> select * from table(dbms_xplan.display_cursor); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------- SQL_ID 97xuqf9cmjsta, child number 0 ------------------------------------- select * from dual where regexp_like(dummy,'.') Plan hash value: 272002086 -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | (more...)
Recently I’ve noticed the occasional thread in Oracle newsgroups and lists asking about hugepages support in Linux, including ‘best practices’ for hugepages configuration. This information is out on that ‘world-wide web’ in various places; I’d rather put a lot of that information in this article to provide an easier way to get to it. I’ll cover what hugepages are, what they do, what they can’t do and how best to allocate them for your particular (more...)
Just checked Tim’s latest post and guess what, Oracle database 12c’s latest release, 188.8.131.52 is available now for download. It is available as an OTN download as well as from E-Delivery. Seems like that there is no documentation update available yet as the New Features guide still doesn’t have 184.108.40.206 included in it. But I am sure that it’s coming soon!
So grab your copy now and happy downloads :=).
Oracle 220.127.116.11 Patch 17694377 for Linux and Solaris has been released on Metalink and edelivery a few minutes ago. Happy upgrading!
The post Oracle Database 12c Release 1 [18.104.22.168] Patch Released appeared first on VitalSoftTech.
Replicating data can be a time consuming process to setup. Fortunately, Oracle GoldenGate provide a few tools to help ease the complexity of setup. One of these tools is the “macro”. Macros are used to simplify and automate the work associated with setting up and replicating data. So what exactly is a macro? Oracle defines a macro as:
A macro is a built-in automation tool that enables you to call a stored set of processing (more...)
Want to advance your career ?
We’ve seen DBAs become managers, managers become directors, directors become VPs and CIOs go from lesser known companies to some of the best known in the world. Why did they get promoted? Because they brought in Delphix.
Delphix increases the speed, the agility of IT often enabling development teams to go twice as fast, an increase that is unprecedented.
Companies that have this advantage will outperform the competitors.
How do you (more...)
Recently, I’ve been doing some work with a client where tokens need to be used. It came to my attention that the basic usage of tokens is misunderstood. Let’s see if I can clear this up a bit for people reading.
I had an interesting discussion as part of my latest presentation at the UKOUG RAC CIA & Database Combined SIG. Part of my talk was about the implications of the new threaded execution model in Oracle.
Since “we do not use Windows” (except for gaming) I can’t compare the Windows thread model to the new 12c implementation on UNIX. There are however interesting implications when switching to the new model, some of which I’d like (more...)