Fulltext results:

Oracle: SPFile and PFiles

8 Hits, Last modified: 12 years ago

====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You ... ionally, Oracle can read the parameters from "PFiles", which are regular text files. ===== Create PFile ===== To export the SPFiles to a PFile, just enter the following in SQLplus: <

Oracle

1 Hits, Last modified: 9 years ago

====== Oracle ====== ===== Pages ===== {{indexmenu>.}} ===== Bookmarks ===== * [[http://www.oracle.

Oracle: List Accounts with Objects

1 Hits, Last modified: 12 years ago

o list all accounts (users) the objects (like tables), you can query them with: <code sql> SELECT DIS

Oracle Errors

1 Hits, Last modified: 12 years ago

hive logs]]. * **Resolution**: [[spfile_and_pfiles|Enlarge the flash recovery area]]. * **Document

Oracle: Resize Instance

1 Hits, Last modified: 12 years ago

e PGA to 2GB. First, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggreg