You may have previously seen a short post I did on a SQL statement to identify which statements are using dynamic sampling.
If not, quick recap:
SELECT p.sql_id, t.val FROM v$sql_plan p , xmltable('for $i in /other_xml/info where $i/@type eq "dynamic_sampling" return $i' passing xmltype(p.other_xml) columns attr (more...)
When the wind of change blows, some build walls, others build windmills
It seems that Nikon is squarely in the wall-building camp. Original batteries for all kinds of stuff are expensive, leading to a thriving market in compatible third-party batteries. But since a modern camera is more computer than camera, (more...)
drop table t_no_compress;
drop table t_basic_compress;
drop table t_oltp_compress;
create table t_no_compress
select rownum id
, 10 col1
, lpad('*', (more...)
2 cnt number;
5 #desc (more...)
1) Computation while rendering the page.
Negligence: Failure to take the care that a responsible person usually takes : lack of normal care or attention
A worrying number of organizations run outdated, unsupported software.
There might have been a time when you could install software and leave it running unchanged for decades. But your IT infrastructure (more...)
A compound trigger curiousity I found recently:
begin forall triggers in compound.first .. compound.last insert into only_fire_once ( for_the_statement ) values ( compound(triggers) ); forall triggers in compound.first .. compound.last update firing set trigger_execution = 'once per array entry' where we_equal_the = compound(triggers); end;
For some reason, (more...)
If you are working with JDeveloper 12c (12.1.2), you will probably have experienced quite a few crashes – I had several during my the live demos in my presentations at the UKOUG Tech 2013 conference in Manchester this week.
A few things that help:
- Increase memory (google “JDeveloper (more...)
Although Oracle Forms is a “mature” technology it’s still getting additional new features with every new version. Since most developers have not done any Oracle forms training since the early 90s I thought I’d do a webinar with ODTUG to get everyone caught up on the new features available now (more...)
Time to get back into blogging. I stopped a while ago and the reason was two-fold. As I was leaving my job at Kentor AB I wanted to avoid any concerns with what I wrote while my three month long two week notice played out. The other reason was that (more...)
This Monday, scandal-ridden Royal Bank of Scotland (RBS) was in the news again. Their computer systems crashed, taking with them the balance on thousands of debit cards. This left irate customers unable to pay for anything with their RBS cards on “Cyber Monday,” which was expected to be a major (more...)