VirtualBox 3.2.22 arrived yesterday, and here was me thinking it was dead.
The downloads and changelog are in the usual places.
was first posted on February 13, 2015 at 1:57 pm.
©2012 "The ORACLE-BASE Blog
". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
I had a manager a few years ago, a lady. She was good at her job, knew the tech and we got on well. And she would take the piss out of me constantly about my height. One day, another member of the team suddenly said “Hey! Leave him alone! He might actually be sensitive about it and it’s wrong you should be bullying him like this”. My boss replied “Oh come on, he’s not (more...)
I recently saw the following command in a script that was to be run and thought an error had been made and the power level should have been 5 not 500.
ALTER DISKGROUP DATA REBALANCE POWER 500;
Upon doing some research it was not a mistype but a new method of disk balancing which came in from 184.108.40.206
Previously setting the power limit from 0 to 11 basically caused an additional number (more...)
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we looked at setting up Data Guard standbys in Enterprise Manager 12c.
Let us look into the Administration of Database Users in Enterprise Manager, and specifically the changes for Database 12c.
Selecting Administration..Security..Users from the 12c Database Target menu of Enterprise Manager, this is now Database 12c aware, and allows you to (more...)
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we looked at provisioning 12c Pluggable Databases (PDBs) in a Container Database (CDB) using Enterprise Manager.
As many DBAs are coming to realize, Oracle RMAN backups can be easily set up and scheduled for multiple Oracle databases in Enterprise Manager, it’s all about saving time and effort. Well, now the RMAN wizards in (more...)
I encountered this during some testing – the optimizer can be a little overzealous when it encounters nested group-by’s
SQL> create table T ( ts number not null, c char(10));
SQL> insert into T
2 select 100+dbms_random.value(1,50),'x'
3 from ( select 1 from dual connect by level < 1000 ),
4 ( select 1 from dual connect by level < 1000 )
998001 rows created.
It’s easy to make mistakes, or overlook defects, when constructing parallel queries – especially if you’re a developer who hasn’t been given the right tools to make it easy to test your code. Here’s a little trap I came across recently that’s probably documented somewhere, which could be spotted easily if you had access to the OEM SQL Monitoring screen, but would be very easy to miss if you didn’t check the execution plan very carefully. (more...)
A very interesting question was posted in one of the forums I participate in:
is there any way how I can revoke the right from a normal user to change it's own password in the database?
This, obviously, sparked a fairly lively thread (which I will not re-post here) regarding security and the underlying reason such a request was made. The user who posted the original question continued in the thread to explain:
Of course (more...)
Heute wurde auf "informatik-aktuell.de" ein aktueller Artikel von mir veröffentlicht. Es geht darin um die Analyse eines Falles bei einem meiner Kunden, der auf Exadata nicht die erwartete Performance erreicht hat.
In dem Artikel werden unterschiedliche Abfrage-Profile analysiert und erklärt, wie diese unterschiedlichen Profile die speziellen Features von Exadata und In-Memory beeinflussen.Teil 1 des ArtikelsTeil 2 des Artikels
I am very proud to be able to announce a free workshop on Friday the…
I need to renew my Oracle Support contract. Everyone on the intertubes tells me Oracle are a money grabbing evil empire right? So it follows that they are going to be really on the case with a support renewal right?
Two days ago I wrote an email to customer services to try to renew my support contract. Since then I’ve been bounced between 5 people and I’ve still not managed to pay any money. It surely can’t (more...)
When we’re trying to send mail to localdomain through mailx from linux box. It says “Diagnostic-Code: SMTP; 550 host unknown” and mail not sent.
# “Smart” relay host (may be null)
restart the sendmail service and send the mail is successful
10.x.x.xx — mailbox server
Here’s where I’ll hang out in the following months:
11-12 Feb 2015: IOUG Exadata SIG Virtual Conference (free online event)
- Presentation: Exadata Performance: Latest Improvements and Less Known Features
- It’s a free online event, so sign up here
18-19 Feb 2015: RMOUG Training Days (in Denver)
- I won’t speak there this year, but plan to hang out on Wednesday evening and drink beer
- More info here
1-5 March 2015: Hotsos Symposium 2015
As you know, NaN is a “Not a Number”.
How do you think, what would be the result of the following query? (0f/0 == NaN)
select count(*) cnt from dual where rownum < 0f/0;
Ok, when you know the result, try to guess what will return this query:
select count(*) cnt (more...)
Sometimes you need to see the difference between two pieces of console output. When I research, this can be two stacktraces, but also /proc//maps and smaps output; really anything. Of course, there’s diff, but the diff output is not very visual. Also, diff doesn’t do diffing between more than two files.
This can be done reasonably simple in vim. Here’s how to do that:
1. start vi; vi
2. do a vertical split using a (more...)