tag:blogger.com,1999:blog-1550840387946350137.post275130430795485762..comments2022-04-03T00:39:35.304-07:00Comments on Performance Engineering and Capacity Planning: Temporary Tablespaces on Oracle - going the extra mileUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1550840387946350137.post-51800728226259135372010-02-12T15:16:47.751-08:002010-02-12T15:16:47.751-08:00Hi Vishal,
After you changed the parameters, did ...Hi Vishal,<br /><br />After you changed the parameters, did the number of waits reduce?<br /><br />Also was the test a hash join or a sort?<br /><br />Throughput and latency would depend on storage subsystem capabilities.<br /><br />Thanks<br />KrishnaSSKhttps://www.blogger.com/profile/01063233277470336458noreply@blogger.comtag:blogger.com,1999:blog-1550840387946350137.post-84613800913071562402010-02-12T13:22:29.041-08:002010-02-12T13:22:29.041-08:00After changing these parameters I still see lot of...After changing these parameters I still see lot of direct path read with p3=1 (ie 16k reads). I see large direct path reads as well p3=64 but overall throughput is same.Vishal Desaihttps://www.blogger.com/profile/13334117444053941401noreply@blogger.comtag:blogger.com,1999:blog-1550840387946350137.post-20770552491562391152010-02-12T13:21:09.004-08:002010-02-12T13:21:09.004-08:00I tried both parameters and I still see lot of dir...I tried both parameters and I still see lot of direct path read temp with p3=1 (ie 16k IO's). I also see large IO's with p3=64 but my overall throughput remains same.Vishal Desaihttps://www.blogger.com/profile/13334117444053941401noreply@blogger.comtag:blogger.com,1999:blog-1550840387946350137.post-37839385220135456582010-02-12T13:19:19.251-08:002010-02-12T13:19:19.251-08:00I ran into similar problem. Tried increasing both ...I ran into similar problem. Tried increasing both parameters but I still see lot of direct path read temp with p3=1. Good news is I also see few large IO's of 1 MB ie p3=64.Anonymousnoreply@blogger.com