The following is a list of changes I noted during installation of Oracle Linux 7. I imagine the same will apply to Red Hat Enterprise Linux 7, but I haven’t verified that to be the case.
Setting the Hostname
I was accustomed to updating /etc/sysconfig/network with the hostname of my machine as documented here for Oracle Linux 7. I did this and was then surprised to find that my hostname was not picked up. On returning (more...)
(Otherwise known as #E42014 to the Twitterati. Note to the casual reader ... like a lot of conference posts, this is more personal diary entry than having any tech content whatsoever. You have been warned.)
Yes, so this post is hopelessly late, but I really have been busy this time!
Although I feel like I've done quite a few presentations over the past year, a lot of them have been at client sites and the (more...)
Oracle 18.104.22.168 is out, after lots of announcements the product has finally been released. I had just extended my 22.214.171.124.3 cluster to 3 nodes and was about to apply the July PSU when I saw the news. So why not try and upgrade to the brand new thing?
What struck me at first was the list of new features … Oracle’s patching strategy has really changed over time. I (more...)
There is more and more happening in the world of visualization and visualizing Oracle performance specifically with v$active_session_history.
Of these visualizations, the one pushing the envelope the most is Marcin Przepiorowski. Marcin is responsible for writing S-ASH , ie Simulated ASH versions 2.1,2.2 and 2.3. See
Here are some examples of what I have seen happening out there in the web with these visualizations grouped by (more...)
focused on the intersection of software and hardware. It's great community with Software and Hardware. Audiences will be able to learn new idea to combine software and hardware. It gathered idea from engineers, researchers, roboticists, artists, founders of startups, and innovators.
Oreilly launched HD videos (Solid Conference San Francisco 2014: Complete Video Compilation Experience the revolution at the intersection of hardware and software—and imagine the future
) for this conference. Video files (more...)
So how to turn it the option off/disabled…As a privileged database user: > Just don’t set the INMEMORY_SIZE parameter to a non zero value…(the default...
There is a serious problem with export/import utilities between versions.
The first command, executed on Oracle 126.96.36.199, Linux x86_64 was:
[oracle@oradb tmp]$ expdp system directory=tmp dumpfile=oe.dmp schemas=oe
Directory tmp was created as /tmp
Result was the following:
Export: Release 188.8.131.52.0 – Production on Mon Jul 28 22:57:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
Connected to: Oracle Database 11g (more...)
My biggest complaint about earlier versions of OEM came from the poor integration of BI Publisher with Enterprise Manager. The Information Publisher said boldly that I/P will be discontinued in favor of BI Publisher. That sounded pretty serious so I made the effort to install it.
The installation was difficult, the canned reports were mostly worthless, and the OEM and BI Publisher security models were completely separate. BI Publisher used the WebLogic security model and (more...)
I came up with a simple query that shows a running SQL executing a different plan than what it had in the past. Here is the query:
-- show currently executing sqls that have history
-- but who have never run with the current plan
-- joins v$session to v$sql to get plan_hash_value of
-- executing sql.
-- queries dba_hist_sqlstat for previously used values
-- of plan_hash_value.
-- only reports queries that have an (more...)
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...)
Performance Metrics are easier to digest if visualized trough some Line Charts. OEM, eDB360, eAdam and other tools use them. If you already have a SQL Statement that provides the Performance Metrics you care about, and just need to generate a Line Chart for them, you can easily create a CSV file and open it with MS-Excel. But if you want to build an HTML Report out of your SQL, that is a bit (more...)
There was a problem at a customer in application development where using full copies for developers and QA was causing excessive storage usage and they wanted to reduce costs , so they decided to use subsets of the production development and QA
- Data growing, storage costs too high, decided to roll out subsetting
- App teams and IT Ops teams had to coordinate and manage the complexity of the shift to subsets in dev/test
- Scripts had (more...)
Four Options For Oracle DBA Tuning Training
Oracle DBAs are constantly solving problems... mysteries. That requires a constant knowledge increase. I received more personal emails from my Oracle DBA Training Options Are Changing posting than ever before. Many of these were from frustrated, angry, and "stuck" DBAs. But in some way, almost all asked the question, "What should I do?"
In response to the "What should I do?" question, I came up with (more...)
As a remote data infrastructure services provider, documenting the activities we perform, as well as our customers’ environments, is critical to our success. RDX currently supports thousands (and thousands) of database ecosystems ranging in complexity from simple to “making your hair stand on end.”
My customers hold my organization to extremely high standards. Rightfully so, they have turned over the keys to their most sensitive and mission-critical data stores to RDX. At the end (more...)
- 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...)
Enkitec’s Oracle AWR Data Mining Tool
EAdam is a free tool that extracts from an Oracle database a subset of data and metadata with the objective to perform some data mining using a separate staging Oracle database. The data extracted is relevant to Performance Evaluations (PE) and/or to Sizing and Provisioning (SP) projects. Most of the data eAdam extracts is licensed by Oracle under the Diagnostics Pack, and some under the Tuning Pack. Therefore, in (more...)
Enkitec’s Oracle Database 360-degree View
EDB360 is a free tool that executes on an Oracle database and produces a compressed file which includes a large set of small Reports. This set of Reports provides a 360-degree view of an Oracle Database. EDB360 is mostly used for one of the following 3 reasons, listed here in order of frequency of use: 1) Keystone of an Oracle database Health-Check. 2) Kick-off for an Oracle database Performance Evaluation. 3) High-level (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.
So 220.127.116.11 is out with a number of interesting new features, of which the most noisily touted is the “in-memory columnar storage” feature. As ever the key to making best use of a feature is to have an intuitive grasp of what it gives you, and it’s often the case that a good analogy helps you reach that level of understanding; so here’s the first thought I had about the feature during one (more...)