https://wiki.solaris-systems.ro/ 2026-04-17T17:27:35+00:00 https://wiki.solaris-systems.ro/ https://wiki.solaris-systems.ro/lib/tpl/dokuwiki/images/favicon.ico text/html 2020-10-05T09:27:56+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=grep_surrounding_lines_in_aix&rev=1601879276&do=diff To print 5 lines before and after error message (ORA-00904): awk -v dt=$(echo ORA-00904) '$0~dt{counter=5}counter>=0{print;counter--}' create_indx3_parallel.log text/html 2020-05-25T10:08:11+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=start&rev=1590390491&do=diff Scope of this Wiki site: This wiki contains all Oracle or Linux/Unix commands used on my daily activity. Oracle pages: * 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 * R… text/html 2020-02-20T16:14:31+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=redo_log_file_management&rev=1582208071&do=diff Test text/html 2020-01-29T10:40:22+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=vagrant_operations&rev=1580287222&do=diff # List virtual machines VBoxManage list vms # Start VM in headless mode VBoxManage startvm MyVM --type headless # Power off VM VBoxManage controlvm MyVM poweroff Source: <https://schier.co/blog/start-virtualbox-vm-in-headless-mode> text/html 2019-12-17T12:56:45+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=aix_process_monitoring&rev=1576580205&do=diff You may use the following commands for checking CPU/Memory utilization. Displaying top CPU_consuming processes: #ps aux | head -1; ps aux | sort -rn +2 | head -10 Displaying top 10 memory-consuming processes: #ps aux | head -1; ps aux | sort -rn +3 | head text/html 2019-11-06T16:18:35+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=compress_directory_to_a_tar.gz_file&rev=1573049915&do=diff tar cvf - directory/ | gzip > /path/to/file.tar.gz text/html 2019-11-04T11:26:36+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=sql_report&rev=1572859596&do=diff SET pages 250 col begin_interval_time FOR a30 col sql_profile FOR a30 SET lines 200 col cpu_time_total FOR 9999999999999999 col elapsed_time_total FOR 9999999999999999 col iowait_total FOR 9999999999999999 SELECT a.INSTANCE_NUMBER,b.snap_id,b.begin_interval_time, a.plan_hash_value, a.optimizer_mode, a.sql_profile, a.disk_reads_total, a.buffer_gets_total, a.cpu_time_total,a.EXECUTIONS_TOTAL, (a.elapsed_time_total/1000000)elapsed_time_sec, a.iowait_total FROM dba_hist_sqlstat a, dba_hist_snap… text/html 2019-10-28T16:10:48+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=oracle_media_recovery_report&rev=1572271848&do=diff # lists backups of all files in database LIST BACKUP OF DATABASE; # lists copy of specified datafile LIST COPY OF DATAFILE 'ora_home/oradata/trgt/system01.dbf'; # lists specified backup set LIST BACKUPSET 213; # lists datafile copy LIST DATAFILECOPY '/tmp/tools01.dbf'; text/html 2018-10-11T12:57:52+00:00 admin (admin@undisclosed.example.com) https://wiki.solaris-systems.ro/doku.php?id=find_aix_version&rev=1539251872&do=diff oslevel -s | awk -F- '{printf "AIX %.1f - Technology Level %d - Service Pack %d\n",$1/1000,$2,$3}'