Script to load daily average I/O stats from a .ksh file into Oracle db

Shell Programming and Scripting
1

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

2

That output is from iostat, but we can't help you without knowing the name of the table and the table column names and datatypes. (describe gives that information)

3

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?