louis vuitton mens belt louis vuitton mens belt louis vuitton wallpaper Established in 1854 Louis vuitton bags have regularly experienced fashion thus one rather demanded of accessories. It is a fact that you have to spend a lot to be described as a proud owner of these bags, but nonetheless every penny you spend is […]
In case you were wondering, I’m very fond of male fashion. I love to see a well-dressed man, but of course I love shoes, to find out love to see a man in 2 nice shoes or running shoes. One way of getting in touch with substantial end fashion and to get access to elevated […]
To make upgrades easier, I regularly see people considering disabling query optimizer features by setting the OPTIMIZER_FEATURES_ENABLE initialization parameter to a non-default value. My general opinion about this “habit” is summarized in TOP with the following two sentences:
Changing the default value of the OPTIMIZER_FEATURES_ENABLE initialization parameter is only a short-term workaround. Sooner or later the application should be adapted (optimized) for the new database version.
The issue is that not all new features are (more...)
We use LDAP users to install oracle software. In my humble opinion, it’s not a good approach because if the server can not communicate with LDAP service, Oracle gets errors when spawning new processes. We have already started to switch our oracle users from LDAP authentication to local users, but this is not the subject of this blog post. Using LDAP for authentication, also affects Enterprise Manager agents. When I try to create a named (more...)
Yesterday, I posted a trace file that seemed odd to me Twitter. This resulted in a very lively discussion, and several very interesting theories were put forward. Even though the issue hasn’t been solved yet, I would like to post a summary of this discussion (plus my findings) so that more people would be able to give their inputs. Also, some of the theories put forward to explain the observed anomaly are very interesting on (more...)
Ever get tired of typing commands? Ever wish there was a way to recall commands from GGSCI? Well, you are in luck! There are two ways this can be done (listed below).
2. ! (command)
The first option, History, is a command that allows you to view a list of the most recent commands executed in the GGSCI interface since the session started.
GGSCI Command History
This is a reposting of an old blog post that was on dboptimizer.com but is no longer accessible
More trace file analyzer tools at http://ba6.us/node/177
Related blog post: Oracle “Physical I/O” ? not always physical
Often when I have a 10046 trace file, especially when looking at I/O issues, I want a histogram of I/O response time. To get I/O response time I’ve hacked out incomple awk scripts from time to time, (more...)
I recently did an Introduction to Oracle presentation, describing how the oracle instance worked – technically, but from a very high level. In it I used the analogy of a restaurant, which I was quite happy with. I am now looking at converting that talk into a set of short articles and it struck me that the restaurant analogy is rather good!
Here is a slide from the talk:
The term “Service” is used to represent numerous objects within Enterprise Manager 12c. Although the most common reference to the term is related to the Oracle Management Service, (OMS), in this blog post, we are going to drill down and refer to all services identified in the drop down menu from Targets, Management Services and Repository.
The two main services we are going to cover here are set up as part of the Oracle Enterprise Manager 12.1.0. (more...)
Create an army of clone databases and applications in minutes
Tomorrow Jan 28 we will be installing Delphix on people’s laptops at the BIWA conference at Oracle conference center at Oracle head quarters in Redwood Shores.
- Laptop, either
- Mac: VMware Fusion or VirtualBox
- Linux: VMware Fusion or VirtualBox
- Windows: VMware Workstation or VirtualBox
- at least 8 GB RAM
- at least 50 GB free disk space, but preferably 100 GB free
- at least 2 Ghz CPU, (more...)
The Hitchhiker’s Guide to the EXPLAIN PLAN Part 32: Pretzels created by someone experimenting with hallucinogens?
There is no one-size-fits-all break-even point for indexed versus table scan access. If only a few rows are being accessed, the index will be preferred.
If almost all the rows are being accessed, the full table scan will be preferred. In between these two extremes, your “mileage” will vary.
A concatenated index is more useful if it also supports queries where not all columns are specified. For (more...)
Photo by Kevin Dooley
If you are in the Bay Area tomorrow, Jan 27, come see myself, Yann Ropars and Yury Velikanov talk about how to leverage social media to boost your career. We will be talking at Oracle head quarters at the NoCOUG/BIWA conference at 2:30 pm
Why use social media as an IT technician? Because
vibrant social networks are key to landing jobs, moving forward in your career, and securing personal happiness – (more...)
There are many ways to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it. In this session, several real-world examples will be reviewed to help you (more...)
Back in July 2013, Oracle released the latest version of its flagship database product, Oracle 12c. Among the usual fanfare was information about a number of new options – including one known as Multitenant. With the Multitenant option, databases use a new architecture which features a container database (or CDB) which in turn contains one or more pluggable databases (or PDBs). Use of Multitenant requires a licence – which at the time of writing retails at $17,500 (more...)
Yeah, it’s indeed true and official. So if you still haven’t started reading and learning Multitenant architecture introduced in 18.104.22.168 and enhanced in 22.214.171.124, it’s high time that you start doing it. Not because that it’s new but because the old architecture you are familiar with, it’s officially on the verge of extinction.
Oracle Midlands Event #8 is now confirmed and one of the speakers looks rather familiar!
Thanks again to Redgate for sponsoring the event, allowing it to remain free!
Put the date in your diary. See you there!
Oracle Midlands : Event #8 was first posted on January 26, 2015 at 3:06 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading (more...)