-
Subtle changes in XML, 11g vs 12c
An AskTOM reader brought this to our attention. It is unlikely to cause you any issues, but perhaps is good to know when it comes times to upgrade from 11g to 12c. If you are taking an user defined object type and transposing that to XML, you will see a slightly different handling of NULLs… Read more
-
Dealing with IP addresses
Kris Rice made mention on Twitter about the free (but limited lifetime) IP address to Country mappings that you can get from Maxmind. If you ever need to deal with IP addresses, you might find the following utility package I wrote a while back useful. It lets you convert from the string representation of an… Read more
-
Brand new year ? Brand new to installing Oracle ?
If you’ve stumbled across this blog trying to get started with a local installation of Oracle database for some personal development, then firstly, welcome! Secondly, it can be a little daunting to get up to speed, so here’s a little video that will walk though the process of download, installing and getting up and running… Read more
-
Clone a table
Sometimes doing a CREATE TABLE AS SELECT is all we need to copy the data from an existing table. But what if we want more than that ? What if we really want to clone that table to match the original as closely as possible. We had a question along these lines on AskTOM today. … Read more
-
Licensed for Advanced Compression? Don’t forget the network
We often think of Advanced Compression being exclusively about compressing data “at rest”, ie, on some sort of storage device. And don’t get me wrong, if we consider just that part of Advanced Compression, that still covers a myriad of opportunities that could yield benefits for your databases and database applications: Heat maps Automatic Data… Read more
-
It’s not about ego … it’s about knowledge
Take a quick look at this blog post by Jonathan Lewis https://jonathanlewis.wordpress.com/2017/12/30/nvarchar2/ Anyone that has been working with Oracle for any length of time probably knows that Jonathan has a great depth of knowledge in the Oracle database, and is a regular blogger. But this post is a good example to inspire anyone that is… Read more
-
2017–what grabbed your attention
Here are the blog posts that you hit on most this year. Thanks for supporting the blog, and always, there will be more content next year ! ORA-14758: Last partition … cannot be dropped EXCHANGE PARTITION those pesky columns Pluggable database and restricted sessions Active and Inactive Sessions 12c install on Windows Problematic SQL ?… Read more
-
Seasons greetings from the AskTOM team
This year we’ve answered over 2800 of your questions and followed up on 3500 reviews. It’s been a great and busy year! We’ll see you all in 2018 Read more
-
iASH–my “infinite ASH” routine
I love Active Session History (ASH) data because a lot of the work I’ve done in my consulting life was “after the fact” diagnosis. By this I mean that many of us have been in a similar circumstance where the customer will contact you not when a problem is occurring, but only when you contact… Read more
-
LOBs from afar
This has always been a nuisance. There you are – getting all the bells and whistles with LOBs…until a database link enters the room — — Database: DB11 — SQL> create table t ( id int, c clob ); Table created. SQL> insert into t values (1,rpad(‘x’,32000,’x’)); 1 row created. SQL> select * 2 from… Read more
-
Buffer cache hit ratio–blast from the past
I was perusing some old content during a hard drive “spring clean” the other day, and I found an old gem from way back in 2001. A time when the database community were trying to dispel the myth that all database performance issues could be tracked back to, and solved via, the database buffer cache… Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 