Removing the auto-commit sounds good, on condition, of course, that you
can afford to lose up to 999 recs in the event of a system crash. You
probably may want to write them to a temp storage table first
Chris
-Original Message-
Sent: 06 September 2002 09:28
To: Multiple
Marul,
I think this question needs to be answered, otherwise impossible to make
suggestions...
Chris
-Original Message-
Sent: 05 September 2002 08:18
To: Multiple recipients of list ORACLE-L
Marul, what i fail to understand is:
Are you running a batch job of inserting 350,000
Mahul,
Sounds a bit of a classic problem - optimum performance and availability
required with no time given for database admin/reorg work. One idea you
might think about is messy but could involve the following:
Step 1 Create 2 tables - Prob_table and prob_table_copy
Step 2 Create indexes on
Marul,
It sounds to me like the indexes are going into overflow - this will
cause the insert time to increase. I would suggest batching up the
inserts, dropping the indexes, running the inserts and re-creating
the indexes.
Chris
-Original Message-From: Marul Mehta
Good question, Jared! Perhaps 'overflow' is technically not the correct
term to use to decribe this scenario but it seemed to fit the bill
sufficiently to mail off a quick one-liner solution without going into great
depth. Some of us have work to do, you know ;)
To redeem myself I probably
Hannah,
I'm no Unix guru either but in this situation I use
'truss', e.g.
truss procname
HTH
Chris
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: 09 August 2002
16:08To: Multiple recipients of list ORACLE-LSubject:
Unix Script Quest : Urgent
Oops, missed a quotation mark in earlier posting. Should have read:
sqlplus -s / EOF | grep -v ^$ | sed -n '$p'
select sysdate from dual;
exit
EOF
Regards
Chris
-Original Message-
Sent: 24 July 2002 09:15
To: '[EMAIL PROTECTED]'
Ross,
You are hitting a couple of problems here:
Ross,
Not sure if original mail got through (looked garbled on Fatcity website) so
here goes again
You are hitting a couple of problems here:
1 - the 'tail' command needs to be on your first line (sqlplus / EOF |
tail -1)
2. However, I suspect this will not give you what you want as
Ross,
You are hitting a couple of problems here:
1 - the 'tail' command needs to be on your first line (sqlplus / EOF |
tail -1)
2. However, I suspect this will not give you what you want as sqlplus
prints a blank line at the end. Try the following:
sqlplus -s / EOF | grep -v ^$ | sed -n
It works for me. Using the following code:
#!/bin/ksh
#set -x
sqlplus / EOF | tail -1
select sysdate from dual;
exit
EOF
I get:
$ test.sh
JServer Release 8.1.7.0.0 - Production
$
With -x flag set:
$ test.sh
+ tail -1
+ sqlplus nri/nri
+ 0 /tmp/sh27884.2
JServer Release 8.1.7.0.0 -
Title: RE: Unix Q: ksh scripting
I also assumed you may want the last line (rather than
just sysdate) - grep -v ^$ | sed -n '$p' solution works for last
line too :)
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]]Sent: 24 July 2002
14:49To: Multiple
Title: UNIX help needed for sed multi-line pattern space
Alan,
Why not use awk?
cat filename | awk '{if (
substr($0,length($0),1) == ";") {print " " $0 } else {printf($0)
}}'
Hope this helps
Chris
-Original Message-From: Martin, Alan
[mailto:[EMAIL PROTECTED]]Sent: 15
12 matches
Mail list logo