-
Continue reading →: Oracle Audit Control part 1 – location of the audit table
One of the oldest problems with the Auditing capabilities within Oracle is that the SYS.AUD$ table resides in the SYSTEM tablespace. Unless you are rigorous in ensuring that your audit records are routinely pruned to keep the table manageable, it can single-handedly make the SYSTEM tablespace enormous. Historically, we used to…
-
Continue reading →: Developers Killing Sessions
When you end up spending a far great a percentage of your day than seems sensible killing off Java connections that Developers have carelessly left lying around, locking objects all over the place, you need a solution to get them to go away. The solution is to let them do it…
-
Continue reading →: Doing it properly?
When giving a presentation last year about how much a DBA should do to get to the bottom of a problem; in a discussion between Martin Widlake, myself, and the audience we amusingly concluded that we probably shouldn’t be doing things quite right first time. What do I mean by this?…
-
Continue reading →: The trouble with Timezones & Grid Infrastructure
When installing Oracle Grid Infrastructure 11.2 (and all other releases), you need to make sure that you have all of the server setting correct and to standard before you do the install. One that bit me recently was the timezone setting. The Red Hat 6.4 server(s) in question has the…
-
Continue reading →: Online index problem – ORA-08104
So, you’re creating (or rebuilding) an index ONLINE on a busy system. Your session dies, or it becomes necessary to kill the command, you may find that Oracle does not (always manage to) automatically clean up after itself. CREATE INDEX my_ind ON my_table (mycol ASC) LOCAL LOGGING COMPRESS 1 ONLINE; (ctrl-c)…
-
Continue reading →: #desc
Here’s a good tip In SQL*Plus, that I have learned only recently; You’re in the middle of typing in some SQL or a PL/SQL Anonymous block, and can’t remember the column name, or other table information? At the start of the next line type “#desc <table_name>” and the table is…
-
Continue reading →: SQL Plan Management – 12C dumb feature
In Oracle 11G, Oracle introduced SQL Plan Management (SPM). It is excellent (I love it to bits). It allows you to create Baselines against SQL which lock-down the SQL execution plan. No more plan flips. More consistency. Perfect**. Whenever some Baselined SQL is ran, Oracle still parses it and compares…
-
Continue reading →: UKOUG Tech13
I attended the UKOUG Tech13 conference this week, along with over 1,000 other Oracle Technical Professionals (and some less-professional too), to learn what I could about how everyone else is doing stuff with Oracle, and how it works. And to share some experiences. I wasn’t disappointed. As with everything these…
-
Continue reading →: UKOUG Presentations for Tech13
I’m giving 2 presentation this year at the UK Oracle User Group Tech13 Conference The first is a discussion about the reason why you do or do not need to do low level detail traces and block dumps, and argument with Martin Widlake (and the audience hopefully). This is at…
-
Continue reading →: RACCheck
Running RAC? (Why? No, really, WHY? Never heard of DataGuard? With a broker?) Running RAC? Not sure if you’ve configured it correctly? Not sure if you have all of the recommended initialisation parameters set? All recommended RPM’s installed? All daemons running? etc, etc, etc, Well, as of Oracle 11.2.0.4 where’s…
-
Continue reading →: Goldengate OGG-01223 (Version) Problem
Just implementing Goldengate between a platform I don’t understand, a Tandem/HP non-stop, and Oracle 11G R2 RAC. So, I spend the day trying to get it working, have all of the configuration seemingly correct and when the Tandem guy an I try to for a connection to send data over,…
-
Continue reading →: UKOUG Tech13 launch last night
UKOUG Tech13 agenda launch last night. Feeling energised today if a little delicate. Looks like I’m giving 2 presentations this year.
-
Continue reading →: SQL Developer insight
When using SQL Developer, there is a feature called Completion Insight which help you write SQL and PL/SQL in the SQL Worksheets. It will auto-pop helpful things, like object name when typing a SELECT statement, column names if it is aware of the object which you are accessing and things…
Neil Chandler's DB Blog 