Shell Programming and Scripting

hi, I am new to unix I have executed the following script :-

X=`sqlplus service/service@psmf.world <<eof
set serveroutput on;
set feedback off;
set linesize 1000;
select count(*) from table ;
EXIT;
eof`

echo $X>testing1.txt

.... and got the following output

vi testing1.txt
SQL*Plus: Release 9.2.0.5.0 - Production on Mon Mar 17 07:57:45 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production

SQL>
COUNT(*)
----------
270

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production


I only want output 270 in the file. How can i get this output? Please give your inputs

If you have questions do not hesitate to ask but start your own thread and don't hijack old threads.
Having said that, with awk you can get the value as follow:

Code:

awk '/----.*/{getline;print;exit}' testing1.txt

Regards

Hi Gauravah,

U should try the following to display only output without dispalying oracle messages

set heading off
set lines 500
set trimspool on
set trimout on
set echo off
set pagesize 0
set feedback off

try sqlplus -s user/password@database --(Use of -s option suppress the Oracle login messages)

thanks to everyone for help,
also I will be careful next time not to hijack anyone's post. sorry for that

Sorry for posting some Oracle related question in this forum as I don't know if any other place that I can post the question. I am sure there are many of you familiar with Oracle database and can answer my question.
My DBA recently written a analytic script to perform a table space analyse as well as reform of indexes in order to have a better performance on some application processes. The scripts that written by him is as follow :
======================
Analyze table GNMM_INTEREST_RATE_MASTER estimate statistics for table for all indexes for all indexed columns;
Analyze table PS_INTEREST_TRANSACTION_TEMP estimate statistics for table for all indexes for all indexed columns;
Analyze table PSDT_APL_TRANSACTION_BREAKUP estimate statistics for table for all indexes for all indexed columns;
Analyze table PSMT_CLEARANCE_MASTER estimate statistics for table for all indexes for all indexed columns;
Analyze table PSDT_CLEARANCE_DETAILS estimate statistics for table for all indexes for all indexed columns;
===========================
I can run the script on AIX platform with Oracle priviledge. And the application process run after the script will have a very much improve performance.

I have also found another scripts written by some other DBA from other company who claimed that is the same as the one I stated above. The scripts are as below :
=======================
create or replace
procedure BFN_ANALYZE_INT_ACCTABLES is

Begin
dbms_stats.gather_table_stats( ownname => 'PROD',
tabname => 'gnmm_interest_rate_master',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all indexed columns size auto',
cascade => true,
degree => 7
) ;
dbms_stats.gather_table_stats( ownname => 'PROD',
tabname => 'PS_INTEREST_TRANSACTION_TEMP',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all indexed columns size auto',
cascade => true,
degree => 7
) ;
dbms_stats.gather_table_stats( ownname => 'PROD',
tabname => 'PSDT_APL_TRANSACTION_BREAKUP',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all indexed columns size auto',
cascade => true,
degree => 7
) ;
dbms_stats.gather_table_stats( ownname => 'PROD',
tabname => 'PSMT_CLEARANCE_MASTER',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all indexed columns size auto',
cascade => true,
degree => 7
) ;
dbms_stats.gather_table_stats(ownname => 'PROD',
tabname => 'PSDT_CLEARANCE_DETAILS',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all indexed columns size auto',
cascade => true,
degree => 7
) ;
END BFN_ANALYZE_INT_ACCTABLES ;
====================================

I found that the above script doesn't have the same effect as the previous one which will improve performance of application processes.

Please advise whether the 2 scripts are similar or any differences that limited the performance?

Thanks in advance.

kwliew999

As mentioned above, if you have a question don't hijack a thread but start your own thread.

Regards