Posts

What is forking in postgres?

In this PostgreSQL interview series, we are going to discuss the important question for interview preparation for beginners. What is forking in postgresql? https://mynotesoracledba.medium.com/what-is-forking-in-postgresql-58e23458f026
Read more

ORA-00439: feature not enabled: Flashback Database

Today we discuss ORA-00439: feature not enabled: Flashback Database ora error This is the test database I was performing flashback on the dummy table to deleted some rows  and tried to do the flashback above-mentioned Error S-1: SQL> flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY -MM-DD HH:MI:SS'); flashback table hr.rg to timestamp to_timestamp('2018-04-18 12:57:00','YYYY-MM-D D HH:MI:SS') * ERROR at line 1: ORA-00439: feature not enabled: Flashback Table S-2: To view version of my oracle SQL> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production PL/SQL Release 11.2.0.2.0 - Production CORE    11.2.0.2.0      Production TNS for 32-bit Windows: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production S-3: to features of my oracle edition SQL> SELECT Parameter, Valu...
Read more

Rman Parameter configuration Part-2 in oracle11g

Let us discuss "Rman Parameter  configuration Part -2 in oracle11g" this are basic steps before we take backup for more details click here https://ampersandacademy.com/tutorials/oracle-admin-2/rman-configuration-parameter-part-2
Read more

How to Understand AWR reports in oracle 11g

Let us we discuss How to understand AWR reports in oracle 11g? We already Saw how to generate AWR reports here we go to read AWR reports step by step https://ampersandacademy.com/tutorials/oracle-admin-1/how-to-understand-awr-report-in-oracle11g
Read more

Difference between AWR and Statspack in Oracle 11g

AWR VS STATSPACK   *When we are facing performance issue in the database our first thought is to take AWR or statspack reports. but we do not know what are the difference between AWR and statspack Here we can discuss them and I will try to mention as much as I can   https://ampersandacademy.com/tutorials/oracle-admin-1/awr-vs-statspack-reports-in-oracle-11g
Read more

Dataguard and Rac Background Process in oracle

Let us we discuss Dataguard and Rac Background Process in oracle? Here we can see some important background process in Dataguard and RAC in oracle 11g https://ampersandacademy.com/tutorials/oracle-admin-1/dataguard-and-rac-background-processes-in-oracle-11g
Read more

BackGround Process in oracle

Let us we discuss What are the background process in oracle ?  In architecture we already saw some mandatory (PMON,SMON,DBWR,LGWR,CHPK AND ARCN )background process,but here we are going to see some more background process for more details click here https://ampersandacademy.com/tutorials/oracle-admin-1/background-process-in-oracle
Read more