Posts Categorized: Pythian

How Filtered Indexes Look Like (Part 2)

In the first part of this series on Filtered Indexes, I talked about how SQL Server navigates through the index structure and used a clustered index as an example to demonstrate how the process works. To continue this series, we’ll look at filtered indexes and how they look like from a storage perspective. If you look at…

Training from a MySQL DBA’s Perspective

I’ve been pondering the next step in my training path; what do I want to learn or improve upon? You see, here at Pythian we’re encouraged to be the masters of our own progress. If you’re ever lucky enough to be on my side of the Pythian fence, you will see that there are provisions…

Exchange Server 2010 with Oracle Workflow Mailer

Almost all Oracle E-Business Suite DBAs will run into this problem if they are using exchange server as their Workflow IMAP server. Workflow is a important component of Oracle E-Business Suite, and its mailer component adds a biggest oracle EBS feature of inbound mail processing of workflow approval and rejection email replies from end users….

Amazon Elastic Load Balancer with Oracle E-Business Suite

This blog post outlines a couple of issues we faced in our Oracle E-Business consulting group when configuring Amazon Elastic Load Balancer with Oracle E-Business Suite 11i. The current IT industry trend is to virtualize all servers, and Oracle E-Business Suite servers are no exception. Among current cloud operators, Amazon Cloud infrastructure is a favorite…

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

Just like the new car model excites the car enthusiasts, the new version of the database products fascinates the database professionals. A plethora of blog posts sprung up as the new versions of databases are released. Oracle, SQL Server, and MySQL now have new things to offer. This Log Buffer shares that excitement and anticipation.

Why Upgrade to Oracle 12c

Oracle 12c: Making the Impossible, Possible?

Pythian’s Oracle team has had the opportunity over this last year to explore, test, and assess every aspect of Oracle’s latest database release. Oracle 12c, and we have to say, it’s very impressive. See our top 5 reasons to upgrade and share your reasons.

Do You Know If Your Database Is Slow?

The time to respond There was a question at Pythian a while ago on how to monitor Oracle database instance performance and alert if there is significant degradation. That got me thinking, while there are different approaches that different DBAs would take to interactively measure current instance performance, here we would need something simple. It…

Update on Home Learning Lab – Hyper-V

This is an update on my “Setting up a home learning lab” post. I have recently decided to upgrade the host OS on my desktop to Windows 8 Professional so I could check out Hyper-V as a virtualization platform and get to know Windows 8 better. Windows Server 2012 would have been my first choice,…

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

Close your eyes and imagine an affordable holiday featuring islands, pools, simmering white sandy beaches, and clubs. Chances are that you’re thinking about a resort in Hawaii, Fiji or French Polynesia. Now picture such a trip right now. I’ll give you a second. Still wondering? Yep, it’s this edition of Log buffer. :)

Managing Oracle on Windows: Where’s my Oratab?

If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use. On Unix or Linux, this is a very simple task.  Oracle services and their ORACLE_HOMEs are listed in the oratab file, located in /etc/ on most platforms…

Page 29 of 207« First...1020...2728293031...405060...Last »