<div>
it defaults to memory<br />
<br />
<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_2014.htm#i2053602" rel="ugc nofollow">http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_2014.htm#i2053602</a>
</div>


it defaults to memory


http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_2014.htm#i2053602 [http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_2014.htm#i2053602]

<div>
msimons4,<br />
<br />
I appreciate the points, but slightwv gave a superior answer. &nbsp; &nbsp;<br />
<br />
defaults to memory is correct for only one scenario. &nbsp;I didn't mention the other, but I did include the same link.<br />
<br />
I suggest either giving him all the points, or at least a weighted split with him the majority
</div>


msimons4,

I appreciate the points, but slightwv gave a superior answer.    

defaults to memory is correct for only one scenario.  I didn't mention the other, but I did include the same link.

I suggest either giving him all the points, or at least a weighted split with him the majority

<div>
sdstuber,<br />
<br />
Thanks for the offer. &nbsp;We both basically pasted the same thing at the same time. &nbsp;I'm fine with how the points were split.
</div>


sdstuber,

Thanks for the offer.  We both basically pasted the same thing at the same time.  I'm fine with how the points were split.

<div>
<div class="content wysiwyg-content">
Atler system set ... <br />
What happens if you don't specify scope=spfile or scope=memory or scope=both?
</div>
</div>


Atler system set ... 
What happens if you don't specify scope=spfile or scope=memory or scope=both?

Alter system

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.