Search Results

it is working fine. Many thanks for your support.

Thanks for your response. But I am getting wrong output as below. Do I need to change anything?


0GB /dborafiles/nethealth21/PV/oradata01
0GB /dborafiles/nethealth21/PV/oradata02
0GB...

space_used.lst


/dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata01 505G 318G 175G 65% /dborafiles/nethealth21/PV/oradata01
/dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata02 505G 433G 67G 87%...

Thanks for the quick reply.

I think gnu is not installed for me.

$ uname -a
SunOS osp2pits03-th 5.10 Generic_118833-02 sun4u sparc SUNW,Sun-Fire-V440

But perl -MPOSIX -e 'print...

Hi,

date now +6 days '+%m/%d/20%y' is not working in solaris.

And I need to do in the shell itself. I cant do in oracle prompt. because the requirement is as such.

So can u pls help me...

Thank you very much.

Can you pls tell me how can I find the current_date+6days date? I mean if I run a script today it should print 22/11/2009.

Important thing is it should work for all the...

Thanks guys.

Yes. the problem was the space . Now it is working fine.

am running the small script below.

count_a=48
count_b=48
if [$count_a -eq $count_b]; then
echo "Count matched"
else
echo "count not matched"
fi

I got the below output.

/bin/ksh:...

Thanks methyl. I selected the partition name through the way as below.

partition_name=sed '/^$/d' partition_name.lst|awk '{print $3,$1}'|sort -n|head -1|awk '{print $2}'
echo $partition_name
...

Hi methyl,

or I can select another one column also with that partition name as below.

SQL> select partition_name,high_value from user_tab_partitions where table_name='USER_AUDIT';...

Hi Folks,

Currently am working with 10g db. I want to sort the below o/p.
Current output:
============
SQL> select partition_name from user_tab_partitions where table_name='USER_AUDIT';
...

Hi Durden,

Thanks a lot. It is working fine.

Can you help me once again to suppress the below coloured things?

ID JOB_ID ELAPSED_TIME DIFF from to
----- ...

Hi guru's,

Am new to shell scripting.
I am getting the below o/p from the oracle database, when I fire a query.

ID JOB_ID ELAPSED_TIME FROM TO
----- ------ ...