Fulltext results:

Oracle: SPFile and PFiles

5 Hits, Last modified: 12 years ago

e SPFiles to a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${... to the PFile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='${PAT... itweb.ora'', the the second line would be: <code sql> STARTUP NOMOUNT PFILE='/db/oracle/config/pfiles/

Oracle: List Accounts with Objects

4 Hits, Last modified: 12 years ago

ts (like tables), you can query them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY ... ist all accounts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}}

Oracle: SQLplus Scripting

4 Hits, Last modified: 12 years ago

====== Oracle: SQLplus Scripting ====== To show only data in SQLplus and no header or other stuff, enter the following: <code sql> SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PA... SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF </code> {{tag>oracle scripting sqlplus}}

Oracle: Resize Instance

3 Hits, Last modified: 12 years ago

, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE... (optionally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admi

Oracle: Recovery Manager

2 Hits, Last modified: 12 years ago

ll archive logs but keep the last 45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE ... rompting, e.g. via cron, after backup run: <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE