Home › 2014 › Page 3

Year: 2014

By Posted on Posted in Oracle Tagged with , , ,

http://stackoverflow.com/questions/264914/how-do-i-calculate-tables-size-in-oracle –first gather stats for table… begin dbms_stats.gather_table_stats(‘MYSCHEMA’,’MYTABLE’); end; –or schema… begin dbms_stats.gather_table_stats(‘MYSCHEMA’); end; –get table size select owner, table_name, round((num_rows*avg_row_len)/(1024*1024)) MB, num_rows, avg_row_len, last_analyzed from all_tables where owner = ‘<WHOEVER>’ and table_name in (‘<WHATEVER>’) order by MB desc Also …

Get oracle table size Read more »

By Posted on Posted in Datastage Tagged with

[server1:~]: export DSHOME=$(cat /.dshome) [server1:~]: . $DSHOME/dsenv [server1:~]: export LD_LIBRARY_PATH=$APT_ORCHHOME/lib [server1:~]: export APT_CONFIG_FILE=/opt2/IBM/InformationServer/Server/PXEngine/APT_GRID_JOBDIR/ADM_00_ACCOUNT_SUMMARY_Master_Daily_SEQ/ADM_00_ACCOUNT_SUMMARY_Master_Daily_SEQ_32899132.config.apt [server1:~]: export PATH=$DSHOME/bin:$APT_ORCHHOME/bin:/$PATH [server1:~]: orchadmin -help ##I IIS-DSEE-TFCN-00001 16:53:40(000) <main_program> IBM InfoSphere DataStage Enterprise Edition 8.7.0.6366 Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved   ##I …

orchadmin Read more »

By Posted on Posted in Unix

for filename in <FILENAME_PATTERN>; do echo mv \”$filename\” \”${filename//<STRING_TO_REPLACE>/<REPLACEMENT_STRING>}\”; done | /bin/bash E.g: for filename in linx*; do echo mv \”$filename\” \”${filename//20140430/20140508}\”; done | /bin/bash