OraFAQ Forum: Linux » Trying to sort out uniq tables from Gather stat job trace

Home » Infrastructure » Linux » Trying to sort out uniq tables from Gather stat job trace (RDBMS 11.2.0.2 RHEL6 x64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trying to sort out uniq tables from Gather stat job trace [message #525038]

Wed, 28 September 2011 08:49

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

Im trying to sort out uniq tables from a trace file which is creted after a failed gather stat job (timeframe to short).

I would like to get out only a uniq tablename.

The file looks like this:

...
"PHA"."tableOne"."partition1"
"PHA"."tableOne"."partition2"
"PHA"."tableOne"."partition3"
"PHA"."tableOne"."partition4"
...

I try this:

awk -F. '/TABLE: "PHA"\./ {print $2} ' PHAPROD_j002_3819.trc sort|uniq

But then I get multiple table names of the same table (I guess because of the partitions)

How do I get around this?

Regards
H

[Updated on: Wed, 28 September 2011 09:10]

Report message to a moderator

Re: Trying to sort out uniq tables from Gather stat job trace [message #525056 is a reply to message #525038]

Wed, 28 September 2011 10:33

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

cut -f1-2 -d. | sort -u

Regards
Michel

Report message to a moderator

Re: Trying to sort out uniq tables from Gather stat job trace [message #525110 is a reply to message #525056]

Thu, 29 September 2011 02:42

hristo
Messages: 258
Registered: May 2007

Senior Member

As always, Michel, you provide a good answer, thanks!

Report message to a moderator

Previous Topic:	DB creation with dbca command line
Next Topic:	Using Wine in Linux to run Developer 10g Forms/Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 20:06:55 CST 2024