Oracle

5 Days Left – Vote for Pythian Sessions at Oracle OpenWorld 2011 on Oracle Mix

Summer’s here, and that means it’s time to start thinking about Oracle OpenWorld 2011. Pythian’s plans are well underway. We have been busily planning since March, have submitted a number of abstracts on all sorts of topics: Exadata, ASM, GoldenGate, ADR, ASM, many based on real world experiences with Pythian clients. Some have been accepted, but we’re hoping for a few more and we’re asking Pythian fans to vote for our sessions on Oracle Mix.

How to Confirm DIRECT IO is Getting Used on Solaris

I was working on a task where I had to confirm if the direct IO is in use or not. filesystem_io_option database parameter was set to “DIRECTIO” to make use of directio. Initially I was looking for same kind of memory structures in Solaris but could not find so ( bad luck :( ) and so used basic tracing using truss.First I logged into database and check the filesystem parameter ( Changed the name of the database and host :) )

Log Buffer #224, A Carnival of the Vanities for DBAs

There are many variates of mangoes and its hard to pick from them as they all are so sweet and eye catching. Same is the case with the database related blogs, when it comes to selection for the edition of Log Buffer. So once again here you are, about to savor the sweet blogs in Log Buffer #224.

Database Migration to ASM

I was working on a task of 10g Active-Passive cluster design where I was supposed to migrate a database to ASM from conventional filesystem. So I thought of writing this blog. Here are the steps which I followed to move the database to ASM and then created a spfile in ASM diskgroup in the end.

Using KateSQL to connect to an Oracle database in Kate

Among the features announced with the release of version 4.6 of the KDE Software Compilation is KateSQL, a SQL Query plugin for the Kate text editor. It leverages the Qt SQL module, enabling connections to most types of databases, and includes support for MySQL and SQLite. In this post I’ll show you how to get it to connect to Oracle databases.

Page 52 of 140« First Page...10...5051525354...60...Last Page »