Home » Infrastructure » Linux » Trying to sort out uniq tables from Gather stat job trace (RDBMS 11.2.0.2 RHEL6 x64)
Trying to sort out uniq tables from Gather stat job trace [message #525038] Wed, 28 September 2011 08:49 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65964
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cut -f1-2 -d. | sort -u

Regards
Michel
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 Go to previous message
hristo
Messages: 258
Registered: May 2007
Senior Member
As always, Michel, you provide a good answer, thanks!
Previous Topic: DB creation with dbca command line
Next Topic: Using Wine in Linux to run Developer 10g Forms/Reports
Goto Forum:
  


Current Time: Thu Nov 15 21:42:17 CST 2018