ORA-1652: unable to extend temp segment by %s in tablespace TEMP This error occur when user running the queries doesn’t…
A materialized view is a table segment or database object that contains the results of a query. A materialized view…
Sometimes it is required to flush the single sql plan from the shared pool and it a good idea rather…
Being a DBA, you often asked to check the status of RMAN backup job details. You can monitor progress and…
From Oracle 10gR2 onward RAC clusterware automatically start and stop the ASM and Oracle database instances and listeners, so the…
Sometime you need to Kill Oracle Session to avoid any performance issues. There are chances that some session cause blocking…
Oracle database Size depends on the volume of data stored on disk or ASM. You can check size of Oracle…