Padraig O'Sullivan
![Subscribe to Padraig O'Sullivan feed](http://www.orafaq.com/misc/feed.png)
Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.comBlogger21125
Updated: 9 hours 42 min ago
Blogging at posulliv.com Now
I've decided to start blogging with WordPress now as it just makes putting code samples and things like that so much easier! Also, I had a domain name for a while so I figured I might as well use it and it will encourage me to blog more. I really want to blog more at the moment since I'm working on an interesting project for my database course this semester.You can find my blog here from now on. Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Drizzle: A Pretty Cool Project
Drizzle is a pretty cool project whose progress I've started following in the last few weeks. I'm trying to contribute in a tiny way if I can by confirming bug reports. If I had more time, I'd like to try resolving some bugs. Hopefully, I'll find some spare time to do that in the future.I think its definitely a project worth keeping an eye on though. Check it out if you have the time.Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
A Subtle Bug
At university, I work in a research group where we are developing an application in C++ that runs on both Linux and Windows. Since I do most of my development on Linux, I rarely test our application on Windows (other people in the group who run Windows test on that platform). Recently, one of my colleagues was encountering a problem while running our application on Windows that I was not Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
What is Direct Data Placement
I'm currently studying Oracle's white paper on Exadata and came across the following paragraph:"Further, Orace's interconnect protocol uses direct data placement (DMA - direct memory access) to ensure very low CPU overhead by directly moving data from the wire to database buffers with no extra data copies being made."This got me wondering what direct data placement is. First off, the interconnectPadraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com1
Semester Project Finally Finished
We just finished our semester project yesterday for the class I am taking on High Performance Computing. It was a pretty interesting project based on the topic of software fault injection.More details can be found in the project report here.Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Its Been a While
I had removed this blog but kept getting some emails asking for links to certain posts so I just posted some old posts again so that they are available to anyone who is interested in them.As an update for what I'm doing, I'm currently in my second year of graduate school. I plan on taking a grad class in database systems next semester so that should be interesting. I'll get to learn a lot about Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Configuring Oracle as a Service in SMF
In Solaris 10, Sun introduced the Service Management Facility (SMF) to simplify management of system services. It is a component of the so called Predictive Self Healing technology available in Solaris 10. The other component is the Fault Management Architecture.In this post, I will demonstrate how to configure an Oracle database and listener as services managed by SMF. This entails that Oracle Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com2
Building a Modified cp Binary on Solaris 10
I thought I would write a post on how I setup my Solaris 10 system to build an improved version of the stock cp(1) utility that comes with Solaris 10 in case anyone arrives here from Kevin Closson's blog. If you are looking for more background information on why I am performing this modification, have a look at this post by Kevin Closson.GNU Core UtilitiesWe need to download the source code for Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
srvctl Error in Solaris 10 RAC Environment
If you install a RAC environment on Solaris 10 and set kernel parameters using resource control projects (which is the recommended method in Solaris 10), then you will likely encounter issues when trying to start the cluster database or an individual instance using the srvctl utility. As an example, this is likely what you will encounter:$ srvctl start instance -d orclrac -i orclrac2PRKP-1001 : Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Oracle 10gR2 RAC with Solaris 10 and NFS
Recently, I setup a 2 node RAC environment for testing using Solaris 10 and NFS. This environment consisted of 2 RAC nodes running Solaris 10 and a Solaris 10 server which served as my NFS filer.I thought it might prove useful to create a post on how this is achieved as I found it to be a relatively quick way to setup a cheap test RAC environment. Obviously, this setup is not supported by Oracle Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com1
Creating a UFS File System on an External Hard Drive with Solaris 10
Recently, I wanted to create a UFS file system on a Maxtor OneTouch II external hard drive I have. I wanted to use the external hard drive for storing some large files and I was going to use the drive exclusively with one of my Solaris systems. Now, I didn't find much information on the web about how to perform this with Solaris (maybe I wasn't searching very well or something) so I thought I Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Observing Oracle I/O Access Patterns with DTrace
In this post, I will use the seeks.d and iopattern DTrace scripts, which are available as part of the DTraceToolKit (This toolkit is an extremely useful collection of scripts created by Brendan Gregg), to view the I/O access patterns typical of Oracle. DTrace is able to capture data throughout the kernel and so the job of finding access patterns has been greatly simplified.The system on which Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Playing with Swingbench
Swingbench is a free load generator (and benchmarks generator) designed by Dominic Giles to stress test an Oracle database. In this post, I will be playing with Swingbench and showing how it can be used. This article will focus on comparing the performance of buffered I/O versus un-buffered I/O (i.e. direct I/O) using the Swingbench tool. Since this article is not about direct I/O (I encourage Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Generating a System State Dump on HP-UX with gdb
I have previously used the gdb (GNU Debugger) to generate oracle system state dumps on Linux systems by attaching to an Oracle process. The ability to do this has been well documented by Oracle on Metalink (Note 121779.1) and in other locations.The problem with this is that it does not work on the HP-UX platform. I found this out at the wrong time when trying to generate a system state dump Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Installing & Configuring a USB NIC on Solaris
In this post, I will provide a very quick overview of how to install and configure a USB network interface on Solaris.Obtaining the USB DriverThe driver for a generic USB network interface which should cover the majority of USB NIC devices can be downloaded from here.Installing the USB DriverAfter downloading the driver, uncompress the gunzipped file and extract the archive as the root user. # Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Temporary Tablespace Groups
Temporary tablespace groups are a new feature introduced in Oracle10g. A temporary tablespace group is a list of tablespaces and is implicitly created when the first temporary tablespace is created. Its members can only be temporary tablespaces.You can specify a tablespace group name wherever a tablespace name would appear when you assign a default temporary tablespace for the database or a Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
OCFS2 Mount by Label Support
While messing around with OCFS2 on my RHEL4 install, I discovered that if I created an OCFS2 filesystem with a label, I was unable to mount it by that label. I would encounter the following:# mount -L "oradata" /ocfs2mount: no such partition found#I found this quite strange and did some investigation. The version of util-linux that was present on my system after a fresh RHEL 4 install was - Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
Installing a Back Door in Oracle 9i
In this post, we will demonstrate a way an attacker could install a back door in a 9i Oracle database. The information on this post is based on information obtained from Pete Finnigin's website and the 2600 magazine. The version of the database we are using in this post is:sys@ORA9R2> select * from v$version;BANNER----------------------------------------------------------------Oracle9i EnterprisePadraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com2
White Paper at Oracle OpenWorld
A white paper that I was part of writing is being presented at Oracle OpenWorld this week. The paper is entitled 'High Availability Options for the Oracle Database'. It is being presented by Dan Norris and I wrote the sections on Export/Import and data pump. The paper is available for download from the IT Convergence website here.Dan is kinda like my mentor here at IT Convergence. He has a lot ofPadraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0
First Paper Accepted
I just found out that my first paper has been accepted! Its a pretty nice feeling. This paper was based on research I did in the summer of 2005 with the MISL research group in UCC.A pre-print version of the paper is available here. It was accepted to a conference called First International Workshop on Practical Issues in Building Sensor Network Applications.Now I'm hoping my paper on small-world Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0