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: Oracle Database
An Oracle database system—identified by an alphanumeric system identifier or SID—comprises at least one instance of the application, along with data storage. An instance—identified persistently by an instantiation number (or activation id: SYS.V_$DATABASE.ACTIVATION#)—comprises a set of operating-system processes and memory-structures that interact with the storage. Typical processes include PMON (the process monitor) and SMON (the system monitor).
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...
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...
Datasource autoreconnect in Java Application Servers
Many times we face issues like the database will be down due to some reason and even after the database...