-
Continue reading →: Fundamental Security Part Three – Unused and Historic AccountsJune 2023 – Oracle 19C So in the previous post we talked about implementing password complexity. Complex passwords are fine, but what when you experience change. For example, someone leaves the company to become a professional skydiver. Do you remove their database accounts? Are you even informed by HR that…
-
Continue reading →: Fundamental Security Part Two – Password Complexity and DefaultsJune 2023 – Oracle 19C So in the previous post we saw the creation of a PROFILE to add controls on user passwords, but we did not specify password complexity. By default, this is set to NULL in the profile, meaning no password complexity is enforced. This is a bad…
-
Continue reading →: Fundamental Security Part One – User Profiles
June 2023 – Oracle 19C Stage 1 with our Fundamental Oracle Security… are you enforcing password rules with your database users and administrators? Do you have a standard to which you are adhering? Are the users forced to change their passwords regularly? Can they change it back again, maybe to…
-
Continue reading →: Fundamental Oracle Security
June 2023 – Oracle 19C Frequently I turn up at companies to resolve performance issues and migrate and upgrade systems. However, I have spent a fair bit of time recently working on security, from audit to helping with ransomware issues. The profile of security has increased significantly in recent years…
-
Continue reading →: Unexpected Performance Issue with Unified Audit and OEMOracle 19C. January 2023. A customer was experiencing excessive I/O against the operating disk (sda), which indicated problems with /u01 or /u03. There was nothing obviously writing a lot of data to any “sda” mounted filesystems (and no swapping), so process tracing was initiated to review I/O against processes (pidstat),…
-
Continue reading →: Huge Pages on ExadataQuick note to myself: Oracle has deprecated the initialisation parameter use_large_pages=”true” on Exadata as of 19.13 (OK – could be 19.12, I’ve not checked) If you started your database in 19.11, and had this set, you got yourself a warning in the alert log (if you have a look): “WARNING:…
-
Continue reading →: Mash ProgramAs an experienced speaker and community advocate, I decided to join with a number of other like-minded community advocates to see if we can help others get started in the world of conference speaking. Everybody has a story to tell about their work. Talking about the challenges you face in…
-
Continue reading →: Exadata System StatisticsFollowing on from last weeks Oracle Optimizer System Statistics post, I though it worthwhile adding a note about gathering system statistics in Exadata mode. exec dbms_stats.gather_system_statistics(‘EXADATA’); So what is this, and why would you chose to do it? First of all, these are not workload system statistics (which I believe…
-
Continue reading →: Oracle Optimizer System StatisticsOh System statistics! Should we gather them? Should we not?What do they mean? What are they doing to the optimizer? tl;dr – in almost all cases, DON’T GATHER SYSTEM STATISTICS.DON’T SET MBRC. LET THEM DEFAULT! First you need to be armed with a piece of information. When Oracle optimizes your…
-
Continue reading →: Goldengate Install ErrorSometimes you waste much more time than you can believe because the instrumentation of the system isn’t great. If you don’t know what a system is doing, you can’t easily fix it. Time should be take to instrument your code, and ensure that any outputs from that instrumentation are readily…
-
Continue reading →: Oracle Database GLOBAL_NAME, DB_DOMAIN and database linksI needed to create a database link on a 19.7C Oracle DB recently. Importantly, the database link name must match the database name as security dictates that GLOBAL_NAMES=TRUE for this set of databases. The DB was created using the gui on an ODA, meaning there were quite a few initialisation…
-
Continue reading →: UKOUG Techfest19I’ve just returned from Techfest19 – the UKOUG Flagship Oracle Tech conference – and it was simply excellent. It was held at The Grand Hotel in Brighton, and it was grand. If you missed it, you really missed out. 250 mostly amazing presentations. I did 2 main ones about Oracle…
-
Continue reading →: Oracle Tech Conferences
It’s mid-November 2019. The leaves have mostly fallen and the nights are drawing in. That can only mean… it’s time for Europes 2 biggest Independent Oracle User Groups to have their conferences. The first, starting Tuesday 18th November, is DOAG – the German Oracle User Group – in Nuremberg. I’m…
-
Continue reading →: Oracle Table Prefs
V. Quick post for me really: Some SQL to tell me all of the Table Prefs for any specific table (All Oracle 19 prefs) You could always just query DBA_TAB_STAT_PREFS select * from user_tab_stat_prefs where table_name = ‘&&TABLE’; But that only tells you what you have explicitly set for a…
Neil Chandler's DB Blog 