onstat -u shows reads

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/