You can try a parallel sql processing first - maybe it will help.
Ivo Libal
Knapp-systems
> -----Urspr=FCngliche Nachricht-----
> Von: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> Gesendet am: Dienstag, 20. Juni 2000 17:07
> An: Multiple recipients of list ORACLE-L
> Betreff: Block size or replication?
>=20
> We have an OLTP system that has frequent long running Crystal Reports
> reports that affect the overall online performance. We are looking =
at
> ways
> to improve response time. This is a purchased app and we do not =
modify
> code. We are looking at doing replication to offload some of the
> processing. But I am wondering if increasing the blocksize would be =
a
> better solution. The ad-hoc reports often do full table scans, as do =
the
> OLTP programs. This is even though there are indexes available. =
Remember
> we don't change code. The current block size is 4096. I would like =
to
> change it to 8192. I am thinking this would cut full table scan i/o =
in
> half
> and speed up processing. Any ideas?
>=20
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>=20
>=20
> --=20
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 20 2000 - 09:31:45 CDT
