If we need to change some values of parameters persistently, what should we start? First of all, we have to know whether the database started… Read More »Whether Database Started with SPFILE or PFILE?
Tunning ASSM or ASM target can never be done within memory scope, which is not allowed.SQL> alter system set sga_target=64g scope=both;alter system set sga_target=64g scope=both*ERROR… Read More »How to Raise SGA_TARGET or MEMORY_TARGET
If your database is 10g onward, you don't have to worry about it, the control file will recreate the tempfiles after database restore, but for… Read More »Don't Forget to Add Tempfiles Back After Restoring 9i Database
Without declaring SCOPEIf you do not specify this clause, then:If a server parameter file was used to start up the database, then BOTH is the… Read More »The Default Values in "ALTER SYSTEM SET" Statement
A misconfigured database is a database which was set with wrong values of initialization parameters in SPFILE, it will prevent the database from startup. Let's… Read More »How to Startup a Misconfigured Database ORA-00837