In the 10g database version we had the ability to validate the database and the backup sets using the Backup Validate command. This command was able to validate the database datafiles and check for any block corruptions while the use was to make sure that the specific backup sets were valid (no missing files). The […]
Oracle Secutriy Strong Password Hash Algorithm Out of Box Security features Delayed Failed Logins Case Sensitive passwords Oracle Security Oracle Security features is by no means a second thought in today’s database system design. It is a part of the overall design strategy and can be a major concern when choosing one database over another. […]
Introduction Password Protection Password Verification Function Changing Passwords Introduction In addition to changing the default for the passwords from being case insensitive to case sensitive, Oracle has also introduced strong password authentication, using a new technique, to safeguard the passwords exposed via the DBA_USERS view. This article looks at this first and also discuss other […]
[dropcap1]E[/dropcap1]ven with all the security measures in place, one potential threat which mostly goes unnoticed is access to certain database packages. There are some packages which have execute privileges granted to public by default, which means that any database user can execute them. The four packages of special importance in this context are the below. […]
Starting in Oracle 12c database, you can change this and enable the new Multithreaded configuration! And that too by merely setting one parameter. You can change the architecture by making Oracle database use thread based architecture instead of process based. Once changed, all Oracle processes will be threads within a few Oracle processes. Thus if CPU moves from one Oracle process to the other, the time between the context switch will be reduced significantly as the switching from one thread to the other is within the same process.