I now this thing. Had it two weeks ago.
Call Oracle and ask them to come with the DUL (database unload) utility.
Your database is OUT.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 8:58 AM
OS:WIN2K
IMHO, the main requirement is that you have to have a systemthat
needs to be up 24x7 on a cluster and your ability to fork enough money to Oracle
and your server vendor (to get two identical machines) and your networking
vendor (for redundant network connections).
Rest everything is easy
We have ORACLE 8.1.7 running on server. My question is what difference on
following select statement:
select col1 form table1;
select all col1 form table1;
Look like output are the same. Thanks.
_
Surf the Web without
Because your boss is wrong on both issues: features and price.
As for references, check this site:
http://www.itsystems.lv/gints/compare_db.htm
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday,
We have ORACLE 8.1.7 running on server. My question is what difference on
following select statement:
select col1 form table1;
select all col1 form table1;
compare select distinct ...
Look like output are the same. Thanks.
Aye to that, but you'll need at least two, possibly
three, identical clusters, not just one. One clusterfor production
and an identicalcluster for QA/Test, and possibly one for development
(though that last is often regarded as unnecessary). Skimping on the
QA/Test environment is the
there is no difference
regards
naveen
-Original Message-
Sent: Wednesday, October 23, 2002 6:59 PM
To: Multiple recipients of list ORACLE-L
We have ORACLE 8.1.7 running on server. My question is what difference on
following select statement:
select col1 form table1;
select
For what it is worth... I've been battling this problem on Oracle 9i Release
2 and finally got it into Oracle as a bug. ORA-02070: database does not
support operator SYS_CONTEXT in this context. (Oracle BUG Reference
2624342) when using an object that contains SYS_CONTEXT. I don't know if
anyone
SELECT ALL is the default behavior. SELECT DISTINCT is the other option.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 7:28 AM
We have ORACLE 8.1.7 running on server. My question is what difference on
following
You might be able to find what you need at this site.
http://web.singnet.com.sg/~petermag/oracle.html
Dave
-Original Message-
Sent: Tuesday, October 22, 2002 8:39 PM
To: Multiple recipients of list ORACLE-L
S
Hi,
Does anyone know of any web site that contains materials about
You are right Tim (now you may ask "what's new in
that?")
We have a production cluster, development cluster and (possible a standby
cluster) all identical.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
It depends on your companies needs.
On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote:
Hi list
Please input why my boss must invest into oracle rather than the cheaper
mssql.
His opinion is that most features are almost the same but mssql does that at
half the price as oracle does.
So why he
No it doesn't.
MicroSoft is a card-carrying member of the Axis Of Evil.
Last I heard they were developing nuclear weapons, probably in a huge bunker
under Bill Gates' house.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, October 23, 2002 8:54 AM
To: Multiple
Hi DBAs,
A co-worker and I disagree on impact of slightly different BR scenarios
and I would like your thoughts.
Environment for both scenarios: Oracle 8.1.6, WinNt, Archivelog mode, not
using RMAN
Scenario 1:
I do standard Hot Backup using
BEGIN BACKUP
OCOPY ...
END
If he really wants to go cheap tell him to go with mySQL! At least it will
be an open solution.
Greg
-Original Message-
Sent: Wednesday, October 23, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
No it doesn't.
MicroSoft is a card-carrying member of the Axis Of Evil.
Last I
Wow.
Thanks, Dave!
I dropped this msg in the wastebasket, then for some reason went back and
gave it a second look. Glad I did. Nicely organized.
Barb
--
From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Wednesday, October 23,
Try this
update x z set id2 = (select id2 from a where z.id1=id1 and id20) where
id2=0;
Deepa
|+---
|| Imran Ashraf |
|| imran9a@yaho|
|| o.com |
|| |
||
In reality your boss does not have to invest in either. Flat files are still
viable options for limited scope and usage applications.
But in the real world most applications need a database of some type to run in a
multi user environment. That being the case, why would one want to use either.
Its been a while since I used MS SQL but one of the downsides that I
experienced was the fact that MSSQL could not support the user loads we
needed right out of the box. We had to cluster servers together to get the
throughput that we got out of Oracle.
MSSQL might be cheaper at the database
We purchased Autosys when it was owned by Platinum and continue to use it today
for all of our production jobs. The server and clients are running on AIX
4.3.3. and we have had no problems with the product.
@fatcity.com on 10/18/2002 08:19 AM PST
Please respond to [EMAIL PROTECTED]
G - Actually, Oracle may not be more expensive. First, of all, you must do a
little digging into what is included in licensing fees. There are some
extras you must pay for with MS that aren't obvious at first glance, like
the right to upgrade.
If you compare list prices, both Oracle and MS
both scenarios potentially lose the online redo logs. actually, since
you don't include the backup of the archived redo logs in either
scenario, you can't do recovery without a resetlogs for both scenarios.
In order not to lose the contents of the online logs, you have to
archive them and back
We have ORACLE 8.1.7 on SUN server. Does anyone has script that can ckeck
how many total space a user allocate on oracle?
Thanks.
_
Internet access plans that fit your lifestyle -- join MSN.
Is MSSQL server available on UNIX?
-Rachna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 11:25 AM
Its been a while since I used MS SQL but one of the downsides that I
experienced was the fact that MSSQL could not
This is HP True64Unix with Oracle 8.1.7
I found nothing in metalink
Ofer
-Original Message-
Sent: Tuesday, October 22, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
What version and platform you are on?
Sounds like a bug...
There have been a few related to huge values
Greetings ALL!
Have a question for anyone who has infoI'm researching what it would
take to convert a NT database platform (Oracle 81730) to Linux. I have not
approached Metalink yet, but will soon. Does anyone have any information on
Linux? Whether or not Oracle can run on it? Info on the
I've heard that, too. We must be afraid because Microsoft ICBM's
will be running Win2k/sp3 and .net. Knowing the security of that
particular peace of software, I wouldn't be surprised if they blow
the world up before their next release.
-Original Message-
From: Weaver, Walt
I'm back on 8i for a different client who wants to implement standby
database.
other than the whole possibility of losing data during a failover, i've
not been able to find anything about doing managed recovery with out
having a dedicated session to put the database in managed recovery mode.
Rick,
I will assume that all logs are properly backed up.
The only difference in the recoverability of the 2 scenarios is that
an incomplete recovery cannot be done to a time while any tablespace in the
database is in hot backup mode. So, there is a window of exposure in
Scenario
Rick,
I'm going to make the following assumptions about both scenarios, namely
that both instances are in 'archive log mode' and that your handling the
archived redo logs separately. That being said, both scenario's are viable for
recovery up to the point of failure assuming that in the
-Is MSSQL server available on UNIX?
Hahahahahahahahaha. ROTFLMAO :o)
No. Only on windows.
Dave
-Original Message-
Sent: Wednesday, October 23, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
Is MSSQL server available on UNIX?
--
Please see the official ORACLE-L FAQ:
ARE YOU AN IDIOT?? Otherwise, pass some of whatever your smoking this way
because it must be good!!
Dick Goulet
Reply Separator
Author: Rachna Vaidya [EMAIL PROTECTED]
Date: 10/23/2002 7:59 AM
Is MSSQL server available on UNIX?
-Rachna
-
We are performing a rather detailed POC of RAC within a SUN environment...
Be glad to share some details once we complete this to those
interestedI'm hoping for a detailed document with detailed use
cases... But that does assume those who are in the separate areas will
accomplish that as
Tim - Gee, during the original presentation I attended, RAC was presented as
a cost-saving feature. Something about being able to use a lot of cheap
Linux servers. This stuck me as a little odd at the time. Just now, I looked
at the white papers that Oracle posts on the subject, and I didn't see
Hello All,
We are running oracle 9.2 on a sun box in a DW env.
Data loads are thorugh informatica.
During one such load of fact table, the load time per sec is about 300
rows per sec.
The table is suppose to load about 5 mil rows.
During the load i happen to do
Run it on Linux like you would run it on Windows. You do need some Unix skills
for any OS level work though. Otherwise, Oracle is the same (mostly) on both
platforms.
Download Oracle for Linux., It's free for evaluation, education and development
use from http://www.oracle.com
--
Lyndon Tiu
It will be open, not necessarily a solution.
-Original Message-
From: Mirsky, Greg [mailto:gmirsky;Estee.com]
Sent: Wednesday, October 23, 2002 11:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: oracle or mssql
If he really wants to go cheap tell him to go with
same here! thanks Dave!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:15 AM
Wow.
Thanks, Dave!
I dropped this msg in the wastebasket, then for some reason went back and
gave it a second look. Glad I did.
This is your opportunity to contribute to the body of
knowledge; log a TAR...
This is HP True64Unix with Oracle 8.1.7
I found nothing in metalink
Ofer
-Original Message-
Sent: Tuesday, October 22, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
What version and
It run beautifully. i've been running oracle(not so much production but
up thru testing/QA) on linux platform since 8.0.
I love it.
You know that the datafiles format is not compatible, so the only choice
to migrate to linux is exp/imp.
It runs on linux like it runs on any other *nix(except
query SUM(BYTES) from USER_SEGMENTS, or query DBA_SEGMENTS where OWNER =
username
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:54 AM
We have ORACLE 8.1.7 on SUN server. Does anyone has script that can ckeck
how
Its interesting to me what you guys are attempting -we're setting up a large DWH as
well and use a similar technology BC copy to backup the dbs etc .
In the process you outlined - I do question the need for two copies of the DWH - a dbs
for writing ETL's to and another for read-only .Why do
Re. the trial, does anyone know when the judge is expected to rule?
Not a peep re. expected timeline in the media that I can find.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Christine,
Runs fine, but you'll have to use the export/import conversion route. OH,
and get use to a different OS.
Dick Goulet
Reply Separator
Author: Turner; Christine [EMAIL PROTECTED]
Date: 10/23/2002 8:14 AM
Greetings ALL!
Have a
Correct.
...though you can achieve the same thing in 8i by running the SQL*Plus or
SvrMgr process in a backgrounded script. Stopping the backgrounded script
is easy using the RECOVER CANCEL command from any other session...
- Original Message -
To: Multiple recipients of list ORACLE-L
Windows?
I used to do this with a 7.3.4 instance on Unix, I had a shell script
that would run every x minutes, and would first check to see it if was
already running. If not, it would do the recover automatic. It would
fail when it ran out of archived logs to apply, but the cron would
restart it
We have Oracle 8.1.7 and 9.2.0 running on Red Hat Linux 7.2 - and love it. It is not
a production box though. We are still in test mode.
Jim Hawkins
Oracle Database Administrator
St. Louis, MO
Turner, Christine [EMAIL PROTECTED] wrote:
Greetings ALL!
Have a question for anyone who
Hi all,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment the user is attached to but need to
know how much is being used (something like a
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Région des
Title: RE: Insert too slow...
How may indexes are on DM_TRANS_PYMT_HIST? If there are a lot, you might want to drop the indexes, except for the primary key or unique constraints, insert the records, rebuild the dropped indexes, and analyze those indexes.
Jerry Whittle
ACIFICS DBA
NCI
See http://otn.oracle.com/tech/linux/content.html
It runs very well.
Moving a database from NT to Linux is as easy as export/import. Other
methods exist too.
--- Turner, Christine [EMAIL PROTECTED] wrote:
Greetings ALL!
Have a question for anyone who has infoI'm researching what it
How about using bind variables in your execute
immediate statement.
Please see doc id 34433.1 and 366753.999 on Metalink
as I followed 34433.1 for what I tested below.
366753.999 is a forum question which relates very well
to doc id 34433.1.
create table t (col1 number, col2 varchar2(10));
First of all: Kudos to List members Murali Vallath and K 'X$' Gopalakrishnan
who appear in the current Oramag issues's Peer-to-Peer column!
The reason I mutated this particular thread was on account of something I
saw in this column. Murali Vallath apparently is writing a book on RAC.
Maybe we
nope its unix(solaris flavor).
thanks for the idea, thats probably what I'll do versus trying to setup
data guard on the nodes.
joe
Rachel Carmichael wrote:
Windows?
I used to do this with a 7.3.4 instance on Unix, I had a shell script
that would run every x minutes, and would first check
Xenix, now there an OS i've not heard about since '89.
joe
Boivin, Patrice J wrote:
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics
On Wed, Oct 23, 2002 at 08:14:07AM -0800, Fink, Dan wrote:
Rick,
I will assume that all logs are properly backed up.
The only difference in the recoverability of the 2 scenarios is that
an incomplete recovery cannot be done to a time while any tablespace in the
database is in hot
Define Linux.
Check the support matrix. I liked running on Redhat, but Oracle seemed
to drop support for the free versions after 7.1 or so. Anyway, you may
want support and so you may want to purchase some of the enterprise
releases of linux, such as from RedHat or SuSE that are included in
What distribution/version of Linux would you recommend (RedHat, Suse, etc.)?
Thanks
Phil Wilson ([EMAIL PROTECTED])
DBA, Operations Group
SkillSoft, Learning Solutions for the Human Enterprise
506.462.1124(w)
506.447.0334(c)
-Original Message-
Sent: Wednesday, October 23, 2002 1:50
New Bee
If I understand your question, you are looking for information on how to
tune SQL statements. Actually, I've been searching for something like this
for quite a while. I glanced at the web link in Dave's reply, but I didn't
see anything that directly addressed SQL statement tuning. If I
Use used_ublk, used_urec from v$transaction. You will need to join to
v$session to get the session info.
USED_UBLK USED_UREC
-- --
12918
-Original Message-
Sent: Wednesday, October 23, 2002 11:02 AM
To: Multiple recipients of list ORACLE-L
Hi all,
SELECT
r.NAME, -- rbs name
s.sid,
s.serial#,
s.username,
s.machine,
t.status,
t.cr_get, -- consistent gets
t.phy_io, -- physical IO
t.used_ublk, -- Undo blocks used
t.noundo, -- Is a noundo transaction
SUBSTR (s.program, 1, 78) COMMAND,
s.username DB User,
Except for primay key constraint we dont have any other constraints or
indexes present during the load.
What does the sql * net wait events signify. Is there cause for concern
when we see those events. ??
Thanks,
Sathish.
On Wed, 23 Oct 2002 09:02:21 -0800, Whittle Jerome Contr NCI
[EMAIL
George,
Try this query and check for average_active
select ud.name,
sg.extents ext,
round(sg.blocks * ts.blocksize / 1048576, 2) MB,
round(s.optsize / 1048576, 1) optsize,
round(s.aveactive / 1048576, 1) AVEACT,
round(s.hwmsize / 1048576, 1) HWMSIZE,
The developers working on our new VB app are also responsible for
setting up the Oracle DB behind it. The app is for an order
entry/despatch/warehouse system with 5 million customers and 1000
orders per day. We have nearly 400 tables. They are not planning on
using primary keys/secondary keys, as
Sathish
Given that your high wait times relate not to the actual Oracle insert
process but to communication with the client, the first place I would look
is the connection between Oracle and Informatica. Are you going through
ODBC? There are options in SQL*Net and in the ODBC driver. I would
It provides a window for an incomplete recovery during the time that the
backup is being performed.
For example
02:00 1st tablespace begins backup
04:00 last tablespace ends backup with no time gaps in between
It is not possible to perform an incomplete recovery from 02:00 to 04:00.
02:00 1st
Kewlness! Thanks everyone for your input. Totally off the dba subject...does
anyone know of any C++ developers that have information regarding converting
to UNIX. My developers are going stir crazy trying to find any steps to
follow when converting C++ applications for Linux. If not, that's cool,
On Wed, Oct 23, 2002 at 08:49:49AM -0800, Tim Gorman wrote:
Correct.
...though you can achieve the same thing in 8i by running the SQL*Plus or
SvrMgr process in a backgrounded script. Stopping the backgrounded script
is easy using the RECOVER CANCEL command from any other session...
I
Well technically, only the advanced version of RH( are supported, i
think most if not all(some please clarify) of Suse are supported.
go here: http://www.redhat.com/oracle_cert/
for the scoop of versions of oracle on which versions of RH are certified.
Joe
Phil Wilson (DBA) wrote:
What
If the database crash causes media failure of your archive destination or
your online log destination, then you can only recover the database upto
the last archivelog availability, and you would need to open the database
with resetlogs. This is true for both scenarios.
Assuming no media
That would be the manual mode. Recover standby database. With 8i, and the
multiple archive destinations, you have the sustained recovery mode.
Recover managed standby database. A sustained recovery mode will lock
your telnet window, and will be dedicated to doing just the recovery. But
then, one
Craig,
No, this is not normal. They have purchased a Caddy so they can push their
grandma to the beauty parlor to get her blue-hair done - they will never
start the car.
Why in the hell did they purchase Oracle in the first place? Talk about a
waste of money!
If you cannot stop them now, then
Craig,
Your right, Oracle is just being used as an expensive file system. Get them
to use MySql instead, it's far cheaper.
Now from a practical point of view, who are these duhvelopers that they
dictate setting up the database? If they were in our shop they would not have
gotten onto
Craig, i dont know jack about VB but M$ Access wont let you do
updates(according to my sources) unless there is PK or Unique index on
the tables.
joe
Craig Healey wrote:
The developers working on our new VB app are also responsible for
setting up the Oracle DB behind it. The app is for an
Craig,
Unfortuneatly this happens alot. Many developers have an over inflated view of their abilities and think they can write their code good enough to handle this. Every time I have seen this in place I have seen data integrity problems. Some major application vendors do this to provide the
Dont you mean complete recovery?
You could then perform an incomplete recovery until 02:10:01 - 02:10:59 or
02:21:01 - 02:21:59, etc.
Fink, Dan
If I wanted to put together a cheap RAC for play purposes what sort of
HW/SW would I need? I'm not talking about a production-level solution
here, just taking some older-HW I might have laying around and turning it
into a RAC with a minimal investment for sandbox purposes.
Could I do it with 2+
I'm sure some of you are aware of this, but it was news to me.
I had to open a tar because of ORA-0600 [4000] and while creating an itar
found that I could lookup ORA-600's directly.
My ora 600 wasn't published, but it may help others
it's not common and you should insist on primary and foreign key
constraints.
all you need is ONE user to hack into the database outside the app and
insert/delete/update rows that violate the integrity constraints and
your app stops working.
--- Craig Healey [EMAIL PROTECTED] wrote:
The
Christine,
I found it easier ( because I had the OS disks) to load the PC with
RedHat6.2 and then install Oracle 8.1.7. That eliminated the glib and
java problems encountered with the RedHat 7.0 and 7.1 versions. Then I
upgraded the OS to 7.0 and finally 7.1 after I found things ran
perfectly.
When code is developed to be database generic, developers will steer away from
code for a specific database. However, foreign key and check constraints hardly fall
into this category. I don't use Sqlserver or DB2, but I would guess that they
implement FKs and constraints. Your developers
We have experience numerous problems with high transaction load
databases. The i/o drivers and memory drivers have proven to be
unstable. The largest problem seems to occur with the memory drivers.
Try running a linux database with and SGA over 1GB. We have been able
to duplicate these
Xenix is history now...SCO itself stopped it sometime in 1990
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:02:19 -0800
XENIX maybe.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
Craig - I've seen large/busy databases run with RI handled outside the db.
Most common with package apps like Peoplesoft. They do that because they
want to run on many DBMSs and each handles RI differently. To reduce
development cost, they code once to the least common denominator. Thus no
RI
Title: RE: Website that contains materials about performance tuning of S
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
For Oracle, the best resource I've found is a book (not
free, but pretty
inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry
Wow, Life is stranger than fiction!
First of all buy stock in your hardware vendors since every query will
result in a table scan of every table and if you get more than an
intermittant workload on the system, it may very well come down onto its
knee's. indeed they are making it a very expensive
This is VERY wrong.
I know they are perfect, but one bug in the code will cause data loss,
order entries without a correct customer code etc.
Lets say that a year from now one customer complain.
They print a report and see that two entries are missing.
You check for orders with incorrect
OK. For everyone's benefit, this is commonly known as the Developer's
Paradox. Essentially, it means that developers write more code so they are
brought back to maintain the stuff.
Your developers have tragically forced you into this. Instruct them on
proper database/application/system
Oops, for got Ladies on my last email. Rachel definitely has some good
opinions on this.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent:
Hi Kevin,
Fantastic, thx, just what I was looking for, will event tell the oracle
support person that could not even assist.
George
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575
Can you send them to oracle training in Bethesda, MD or
Reston, VA? Benefits could be multiple, especially for you.
Make sure that they wear clothing in bright colors.
-Original Message-
From: Craig Healey [mailto:C.Healey;hhsuk.com]
Sent: Wednesday, October 23, 2002 1:45 PM
To:
Hi
I am having following error message in alert log on standby database at time
of recovery.
ORA-00600: internal error code, arguments: [3020], [46191421], [1], [8439],
[18903], [16], [], []
Metalink say its BUG.Does any one faced such error? If yes how to fix that.
Thx
-Seema
3 yrs after ur developers code the VB app, the original team vanishes(they start
working on .net .. or maybe java)
The new team even after going through the docs and vb application libraries, forget
the right joins and insert invalid data/update rows in the master without taking care
of the
I'll be able to tell you more about 9.2.0.2 on RH 8.0 after this weekend.
I don't expect any trouble.
-Original Message-
From: Joe Testa [mailto:jtesta;dmc-it.com]
Sent: Wednesday, October 23, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: linux
Well
Did you ever discover the rogue instance? I would be interested in learning
why it wasn't being discovered.
Phil Wilson ([EMAIL PROTECTED])
DBA, Operations Group
SkillSoft, Learning Solutions for the Human Enterprise
506.462.1124(w)
506.447.0334(c)
-Original Message-
Sent: Friday,
The main problem as I see it is that you might be
lucky in getting IO balance with a
tables-here-indexes-there approach in rule based
databases, where pretty much the only thing Oracle can
do is table scan and single block index read.
But since 7.3, and even more so with the more recent
releases,
here's my standard answer to developers who try to tell me how the
database should be designed:
which part of the word No don't you understand?
The DBA should know best how to use the abilities of the database. I
can understand that with 3rd party applications, which have been coded
to be
-- Make sure that they wear clothing in bright colors.
Not exactly a nice comment Gogala I have friends in that area who are
dealing with the sniper every day I am sure there are others as well.
-Original Message-
Sent: Wednesday, October 23, 2002 2:33 PM
To: Multiple
Seema - I used the ORA-600 lookup function on metalink, but it said nothing
had yet been published on this error. Your best choice may be to file a TAR.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, October 23, 2002 2:33 PM
To:
There are tons of IDE software like Anjuta, CodeWarrior, CodeCrusader, Grasp
and alike which can ease up transition. The following URL is, however,
worth looking if you have to deal with hard core Micros*t guys:
http://www.bristol.com/windu/index.html
-Original Message-
From: Turner,
1 - 100 of 160 matches
Mail list logo