Solaris Systems Wiki

aditing_large_files_in_aix

Anonymous (anonymous@undisclosed.example.com) — 2018-02-05T09:10:40+00:00

Editing large files # Avoid problems when using vi to edit large files (files with many lines) export EXINIT="set ll=20000000" AIX cookbook

aix_paging_procentage

Anonymous (anonymous@undisclosed.example.com) — 2017-12-28T10:16:30+00:00

Command for finding AIX swapping percentage: lsps -s | awk ' { print $2" "$3 }'

aix_process_monitoring

Anonymous (anonymous@undisclosed.example.com) — 2019-12-17T12:56:45+00:00

archivelog_containing_scn

Anonymous (anonymous@undisclosed.example.com) — 2018-02-20T11:44:35+00:00

The archivelog files containing requested SCN select THREAD#,sequence# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#-1; Source link.

compress_directory_to_a_tar.gz_file

Anonymous (anonymous@undisclosed.example.com) — 2019-11-06T16:18:35+00:00

tar cvf - directory/ | gzip > /path/to/file.tar.gz

copy_sql_profile_to_other_database

Anonymous (anonymous@undisclosed.example.com) — 2017-12-29T10:51:51+00:00

1. Creating a staging table to store the SQL Profiles: exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name=>'SQL_PROFILES_TT',schema_name=>'SCOTT'); 2. Select SQL profiles names available in the source database. SELECT name FROM dba_sql_profiles; 3. Packing the SQL Profiles to the staging table

editing_large_files_in_aix

Anonymous (anonymous@undisclosed.example.com) — 2018-05-10T13:16:36+00:00

set -o vi export EXINIT="set ll=20000000"

extract_tar.gz_file_in_aix

Anonymous (anonymous@undisclosed.example.com) — 2018-03-06T15:42:35+00:00

Extract tar.gz file from one command in local directory gzip -cd /path_to/archive.tar.gz | tar -xf - Source

find_aix_version

Anonymous (anonymous@undisclosed.example.com) — 2018-10-11T12:57:52+00:00

oslevel -s | awk -F- '{printf "AIX %.1f - Technology Level %d - Service Pack %d\n",$1/1000,$2,$3}'

find_the_biggest_file_in_size

Anonymous (anonymous@undisclosed.example.com) — 2018-08-08T11:34:56+00:00

find . -ls |sort -n -r -k7 |head -15

grep_surrounding_lines_in_aix

Anonymous (anonymous@undisclosed.example.com) — 2020-10-05T09:27:56+00:00

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

how_far_oracle_flashback_can_go

Anonymous (anonymous@undisclosed.example.com) — 2017-12-28T10:12:03+00:00

The following statement helps find how far back in time FLASHBACK can go. select cast( from_tz( cast( oldest_flashback_time as timestamp ) ,dbtimezone ) at time zone 'US/Central' as date ) oldest_db_fb ,round((sysdate - oldest_flashback_time) * 24, 1) oldest_db_fb_hours from v$flashback_database_log;

how_to_get_sql_profile_hints

Anonymous (anonymous@undisclosed.example.com) — 2017-12-29T10:36:33+00:00

The following statement is used to obtain the sql profile hints SELECT extractValue(value(h),'.') AS hint FROM sys.sqlobj$data od, sys.sqlobj$ so, table(xmlsequence(extract(xmltype(od.comp_data),'/outline_data/hint'))) h WHERE so.name = 'opt_estimate' AND so.signature = od.signature AND so.category = od.category AND so.obj_type = od.obj_type AND so.plan_id = od.plan_id;

manually_implementation_of_sql_profile

Anonymous (anonymous@undisclosed.example.com) — 2018-01-09T14:46:43+00:00

The following tutorial shows how to manually implement a sql profile. 1. Use the following script to get the best execution plan ID for a SQL ID. 2. Obtain the sql plan hints: select * from table(dbms_xplan.display_awr('2tgrx1vgdw0t9',format => 'ADVANCED'));

monitor_progress_of_undo_operation

Anonymous (anonymous@undisclosed.example.com) — 2018-03-09T14:00:17+00:00

Monitor progress of UNDO operation select ses.username , substr(ses.program, 1, 19) command , tra.used_ublk from v$session ses, v$transaction tra where ses.saddr = tra.ses_addr; Source

