Oracle Tidbits – July 2015 #oratidbit

Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in July 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use…

Publish Date TidBit
1-Jul #oratidbit use V$INSTANCE_RECOVERY view column OPTIMAL_LOGFILE_SIZE to determine the size of your online redo logs. This column shows the redo log file size in megabytes that is considered optimal based on the current setting of FAST_START_MTTR_TARGET.
2-Jul #oratidbit The V$PROCESS view contains one row for each Oracle process connected to the database instance. Columns program, pga_used_mem, pga_alloc_mem, pga_freeable_mem, pga_max_mem show the PGA memory usage for each connection.
3-Jul #oratidbit check out the V$OSSTAT view, which displays system utilization statistics from the operating system, one row for each system statistic.
6-Jul #oratidbit In #DB12c, the SYSBACKUP administrative privilege encompasses the permissions required for backup and recovery, including the ability to connect to a closed database. System administrators can grant SYSBACKUP instead of SYSDBA to users who perform backup and recovery, thus reducing the proliferation of the SYSDBA privilege. In contrast to SYSDBA, SYSBACKUP does not include data access privileges such as SELECT ANY TABLE.
7-Jul #oratidbit In #DB12c, #RMAN supports DESCRIBE command similar to SQL*Plus.
8-Jul #oratidbit In #DB12c, #RMAN DUPLICATE DATABASE has NOOPEN clause to keep the database in mount state after duplicate.
9-Jul #oratidbt The REPORT UNRECOVERABLE command in #RMAN lists all data files for which an unrecoverable operation has been performed against an object in the data file since the last backup of the data file.
10-Jul #oratidbit The RESTORE DATABASE PREVIEW command in #RMAN can be used to report, but not restore, the backups that RMAN can use to restore. The database can be open when you run this command. RMAN queries the metadata and does not actually read the backup files.
13-Jul #oratidbit The RECOVER CORRUPTION LIST command in #RMAN recovers all corrupted blocks listed in V$DATABASE_BLOCK_CORRUPTION.
14-Jul #oratidbit #RMAN command-line argument CHECKSYNTAX can be used to validate RMAN command files. “rman CHECKSYNTAX @commandfile”. Argument CHECKSYNTAX starts the RMAN client in a mode in which it only parses the commands that you enter and returns an RMAN-00558 error for commands that are not legal RMAN syntax.
15-Jul #oratidbit If you are licensed to use Oracle Advanced Compression option, you have HIGH, LOW, MEDIUM compression choices with #RMAN Backups. The default is CONFIGURE COMPRESSION ALGORITHM ‘BASIC’.
16-Jul #oratidbit STORAGE_SIZE column in V$RESTORE_POINT is zero for normal restore points. For guaranteed restore points, STORAGE_SIZE indicates the amount of disk space in the fast recovery area used to retain logs required to guarantee FLASHBACK DATABASE to that restore point.
17-Jul #oratidbit #RMAN in #DB12c excludes undo not needed for recovery of a backup, that is, for transactions that have been committed. Backup undo optimization works for disk backups and Oracle Secure Backup (OSB) tape backups.
20-Jul #oratidbit The equivalent of SQL*Plus STARTUP RESTRICT in #RMAN is STARTUP DBA. STARTUP FORCE DBA is valid too. Restricts database access to users with the RESTRICTED SESSION privilege.
21-Jul #oratidbit Trace File Analyzer Collector (TFA) has a collection of health check and diagnostic tools including orachk, exachk, SQLT, procwatcher, osw. Read MOS Note 1513912.2
27-Jul #oratidbit #SQLDeveloper can format a .sql file or all .sql files in a directory, use the format.sh or format.bat on the operating system command line.
28-Jul #oratidbit Using #SQLDeveloper you can connect to schemas for non-Oracle databases, such as MySQL, Microsoft SQL Server, Sybase Adaptive Server, Microsoft Access, and IBM DB2, and view metadata and data in these databases; and you can migrate these non-Oracle databases to Oracle.
29-Jul #oratidbit When you use #SQLDeveloper to connect to a schema that owns #APEX applications, you can perform Import, Deploy, Drop, Modify APEX application operations through the Application Express node in Navigator.
30-Jul #oratidbit Using #SQLDeveloper you can display SQL Trace output files in a formatted way similar to TKPROF. You can examine the information in the List View, Statistics View, and History panes, with each pane including options for filtering and controlling the display.
31-Jul #oratidbit #SQLDeveloper SQL Worksheet does not support few SQL*Plus commands such as archive, copy, oradebug, password, recover, run, startup, shutdown.