How To Find Database Objects With Datafiles? SELECT DISTINCT t.ts#,t.name AS Tablespace_name,d.name AS DATAFILE,s.owner,s.segment_name,s.segment_type,s.bytes / 1024 / 1024 AS “MB”FROM v$tablespace t,v$datafile d,dba_segments sWHERE t.ts# … Read more
There are many Oracle GoldenGate parameters for the extract, pump, and replicate processes. We will explain each of them step by step. Oracle GoldenGate Parameters: … Read more
OSWatcher is a tool that collects information from commands like top, ps, vmstat, netstat, iostat, and meminfo. It records data files and automatically looks for … Read more
To generate ASH Report in an Oracle database. It’s simple and very easy, please follow the below steps. ASH Report to identify performance bottlenecks. ASH … Read more
To generate ADDM Report in an Oracle database. It’s simple and very easy, please follow the below steps. Full form of ADDM report: Automatic Database … Read more
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
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
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
The SQL Injection
To resolve ORA-00019 Maximum Number of Session Licenses Exceeded Encountering the “ORA-00019: maximum number of session licenses exceeded” error in Oracle Database can be challenging … Read more