Tag: Oracle

Log Buffer #115: A Carnival of the Vanities for DBAs

Welcome to the 115th edition of Log Buffer, the weekly review of database blogs.

Read More >

GNU basename in PL/SQL

In the process of scripting a database migration, I was in need of something akin to the GNU basename utility that I know and love on Linux. basename is most famous for taking a full file path string and stripping away the leading path component, returning just the name of the file. This can be emulated in PL/SQL with calls to SUBSTR and INSTR, like this…

Read More >

How to Tie OS-level PIDs to Oracle Database Sessions

About once a week, our team gets a request from the server admins to provide some information on why a database server is running slowly. This typically begins a painstaking process of finding the main processes on the OS side and tracing them back to database sessions. Attached to this post (see bottom for link) is a general diagram that the team came up with for relating our tables together, taking RAC into consideration.

Read More >

So, You Want to be an Oracle ACE? Oracle OpenWorld 2008 Presentation

Next week, Dan Norris and I will collaborate on a presentation at Oracle Openworld 2008. Our presentation, entitled So, You Want to be an Oracle ACE?, will be on Monday, 9/22, from 11:30 am – 12:30 pm in Moscone South, room 310 — that’s the very first conference slot. We’ve already put together our presentation, with input from many Oracle ACEs and Oracle ACE directors, complete with some great video clips. I’m excited and honored to be presenting with Dan. The official description of our presentation is…

Read More >

Log Buffer #114: A Carnival of the Vanities for DBAs

This is the 114th edition of Log Buffer, the weekly review of database blogs.

Read More >

Oracle RAC SIG Web Seminar — RAC Connection Management

Oracle RAC SIG web cast presented by your humble servant. Don’t miss it today! You can register on the RAC SIG web-site. This is a longer than usual session (90 minutes) packed with details of connection failover, load balancing and implementation details.

Read More >

Log Buffer #113: A Carnival of the Vanities for DBAs

his is the 113th edition of Log Buffer, the weekly review of database blogs.

Read More >

Sheeri’s Sordid Past

I confess — I have not always been an exclusive MySQL user. I have fooled around with other DBMSs. I was young, inexperienced, and I needed the money, I swear!

Read More >

How to Find Objects Creating nologging Changes

In an Oracle-l thread, this question was raised: how can you find objects creating nologging changes?

Read More >

Ubiquity and Tahiti: Together At Last!

You can load the command in your Ubiquity-enabled browser by visiting this page. Ubiquity users should already see the notice at the top of the page to subscribe to this command. You can view the source code at the end of this post.

Read More >
Page 96 of 141« First Page...10...9495969798...110...Last Page »