Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: order by / sorting performance issue
Hi Roobaron,
What's work, you're confusing me (and probably most Australians :)
Actually, I'm a self confessed sports nut and with the Commonwealth Games on I'm in sporting heaven. One of the best things about having one's own Consulting business is picking where and when to work. By some incredible coincidence, I have only a few things on this week ...
Go for gold you Aussies !!
Richard
"roobaron" <member_at_dbforums.com> wrote in message
news:3d4607e4$5_at_news.usenetgateway.com...
> There is a sql script on ixora.com.au to check to see if you are hitting
> the disk for the sort. Called disk_sorts.sql Sorts in memory will be
> must faster than sorts to disk Run the script and modify the
> sort_area_size to make sure most sorts run in memory (provided you have
> enough memory).
>
> The other choice, overkill perhaps :) might be to use an index-organized
> table, organised on the order by column. or create an index which will
> satisfy the query, the optimiser could then choose to perform a full
> index scan...
>
> We are grasping at straws without seeing the SQL, the indexs on tables,
> the sort_area_size etc.
>
> Have Fun
>
> p.s. noticed there is few people from Aus. Is work slow eh?
>
>
>
> --
> An Oracle DBAs undocumented init.ora parameters
> _OVERCOME_POOR_DESIGN = TRUE
> _DISABLE_BAD_PERFORMANCE = TRUE
>
> An Oracle DBAs undocumented init.ora parameters
> _OVERCOME_POOR_DESIGN = TRUE
> _DISABLE_BAD_PERFORMANCE = TRUE
>
> An Oracle DBAs undocumented init.ora parameters
> _OVERCOME_POOR_DESIGN = TRUE
> _DISABLE_BAD_PERFORMANCE = TRUE
>
> Posted via dBforums
> http://dbforums.com
Received on Tue Jul 30 2002 - 03:03:20 CDT