04-28-2010
No,
the delete performance has nothing to do with the fact that it's executed via shell script, rather than sqlplus or some other API.
A few thoughts:
1. If you delete every record in the table it is worth verifying if truncating the table is more appropriate.
2. If multiple partitions of a partitioned table are involved, try parallelizing the delete operation.
3. Verify if it is possible to implement partitioning, if not already implemented, and remove the data by dropping the unused partitions.
4. Check the wait events your operation is waiting on; the system optimization should be based on those events.
5. Check for before/after delete triggers defined on the table.
10 More Discussions You Might Find Interesting
1. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
2. Shell Programming and Scripting
Hi,
I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure)
While the command is running,I am able to view the log file created in the Unix machine.After the command... (2 Replies)
Discussion started by: ann_124
2 Replies
3. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
4. Shell Programming and Scripting
Hi ,
Can anyone help me regarding loading a unix file data to oracle database table using shell scripts?
I wanted to grep only this data from a spool file
sql_test.txt
99
00:00:00:01
but if I use grep I am getting format
sql_test.txt
99 rows selected.
Elapsed:... (2 Replies)
Discussion started by: ran16
2 Replies
5. HP-UX
Hi all,
I have to create table for each month inside a perl script.
tablename_monthnameyear.
megh_aug2008 for august 2008.
megh_sep2008 for september 2008.
just like the logfiles created on date basis.
thanks
megh (1 Reply)
Discussion started by: megh
1 Replies
6. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
7. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
8. Shell Programming and Scripting
Hi frndz,
Can anyone provide me some input or pseudo code for my req as mentioned below...
I am loading 2 files through unix script into oracle table...as i am doing some updates also i am getting an error where both files try to update the table simultaneously and my script fails..
so i... (3 Replies)
Discussion started by: gnnsprapa
3 Replies
9. UNIX and Linux Applications
Hello All,
I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated.
I'm setting below options :
SET... (4 Replies)
Discussion started by: venkat_reddy
4 Replies
10. Shell Programming and Scripting
Hello Folks,
I'm working on a requirement to automate the process of generating report(csv file) using metadata info stored in an Oracle table and E-mail it to respective people.
Meta data table:
Report_ID,Report_SUB_ID,Report_DB,Report_SQL,Report_to_email_Id
1,1,DEV,'select * From... (2 Replies)
Discussion started by: venkat_reddy
2 Replies
script(1) User Commands script(1)
NAME
script - make record of a terminal session
SYNOPSIS
script [-a] [filename]
DESCRIPTION
The script utility makes a record of everything printed on your screen. The record is written to filename. If no file name is given, the
record is saved in the file typescript. See WARNINGS.
The script command forks and creates a sub-shell, according to the value of $SHELL, and records the text from this session. The script ends
when the forked shell exits or when Control-d is typed.
OPTIONS
The following option is supported:
-a Appends the session record to filename, rather than overwriting it.
NOTES
script places everything that appears on the screen in filename, including prompts.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
WARNINGS
script can pose a security risk when used in directories that are writable by other users (for example, /tmp), especially when run by a
privileged user, that is, root. Be sure that typescript is not a link before running script.
SunOS 5.10 30 Jan 2004 script(1)