With Oracle’s move towards engineered systems we all know that “more” is being done down at the storage layer and modern storage arrays have hundreds of spindles and massive caches. Does it really matter if data is kept in the Database Buffer Cache anymore?
Yes. Yes it does.
Time for a cool beer
With much larger data sets and the still-real issue of less disk spindles per GB of data, the Oracle database buffer cache (more...)
AWS EC2 API tools help too much for Amazon EC2 to register and launch instances, manipulate security groups, and more. Someone asked me to backup EC2 instance. I thought to use it for backup script. Anyway, No need to explain more how to install Amazon EC2 API tools on Ubuntu? Just say thank for EC2StartersGuide
. I fellow this link and installed it easily. Additional, I used this Link
for more idea about java.- Adding (more...)
I’ll prefix this post with a warning. I’ve never done any paid blogging myself, so this is based on emails I’ve received from people requesting me to write for them and from comments I’ve heard from others. With that in mind…
Apart from having adverts on your blog or selling books, there are other ways to earn money from writing. You will have to decide if they suit you.
Paid Articles. Some websites, blogs and magazines pay for (more...)
"It seems to me that almost everything is a waste of time."
- Norton Juster, The Phantom Tollbooth
Jonathan Lewis has coined a term and its definition that, I believe, we’ll be using quite a bit:
Stoptimisation - the art of optimisation by not doing the things you don't need to do.
It’s a term we’ve needed for some time now, given the pendulum swing back to the days of yore (meaning pre-9i) with (more...)
Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon.
However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c databases including legacy and container databases.
The following simple SQL and sqlplus techniques can be used to make a “universal (more...)
If you are interested in array-level data reduction services and how such technology mixes with Oracle Database application-level compression (such as Advanced Compression Option), I offer the link below to an EMC Lab Report on this very topic.
To read the entire Lab Report please click the following link: Click Here.
The following is an excerpt from the Lab Report:
EMC XtremIO storage array offers powerful data reduction features. In addition to (more...)
You’ve started a blog. This time next year you’re going to be a millionaire!
If you are interested in making money from a website you can. There are a number of advertising options, with the most popular for the small publishers being Google Adsense. Having said that, you’re going to get a rude awakening when you start earning 20 cents a day.
Advertisers care about reach, so advertising is a numbers game. If you want (more...)
In pre-12c database releases, VARCHAR2, NVARCHAR2 data types were limited to 4000 bytes and RAW data type was limited to 2000 bytes. If there is a need to store more data in VARCHAR2 column, you can in 12c after setting the parameter MAX_STRING_SIZE to EXTENDED. With setting MAX_STRING_SIZE to EXTENDED, you can store up to […]
As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details.
To demonstrate the new behaviour I have used an 126.96.36.199 BP 22 database on Exadata 11.2.3. (more...)
Having published recently two notes
about the Temp Table Transformation highlighting the heuristics based decision and other weaknesses, for example regarding the projection of columns, it's time to publish some more notes about it.The transformation can also have significant impact on cardinality estimates
, both join and single table cardinality.Looking at the difference in the join cardinality estimates of following simple example:
create table t1
rownum as id
, mod(rownum, 10) (more...)
I’m currently doing yet another pass through my whole website correcting broken external links. This is nothing to do with my bad management. This is to do with people changing their URLs and not putting the correct redirects in place. I’ve just done a scan of my website and there are over 800 broken links to Oracle documentation!
There seem to be several ways people deal with URL changes on their website.
I was trying to transport a large number of tablespace datafiles from one database to another, and impdp kept crashing with “PL/SQL: numeric or value error: character string buffer too small.”
It turns out there is a limit on what you can put on a single line in a parameter file. Hence if you have something like:
then you might run into trouble. It’s easily fixed however – just put the entries (more...)
Many times, while doing SQL tuning, we want to trace (event 10046) single SQL in database. Instead of going for module level tracing or session level using DBMS_MONITOR, we can simply use below alter system command to trace specific SQL
Example: I have a table T1 and index T_I_TABLE_NAME on that table.
I am running following SQL and I want to trace on this SQL
select * from T1 where table_name = 'SINGLE_PRODUCT_GROUPS';
Prior to 11g, whenever optimizer goes for full table scan, Oracle used to show “db file scattered read” as wait event. But starting from 11g, a full table scan can show (depending on certain conditions) “direct path read” wait event.
db file scattered read – happens when blocks for a table is read from datafile into buffer cache in SGA
direct path read – happens when blocks for a table is read from datafile into (more...)
I recently worked at a company that used "Product X" for all of it SQL and PL/SQL activities. There’s no real need to reveal what "Product X" is, because this isn’t a post about whether as a product it was good, bad or somewhere in between. "Product X" met the needs of the Oracle developers in the company, and that’s all that matters. There was just one issue – for Product X, (more...)