I am writing at my blog for future reference. I am writing Oracle related experiences and stuffs.
I have over 7 years of Oracle DBA experience, I am also Oracle 11g DBA & 10g DBA Certified Professional.
If you want to hire me on Permanent / Contract / Project basis then do contact me at rocky.soni@gmail.com or rakesh.is.ocp@gmail.com.
Friday, November 25, 2011
PFILE or SPFILE ..
How will I know if my database is using a PFILE or SPFILE: Execute the following query to see if your database was started with a PFILE or SPFILE: SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';
No comments:
Post a Comment