We have a couple of independent applications running over the same instance
now (it's better to do it because our resources cant' support two instances
over the same machine), we think if we use parallel server, we can make
partition of this applications, one for each node or someting like
Thanks ! A very useful link !
-Original Message-
Sent: Thursday, May 31, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L
Vikas Kawatra wrote:
Anyone using this product as an alternative to Local Naming ? How about
LDAP
?
Any info /suggestions/comments are welcome
vikas
However, if you rebuild all the indexes for schema SALES on PRIMARY, what happens on
STANDBY? Are they rebuilt?
Cheers,
Earl
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 31 May 2001 08:16:06
Rachel Carmichael wrote:
there IS no way to do that with a standby database. Once you open it
Cartesian Join? shudder
Scott Shafer
San Antonio, TX
210-581-6217
And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch,
Dave:
Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.
Kevin
-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Can anyone help me with this.
I have
hi,
This may sound funny. I want to know
how to corrupt a block. I want to test the different methods of identifying
block corruption, but I don't have sample data blocks.
Please help me
novice
Hi,
When i am trying to start my database form svrmgrl ..
i am getting error:
ORA-00205 error in identifying controlfile, check alert log for more info
there is nothing in alert.log...
i have 3 control files all r in proper directory..
i am using proper SID
i tryied with only i
Correct.
By the way: A good rule is to always keep the sequence Table - Snapshot Log -
Snapshot, ie. don't break the sequence, for instance by dropping and
re-creating the snapshot log. If something happens to the snapshot log you
should drop the snapshot, create the snapshot log, then re-create
I need to find the article I had saved about Oracle 6.0 (as we were preparing to
upgrade from 5.1). It was something about how the 6.0 DBA would be bored and would now
be able to help appdev.
Cheers,
Earl
---
TheOracleDBA
[EMAIL PROTECTED]
On Fri, 25 May 2001 09:28:53
Vergara,
The general school of thought is joining a large table
to a small one. There is an article on Metalink thats
a little out of date now, but it describes the
good/the bad, and tuning of hash joins.
Look for doc 67134.1 and 41954.1
hth
connor
--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
What's
Title: Implementing Stored Procedures
Hi -
I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or
Title: RE: Auto Extend
See Note:62427.1, 2Gb or Not 2Gb - File limits in Oracle http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT_id=62427.1
-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:56 AM
Title: RE: Auto Extend
Hi Ron,
do you have large files enabled on your system? What unix are you running? if large files are not enabled you're going to get an error but I can't tell you what it will be.
Boy, autoextend reminds me of a monkey running around in your database. I'd never do
Hatzistavrou,
Thanks for you reply. It was about 4am when I ran into that and discovered
what I needed to do, however, I knew it would take a while so I just stopped
at that point. But, I was curious to find out if anyone had a BETTER way of
doing it. It seems like a waste if I have to go
Hi Ed,
Why do you say that OiD is not cheap? I haven't seen any associated
costs, other than servers to put it on. Can you explain?
The complicated part, though I definitely agree with! :)
Thx!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Hi all,
Does anybody knows how to autmotize the outlook express from a Form,
to open a new mail and atach a file to it, leaving the subject and
destiny in blank, to be filled by the user, or where can I find any
guidelines to do it.
I have searched it at metalink , oraclefaq and the
I like lsof for this purpose. You can see which processes have which
filehandles and ports open to which hosts. It is an excellent utility.
ftp://vic.cc.purdue.edu/pub/tools/unix/lsof/README
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 31 May 2001, Mohan, Ross wrote:
you
SET ORACLE-L NOMAIL
---
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not
Oracle could be doing partition elimination but the tools that you are using
to see the execution plan is not showing you the details you're looking for.
I usually do:
Truncate table plan_table;
explain plan for your-sql;
select * from plan_table;
There should be two columns that indicate the
I have heard rumors that OPS on 9i will allow you to use cooked files.
User group meeting next week, with a presentation on 9i new features.
I'll ask
Rachel
From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Title: RE: Listener problems
-Original Message-
From: zabair ahmed [mailto:[EMAIL PROTECTED]]
Has anybody come across the following error message in the
listener.log, and
know what the resolution is.
TNS-12500: TNS:listener failed to start a dedicated server process
This can be done using the Outlook object model. I have never done it with
express but have created lots of stuff with outlook. Check out
msdn.microsoft.com for information on the model and examples (look in the
MSDN Library).
- Ethan Post
-Original Message-
Sent: Thursday, May 31,
Now that sounds like a fantastic idea, now all that I have to do is figure
out how you do that?:0 Kev
-Original Message-
McDonald
Sent: Thursday, May 31, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L
if you get 18's then you can just use the outer 9G
portion of each drive to
18Gb with the cache all the way, I would recommend Seagate for this. The
cost difference is small between the 9Gb and 18Gb plus 18Gb will be
replaceable for longer time than 9Gb.
I would recommend more than 4 disks though. Specially if your implementing
raid of some sort.
If at all possible.
Lisa,
This is what we did in my last project:
1. Developers had access to the application schema where they created and
modified procedures/functions/triggers as needed
2. After their unit testing is done, the QA team would test it using the
front-end application.
3. Once QA team approves the
Thanks
I just found it interesting that here in Canada no one has asked for the
trial CD kit... and that Oracle Canada doesn't know what to do when we wish
to order one.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Shreter, Hilary
You are out of space on that filesystem.
Check the size of your log files, as they are likely
responsible for consuming a lot of space.
Also check in the cdump directory for core files.
Jared
On Thursday 31 May 2001 09:16, zabair ahmed wrote:
Has anybody come across the following error
Title: RE: Auto Extend
We had
an issue here where we had the Sun box to except files over 2G but got bitten in
the ass quickly by it. We use HP OmniBack to backup all our Unix boxes and
the agent on the Sun box could not handle the file size. So there is more
then just "Can the OS handle
Check optimizer_mode in v$parameter for your session. I don't think it will eliminate
partitions if it is RULE.
Here is an explain plan from a simple select on a partitioned table. An index exists:
SELECT STATEMENT Optimizer=CHOOSE (Cost=1.69535189333285 Card=32 Bytes=3488)
PARTITION RANGE
Take a look at /var/adm/messages for any reported errors
-Original Message-
Sent: Thursday, May 31, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
Has anybody come across the following error message in the listener.log, and
know what the resolution is.
TNS-12500:
Hi Folks,
I have just installed 8.1.7 on my HP-UX 11.00 box and have Apache running.
Now what? How can I test to make sure apache is talking to oracle and
vice-versa? The install documents don't really explain that part and I've
tried searching metalink but don't know what I'm looking for.
I guess this has already been answered, but to clarify:
I believe Cartesian refers to a *product* (Cartesian product), not a
join.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
Cartesian Join? shudder
--
Title: RE: select question
I believe you'll want to rpad your return value.
select rpad(26.5,5,0) from dual
returns
26.50
or format it in SQL*Plus.
HTH
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential
they should be, unless you do nologging operations -- which can mess up your
standby database
From: The Oracle DBA [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Rebuilding indexes
Date: Thu, 31 May 2001 10:05:57 -0800
Yes it does.
The scan will be range of partitions and the execution plan will show
partition stop = key and partition start = key.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Can oracle do partition elimination
Hi !
The simple thing is you can edit the datablocks using
BBED editor. It is shipped with Oracle and You need a
password to use that utility. You can browse and edit
the data blocks.
$BBED will give the required details. BUT IT IS
DANGEROUS
--- novicedba [EMAIL PROTECTED] wrote:
hi,
At 9:07 -0800 31/5/01, Mogens Nørgaard wrote:
There is certainly something new called an index join around in 8i.
An index join is a hash join on 2 or more indexes which between them
contain all the columns required to fulfill the query. It is new to
8i, and is considered to be an access pathl
Actually, Oracle 'Applications or a flavor there of has been around for many years.
10 + I believe.
What CD PACK are you looking for?
ROR mª¿ªm
[EMAIL PROTECTED] 05/31/01 10:50AM
Still no response from Oracle Canada, I left a message again - they didn't
know what to do when people order CD
I've been expirementing with MV for a couple of days. Interesting gotcha's for fast
refresh on
commit, but otherwise cool stuff. Now for the question.
If I have a base table of 1 millions rows of time series data and I want to produce
MVs for day,
month, and year aggregates, would it be
Can oracle do partition elimination when ysing bind variables?
Alex Hillman
-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Dave:
Oracle does do partition elimination in this case...check out he
partition_start and partition_stop
If you do a snapshot refresh then the snapshot log should be empty(correct?).
Then I would think you could reorg the master table as long as you prohibit
users from updating the master until the reorg and the recreating of the log is
complete. Thus eliminating the need to do a complete refresh
Call Oracle support and ask for a document Cracking Outlook Express, this
PDF will explain (thought not in complete details) how to implement this
interface. I am not sure if this file is available through Metalink
Libraries ... you can check though ...
Raj
I was thinking the 18's where a better idea now that everyone agrees.
However, I can't go with more than 4 drives unfortunately, this is on a Dell
Precision 410. I could try and add an additional scsi adapter, but I am not
sure that I would have a place for the drive, unless I went external.
Steve,
If you are going to pull code from v$sqlarea, you will also want
to use v$sqltext.
In that case, look up the paper at www.hotsos.com about joining
v$sqltext and v$sqlarea, as the hash_value is defined as a
different data type in each. This affects all releases prior to
8.0.5.
Also,
On Thursday 31 May 2001 10:07, Mogens Nørgaard wrote:
There is certainly something new called an index join around in 8i.
That wouldn't be considered a new type of join though would it?
Just using indexes as a data source for the join. They shoulda done
this a long time ago.
Jared
--
Dick, I am not sure which platform you where using for
OPS, but you have to use raw device's. Unless you are
using OpenVMS or Compaq TRU64 v5.1 you have to use raw
devices for datafiles, controlfiles and online redo logs.
Archive logs have to go to a file system. Now there are
some
Is it possible that there is an error in your init file? I have had this
problem before with Oracle 8.0.5 on NT, I had to reboot :) the machine and
then it worked, very strange.
Kev
-Original Message-
Singh
Sent: Thursday, May 31, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
Hi Anita,
Ironically that is just what I am trying to do. (ie implement a storage plan
which will address the issues discussed in the paper) To your other point, I
understand oracle's position, but if I can prohibit changes to the master
during the reorg/rebuild, is this still an issue?
nah. you aren't, the rest of us are :)
From: Jared Still [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: OT: Archiving not possible with SQL Server?
Date: Thu, 31 May 2001 11:38:08 -0800
I thought everyone would realize
Rachel, OPS or in 9i RAC (Hate name changes confuses
everyone) raw devices are a requirement of the OS not
Oracle. So whether you are using 7, 8, 8i, 9i you can use
filesystems for OPS (RAC) if the OS supports multiple
concurrent mounts on the same filesystem from multiple
nodes. This is the
Ray
I think, you are referring to RAC, Real Application Cluster. Which is same as OPS with cache fusion for all scenarios. Please see my previous mail thread with the same subject..
Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Ray Stell [EMAIL
Folks,
Just got an e-mail from my Damager that there is a concern about the cost
of TOAD licensees and an effort is being made to find a suitable
replacement. Evaluation of PL/SQL Developer by Allround Automations is
underway. Anyone knows the pros/cons of using this (PL/SQL Developer)
product
Helmut Daiminger wrote:
Hi!
I have a SQL problem here, which I can't solve.
I have a B-tree structure in a table (parentID, childID).
If a parent has kids then select those kids. If not, select this parent.
How do I code this in SQL? I tried using connect by but this doesn't
I want to know if it is allowable to kill programmers who say these are the
rules for data in this column but then don't enforce those same rules.
Rachel (rolling up her sleeves, putting on the rubber gloves to begin data
scrubbing really BAD data)
From: Jared Still [EMAIL PROTECTED]
Never say never :)
I opted for 4 GB files in a larger database which is living happily on EMC
Sym box. If hardware and software allow for fewer, easier managed large
files...why not? This is scratching the surface of course...
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
What do you mean by 'the system is not set up'. How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit. Is it documented?
Please explain. Thank
It apparently is only on NT, and unless you have the password,
which is known only to Oracle Support Personnel, you can't
use it.
http://www.ixora.com.au/q+a/0101/23224038.htm
Jared
On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote:
Hi !
The simple thing is you can edit the
We put the code in a file on Unix (our server platform) and in the change
request form, provide the file name and location. The DBA will log in as the
schema owner and simply run the file. Any errors are reported back to
developer who requested the change. All the SQL code is archived using SCCS.
I thought everyone would realize this is a joke. It's been
appearing with some regularity in a mocking tone of
someone that posted it seriously a couple of weeks ago.
Sigh... Maybe I am just having a bad day.
Jared
On Wednesday 30 May 2001 23:50, Jared Still wrote:
Are you an idiot?
Ray, Oracle9i RAC (Real Application Clusters) is or was
(depending on your perspective) Oracle Parallel Server.
Compaq is working with Oracle to pre-install and ship
Oracle9i on there NT boxes (not sure about TRU64 or
OpenVMS platforms), so you just turn it on and it works.
Oracle9i
Title: digital tru64 unix
Hello everyone,
Anyone out there running Oracle on this flavor of Unix? If so can you please email me directly?
I don't have a Unix box to play with and I have a few simple performance questions. I'm also looking in the online doco and I don't see what I'm looking
Title: RE: what's hash-join
Hi Lisa,
You're correct.
I'm sure you know, but I'd like to add that
hash join usually worksfaster than over
methods
when there are no good selective conditions
in the
clause WHERE.
Regards,
Ed
Hi Kevin,
It's quick if you have the temp space
to
I think you mean bitmap join indexes which is a new feature in 9i.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L
There is certainly something new called an index join around in 8i.
[EMAIL PROTECTED] wrote:
I wonder
Richard,
Thanks! Now let me know if the book is actually useful...
I think you are going to have to bite the bullet and do the rebuild with
logging. And, since this is something you may have to do over and over
again, I'd create that extra tablespace and datafile and leave them there on
both
I'm looking for recommendations for Windows based s/w
that does the equivalent of SCCS/RCS on Unix. A command
line interface is a requirement; GUI is optional.
TIA HAND!
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit
No need to copy the whole file to the standby when adding a datafile! Just wait
for recovery to fail on the new file (ORA-01670), then type on the standby (in
'mount standby database' mode):
SQL alter database create datafile 'filename' as 'filename';
As long as you are using identical paths
As Kevin Lange pointed out, you need the correct access to UTL_TCP.
If you have access to this package through a role, you won't be
able to do this. You must login as sys and give an explicit grant:
e.g. grant execute on sys.utl_tcp to scott;
Whe you say that the package is shown as valid
-Original Message-
From: Fisher, Julie [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 6:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to encrypt Password in Export script file ?
I also did this on all my databases - works very slick.
Julie
Hi
Some time I am receiving the following information in alert logs.
ORA-60: Deadlock detected. and .trc file generated.Let me know what to
do to prevent such error.
Thanks
-seema
_
Get your FREE download of MSN Explorer at
Fernando, If your current resources are limited and the
app is partitioned, you should have very few problems
implementing the App in OPS (famous last words). If HA is
a requirement and fast failover times OPS is a good pick.
Just make sure the ends justify the means. Some people
have good
On Thu, May 31, 2001 at 11:17:30AM -0800, [EMAIL PROTECTED] wrote:
Ray
I think, you are referring to RAC, Real Application Cluster. Which
is same as OPS with cache fusion for all scenarios. Please see my previous
mail thread with the same subject..
--
index oracle-l
The archive
hi dba's,
In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm
having only two groups with a single member each.
I tried with alter database command, there is only options for adding and
droping log group or member...
How can i resize it.. to increase the size 5mb.
Regards,
At parse time, the optimizer determines that partition elimination can be
done -- which partitions to use is determined after the values are bound to
the query.
-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Can oracle do partition
Title: RE: Resizing Log file
Nirmal,
you need to add new groups with a new redo log size, force the switch, and drop the small redo log groups once they are not active and have been archived. Check the doco for exact syntax. You can't just resize them iirc.
Be sure to have at least two
If you do a snapshot refresh then the snapshot log should be empty(correct?).
Then I would think you could reorg the master table as long as you prohibit
users from updating the master until the reorg and the recreating of the log is
complete. Thus eliminating the need to do a complete refresh
If you know the size of the number (in position count not value) you can use the
RPAD(sum(field),count,0) to populate the right end of the return value to zero.
ex. the sum value is = 2.5 and you want 2.50 rpad(sum(fd1,4,'0') return 2.50
BUT if the return value = 25.5 and you want 25.50 and
Jared/all,
A joke is exactly how I read it and is how I meant my request for HELP to
come across :).
Btw, thanks to everyone for interesting replies, reaffirming my grim
suspicions about MS idea of archiving...
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
-Original
i don't think it is considered a join, from what I remember it was called
merging indexes.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, May 31, 2001 3:11 PM
To:
On Thu, 31 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
-It adds the datafile NAME only, not the file itself. And if the physical
-file has not been moved before the archived log that has that redo in it is
-applied, the recovery dies.
so if you got the file in the right
1. Most all drives have cache on the drive.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, May 31, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
Kev,
Add new log groups (I'd go with at least 3 groups of 2) with 5MB files,
then drop the old log groups.
Dennis
Nirmal Kumar Muthu Kumaran wrote:
hi dba's,
In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm
having only two groups with a single member each.
I tried
There's an excellent tool by the company Kintana that automates the
deployment of software (which can include stored packages and procedures,
as well as shell scripts, SQL*Loader, whatever). The developer creates a
release with the file names and version numbers in PVCS or ClearCase, and
the
When you say Cartesian Join you are basically speaking, like you said, of
a Cartesian Product of two Matrixes. Each row joined to each row of each
Matrix.Cartesian Joins in Relational DBs are basically 2 or more tables
in query without a join condition so that each row in the first table is
CHAN Chor Ling Catherine (CSC) wrote:
Hi Unix Gurus,
My daily export file (daily_exp.sh) contains :
exp userid='system/password' file=file_name.dmp grants=y rows=y
constraints=y compress=y full=y inctype=complete log=file_name.log
The system password is stated clearly in the export
Title: RE: Auto Extend
Thanks Kimberly for correcting me. I had a feeling there was a real reason it was frowned upon in the solaris environment I used to work on (instead of 'just don't do it, I said so') but everything was so overwhemling at that time I just let it go.
LK
-Original
Rewrite your apps so that they consistently follow
a locking stragegy.
Look up locks in the concepts manual, it has some
good information, such as 'avoid explicit locks'
Jared
On Thursday 31 May 2001 13:29, Seema Singh wrote:
Hi
Some time I am receiving the following information in alert
Title: Implementing Stored Procedures
One option (and I'm not suggesting that this is the BEST option by any
means, but it IS an option =) might be to grant the developer(s) the 'CREATE ANY
PROCEDURE' role, and then have them create their procedures/functions/packages
etc as
put your userid and password and all other parameters in parfile and run.
exp parfile=abc.parfile
It will hide your password on unix level. your password file should be
readable by you only...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Do a
"dd" on unix and changethe contents of any particular
block.
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16
PMTo: Multiple recipients of list ORACLE-LSubject: How
do I corrupt a block
hi,
This may sound funny. I want
Add some new ones, drop the old ones...
hth
connor
--- Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED]
wrote: hi dba's,
In my DB, oracle 816, NT4, the redolog member's
size is only 50kb. I'm
having only two groups with a single member each.
I tried with alter database command, there is
CHAN Chor Ling Catherine (CSC) wrote:
Hi Gurus,
How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the
same table ?
I created the first index successfully but encountered the error ORA-01452:
cannot CREATE UNIQUE INDEX; duplicate keys found when I tried to create
OiD is a separately licensable product...not included as part of the DB
license. If I remember correctly, you have the UPU license calculation or a
per entry license @ $50/, with 5000 entries being the minimum!!
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Thursday,
Hi Tracy,
Oracle still won't let you do a fast refresh if the
creation time stamp on the snapshot log is more recent
than the creation time stamp or last complete refresh
of the snapshot. An attempt to do so will generate
the dreaded ORA-12004: REFRESH FAST cannot be used
(see note 1035524.6
HELP
I have no sense of humour
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Gary Weber [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 4:50 PM
To: Multiple recipients of list ORACLE-L
Hi,
Actually, it's not so bad.
OiD is licensed separately ONLY when used as general purpose directory
service.
Check Metalink Note:135696.1
13. Do I need to license OID when deploying the directory for NET8 ?
Answer
--
No, deploying OID for NET8 is free of charge.
Vadim Gorbounov
Oracle
Ken,
(FYI, I used a version of Apache (1.3.12) that came from Apache's web site,
not the version that came with Oracle. And my web servers and database
servers are on different machines. And my web servers are running Kerberos
and SSL. And I still can't believe it all works together.)
Check
Jared,
Yes and No. As I understand them it uses both a merge and a hash join, but
then you know marketing types!! BTW: that was a guess on my part too. And yes,
I do need to RTFM to be sure.
Dick Goulet
Reply Separator
Author: Jared Still [EMAIL
SET ORACLE-L DIGEST
=
Hamid Alavi
4268 Flintlock LN
Westlake Village 91631
PH: 818-8790966
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official
Kevin,
You did not state the OS you will be using. If it is a flavor of LINUX them 3ware
makes a ISA card that will handle disk drives like they were SCSI drives. You save the
high cost of disks and spend it on the card. But I bought 2- 40 GIG WD drives last
week for $109.00 each and put them
The docs actually do a good job of showing what the explain plan
will look like for a partition elimination.
Look at the 'Explan Plan' chapter of 'Designing and Tuning for Performance'
Are you using ?/rdbms/admin/utlxplp.sql to examine your explain plan?
Jared
On Thursday 31 May 2001 09:00,
101 - 200 of 271 matches
Mail list logo