2 Shares 1 Share Facebook 1 Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email The Database Security Assessment Tool (DBSAT) is an incredible free command line tool provided by Oracle Corporation as a utility to help you verify your database for common database security issues(including security policies and controls in…
Category: Scripts
Playing with Google Authenticator and Oracle Cloud – Securing SSH to Oracle account with two factor authentication
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email The Requirement Increase security when connecting via SSH to the Oracle OS account at Oracle Cloud by implementing two factor authentication (TFA or 2FA). The Environment Oracle Cloud Instance OS: Oracle Linux 6.9 The…
My book: Oracle Database 12c Backup and Recovery Survival Guide
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote…
Tip of the month – Magic for DBAs
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Who never had a problem with a SQL that is killing your Database Performance and you can’t fix it because it’s running from an external closed application that you or your developers can’t touch?…
LOGGING or NOLOGGING, that is the question – Part VIII
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email By Francisco Munoz Alvarez How to find Sessions Generating Lots of Redo To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo…
Oracle CPU (Critical Patch Update) January-2009
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email The first CPU of 2009 is already out, was released on January 13, 2009. Like always, Oracle strongly recommends applying the patches as soon as possible. To know more about the January CPU like…
Be a hero, be proactive!
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Let start this New Year with a new mentality or a new resolution if you prefer call this way, let stop being reactive and start being proactive. Being proactive will reduce your database administration…
How to find all user Roles and Privileges?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email Here is the scripts to help you to get this information: PROMPT PROMPT PROMPT ******************************************** ROLES AND PRIVILEGES PROMPT PROMPT ******************************************** USER ROLES SELECT grantee user, granted_role, admin_option, default_role FROM dba_role_privs WHERE grantee IN…
How to setup a Basic Audit?
0 Shares 1K Share Facebook 1K Share Twitter 1K Share LinkedIn 1K Share Facebook Messenger 1K Share WhatsApp 1K Share Email For any Oracle versions prior to 9i you will need to set audit_trail parameter in the pfile ie.g.: audit_trail = DB For later Oracle Versions: SQL>alter system set audit_trail = DB; To enable auditing…