Article View: borland.public.jbuilder.database
Article #393Re: Database Pilot issues analyze statement
From: Tim Truman
Date: Tue, 18 Oct 2005 14:19
Date: Tue, 18 Oct 2005 14:19
21 lines
1919 bytes
1919 bytes
>Hint: Try Squirrel. Does it exhibit the same behavior? >http://squirrel-sql.sourceforge.net/ Yes. When the metadata indexes tab is selected. Scary. But I would guess the code could be modified to eliminate this behavior. I have read numerous documents and articles up to this point. It would seem the only way to quickly solve the issue is to provide a single user account for each developer and grant in the objects they need access to. Keeping access to production schemas off limits. I am perplexed however as to why these tools issue commands that affect the operation behavior of the database. ANALYZE is a well documented command affecting the operation of the CBO. In any event, thank you Paul (TeamB) for taking interest in my issue and providing assitance. It is appreciated. Tim Truman Oracle DBA
Technical Details
Message-ID:
<43550460$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<434d2add$1@newsgroups.borland.com> <434de09f$1@newsgroups.borland.com> <434ec516$1@newsgroups.borland.com> <43502088$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,9271f20c522d59c5 X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Tim Truman" <ttruman@nospam.com> Sender: "Tim Truman" <ttruman@nospam.com> Reply-To: "Tim Truman" <ttruman@nospam.com> Subject: Re: Database Pilot issues analyze statement Newsgroups: borland.public.jbuilder.database X-User-Info: 65.75.48.125 References: <434d2add$1@newsgroups.borland.com> <434de09f$1@newsgroups.borland.com> <434ec516$1@newsgroups.borland.com> <43502088$1@newsgroups.borland.com> NNTP-Posting-Host: 207.105.83.66 Message-ID: <43550460$1@newsgroups.borland.com> Date: 18 Oct 2005 07:19:12 -0700 X-Trace: newsgroups.borland.com 1129645152 207.105.83.66 (18 Oct 2005 07:19:12 -0700) Lines: 21 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail