-
Continue reading →: Oracle Statistics Gathering TimeoutJanuary 2024 – Oracle 12C, 19C, 21C, 23C+ Gathering object statistic in Oracle is important. The optimizer needs metadata about the object, such as the amount of rows and number of distinct values in a column, to help it decide the optimum way to access your data. This takes effort,…
-
Continue reading →: Fundamental Security Part Eight – Unified AuditJanuary 2024 – Oracle 19C+ If you are Oracle 12.1 onwards, and you have not explicitly disabled it, you are using Unified Audit We previously discussed Data Encryption At Rest. Now lets talk about Unified Audit, and why you should be using it When you create an Oracle database, there…
-
Continue reading →: Fundamental Security Part Seven– Data Encryption At RestOctober 2023 – Oracle 19C+ What is Data Encryption At Rest and why should we use it? We have looked at Data Encryption in Transit, encrypting your network traffic. Everyone should be doing this. But what about Encrypting Data At Rest? Data that is stored permanently (on your hard drives).…
-
Continue reading →: Fundamental Security Part Six– Network EncryptionAugust 2023 – Oracle 19C We have considered observability. Knowing where you may have a security problem. We now need to look at removing some of the main problems associated with Oracle databases. Lets start with Network Security. By default, all data travelling over the network with Oracle is unencrypted.…
-
Continue reading →: Fundamental Security Part Five – ObservabilityJuly 2023 – Oracle 19C Now you know what permissions have been granted in your system and to whom, as shown in the previous post. Maybe you have remediated them down to least privilege. Now, how do you ensure the system stays like that? How do you know if you…
-
Continue reading →: Fundamental Security Part Four – Permissions CheckingJuly 2023 – Oracle 19C So in the previous post we talked about identifying unused and historic accounts. Old accounts should be removed, but what are the capabilities of the existing users who are accessing the systems? A surprisingly large amount of applications request that the schema owner, and maybe…
-
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, 26ai 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…
-
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…










