Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to Change parameter at statement level

Re: how to Change parameter at statement level

From: chao_ping <zhuchao_at_gmail.com>
Date: 24 May 2005 23:15:05 -0700
Message-ID: <1117001705.244281.151300@z14g2000cwz.googlegroups.com> 





You keep on talking about something I don't care about.
I have control on all the database, including local/remote.



I don't want to change the initsid.ora , I just want to change this
specific SQL (doing index fast full scan) execution behavior.



My above sample just shows I want to get such a result. I can't change
the session doing index ffs 's DFMBC. I am trying to get that changed
at that statement leve.



I don't want to create a logon trigger and do alter session set
db_file_multiblock_read_count=128 for that session.
Received on Wed May 25 2005 - 01:15:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US