Posts Categorized: Pythian

Sleuthing for Temporary Space Spendthrifts

I was recently looking at an issue where a large database server was running out of temp space. The issue had happened in the past, so the goal was to identify what had been causing the system to run out of temp. Although ORA-1555 messages will appear in the database alert log (with query text) when a query runs out of temporary space, they only talk about the query that was “unlucky” enough to be attempting to get space when the tablespace was full, not who was using the temp space.

MERRY CHRISTMAS from Pythian’s EBS Teams, Oracle Style ;-)

Pythian’s friendly Oracle e-Business Suite DBAs would like to congratulate all of our friends, clients, Pythian colleagues, prospects, new team members whom we haven’t yet met (join us!), all database geeks, and blog readers for successfully completing 2012! Have a very peaceful Christmas and the happiest year ever in 2013! May all of your pagers be quiet, and your year-end maintenance be incident-free! ;) Here comes our Christmas card to you :)

Changing SID on a RAC Environment

Just a short note documenting a procedure that isn’t done frequently, and I didn’t see described anywhere else. Somewhere last month a customer asked for my help in changing the SIDs on one of his RAC databases to match the new corporate standard. The database name matched the standard so we could leave that alone, but the SID needed to be changed. Here’s what we did to change it

Still a Lot of Database Offerings…

The CORE database audience has been well served at this year’s version of the UKOUG forum. Many of the shows we attend concentrate on the late-breaking components of the vendors’ new offerings. The attendees are hungry for this information and having it delivered in a 4-5 day package is very helpful.

Page 39 of 206« First...102030...3738394041...506070...Last »