Tag: Oracle

Oracle Free Block Corruption – Test Case

My very first blog post at Pythian – Trick or Treat? So there I was, faced with more that 4000 block corruptions as shown from v$database_block_corruption. The script  corrupt_seg.sql identified the corruption as Free Block Corruption (block not associated with any segments)….

Read More >

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

Every day is a new journey but the path remains the same. Bloggers are advancing on this path to reach new milestones. They sometimes pace high, sometime low, but whatever, they never miss to share what they learn along the…

Read More >

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful information to answer these questions. The data is there, but it not always easy to retrieve it, especially if…

Read More >

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

One key success factor in a great leadership is to gather great people around you. Bloggers are people, and this Log Buffer Edition enables you to gather them around you through their blog posts.

Read More >

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

Naysayer within us keep on erecting new obstacles, especially when it comes to the creativity. Our database bloggers are winning this fight within and producing gems of blogs. This Log Buffer edition celebrates their victory.

Read More >

UDM is watching you, UDMs

With time monitoring of several thousand targets of different versions and on different operating systems accumulates additional checks and user-defined metrics for specific requirements. With the presence of a dozen super administrator accounts, the Oracle Enterprise Manager environment demands specific…

Read More >

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

Extreme performance is the key to excellence. One example of it is the winning of 34th America Cup by Team Oracle USA, another example is the Pythian’s legendary love of  data, and this Log Buffer edition loves the blogs again,…

Read More >

Linux HugePages for Oracle on Amazon EC2

One of the optimizations available to us when running Oracle on Linux is huge page support. This feature of the Linux kernel enables processes to allocate memory pages of size 2M (instead of 4k). In addition, memory allocated using hugepages…

Read More >

Simple and Quick Way to Get SQL_ID of Query in Oracle

If you need to get SQL_ID of a query from a busy system, which has similar queries scattered all around, it becomes a hassle to get what you are looking for. If the query for which you are getting SQL_ID…

Read More >

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

Education is everything. Education can pull you out of poverty, it can propel you into upper echelons. Education can make you see what’s truly important in the life. Education can enable you to appreciate the people. Blogging is all about…

Read More >
Page 19 of 144« First Page...10...1718192021...30...Last Page »