one word ... CLOB field ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original
Hi List,
I have a web application that allows users to type notes with paragraphs.
Is it possiable to load the string with paragraphs into Oracle (not save the
note as a file)? Later on the application has to display the same format
for the note when the user queries that record on the web.
i hv to write an sql query in which i hv to fetch all the tables frm the
database having a column say EMPNO and where the value of this empno column
is say 9 and this should be thru a single sql query
is this possible ?
Thanks and Regds,
Rohan
EMPNO and where the value of this
empno column is say 9 and this should be thru a single sql query
is this possible ?
Thanks and Regds,
Rohan
_
Contact brides grooms FREE!
http://www.shaadi.com/ptnr.php?ptnr=hmltag Only
I know you can hint a fast full scan. I have run into cases lately where depending on
circumstances Oracle will use an index, but use a sub-optimal type of index scan with
dramatic differences in performances.
This is on 9.2. Any hints for forcing an 'index range scan'. Anything stronger than
put in a between clause in where clause on appropriate columns for a range scan.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have
You can have range scan with equality search (=) as well, if your index is
non-unique and there is no unique constraint on column.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 3:24 PM
put in a between clause
Hi.
tar already opened - awaiting feedback.
W2K Adv Svr Sp4
Oracle 9i R2 Std Ed 9.2.0.4
NTFS 5.0 filesystem
Dell 2650, PERC3/Di controller, writeback caching enabled
qa database, not a huge deal at the moment.
I have a backup controlfile, but would rather not open resetlogs, as there is a remote
Im familiar with top n queries. Im trying to tune an update and try to do it in one
update statement instead of a query. Im basically trying to update only the top N
fields.
Here is the cursor(I have rewritten it as an analytic function, but I really want it
as a single update. any
]Subject: how is it
possible
.com
10/23/2003 04:49
PM
Please respond to
ORACLE-L
This happening with me 3 rd time on this hp box . When I do ls -alt I can
see a file in current
PROTECTED]
Sent by: cc:
ml-errorsSubject: Re: how is it possible
]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: how is it possible
Thanks Ron ,
This worked . But do you know why it happens . As I said its happening
third
time with me . My unix screen behaves weired sometimes it doesn't print
any
character I type and some time it prints
]Subject: Re: how is it possible
.com
This happening with me 3 rd time on this hp box .
When I do ls -alt I can see a file in current directory but when I try to open
it (vi/cat ) it says no such file or directory . I am same user who
created the file . ( no permission problem )
Any idea ??
-ak
Likely there are non-printing characters in the name of
the file...
To see them, try ls -alt | od -c | more. To view, rename,
or delete the file, use wildcards...
This happening with me 3 rd time on this hp box . When I
do ls -alt I can see a file in current directory but when
I try to open
]Subject: how is it possible
.com
PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
how is it possible
This happening with me 3 rd time on this hp box . When I do ls -alt I can
see a file in current directory but when I try to open it (vi/cat ) it
says no such file or directory . I am same user who
Could it have some special characters in the name?
Try "cat *" instead.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 23, 2003 6:49
PM
Subject: how is it possible
This happening with me 3 rd time
: how is it possible
Date: Thu, 23 Oct 2003 14:49:24 -0800
This happening with me 3 rd time on this hp box . When I do ls -alt I can
see a file in current directory but when I try to open it (vi/cat ) it says
no such file or directory . I am same user who created the file . ( no
permission
Many
thanks to everyone who responded! Looks like the outcome will be PL/SQL
Developer licenses for our developers, while I get to keep my Toad Xpert / DBA
module. Thanks again for the useful insights!
Paul
Vincent
DBA
University of Central England
Paul,
I've used PL/SQL Developer by Allround Automations to develop PL/SQL procs,
packages and it's fine including a well featured de-bugger. I believe that a
site licence costs $3,000. As to it being a DBA tool I'd have to say it's
not in the same league as TOAD Xpert with DBA module.
Chris
there to replace TOAD and any small
licensing savings will be lost to lower productivity during the learning
curve anyway.
Regards,
Mark.
From: Dunscombe, Chris [EMAIL PROTECTED]
Date: Thu, 16 Oct 2003 07:50:30 +0100
Subject: RE: Opinions sought on possible TOAD replacement
Message-From: Rich Gesler
[mailto:[EMAIL PROTECTED] Sent: 2003-10-15 1:24
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Opinions sought on possible TOAD replacement
You
are correct in that it is very developer centric. As far, as hidden
charms...I'd have to say the Reports
the cost...
Tim
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday,
October 16, 2003 3:29 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Opinions sought on possible TOAD
replacement
We
do something similar here.
Developers gets
Paul Vincent
[EMAIL PROTECTED]
Sent
by: [EMAIL PROTECTED]
10/15/2003 08:59 AM
Please
respond to ORACLE-L
To:Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Opinions sought on
possible TOAD
]
cc:
Subject:RE: Opinions sought on possible TOAD replacement
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the
database servers are mostly Win2k.
Software $0.00
OS $0.0
HW $12k
A procedure return with no errors
Priceless
g
FWIW for a nice sql
Management have been grumbling about the cost of TOAD Professional
licenses, and have been "recommended" a cheaper product called PL/SQL Developer
by Allround Automations (available from Inthink Corporation at $150 a pop). Now,
I've been to the product website, and read up on all its
and $100 a license on Windows. This option
offers some middle ground anyway.
-Original Message-From: Paul Vincent
[mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003
11:59 AMTo: Multiple recipients of list ORACLE-LSubject:
Opinions sought on possible TOAD replacement
.
Download it and give it a try,
Rich
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Paul VincentSent:
Wednesday, October 15, 2003 11:59 AMTo: Multiple recipients of list
ORACLE-LSubject: Opinions sought on possible TOAD
replacement
Management have
PROTECTED]
Behalf Of
Paul Vincent
Sent: Wednesday, October 15, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD
Professional
licenses, and have been recommended a cheaper
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
11:59 AMTo: Multiple recipients of list ORACLE-LSubject:
Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD Professional
licenses, and have been "recommended" a cheaper product cal
TORA
-Original Message-From: Paul Vincent
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
10:59 AMTo: Multiple recipients of list ORACLE-LSubject:
Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD Professional
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD Professional licenses, and have been recommended a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink
is it possible to have a primary key that is enforced with a bitmap index?
if so what is the syntax?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
PROTECTED]
Sent: Tuesday, September 23, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
is it possible to have a primary key that is enforced with a bitmap
index?
if so what is the syntax?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET
] mailto:[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
is it possible to have a primary key that is enforced with a bitmap index?
if so what is the syntax?
--
Please see the official ORACLE-L FAQ
It's not possible:
SQL create bitmap index emp_empno_b on emp(empno);
Index created.
SQL alter table emp add constraint emp_pk primary key(empno) using index
emp_empno_b novalidate;
alter table emp add constraint emp_pk primary key(empno) using index
emp_empno_b novalidate
*
ERROR at line 1
cardinality,
while primary key index is unique. So, why do you want bitmap index for
your primary key?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
is it possible
[EMAIL PROTECTED]
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
is it possible to have a primary key that is enforced with a bitmap
index?
if so what is the syntax?
--
Please see the official
Restrictions on Unique Indexes
You cannot specify both UNIQUE and BITMAP
-Original Message-
Sent: Tuesday, September 23, 2003 5:35 PM
To: Multiple recipients of list ORACLE-L
It's not possible:
SQL create bitmap index emp_empno_b on emp(empno);
Index created.
SQL alter table emp
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Khedr, Waleed
Sent: Tuesday, September 23, 2003 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: possible to have a primary key with a bitmap indx?
Restrictions on Unique Indexes
You
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
is it possible to have a primary key that is enforced with a
bitmap index?
I don't think so. Here's an example from a 9.2.0.3 database:
SQL create table t (v varchar2 (10), d date
We have found the cause of the problem. If populate the varray for a row with 100
values, copy that data to a temporary table and then perform split and exchange
partition operations everything is fine. However if we populate the varray with 1000
values for a row and then perform the same
Hi!
If even Oracle hasn't seen this error, then probably we can't help much here
either. Just a wild guess, try to move this partition to another location
and select from it then (although koxsisz1 isn't a data layer error as far
as I understand). Try to read using index if available, then using
The error was first discovered when we tried to move a partition. ( alter table
archive_wave_i move partition SEP1103 tablespace CHANARCH_NLC_2003_09_DATA). The
table was renamed to OLD_archive_wave_i once it was determined that no new varray data
was accessible. My theory is that this is
? Are any
other partitions affected? One more way would be to take one working record
and insert it to new partition. If now the new record gets unusable again,
it's possible to take relevant blockdumps for both these records, to see
whether theres any difference in low-level data.
For summary
Ian,
I was going to recommend to try exporting your problematic partition with
direct=y, that way normal SQL query processing layer is bypassed in Oracle
kernel all data belonging to segment is read directly (thus hopefully
avoiding the koxsisz1 crash) ... but I'm not sure whether varrays don't
The varray data is stored in a LOB. So I expect direct export will not work. But
I'll give it a try.
Ian
-Original Message-
Sent: Thursday, September 18, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Ian,
I was going to recommend to try exporting your problematic
This is not my week ...
Has anyone seen anything like this
select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id =
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [],
[]
I have Oracle
I think that there are two reasons to do it:
1) You need permissions that are granted to another user
2) You need to work in another schema and you have permissions to these
objects.
In 1) you can grant yourself the necessary permissions.
in 2) try execute immediate 'alter session set current
I doubt it... but this could save me from coding it into a unix script and keeping all
my code in my package. I tried
execute immediate 'connect user/password; and it failed.
is this doable?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET:
My guess is that 'connect' is a sql*plus command (rather than a pl/sql command) so
wouldn't work with execute immediate.
But maybe you could break out the portions of your code that need to run as a
different user into a separate package, owned by that user?
HTH,
-Roy
Roy Pardee
EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: possible to dynamicly connect to a different user in pl/sql?
My guess is that 'connect' is a sql*plus command (rather than a pl/sql command) so
wouldn't work with execute immediate.
But maybe you could break out
my max_extents for my tablespace is set to 505, yet all my lob segments default to a
max_extent of 121.
is it possible to have them use the tablespace default? or set up a default for all
lob segments to use?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
I've no experience with Peoplesoft and Oracle 9, but ..
Try setting the following parameters
optimizer_features_enable = 8.1.6
As I recall this prevented Oracle from incorrectly tossing out some subselects. I'm
not sure if it is even valid in 9iR2
_ignore_desc_in_index = TRUE
Not setting
While I am waiting for oracle support to respond to my tar update (2nd
callback) I am just wondering if anybody has found this problem.
We have the following select query (from a peoplesoft implementation)
SELECT a.emplid, a.effdt
FROM PS_JOB A
WHERE A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_JOB
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: RE: possible Bug in Oracle 9.2.0.2
You it is a bug
alter session|system set _unnest_subquery=false
/
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
Title: Message
That
fixed it, thank you.
I
still haven't heard from oracle support yet.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday,
August 07, 2003 4:44 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: possible Bug
Did you open an iTar with Oracle? If so, what severity was it logged at? How
you answer certain questions on the iTAR form will impact the severity of
the tar, and as a result the time for responses from Oracle.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent:
Can you please list select emplid, empl_rcd, effdt, effseq, empl_status
from ps_job where emplid = '3442'
At 03:34 PM 8/6/2003 -0800, you wrote:
While I am waiting for oracle support to respond to my tar update (2nd
callback) I am just wondering if anybody has found this problem.
We have the
Title: Message
I
already have :)
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday,
August 07, 2003 12:04 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: possible Bug in Oracle
9.2.0.2
Tell them ...
Raj
!
-Original Message-From: Browett, Darren
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 2:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
possible Bug in Oracle 9.2.0.2
That
fixed it, thank you.
I
still haven't heard from oracle support yet
Building on Jacques' solution, here is one that aligns all the statements nice and
neat. Of course, it does not have the username/instance, so I don't know how
acceptable it is
select ' 1 '
as new_prompt
from dual
/
set sqlprompt new_sqlprompt
1 select 1,
2 2,
3 3,
4 4,
Roy,
You got me thinking on a tangent. How can I cut and paste the whole
multi-line SQL
statement at once and have it useable. Now you can, of course, use sqlplus
in silent
mode (-s), but that's a little too silent for my tastes. So how 'bout set
sqlnumber off
sqlprompt ' '. That way you
set sqlprompt ^G
Will make it less quiet.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 23, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Roy,
You got me thinking on a tangent. How can I cut and paste the whole
username
2 from dba_users
3 where username like '%MC%' ;
Is it possible to specify the prompt that shows on continuation lines (or otherwise
pad it out) in sql*plus?
Thanks!
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
--
Please see the official ORACLE-L FAQ
to
which I'm connected. This works well, but has made it tough to drag-select text b/c
now the first line sticks way out relative to the continuation lines, like so:
[EMAIL PROTECTED] select username
2 from dba_users
3 where username like '%MC%' ;
Is it possible to specify the prompt that shows
of
the db to which I'm connected. This works well, but has made it tough to
drag-select text b/c now the first line sticks way out relative to the
continuation lines, like so:
[EMAIL PROTECTED] select username
2 from dba_users
3 where username like '%MC%' ;
Is it possible to specify
the sid of the db to which I'm connected. This works well,
but has made it tough to drag-select text b/c now the first
line sticks way out relative to the continuation lines, like so:
[EMAIL PROTECTED] select username
2 from dba_users
3 where username like '%MC%' ;
Is it possible
the first
line sticks way out relative to the continuation lines, like so:
[EMAIL PROTECTED] select username
2 from dba_users
3 where username like '%MC%' ;
Is it possible to specify the prompt that shows on
continuation lines (or otherwise pad it out) in sql*plus?
--
Please
%' ;
Is it possible to specify the prompt that shows on
continuation lines (or otherwise pad it out) in sql*plus?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
where username like '%MC%' ;
Is it possible to specify the prompt that shows on
continuation lines (or otherwise pad it out) in sql*plus?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
: mardi, 22. juillet 2003 12:44
To: Multiple recipients of list ORACLE-L
Subject: Re: possible to set continuation prompt in sql*plus?
I suggested using SET SQLNUMBER OFF. This sure works in
SQL*Plus 8i and
above; not sure if it does in 8.0.6 and I don't have a test
executable to
test
it tough to drag-select text b/c now the first
line sticks way out relative to the continuation lines, like so:
[EMAIL PROTECTED] select username
2 from dba_users
3 where username like '%MC%' ;
Is it possible to specify the prompt that shows on
continuation lines (or otherwise pad
. juillet 2003 12:44
To: Multiple recipients of list ORACLE-L
Subject: Re: possible to set continuation prompt in sql*plus?
I suggested using SET SQLNUMBER OFF. This sure works in
SQL*Plus 8i and
above; not sure if it does in 8.0.6 and I don't have a test
executable to
test
ORACLE-L
Subject: Re: possible to set continuation prompt in sql*plus?
Setting SQLNUMBER OFF will make the SQLPROMPT continuation prompt, not
completely eliminate it.
Isn't it what the OP wanted in the first place?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
ORACLE-L
Subject: Re: possible to set continuation prompt in sql*plus?
I suggested using SET SQLNUMBER OFF. This sure works in
SQL*Plus 8i and
above; not sure if it does in 8.0.6 and I don't have a test
executable to
test it. But have you tried it?
Arup Nanda
- Original
You can always set your prompt to take up two lines, but that looks ugly to me too.
See example.
SQL show user
USER est SYSTEM
SQL show sqlprompt
sqlprompt SQL
SQL -- change prompt to be connected username and last 4
SQL -- characters of instance name
SQL column new_prompt new_value
the LIST MEMBERS is that it is not
at all possible to range partition without changing the column
type/contents. I have two options now, one with what you suggested.
Thanks for your help and thanks for all those who replied.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 8:34
Dear List,
I have a table of size approx 10gig, and I need to partition based on the
YEAR. I have column in the table, REPORT_CYCLE_CD with VARCHAR2(7). The
data in the column of format MON . I need to partition the table based
on the year , that is, substr(report_cycle_cd, 4,4).
Babu
I don't think partitions are clearly documented anywhere. Here is some SQL
that works so you can see how to use a date function. It partitions on two
columns, but I wanted you to see something that works.
add partition sum_fy_28
values less than ('FY',
No, I think you will have to add a column to store '' separately in
order to partition on it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 4:14 PM
Dear List,
I have a table
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original Message-
Sent: Thursday, March 13, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
??
Dear List,
I have a table of size approx 10gig, and I need to partition
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy to do if it was 'MON'
Oracle 9i has list partitioning that may work for you.
Regards,
Waleed
-Original
No
-Original Message-
Sent: Thursday, March 13, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
???
Is list partitioning available in 8i? Iam on 8.1.7.4.
-- Babu
-Original Message-
Sent: Thursday, March 13, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
???
Easy
Babu,
On a slightly different approach, is it possible to update the column to the
format MON, from the present MON? If so, then there is hope. You
could create the partitions like this
PARTITIONING BY RANGE (REPORT_CYCLE_CD)
(
PARTITION P1998 VALUES LESS THAN ('1999%'),
PARTITION P1999
Title: RE: Middle Tier spawning sessions, possible performance issues
Anjo,
Actually I saw this in your (et al) famous YAPP
paper.
Still
curious,
Steve
-Original Message-From: Orr, Steve Sent:
Thursday, January 30, 2003 10:32 AMTo: Multiple recipients of list
ORACLE
R - I haven't yet been the victim of .net (thankfully), and I hope someone
with direct experience will reply. But just in case, I'll mention a couple
of ideas.
Try to sample the SQL that is being inflicted on Oracle. Microsoft
interfaces tend to have default settings for the lowest common
I'm far more of a developer than a DBA, but when someone told me this it set off a big
red light in my head.
We are using an Oracle Backend with a .net front front. One of our .net guys told me
that the middle tier they are using 'spawns' sessions.
We have 2 pretty distinct skillsets here so
250 connections from the middle tier does sound a bit suspect, way over the
top. I'm assuming 'spawns' relates to establishing connections as and when
required and then disconnecting when done. I think you will find that there
is quite an Oracle overhead in handling all of the connect/disconnect
You are kind of on the right track. The number of sessions doesn't really
matter. What matters is that they logon/logoff all the time. That is the
worst thing that you can do in an Oracle database. Why? The session will
allocate the cursors, parse them, close them everytime the session will
Title: RE: Middle Tier spawning sessions, possible performance issues
I read somewhere that for apps that constantly logon/logoff (like web apps), one possible thing to do is increase the cache size for the AUDSES$ sequence. Anyone done this and seen improvements?
Curiously,
Steve Orr
Title: RE: Middle Tier spawning sessions, possible performance issues
Any
takers on this ??
-Original Message-From: Orr, Steve Sent:
Thursday, January 30, 2003 10:32 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Middle Tier spawning sessions, possible
session can be found with select sid
from v$mystat where rownum = 1.
HTH.
Louis
At 15:13 2003-01-27 -0800, you wrote:
In case anyone cares--it looks like it is *not* possible to set a role in an
after logon trigger. Had I only looked at metalink:
AFTER LOGON Triggers Don't Allow
it is *not* possible to set a role in
an
after logon trigger. Had I only looked at metalink:
AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles
Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
b
ase_id=NOTp_id=106140.1
Bummer, that.
Thanks
anyone cares--it looks like it is *not* possible to set a role
in an
after logon trigger. Had I only looked at metalink:
AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles
Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p
_datab
ase_id=NOTp_id=106140.1
In case anyone cares--it looks like it is *not* possible to set a role in an
after logon trigger. Had I only looked at metalink:
AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id
Title: Message
Chris,
That column is added to the table when upgrading
to 7.3.3 release, by cat7303.sql script.It is possible that this script
was not run after opening the database under 7.3.3.
If you are notusing Replication, I don't
think you need to run catrep8m script.
If you
discovered the v$session.program field am now wondering
whether it would be possible to use the new-fangled logon system trigger to
set the role only for cases where v$session.program = the COTS client.
Can anybody comment as to whether this is a viable approach on an 8.1.6
database
1 - 100 of 201 matches
Mail list logo