Oracle Statistics Gathering Timeout
Neil Chandler's DBA Blog
by Blog
2M ago
January 2024 – Oracle 12C+ 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, and takes place automatically in scheduled windows, both ..read more
Visit website
Fundamental Security Part Eight – Unified Audit
Neil Chandler's DBA Blog
by Blog
2M ago
January 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 is a very small amount ..read more
Visit website
Fundamental Security Part Seven– Data Encryption At Rest
Neil Chandler's DBA Blog
by Blog
5M ago
October 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). The simplest way to do ..read more
Visit website
Fundamental Security Part Six– Network Encryption
Neil Chandler's DBA Blog
by Blog
8M ago
August 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. This means that anyone with ..read more
Visit website
Fundamental Security Part Five – Observability
Neil Chandler's DBA Blog
by Blog
9M ago
July 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 have succeeded in stripping the ..read more
Visit website
Fundamental Security Part Four – Permissions Checking
Neil Chandler's DBA Blog
by Blog
9M ago
July 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 the primary application connection, has ..read more
Visit website
Fundamental Security Part Three – Unused and Historic Accounts
Neil Chandler's DBA Blog
by Neil Chandler
10M ago
June 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 someone with database access has ..read more
Visit website
Fundamental Security Part One – User Profiles
Neil Chandler's DBA Blog
by Neil Chandler
10M ago
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 something simple? What happens to ..read more
Visit website
Fundamental Oracle Security
Neil Chandler's DBA Blog
by Neil Chandler
10M ago
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 and I find that many ..read more
Visit website
Unexpected Performance Issue with Unified Audit and OEM
Neil Chandler's DBA Blog
by Neil Chandler
1y ago
Oracle 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), a process identified and linked ..read more
Visit website

Follow Neil Chandler's DBA Blog on FeedSpot

Continue with Google
Continue with Apple
OR