Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help!
"J" <jungnaja_at_hotmail.com> wrote in message
news:d1au7k$a47$1_at_mailhub227.itcs.purdue.edu...
> I don't know how to ask this question. Well, I will give you information
> and hope someone can help me with this.
>
>
>
> We have an Oracle database for reporting. We all have READ access to this
> data warehouse. Most people will use Brioquery tool to access this data,
> but I used Microsoft Access via ODBC because I need to update the data in
> our local DB with the data returned from my queries running against the
data
> warehouse. I don't could use Brioquery because it is cumbersome for my
> particular need.
>
>
>
> One of the people at work told me this:
>
>
>
> The entire warehouse is stored in one location, and using any tool
>
> other than Brioquery keeps others from being able to query against
>
> the data when you run a row by row type of query to extract the
>
> data you need.
>
>
>
> Can anyone explain the above statements, please?
>
>
>
> Since this database is designed for reporting, I don't see how I kept
others
> from being able to query against the data when I ran MS Access queries
> against the data warehouse? There is no record-level locking when you use
> SELECT command, isn't this correct? BTW, this is not a performance issue.
>
>
>
> He claimed that the statistic told him the number of hits by me is 2.5
> millions in Feb, which is hard to believe. If a "hit" means a time I run
> the query, in order to reach 2.5 million hits, I have to run a query every
> second every day for 28 days.
>
>
>
> Thanks,
>
> J
>
>
>
In Oracle readers don't block writers. Sounds like a SQLServer DBA thinks
they understand how Oracle works.
Jim
Received on Wed Mar 16 2005 - 21:59:08 CST