Ashli Sieben asked 1 year ago
Title : I am new to Oracle db, what is pfile and spfile?

Question :

I am new to Oracle db, what is pfile and spfile?

1 Answers
Kumar HarshKumar Harsh Staff answered 1 year ago

pfile stores database initialization parameters and any changes require restart. spfile is a binary file thatĀ holds same information and can be dynamically changed. By default if pfile is not specified in startup command then spfile is used.

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.