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

Popular posts from this blog

Error in starting the service (OracleMTSRecovery)

Image
 While i am installing the oracle 11g database i got the popup message " Error in starting the service.The service OracleMTSRecoveryService was not found " i just ignored the message and continue my installing but the installation was successful with errors, so once again i started the installation this time also i got the same error pop up and  searched on google to resolve this issue by using below steps S-1: S-2: press " Ctrl + r " then type " regedit " you 'll got this screen and  then choose " HKEY_LOCAL_MACHINE "   S-3:  Then choose " SYSTEM "  => " ControlSet001 " => " Services " => " OracleMTSRecoveryService "       S-4:                 After   choosing the " OracleMTSRecovery " we can see the " imagepath " which was mentioned below Double click the image and change the path where we are going to install the software(like be...
Read more

ORA-39000, ORA-39143 ORA- 31619 invalid dump file in datapump

Today i am tired to export  one schema (hr) from the one database  into another database  ( import schema ) so i created one directory which is called "ram" grant read and write access to  the system user ,then i started export the schema (hr) from production  while i did the export of hr schema the job was successful after that i did import schema like below expdp : C:\>expdp system/oracle directory=ram schemas=hr dumpfile=hr.dmp logfile=hr.log ...... ...... Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:   C:\datapump\HR.DMP Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 13:23:40 impdp: C:\>impdp system/oracle directory=ram remap_schema=hr:scott dumpfile=HR.DMP logfile=hr.log it through an error like below . ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31619: invalid dump file "C:\datapump\hr.dmp" ORA-27091: unable to queue I/O ORA-27070: async read/write failed OSD-04006: ReadFile() failu...
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