For some time now, I’ve been creating blog posts that walk you through using some of the Enterprise Manager technology to perform specific tasks. For example, there’s one here on setting up Chargeback in EM 18.104.22.168. I’ve never been really satisfied with the way these blog posts turn out, as to document a step by step process like this takes lots of screenshots and you end up with a post that’s a (more...)
UltraEdit v22.0 has been released. You can see the new features here. For such a mature editor, it’s surprising when something new comes out that makes you take a step back. I think they’ve done just that in this release. The document map shows a miniaturized version of the page, making scrolling through large files really simple.
I’m not sure if this is an idea they kicked from another browser, but this is the (more...)
I was planning to cover this subject in a single article, but it got a bit bulky, so I split it down into 6 little articles.
- Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1
- Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1
- Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1
- Interval-Reference Partitioning in Oracle Database 12c Release 1
- Cascade Functionality for TRUNCATE PARTITION and EXCHANGE (more...)
Real-life scenario describing troubleshooting of instance startup problems and actions needed to solve them.
Wednesday April 15 at Collaborate 2015 Las Vegas room Mandalay K
For more information see Pythian’s Blog post.
What is Oaktable World ? Oaktable World is a day organized by members of the Oaktable network. The Oaktable network is a network of Oracle database tuning geeks. Among the members are Tanel Poder, Jonathan Lewis, Cary Millsap etc. Oaktable network was created by Mogens Nørgaard back in 2001 or so and Mogens started (more...)
In my previous article I started exploring the memory usage of a process on a recent linux kernel (2.6.39-400.243.1 (UEK2)), recent means “recent for the Enterprise Linux distributions” in this context, linux kernel developers would point out that the kernel itself is at version 3.19 (“stable version” at the time of writing of this blogpost).
The previous article showed that every process has its own address space, and that different (more...)
There are 5 parameters that are all prefixed with ‘sec’ in an 11g and 12c database. Actually that is a lie because one is now deprecated in 12c. They are all, as you might guess related to security. This blog is about changes in the default values and some thoughts about whether or not the default value is appropriate or not.
|SEC_CASE_SENSITIVE_LOGON||TRUE in 11GR1 , 11GR2, DEPRECATED IN 12C|
|SEC_MAX_FAILED_LOGIN_ATTEMPTS||default 11GR1,11GR2=10, 12c=3|
LPAR stands for Logical Partitioning and it's a feature of IBM's operating system AIX (Also available in Linux). By abstracting all the physical devices in a system, LPAR creates a virtualized computing environment.
In a server; the processor, memory, and storage are divided into multiple sets. Each set in a server consist of resources like processor, memory and storage. Each set is called as LPAR.
One server can have many LPARs operating (more...)
Everyone gets caught out some of the time with NOT IN.
This came up in a (fairly typical) question on OTN recently where someone had the task of “deleting 6M rows from a table of 18M”. A common, and perfectly reasonable, suggestion for dealing with a delete on this scale is to consider creating a replacement table holding the data you do want rather than deleting the (more...)
I don’t travel as frequently as some people do, but with OpenWorld and various Oracle conferences each year, I definitely see my fair share of the inside of a plane and a hotel room. To pass the time on flights, I try to read, but when you’re reading on a work-based trip, it’s a case of reading a page or two here and there, rather than a true extended session of relaxed reading.
I watched Interstellar last night at a mates house.
Where to start with this film?
- Visually it is fantastic. Lots of epic scenes. Definitely great eye candy.
- The story is pretty basic. I won’t give anything away but there’s nothing new here.
- According to all the stuff on the net, it is scientifically on point.
What’s my gut feel?
- Way too long. Lots of “setting the scene” and comparatively much less of the stuff you really want (more...)
This blogpost is about finding the actual amount of memory a process is taking. In order to do so, this post dives into the memory mechanisms of Linux. The examples in this article are taken from an Oracle Linux version 6.6 server, with kernel 2.6.39-400.243.1 (UEK2). This is written with the Oracle database processes in mind, but actually uses examples of a processes running ‘cat’, which means the contents of (more...)
In April 2008 (wow, does time fly!) I used the following picture in my "11g features for Developers" presentation at the Australian Oracle User Group conference.
I think the picture is from the movie "Indiana Jones and the Last Crusade"… where they sought the Holy Grail.
I used the picture because I said that Edition Based Redefinition (EBR) was the Holy Grail of 24/7 Oracle based applications. (Like most Oracle presentations at the (more...)