And you may well use Logminer to determine what that exact point in time is (and then
use tablespace point in time recovery to do the actual recovery).
Bruce Reardon
-Original Message-
Sent: Thursday, 29 August 2002 2:52
There is a way of undoing DDL and it is described in the RMAN
DENNIS WILLIAMS,
hi, I finally solved it by recreate a new database and export the old data and
import it into the new database.They are on the same machine with same os and same
oracle version and same configuration.
I just failed to solve the question and tried create a new
Another solution I think of would be to set up a DBMS job using UTL_FILE
to read (and parse) the export log file and UTL_SMTP to send alerts (or
messages saying 'OK'). A bit more difficult with the hot backup, but if
the procedure is able to log failure somewhere then the same principle
could be
Thanks for pointing out the Note.
However, Note 19796.1 isn't very helpful.
It does talk of buffersize, and I have tried changing
the Arraysize (but not the buffersize) in sqlplus.
The note seems to indicate that the problem could be in
the client application.
When querying across a db-link,
Hi friends
I would like to know is there any difference
between Oracle Application Server and Oracle 9i Application
server.?
If there is difference ,then what is the First
version of Oracle 9i Application Server?
The term is confusing me.
Any one clarrify me please.
Thanks in advance
syed
I think it is correct to round -0.875 to 0.87, since what you do is multiply
a by 100 (-87.5).
If you round this, the correct value is -87. Divided by 100 = -0.87.
So, Java is fine.
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL
I am installing RedHat Linux and oracle 9i on two RM servers.
I have never run Linux before. I usually run HP L-class or Sun Sparc
servers with 8/8i.
I would welcome emails with tips anybody has for avoiding anything I don't
know that I should be avoiding yet, if you see what I mean!
OT:
I know the rule round up, but does up mean the highest value (-0.87) or
the highest absolute magnitude (-0.88)? :)
- Bill.
At 09:53 28/08/2002 -0800, you wrote:
I would think -0.875 would round up therefore -0.87 is my guess.
Rick
--
Please see the official ORACLE-L FAQ:
Hi all,
OS: SOlaris 2.8
DB: 8i
In the clean up process of the following files, I am
trying to list out the files that start with cz.
cz-session-returnui177_11Jan02_0959AM_33509.txt
cz-session-Applet178_11Jan02_0959AM_34108.txt
cz-session-returnui175_11Jan02_0959AM_20504.txt
in case you run into troubles with make consult the RH hompages and refer to the notes
for oracle 9 RH server 2.1. These hints/tips work for the distribution of RH
7.0,7.1,7.2,7.3 as well. We have Oracle rdbms 9.2.0 Enterprise edition and OID and IAS
on RH 7.2 and RH 7.3. there shouldn't be
Use the xargs command.
Read about it in the man pages.
Or use find, but that is more complex.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
OS: SOlaris 2.8
DB: 8i
In the clean up process of the following files, I am
trying to list out the files that start with cz.
www.suse.com/oracle
Although it's not Red Hat, they have pretty good instructions and tricks for
Oracle Installation, many of which are applicable to RH as well.
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002
there
was a discussion re. the OWS/OAS/OWAS/iAS versions a week or two ago on this
list.
Regards, Patrice Boivin Systems Analyst
(Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques Informatics
Branch |
I don't know if you saw the Larry Ellison presentation to the LINUX
convention... www.oracle.com, there is a link near the bottom.
The beginning is funny, with the penguin being driven around in a limo and
eating with executives.
Larry says in passing that OTN is running on LINUX now.
Regards,
I have the collections of snapshots scheduled in DBMS_JOBS, but I was
looking for a way to automate running of the reports from these snapshots.
It looks as though there is no easy way to do this.
Thanks for the quick responses.
Erik
-Original Message-
Sent: Wednesday, August 28, 2002
kommareddy sreenivasa wrote:
Hi all,
OS: SOlaris 2.8
DB: 8i
In the clean up process of the following files, I am
trying to list out the files that start with cz.
cz-session-returnui177_11Jan02_0959AM_33509.txt
cz-session-Applet178_11Jan02_0959AM_34108.txt
Hi,
IAS - Apache
OAS- SpyGlass
OAS and iAS are webservers. iAS is basically the
same as OAS, but the major difference is the listener is an Apache, and from
cartridges to modules. iAS is more or less the 'next generation' of OAS as
Oracle8i was the next generation of Oracle8.
Regards,
Dennis,
You've got that right. Damned PeopleSoft! We were hoping we might be able
to leverage ORM to control PeopleSorft query users. No such luck since everyone
is PeopleSoft. Now on the other hand, if you've got the LUXURY of having people
logged in with their own usernames you
. Oracle9i Database R2 Developers Release on Apple's new Mac OS X version
10.2 ''Jaguar.''
is much more interesting headline for me :-)
JP
On Thursday 29 August 2002 14:28, you wrote:
I don't know if you saw the Larry Ellison presentation to the LINUX
convention...
Kevin,
Thanks for your input.
Just to clarify; I only want to control this
one database. I want to limit its resources
so it does not impact the other 4 databases on
the box. So, in that case would resource
manager be beneficial ?
Also, besides profiles, and resource manager,
does anyone
Not on the oracle topic:
RH is pretty insecure out of the box. If you don't take steps
to lock it down the machine will be compromised within the hour in
our experience. There are some good web pages out on the steps
that need to be taken:
After an intense ask-your-local-mathematician-session, here you go:
It depends ;) (That's typical math-guys, isn't it ?). If you define round
according to the Gauss function, then it should calculate it using absolute
values, that would be -0.88. On the other hand, round is usually defined
to go
Hi
I
always thought iAS refers to a whole suite of things. The webserver (which is an
Apache in iAS) is one component. But there is more to it like J2EE containers, a
servlet engine, mod_perl (?), messaging and other stuff (haven't really into
anything besides J2EE EJB containers, the web
Gurus,
I've some problems with datafiles 2Gb in
HadHat 7.3. I'm using datafile type ext3 and
when i try create a datafile with 2Gb the database
is catching.
Anybody have the some problem?
any suggestion?
Thanks
Adriano.
Hi
take a look at xargs, it handles those things.
regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL PROTECTED]
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
how about;
$ find . -name 'cz*' -print | xargs ls -lt
or
$ find . -name 'cz*' -print | xargs rm
-Original Message-
From: kommareddy sreenivasa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 6:59 AM
To: Multiple recipients of list ORACLE-L
Subject: arg list too long in
I got 9i release 2 running successfully on a RH7.2 and 7.3 system with no
install or runtime problems.
I also got release 2 to run without any problems on a Mandrake 8.1 and
Mandrake 8.2.
No surprise since Mandrake is based on RedHat.
ltiu
On Thursday 29 August 2002 03:08, Docherty, Heather
I'm not sure xargs will work -- it seems to me that since xargs is
typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same
arg list too long error. I think the best way to delete the files would
be: 'find . -name cz\* -exec rm -f {} \;'
-- Philip
- Original Message -
Hi,
I recieved an email today as follows:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Title: RE: arg list too long in unix
go into the top dir and run
find . -name cz-session-* | xargs rm -f
or
find . -name cz-session-* -exec rm -f {} \;
the first runs faster but keep in mind that
in other scenarios xargs splits stdin into
file names on space and newline.
Thank you for the ideas on maintaining a reasonable size listener.log file.
I am trying out the scripts now in development to see which one works the
best for me.
Bryan
-Original Message-
Sent: Saturday, August 24, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
You can do it
I cant list them using ls -ltr *session* as this
string may change. I have to identify the files that
srart with cz only.
can somebody through somelight on this.
man xargs;
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL
Hi Ray,
I have Oracle 8.1.7 and 9.0.1 running on an Suse 7.2 box configured with
ext3 file systems. Both instances are working properly and without major
issues.
Suse 7.2 comes along with a variety of file systems , including ReiserFS ,
ext3 , ext2 , Aix´s JFS and other that I can´t recall
Got trigger happy, so I'm resending.
-Original Message-
Sent: Thursday, August 29, 2002 10:11 AM
To: DBA List (E-mail); Fat Dba (E-mail)
Hi,
I recieved an email today as follows:
Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL
[EMAIL PROTECTED]@SUNGARD
Greetings All,
In past somebody provided me some sample questions for the OCP test on Oracle 8 to 8i
Upgrade(1Z0-020). In the process of rebuilding my desktop, I have lost those.
If any of you have any sample questions for this test could you please forward these
to me. Or if you know any
Dick and Dennis,
The application here is the same, where all
users are logged in as the same user via
the application server.
But in my case, I want to throttle all the
users who use this id. Wouldn't ORM be beneficial in that
situation ? thanks.
ed
Dennis,
You've got
What are you trying to communicate to us. There is nothing in your mail.
[EMAIL PROTECTED] wrote:
Hi,
I recieved an email today as follows:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services--
I'm confused too.
What's 11i??
Is this an SAP-like application? How does it tei to 9i DB and 9i AS?
Thanks for any input.
ltiu
Stefan Jahnke wrote:
Hi
I always thought iAS refers to a whole suite of things. The webserver
(which is an Apache in iAS) is one component. But there is more
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM n clause is attached; that makes sense to me. What doesn't
make sense is the following: if we add WHERE ROWNUM 50, the query
returns 24 rows. If we add
Speaking of bashing, you can't watch Larry's presentation without the latest
version of Real Player - which is 155M!!! On our T1 that's an hour of
download time... what an oinker. If it EVER finishes downloading and
(miracle of miracles) the behemoth actually works when installed, I'll be
amazed.
Stop using MS products if you are seriously worried about viruses.
[EMAIL PROTECTED] wrote:
Got trigger happy, so I'm resending.
-Original Message-
Sent: Thursday, August 29, 2002 10:11 AM
To: DBA List (E-mail); Fat Dba (E-mail)
Hi,
I recieved an email today as follows:
Oracle 8.1.7 on Solaris 8
I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is
solaris 8, and I can't find the patches for 7 anymore, I am trying to
upgrade via an export and import. Besides, the DB is small - less than 2G.
The export was done with compress=n. There are
Inka Bezdziecka,
oops ... my previously reply wasn't complete and didn't indicate the
right context. My apologies if the reply wasn't very clear.
As I have logged a TAR with Oracle Support, I was waiting
for a reply from Oracle. That is why I put in the line
Both are Oracle products and I
Hi,
I'm sure there has been discussion in the past
about the same, but I'm more interested in the feasibility/performance of
serving images (stored as BLOB) from the database.
1. For a large multi-tier application (client,
web-tier, application, database), with about 5 million records
Post your query
-Original Message-
Sent: Thursday, August 29, 2002 9:23 PM
To: Multiple recipients of list ORACLE-L
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM n clause is attached; that
-- Philip Douglass [EMAIL PROTECTED]
I'm not sure xargs will work -- it seems to me that since xargs is
typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same
arg list too long error. I think the best way to delete the files would
be: 'find . -name cz\* -exec rm -f {}
-- Markham, Richard [EMAIL PROTECTED]
find . -name cz-session-* | xargs rm -f
This will handle files in 8K chunks; find .. -e will fork
for each file. Net result is that xargs is a much better
way to go. On a multi-cpu system you can also use xargs -P
to run jobs in parallel (at the expense
Speaking of bashing, you can't watch Larry's presentation
without the latest version of Real Player - which is 155M!!!
On our T1 that's an hour of download time... what an oinker.
If it EVER finishes downloading and (miracle of miracles) the
behemoth actually works when installed, I'll
In my haste, I hadn't noticed that, although the query did not contain
an ORDER BY, it did contain SELECT DISTINCT, which causes an implicit
ORDER BY. As we all know, ROWNUM is usually assigned when rows are
read into the cache, before sorting; thus the order of ROWNUMs in the
output is not
Creating grants and synonyms on each table?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
In looking at how long it takes, the table imports in a second or
less, but
it takes 3 minutes + to start the import of the next table. I'm not
sure
what it is doing for 3 minutes
On Thu, Aug 29, 2002 at 04:58:22AM -0800, Erik Williams wrote:
I have the collections of snapshots scheduled in DBMS_JOBS, but I was
looking for a way to automate running of the reports from these snapshots.
It looks as though there is no easy way to do this.
spreport.sql is an interactive
remove (not disable, REMOVE) constraints and drop indexes and recreate
after the import.
Change the buffer size on the import as well. Check to see if it is
committing after every row.
--- Ball, Terry [EMAIL PROTECTED] wrote:
Oracle 8.1.7 on Solaris 8
I am testing and upgrade from 7.3.4
Holes in your extents/segments. Normal. You get this after repeated
updates/deletes/inserts.
ltiu
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM n clause is attached; that
Gee, that's a helpful reply! As if we have any choice!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, August 29, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L
Stop using MS products if you are seriously worried about viruses.
[EMAIL
YES
Reply Separator
Author: Ed Lewis [EMAIL PROTECTED]
Date: 8/29/2002 7:23 AM
Dick and Dennis,
The application here is the same, where all
users are logged in as the same user via
the application server.
But in my case, I want to throttle
What's HadHat 7.3?
A new Linux distro pattered after RedHat 7.3?
ltiu
Adriano Freire wrote:
Gurus,
I've some problems with datafiles 2Gb in HadHat 7.3. I'm using
datafile type ext3 and
when i try create a datafile with 2Gb the database is catching.
Anybody have the some problem?
Trace it. www.hotsos.com/dnloads/1/10046a
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Next event: Miracle
MUM, Eric is listening!!!
:-))
On Thursday 29 August 2002 18:08, you wrote:
Stop using MS products if you are seriously worried about viruses.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
The unix problem went away with no know cause. The VMS problem turned
out to be one of thos absurdly simple fixes. The problem was a comment
in the tnsnames.ora file that didn't have a # at the start of the line.
Troubleshooting was difficult because sqlplus and the ProC applications
worked
good, thanks for the report. I'll get there one day, since
RH has been dropped on the floor, apparently.
On Thu, Aug 29, 2002 at 07:23:26AM -0800, [EMAIL PROTECTED] wrote:
Hi Ray,
I have Oracle 8.1.7 and 9.0.1 running on an Suse 7.2 box configured with
ext3 file systems. Both
Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which
is just a web server) as one of components. It requires two Oracle RDBMS technology
stacks: 8.0.6 and 8.1.7 - it is very likely that for the latest release a database
itself can be upgraded from 8.1.7 to 9i.
I tried this at your suggestion (though it didn't look like it was analyzing
as there were not status on the tables). This didn't help. I even tried
turning off archiving and no joy.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-Original Message-
Sent:
Terry,
The 3 minutes between table could be because the new database is
analysing the tables you are importing.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 08/29/02 11:23AM
Oracle 8.1.7 on Solaris 8
I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server
is
solaris 8, and I can't find
How many redo log files you have and what are the sizes for these files?
Chech the frequency of switch log and also check checkpoint frequency.
It looks like the DB has a severe contention problem. What is the size of
shared_pool and buffer_cache?
Regards,
Waleed
-Original Message-
Ok ltiu,
REDHAT 7.3 kernel-2.4.18-10
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 1:18 PM
What's HadHat 7.3?
A new Linux distro pattered after RedHat 7.3?
ltiu
Adriano Freire wrote:
Gurus,
I've
This is a good guess.
-Original Message-
Sent: Thursday, August 29, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Terry,
The 3 minutes between table could be because the new database is
analysing the tables you are importing.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 08/29/02 11:23AM
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle
Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate servers? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child. The
11i is a suite of products which include ERP and CRM products. Its called
oracle applications and runs on Oracle DB version 8 or higher.
Oracle 9i AS(Application Server) is a suite of products which include, Web
Server, J2EE server, Forms server and lot of other things
9i DB is database server,
Hi Paul,
How's going?
Maybe there are other criteria's that limits the result set to only
return 24 rows?
Richard Ji
-Original Message-
Sent: Thursday, August 29, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L
I've been given a query to investigate. The performance varies
I have to jump in at this point since the arguments for rounding -0.875 to -0.87 just
don't seem quite right (I guess I might be Gaussian about this thing). Let me use a
different approach to this argument:
Value Rounded
-0.870 -0.87
-0.871 -0.87
-0.872 -0.87
-0.873 -0.87
-0.874 -0.87
Title: RE: PROCESSING APPROACH - Oracle design issue on Unix
Guys,
In the past when writing ETL processes for data warehouses I did a lot with scripting on Unix and used SQL for some basic processing. I have been moving more into creating stored procedures and also separately been working
Actually, that's what was the 155M - Oracle's version of the latest Real
Player. That didn't work, nor did downloading it from the Real Player site
directly. I did find out the reason - Real Player doesn't work through our
(or any?) corporate proxy server for it's final part of the install
Thanks.
So does this mean 12i or 13i will be a combo between the Oracle DB and
the Oracle E-Biz (can I hear people say integration)? If this happens
then SAP is toast!
ltiu
Inka Bezdziecka wrote:
Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which
is just a
Actually. Scratch my previous email on this matter.
We have seen this problem before and I couldn't figure out how to fix it.
ltiu
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM
and indexes, too! do the indexes, constraints, grants, etc after the table
data imports!
-bill
-Original Message-
Sent: Thursday, August 29, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Creating grants and synonyms on each table?
Cheers
Nuno Souto
[EMAIL PROTECTED]
-
As we all know, ROWNUM is *usually* assigned when rows are
read into the cache, before sorting;
Always
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM n clause is attached; that makes sense to me. What doesn't
make sense is the following: if we add WHERE ROWNUM 50, the query
You always have a choice. Sometimes it is difficult to make the right choice.
Consider a high school student who is doing poorly -- they can make the easy choice
and drop out or they can make the difficult choice and work harder. In the case of
M$, the easy choice is to accept whatever M$
Title: RE: ROWNUM strangeness?
show the full sql please, perhaps its how you are grouping your
conditions
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM n clause is
Help!!!
I have load the oracle 9i Database on my Linux Server running SuSE 8.0 Pro.
The installation went fine, but the database keeps getting corrupted data
blocks.
Does anybody know why this keeps happing. I had thing running before and
then I had a disk drive crash. 30.7 gig drive).
Do not believe him :)
-Original Message-
Sent: Monday, July 29, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
If the Export has been taken with DIRECT = Y, meaning that the SQL
Evaluation buffer has to be bypassed then Import would not generate the Redo
buffer while
I am looking for a hot backup script that has been successfully used on
UNIX(Solaris). Wouldn't mind using the Velpuri scripts, but they seem a bit
complicated and we have had some issues trying to actually implement them.
Would really appreciate seeing what other people are using. Also would
Put the table in NOLOGGIN.
-Message d'origine-
De: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Date: jeudi 29 août 2002 18:58
À: Multiple recipients of list ORACLE-L
Objet: Re: IMPORT sl
remove (not disable, REMOVE)
Here is a most excellent post from Kirti Deshpande,
[EMAIL PROTECTED] earlier on some import /
export principles that may help you.
If you like it, pass on your thanks to him.
PEACE.
Mike
Prepare scripts to build tables, indexes and constraints etc.. Prebuild the
tables in the target database.
Paul,
It's because of how ROWNUM is interpreted.
The first query only returned the first 50 rows it found and you got 24 that
passed the rest of your criteria.
The second query returned 1000 rows of which only 336 passed the rest of
your criteria.
Makes perfect sense to me. This is why
My first suggestion would be to try release 2.
Second suggestion is that your new hard drive is defective.
ltiu
Joe A Cairns wrote:
Help!!!
I have load the oracle 9i Database on my Linux Server running SuSE 8.0 Pro.
The installation went fine, but the database keeps getting corrupted data
All,
Is there a way to identify unused indexes in Oracle
8i. I know that it is easy to check with 9i. I would
appreciate if you could share your experience (or
ideas) with me.
Thanks,
Bob
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock
Hi
Does some one have DB down script on Sun solaris.I mean to say if instance
down I will get page .
Thx
-Seema
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
Please see the official ORACLE-L FAQ:
It doesn't really matter what OS you have. Intel hardware can only
handle 2Gb files sizes max. Even if the hardware can support large
files, it is still recommended that you do not have large datafiles. You
need to partition your tablespaces into multiple datafiles. This
facilitates backups
Title: Failsafe and OEM automatic discovery
I am running OEM and OMS 9.0.1 on WIN2000 and am having ptoblems discovering databases on a two server Oracle Failsafe cluster.
I am running Failsafe 3.3.1 on a two node cluster.
Database DB1 on node 1 (cluster group GRP1)
Database DB2 on node 2
I believe you have ROWNUM confused with ROWID.
--- ltiu [EMAIL PROTECTED] wrote:
Holes in your extents/segments. Normal. You get this after repeated
updates/deletes/inserts.
ltiu
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely
Linux or MacOSX are good alternatives for the end user.
ltiu
kkennedy wrote:
You always have a choice. Sometimes it is difficult to make the right choice.
Consider a high school student who is doing poorly -- they can make the easy choice
and drop out or they can make the difficult choice
Actually, ROWNUM has nothing to do with
extents/segments/inserts/updates/deletes. It is all about access paths. The
solution posted makes sense as ROWNUM can be affected by many subsequent
operations.
-Original Message-
Sent: Thursday, August 29, 2002 11:04 AM
To: Multiple recipients of
It has always been.
SAP is just one of ..., as is Oracle - and none will go away for the foreseen future.
The common competitor is, or would like to be, Microsoft with its acquisition of Great
Plains.
-Original Message-
Sent: Thursday, August 29, 2002 1:54 PM
To: Multiple recipients
To be exact...
Rownum is sequentially assigned for each row that meets the predicate. If
the row does not match the predicate condition, it is discarded and not
assigned a rownum. Below is an example using our friendly EMP table.
As for sorting, rownum is assigned before any sorting. However,
Quite true, but ironically enough, the xargs manpage (on my system as well
as many others) only has examples using ls to feed xargs. I meant to end
the exec param with \+ instead of \; which aggregates a set to operate on.
I'm not clear on whether that means one giant set, or several smaller
I guess this is my day to post questions to the list.
Does anyone have any ideas on how to diagnose and fix SQL-2100 (aka
ORA-2100)? The manual says
ORA-02100 PCC: out of memory (i.e., could not allocate)
Cause: SQLLIB was unable to allocate enough memory to execute the
program.
Action:
As a WAG...
is your blocksize compatible with the Linux filesystem??
I don't understand how the OS version has a play in Oracle giving you
support. If you are paying for a legitimate license then I don't see how
its and issue.
Maybe you can post to the suse-oracle list
Title: RE: PROCESSING APPROACH - Oracle design issue on Unix
Paula,
Your
approach is fine. The bigger question that your organization needs to ask
is - if you leave, can they support it - do they have adequate staff on hand
that can maintain PL/SQL code?
I
agree with you that PL/SQL can
I agree. I got confused and my second email to disregard my erroneous
first emai on this matterl was apparently shot down by the mail filters
so it never got to you guys in time.
Sorry for the confision.
ltiu
Fink, Dan wrote:
Actually, ROWNUM has nothing to do with
1 - 100 of 183 matches
Mail list logo