onstat -u shows reads
klawson asked why onstat -u showed some users with writes on a data warehouse where public has only read access. dareb suggested temporary tables and said onstat -g ses lists them, in a 'User-created Temp tables' section at the end, printed only if present. lawson_kris asked where they show up. No further confirmation of the cause.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
The tables on our data warehouse have only read access by public. An
onstat -u shows some users that have reads AND some writes, whilemost users only have reads.
Does anyone know what tables these queries would be writing to, and why
not all queries have a write??
Sent via Deja.com
http://www.deja.com/
temp- tables maybe? onstat -g ses for the session in question will
display any temp tables in use.
Bill
In article <954bm1$5ub$1@nnrp1.deja.com>,
klawson@aetinc.com wrote:
> The tables on our data warehouse have only read access by public. An
> onstat -u shows some users that have reads AND some writes, while> most users only have reads.
>
> Does anyone know what tables these queries would be writing to, and
why
> not all queries have a write??
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Do the temp tables would show up in the sql statement shown in the
onstat -g ses output or somewhere else in the output? If they show inthe sql statement then no temp tables are used.
In article <954d87$7hj$1@nnrp1.deja.com>,
dareb@my-deja.com wrote:
> temp- tables maybe? onstat -g ses for the session in question will
> display any temp tables in use.
>
> Bill
>
> In article <954bm1$5ub$1@nnrp1.deja.com>,
> klawson@aetinc.com wrote:
> > The tables on our data warehouse have only read access by public.
An
> > onstat -u shows some users that have reads AND some writes, while> > most users only have reads.
> >
> > Does anyone know what tables these queries would be writing to, and
> why
> > not all queries have a write??
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Last item in the onstat output under heading:
User-created Temp tables :
If none are created, no heading is printed.
Bill
In article <954ebn$8l4$1@nnrp1.deja.com>,
lawson_kris@my-deja.com wrote:
> Do the temp tables would show up in the sql statement shown in the
> onstat -g ses output or somewhere else in the output? If they show in> the sql statement then no temp tables are used.
>
> In article <954d87$7hj$1@nnrp1.deja.com>,
> dareb@my-deja.com wrote:
> > temp- tables maybe? onstat -g ses for the session in question will
> > display any temp tables in use.
> >
> > Bill
> >
> > In article <954bm1$5ub$1@nnrp1.deja.com>,
> > klawson@aetinc.com wrote:
> > > The tables on our data warehouse have only read access by public.
> An
> > > onstat -u shows some users that have reads AND some writes,while
> > > most users only have reads.
> > >
> > > Does anyone know what tables these queries would be writing to,
and
> > why
> > > not all queries have a write??
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/