-
Continue reading →: Oracle Audit Control part 3 – OS files
Just realized that I wrote a follow-up to Part 2 two years ago and never posted it! So here’s the stripped-out key facts to round off auditing control a bit more: Deleting O/S audit files is, like, totally necessary. In Oracle 12C (12.1), they are created by default as AUDIT_SYS_OPERATIONS…
-
Continue reading →: UKOUG Tech16 Call For Papers!
It’s that time of year again. The UKOUG Tech16 conference call for papers went out today. You want to learn a subject really well? Better than you currently know it? Teach someone about it! You want to help people avoid the potholes and problems that you hit with your implementation?…
-
Continue reading →: UKOUG RDBMS and RAC-CIA Special Interest Groups
On Thursday 21st April, there is a dual UKOUG Database and RAC, Cloud, Infrastructure and Availability special interest group. For the first time, this event is being held in the fabulous Northern city of Manchester! There are a dozen interesting, career-assisting, educational talks from end users, Oracle employees and a…
-
Continue reading →: Proxy Accounts Tracking
If you are using Proxy accounts to access users, for example as a DBA to do a release to a schema owner, how do you know the login was via proxy instead of directly with the password? This information is handily recorded in the audit, assuming you have audit switched…
-
Continue reading →: Accessing a user when you don’t know the password
There are times that you may need to logon to a database user, probably a schema owner to do a release, but you don’t know the password. You may not be able to (easily) change the password as it could be embedded in application connect strings or worse. If may…
-
Continue reading →: Killing Sessions
You have a session which is out of control. You decide to kill it. What options are available to you as a DBA? Assuming you don’t have access to the O/S to be able to use O/S commands to kill the session (using kill -9 in Unix/Linux or orakill in…
-
Continue reading →: Contactless Payment Theft
You may have seen stories in the news about Contactless Payment theft; how it is possible for a criminal to merely brush against you with a new contactless card reader and steal up to £30 from your contactless payment card. It might be a good idea to consider protecting your…
-
Continue reading →: Pre-creating Interval Partitions
One of the major problems with interval-based partitioning is the statistics. Partitions appear dynamically as-needed based upon data being inserted or udpated, and any partition magically appearing isn’t going to have any statistics. This is generally a stability issue as you will, at best, be using dynamic statistics for your…
-
Continue reading →: Primarys Keys and their supporting indexes
Sometimes things just happen which makes you realise that stuff you thought all experienced DBA’s knew about isn’t common knowledge. I suppose it’s a side effect of working with the same evolving product for over 25 years at dozens of clients, when the colleague you are talking to has a…
-
Continue reading →: The Boat
Coming soon in March there’s one of the most popular global user group conferences, The Norwegian Oracle User Group Spring conference, known fondly as “The Boat“, it takes place from 10th to 12th of March sailing on board a cruise ship. The ship sails from Olso on 10th and arrives…
-
Continue reading →: UKOUG Tech 15
It’s nearly early December, so it must be time for the UK Oracle User Group Conferences – JDE15, Apps15 and Tech15 There’s some absolutely wonderful presentations, and there’s the 2 I’m giving as well: An Introduction to RAC (12c) at 9am on Monday 6th, and Troubleshooting Goldengate at 12:20 on…
-
Continue reading →: Decoding DBA_TAB_COLUMNS high_value and low_value
When performance tuning, it can be important to understand the statistics in the database. It is worth noting that every column records it lowest (low_value) and highest (high_value) values in DBA_TAB_COLUMNS when you gather stats, like a mini-histogram. If the optimizer believes it knows the range of values within a…
-
Continue reading →: OEM and monitoring the -MGMTDB GMIR Database
When you create Grid Infrastructure in 12.1.0.2, you are presented with a new (annoyingly named) “-MGMTDB” This database is a standard, 12C CDB/PDB storing transient performance and other information (Grid Infrastructure Management Repository). If it is lost, no biggie. Just re-create it (in your voting disk DG. Aside: create a…
-
Continue reading →: Oracle Midlands Presentation
Ever wonder why your SQL execution plan has changed? Wondering why your boss is shouting something about “traders can’t trade” or “shoppers can’t spend” or “well that’s the Airport shut!” ? When you write SQL, Oracle runs it through the Optimiser to determine the fastest way to access the data.…
Neil Chandler's DB Blog 