hi gurus!
can anyone answer this (maybe newb question:)
i have a table with a BLOB column. this table is stored in a
seperate tablespace, in which there are no other data than that
of this very table.
suppose now i have one row in this table.
if i delete this row, the blob is also deleted
Hi All,
I remember that a number of people were all for getting together on the
Monday night at the UKOUG. I *don't* remember us actually arranging a
place/time.. ;) Is there any chance of another show of hands so that we can
see if we'll need to book a table or not. And has *anybody* had any
Yup, got that covered :)
If I may add another point. When dealing with SLA's, you not only have to
show that the database has been servicing users that are connected
(showing database uptime), but also that users can also *connect* to the
database as well (the listener is servicing requests).
If
There are issues here. Will the table being copied to have the same
constraints in place as those tables from which the data is being extracted?
If so, resolves those, and get these reference tables in place first.
Then simply use a database link to 'pull' the data from your source tables,
eg
Hi All,
I remember that a number of people were all for
getting together on the
Monday night at the UKOUG. I *don't* remember us
actually arranging a
place/time.. ;) Is there any chance of another show
of hands so that we can
see if we'll need to book a table or not. And has
*anybody* had any
hello to everybody
I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't
find libproc2.a is the message when I try do creat. doesn't seem to be an installation
issue, because no kind of installation offers the(se) file(s).
precompilers did exist in 9.0.1 - but
Some simple options:
1) The 9.x installer still gives the option of
creating scripts in the old fashioned way. The key is
not to choose a template database. A little
scrubbing and they work fine...but man do they take a
while to create a db nowadays.
2) My preferred option is to create a
Guys , i posted this already and this time my question is a bit
different .
I have to store 20,000,000 images of 5k each either in DB ( on
win2k) or linux o/s file system.
the images are to be displayed over mobile phones.so the time to
retrieve the images should be minimum.
for this to
Count me in on this, Mark -
As for a 'table' - presupposes a venue in which to find said article of
furniture...(!) no idea on that, but there are places out the back of the
ICC as I recall which might be suitable.
peter
edinburgh
-Original Message-
From: Mark Leith [mailto:[EMAIL
chao_ping,
It seems i am posting a too long question, so nobody is interested.
I post the answer to my second question, to check the memory
utilization in linux operation system.
It is in /proc/spid/status file.
Regards
zhu chao
Eachnet DBA
Hi !
I 've a question regarding OMF realted parameter
CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of
parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does
not recommend it's use.
regards
Tc
Ora-472 is a very non-specific PMON error. You've probably already worked
through this with support using a TAR, but if you still are having problems and
wanted to post the following it would help:
The stack trace from your pmon traces (they'll either be in bdump or udump, and by
stack
Mark,
yes, I'll be there and Monday night is fine. I don't know the area at all so
can't suggest venues but I'm not choosy regarding food so anywhere should do
for me.
Cheers,
Mike
-Original Message-
Sent: 03 December 2002 09:59
To: Multiple recipients of list ORACLE-L
Hi All,
I
I don't know whether people do it on purpose or they are still unaware
after so many similar postings of the same nature and replies of 'ARE YOU AN
IDIOT', but it does result in a plethora of responses which create unnecessary
hassles.
Jared, why not parse messages for these commands and
Must..
resist urge...
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tinu !@#!^%Sent: 03
December 2002 11:29To: Multiple recipients of list
ORACLE-LSubject:
HELP
HELP
I posted a similar question recently and whilst I received some answers I
never did discover an exact way of matching oracle use of memory with unix
use of memory.
One issue is that when oracle releases memory the unix process does not
automatically do the same until the memory is required.
There is a OMF related parameter called db_create_online_log_dest_n.
This defines where the online redo logs are created. The value n can vary
from 1 to 5 and it allows for upto 5 multiplexed copies opf each redo log
group member.
HTH
John
-Original Message-
Sent: 03 December 2002
Managing 20mil of anything (images/text/etc) in a file
system isn't a nice proposition. Go with the database
hth
connor
--- oraora oraora [EMAIL PROTECTED] wrote:
Guys , i posted this already and this time my
question is a bit
different .
I have to store 20,000,000 images of 5k each
Its in the 9.2 doco
hth
connor
--- Tinu !@#!^% [EMAIL PROTECTED] wrote: Hi
!
I 've a question regarding OMF realted parameter
CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter
mentioned in the list of parameters in the Oracle
Documenttion cd of 9i. Is it obsolete or oracle does
not
John ,
I meant the same param.apologies ,i misplaced db and create. Is this
parameter obsolete (with 9i) coz its not mentioned in the Documentation
(9i) list of initialization parameters. Only db_create_file_dest is
present in the doc.
Thanx !
best regards
Tc
On Tue, 3 Dec 2002 [EMAIL
installed O92010 on rh 8.0. went fine so far until I tried to connect via oemapp
console - whatever connectdescripter I chose in resulted in the error string not
properly terminated. same connect descriptors in the CLI worked fine - made them
available in the oemapp console and got the error
Hi, all,
My developer continually got ora-1722 when he was installing a new billing
system. I used 10046 event to get trace file, but i could not figure out
which bind variable value causes the error, here is the part of trace:
PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370
Ron,
Good idea, but DEGREE=1
There are two indexes, but they are in a different tablespace (which has
plenty of free space available and did not give an error).
Next extent size is 25M but, as mentioned, it shouldn't have needed a new
extent.
I'm still at a loss...
Jay
-Original
Connor,
I seem to think otherwise. Storing 100 GB of image is not necessarily a
pretty proposition either when you consider hot backups and archived log
generation, etc. I presume you are concerned about the management of the
image files considering the sheer volume of it. But that's precisely
If PreCompilers were installed, check in $ORACLE_HOME/precomp/lib* directories.
Also, check your path, ld library path.
Here's what I get (9iR2 on HP-UX).
/u01/home/oracle/product/9.2.0
hp102 [KED9]: find . -name libproc2.a -print
./precomp/lib32/libproc2.a
./precomp/lib/libproc2.a
- Kirti
Title: RE: oracle precompiler in O 9.2
SQL exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
oraclei@elara-ABC1
For reasons too long to go in to, go buy a tool is not a good option for
my purposes. Besides, why buy what I can build? These are exactly the sort
of challenges that make my job worth coming to.
Thanks,
Ethan
-Original Message-
Sent: Tuesday, December 03, 2002 4:14 AM
To: Multiple
Title: RE: SLA Trigger/Procedure
Go buy a tool? Here is an idea instead ...
Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in
Title: 9i database create script - My, how things have changed
I
followed the same procedure as 8.1.7 to make the scripts and modified
them
What
part does not work, no mo ?
-Original Message-From: Jeremy Pulcifer
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 02, 2002
The ORACLE_HOME is /usr/opt/oracle/current ?
I have read of /usr/opt being used, [although I generally
use
/u0x/app or /oracle/app or
/orasys/app depending on the standard'
at the site] but not current -- I generally still use
[the OFA standard]
./product/Version.Release.MaintenanceRelease
Hemant
Hi all,
After with some deliberation with Peter Robson, we've come to a decision (I
think!) ;) Please see below (a cba to type it all again ;P).
Basics, meet up at around 7 (which is when the reception *starts* to see if
we can all get together for the party as well. If we can't all get in, the
and that select 'PING' from dual is very costly. I believe Gaja, Cary,
Anjo, and a few others (who were nice enough to include me on the
thread) determined that before 9i Oracle takes about 5 LIOs to do a
select anything from dual. I think it went down to either 3 or 4 in
9i but that's still VERY
a table presumes there will be only a few of you there
by my count, which is admittedly low, you folk are already at 8
--- Robson, Peter [EMAIL PROTECTED] wrote:
Count me in on this, Mark -
As for a 'table' - presupposes a venue in which to find said article
of
furniture...(!) no idea
I am going to install 64 bit Oracle 8.1.7 on AIX 5L (5.1). There is already
32 bit Oracle on the box. Any suggestions or advice I would appreciate.
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Title: RE: SLA Trigger/Procedure
Dang,
I just new that would cause a stir!
;P
Mark
Running away now Leith
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni,
RajendraSent: 03 December 2002 14:32To: Multiple
recipients of list
Excellent points all around. I am dealing with these issues currently. The
original design was to use BFILE and external files. Now, they are leaning
towards BLOBs. Here are some points to consider.
If the system design calls for a standby or other backup site, you have to
remember to replicate
You should/must do a benchmark.
If not, how can you justify your decision ?
If your management do not ask for a benchmack then you
have bad management (and that's no good for you
either...)
Anyway, in a previous life, we did a benchmarck with
files of similar size and it was faster on the OS.
The
oraora
I've provided a couple of thoughts before in response to this issue, but
I think that the only way you will get a satisfactory answer is to code a
simple test. I hope someone else has extensive experience with 5k images and
will reply to you. However, I think the answer to your question
but i just logged in metalstink after a few weeks and noticed:
Oracle announces the extension of Error Correction and Extended Maintenance
Support for Oracle Database 9i Release 1 (9.0.1).
Support
Original Date
Extended
Date
Error Correction Support (ECS)
June
I don't manage the mail list software, Bruce Bergman does.
Though these are a minor annoyance, I personally wouldn't
bother writing code/rules to eliminate these.
Just hit DELETE
Jared
Naveen Nahata [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/03/2002 03:58 AM
Please respond to
Arup,
What Connor may have been referring to is the inefficiency
of managing 20 million files in a filesystem.
That's a lot of inodes ( assuming unix ). It's a bit much
for a filesystem to deal with.
Jared
Arup Nanda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/03/2002 07:14 AM
And each of the threads can be defined as either mandatory (the
archiving/copy has to succeed for the database to continue running) or not.
Mogens
[EMAIL PROTECTED] wrote:
There is a OMF related parameter called db_create_online_log_dest_n.
This defines where the online redo logs are created.
Ahem...
OK, I can not resist any longer.
The tools exist: http://www.amazon.com/exec/obidos/tg/detail/-/0596002106
The 'dbup' script logs all connections attempts. Use sed, perl, or
whatever
to parse the logfile, or modify to create logs more to your liking.
Jared
Jamadagni, Rajendra
Hear-hear. The OakTable Network has a couple of round tables near the bar
area in the Exhibition Hall where we could meet, perhaps?
Mogens
Connor McDonald wrote:
I'm up for a drink - I think we all deferred to your
local knowledge. I say choose a pub and anyone thats
want to be there
I had one thought.
The Freelist parameter for this table is only set to 1. Is it possible that
if it gets tied up with contention for the freelist that it grabs a new
extent?
I see that some of these blocks are being written to, the
num_freelist_blocks is now down to 2095705. But the new data
Hi
If I create a temporary tablespace using temp files, how is it possible to
check the space usage of that tablespace.
They do not show up in dba_free_space nor dba_data_files. DBA_TEMP_FILES
gives me user_bytes and blocks. is this the opposite of the info in
dba_free_space??
TIA
Jack
--
Tool? I have a tool. Want to buy? ;)
It's a simple script that connects (actually attempts to connect with a fake id/pw) to
the target DB (on Windows, HP-Alpha/VMS, UNIX) over Oracle Net. Scans for the ORA-
errors and we know if the DB is accessible or not, as well as if Listener is
To be fair, there is some disagreement about adding an index on DUAL. I have
not duplicated the scenario that Cary presents and I have been too
distracted (writing a paper/presentation for Rachel) to get back to my
testing. So take with a small grain of salt.
Dan
-Original Message-
Sent:
a table presumes there will be only a few of you there
by my count, which is admittedly low, you folk are already at 8
You haven't seen the SIZE of these tables - they are bl massive! We take
our communal beering seriously over here!
peter
--- Robson, Peter [EMAIL
ELIZA
And how may we help you?
\ELIZA
Tinu !@#!^% brain_damage
Sent by: [EMAIL PROTECTED]
12/03/2002 03:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
HELP
--
Please see the official ORACLE-L
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that belong to them.
The open to the database is working fine. When I use:
ResultSet myTablespaces =
I'll be there, with a special gift and greetings from the DBA Goddess...
Dan Fink
-Original Message-
Sent: Tuesday, December 03, 2002 2:59 AM
To: Multiple recipients of list ORACLE-L
Hi All,
I remember that a number of people were all for getting together on the
Monday night at the
Yes, but can I get it signed...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
As part of a Batch Processing Job Benchmark , the Veritas parameter
vxdmp:dmp_patchswitch_blks_shift =15 set by the Sysadmin gave Good Performance
/ Elapsed Time benefits .
Has any used this parameter ? Any recommendations ? Any cautions about the Same ?
Anyplace i can get some info on this
and besides, it gives some of us a source of amusement - waiting for the
first Are you and idiot? response.
-Original Message-
Sent: Tuesday, December 03, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L
I don't manage the mail list software, Bruce Bergman does.
Though these are
Sorry, I forgot a Subject title!
Gurus,
I was just given a project to maintain a Computerized Maintenance
Management System. When I asked the companies support staff how to roll
back patches in the backend Oracle Database (Ver. 8174), they said that
there was no way to do this. I'm
v$sort_usage perhaps?
not sure what you're trying to determine.
'TEMPORARY' temp tablespaces provide space for sorting, and
the kernel ( forget which process at the moment ) tends to hang on
to them once allocated, and supply them to sessions as needed.
This avoids contention on the ST enqueue.
And, if I'm not mistaken, 8.1.7's ECS date got pushed out as well, to
12/31/2003 (MetaLink doc ID 148054.1). I seem to remember being in a
feverish panic because 95% of my databases would be out of ECS this year.
Of course, those brain cells may have been long gone now... :)
Rich
Rich Jesse
Dale,
I installed 11.5.5 on Suse 7.0 and it went absolutely fine. I went with that
O/S because I'd heard it was the most trouble free combination.
I believe that the 11.5.7 release is 11.5.5 plus extra CDs containg the
11.5.6 and 11.5.7 maintenance packs.
I ran it as a single tier install and
Title: RE: install of 64 and 32 bit
According to Metalink, 8.1.7 64-bit is not certified for AIX 5.1.
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Subject: install of 64 and
John - your problem is that you are reusing the Statement named myStatement
within your while (myTablespaces.next()) loop. just declare and use a
second Statement and i suspect all will be well once again.
from http://java.sun.com/j2se/1.3/docs/api/index.html :
java.sql
Interface Statement
All
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine as long I insert into
local table. If I try to insert into a table across a database link the
record get inserted but upon exiting the app whether it is
sqlplus,forms,etc I get ora-2083. I think it is probably a bug
It is documented in Oracle9i Database Reference Release 1 (9.0.1) Part Number
A90190-02.
Check it out at http://tahiti.oracle.com
- Kirti
-Original Message-
Sent: Tuesday, December 03, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L
John ,
I meant the same param.apologies ,i
Exactly.
We had a system that used to drag emails (from qmail
so each mail was a file) into clobs in the database.
After a year or so we had about 15 million emails in
the database - no problems at all.
Then one day the some idiot (aka me) put a new version
of the program in which
Title: Extent sizes when using LMT with autoallocate clause
Hi!
I was wondering what the allocated extent sizes for locally managed tablespaces with the autoallocate clause are? The first extents are 64k in size. How many 64k chunks are allocated? What are the next sizes?
CREATE
[EMAIL PROTECTED] wrote:
Ethan,
That records the startup times, but does not record the time
that the database was unavailable.
What's needed is a 3rd party monitor that is not dependent
on the database being up to record metrics.
Jared
Jared,
I am far from having given much
Title: RE: SLA Trigger/Procedure
you still have to *buy* the tool right?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
FWIW ... in my last job we stored 13 million CLOB documents (max size of
5KB, stored out-of-line in their own CLOB segments) in an 8.1.7.3 DB under
Win2k (2 CPU HP NetServer with 4GB RAM and twenty-three 36GB drives;
JBOD). The CLOB documents were all interMedia Text indexed.
Contains queries
actually we also have /usr/opt/oracle/92 which is linked to
/usr/opt/oracle/current
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that of ESPN
Mike,
It is the value in the :gl_id string, which is 6.55802.
The column GL_ID is defined as an integer of 38 digits (i.e.
NUMBER(38) instead of NUMBER), so there is no room for
digits to the right of the decimal...
Hope this helps...
-Tim
Hi, all,
My developer continually got ora-1722
Rick - Have you tested the link itself?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine
Mark - Well, speaking for myself, I appreciate your openness in pointing out
the major issues one would have to deal with if they were going to write
their own.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 10:34
Hum.
My last thought would are there triggers or snapshots defined on the table?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
case
when initial_extent 1m then
case when extents 16 then next = 64k,
when extents 80 then next = 1m,
when extents 200 then next = 8m,
else next = 64m
when initial_extent = 1m then
case when extents 64 then next = 1m,
Steve,
This was it exactly. Thanks!
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Tuesday, December 03, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
John - your problem is that you are reusing the Statement named myStatement
within
Scott,
Of course, the answer is It depends.
It all depends on the kind of software patches that are being applied.
Are you talking about adding a column to a table that allows nulls? There
might not be a need to back this patch out - the column might be able to
stay depending on how it is used
Gurus,
I was just given a project to maintain a Computerized Maintenance
Management System. When I asked the companies support staff how to roll
back patches in the backend Oracle Database (Ver. 8174), they said that
there was no way to do this. I'm guessing I could use logminer just incase
comment out
myDataFiles.close();
and see what happens.
On Tue, 3 Dec 2002, John Weatherman wrote:
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that
It looks like that is bind value 4(gl_id) = 0.
How did you determine it is 6.55802?
I certainly do not how to read this trace but looks like it is define
correctly
:element_id, bind 0
:fixed_operand,bind 1
:flags,bind 2
:free_quantity,bind 3
:gl_id,
Check view V$TEMP_SPACE_HEADER.
I suggest referring to Metalink Notes: 160426.1 and 188610.1
- Kirti
-Original Message-
Sent: Tuesday, December 03, 2002 8:44 AM
To: Multiple recipients of list ORACLE-L
Hi
If I create a temporary tablespace using temp files, how is it possible to
Jay,
Don't think it will bypass the freelist there. I don't think the freelist
is the cause of the problem here.
Richard
-Original Message-
Sent: Tuesday, December 03, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L
I had one thought.
The Freelist parameter for this table is
Just for grins, here's the level of support I'm getting on my Oracle TAR:
--
You had stated earlier:
1/ After reanalyzing the table I saw the following stats in DBA_TABLES:
num_freelist_blocks: 2266966
avg_space_freelist_blocks: 3895
Unless I'm misreading this I
Apologies for the delay (the digital camera died on
the trip over) so apologies as well for the picture
quality (all taken with a throwaway disposable
camera).
But, here they are... the rough bunch that is the
Oracle Fatcity-L crew in San Francisco.
http://www.oracledba.co.uk/sanfran.htm
Cheers
Title: Extent sizes when using LMT with autoallocate clause
From
memory...
16
extents of 64K = 1 meg
63
extents of 1m = 63 meg (64 total)
120 extents of 8m = 960 meg (1024 meg or 1 gig
total)
Additional extents are 64m (I never found an upward bound in testing...)
*This is undocumented by
John - I forwarded your message to one of our newly-trained Java
programmers. He replied with:
The code is incomplete, how are they handling the connection.
Obviously the while loops are messing each other up.
There are multiple ways of handling this.
If I see the complete code I can
Title: RE: install of 64 and 32 bit
AIX 5.1 you can install only 9201 64 bit.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Stephan,
There will be no relevant info in the alert.log about the time when database
was unavailable, if database was not shut down properly (let say, the plug
was pulled).
Or, may be I misunderstood you?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple
On Unix, you can back up the installation directory. If you need to go back
to the old version, put the old directory back. You can use tape, tar,
cpio, cp, etc. to do this.
Example 1
cd /path/here/product
tar cvf /path/elsewhere/old817.tar 8.1.7 (assuming 8.1.7 is the directory to
back up)
If
Yes I have taken the insert statement out of the logon trigger and it works
fine. I think there may be a possible bug
with logon trigger using database links.
I would test it on raw disk device because it avoids double buffering.
-Original Message-
Sent: Tuesday, December 03, 2002 2:49 AM
To: Multiple recipients of list ORACLE-L
Guys , i posted this already and this time my question is a bit
different .
I have to store 20,000,000 images of
Kirti,
Nice script for checking availability. May I remind everyone that you get
an additional free check by running this on a different physical host -
you are then checking physical host availability and at least some degree
of network connectivity as well.
I still think my original
We are doing ORACLE 9.2.0.2 Enterprise Edition testing on SUN server
(Solaris 8). Currently one problem happen. If I put SGA_MAX_size entry
on init.ora file and restart database, the SUN server will crash and
following messages on /var/adm/message file:
Dec 3 13:34:59 ISS unix: [ID 253085
I would recommend a restore because you are going to backup for applying a
patch anyway RIGHT? Logminer would do nothing as far as the OS files
getting overwritten by applying the patch.
Rick
Mike,
If there a trigger on the table that does some DML with another table?
You already got the sql statement. Why not run that in sql*plus the exact
same way, after declaring the bind variables and assigning them the same
values you found in the trace file and see what happens?
From sql
After spending hours debugging, we finally found the solution: NLS_LANG.
There is no problem if nls_lang is american_america.utf8; while ora-1722
occurs when nls_lang is set to american_canada.utf8. The culprit is 6.55802.
And when nls_lang is set to american_canada.utf8, the default decimal
I agree what is needed is something very generic that could monitor the
uptime of pretty much any process. After giving this more thought and
always liking to keep things simple here is the direction I might eventually
head. The logic below would result in a log file that shows all unscheduled
Connor:
Perfect pictures. Office looks cool. Perhaps Larry could sell Oracle in
Linux there. Small platform, low cost.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
Rick - Can you do that insert in SQL*Plus (outside the trigger)? I'm sure
you have, just my logical completeness tendency.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
Dist - It sounds like you are setting SGA_MAX_SIZE too large for the server
kernel. Try setting it smaller and see if the server is okay with that. If
this is true, then you may need to adjust some Solaris kernel parameters.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
1 - 100 of 126 matches
Mail list logo