Fulltext results:

Oracle: SPFile and PFiles

11 Hits, Last modified: 13 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: Resize Instance

3 Hits, Last modified: 13 years ago

====== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggreg

Oracle Errors

3 Hits, Last modified: 13 years ago

Reason**: The flash recovery area is full. * **Resolution**: [[rman|Remove archive logs]]. * **Resolution**: [[spfile_and_pfiles|Enlarge the flash recovery area]]. * **Documentation**: [[http://down

Oracle: SQLplus Scripting

2 Hits, Last modified: 13 years ago

ing: <code sql> SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF

Oracle

1 Hits, Last modified: 11 years ago

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

Oracle: List Accounts with Objects

1 Hits, Last modified: 13 years ago

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