This post also applies to non-Exadata systems as hard drives work the same way in other storage arrays too – just the commands you would use for extracting the disk-level metrics would be different.
I just noticed that one of our Exadatas had a disk put into “predictive failure” mode (more...)
A recent question on the OTN database forum included an execution plan that prompted one reader to ask: “but where has the existence subquery gone?” Here’s the original question showing the query, and here’s the later response showing the plan that prompted the question.
There were three possible reasons (more...)
So there I was, one Thanksgiving I came across Randy Pausch’s Last Lecture and wanted to share with you.
This is a good blog post. I’ve come back to it multiple times to get perspective on my career and involvement in the Oracle community:
I like it because it encourages me to embrace my (more...)
In setting up some testing, I decided to install Oracle GoldenGate 12c (12.1.2) on a Windows 2008R2 server. After doing a few installs on Linux with Oracle GoldenGate 12c, I figured the OUI would be quick and painless on Windows; boy was I misled.
On the windows (more...)
Recently we noticed that imageinfo was displaying the following information at a customers site. Imageinfo was not displaying data i suspected, so a quick little blogpost about what was going on there.
[root@dm01db01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/dbs_group -l root "imageinfo | grep 'Image version'" dm01db01: Image version: 11.2. (more...)
Tanel does offer a zip file with all of his scripts. The zip seems up-to-date now; I started doing this alternative technique awhile ago when the zip file didn’t seem to get updated as quickly as the raw scripts directory.
mkdir tpt cd tpt wget -r -nH --cut-dirs=2 --no-parent --reject="index. (more...)
This post applies both to non-Exadata and Exadata systems.
Before Oracle 11.2 came out, it was true to say that Oracle Parallel Execution slaves always do direct path reads (bypassing buffer cache) when doing full segment scans. This should not be taken simplistically though. Even when you were doing (more...)
As the IT landscape evolves, it's becoming easier for decision-makers to implement innovative new solutions. Daily operations, for instance, are being streamlined with cloud services for increased efficiency and greater customization, and big data organizations are gaining a more intuitive list of digital strategies.
Cloud solutions for building reliable infrastructures
According to (more...)
As storage technologies advance, the cloud market is continuing to provide enterprises with additional customization options. Furthermore, for IT teams transitioning to a cloud-based infrastructure, providers are making it easier to leverage new strategies to perform information maintenance.
Are you a student of Baku State University ?
Do you want to know about Oracle Database ?
Do you want to listen presentations from the professionals ?
The event is free to attend, but just for Baku State University students.
I encourage people that I work with to put a small number like 8 as the parallel degree when they want to create tables or indexes to use parallel query. For example:
SQL> create table test parallel 8 as select * from dba_tables; Table created. SQL> SQL> select degree (more...)