Tag: Oracle

The Internal Workflow of an E-Business Suite Concurrent Manager Process

This is the first article in a series about performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!

Read More >

Oracle Trace Files in User Directories

How to resolve unusual situation where Oracle was writing trace files into the user directory instead of the usual oracle diagnostic destinations.

Read More >

How to Tune Using v$mystat

When reviewing the performance of some queries, it is sometimes useful to review the sessions statistics for each execution of the query. I had a situation that required to look at these stats so I could see why one query would run fast and sometimes much slower. I wrote a simple wrapper ksh shell script for the query. It saves the session statistics in a table before and after the execution of the query and then prints out the statistics in a pivot report. This turned out to be very handy to me and therefore I chose to share it with the world :)

Read More >

Virtual IOUG Collaborate 13 for Only $299

For only $299 you can access Virtual IOUG Collaborate 13 individually or setup a conference room at your company for the whole team. There will be two tracks broadcasted so if you have demand for both tracks, it make sense to purchase two access passes and setup two tracks broadcasted in parallel in your office so that members of your team can choose individually what to attend.

Read More >

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

With real possibilities and opportunities, blogging is getting mature day by day, and so is the technology and its innovations. The combination of both becomes a dazzling medley, which is called as Log Buffer. Enjoy this week’s stunning Log Buffer #311.

Read More >

Why is Oracle Ignoring My Memory Parameters?

When you set sizes for areas of the SGA (e.g. large_pool_size or java_pool_size) you might often see Oracle has used different and sometimes much larger values, this post explains some of the reasons why this might happen.

Read More >

A (Oracle) Pirate Looks At: Extending OEM 12c with Oracle Application Management Pack for E-Business Suite

Mother, mother Oracle. I have heard you call… Wanted to sail upon your cloud (control) since 7.3.4… You’ve seen it all, you’ve seen it all… (Paraphrased from Jimmy Buffett’s, “A Pirate Looks at 40”) For a while now, Oracle Enterprise…

Read More >

Register to IOUG COLLABORATE 13 and Get an Hour of My Time

Spring is a very active conference season for me. I might be going to half a dozen conferences in 3-4 months. That’s a lot of travel but I look forward to all them. The conference I’m probably looking forward the most this year is IOUG Collaborate.

Read More >

Are You Paying Too Much for Database Support?

Oracle MS SQL Server VersionsOracle MS SQL Server Versions

Notwithstanding all the new shiny features the latest database release can provide; in this post I am going to put in dollars and cents the reasons why upgrading your database makes economical sense.

Read More >

Be Careful When Revoking UNLIMITED TABLESPACE

In this post I go through some tips and advice when revoking UNLIMITED TABLESPACE in Oracle, and look at how to form the experts.

Read More >
Page 27 of 144« First Page...10...2526272829...40...Last Page »