Thanks, but I think it will get rewritten soon anyway.
Jared
On Sunday 27 July 2003 22:44, Mladen Gogala wrote:
I saved the article but not having too much experience with the database
duplication using RMAN, I have no comment to make. I can send you the
document in the PDF format, instead
thanks Charu, i have used this example
successfully... but nowhere it's tell me how to use/attach astylesheet
to format my XML output !!!
- Original Message -
From:
Charu
Joshi
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 28, 2003 1:29 PM
Hi
Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD
?
If so, does anybody know of a good How-To ?
TIA,
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi Group,
I have a doubt. From where the SGA will be taken. From the RAM or from the
virtual memory?
regards,
Senthil
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Senthil Kumar D
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Hi!
Others have had the same problem, only thing that metalink has advised is to
create pfile, modify it by hand, then create new spfile from it (using
create pfile from spfile and create spfile from pfile commands).
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L
Are you actually getting the statistics back when you run a sql statement
(Bnow?
(B
(BNormaly one had to run $ORACLE_HOME/sqlplus/admin/plustrce.sql to get a role
(Bnamed PLUSTRACE, which should have been granted to users doing sql tracing
(Bwith statistics.
(B
(BThe role has only following
Hi!
Definitely virutal memory (if you're not running v4 on DOS :).
And virtual memory is taken either from RAM or swap space by your operating
system. In order to use any bit of virtual memory, it has to be in RAM, e.g.
read in from swap space, if swapped out previously..
Tanel.
- Original
It's from the RAM senthil.
Jp.
28-07-2003 18:34:24, Senthil Kumar D [EMAIL PROTECTED] wrote:
Hi Group,
I have a doubt. From where the SGA will be taken. From the RAM or from the
virtual memory?
regards,
Senthil
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem
Tanel,
(B
(BPLUSTRACE role was already granted to CTI.
(B
(Bit's the SAME user "CTI".
(Bi tried it on a different machine.that's it.
(B
(Bwhen i upgraded oracle client 9.2.0.2 to 9.2.0.3,
(Bit worked fine and i was able to get the statistics.
(B
(BSo,is this a bug or ?
(B
Cool, but it also begs the question as to why SQL*Plus doesn't have line
editing capability?
Even in 9i, unless I don't know the keystrokes to do the line editing
...
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original
v/r
Thanks for the encouragement and yes I would like to know some of the good Oracle 101
under a windows environment books. I'm pretty certain that my approved training will
be funded with year-end money, but that means the earliest I'll get to class is in
late October or early November.
I use sql-mode for local databases. Its got the advantage that you can
'pop' sql statements from another buffer into it, giving you something very
like the sqlplus worksheet. Its great when you're fiddling with a big
query.
Also, I use emacs with the vi emulation (viper) so I get the best of
I'm expecting a lot of innovative answers for this question
:-)
-Original Message-
From: Senthil Kumar D [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Question on SGA
Hi Group,
I have a doubt. From where the
I'd see myself as one of the old dinosaur type's!! (Been using vi since I
can remember) ;-) I've tried playing with emacs many times, but it's the
configuration that put's me off everytime. Is there a good source of
information for configuring emacs with sql support ?
Regards
Lee
-Original
I know what you mean. The best I can come up with is
http://www.emacswiki.org/cgi-bin/wiki.pl?SqlMode. My .emacs has been built
up over five years. Its not pretty, but I'd be lost without it.
Fortunately, sql-mode comes with GNU emacs (and I'm almost certain, with
Xemacs) and doesn't need any
the otn document for administering oracle on windows is pretty solid. the book
includes most of that stuff plus some fo the gui tools.
From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED]
Date: 2003/07/28 Mon AM 08:11:32 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
if you dont have enough memory, it will be taken from virtual memory which is very
bad.
if there is enough memory, Oracle will reserve its space from that first.
From: Naveen Nahata [EMAIL PROTECTED]
Date: 2003/07/28 Mon AM 07:59:24 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Hi
listers,
I am trying to setup
Oracle9i RAC on RedHat Linux AS 2.1 on DL580 server. The storage system is MSA 1000 Controller
with FCA2101 Fibre Channel Host Bus Adapter. I have
installed dual operating systems viz; Windows 2000 Advanced Server and RedHat Linux AS 2.1. I am unable to
Hi
(B
(BHm, but try to query sys.v_$session sys.v_$sesstat and sys.v_$statname views
(Bunder cti user.
(BIf it works, then enable event 10046 at level 4 before you set autotrace on
(Band check trace file (maybe there are some parse errors for example)
(B
(BIt could be a bug, or just change
Hi,
rather vague, this one, I'm afraid, but we're stumped for ideas.
We have an Oracle 8.1.7 instance on a Sun Solaris setup, which we're currently testing
prior to going live. Every so often - 2 or 3 times a week - the users phone to say the
application has stopped responding. They're waiting
Actually it's not ultimately bad. I'd say it's rather good instead.
When you initiate a process and allocate memory to it, it's actually just
mapped to virtual memory in modern operating systems, meaning that a process
which hasn't actually touched the memory it has allocated (thus unused
memory),
vi on *nix and cygwin is the friend
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-289
mailto:[EMAIL PROTECTED]
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
24.07.03 in
Thank you. These are excellent suggestions and I will follow up on them.
Our senior DBA has some analysis of his own and I do agree with #4 -
we've had problems before with this application and its execution of SQL
statements.
Thanks again,
Saira
-Original Message-
M Rafiq
Sent: July 27,
Coolness. Thanks David. I fired up Xemacs and, following your
instructions, was able to log into one of my databases. Now I have a
'cool toy' to play with!
Dwayne
Lord David wrote:
I know what you mean. The best I can come up with is
http://www.emacswiki.org/cgi-bin/wiki.pl?SqlMode. My
My only doubt is:
1.After analyzing the index,CBO doesn't read the index because
it is costlier in terms of I/O and other resources.
The point is, that index access is cheap in reality, but CBO thinks it's
very expensive and chooses next best executin plan in it's opinion, but this
opinion is
Rabbit - Please don't take offense. From time to time I myself have had
someone try to make me do something really dumb, and it is really helpful to
innocently ask the question on this list and then return to that person's
office with a handful of scorching replies. But until we get that strong
Paul
Checked the Following
1) Are there any error in the Alert.log file
2) Are the Database in Archivelog mode and the Log_archive_start is not marked true and so it might be hanging after all of the Redologs are been filled as Archiver is not running.
Thanks
Indy Johal
Paul Vincent
Stefan - Instead of AD?? I'm still trying to figure out how to get it to
work with AD. My impression at this point is that only a few people have
played with OID. I really hope you receive a reply because it will probably
give me some hints about how to use it with AD.
Dennis Williams
DBA,
run statspack and check your top 5 wait events. you have some kind of bottleneck
flairing up.
From: Paul Vincent [EMAIL PROTECTED]
Date: 2003/07/28 Mon AM 09:39:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: 8.1.7 instance on Solaris periodically goes sluggish,
Please excuse the ignorance but what is an otn document? I have three Oracle based
applications here and each one was delivered without any documentation.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original Message-
otn.oracle.com
its where oracle keeps all its documents and downloads etc. www.oracle.com is the
marketing. you have to register but its free.
go to that site. On the left will be a link for documentation. Go to the 'database'
documentaiton. Both 8i and 9i are there. Click books. There is a
Stephen
Go to http://technet.oracle.com and register -- it's free.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Please excuse the
OTN is shorthand for Oracle Technical Network
technet.oracle.com
--- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED]
wrote:
Please excuse the ignorance but what is an otn document? I have
three Oracle based applications here and each one was delivered
without any documentation.
Paul - What I've found to be the most helpful is to install Oracle's
STATSPACK (included free with your Oracle). Then when you receive the first
report of sluggishness, take a STATSPACK snapshot. About 5 minutes later,
take another. It takes a snapshot of what is going on with your database at
Our secondary ONAMES server used to be 8.1.7 on WinTuke, SP3 with the
primary ONAMES being 8.0.5.0.1 under OpenVMS and the common repository Names
DB 8.1.7. At the time, the secondary ONAMES server was my PC (one of those
quick-and-dirty ideas that became production). I was also trying to get
Stephen.
OTN is the abreviation for Oracle Technology Network
http://otn.oracle.com/. It is a source and startup point for
documentation, softrare , news, and other Oracle related stuff. I
would surf the site to see what is available for the Oracle applications
you have and to locate the
We have a developer that is inserting a large number of records using a VB program.
An insert trigger exists on the table. This trigger checks a parent table for
records. I know this trigger really is not needed, since a Foreign Key exists to
enforce referential integrity, so I plan to
Yes, but it isn't pretty. Actually, we chose SunOne, but the concept is the
same. I can't take any credit for it though as the local LDAP expert
employee-turned-consultant figured out how to create the Oracle schema (LDAP
schema, not DB schema). I don't know the exact details, but I remember
Title: RE: Maximum Open Cursors on Insert Trigger
Just for a more _completeness_ I'd put a curser close statement in the exception clause ... I agree with you that for-update is a no no in this context.
Raj
Thanks. So it looks like I either have to
... create an OID, export everything and change the stuff to be standard
LDAP,
... or, maybe: Sniff the network traffic while having Oracle create the
Schema (LDAP, not DB)
on a win2k Active Directory (if that is standard LDAP stuff, let's see ;).
Thanks! I'll start perusing the sites right away.
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 10:39 AM
To: Multiple recipients of
Plus if you are on 8.1.7.3 you have several bugs that can cause hangs w/o
alert log messages. (check metalink)
Jack
-Original Message-
Sent: Monday, July 28, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
hangs...
run statspack and check your top 5 wait events. you have some
Thanks David, that is pretty good stuff. Where would the .emacs file be for
this so that I can have a look and try and understand the configuration?
Cheers
Lee
-Original Message-
Sent: 28 July 2003 14:14
To: Multiple recipients of list ORACLE-L
I know what you mean. The best I can
I tried the whole process again this morning and got it to work, (after
a couple of days playing with varios settings. Here is the summary of
the tar.
This was a clean install on w2k sp2 oracle 8.17 with patch/sets 1,2,3,4
applied
Thanks to all who took the time to reply
Bob
There are several bugs in 8.1.7 with this annoying behaviour. You did not
say what patch release you are on. If anything before 8.1.7.4, good chance
its one of those.
Bottom line is TOAD or Spotlight is useful for normal circumstances, but not
in this case where everything thing seems to hang.
I asked this last week, but I have a little more info this week.
I have a table that gets programmatically loaded each night. The table
needs to have an index added for reporting purposes. However, when I
add the index to the table in the TEST database I start getting Snapshot
Too Old errors.
Hi Guys ,
I am new to this clustering concept. Just trying to
understand few basics . Need ur help .
what is differece between oracle running on sun /hp
cluster with 2 nodes and oracle with RAC running
on 2 nodes ?
thanks,
-ak
Try to give this index initial sufficient space so that it does not
autoextend the extents.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:09 AM
I asked this last week, but I have a little more info this week.
I
Hi
oracle running on sun cluster or MC/service guard is usually a failover
solution. If the
node running oracle fails the standby node takes over by executing
customized start
scripts.
With RAC both nodes have instances of the same database up and running. If
one
node fails the other is
That's just sidestepping the problem. I agree it is an easy fix but
there should be a way to diagnose and correct the problem. I have done
everything suggested in the Oracle papers but nothing seems to work.
There must be something I am missing.
Thanks!
Ron
-Original Message-
Sent:
ak,
As I understand it, an HP cluster is 2 boxes that have the capability
to access the same disks and data but only one can have the oracle
instance running and accessing the datafiles(active). Sort of like a
high availability option.
With RAC both boxes can access the instance and datafiles at
Title: Message
Active/active = RAC
Active/Passive = Traditional Sun and Veritas
clustering
Basically, in RAC both nodes are up servicing queries and if a node
fails, the other one takes care of recovering the other one's
transactions.
In
traditional active-passive clustering, one node
HUH??
Ron,
Is your index set up as NOLOGGING? Could you perform the load and
then add the index without having the error? Is there any other activity
on the server at the time the load is being performed?
Ron
[EMAIL PROTECTED] 07/28/03 12:24PM
Try to give this index initial sufficient
Here's mine with references to optional packages (mainly jde) removed. Its
set up for windows and cygwin, so if you're using something else (better;)
you can remove the cygwin bit at the end.
--x--x--x--x--x--cut-here--x--x--x--x--x--
(setq viper-mode t)
(require 'viper)
(custom-set-variables
so what happens when first node goes down , oracle instance (processes )
will start on other node ? OS will take care of everything ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:29 AM
ak,
As I understand it, an
Another Important different is that RAC is best High Availability solution in case of System/Instance Failure where in case of HP or Veritas Cluster, all of the resource get stopped on live system/node of the cluster and then get started on second node and hence user will be affected. But in case
Ron,
With an index, you also increase the amount of undo that must be generated. It
will also increase the amount of time that is required to process the load. Either of
these can increase the risk of ORA-01555.
ORA-01555 means that the information required to reconstruct a read
Paul,
Make sure you're on the lastest 8.1.7.4 patch level.
Learn about 10046 extended SQL tracing. Then, arrange for one or two of
those users who have been complaining to call you as soon as they notice
something fishy and turn on the tracing. This will show you in more
detail than you might
Normally the process is very inelegant. The filesystems are mounted on
the passive node (and unmounted from the primary node if the OS is still
up), oracle is started up, any listener IP addresses are failed over,
and then the listener is started (not necessarily in that order).
With
Yes, if the first node [ Live ] goes down, then all of the resources [ Listener/Database/Filesystem/Mounted Disk] etc are been stopped/unmounted and then been mount/started on the second server. I am sending a small diagram showing the Tree of the Resources in Veritas cluster setup
Good Luck
why not drop the index and then recreate it once the load is done?
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
I asked this last week, but I have a little more info this week.
I have a table that gets programmatically loaded each night. The
table
needs to have an index added for reporting
The index is not set up with nologging. I can build the index after the
load with no problem. There is no other activity in the database during
the load process.
Thanks!
Ron
-Original Message-
Sent: Monday, July 28, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
HUH??
Ron,
can someone please tell me what is shared pool
latch(latch# 155) and how do we prevent this.
i am facing this in 9i very frequently.
thanks
sai
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sai Selvaganesan
INET: [EMAIL PROTECTED]
Fat City Network Services--
what bugs are those?
From: Jack van Zanen [EMAIL PROTECTED]
Date: 2003/07/28 Mon AM 11:09:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: 8.1.7 instance on Solaris periodically goes sluggish, then ha
Plus if you are on 8.1.7.3 you have several bugs that can
well does the load process happen serially or are you breaking it into pieces and
doing it at once?
by load I take it to mean
insert
update
delete
create index.
correct?
From: Smith, Ron L. [EMAIL PROTECTED]
Date: 2003/07/28 Mon PM 01:24:23 EDT
To: Multiple recipients of list ORACLE-L
There are some relevant notes on MetaLink that may be of help.
Search on 'visual basic ora-1000'
Jared
On Monday 28 July 2003 07:54, Jay Hostetter wrote:
We have a developer that is inserting a large number of records using a VB
program. An insert trigger exists on the table. This trigger
if your doing a 'programmatic load' you should consider doing one commit. if you have
the rollback space for it.
This is what is happening.
your 'load' is doing DML on the table
another dml or query is operating on the table. you do a commit, the before image it
was using gets overwritten.
Stephen
Technet (aka. otn) is good, but sometimes it helps to have a book help
you get started. Consider picking up a copy of Oracle9i DBA 101.
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1059408389/sr=8
-1/ref=sr_8_1/002-8977984-5541669?v=glances=booksn=507846
Don't worry too
Smith, Ron L. scribbled on the wall in glitter crayon:
I asked this last week, but I have a little more info this week.
I have a table that gets programmatically loaded each night. The
table needs to have an index added for reporting purposes. However,
when I add the index to the table
Hi!
Yep it could very well be an crashing/stuck
archiver process problem. When instance is restarted by sysadmin, archiver is
started again and it archives online logs allowing further DML to be made and
redo to be generated.
Also, when users phone you next time, try to
tnsping your
does an archiver problem show up when you run statspack?
From: Tanel Poder [EMAIL PROTECTED]
Date: 2003/07/28 Mon AM 10:49:24 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: 8.1.7 instance on Solaris periodically goes sluggish, then hangs...
Hi!
Yep it
Eeeew. And people don't like VMS clustering why??? insert subjective
argument here DEC had this nailed down *decades* (plural) ago -- with all
nodes in the cluster active voting members (read: all servers in cluster by
default are available) in the quorum. The major downside is that failover
Yep, all at once. All inserts I believe.
-Original Message-
Sent: Monday, July 28, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
well does the load process happen serially or are you breaking it into
pieces and doing it at once?
by load I take it to mean
insert
update
FYI
NGSSoftware Insight Security Research Advisory
Name: Oracle Extproc Buffer Overflow
Systems Affected: Most OS platforms; Oracle9i Database Release 2 and 1, 8i
Severity: High Risk
Vendor URL: http://www.oracle.com
Authors: David Litchfield ([EMAIL PROTECTED])
Chris Anley ([EMAIL
ok so your not running it serially. you have say 10 inserts all running at the same
time right?
well that is your problem.
they are using each others 'before image'(ie the data in the rollback segment) then
you commit and the before image in the rollback segment gets written to. So it
I agree. It was disheartening to look at the LDAP v3 standard compliant
OiD and not be able to do much with the extracted LDIFs. After looking up
the RFCs, I saw that there is an RFC for LDIF files that is separate from
the RFC for LDAP. My opinion is that OiD *may* be LDAP v3-compliant, but
is
Does anybody know if is possible to change the
Oracle banner description?
Oracle9i Enterprise
Edition Release 9.0.1.3.0 - Production
PL/SQL Release 9.0.1.3.0 - Production
CORE 9.0.1.2.0 Production
TNS for Solaris: Version 9.0.1.3.0 - Production
NLSRTL Version 9.0.1.3.0 - Production
Yes it is. We actually had to do it for a
canned app that checked the exact version of the database...for no apparent
reason. The app would only run on 8.1.6 and we were running 8.1.7...so we
just created a table with the exact same structure as v$_version and update the
table to reflect
Check gubinst_name in table gubinst (Form: GUAINST).
Shamita
Shamita Singh
George Brown College
[EMAIL PROTECTED] wrote:
Does anybody know if is possible to change the Oracle banner description?
Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production
PL/SQL Release 9.0.1.3.0 -
Actually...went to look and see
exactly how we did this...(it was quite a while ago)... We didn't
drop the v$version public synonym. We created a private synonym with the same
name in the schema the app ran in and had it point to the new dummy table.
-Original Message-
I don't know much about Oracle,
Is there a spelling mistake in the command you gave ?
SQL set autot trace
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 28, 2003 09:19
Guys,
when i try the same from a different machine,i get the
Wolfgang,
Thanks for the offer. You're lucky. I got to go to New Jersey for the last
three days. The trace I posted was my initial run with no attempt to tune. I
had just never seen such a large discrepency between the wait elapsed time
and the wall clock time in the trace file. The explanation
Zounds, that's quite an app...
If you haven't yet seen it, you might have a look at metalink note
106140.1:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_d
atabase_id=NOTp_id=106140.1
aka:
http://tinyurl.com/ibcb
Unfortunately, I don't think there's good news in
HI ,
Please kindly share your experience or any known
issues with Oracle reports 9i on oracle 9i2 Database
on SUN Solaries. We would like to move from 8.1.7 to
9i2 and from reports 6i to 9i.
OS: Sun solaris 8
DB : 8.1.7
Reports : 6i
To DB 9i2 and reports 9i.
with many thanks,
Ravi.
At the risk of stating the painfully obvious--you realize that those 'production'
designations refer to the oracle db software itself, and not your use of the db, right?
One other thing to consider would be setting your sql*plus prompt to include the SID
of the db to which you are connected.
SQL-Plus is a little like the old interactive fiction games (text-based games, like
'Adventure' or 'Zork'). You only need to type enough of some words so that they are
unambiguous. See the SQL-Plus User's Guide, command reference (chapter 8 for 8.1.7,
chapter 13 for 9.2.0) for details.
I'm
I am going to import an Oracle 7 database into an Oracle 8.1.7.0.0 instance
that I am going to make. I have 31 tables of which 11 hold LONG and/or LONG
RAW column datatypes. What storage clause should I put on the tablespace to
hold the LOBs most efficiently?
thanks,
David Ehresmann.
--
Of course, anytime. Have fun with the CBO trace.
At 01:19 PM 7/28/2003 -0800, you wrote:
Wolfgang,
Thanks for the offer. You're lucky. I got to go to New Jersey for the last
three days. The trace I posted was my initial run with no attempt to tune. I
had just never seen such a large discrepency
You won't be storing LOB's, you will be storing LONG's.
Oracle does not automatically convert LONG to LOB for you.
You will have to do that yourself ( check on MetaLink ) after
you import the data.
Assuming that your new database will be using LMT's ( locally
managed tablespaces ) I would think
Jared
This is not the case. I had imported a 150 Gig table containing LONG RAW column to BLOB with simple Export /Import sometime back last year and the only thing is that the column name given to BLOB column is same. This is export import from 81.7.3 non -partitioned table to 8.1.7.3
Sorry I press Sent button in mine earlier reply and what I missed is that you need to pre-create the table with LOB column before importing the LONG RAW column table export
Thanks
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687
However, failed transactions must be handled from
client side. Queries may migrate to surviving nodes transparently.
Also, currently RAC has many problems, such all
nodes hanging when one node dies. Completely separate systems are still (an will
always be) the most available solution.
HEre is the full reply as I am looking that mine second reply come before the first reply and this happend few times today
This is not the case. I had imported a 150 Gig table containing LONG RAW column to BLOB with simple Export /Import sometime back last year and the only thing is that the
When storing lot's of LOBs id worry
about:
* whether in-line storage is allowed
* PCTVERSION - for read consistency (LOBs do not
use rollback segments for data pages, only )
* CACHE - default is nocache, this requires always
direct reads writes which can hit IO. But if you do cache, this
Hi,
Read the metalink article Note:116091.1 which may solve your problem.
/Quamrul
From: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Problem with Autotrace ?
Date: Mon, 28 Jul 2003 13:14:23 -0800
I don't know much
Thanks, I thought that import would not do that for you.
Don't listen to me...
Jared
Indy Johal [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/28/2003 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Hi,
I am looking at using Oracle AQ to post messages.I know they are just like
any other database table but with some limitations.i have some concerns from
what I have heard from users who have previously used AQ
1.Are there any serious concerns in using AQ.My purpose of using AQ is just
to act
Tanel,
Are
you sure that all nodes hang when one node dies? Not in my experience ... do you
have version numbers on hand?
I am
very interested ... asI have 5 production and about 25+ (devl/acpt type)
instances on RAC and when node dies the other one always takes over. But I am
very
Title: RE: Oracle AQ monitoring questions
We use AQ extensively on one of our database and have no issues. v$aq provides good interface (but it is very slow, trace it and you'll know why).
Raj
-Original Message-
From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]]
Sent: Monday,
To fix this problem, compile your package with AUTHID CURRENT USER
directive in the Package Signature.
Basically when user B executes package of user A, for the course of
the package's run user B becomes user A and the ownership context is
that of user A's. When user B runs
100 matches
Mail list logo