Sponsored Content
Top Forums Shell Programming and Scripting Delete oracle table from UNIX script Post 302416950 by radoulov on Wednesday 28th of April 2010 06:11:27 AM
Old 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

How can i load or insert a table in oracle from c language thru unix environment

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

update a oracle table using shell script

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

unix script for update or insert records from a file to a oracle table

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

unix file to oracle table

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

to create a oracle table in perl script

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

Insert into Oracle table thru UNIX - linux 2.6.9-89

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

Shell script to query Oracle table

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

How to lock Oracle table through UNIX?

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

UNIX spool command not extracting complete record from the Oracle table

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

Help Needed: UNIX shell variables to store Oracle table records

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
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
All times are GMT -4. The time now is 12:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy