10-08-2012
Hi Jim, thanks for ur response, the table does not exist i have to create a table, as for the table column names i have to use the ones in the output, the data type is INTEGER,except the for column:Device
---------- Post updated at 04:24 PM ---------- Previous update was at 04:15 PM ----------
these are the column name: r/s, w/s, kr/s, kw/s, wait, actv, wsvc_t, asvc_t, %w, %b, device
---------- Post updated at 05:00 PM ---------- Previous update was at 04:24 PM ----------
PLEASE CLARIFY IF I HAVE TO WRITE TWO SCRIPTS OR JUST ONLY THE CONTROL FILE?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies
2. Shell Programming and Scripting
Hi all,
I'm traying to run a script on Unix with in it sql +.
In this script I want to load a externall file that stand on my unix system into a tmp table of a oracle db, but for some reason it won't work.
Find below the script.
#!/bin/ksh
ORACLE_SID=db1... (7 Replies)
Discussion started by: Tuut-Tuut
7 Replies
3. Shell Programming and Scripting
Hi! I've make a script that gets a list of 200 Ip's and calls another script once per ip in a infinite loop with a pause of 10 seconds. So It calls over 200 times every 10 seconds the second script (that makes a fping). But this cause a load average of 30. I've been reading about this and I... (4 Replies)
Discussion started by: charlscross
4 Replies
4. Shell Programming and Scripting
Hello everyone,
I am new to shell scripting/ loading data into a database.
I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies
5. UNIX for Dummies Questions & Answers
how load average is calculated and what exactly is it
difference between cpu% and load average (9 Replies)
Discussion started by: robo
9 Replies
6. Shell Programming and Scripting
Hello
I have created next scritpt to do the next: chekp if host is alive. When the host down, launch telnet other equip to do checks.
When execute the script the load average of the machines increase. For example:
Before launch script
top - 11:14:56 up 14 days, 18:06, 3 users, load... (3 Replies)
Discussion started by: capilla
3 Replies
7. Shell Programming and Scripting
Hi ,
I am trying to automate a gather stats in shell script
#!/usr/bin/ksh
export ORACLE_HOME=/orcl/app/oracle/product/11.2.0.1/db_1
export PATH="$PATH:$ORACLE_HOME/bin"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib32"
export TNS_ADMIN=/opt/netprobe/config... (1 Reply)
Discussion started by: neil.k
1 Replies
8. Red Hat
Hi,
Is there a way that I can find the load usage stats on a cluster (Redhat 4.8)? I want to find out if my jobs are using too many resources. I am not a sys admin.
Also, apart from 'top', what other commands can be used to monitor your own jobs as an ordinary user?
thanks!! (1 Reply)
Discussion started by: pc2001
1 Replies
9. Shell Programming and Scripting
Hi,
I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop.
The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Discussion started by: newbie_01
2 Replies
10. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT CENTOS
truncate
TRUNCATE(1) User Commands TRUNCATE(1)
NAME
truncate - shrink or extend the size of a file to the specified size
SYNOPSIS
truncate OPTION... FILE...
DESCRIPTION
Shrink or extend the size of each FILE to the specified size
A FILE argument that does not exist is created.
If a FILE is larger than the specified size, the extra data is lost. If a FILE is shorter, it is extended and the extended part (hole)
reads as zero bytes.
Mandatory arguments to long options are mandatory for short options too.
-c, --no-create
do not create any files
-o, --io-blocks
treat SIZE as number of IO blocks instead of bytes
-r, --reference=RFILE
base size on RFILE
-s, --size=SIZE
set or adjust the file size by SIZE bytes
--help display this help and exit
--version
output version information and exit
SIZE is an integer and optional unit (example: 10M is 10*1024*1024). Units are K, M, G, T, P, E, Z, Y (powers of 1024) or KB, MB, ...
(powers of 1000).
SIZE may also be prefixed by one of the following modifying characters: '+' extend by, '-' reduce by, '<' at most, '>' at least, '/' round
down to multiple of, '%' round up to multiple of.
GNU coreutils online help: <http://www.gnu.org/software/coreutils/> Report truncate translation bugs to <http://translationpro-
ject.org/team/>
AUTHOR
Written by Padraig Brady.
COPYRIGHT
Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
dd(1), truncate(2), ftruncate(2)
The full documentation for truncate is maintained as a Texinfo manual. If the info and truncate programs are properly installed at your
site, the command
info coreutils 'truncate invocation'
should give you access to the complete manual.
GNU coreutils 8.22 June 2014 TRUNCATE(1)