I've received additional insight from Stephan Haisley of Oracle.
Bottom-line, it sounds like the real trade-off is that if a larger
number of CR versions could be left on a chain, then the number of undo
operations required to fulfill a given query might be reduced, but at
the expense of longer
Given IBM AIX and Oracle 81.7, i have dumped to tape the Oracle database
and all
the Oracle directories. The instance id is AAA. I have restored
everything on another
server with instance id BBB. The data in directory oraInventory still
points to instance AAA.
How can i change the data in
Hi All,
How can I use utl_http.request for https pages with Oracle 8.1.7
?
Any ideas !! It is very urgent.
Thanks Regards,
Pradeep
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pradeep Kumar Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
sequence. [ The column name is USERNO ]
This table is quite heavy and the current situation is USERNO have reached
it's maximum value i.e. 9.
No more records can be inserted
Yay, I'm hitting one a day now!!
I won't forward anymore, I could become the king of spam myself! ;)
-Original Message-
Sent: 20 February 2003 01:44
To: [EMAIL PROTECTED]
FROM: BALDWIN ONUIGBO ESQ
REPLY TO: [EMAIL PROTECTED]
ATTN:
I am Baldwin Onuigbo, Bank Manager of DIAMOND BANK
If you are using the media management layer (ie rman
talks to tape devices) then you can't beat rman.
If rman is just dumping to disk, and these are going
to tape manually *and* you only want the most recent
backup, then you can't beat rman
If you want to be able to restore from various points
Title: Lengthy Table and/or column names
Well,
yes there are. It is very likely that you will want to name subsequent database
objects which are closely associated with that table (indexes, constraints,
etc)with the table name as the prefix (or suffix). The longer your
original table name,
ALTER TABLE user_details MODIFY (column_name NUMBER);
Regards
Naveen
-Original Message-
Sent: Thursday, February 20, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
Sorry all, this was supposed to go to the OT list!!
Mark
-Original Message-
Sent: 20 February 2003 09:22
To: Multiple recipients of list ORACLE-L
Yay, I'm hitting one a day now!!
I won't forward anymore, I could become the king of spam myself! ;)
-Original Message-
Sent: 20
Hi Harsha,
You can modify column length as done in second step below:
SYSTEM@OHIL create table test121 (col1 number (5)) tablespace users ;
Table created.
SYSTEM@OHILalter table test121 modify col1 number(8) ;
Table altered.
SYSTEM@OHILdrop table test121 ;
Table dropped.
Cheers,
Rajesh
i think altering the table will be the only solutionalter the size of
the column to 10 or 11 depending on the requirement.
santosh
-Original Message-
Agrawal
Sent: Thursday, February 20, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I need a urgent help.
I have
Export using query option
Regards
Naveen
-Original Message-
Sent: Thursday, February 20, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have a requirement like this:
I have a transaction database(OLTP) and after closure of every day's
transactions, i need to move data
u need to increase the length of the field USERNO and make corresponding
changes in the application where you are accessing this field.
Syntax will be something like this
Alter table table_name modify column_name;
HTH
Kranti
I cannot trust my network admins. They do crap without any notification. They will
make a change and then I will spend the next day trying to figure out what happened.
Their typical response is Oh, we didn't know that the databases would be affected.
DO NOT TRUST NETWORK ADMINS. And from
Kick his butt Jared!!! ;o)
-Original Message-
Sent: Thursday, February 20, 2003 3:59 AM
To: Multiple recipients of list ORACLE-L
Sorry all, this was supposed to go to the OT list!!
Mark
-Original Message-
Sent: 20 February 2003 09:22
To: Multiple recipients of list
Kirti:
I have not complely following this thread. But I am sure it is worth
mentioning even if someone already mentioned also. In ASSM there would
be two highwatermarks called low high water mark and high high water
mark.
The high high water mark is the actual high water mark (like in the
Cary:
I guess the parameter just puts a softlimit of number of CR Blocks per
DBA. But I have seen more number of CR copies (10+ CR copies per DBA)
many times. But then I was using Relative File# in the X$BH while
querying (though the chances of same block# in the different files
becoming hot is
Harsha,
You may even have to drop and reacreate the sequence number (if it is at
it's max too). Recreate it with the same name and start at its current
value and increment by 1.
What is running on top of the tables? You said no change or minor change to
the software... Will making the column
Title: Message
in general since they moved most support to
India
you get analysts that are more interested in
playing
the blame game than solving
problems.
Being
an Indian I am sad to hear this, but I have to admit there's some truth in it.
It is difficult to analyze why it should be
Kirti:
There are some (or more) errors in my previous post. The process can
not find the partly filled/free blocks until it scans the L1 bitmaps
(I said L2 bitmap in the previous post as I was in half-sleep while
composting the message) and the L2 bitmaps just point the scanning
process to the
Please use the following
SELECT TEXT FROM ALL_SOURCE WHERE NAME = 'object_name'
Cheers,
Ajay Kumar
-Original Message-
Sent: 19 February 2003 23:11
To: Multiple recipients of list ORACLE-L
Look at dba_source or user_source.
[EMAIL PROTECTED] 02/19/03 04:03PM
Im mucking about in the
Hi Harish,
The only solution as per my understanding you have is to alter table and
increase the size just by 1. That will give you 10 times more room than as
of now.
Then start looking at forms, reports, DB_Objects , Local scripts etc etc to
make the possible changes..
In case your DB
Lisa,
I'm using Windows 2000 with Oracle DataBase 9i.
And I had a similar problem with you afer install the database.
The Listener service does not show in the list of Windows services.
Try stop the listener and restart it.
Use the application LSNRCTL at Commaand Prompt
Type STOP and them START.
Hi,
Thanks to all who reply. After setting the job_queue_processes to 1 and
job_queue_interval = 90, the job runs successfully. Thank you.
Regds,
Catherine
-Original Message-
From: Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent:
vendor hat on
1.To perform what you mention
you have to query
Oracle
you have to query SQL
Server
and
then joint the two result set and then use any statiscal function to have
average, top5, ...
2.Multiple datasources
can be connected at a time
3. Brio Intelligence
server is a
OURs keeps telling me what a piece of crap Oracle Apps is, not nice and
simple like an OS install or an Office migration and WHAT would they
need to test what THEY do for... they blanket install everything the same
time... it IS after all, only an OS patch..but when apps pukes because no
one
Title: RE: Lengthy Table and/or column names
A team of developers are already complaining of oracle's 30 character limit on names for their pl/sql code.
I left the room for to have a good laugh ... it isn;t polite to laugh in front of someone ... right?
Raj
Bob,
Take a look at USER_SOURCE
-Original Message-
Metelsky
Sent: Wednesday, February 19, 2003 5:03 PM
To: Multiple recipients of list ORACLE-L
Im mucking about in the user_ views...
Im seeing dba_objects type = 'procedure'; but need to find the sql
Thanks
bob
--
Please see the
Title: RE: DBMS_JOB : Can submit but does not execute
In 8i I have had bad luck of submitting it at sysdate and they don't fire ...
Once I got burned, I can afford 5 seconds ... if it is that critical, dbms_job isn't the tool for that job anymore.
Raj
In an attempt to get a handle on the overhead
of the LHWM / HHWM thing, it's worth noting
that you seem to get bitmap blocks per extent,
and that the bitmap block caters for formatting
16 blocks at a time within that extent.
The Low HWM is the point up to which all the blocks
are formatted - and
I succesfully intall Oracle 8.1.7 on RHL 7.1 throw OUI, then
runs Net8 CA,
when I do Listener configuration, Net8 CA hangs.
Wheremay beerror?
I have installed compat-glibc, compat-libs, compat-egcs and
jdk 1.1.8
Best Regards
Edouard Dormidontov
hi sree!
since the shells (whether korn, bash or any other) are very powerful
and cmd.exe is a rather poor thing, i would suggest the following:
either:
find someone who is capable of shell programming and has been on NT
or can read the screen after typing HELP in cmd.exe
he will have no problem
Raj,
Not really. I just wanted to know people's experience in general with
Resource Manager on 9.2. I'm not sure that it's being used much. You
are the only person who responded to my email. Perhaps not many people
are running on 9.2 (especially in production).
We ended up turning it
My mistake. I got you confused with someone who was having a Windoze
problem. However, your error messages are indicative of an environment
problem. Usually that's an ORACLE_HOME issue. Check your listener.ora
file and see how the ORACLE_HOME is set under the SID descriptions.
The
Title: Follow-up on Legato Registration Offer
Everyone:
This is a letter from the IOUG to all the Alliance Partners. The Legato offer is subject to several
stipulations. Please read and pass
on.
Thank You
Stephen P. Karniotis
Product
Architect
Compuware
Corporation
Direct:
No, it is different, 2790007.
-Original Message-
Sent: Thursday, February 20, 2003 1:24 AM
To: Multiple recipients of list ORACLE-L
Is this bug 1210242? If yes, then it's been around since I believe 8.0.5
(with patches all over the place).
Cary Millsap
Hotsos Enterprises, Ltd.
I am trying to use the DELETE ARCHIVELOG command that is available in
version 9.2.0.1. The complete syntax I wish to use is this command:
RMANdelete archivelog until time 'trunc(sysdate)-2' backed up 1
times to tape;
I have tried this as part of a backup script and as a standalone
Vijaya
There are several methods you can use to accomplish this. I think you
will have to explore the various methods in your environment and decide
which one seems to work best for you:
1. Export with a query (Naveen's suggestion)
2. Database link.
3. Transportable tablespace.
Ed
In my opinion, it comes down to:
If you have hot backup running very well on an existing system, stick with
it. Otherwise use RMAN. Technically, hot backups can create more redo
records, while RMAN has negligible affect on the production system, near as
I can tell.
Dennis Williams
DBA,
What books are "recomended reading" for
RAC?
Especially Tru64 based
RAC?
Beside paper books, are there any
goodweb pages(beside metalink, of course) that are dealing with
RAC?
Thanks,
Vladimir Barac
We're using it with 8.1.7. We're using resource manager to prevent parallel
queries on the OLTP nodes of our OPS database.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Subject:
Frank-
We used to copy our stuff this way on AIX, and still kind of do it this
way on Linux, but use vmware. What specifically is the problem? Is it
that you want to change all of the references within the oraInventory
directory structure to recognize the new instance name?
-Candi
On Thu,
Thanks for all the replies...
A summary
{user|all|dba}_source
LOCDB SQL desc dba_source;
Name
---
OWNER
NAME
TYPE
LINE
TEXT
Hi everybody
I'm experiencing some problems with the endian byte order parameter while
processing data files from a mainframe platform (OS/390).
The data contains integers (smallint, 2 bytes long), which come in big
endian format (high byte first). I'm importing the data on a Linux (PC)
platform
It sounds like you're using code that checks for the existence of the sgadef
file to see whether the instance was running. As part of our upgrade
process we changed our code that did that (there was a fair amount of it) to
check for the SMON process instead.
HTH,
Jay Miller
-Original
April - One thing I've discovered is everyone is frustrated with their ERP,
whether it is Oracle Apps, SAP, Peoplesoft, etc. I think the ERP systems are
vastly more complex than a mere OS, or maybe not so self-contained.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Links:
http://www.ixora.com.au/
http://www.dbasupport.com/
http://www.dbazine.com/ch_oracle.html
http://www.evdbt.com/links.htm
http://www.jlcomp.demon.co.uk/
http://www.hotsos.com/
http://www.pc.ibm.com/ww/eserver/xseries/clustering/parallel_server.html
My guess would be it's the pinning issue. A pinned block will *never* be
expelled, and the Oracle kernel is very unlikely to come back later to
do an operation that's not possible to accomplish right now.
However, having said that, it's likely something else too. I say this
because I haven't even
I guess the problem is that you want the new ORacle_home , and not the
instance name to be recg. as far as I know Orainventory doesn't check for
intance names , just oracle_homes ( which is what matters regarding
instalations - one instalation several instances, etc. It's very hard to
cheat
Vladimir,
The
official manuals do a good job. Besides from that The O'Reilly Oracle Parallel
Processing book is quite OK, but it repeats a lot of the info in the manuals.
There
happens to be a book called: Tru64 Unix Oracle9i CLuster quick reference
(Digital Press) written by Tim Donar.
Gopal,
Thanks for the info.
As I said earlier, I have not played a lot with ASSM.
- Kirti
-Original Message-
Sent: Thursday, February 20, 2003 5:10 AM
To: Multiple recipients of list ORACLE-L
Kirti:
I have not complely following this thread. But I am sure it is worth
mentioning
Vladimir:
I have not seen any GOOD book for RAC (for that matter even OPS). But
the Oracle documentation is very good at least in that front. There are
some other books coming (or already published???) for RAC, check
amazon.com for the details.
=
Have a nice day !!
Dear List,
I have changed my RMAN backup script to use multiple channels(3) as we have
plenty of tape drives. It is taking the same amount of time as it used to
with single channel. The DB size is 120gig. The output indicates it is using
three channels while backing up. Anyone has any idea why
Hi John,
If I'm understanding what I'm reading from the 9i Concepts Guide, I think that
non-default block size objects can only go into the cache with the same block size
(meaning it can't go into keep buffer). I'm making this assumption because we can't
create a tablespace of 16k blocksize
I joined this thread late - another possibility is using the sqlplus COPY command in a
script. Again, depends on volume of data, etc. etc.
REM number of record groups before commit occurs
set copycommit 1;
REM number of records in each group
set arraysize 1000;
copy from uname/pwd@yourdb
I know that a few list users are using DB*Expert SQL tuning tool by
Leccotech.
We are using the latest version on a 9.2.0.1 database. On occassion, I
have seen that when we do a batch run of optimized SQL to find the fastest
SQL we see a fairly wide disparity between elapsed time and response
And forget about gsd and srvctl - that stuff has nothing to do with RUNNING
the database (but has to do with e.g. software install). Also, the parameter
is cluster_database=false, parallel_server was for OPS back in Oracle8i,
which (as everybody knows:-) is completely different from RAC.
In
There seems to be something that you miss in this discussion: Writing applications!
It's very likely very true, that you can use your DBA skills from one database
and apply them on another, but many application developers have truely failed
to understand that the different databases are very
SELECT TEXT
FROM DBA_SOURCE
WHERE NAME = 'object_name'
and owner='owner name'
order by line
just in case two people own objects with the same name. And while it
MIGHT do the select in line order, it doesn't hurt to ensure that you
are reading the lines of code in the proper order :)
--- Bob
. re-write those in Perl. Test the Perl version on NT. It will work on UNIX as
well :)
Am I right, Jared?
- Kirti
(Perl Newbie)
-Original Message-
Sent: Wednesday, February 19, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L
The best thing to do is document the logic in
You can also use the $ORACLE_HOME/bin/sysresv to check whether an instance
is up or not.
-Original Message-
Sent: Thursday, February 20, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
It sounds like you're using code that checks for the existence of the sgadef
file to see
Try yappack:-)
/Bjrn.
Ray Stell wrote:
google can't find yapp_pack.zip, where did you find it?
On Wed, Feb 19, 2003 at 12:50:20PM -0800, Chris Stephens wrote:
List,
I've recently run this EXTREMELY useful set of scripts from miracle A/S to
chart various info from my
We've currently got Names Server running on 4 host boxes. If one Names server is down, the client is configured to automatically attempt to connect to the next one in the list. We had a problem recently were, if we issued a tnsping from any of the clients we got the following message.
TNS-03505
Title: Message
I'd also recommend the book TruCluster Server Handbook co-authored by Jim Lola.
Doesn't cover RAC, but goes into a lot of detail on the Tru64 clustering
side. Jim really knows his stuff - I worked with him last year installing
RAC at the company he works for in South San
Any suggestions?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 7:28 PM
Ok, here's my current disk setup before the Oracle install and mount
points:
bash-2.05$ df -k
Filesystemkbytes
Babu - We allocated multiple channels on an RMAN disk backup and the backup
time was reduced. I would suggest you try to figure out where your
bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several
features to keep the tape streaming, you may want to look at these. If your
It is also a good idea to include the type or you can end up with such
confusing things as the text of a package mixed with the text of the
package body.
Pat
SELECT TEXT
FROM DBA_SOURCE
WHERE NAME = 'object_name'
and owner='owner name'
order by line
just in
List,
Does anybody have experience with dbms_debug? I ran the following, a
sample:
alter FUNCTION SF_REMOVE_CHARACTER compile debug;
alter PACKAGE P_ACCOUNTS_PAYABLE_1 compile debug;
alter package P_CALC_MED_DEF compile debug body;and so on
I can't recompile two of my packages and
Zabair:
Interesting problem. Where
is the names server repository located?
We have implemented the Dynamic Discovery Option of the Oracle Names
Server. Additionally, we
implemented multiple names servers and used the internal replication facility
to keep them in sync. I will send
Well, I was going to say that, but thought everyone might be
tired of hearing it by now.
Jared
Deshpande, Kirti [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/20/2003 08:38 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I have
not played with RAC yet but was wondering why we should shutdown down the
database (except for the SYSTEM TS).
Can't
we put the Tablespace in the offline mode and then move/rename the
file?
Can we
still put the TS in the offline mode in RAC? Is it doable from any instance or
Ok, I'm working on a 8.1.7 Tru64 system with 10 groups of redo logs with 2
members; 5 groups on each of 2 mount points. I've finally taken a close
look at the order each group is used and I'm not happy. Four of the 10
switches are between redo logs on the same mount point. Now I'm not sure
Title: RE: dbms_debug
if you recompile without DEBUG option, debug info is lost ... that is what you want right?
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have
You may also want to add these 2 parameters to your sqlnet.ora.
Speeds up the switch to another nameserver.
NAMES.INITIAL_RETRY_TIMEOUT = 5# Wait num
seconds before going to next nameserver,
default=15NAMES.REQUEST_RETRIES = 2# Number of
retries for nameserver, default=5
Gene [EMAIL
I found a tech support person's direct phone number in an old email and
called her. She told me that Response Time is the time that it takes to
bring back the first record and Elapsed Time is the time it takes to bring
back all of the records. So, if you're writing to a form or to a web
We run
4 Names servers on 4 different host machines, each having its own repository
database on that host.
These
are defined in various preference order in SQLNET.ora file on various clients.
Repository databases are monitored by other mechanisms.
-
Kirti
-Original
Dennis,
Thanks for your reply. Iam taking tape backup with 3 channels as we have
multiple tape drives. I don't know where the bottleneck is. In the RMAN
output I see it is using all the three channels simultaneously with 10
datafiles per channel. But Iam not getting the throuput. It is taking the
I have
to confess, our database is 8.1.7, not 9.2.
-Original Message-From: Bjørn Engsig
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 12:04
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
RAC 9i - renamin filesAnd forget about gsd and srvctl -
that
The _db_block_max_cr_dba parameter was put in to fix this problem with massive
number of CR copies (segment header blocks mostly). I remember seeing a test
case that had 1500+ CR copies of the segment header block. So the fix was to
limit the number of CR copies. The parameter
David,
I can't recompile two of my packages and the Oracle tech said
shutdown and
start backup. When I did that and re-compiled everything
was fine. The
two packages had a lock on them (ora-04021). I read the
Oracle docs on how
to use dbms_debug but there is no information on:
You
can try.
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 2003 1:34
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
RAC 9i - renamin files
I
have not played with RAC yet but was wondering why we should shutdown
good point! forgot about packages :)
--- Pat Hildebrand [EMAIL PROTECTED] wrote:
It is also a good idea to include the type or you can end up with
such
confusing things as the text of a package mixed with the text of the
package body.
Pat
SELECT TEXT
Title: RE: GR OWS
LMAO.. Now you need a database named WHUP and A$$
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: GR OWS
A good website for appropriate
Zabair,
In addition to the excellent replies you have recieved, be aware that the
Name Server will keep an open connection to the Repository, but will check
the local cache (in the names directory) to resolve any queries. (Performing
a DB query for every name resolution can be expensive!) I have
Title: RE: dbms_debug
I have
been chastised before for leaving packages compiled in debug mode before.
Suppossedly it incurs a performance hit.
Of
course I was doing this through SQL*Navigator, not command line.
And of
course I have been chastised for much worse.
Mrs.
Monkey.
Anjo personally saved my bacon when I was at a site in Dallas with
this problem. This particular problem was a vendor application ported
from Sybase and thus used select from blah_id for update; update blah;
commit; instead of Oracle sequences. These guys had 1,200+ CR copies of
each little
Title: RE: dbms_debug
Yes ,
that is what I did and it seemed to work.Are there any performance
issues with debug after you compile with debug?
thanks,
David
Ehresmann.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20,
2003
Title: RE: GR OWS
FWIW
We have ASSP, SCRP,SCRU...
:)
-
Kirti
-Original Message-From:
Loughmiller, Greg [mailto:[EMAIL PROTECTED]]Sent:
Thursday, February 20, 2003 1:16 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: GR OWS
LMAO.. Now you need a database
On Thu, Feb 20, 2003 at 09:33:52AM -0800, Bj?rn Engsig wrote:
Try yappack:-)
nope, yapppack works
/Bj?rn.
Ray Stell wrote:
google can't find yapp_pack.zip, where did you find it?
On Wed, Feb 19, 2003 at 12:50:20PM -0800, Chris Stephens wrote:
List,
I've recently run
Michael
The reason to use multiple members in each group is so each member can be
on a different device (that is device, not just a separate mount point on
the same device). Then if a terrorist sprays your computer room with
automatic gunfire (or a drive crashes), maybe one of the devices will
Alright, Mogens. I'll stand up
here.
I'm
one of the two DBA focus area managers (FAMs) for IOUG 2003. My fellow
FAM
and abstract reviewers (3 of them) and I are the ones who
choose
this presentation (along with all the others in the DBA
track).
None
of us are employed by TUSC or by
Title: RE: dbms_debug
Nope ... it just bloats the code(p-code or m-code) size that
is.
Raj
-
Rajendra dot Jamadagni at espn dot
com Any views expressed here are
strictly personal. QOTD: Any clod can
have facts, having an opinion
Babu
When building an index, there are 3 (at least) tablespaces that matter:
1. Table tablespace
2. Temp tablespace for sorting
3. Index tablespace (could be the same as the table tablespace)
Ideally you will have all 3 on separate devices. I suspect for your test
cases that
Your answer was buried in the question itself. If the TEMP tablespace had to
contend with Tablespace C on the same 'disk' then such a result is expected.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
What would you see if you were allowed to look back at your life at the
Tablespace C is on the I/O path as TEMP tablespace maybe???
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 1:41 PM
To: Multiple recipients of list ORACLE-L
Subject: direct path read waits
All
We are doing some
Today I opened yet another iTar on the VERY buggy 9iAS R2 Reports Server.
Below is a CLASSIC response to my report of errors being generated.
There is a Unix generic solution that you can try . Use the command like
this :
+ rwclient.sh userid=mwh/***@prod authid=orcladmin/**
Stephan just passed this on to me...
Cary,
I really must subscribe to this mail list, but until I do, maybe you can
pass this on.
You are correct, the _db_block_max_cr_dba parameter is just a guide. I
believe that when needing to create a new CR copy and this limit has
been reached Oracle
Unless you have a fairly complex environment with multiple domains,
it may be easier to not use the repository. It isn't required.
Jared
Zabair Ahmed [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/20/2003 09:19 AM
Please respond to ORACLE-L
To: Multiple recipients of
Harsh,
after altering the column (increasing the width) make sure u dont have any
triggers/procedures associated with the table. altering the table will make
those objects invalid. so make sure to compile those objects again.
HTH !!!
-Original Message-
Agrawal
Sent: Thursday, February
John
All the tablespaces are on different disks - Sorry I should have mentioned
this in the original post itself...
Babu
1 - 100 of 156 matches
Mail list logo