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