RAC vs. OPS any comparison study , doc , link ?
Need it for customer already on OPS , who is considering moving to RAC
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
What may be the performance impact of using Different Data Guard implementation modes
on the primary Standby Database ?
We are Looking to do a small benchmark on the same .
Any Benchmarks done , advise , best practices , must dos don'ts ?
Thanks
--
Please see the official ORACLE-L FAQ:
Hi, friends:
I am reading install/config rac on aix cluster, and I wonder which
netcard is used to transfer cache fusion from node to node. It says one card
for public network, one card for standby network and one tty as hearbeat.
So, where will the data be transferred from node to node ?
Hi
Has anyone converted Oracle Financials from HP_UX rev 10.20 (DB v7.3.4.4) to
run on HP-UX rev 11?
The only rev 10.20 host we have left is running our Oracle Financials 10SC.
We are looking at converting to HP-UX rev 11 purely for disaster recovery
reasons.
It will be most useful to communicate
All of the editions (Personal/Standard/Enterprise) of the latest Oracle for
Windows version (9.2) will work on XP..
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd
I've been watching this thread with interest, feel obliged to report in my
experiences.
Came of replicating data (once per day) between several instances. Needed a
way to validate that post-replication all data was identicial. Dynamic
scripts do it, driven from a table which lists the tables
You can define the exact index you want to use.
/*+ INDEX ( table [index [index]...] ) */
HTH,
Mike
[EMAIL PROTECTED] wrote:
Is there anyway to hint a specific type of scan? I know you can hint a fast full scan.
I have something odd happening. I made a copy of a tablespace and transported
i know how to choose the index i want. im wondering if there is a way to tell oracle
what type of index scan to use. i know you can choose a fast full scan, but what about
forcing a unique scan? just because oracle uses a unique index does not mean it always
chooses the most efficient TYPE of
Title: RE: question about rac cache fution channel on AIX cluster
While I can't show you the output of the command ... we have two high speed private interconnects that are dedicated between machines in the cluster. And one public interconnect which is used by the whole world.
The private
On Tue, Jun 17, 2003 at 01:30:17PM -0800, Gogala, Mladen wrote:
Nope, it will not. Companies are still suspicious toward open source
and if they cannot buy it, they will not use it. The most often quoted
reason is support.
http://www.mysql.com/support/index.html
I have found their support
Jesse,
In the Open Source world I'm becoming a PostGreSql bigot. While there are a
lot of folks out there using MySql I believe they acquired an inferior product.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, June 17, 2003 6:00 PM
To:
Sorry
for the Off-Topic post.
Anyone
from australia please contact me personally, I need some
information.
Regards
NaveenDISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects.
You got it..
I use OEM in the stand-alone mode only, without the repository. However, not all
functionality is
available in this mode. But it will get you going to taste OEM ;)
- Kirti
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
-
OEM question
Hello all,
I'm
Title: Partitions of table read only
Hi,
I would like to know if it is possible and what the pitfalls are if I do the following.
Partition a large table into partitions based on date.
Data is only entered and read and never altered, so I would like to move older partitions to read only
Greetings and Salutations!
At the direction of the external auditors I have been instructed to
install/configure oracle auditing in our Oracle Applications databases.
(sweet!) The next step is to estimate how much space all of the auditing
information will take. (I plan on moving the data from
I'm trying to create a materialized view on a 7G table. I'm using UNDO and
undo_retention=108000, which if I understand correctly is 30 hours. I have
7G in UNDOTBS1 --- I shouldn't need that much. After 7 hrs I get
ORA-01555: snapshot too old: rollback segment number with name too
small
The
Kevin Toepke scribbled on the wall in glitter crayon:
Can anyone out there in oracle-l land help me give a reasonable
estimate?
billions and billions.;-)
--
Bill Shrek ThaterOracle DBA BAARF Party member #25
[EMAIL PROTECTED]
Title: OEM question
Lisa,
You can put the catalog in any database. I
have mine in a separate database right now and use rman to back it up. I
run it in archivelog mode of course. It takes less than a minute to back
itup, including the archivelogs. I used to have it with my rman
catalog but
String? Length of??
It realy does depend on how much you want to audit, and how frequently, and
how big your system is, and how much traffic it carries etc etc.
For example, if no one used your db for a month, your audit tables would be
pretty small (grin!)
peter
-Original Message-
Kevin,
It widely depends on what you are auditing, and how (eg per access / per session).
If it's per access (certainly an overkill) a sum(executions) from v$sql group by
command_type can put you on the right tracks for the number of records you may expect
(check also the oldest loading
Are both volumes laid out the same on the EMC? Perhaps you've been RAID5'd
on your UAT environment???
BAARF,
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: [EMAIL
Glad to see another PostGresql like here. I always wonder
why is MySql bigger than PostGreSql when it was inferior.
My guess is that it was widely used as Web logging, site logging
as an alternative to file based logging where people don't care
much about transaction 'n such.
Richard Ji
I've been keeping an eye on this at The Register site
(http://www.theregsiter.co.uk), who've had a number of articles on the
tit-for-tat war that now seems to be going on between Oracle, Peoplesoft,
and JD Edwards..
Oracle upped their offer today:
Oracle Boosts PeopleSoft Bid to US$19.50 per
This was just passed on to me and I'd like to share it wit the list...
http://www.palaydium.net/tech/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
I haven't tested this but would imagine it entirely possible.
What I wanted to throw out though, is somewhat of a related caution.
You can drop a table from a read only tablespace. I discovered this in
test, fortunately when I was finished testing with that table and
intentionally dropped it
And, more than likely, highly illegal. I was assume the authors on list
list will be contacting their respective publishers?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
I'm sure Dan Fink will have more (and better) information on this, as
he did a presentation on AUM at IOUG. But we did do a demonstration of
how you can get an ORA-1555 even with AUM. It has nothing to do with
trying to create another extent or how much room is left in the
tablespace but has much
Title: Upgrade gotchas - 8.1.7.4-9.2.0.3 on Windows
Thought I'd let you know since a couple of people are planning upgrades to 9.2 on Windows (that I've heard from) - here's the gotchas I ran into with my upgrade. The databases were fine but other stuff broke, of course.
After upgrading,
From our production ERP DB:
SELECT MIN(timestamp), MAX(timestamp), AVG(rowsperday), SUM(rowsperday)
FROM
(
SELECT TRUNC(timestamp) TIMESTAMP, COUNT(*) ROWSPERDAY
FROM dba_audit_trail
GROUP BY TRUNC(timestamp)
) UNION
SELECT SYSDATE, SYSDATE, 0, SUM(bytes)
FROM dba_extents de
WHERE
What do you want to audit. If all table access then I would think you
would impact performance. Are you just trying to audit signon's? If
so, the apps does that automatically.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland,
that actually makes sense when you think about it, with one question --
was the tablespace a dictionary-managed one or an LMT?
If it was dictionary-managed, it makes perfect sense. The metadata
about the table and the extents used in the tablespace are not stored
IN that tablespace, so drop table
Richard,
I believe someone else here put the magic phrase on the subject. Support.
MySql has a commercial company that you can buy support from, namely MySQL.
PostGreSql use to have a vendor who would sell you a support contract, Great Bridge
Software. Don't know what happen to
I shall just comment on conversion from 10.20 to HP-UX 11.
Install fresh HP-UX-11 11 on a new box. Install 10.7 version for HP-UX 11
and Oracle 7.3.4.5 .
Apply all application patches for Hp 11 version on new box.
Copy over all your datafile and migrate to new binaries.
At this stage don't
Sorry, I'm the only user with access to this database and this was the only
job running.
Very frustrating two days of reading manuals and metalink has not improved
my warm and fuzzy about using UNDO.
Yes, agreed. But out of all the MySql running out there, how
many of them do you think people purchased support for? People
run MySql just like Apache because it's free. And they get most
of the support through internal mailing-list, groups etc.
Richard
-Original Message-
Sent:
okay, am I missing something?
I created an LMT. Created a table in it. Gave no one quota on the
tablespace.
did (both as system and sysdba)
alter tablespace test_drop read only;
and hung
what did I forget to do?
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
that actually makes sense
Oh yeah, I supposed this would help, too:
SELECT *
FROM dba_stmt_audit_opts;
AUDIT_OPTIONSUCCESS FAILURE
ALTER SYSTEMBY ACCESS BY ACCESS
TABLE BY ACCESS BY ACCESS
CLUSTER BY ACCESS BY ACCESS
TABLESPACE BY ACCESS
Richard,
Oh Contrare, if your using MySql for a commercial purpose then you owe MySql
AB in Germany $475 US, at last look. Here's from their web site
(http://www.mysql.com/products/licensing.html):
MySQL Licensing
Policy In Brief
This is our licensing policy in brief: Our software
What's in the alert log file for this error?
Does it report any undo segments getting off-lined?
- Kirti
--- Thomas Day [EMAIL PROTECTED] wrote:
Sorry, I'm the only user with access to this database and this was the only
job running.
Very frustrating two days of reading manuals and
As a suggestion I would simply download, read the doc and install. I had
mysql installed and database built in about an hour. (not to
oversimplify it) but the docs are very good and will have you running in
no time.
Your coming from an oracle background so
architecturally/(instinctually), it
Jack,
We use the methods you are asking about. The partitions are created
and the table uses the range option to place the data in the correct
partition according to the date field. Each year I place the partition
in a read-only status and the back it up and place it on the shelf. RMAN
will not
Wow, great question, Rachel.
I truly didn't think of that until you asked, but, it turns out it was
LMT, uniform size, etc.
[EMAIL PROTECTED] 06/18/03 11:50AM
that actually makes sense when you think about it, with one question
--
was the tablespace a dictionary-managed one or an LMT?
If it
You're missing something, but I couldn't say what...
I tried toying with the same thing, but I'm having a lazy afternoon, so I
used Enterprise Manager:
Set up a new tablespace, created the table, sounds the same so far...
put a few rows into it, again using the nice graphical interface that
Rachel,
You forgot to kill all other active transactions... ;(
- Kirti
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
okay, am I missing something?
I created an LMT. Created a table in it. Gave no one quota on the
tablespace.
did (both as system and sysdba)
alter tablespace
I thought that's only when you use their MySQL which has
some addon features. But if you download the free MySql you don't
have to pay anyone.
-Original Message-
Sent: Wednesday, June 18, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Richard,
Oh Contrare, if your using
Wednesday, June 18, 2003, 12:34:19 PM, Jesse wrote:
JR And, more than likely, highly illegal. I was assume the authors on list
JR list will be contacting their respective publishers?
My thanks to Rachel for pointing this out to me, else I'd
have missed it. It turns out that O'Reilly, at least,
Hi
Gurus
I am looking for a
tool/method resource to migrate over 100 reports written in Oracle character
based reporting tool to Developer 6i. Appreciate any help link or any method
that could speed up this process. There is link on Oracle Metalink that refers
to forms migration, I am
Wednesday, June 18, 2003, 12:34:19 PM, Jesse wrote:
JR And, more than likely, highly illegal. I was assume the
authors on
JR list list will be contacting their respective publishers?
My thanks to Rachel for pointing this out to me, else I'd
have missed it. It turns out that
Title: Partitions of table read only
Jack,
It is possible to have some partitions of a table
read only and some read write. Possible even if they are subpartitions. They are
requird, say, in a DW environment, where the current quarter's data is read
write but the rest are read only.
You
all other active transactions in the database? or against that table?
if in the database, it will have to wait, this is a testing database
and work is going on in it.
if against that table, no one else knows anything about that table. As
far as any other user in the database knows, it doesn't
Rachel,
A TS can't become read only if there are active transactions against it. You
must wait till they all finish or kill them.
A word of advice - if you decide to kill the sessions, bring the tablespace
offline and then online to flush the buffers to disk. This will ensure that
the delayed
Check
out www.kumaran.com
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Baswannappa, Shiva
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 18, 2003 2:20
PMTo: Multiple recipients of list ORACLE-LSubject:
Tool/Method for migration of Oracle character
No no, your application have to be GPL - then you need not to pay anyone. :-)
Example: You have a website and you use mySQL to store parts of the pages. So,
source of your website pages must be GPL or you have to buy a licence.
JP
On Wednesday 18 of June 2003 20:04, you wrote:
I thought that's
Title: IOUG Live 2003
Greg:
Order is
Solaris (development platform base)
HP-UX, Linux Same time
AIX, Windows Same time
OpenVMS
MVS
Thank You
Stephen
P. Karniotis
Strategic Alliance Manager
Compuware Corporation
Direct: (313)
227-4350
Mobile: (248)
408-2918
Email:
Title: IOUG Live 2003
If you are a member of the IOUG, you can use our
userid/password to obtain access.
If not, I am not sure how access is provided.
Thank You
Stephen
P. Karniotis
Strategic Alliance Manager
Compuware Corporation
Direct: (313)
227-4350
Mobile: (248)
408-2918
.
--
Chris J. Guidry
Principal Engineer, DCSI
Phone: (314) 895-6516
Fax: (314) 895-6453
Email: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guidry, Chris
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Hi List,
we get the following error when we Capture (Reverse Engineer) tables
from the data base (Oracle 9.2.0.1) into Designer 6i Release 4 :
ORA-01795: maximum number of expressions in a list is 1000 Is thislimit hard-code in Oracle (Oracle7 the limit was
254) ?
TIA
Alessandro Guimaraes
there WERE no active transactions against that tablespace.
The steps I took were:
as system:
1) create tablespace as an LMT
2) create table within that tablespace
3) attempt to make the tablespace read-only
when that hung I logged out (which certainly killed any active
transactions against that
My guess is that this has to do with being able to get a read consistent
image of the underlying tables of the mview. can you provide us with:
1. The version of Oracle
2. The statement being used to create the mview
3. Is anyone doing anything to the underlying tables while you are creating
the
This may be of interest to some people. I never knew what the exact maximum
size was for a stored procedure. One of my colleagues asked me why the
manual said that the size limit for a trigger was 32K when he had personally
seen triggers bigger than that. Below you see the answer from Oracle (on
Raj
It was available at http://www.ioug.org/2003proceedings with an id of live2003 and password can be obtained if you are the member from the site
Thanks
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687 [W]
(201) 400-3960
What? Are you sure? My understanding is if I make changes to MySql
code or some addon to MySql I need to submit my changes bakc to public
and GPL. That what the whole dispute between MySQL the company and the
community before, right?
But my application too? For just using it? What about all
Ok, I'm a bit perplexed and I need some ideas. I have two systems. From a
hardware/software POV they are exactly alike. However, one performs
consistently better than the other. I'm sure this is an IO related issue. I
have a shell script that does a bit of work on 10046 trace files. On both
Jack
I am also using almost similar kind of Partition Management where I am keeping only six months of data. In mine configuration , I have the following requirement
Daily partition created in the evening and dropping the 7day old partition.e.g I am creating Wednesday Partition on Sunday so as
With the talk about replication lately, I thought I would see what might be
out there in book land and came across this. It is currently a vapor book.
http://www.dba-oracle.com/bp/bp_book4_replication.htm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
Jack, maybe this has been covered. I seem to recall from the BR module
(knew it would prove useful sometime) that after you make a tablespace
read-only that you should take a backup. Recovering a database with
tablespaces that were read-write when backed up but are read-only now
requires an extra
Ian,
You can try resyncing the catalog and if that still doesn't work try to
uncatalog that log:
rman change archivelog '/full_path/log_name_8192.arc' uncatalog;'
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 10:14 PM
Thomas,
How long ago was the data for the mview loaded? It is possible that you are
running into the scenario where delayed block cleanout is causing the ORA-1555. Is the
name of the undo segment in the error the same as the large undo extent? I would
suspect that they are different.
Title: IOUG Live 2003
Thanks Stephen,
I am a member, but still don't see any reference to 2003 conference
proceedings, at-least not in Technical Repository section. Did I miss the
train?
Raj
Rajendra dot
Unfortunately, in the *database* .
- Kirti
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
all other active transactions in the database? or against that table?
if in the database, it will have to wait, this is a testing database
and work is going on in it.
if against that table, no
It sounds like a bad SCSI cable. Not all SCSI cables are created equal.
If you have raw partitions on both machines, do
time dd if=/dev/rdsk/cxxx of=/dev/null
on both machines. If disks are identical, CPU and memory boards as well as
the main system boards, then the only thing left is a SCSI
Richard,
I don't think there is a commercial company supporting/developing Apache,
TomCat, etc... But MySql AB is doing all of the above they want to make money. So
if all of your web pages, html code, JAVA etc... are all licensed under GPL or an
acceptable to MySql AB OSI license
Rachel,
It is not active transactions against that tablespace, it is active
transactions. Yup, period! As soon as all the active transactions complete, the
tablespace will complete altering itself.
Dan
Rachel Carmichael wrote:
there WERE no active transactions against that
Dick,
That's the commercial version your link points to which provides
additional functionality like InnoDB. But you can get free MySQL
from www.mysql.org.
Richard
-Original Message-
Sent: Wednesday, June 18, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Richard,
Oh
Ian,
This is a problem I run into a great deal. Before you backup issue this
command (I assume 9i here and pre-configured defaults so no allocate channel
commands):
crosscheck archivelog all;
backup database archivelog all;
The crosscheck command will compare the archivelogs currently on disk
How about finding out what the session is waiting on, from v$session_wait?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:29 PM
there WERE no active transactions against that tablespace.
The steps I took were:
as
That all being said, the fact that there is free space in the
tablespace implies that the 1555 is not due to an extent being
overwritten. Oracle should grab free space before it grabs other
extents, even expired ones.
Daniel,
Are you saying this correctly? The reason I ask, is I've seen a 1555
Hi,
I'm from Australia. What would you like to know?
Cheers,
Craig.
At 05:44 AM 18/06/2003 -0800, you wrote:
Sorry for the Off-Topic post.
Anyone from australia please contact me personally, I need some information.
Regards
Naveen
DISCLAIMER:
This message (including attachment if any) is
Dick
So does that mean that MySQL could do the famous Microsoft maneuver? Give
it to them free/cheap until they're hooked, then raise the price?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 18, 2003 4:25 PM
To:
Rich,
BTW, are you RAID 0ing along with your RAID 1 or are you
relying on the SAN
cache for performance? Whole DB or just data?
We are pure RAID 1 for the whole DB (along with the Apps). It was a long
fight, but worth it,and I had a savvy SA on my side early on.
John
--
Please see the
The more I thought about this (after exchanging a few direct emails with Thomas), I am
leaning
towards the delayed block cleanout possibility.
There was nothing in the alert log that indicated SMON off-lining any undo segments
(there were
only 10 SMUs to deal with). It is, however, possible
Hi Robert
Ok, I'm a bit perplexed and I need some ideas. I have two
systems. From a hardware/software POV they are exactly alike.
I hate that - I can never tell if they really, really are :(
However, one performs consistently better than the other. I'm
sure this is an IO related issue. I
The GPL does require any changes to the code covered by the GPL to be
released under the same license. That being said the code used in
conjuction with a GPL application does not have to be GPL'd. Consider
the example of compiling a c program with gcc. Your program can be as
proprietary as you
In order to complete an alter to read only, ALL transactions against the
database that were started before you issued that alter command must
complete before the alter will continue... From the concepts guide...
The ALTER TABLESPACE ... READ ONLY statement places the tablespace in a
Robert, i needed to restore some archivelogs(for applying to a clone,
its a long story, firewall issues, etc), anyways, i restored them,
pushed them to new server, deleted from disk(original source
archive_dest), this messed up repository, i couldnt ever get the
crosscheck to mark things as
No, the GPL'd code is GPL'd forever.
Allan
-Original Message-
Sent: Wednesday, June 18, 2003 4:50 PM
To: Multiple recipients of list ORACLE-L
Dick
So does that mean that MySQL could do the famous Microsoft maneuver?
Give it to them free/cheap until they're hooked, then raise the
that would explain it... and means I have to test it on my laptop, this
database is rarely quiet even in test
--- Kirtikumar Deshpande [EMAIL PROTECTED] wrote:
Unfortunately, in the *database* .
- Kirti
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
all other active transactions in
that would be sensible... :)
I'll try this again, from home and see -- but as Kirti says, if there
has to be no activity in the database, that would explain the problem
--- Arup Nanda [EMAIL PROTECTED] wrote:
How about finding out what the session is waiting on, from
v$session_wait?
ARGH!
Well, that pretty much kills the idea of using this for my data
warehouse as there is always activity in it. Dang!
Okay, I'll try it from my laptop as I can control users there :)
--- Daniel Fink [EMAIL PROTECTED] wrote:
Rachel,
It is not active transactions against that
you are better served by our commercial license
is not necessarily the same as:
you must buy our commercial license.
Either way, if you want to verify the license needs for your specific situation,
contact the company.
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL
I think the intro para quoted below is an oversimplification of the license
policy--and one that (understandably) favors MySQL AB. My reading of that
page is that it's the *distribution* of the MySQL source code (modified or
not) or binaries that requires you to have a commercial license.
I take
That's how I understand it as well.
-Original Message-
From: Nelson, Allan [mailto:[EMAIL PROTECTED]
Sent: Wed 6/18/2003 6:44 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: MySQL in the future?
The GPL does require any changes to the code covered by the
Oracle JMS as you put it is actually Oracle Advance Queuing with an
implementation of the Java Messaging Service built on top of it. If you are
going to use message queues from Java, I would suggest reading up on JMS
first and then go through a number of examples/tutorials.
For the tutorials
I was presenting a new load process and I am using straight merge selects
from external tables and one of the complaints that came up was that
Performance would be worse because I wasn't committing more frequently.
If my merge was too large memory swapping would occur and it was possibly
But its not that clear, though - look at this part:
As long as you never distribute (internally or externally) the MySQL
Software in any way, you are free to use it for powering your
application, irrespective of whether your application is under GPL or
other OSI approved license or not.
So, I
Hi!!! I create a package in Oracle. When I run the line:
Set adoRS = mCmd.Execute VB sent me the next error:
Run-time error '-214721700 (80040E14)': Ora-06550: line 1,
column 33: PLS-002001: Identifier 'P_IC' must be declare. Ora-06550: line1,
column 7: PLS/SQL: Statemnt ignored. What I am
Will that be all DML activity?
All the times?
In a datawarehouse?
In our data marts most activity is for just 'reading' stuff a lot of stuff
locally... Not many
active transactions.. So I can make TSs read only almost any time I want to..
- Kirti
--- Rachel Carmichael [EMAIL
Ms. Castro:
In the procedure declaration
PROCEDURE CL_CURSOR(p_item in varchar2, P_ICÂ OUT t_row)
the P_IC is referenced as an OUT variable of type t_row. But to use it, it
must be declared somewhere else, usually in the calling program. So, a
variable definition should exist in the package
I don't know, the system in which I
-alter tablespace sales_data read only
-test some queries
-drop table readtest
-alter tablespace read write
had 12+ sessions, and at least 3 were writing data, including one of my
own.
I'm not saying that what is being presented isn't true, just that you
still
1 - 100 of 111 matches
Mail list logo