OraFAQ Forum: Server Utilities » TOP N SQL in dbms_workload

Home » RDBMS Server » Server Utilities » TOP N SQL in dbms_workload_repository, (Oracle 10.2.0, OEL 4)

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

TOP N SQL in dbms_workload_repository, [message #567327]

Wed, 26 September 2012 10:49

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

Hi to all;

SQL > desc dbms_workload_repository

I googled Mostly i got info about retention , interval , dbid ..
I could n't understand purpose of TOPnsql ..

topnsql IN NUMBER DEFAULT NULL,

Quote:

"topnsql IN NUMBER DEFAULT NULL, "
What is the special pupose of " TOP N SQL "DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS"
Someone setting topnsql =100 what it does ??

Thanks and Regards

Report message to a moderator

[Message index]

		TOP N SQL in dbms_workload_repository, By: thiyagusham on Wed, 26 September 2012 10:49
		Re: TOP N SQL in dbms_workload_repository, By: Michel Cadot on Wed, 26 September 2012 11:31

Previous Topic:	load query result in ms-excel sheet
Next Topic:	SQL Loader with WHEN and DISCARD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 05:17:19 CDT 2024