How do you switch from an init.ora file to a spfile?
Answer Posted / ravindra
create pfile from spfile;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
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?
Where would you look for errors from the database engine?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is a correlated sub-query? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what are the performance views in an oracle rac environment?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how does an oracle clusterware manage crs resources?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is fill factor? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
who owns the operating system files created by the utl_file package?
What are the different types of database compression introduced in sql server 2008? : sql server DBA