-
Password Strength and Profile Settings in Oracle Databases
Continue reading →: Password Strength and Profile Settings in Oracle DatabasesEnforcing strong password policies is essential for safeguarding Oracle databases. This article explores how to create custom password verification functions using the password_verify.create_verify_function procedure, configure user profiles for password management, and enforce robust password encryption practices. Detailed examples and best…
-
Enforcing Password Strength and Profile Settings in Amazon RDS for Oracle
Continue reading →: Enforcing Password Strength and Profile Settings in Amazon RDS for OracleEnforcing strong password policies is essential for safeguarding Oracle databases in Amazon RDS. This article explores how to create custom password verification functions using the rdsadmin.rdsadmin_password_verify.create_verify_function procedure, configure user profiles for password management, and enforce robust password encryption practices. Detailed…
-
Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale Statistics
Continue reading →: Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale StatisticsScheduling a Job to Gather Statistics in Oracle Database Weekly for Stale Statistics Scheduling a Job to Gather Statistics in Oracle Database Weekly for Stale StatisticsGathering statistics in Oracle Database is crucial for ensuring the optimizer has up-to-date information to…
-
The Importance of Data Compression in Oracle Databases
Continue reading →: The Importance of Data Compression in Oracle DatabasesMaximizing Storage Efficiency with Advanced Database Compression: Benefits, Challenges, and Implementation StrategiesIntroductionThe exponential growth of data presents increasing challenges for organizations in managing storage, performance, and backup operations efficiently. Advanced database compression is a powerful solution that enables businesses to…
-
Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns
Continue reading →: Efficiently Managing Columns in Oracle: Marking and Dropping Unused ColumnsEfficiently Managing Columns in Oracle: Marking and Dropping Unused Columns Efficiently Managing Columns in Oracle: Marking and Dropping Unused Columns There may be situations where you need to drop a column containing a large amount of data, such as 10…
-
PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing – Oracle installation requires old rpm versions, what to do?
Continue reading →: PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing – Oracle installation requires old rpm versions, what to do?Below packages can usually be ignored as oracle installer thinks they are not available and are still needed while they already exists. [root@rac2 Desktop]# yum install libaio-0.3.105-2.i386.rpm Loaded plugins: refresh-packagekit, security Setting up Install Process No package libaio-0.3.105-2.i386.rpm available.…
-
LAST DDL change time on a table in ORACLE Database
Continue reading →: LAST DDL change time on a table in ORACLE DatabaseA general question among most of developers is ” HOW can I know when LAST DDL was done??” The best option will be to go and look at the table details. While you can also query the same details from…
-
Oracle Virtual Columns: A Powerful Feature in Database Design
Continue reading →: Oracle Virtual Columns: A Powerful Feature in Database DesignOracle Virtual Columns: A Powerful Feature in Database Design Oracle Virtual Columns: A Powerful Feature in Database Design Oracle 11g introduced the concept of Virtual Columns, a unique feature that allows dynamic calculations within a table. These columns behave like…
-
Configure Putty tunnel
Continue reading →: Configure Putty tunnelHow to Configure WinSCP and PuTTY for SSH Tunneling Setting up WinSCP and PuTTY to use SSH tunneling ensures secure and efficient connections to your servers through an intermediate host. This guide provides step-by-step instructions for configuring both tools. WinSCP…
-
Oracle Database DBMS_SCHEDULER: Creating and Managing Jobs
Continue reading →: Oracle Database DBMS_SCHEDULER: Creating and Managing JobsOracle DBMS_SCHEDULER: Creating and Managing Jobs The DBMS_SCHEDULER package in Oracle is a powerful tool for scheduling and automating tasks. Unlike its predecessor, DBMS_JOB, it provides advanced features such as calendaring expressions, better logging, and robust error handling. This article…
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
Hello,
Arvind Toorpu
I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
