Home » RDBMS Server » Server Administration » Few Basic Questions
Few Basic Questions [message #63307] Mon, 27 September 2004 00:53 Go to next message
puneet
Messages: 76
Registered: August 2002
Member
Hi,

I need to clear out few basic questions

a) What is difference b/w SYS and SYSTEM USER

b) What is SP<<SID>>.ORA FILE and what difference does it make if I have only SP<<SID>>.ORA FILE or Pfile init<<SID>>.ORA FILE

IF Oracle read this PFILE insead of SPFILE, Is there is any difference in the performance.

Regards

Puneet Sachar

Report message to a moderator

Re: Few Basic Questions [message #63308 is a reply to message #63307] Mon, 27 September 2004 01:27 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

Question a: See section "Database Administrator Usernames" in chapter 1 of the "Database Administrator's Guide".

Question b: see section "Initialization Parameters and Database Creation" in chapter 2 of the "Database Administrator's Guide".

Question c: No, if will make absolutely no difference in performance either way!

Best regards.

Frank

Report message to a moderator

Re: Few Basic Questions [message #63309 is a reply to message #63308] Mon, 27 September 2004 01:38 Go to previous messageGo to next message
puneet
Messages: 76
Registered: August 2002
Member
Thanks Frank,

But Y Oracle has created the function of SP<<SID>>.ORA File. If there is no difference in performance why in 9i they have chnage it.

Punu

Report message to a moderator

Re: Few Basic Questions [message #63315 is a reply to message #63309] Mon, 27 September 2004 04:56 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

Because there is a difference in functionality. I'm sure you will understand after reading chapter 2 of the admin guide.

Best regards.

Frank

Report message to a moderator

Re: Few Basic Questions [message #63325 is a reply to message #63307] Mon, 27 September 2004 11:53 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
I believe SYS is intended for maintenance operation, such as startup/shutdown, recover. and is also the owner of the data dictionary and dynamic views.

SYSTEM user is a simple dba user.
You can create your customized DBA user, or SYSDBA user, also SYSOPER user for startup/shutdown purpose and no need to user sys and system anymore.

Of course, all this is better explained in documentation.

I also believe tha SP file is intended for security reason, i mean, you can edit that file as easy as init.ora file. But nothing to do with performance.

Best regards.
Oracle Consultant and remote DBA for hire.

Report message to a moderator

Previous Topic: HARDWARE REQUIRMENTS
Next Topic: ORA-01031
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 14:49:36 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.