• 博客访问: 96958
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02





发布时间:2005-04-06 10:35:51

with sum_obj as(    select        nvl(county_code,'合计') county_code,        sum(case when color_flag = 0 then objective else 0 end) t_red,        sum(case when color_flag = 3 then objective else 0 end) t_yellow,        sum(objective) t_total,        sum(case when kind = 1 and color_flag = 0 then objective else 0 end) a_red, &#......【阅读全文】

阅读(1023) | 评论(0) | 转发(0)

发布时间:2005-04-04 11:22:30

Thanks for the quick response.Is there a way to force temp files to be created as non-sparse files in UNIX ? Followup:  Here, I'll let you tech edit a new section of "expert one on one Oracle" 2cnd edition :)Temp FilesTemporary data files (temp files) in Oracle are a special type of data file. Oracle will use temporary files to store the intermediate results of a large sort operation, hash operations, global temporary table data, or result set, when there is insufficient memory to......【阅读全文】

阅读(1662) | 评论(0) | 转发(0)

发布时间:2005-04-04 05:50:54

  May 07, 2002 Reviewer:  A reader Hi Tom,When user is doing sort operation.oracle first do sort in memory(sort_area_size) and if the space is not enough it go to temporary tablespace(if temp tablespace is TEMP) and create TEMP SEGMENT for sorting.Once process is done with sorting oracle deallocate extents.Am i right?As far as i konw we only create TEMP tablespace ,How Sort segment are created?.and how many sort segment(max) can be in a database.2) If many session are performing sort o......【阅读全文】

阅读(3894) | 评论(0) | 转发(0)

发布时间:2005-04-01 09:41:17

Reviewer: A reader Hi I just asked about meaning of connect_timeout... I wanted to ask somthing more, in some servers when I try to connect such asscott/tiger@testif test is not defined in tnsnames.ora I get an error straight away however in some servers it takes ages to tell me the errorwhich parameter defines that interval? Followup: look in your sqlnet.ora -- there is an entry like:NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)so, for me, if tnsnames.ora lookup fails (no test), it'll tr......【阅读全文】

阅读(1873) | 评论(0) | 转发(0)

发布时间:2005-03-31 13:17:29

please correct me if my understanding is wrong.LIO - from/to the buffer cache ( not disk ).PIO - to/from the disk.correct ?in many of the threads on tuning i notice that you mention, the less the number of PIO as well as LIO the better. i can understand the 'physical' part of it but not the logical.the query has to get the results and it has to do as much work as is necessary to get it, isnt it ? so at least that much of LIO is a must. how can we reduce that ? Followup: LIO = logical = buffer......【阅读全文】

阅读(4051) | 评论(0) | 转发(0)

jametong2014-06-27 16:58


回复  |  举报

登录 注册