Hi John ,
i have mailed a doc . have a look at it .
Regards,
Prem.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Does anyone have examples of how to use bind variables in VB
when using
OO4O?
John
--
Please see the official ORACLE-L FAQ:
(BBASSI-CHQ) To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
rivaldi.bahar@b cc:
bassi.com Subject: RE: Bind variables
Sent by:
[EMAIL PROTECTED
TMTOWTDI ... It's everywhere.
All these choices. Why do they have to make life so complicated?
I'm just curious: How do you turn if off?
level(0)?
-Original Message-
Hi, in 8i etc, you can use
dbms_system.set_ev(sid,serial#,10046,level(1-12),'') too.
--
Please see
alter session set events '10046 trace name context off'
or
exec sys.dbms_system.set_ev(sid, serial#, 10046, 0, '')
Richard Ji
-Original Message-
Sent: Tuesday, February 11, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L
TMTOWTDI ... It's everywhere.
All these choices. Why do
In order to see the actual value of bind variables, you need to use
event 10046 with level 4.
from your procedure do:
alter session set events '10046 trace name context forever, level 4'
Richard
-Original Message-
Sent: Monday, February 10, 2003 12:29 PM
To: Multiple recipients of list
It worked well from SQLplus but not from procedure.
Did I miss something ?
SQLcreate or replace procedure testtrace
2 as
3vempno varchar2(3);
4vempno1 varchar2(3);
5begin
6 ALTER Session SET EVENTS '10046 trace name context forever, level 4';
7 select empno
You might try playing around with the DBMS_SUPPORT package which is loaded
with the dbmssupp.sql script in the rdbms/admin directory.
dbms_support.start_trace_in_session(SID, SERIAL#, waits=false, binds=true)
dbms_support.stop_trace_in_session(SID, SERIAL#).
-Original Message-
It
alter session is DDL, you should do:
execute immediate 'ALTER Session SET EVENTS ''10046 trace name context
forever, level 4''';
Richard
-Original Message-
Sent: Monday, February 10, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
It worked well from SQLplus but not from
: Bind variables
Sent by:
[EMAIL PROTECTED
Try
exec sql alter session set events .
Rajesh
-Original Message-
Sent: Monday, February 10, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L
It worked well from SQLplus but not from procedure.
Did I miss something ?
SQLcreate or replace procedure testtrace
2
Stephen,
What version of oracle are you talking about?
I didn't find dbms_support in 9.2.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 10, 2003 3:43 PM
You might try playing around
You have to load it by running the dbmssupp.sql script in the ?/rdbms/admin
directory.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Bind variables
Stephen,
What
Hi Bahar,
If you run it on form you can find out the values by debugging that
'procedure testproc'.
Rgrds,
Sony
-Original Message-
From: Bahar, Rivaldi (BBASSI-CHQ) [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:29 AM
To: Multiple recipients of list ORACLE-L
the dbmssupp.sql script in the ?/rdbms/admin
directory.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Bind variables
Stephen,
What version of oracle are you talking
Hi Nicoll,
The importance of bind variables, to use in OLTP application is such that if
we use, we survive else one or the other day we would feel uncomfortable
over the performance issues and would repent over the scalability of the
application.
Yes, if we use bind variables, the parser does
Yes.
-Original Message-
Sent: Friday, September 06, 2002 4:28 PM
To: Multiple recipients of list ORACLE-L
Kevin,
Are you saying then, that by default, any static
statement that is executed within PL/SQL will not have
be re-parsed eg
sp_proc(var in varchar2)
as
begin
select
If you want to show anyone the different in seed between using bind
variables and not using them Tom Kyte's Expert one on one got a nice
example, it is in chap 2 or 3 I think.
George
George Leonard
Oracle Database Administrator
Dimension Data
Actually its easy. Any variable declared in PL/SQL and referenced in a
non-dynamic SQL statement is a bind variable.
In the following example (#1), some_var is an output bind-variable and
other_var is a input bind variable. PL/SQL does manipulation on the
statement and will send something like
You probably already are. You have to go to a lot of trouble to avoid
using bind variables in PL/SQL. (I'm too lazy^H^H^H^H busy to find the doc
link right now.)
-- Philip
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 06, 2002
Kevin,
Are you saying then, that by default, any static
statement that is executed within PL/SQL will not have
be re-parsed eg
sp_proc(var in varchar2)
as
begin
select last_name
from emp
where last_name = var;
end;
If that's the case, I wont have to change much code.
mkb
--- Toepke,
Someone pointed me towards these articles when I asked this question a week
or two ago:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdobjparameter.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdmscadoobjmod.asp
-Original
What percentage are you estimating? Have you played with that?
-Original Message-
Sent: Saturday, October 20, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L
I have always used the CBO and statistics are generated fairly regularly. I
use the analyze table estimate statistics
Danny,
I'll bet my morning cheese danish that when you changed the SQL from using
literals to bind variables, the execution plan changed.
Just pull each SQL statement and run it in SQL*Plus, one version of it with
literals and the other with bind variables. The difference in your web page
Danny,
Have you tried generating explain plans with and
without bind variables and comparing them? That
should help you identify if it's truly related to bind
variables. What are the wait events for the queries
that are running slower?
HTH,
-- Anita
--- Danny Hughes [EMAIL PROTECTED] wrote:
Hi Greg and list,
I'm not convinced of John's conclusion that 'cursor_sharing' = FORCE outperforms bind
variables. Some months ago I tried
to reproduce John's results and was not able to, despite trying several different
variations on the tests. Tom Kyte
claims that 'cursor_sharing' is about
I have always used the CBO and statistics are generated fairly regularly. I use the
analyze table estimate statistics which should not generate histogram information. I
have even used the INDEX, FIRST_ROWS, and ALL_ROWS hints. None made a difference. I
regenerated the statistics on all
Danny,
Were you using histograms? Histograms do not work on bind variables,
they only work on literals.
I'm sure others will have more to say on the topic but that is one tidbit
that
I do have experience with on bind variables.
Cherie Machler
Oracle DBA
Gelco Information Network
Danny,
It sounds like when you ...moved to bind variables... you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.
I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so
Danny,
It sounds like when you ...moved to bind variables... you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.
I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so
Danny,
It sounds like when you ...moved to bind variables... you did two things:
1. Switched to using CBO
2. Changed your application to take advantage of the bind variables.
I have never heard of switching to bind variables making things slower (and
can not imagine when it would make it so
I have heard of it. Its a concern. However, with hints you can
solve some of your problems. And then you could use Stored Outlines
and get it stable. And then life will be groovy.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 3:45 PM
To: Multiple
Danny,
Bind variables are nearly always better than literals in your SQL.
The one exception I can think of is if you are making using of histograms,
but those aren't often used in OLTP type apps.
Without sitting down and analyzing what was taking place, all anyone
can do is guess. If you
32 matches
Mail list logo
