Script to load daily average I/O stats from a .ksh file into Oracle db
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database
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)
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)
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)
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)
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)
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)
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)
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)
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 SUSE
opimport
OPIMPORT(1) General Commands Manual OPIMPORT(1)NAME
opimport - converts sample database files
SYNOPSIS
opimport [ options ] input_file
DESCRIPTION
opimport converts sample database files from a foreign binary format (abi) to the native format.
OPTIONS --abi / -a
Input abi file description location.
--force / -f
Force conversion even if the input and output abi are identical.
--output / -o filename
Specify the output filename. If the output file already exists it is not overwritten but data are accumulated in. Sample filename
are informative for post profile tools and must be kept identical, in other word the pathname from the first path component contain-
ing a '{' must be kept as it in the output filename.
--help / -? / --usage
Show help message.
--verbose / -V
Give verbose debugging output.
--version / -v
Show version.
ENVIRONMENT
No special environment variables are recognised by opimport
FILES
/var/lib/oprofile/abi
The abi file description of the sample database files
VERSION
This man page is current for oprofile-0.9.6.
SEE ALSO
/usr/share/doc/oprofile/, oprofile(1)4th Berkeley Distribution Tue 06 July 2010 OPIMPORT(1)