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
LEARN ABOUT DEBIAN
acorn-fdisk
FDISK(8) BSD System Manager's Manual FDISK(8)
NAME
acorn-fdisk -- partition editor for Acorn/RISC OS machines
SYNOPSIS
acorn-fdisk -h | --help | -v | --version
acorn-fdisk [-t scheme | --type scheme] -l | --list [device ...]
acorn-fdisk [-t scheme | --type scheme] -s | --size partition
acorn-fdisk [-t scheme | --type scheme] [device]
DESCRIPTION
The acorn-fdisk utility allows one to display or interactively edit partition tables for Acorn/RISC OS machines in various formats. Using
the PC/BIOS format, standard IBM PC (i386) partition tables can also be accessed. When no optional device is given, it defaults to /dev/hda
or /dev/sda.
The options are as follows:
-h | --help Display a short usage and exit immediately.
-l | --list Display the partition table(s) of all devices.
-s | --size Display the size of partition.
-t | --type Select the partitioning scheme to use. Valid schemes are:
EESOX Eesox SCSI on the Acorn machines.
ICSIDEFS ICS IDE.
Filecore/Linux Linux on Filecore. This uses the non-ADFS descriptor to point to the start of the disc to be partitioned. The
first two sectors contain a partition table to identify the Linux partitions contained within.
PC/BIOS PC/BIOS partitioning scheme. This consists of a partition table in the first sector of the disk which contains
both CHS and LBA values for the partitions. There can be up to four entries in the primary partition table.
One of these can be an extended partition containing up to four extra partitions.
PowerTec PowerTec SCSI on the Acorn machines.
Filecore/RISCiX RiscIX on Filecore.
-v | --version
Display the version of acorn-fdisk and exit immediately.
If neither -l | --list or -s | --size are given, the partition table of the given device will be edited interactively.
EXAMPLES
Display the default device's partition table on a PC:
acorn-fdisk --type PC/BIOS -l
Display the PC partition table of /dev/sda:
acorn-fdisk --type PC/BIOS --list /dev/sda
Display the size in blocks of the partition /dev/sda1:
acorn-fdisk --type PC/BIOS --size /dev/sda1
Edit the MBR partition table interactively:
acorn-fdisk --type PC/BIOS
Display the partition table of an MBR backed up to a file:
acorn-fdisk -t PC/BIOS -l mbrdump.bin
Display the size of the first partition on a device where the MBR would be restored from the backup file mbrdump.bin:
acorn-fdisk -t PC/BIOS -s mbrdump.bin1
AUTHORS
arm-fdisk was written by Russell King <rmk@arm.uk.linux.org> based on util-linux fdisk, which was written at least partially by
A. V. Le Blanc <LeBlanc@mcc.ac.uk>.
This manual page was written for the Debian system by
Thorsten Glaser <tg@debian.org> but may be used by others.
BSD
October 2, 2010 BSD