Today while working on ASM diskgroup i noticed Negative value for USABLE_FILE_MB. I was little surprised as it has been pretty long that i worked on ASM. So i started looking around for blogs and mos docs and found few really nice one around. A negative value for USABLE_FILE_MB means that you do not have [&hellip
A couple of posts ago in this series, I explained how a NAND flash die is comprised of planes, which contain blocks, which contain pages… which contain individual cells of data. Read operations take place at the page level, as do write operations (although we call them program operations in the flash world). But crucially, erase operations take place at the block level and so affect multiple pages.
Erases are also (more...)
I just wanted to point you to the blog articles I've been posting over at Toad World in case you're wondering why there aren't many articles showing up here.
So, go take a look!Karen's Toad World Blog
Despite the title, this is actually a technical post about Oracle, disk I/O and Exadata & Oracle In-Memory Database Option performance. Read on :)
If a car dealer tells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically different from all the old ones. You don’t just get orders of magnitude (more...)
I started looking into In-Memory on RAC this week. Data can be distributed across RAC nodes in a couple of different ways. The default is to spread it across the available nodes in the cluster. So if you had a 2 node cluster, roughly 50% of the data in your table or partition would be loaded into the column store in each of the 2 instances.
SYS@dw1> alter table kso.skew inmemory;
Oracle Database is one of the leading relational database management system and is used all over the world. It has various training’s, exams and certifications for its Database and other products. However due to regular update in Database, they have to redesign their trainings, certification and exams to add new features and to remove old […]
The post Oracle Database 10g Certifications to Expire in March 01, 2015 appeared first on VitalSoftTech.
On the Maximum Availability Architecture website, there’s a paper on <awful term alert>Best Practices</awful term alert> for Database Consolidation. It’s a great paper, as you’d expect from the MAA guys (well, apart from that awful term alert I had to add! ). Since database consolidation is an area I work in a lot, I thought I’d start looking at implementing as much of their recommendations as I could in Enterprise Manager, which of course is (more...)
The Unix utilities ps and top report memory differently with HugePages than without.
Without HugePages ps seems to include the SGA memory under the SZ column:
UID PID PPID C SZ RSS PSR STIME TTY TIME CMD
oracle 1822 1 0 846155 16232 0 07:19 ? 00:00:00 ora_d000_orcl
oracle 1824 1 0 846155 16228 0 07:19 ? 00:00:00 ora_d001_orcl
oracle 1826 1 0 846155 16236 0 07:19 ? 00:00:00 ora_d002_orcl
oracle 1828 1 0 846155 (more...)
In a recent post on Oracle Certifications, Matthew Morris discussed the new DBA OCA to OCP Upgrade exams in his post on Release Jumping. His post is thorough in explaining the benefits of jumping from Oracle 9i, or 10g or 11g OCA to 12c OCP, or from 9i OCA or 10g OCA to 11g OCP in […]
It's fair to declare up front that the author of this book, Martin Bach, is one of my best friends in the Oracle community (even though I haven't known him for that long really) and someone who I truly respect for all sorts of reasons, both professionally and personally. One of the personality traits I think we share is that, if we thought something was truly awful, we might not call it out as (more...)
In the (good) old days there was only one optimizer and plans were developed based on the precedence of the rules. For some reason I have always thought there were 11 rules but looking at the manual it tells me there are 15 rules
Nowadays the vast majority of databases will be using the CBO and gathering statistics either by using the overnight maintenance functions or manually gathering as required. I suppose there is always (more...)
Top 7 Reasons Why Oracle Conferences Are A Waste Of Time
Want to turn a lame Oracle Database conference experience into a great one? You may not believe this, but I think Oracle conferences are a waste of time. That is, unless I take action.
I've been to hundreds of Oracle conferences, so I'm kind of an expert in this field.
Here is my "Top 7" list about why Oracle conferences are time suckers and (more...)
Join myself and Tim Gorman as we host a live webinar and Q&A September 18th at 10am PST with Jonathan Lewis. Jonathan will explain from his on experiences how Delphix works and what industry problems it solves.
Click here to register for our webinar.
Jonathan explains issues and obstacles to creating “thin clones” on typical industry hardware:
how point in time snapshots work
And from point in time snapshots, he explains how clones can rapidly be made.
This post looks like I am jumping on the bandwagon of IT orchestration like a lot of people are doing. Maybe I should say ‘except for (die hard) Oracle DBA’s’. Or maybe not, it up to you to decide.
Most people who are interested in IT in general will have noticed IT orchestration has gotten attention, especially in the form of Puppet and/or Chef. I _think_ IT orchestration has gotten important with the rise of (more...)
I’ve often found in my travels that I’ve come up with a (potential) solution to a problem and wanted to test it “right now” – only to run onto the horns of a dilemma. A typical client offers me one of two options:
- Option 1: test it on the production system – which is generally frowned on, and sometimes I can’t even get access to the production system anyway.
- Option 2: test it on something that looks (more...)
When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN. Without knowing the password for SYSMAN, how can I access the EM 12c interface? The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.
Before changing the SYSMAN password (more...)
In preparation for our upcoming 12c In-Memory Webcast @CaryMillsap, @TanelPoder, and I solicited questions from members of the universe at large on the interweb. We got a question about how In-Memory works with the 12c multi-tentant option and it got me thinking so I gave a quick try. As it turns out, it works about as you would expect. The basic idea is to turn it on for the container DB (which is where the (more...)