RE: Analyze table different behaviour

A better reward would be if some La chouffe this showed up at my house


From: [email protected] [mailto:[email protected]] On Behalf Of Donna Buskirk
Sent: Tuesday, July 17, 2012 8:05 AM
To: [email protected]; [email protected]
Subject: [toadbeta] RE: Analyze table different behaviour




Kudos, John, for finding the solution in Help!

As a reward, I may let you help me update Help content for 11.6.

;-)

Donna D. Buskirk
Content Developer|Toad for Oracle Quest Software - Simplicity at Work | 919.650.4505 | www.quest.com<http://www.quest.com/>

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of John Dorlon
Sent: July 17, 2012 9:02 AM
To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]>
Subject: [toadbeta] RE: Analyze table different behaviour



Look up SET ROLE in Toad’s help file.    This is possible already.

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Pluim, Dick
Sent: Tuesday, July 17, 2012 7:23 AM
To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]>
Subject: [toad] Analyze table different behaviour



Hi,

Happens as well in the beta as in the GA-release:

Situation: we have personal user-accounts. To 'do something' we have to explicitly issue the command 'set role dba'. After doing so in sqlplus I can issue 'analyze table perfstat.stats$latch estimate statistics' and the table gets analyzed. In Toad in the editor window this works like a charm as well, but when I'm in the schema browser, in the PERFSTAT-schema, Tables-tab and I use rightmouseclick to analyze the table, the 'Analyze all objects' window shows up and after pressing the green arrow I get the errormessage 'ORA-01031 Insufficient privileges'.

From the spool SQL-window:

----------------------------------
Timestamp: 14:12:38.306
Connect: NL_DBA@DB

----------------------------------
Session: NL_DBA@DB
Timestamp: 14:12:40.088
begin sys.dbms_application_info.set_module('TOAD background query session', null); end;

----------------------------------
Session: NL_DBA@DP
Timestamp: 14:12:40.100
Analyze Table PERFSTAT.STATS$LATCH
Estimate Statistics
Sample 1 Percent

----------------------------------
Session: NL_DBA@DB
Timestamp: 14:12:40.163
Analyze Table PERFSTAT.STATS$LATCH
Estimate Statistics
Sample 1 Percent
Error: ORA-01031: insufficient privileges


----------------------------------
Session: NL_DBA@DB
Timestamp: 14:12:41.922
select table_name name, num_rows, blocks, empty_blocks, avg_space, chain_cnt, avg_row_len
,sample_size, last_analyzed
, user_stats, global_stats
from DBA_ALL_TABLES
where owner = 'PERFSTAT'
and table_name in ('STATS$LATCH')

After granting the privilege 'Analyze any' to me explicitly the issue is solved.

Why is this different? Or am I overlooking something?

Kind regards / Met vriendelijke groet / Mit freundlichen Grüßen / Con respeto bueno / avec de sincères amitiés / pozdrowienia / hardik Shubhkamnaye / с дружеским приветом / 드림,

Dick Pluim
ATS NL Oracle
atos.net







Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien de integriteit van het bericht niet veilig gesteld is middels verzending via internet, kan Atos Nederland B.V. niet aansprakelijk worden gehouden voor de inhoud daarvan. Hoewel wij ons inspannen een virusvrij netwerk te hanteren, geven wij geen enkele garantie dat dit bericht virusvrij is, noch aanvaarden wij enige aansprakelijkheid voor de mogelijke aanwezigheid van een virus in dit bericht. Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder Atos Nederland B.V. goederen en/of diensten levert zijn met uitsluiting van alle andere voorwaarden de Leveringsvoorwaarden van Atos Nederland B.V. van toepassing. Deze worden u op aanvraag direct kosteloos toegezonden.

This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Nederland B.V. group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. On all offers and agreements under which Atos Nederland B.V. supplies goods and/or services of whatever nature, the Terms of Delivery from Atos Nederland B.V. exclusively apply. The Terms of Delivery shall be promptly submitted to you on your request.

Atos Nederland B.V. / Utrecht
KvK Utrecht 30132762