Guess what? OakTable World at IOUG C15 is happening. Last year, we’ve had awesome sessions and wonderful attendees. It was so successful that we have now a bigger room this year (there were other reasons too but hey — we can fit more people now!).
What: OakTable World C15
When: Wednesday, 15-Apr-2015, 8:00am – 5:30pm
Where: Mandalay Ballroom K
I really hope if you are reading this, you would be in Vegas between 12th (more...)
This sounds like a simple request doesn’t it?
Simple if there are no roles which are granted DBA role and allow me to show what can go wrong.
Create ROLE “secret”, Grant DBA to “secret”, Grant “secret” to USER “michael”
ARROW:(SYS@hawklas):PRIMARY> create role secret;
ARROW:(SYS@hawklas):PRIMARY> grant dba to secret;
ARROW:(SYS@hawklas):PRIMARY> grant secret to michael identified by michael;
When a simple SQL is used, “secret” is a ROLE NOT USER.
I saw the following error in a job which had just recreated the control file of a test database after cloning:
SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 3
2 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 (more...)
What is SQLcl ? SQLcl is a new command line interface like SQL*PLUS coming along with SQL Developper 4.1 Early Adopter. It is lightweight tool (only 11MB) developed by the SQL Developer team fully compatible with Windows and Unix/Linux. You don’t need to install it so it is totally portable. The tool does need any Oracle … Continue reading SQLcl, a revolution for SQL*Plus users
The post SQLcl, a revolution for SQL*Plus users appeared first (more...)
In physics, one important limitation of any experiment is the fact that an act of observation inevitably interferes with the observed process (“observer effect”). Same thing is true about databases. It is a well known fact that, for example, turning on tracing can significantly slow down the process for which it’s enabled. But there exist even nastier forms of this effect: for example, when you try to trace a SQL statement using nested loop batching mechanism, (more...)
“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in March 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… 2-Mar #oratidbit You can perform […]
Like many other Oracle professionals and speakers I will be attending IOUG Collaborate 2015 this year in Las Vegas. I’m not a big fan of Las Vegas, but hey cannot turn down an opportunity to speak, especially when IOUG asked me to do more than one session.
This year my schedule is going to keep me busy; yet full of good topics that cover both EM12c and GoldenGate. If you are going to be (more...)
I started using sar -d to look at disk performance on a Linux system this week and had to look up what some of the returned numbers meant. I’ve used sar -d on HP Unix but the format is different.
Here is an edited output from a Linux VM that we are copying files to:
$ sar -d 30 1
Linux 2.6.32-504.3.3.el6.x86_64 (myhostname) 04/01/2015 _x86_64_ (4 CPU)
05:26:55 PM (more...)
Oracle Corporation has released a slew of new features that allow Oracle Database implementations to catch up to, match up to, and leave in the dust NoSQL implementations in the areas of performance, scalability, and reliability (PSR).(read more
Version 3.0.1 of Mumbai is available for download. Here’s the list of changes:
- Breaking change: Any custom command that you set up on the toolbar will be gone.
- Breaking change: If you use a master password to encrypt connection passwords, you will loose all your stored passwords with this release. To prevent this, run your current version first and remove the master password, before updating to this version.
- There is now a 32 (more...)
It used to be that if you had an enhancement suggestion for Oracle Database, you had to file an enhancement request in MOS and pray that the Oracle product management gods would hear your request someday. It is now possible to make your enhancement request in a public forum and let the community vote on your idea.(read more
P.O.I.S.E.D. is the acronym I invented for the performance tuning method described by Chris Lawson in The Art and Science of Oracle Performance Tuning; it stands for Problem, Observation, Interpretation, Solution, Execution, and Documentation. The Observation and Interpretation phases feed each other. The Interpretation phase concludes with a determination of root cause. If we are investigating poor performance a single SQL statement, the tool of choice for the observation phase (more...)
If you are a resident of California, you can become a member of the San Jose Public Library and gain access to Safari Books Online and Books24x7. At last count, there were 445 Oracle titles available through Safari Books Online(read more
As you may know, Weblogic is a part of Enterprise Manager Cloud Control environment, and it’s automatically installed and configured by the EM installer. The Enterprise Manager asks you to enter a username and password for Weblogic administration. This information is stored in secure files, and you usually do not need them unless you need to use Weblogic console. So it’s easy to forgot these username and password, and that’s what happened to me. Fortunately (more...)
Every release of edb360 includes some “new goodies”. Latest version v1510 reduces the number of execution parameters from 2 to just 1. It also incorporates a new configuration file which is mostly static, but it can be user-modified for special cases. And new sections below are all now part of edb360. Enjoy!
Last year I promised myself I would do more conferences & presenting and that it would include more events further afield, such as in Europe. I can’t say I managed it in 2014 (Liverpool for the UKOUG Tech14 did not count as a foreign country for me, even if I found a couple of the locals hard to understand) but 2015 is proving more successful. I attended the OUG Ireland conference 2 weeks ago, for (more...)
In zwei Wochen findet das Expertenseminar "Parallel Execution Masterclass"
in Berlin statt, das ich gemeinsam mit der DOAG
Es sind noch ein paar Plätze frei - sollten Sie also Lust und Zeit haben, nach Berlin zu kommen und exklusives Wissen (nicht nur) über das Parallel Execution Feature der Oracle Datenbank zu erfahren, würde ich mich sehr freuen, Sie dort mit den anderen Teilnehmern begrüßen zu dürfen, um gemeinsam mit Ihnen eine gute und produktive (more...)