Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

h8dk97 : member's tip(s)


   Found 202 tips, Displaying 61 - 70 
 
Sort by 
 
 Find segments with corrupted block from alert log with ORA-01578
1. Get the list of corrupted blocks grep 'ORA-01578' alert_DB.log | sort -u > tmp.txt 2. Generate SQL script to find segments with corrupted blocks cat tmp.txt | awk '{ printf("%s %s\n", $8, $11); }' | \ awk -F\, '{ printf ("%s %s\n", $1, $2); }' | \ awk -F\) '{ printf("%s\n", $1); }' | ...
 More...
07/11/07
 
 
Category : Databases > Oracle > Block Corruption
 
 
 How to save (export) table stats
Before analyzing a table you may want to save the old stats (i.e. if the table is very large and analyzing takes a while just to have a backup of previous stats). Here's the syntax: SQL> exec dbms_stats.export_table_stats('SCHEMA_OWNER', 'TABLE_NAME', NULL, 'STATS_TABLE_NAME', 'STATID', TRUE, 'SCHEMA_OF_STATS_TABLE');
     
More...

06/27/07
 
 
Category : Databases > Oracle > Performance Tuning
 
 
 Script to analyze table subpartitions
This script will analyze specified subpartitions in a loop, useful when some partitions / subpartitions in the table have been modified or re-built. BEGIN FOR rec IN (SELECT subpartition_name FROM all_tab_subpartitions WHERE table_owner = 'SCHEMA_OWNER' ...
 More...
06/27/07
 
 
Category : Databases > Oracle > Performance Tuning
 
 
 How to run sapinst on different port
When you have (or planning to have) more than one SAP instance on the same server, it may happen that you will need to run SAPinst at the same time as somebody else. If you attempt to run it on default port it will not start, the solution is to ...
     
More...

06/05/07
 
 
Category : ERP / CRM > SAP
 
 
 Copy filesystem to another filesystem using tar
We assume /source/dir is a filesystem, if there are other filesystems under /source/dir they will also be copied to /destination/dir cd /source/dir tar -cf - . | ( cd /destination/dir ; tar -xpvf - )
     
More...

05/18/07
 
 
Category : Operating Systems > Unix
 
 
 Unlock shadow instance
To login to the shadow instance with a user account other than SAP* or DDIC you need to unlock it: 1. Log on as user adm 2. Enter the following command (this assumes you use /usr/sap/put as your upgrade directory): cd /usr/sap/put/bin ./R3up unlockshd or ./SAPup unlockshd If shadow instance isn't running you can ...
     
More...

05/18/07
 
 
Category : ERP / CRM > SAP
 
 
 Remove old archive logs
grep '.arc' brarchive.log | grep ARCHIVE | grep -v '.dbf' | grep -v '.cds' | \ awk '{printf("rm %s\n", $2)}' > rm_old_logs.ksh
 More...
05/17/07
 
 
Category : ERP / CRM > SAP
 
 
 How to disable popup - Ran out of profile storage space
Sometimes roaming profiles can be real pain, i.e. if you are running a software installation across the network and the installer fills up your profile directory (for example java puts alot of crap there). What you get is pop-up window coming up every few seconds notifying you that you're out ...
     
More...

05/07/07
 
 
Category : Operating Systems > Windows
 
 
 How to manually clean up shared memory / semaphors
This procedure may be useful for something like Oracle database, SAP or Peoplesoft when application was shutdown but shared memory hasn't been clened up for some reason. Get the list of all semaphors for a user: ipcs | grep [username] Remove (clean up) semaphor: ipcrm -s [semaphor id] You can also use the command below ...
     
More...

04/26/07
 
 
Category : Operating Systems > Unix > SUN Solaris
 
 
 Change client_encoding in psql
Example - this will set encoding to cyrillic WIN1251: set client_encoding to 'WIN';
     
More...

03/30/07
 
 
Category : Databases > PostgreSQL
 
 


<< 1 | 2 | 3 | 4 | 5 | 6 | Page 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 >>

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com