oracle_12c_cluster-ware_log_location

Anonymous (anonymous@undisclosed.example.com) — 2018-08-24T10:09:08+00:00

The location of the clusterware log files now reside in diag_dest under the $ORACLE_BASE/diag/crs/$HOSTNAME/crs/trace

oracle_media_recovery_report

Anonymous (anonymous@undisclosed.example.com) — 2019-10-28T16:10:48+00:00

# 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';

oracle_stale_statistic

Anonymous (anonymous@undisclosed.example.com) — 2017-12-28T10:08:51+00:00

Script for finding Oracle stale statistics: col TABLE_NAME for a30 col PARTITION_NAME for a20 col SUBPARTITION_NAME for a20 select OWNER,TABLE_NAME,PARTITION_NAME,SUBPARTITION_NAME,NUM_ROWS,LAST_ANALYZED from dba_TAB_STATISTICS;

redo_log_file_management

Anonymous (anonymous@undisclosed.example.com) — 2020-02-20T16:14:31+00:00

Test

remaining_archivelog_to_restore

Anonymous (anonymous@undisclosed.example.com) — 2018-03-04T20:40:47+00:00

Remaining archivelog files to restore select count(case when (checkpoint_change#>=0 or checkpoint_change# is null) then 3 END) as Total, count(case when checkpoint_change# <>0 then 2 END) as Restored, count(case when (checkpoint_change#=0 or checkpoint_change# is null) then 1 END) as Remained from v$datafile_header;

remove_large_number_of_files

Anonymous (anonymous@undisclosed.example.com) — 2018-02-06T14:19:00+00:00

Remove multiple files. 1. Older than X days find . -name "*xml" -mtime +2 -exec rm {} \; 2. Remove all files with .xml extension if the following error is present when try to delete multiple files: ksh: /usr/bin/rm: 0403-027 The parameter list is too long.

rman_operation_elapsed_time

Anonymous (anonymous@undisclosed.example.com) — 2018-07-25T18:41:36+00:00

select OPNAME,SOFAR/TOTALWORK*100 PCT, trunc(TIME_REMAINING/60) MIN_REMAINING, trunc(ELAPSED_SECONDS/60) MIN_ELAPSED from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%agg%';

sql_plans_history

Anonymous (anonymous@undisclosed.example.com) — 2017-12-29T10:55:40+00:00

This statement generate the history of execution plans for a single SQL ID set pagesize 1000 set linesize 200 column begin_interval_time format a20 column milliseconds_per_execution format 999999990.999 column rows_per_execution format 999999990.9 column buffer_gets_per_execution format 999999990.9 column disk_reads_per_execution format 999999990.9 break on begin_interval_time skip 1

sql_report

Anonymous (anonymous@undisclosed.example.com) — 2019-11-04T11:26:36+00:00

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…

start

Anonymous (anonymous@undisclosed.example.com) — 2020-05-25T10:08:11+00:00

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…

top_ten_biggest_tables

Anonymous (anonymous@undisclosed.example.com) — 2018-05-02T16:14:27+00:00

select * from (select s.SEGMENT_NAME, s.SEGMENT_TYPE, (s.BYTES/1024/1024/1024) GB, t.LAST_ANALYZED from dba_segments s, dba_tables t WHERE t.table_name = s.SEGMENT_NAME and t.LAST_ANALYZED

user_his_roles_and_privileges

Anonymous (anonymous@undisclosed.example.com) — 2018-03-28T15:54:39+00:00

--# Privs : select lpad(' ', 2*level) || granted_role "User, his roles and privileges" from ( /* THE USERS */ select null grantee, username granted_role from dba_users where username like upper('%&enter_username%') /* THE ROLES TO ROLES RELATIONS */ union select grantee, granted_role from dba_role_privs /* THE ROLES TO PRIVILEGE RELATIONS */ union select grantee, privilege from dba_sys_privs ) start with grantee is null connect by grante…

vagrant_operations

Anonymous (anonymous@undisclosed.example.com) — 2020-01-29T10:40:22+00:00

# List virtual machines VBoxManage list vms # Start VM in headless mode VBoxManage startvm MyVM --type headless # Power off VM VBoxManage controlvm MyVM poweroff Source: