RE: Re: Analyze table different behaviour

Mine is in:-

C:\Users\<username>\AppData\Roaming\Quest Software\Toad for Oracle\11.5\User Files

Regards,

Mike McAllister 
Principal Systems Engineer
Decypher
DSN:                      487-3751
Commercial:       (210) 652-3751
Cell:                       (512) 423-7447
Email:                    [email protected]


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Lovelady, Dennis E.
Sent: Wednesday, July 18, 2012 2:33 PM
To: [email protected]
Subject: RE: [toad] Re: Analyze table different behaviour

  

No, nobody knows.


It’s one of those troublesome questions like “Why is the sky blue,” or “Why is Mickey Mouse’s voice higher than Mini’s?”

 

Oh very well, if you insist.  Mine is in My Documents\PeopleSoft\Toad\User Files.  That’s probably a result of setting the GENERAL option Application Folder to  My Documents\PeopleSoft\Toad

 

So have a look at your general options, note the Application Data Directory folder and go from there….  At least, works for me.  And you may no longer have to wonder where those ubiquitous little gnats come from when you place a peach on your counter.  How DO they know, anyway?  But it’s OK - they’re great TOAD food!

 

---
Description: C:\Documents and Settings\dlovelad.CORP\Application Data\Microsoft\Signatures\Default_files\image004.png          DTCC Confidential (Yellow)
Dennis Lovelady
813-470-2795
CONNECT... to the future. 

 

From: [email protected] [mailto:[email protected]] On Behalf Of Bheemsen
Sent: Wednesday, July 18, 2012 3:23 PM
To: [email protected]
Subject: [toad] Re: Analyze table different behaviour

 

  

Does anyone know the location of Toad.ini file? I could not find it for version 11.5.1.

Thanks

--- In [email protected] <mailto:toad%40yahoogroups.com> , John Dorlon <john.dorlon@...> wrote:
>
> I would definitely like to make another trip to Belgium someday. Besides good beer, I also remember good chocolate and good food.
> 
> From: [email protected] <mailto:toadbeta%40yahoogroups.com>  
> [mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> ] 
> On Behalf Of Pluim, Dick
> Sent: Tuesday, July 17, 2012 10:19 AM
> To: [email protected] <mailto:toadbeta%40yahoogroups.com> ; 
> [email protected] <mailto:toad%40yahoogroups.com>
> Subject: [toadbeta] RE: Analyze table different behaviour
> 
> 
> 
> 
> I’ll take a look at the way do it through the TOAD.INI-file.
> 
> Offtopic: And if the La Chouffe is hard to get overthere, consider 
> another trip to Belgium. They have a lot of great beers. Fortunately a 
> lot to be found in the shops in the Netherlands. ;-)
> 
> Kind regards / Met vriendelijke groet / Mit freundlichen Grüßen / 
> Con respeto bueno / avec de sincères amitiés / pozdrowienia / hardik 
> Shubhkamnaye / с дружеским приветом / ë"œë¦¼,
> [Description: cid:480124009@19092011-263E] Dick Pluim ATS NL Oracle 
> atos.net
> [Description: cid:480124009@19092011-2645]
> 
> From: [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> > 
> [mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> 
> ]<mailto:[mailto:[email protected] 
> <mailto:toadbeta%40yahoogroups.com> ]> On Behalf Of John Dorlon
> Sent: dinsdag 17 juli 2012 17:09
> To: [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> 
> >; [email protected] <mailto:toad%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toad%40yahoogroups.com> >
> Subject: [toadbeta] RE: Analyze table different behaviour
> 
> 
> Hi Dick,
> 
> I didn’t mean to use a glogin script. If you add the SET ROLE section to your toad.ini file as described in the help, Toad will run whatever set role commands you configure for every connection we make. You can configure it to only happen on certain databases or when connected as certain users, etc.
> 
> If only I could find La Chouffe nearby! The last time I had it was about 15 years ago when I was in Belgium, but it made a lasting impression.
> 
> -John
> 
> From: [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> > 
> [mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> 
> ]<mailto:[mailto:[email protected] 
> <mailto:toadbeta%40yahoogroups.com> ]> On Behalf Of Pluim, Dick
> Sent: Tuesday, July 17, 2012 10:02 AM
> To: [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> 
> >; [email protected] <mailto:toad%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toad%40yahoogroups.com> >
> Subject: [toadbeta] RE: Analyze table different behaviour
> 
> 
> 
> 
> Yep, I now start automagically a glogin.sql-script which issues the 
> command for me, but to solve the ORA-1031-errormessage I have to add a 
> line to it: grant analyze any to me; ;-)
> 
> And for John: La Chouffe is a good idea. Have to grab some bottles as 
> well. ;-)
> 
> Kind regards / Met vriendelijke groet / Mit freundlichen Grüßen / 
> Con respeto bueno / avec de sincères amitiés / pozdrowienia / hardik 
> Shubhkamnaye / с дружеским приветом / ë"œë¦¼,
> [Description: cid:480124009@19092011-263E] Dick Pluim ATS NL Oracle 
> atos.net
> [Description: cid:480124009@19092011-2645]
> 
> From: [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> > 
> [mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> 
> ]<mailto:[mailto:[email protected] 
> <mailto:toadbeta%40yahoogroups.com> ]> On Behalf Of John Dorlon
> Sent: dinsdag 17 juli 2012 15:02
> To: [email protected] <mailto:toad%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toad%40yahoogroups.com> >; 
> [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> >
> Subject: [toadbeta] RE: Analyze table different behaviour
> 
> 
> Look up SET ROLE in Toad’s help file. This is possible already.
> 
> From: [email protected] <mailto:toad%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toad%40yahoogroups.com> > 
> [mailto:[email protected] <mailto:toad%40yahoogroups.com> 
> ]<mailto:[mailto:[email protected] <mailto:toad%40yahoogroups.com> 
> ]> On Behalf Of Pluim, Dick
> Sent: Tuesday, July 17, 2012 7:23 AM
> To: [email protected] <mailto:toad%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toad%40yahoogroups.com> >; 
> [email protected] <mailto:toadbeta%40yahoogroups.com> 
> <mailto:[email protected] <mailto:toadbeta%40yahoogroups.com> >
> 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
> 
> 
> 
> 
> 
> 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
> 
> 
> 
> 
> 
> 
> 
> 
> 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
>


_____________________________________________________________
DTCC DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify us immediately and delete the email and any attachments from your system. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.