Posts Categorized: Pythian

Oracle Security vs Microsoft Security

I always get a chuckle well not always but often, when I read anything to do with Microsoft vs. “the flavour of the month”. In this case, it looks like the flavour of the month is Oracle. The articles simple imply that SQL Server is more secure than Oracle. They go on to count the number of vulnerabilities identified over the last few years. It’s scary stuff and I’m sure we’re all running out now to ask our architects and DBAs how quickly we can port over to SQL Server.

Oracle Listener Crash in Windows

I faced a problem yesterday. The Oracle listener crashed each time a connection was made. The OS was WINXP SP2. It goes without saying that this was a testing install. The event log showed the following error in SYSTEM log and APPS log. Finally I found the following magic command which fixed the issue after running and restarting the box.

“change tracking state change latch”

In my UKOUG 06 presentation on block change tracking internals I assumed that “change tracking state change latch” is, probably, used by DBWR and CTWR to protect access to a buffer area in shared pool. I wanted to verify it and tried to trace this latch.

Which Risks Are You Protected From?

I worked on one site for a while and during 2.5 years it didn’t face a single media corruption of Oracle datafiles. But one day, my fellow DBA (who is usually extremely cautious and reviews his actions at least twice) overwrote a controlfile with some crap. Even the fact that controlfiles were on raw devices didn’t prevent this disaster from happening.

A Good DBA’s Peripheral Vision

I believe that a good DBA should have well developed “peripheral vision”. It helps everywhere — troubleshooting production issues or performance problems, database/application design, system architecture, reading documentation, etc. I also notice that a newbie DBA with good peripheral vision catches up much faster than a strictly focused person.

Page 202 of 225« First...102030...200201202203204...210220...Last »