(Kellyn Pot’Vin-Gorman) Someone pinged me earlier today and said, “Do I even really need to know about logs in Enterprise Manager? I mean, it’s a GUI, (graphical user interface) so the logs should be unnecessary to the administrator.”
Tag: Oracle
Oracle Data Visualisation : Setting up a Connection to your DB
(Brendan Tierney) Using Oracle Data Visualisation is just the same or very similar as to using the Cloud version of the tool.
Customizing SQL Developer Toolbars
(Jeff Smith) We already have some pretty Spartan toolbars. We aim for fewer buttons, not less.
Mutating Table Error In Oracle: Why It Happens And What You Can Do About It
(David Fitzjarrell) The mutating table error in Oracle can be a familiar sight throughout a DBA’s career, along with the usual question of ‘Why?’. The error itself is not difficult to understand nor is it hazardous to the table data.
Incremental Statistics Collection in Oracle 12.1.0.2 – Upgrade Pitfalls
(Mike Dietrich) A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2:
EM13c Proxy Setup, MOS and CSI Setup
(Kellyn Pot’Vin-Gorman) The change in EM13c, is that it support multiple proxies, but you may still not know how to set up a proxy and then use it with your MOS credentials and then assign out your CSI’s to targets.
Compression — 8 : DROPping a Column of a Compressed Table
(Hemant K Chitale) Building on the series on Compression …..
Optimize ADF HTTP Response Size with ChangeEventPolicy
(Andrejus Baranovskis) You should read this post, if you are looking how to reduce ADF HTTP response size. This can be important for ADF application performance tuning, to improve PPR request response time. By default in ADF 12.2.1, iterator is assigned with ChangeEventPolicy = ppr.
Workarounds
(savvinov) It’s been forever since I last shared any of my performance troubleshooting experiences at work. This week, I got a case that I think is worth publishing, and I decided to write about it in my blog. So, here we go…
Oracle Cloud – DBaaS instance down for no apparent reason – (how archive log mode and storage shortage forced the instance to its knees)
(Lucas Jellema) My Oracle Public Cloud DBaaS instance did not respond. On closer investigation, it turned out to be down. Mounting the database ended with an ORA-3113 End of Communication Channel. Investigation of the startup log and the database alerts indicated that no new archive log files could
