| | Korn shell arithmetic operations
Some basic examples of incrementing / decrementing variables in ksh.
# decrement count from 10 to 1
count=10 ; while [[ $count -gt ]] ; do echo $count ; (( count = $count -1 )) ; done
# set the value of var to 2
let "var = 1 + 1"
# set the ... | | More...
11/09/05 | | | | | | | | |
|
| | How to use cut
Here are some basic examples of using cut command. $ designates the shell prompt.
cut first 10 characters:
$ cut -c1-10
cut from third character to the end of the line
$ cut -c3-
cut 1 and 5 fields from passwd file
$ cut -f 1,5 -d : /etc/passwd
| | More...
11/09/05 | | | | | | | | |
|
| | How to delete a very large number of files on Unix
When you are trying to delete a very large number of files in a directory on Unix you may get an error message similar to this: "Argument list too long" (I also had this problem on Windows running cygwin). In this case you can use the following command, which will ... | | More...
11/09/05 | | | | | | | | |
|
| | How to enable trace in Oracle
1. Enable trace at instance level
Put the following line in init.ora. It will enable trace for all sessions and the background processes
sql_trace = TRUE
to disable trace:
sql_trace = FALSE
- or -
to enable tracing without restarting database run the following command in sqlplus
SQLPLUS> ALTER SYSTEM SET trace_enabled = TRUE;
to stop trace run:
SQLPLUS> ... | |  
More...
11/03/05 | | | | | | | | |
|
| | Show current transactions per user session
--
-- SQL script to show transactions for each user session
--
SELECT s.logon_time, t.start_time, oc.sql_text, s.username "User Name",
s.osuser "OS User", s.status "Status", lockwait "Lock Wait",
s.program "Program", s.logon_time "Connect Time", p.program "P Program",
si.physical_reads "Physical Reads", si.block_gets "Block Gets",
si.consistent_gets "Consistent Gets", si.block_changes "Block Changes",
si.consistent_changes "Consistent Changes", s.process "Process",
p.spid, p.pid, s.serial#, ... | | More...
11/03/05 | | | | | | | | |
|
| | Show locks per user session
--
-- View locked objects, object types and user info
--
SELECT d.owner, d.object_id, d.object_name, d.object_type, l.type, s.username, s.sid, s.serial#
FROM dba_objects d, v$lock l, v$session s
WHERE d.object_id = l.id1
AND l.sid = s.sid
AND owner 'SYS'
ORDER BY d.object_name
/
| | 
More...
11/03/05 | | | | | | | | |
|
| | Scripts to backup Oracle database on Windows NT
Here's a set of scripts to do database export, full database backup (putting tablespaces in backup mode, not using RMAN) and scan the backup logs on Windows NT. The datafiles are first copied to another filesystem using ocopy and then backuped with ntbackup. You can also see some examples of ... | |
More...
11/03/05 | | | | | | | | |
|
| | How to enable Oracle listener tracing
1. Enable tracing
LSNRCTL> set trc_level ADMIN
2. Disable tracing
LSNRCTL> set trc_level OFF
3. Format the trace file using trcasst utility. The command line options for trcasst may vary from version to version, so check what options are supported by your installation.
trcasst [options] [filename] | | More...
11/02/05 | | | | | | | | |
|
| | RMAN reports corrupted blocks after migration
After database migration from 7.3.4 to 8.1.7 RMAN may report block corruption in number of segments (when using logical check in the backup script) but in fact there isn't corruption.
If index blocks are reported corrupted you can check it by running:
ANALYZE INDEX index_name VALIDATE STRUCTURE;
or if you cannot afford locking ... | | More...
10/28/05 | | | | | | | | |
|
| | Find segments with corrupted blocks
RMAN picks up logical block corruption when you use the following option in your backup script:
backup full check logical
The following procedure helps to identify segments with corrupted blocks if there are many occurrences of block corruption in the alert log file:
1. Get the list of all currupted blocks (replace alert_DB.log ... | |
More...
10/28/05 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Page 13 | 14 | 15 | 16 | 17 >>
|
