|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : An Oracle instance is a combination of background processes and memory structures (SGA) ... A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The Latest Answer : Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database. ... Latest Answer : Answer:
Yes, We can start a database without spfile. It is not necessary that the
database should be open with spfile. If init.ora file is there, then you
can open the database. Then later you can create a spfile from pfile.
Mohammed ... The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ... Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ... What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly? Read Answers (1) | Asked by : Manoj Kumar Latest Answer : $ ps -eaf|grep pmon ... Read Answers (6) | Asked by : rajkumarl Latest Answer : Pfile1. text file2. changes take effect on the next startup3. initSID.oraSPfile1. binary file2. changes perisitent across startup and shutdown3. spfileSID.ora Only way to start db with spfile in non default location SPFILE = must beplaced in pfile ... Oracle DBA Questionswhat happen when we kill smon,what happen when we kill pmonwhat is fracture block and how to fix itwhat is corrupted block and how to fix itwhat are the oracle threads are going to start ,when we start the databasehow to check index is working properly ,what are the steps to be taken andon what basis we have to decide particular index has to rebuild not all indexeswhat steps to be taken if receive a call that performance has gone down as dba what steps has be takenWhat possible View Question | Asked by : Ibad Tags : Backup Latest Answer : you want to starting up a database by using STARTUP command....SQL>STARTUPto start instance, database must read the intialization parameter from either a server parameter file(SPFILE)or a traditional text intialization parameter file.When you ... Read Answers (2) | Asked by : shridhar
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
