| SPfile [message #49640] |
Fri, 01 February 2002 02:07  |
Jayarama Murthy
Messages: 3
Registered: February 2002
|
Junior Member |
|
|
1. What is a SPfile?
2. How do U see the background process at DB-LEVEL?
3. Can U see both Pfile and SPfile for the database startup?
|
|
|
|
| Re: SPfile [message #49643 is a reply to message #49640] |
Fri, 01 February 2002 03:31  |
Harish Lingegowda
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
I really have no idea about SPfile for the moment and where did u find that.
If U are working on Windows all process are considered as thread so all process will be in single thread oracle.exe.
Still further u can find sid of specific background process using oracle performance manager.
pfile is parameter file ie where your init.ora file is found in NT example c:>oracleadminorclpfileinit.ora.
At database startup reads parameter file to set SGA ie instance for the database.
Let me know on what OS oracle is Running.
Harish.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
