How To Generate AWR Report in Oracle Database?
To generate AWR report, ASH report, and ADDM report for Oracle RAC and non-RAC databases. Below are the sql scripts to execute as a Sysdba … Read more
tutorailwale
Oracle User Permission in Oracle Database
To check an Oracle user permission in an Oracle database, you can query the data dictionary views like DBA_SYS_PRIVS and DBA_TAB_PRIVS, which store information about … Read more
ORA 27102 out of memory Solaris-AMD64 Error: 12: Not enough space
We tried to start the database but got “ORA 27102 out of memory” errors. There was a DB activity to perform and we normally shut … Read more
What is Table Fragmentation in an Oracle And How To Remove Table Fragmentation?
Table fragmentation means when you updated or deleted data in a table and you wanted to reclaim space, yes you could, but Oracle immediately can’t … Read more
How to Resize Temporary Tablespace in Oracle 11g Database
To resize temporary tablespace in an Oracle 11g database, you should follow the below given document approach, which includes prerequisites. Checking the current configuration, and … Read more
How To Grant Read Only Access To User in Oracle Database?
In this article, we will discuss how to grant read only access to user in Oracle database. In the very first we need to create … Read more
SAP Modules In 2024
What is SAP? SAP, which stands for Systems Applications and Products, is a multinational software corporation that provides services like enterprise software to manage business … Read more
Best Common Linux Commands In 2024
The common linux commands In this post, we have tried to mention all common linux commands that are relevant to the linux administrator and dba … Read more
Useful Linux Commands For DBA
Useful linux commands for DBA with syntax, examples, definitions, and descriptions. Linux commands relevant for a database administrator (DBA), along with their syntax, examples, definitions, … Read more
Basic Linux commands for Oracle DBA With Examples
Basic Linux Commands for Oracle DBA with Examples, Definitions, and Descriptions. A list of basic linux commands for Oracle DBA, along with examples, definitions, and … Read more