Cleaning Oracle SYSAUX Tablespace Usage
Recently in one of our Oracle instances sysaux tablespace grew huge and filled up the complete tablespace. We were also...
Category: Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). The term “database” refers both to the way its users view it, and to the logical and physical materialization of its data, content, in files, computer memory, and computer data storage.
Oracle redo log size increase in Oracle 12C
Oracle redo log is the most crucial structure for recovery operations, redo logs consists of 2 or additional preallocated files...
SQL Server Recovery From Page Header Corruption
There is no doubt in the fact that Microsoft SQL Server provides an effective means to manage database with an...
Export Import Of Application Context Oracle Explained
Exporting and importing is a fairly commonly used procedure by many database administrators to export database objects and import them...
Oracle sqlplus output to html explained
Many times we require formatted sql reports or sql query outputs for our reporting needs and better readability. We had...
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Running a database in noarchivelog mode disables the possibility of database recovery as we will not have any archived redo...
Steps To Gather Schema Stats with dbms_stats
Oracle provides the dbms_stats utility for estimating statistics for large partitioned tables and for better statistics which result in faster...
Steps To Fix Oracle Password Expired Error
When trying to login to database as schema user you might see this error and this might cause the application to...
Increase Swap Space Linux for Oracle Installation
While installing Oracle database for one of DEV environments we encountered a error due to small swap space available in...
Oracle database packages and types invalid
While upgrading Oracle database 11g to 12C via DBUA we came to know that the Packages and Types component is...