Title: RE: Index question ???
Andrea,
It is recommended, not required. Anytime the db needs to verify the fk constraint, if there isn't an index there to support it, a full table scan will happen. Performance killer.
What do you mean your indices disappeared? Can you elaborate?
The answer must be AT LEAST 2 Teachers .
Because lets say two teachers Rick and Susan.
Susan gives the subjects 102 and 105
Rick gives the subjects 102 and 105
Nobody else gives these subjects.
This proves that at least two teachers are given salary rise.
bunyamin
- Original Message
Title: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Eeeek! It just keeps getting worse! Can someone on 8.1.7.x
on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system
level try the
following test
yea 7.1, i've got it working and am using it on a daily basis, my biggest
problem is i only got 192M of ram, so i had to install the software(and none of
it would link during the install), and then link them all externally out of the
installer, then all was well.
joe
[EMAIL PROTECTED]
um, I can see possible answers to this question being 2 teachers, 3 teachers
or 4 teachers.
however, since that isn't one of the multiple choice answers, then it has to
be at least 4 since only 2 is wrong
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
Aldi, there is a bit to be desired in 8i logmining. no ddl, no
chained/migrated rows, etc.
joe
[EMAIL PROTECTED] 08/21/01 12:48PM Check
out the Oracle 8i Administrator's Guide, look at the chapter entitled: "Using
LogMiner to Analyze Online and Archived Redo Logs".Jon Walthour
From:
It's possible, but not the only possibility. Therefore you can't
answer A.
And if you're not certain, you can't answer the question. Because
this is the Oracle OCP exam. The thing that you've studied
night and day for. Everything you learned in the two-night class
preparing you for database
This is a poorly written question. I would guess that since it is the
teacher table the assumption is that the ID is unique, even a primary
key (it is not null), but none of this is stated so it doesn't have to
be the case. Although I can't see it making any sense to repeat the
salary (if indeed
Not only that, PX slaves do direct reads
anyway, bypassing the buffer cache.
It is possible, though, that the flush
that has to take place before the PX
scan can read back is sufficient to
cause other processes to wait for
write complete waits, and I guess that
you could also get extra rbs
Jon,
Thanks for the response. But these users still need to
do updates through the app. I only want to keep them
from doing updates from outside the app.
Larry
--- Jon Walthour [EMAIL PROTECTED] wrote:
Create another user with select privileges only on
the objects in the app's schema. Give
SCO (Unix) was bought by Caldera who releases a version or flavor of
Linux. Caldera's main emphasis has been (historically) the desktop and
end users. During the Linux World conference in San Jose last year,
Caldera announced their acquisition of SCO to fuel their server line of
software
What happens when you join a large parllelized table
with a very small table (contained in just 10 or 12
blocks) the retrieval of rows from the large table
looks up the small table causing buffer busy waits on
the blocks of the small table. Keeping the small table
in keep pool removes the buffer
It also causes ORA 600's, it was supposed to be fixed in Patch 8..1.7.1.. I
believe.
KK
-Original Message-
Sent: Tuesday, August 21, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Although it works for me under Oracle 8.1.7.1.4 on Win/2K as shown below, I
do have doubts about
Can anyone help me with a simple .bat script for NT that will run a TNSPING
against a certain connect descriptor and write the results to a file. I
need to have the TNSPING run for say 1000 loops. Once complete, I can
search through the file for errors.
Thanks,
Ed
--
Please see the official
I was able to configure the standby database.I am not clear about the redo
log files.Oracle
Standby database creation dod doesn't talk of moving the redo log files.Do
we have to move
the redo log files from the primary database to the standby database.But the
standby database
iw working fine and
Multiple choice exams are lousy at testing creative, imaginative people,
because the answer ends up being it depends almost every time!
Hmmm, I wonder why they use them in universities...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit.
SQL Statements That Can Use No-Logging Mode
The following operations can make use of no-logging
mode: direct load
(SQL*Loader) direct-load INSERT
CREATE TABLE ... AS SELECT
CREATE INDEX
ALTER TABLE ... MOVE PARTITION
ALTER TABLE ... SPLIT PARTITION
ALTER INDEX ... SPLIT
Title: Apologies... linux & Oracle
Hi
We've Oracle 8.1.5 8.1.6 and 8.1.7 on Suse
Linux from 7.1 and 7.2 !
We've 6 Databases with this linux and this
databases runnig since 01.02.01 as productive databases by
switzerlandpost !
The size from the databases is from 10GBto
80GB on Compact
Title: Message
With enough ram, does it work without
changing things?
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275
I agree with Joe, the correct answer is two. It doesn't state
that a teacher can only teach one subject
so the same two teachers can teach both
subjects. Ialso agree with
everyone that mentioned that this is a crappy
question.
-Original Message-From: [EMAIL PROTECTED]
What if there are no subject_ids of either 102 or 105 or both in the table?
I'd say it's a case of not enough info (for us that is, not enough thought
on the part of whoever made it up but then they didn't ask the list did they
;-) ).
This is why I dislike word problems.
Linda
It could be anywhere from 0 to more then 4 teachers receiving increase,
depending on whether there are teacher/teachers teaching both subjects, and
on whether one (or both subjects) with those IDs (102, 105) exists or not
exists in the table.
Extreme case (0 teachers receiving increase), when
They can't give any raises this year.
They have to hire a data modeler using those monies. There were at least
four raises that could be used for this purpose.
-Original Message-From: Brian McGraw
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August
21, 2001 3:26 PMTo: Multiple
well we know the answer is C, but its the most correct out of the 4, not
necessarily the ultimate correct answer.
joe
[EMAIL PROTECTED] 08/21/01 03:25PM
It's possible, but not the only possibility. Therefore you
can't answer A.
And if you're not certain, you can't answer the question.
The structure of the table indicates to me that they began with the
assumption that each teacher would only be teaching one subject.
At 10:52 AM 8/21/01 -0800, you wrote:
i still stand by(reading into the question)
that it could be only 2 teachers get a raise, if the same 2 teachers
teach both
Yes, if 102 and 105 are valid subject_id codes. The correct answer is Not
enough data has been supplied to properly evaluate the results.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
If you're talking DB2 on OS/390, the default is EBCDIC but as of DB2 V5, the
default could be changed to ASCII on a table per table basis.
FT
-Original Message-
Sent: August 21, 2001 1:47 PM
To: Multiple recipients
I've got a new install on a HP cluster (windows NT service pack 6) oracle
8.1.7 and failsafe 3.1.2, oracle odbc 8.1.7.4.
Everything seems to work - database and cluster all failover. I can
reconnect to the node after failover, but the odbc driver (with the enable
retry option checked) doesn't
Hello there, Oracle users!I am new here, as new to the Oracle
technology. We are developping a =software which must be transaction
compliant, and we're on microsoft =platform, and thatswy we're using sql2000
and microsoft transaction =server for our application server
components.=20But one
I've found SuSE easier to work with than RH.
Jared
Robertson Lee
Currently upgrading from Coldfusion 4.0 to 4.5 and now all the CF forms
are having problems displaying time portion of date fields. Regardless
of the value of the time, CF always displays 12:00 AM. Anyone else
encounter this problem when converting/using CF?
begin:vcard
n:Taylor;Belinda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 9:48 AM
On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
Bufer busy waits can also be caused by parallel query
servers trying to read the same buffer
Nope u do not have to copy the online redologfiles to the standby, this has
to be done only in the case of switch over from production to the standby
database.
The online redos are only read when the database is getting opened it will
not be read during recovery until and unless u specify the
Need to add accounting for LOB indexes or simply not to add whenever SQL
error ...
alter index .. rebuild does not work for LOB indexes.
Alex Hillman
-Original Message-
Sent: Tuesday, August 21, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
I just did this yesterday. Here are
Not true.
Oracle 8.1.7 is supported on SuSE 7.1
It requires a patch, available through otn.oracle.com and suse.com.
Works fine for me.
Jared
Ron
Yeah, like I said, I wasn't thinking too hard about it. :)
Jared
Jonathan Lewis
Correct me if I'm wrong, but wasn't Red Hat Oracle's preferred Linux
distribution, right up until the time they announced the availability of the Red
Hat Database (PostgreSQL)?
Brian
Christopher Spence wrote:
I would be curious to see these tests going forward, seeing as RedHat
support is
Title: w2k db connections... shudder
OK. This question is posed to those who maintain applications Oracle on Windows 2000 servers.
What's the maximum number of connections you can feasibly support?
Has anyone implemented a windows 2000 cluster and had it reliably work?
I feel
Each subject has 2 teachers. By limiting the update by 2 subject_id's,
you guarantee that 4 teachers will get a raise. Actually, this is poor
SQL if a teacher teaches more than one subject (but that's not part of
the problem).
Scott Shafer
San Antonio, TX
[EMAIL PROTECTED] wrote:
I am
Hello,
We are in the process of learning and implementing RMAN.
We are also in the process of implementing BCP (Business Continuity
Planning). We have a BCP machine with enough disk space to do a restore of
our "production-critical" databases. I need to be able to make a copy of
the RMAN
Hi,
My database generated so many archived log now, let say 20 archived log per
minute. The application and the number of rows in the database is not too
much different with few days ago.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived log
Hi,
My database generated so many archived log now, let say 20 archived log per
minute. The application and the number of rows in the database is not too
much different with few days ago.
I'm just wondering why.
Is it any parameter we need to set to reduce the number of this archived log
Check for code doing insert,delete,update etc in v$sqlarea..
you may run following script to check for active sessions resulting lot of
DML's
select
substr(username,1,10)USER,process,sid,substr(sql_text,1,200),disk_reads,buffer_gets,rows_processed
from v$session,v$sqlarea
where
Hi all,
Is there a way to connect or see if a username and password are valid in a
PL/SQL procedure?
I will come in as one user. Pass in the username and password I want to
validate. Try to connect to the
database with that username and password.
Thanks,
David
--
Please see the official
I've got a requirement to do DML from an RPG program running in an AS400
against a database on a Sun box
running Oracle.
Has anyone done this?
Any pointers?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Let's not turn this forum into a help-desk for all questions you don't
care to bother to research yourself.
Jared
Huy_Le@manulif
Did you perchance leave all your tablespaces in backup mode?
Jared
Aldi Barco
Hi all,
Although it is a little late in this thread, keep in mind that
'STATISTICS=ESTIMATE' kicks in by default for export. This could also have
affected the final outcome, i.e. CHOOSE with incorrect stats isn't exactly
the right combination for the best performance ;-)
IMHO, this gotcha has
And for those who are daring, attend the Fulsom Street Fair.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Either lead by example, or become a terrible warning
I get the same kind of message, anyone knows what it means?
Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-Mensaje original-
De: mala singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 23 de Octubre de 2000 03:01 p.m.
Para: Multiple recipients of
Hi Gurus
Thanks you so much for reading my
problem.
I am a new oracle user and I really interested in
exploring this product.
In fact I want to know it clearly and can control
it in the future.
Someone has said to me that it's better
tobecome a DBA but it seems very difficult for me
smacks of incremental checkpointing...new implemented
in 8i i thinkthe RBA is a redo block address.
More than that, and you'll have to smoke some DBA crack,
make some guru mushroom tea, hack the internals, write a
book, and then become highly enigmatic and largely helpful.
-Original
Try Oracle Gateway.
kevin
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
I've got a requirement to do DML from an RPG program running in an AS400
against a database on a Sun box
running Oracle.
Has anyone done
Or just be like me and spend most of the time saying rtfm :)
joe
Mohan, Ross wrote:
smacks of incremental checkpointing...new implemented
in 8i i thinkthe RBA is a redo block address.
More than that, and you'll have to smoke some DBA crack,
make some guru mushroom tea, hack the
Larry:
Upon rereading your post (this time with my eyes open!), I see your
problem. Hmm. I worked with a developer who did something like this. I
don't know all the details, but I seem to recall that he didn't put the
password in the DSN for the ODBC connection, but rather encrypted it in
an
Ross:
I believe that RBA is referred to Redo Byte Address (Checkpoint RBA).
The checkpoint RBA is stored in the control file. When recovery is required,
the checkpoint RBA determines the location in the redo stream from which to
start applying recovery.
kevin
-Original Message-
Sent:
John,
Thanks for update. But in our case no export was involved in migration as it
was not our option for migration because of Database size. We used 7.3.4.5
datafiles and migrated...there were no statistics of our objects
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple
Raja, You will only have freelist contention on
conventional insert operations only. Insert operations
from direct loads won't cause freelist contention
because of the way direct inserts are done. You can
check for freelist contention by checking
V$SESSION_WAIT and look for the Event 'Buffer Busy
8i implements lazy checkpointing. The dirty buffers
are flushed to disk but the datafile headers are
updated later and when all the datafile headers are
updated the checkpoint complete is written to the
alert log. So it is not uncommon to checkpoints taking
longer in 8i.
Scott
--- Kevin Tsay
I believe that Oracle has decided that when porting to
linux all products will be ported to SuSE and then
perform post release certifications on Redhat. I
believe stability and support of multiple Linux
distributions was a factor in this decision. I run
both Redhat and SuSE and I actually perfer
Clint, The last I heard was that Oracle is not going
release anymore software for X86 Solaris. 8.1.7 is the
terminal release. I think that should sum up the
pro's and con's.
Scott
--- Clinton Naude [EMAIL PROTECTED] wrote:
Hi all.
I sent out a mail recently about Oracle for Solaris
on
What is unil-bialism ??
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 20, 2001 2:12 PM
FYI, in a previous message I detailed some of the tuning efforts we have
been working on in regards to getting a EDI sales order processing
Jon,
This is one of the options we have talked about. This
will require the vendor to do a bit of progamming. But
since they havent provided any security to this point,
it is the least they can do.
I'm just wondering if anyone has any ideas we can use
as a stop gap until the app is changed.
Kevin,
Thanksclarity is always preferable.
As for the acronym inflationI guess when I wrote block instead of
byte, I simply hadn't smoked enough DBA crack. (That's Data Block Address,
I think, but...where *did* i leave that mushroom tea...darnit...)
:)
Ross
-Original
101 - 164 of 164 matches
Mail list logo