Scope of this Wiki site:

This wiki contains all Oracle or Linux/Unix commands used on my daily activity.

• Oracle stale statistic.
• How far Oracle FLASHBACK can go.
• How to get SQL profile hints.
• Copy SQL profile to other database.
• SQL plans history.
• Manually implementation of SQL profile
• Archivelog containing SCN
• Remaining archivelog to restore
• Monitor progress of UNDO operation
• User, his roles and privileges
• Top ten biggest tables
• RMAN operation elapsed time
• Oracle 12c Cluster-ware log location
• Oracle Media recovery report
• sql report
• Redo log file management

• Aix paging procentage.
• Editing large files in AIX.
• Remove large number of files.
• Compress directory to a tar.gz file
• Extract tar.gz file in AIX
• Find the biggest file in size
• Find AIX version
• AIX process monitoring
• Vagrant operations
• Grep surrounding lines in AIX