If you want to be able to create contemporary high-performing PL/SQL code, welcome to my training event in NYC (hosted by NYOUG) on November 7, 2014:
I think, it is as important as ever to follow best practices for server-side development. There are lots of options that could get the job done "now", but very few that would survive for months/years. Also, there is a constant pressure from various "alternative" solutions to (more...)
As a huge friend of Oracles SQL trace I also see it's limitations as well. One of these limitations is visible in it's underlying infrastructure: the wait interface. It's only about waits
There is another source of information as well, you could call it the DO interface, but the common term is session and system statistics. there Oracle counts what it is doing.
Unfortunately I do not know a simple way to show both realities (more...)
So I've spent the days since Oracle OpenWorld 14 decompressing...puttering in the garden, BBQing for family, running errands. The idea was to give my mind time to process all the things I saw and heard at OOW this year. Big year - it was like trying to take a sip from a firehose. Developing any clarity around the avalanche of news has been tough.
If you average out all of Oracle's new product development, (more...)
Now after some research - I detected one simple rule for provoking In-Memory scans :
This is the first entry in a series of random articles about some useful internals-to-know of the awesome Oracle Database In-Memory column store. I intend to write about Oracle’s IM stuff that’s not already covered somewhere else and also about some general CPU topics (that are well covered elsewhere, but not always so well known in the Oracle DBA/developer world).
Before going into further details, you might want to review the Part 0 of this series and also our (more...)
Oracle OpenWorld 2014 is over. Just under a week, full to the brim with information, events, people, energy, plans, hopes and expectations. I have learned many, many things. Small things, important facts, huge insights and many great people. In this article, I will attempt to sum up the largest themes of the conference as I have interpreted them. In subsequent publications, I will focus on some of them as well as discuss less grand but (more...)
To extend an ACFS cluster filesystem dynamically, we need to use the acfsutil command:
node01:/u01/grid>/sbin/acfsutil size +10G /u02
acfsutil size: ACFS-03008: The volume could not be resized. The volume expansion limit has been reached.
acfsutil size: ACFS-03216: The ADVM compatibility attribute for the diskgroup was below the required
version (220.127.116.11.0) for unlimited volume expansions.
Oh dear, not 18.104.22.168, so you can only extend volumes dynamically a (more...)
Yes, direct path reads again :) No worries I’m already a bit bored from digging in this algorithm, so I think this is going to be my last post about it. Till they change it again of course. And yes, in 22.214.171.124 they did. For introduction to DPR, you can check my previous post, because […]
A big thanks to all those who braved attending my session on the final day of Oracle Open World 2014. I hope you enjoyed it and found it valuable.
You can download the slide deck as well as the scripts I mentioned here
As always, I would love to hear from you.
File this one under the misleading-errors department. One of my developers was working with a new queue. He pinged me when he got this error trying to create a job that used the queue:ERROR at line 1:ORA-27373: unknown or illegal event source queueORA-06512: at "SYS.DBMS_ISCHED", line 124ORA-06512: at "SYS.DBMS_SCHEDULER", line 314ORA-06512: at line 2
The CREATE_JOB statement was:BEGINDBMS_SCHEDULER.CREATE_JOB(job_name => 'foo.bar_q_job',job_type => 'PLSQL_BLOCK', (more...)
In a comment on my previous post on shrinking tablespaces Jason Bucata and Karsten Spang both reported problems with small objects that didn’t move to the start of the tablespace. This behaviour is inevitable with dictionary managed tablespaces (regardless of the size of the object), but I don’t think it’s likely to happen with locally managed tablespaces if they’ve been defined with uniform extent sizes. Jason’s comment made me realise, though, that I’d overlooked a feature of (more...)
HROUG,SIOUG and BGOUG. At HROUG and SIOUG I’ll be speaking for Exadata and at BGOUG, maybe for near zero downtime migration or some similar geeky topic ;) Links to the events: Have fun! Kovachev
This week I’ve been enjoying spending some time at Oracle Open World in San Francisco, CA. While here, I’ve been talking with everyone, friends old and new, and it came to my attention that it would be a good idea to have some useful templates for Oracle GoldenGate parameter files. With this in mind, I decided to create some generic templates with comments for Oracle GoldenGate processes. These templates can be found on my Scripts (more...)
Especially on this Monday it seems all about new database data intern ration technologies and support for more data formats. Now adding in 126.96.36.199 native...
It’s been about 8 months since I posted a little note about a “notable change in behaviour” of the optimizer when dealing with subqueries in the where clause that could be used to return a constant, e.g.:
where id between (select 10001 from dual)
and (select 90000 from dual)
There’s been a note at the start of the script ever since saying: Check if this is also true (more...)
A few months ago I wrote a blogpost about the Oracle Reference Architecture for Information Management. There is a new Oracle Big Data Information Management Reference Architecture online now. If you want to find out more about Oracle’s Big Data Information Management Reference Architecture please check the below links: Big Data Information Management Reference Architecture Oracle Information Management Architecture…Read more Oracle Big Data Information Management Reference Architecture