Blog: Database Support

My colleagues and I provide PeopleSoft technical support to several business areas.  In addition to project support, I look forward to answering emails and caller inquiries.  I rely on my technical experience and listening skills to decipher and solve business problems.   I try to confirm the underlying issue quickly and keep my communication in the user’s terms.  It’s motivating to help managers, DBAs, and users alike—remotely assisting from our support center in Walled Lake, Mi. Here are some recent samples of how I help each day beyond my ongoing duties. Rather than asking IT to write...

Read More

While recently working with one of my clients, a large college which has an Oracle RAC 11g on Linux setup, I noticed that certain PeopleSoft batch processes were slow compared to what I have observed at other client sites. I confirmed with the user that the slow performance, in fact, was impacting the end user. I began to research the issue by taking some database snapshots and I reviewed other statistics that confirmed that there were a large number of enqueue waits for TAO tables. While an enqueue is not RAC specific, it can involves a global lock operation when RAC is enabled. Most of the global...

Read More