Title: RE: GRANT REFERENCES
Oracle itself saying that, you cann't create foreign key for a remote database table.
To achive this, use database triggers.
Let me know if am wrong?
Nirmal.
-Original Message-
From: Ekan Emokpae [SMTP:[EMAIL PROTECTED]]
Sent: Thursday,
Title: RE: Determinants of control file
No. i already checked the view v$control_record_section,
This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc
Nirmal.
-Original Message-
From: K Gopalakrishnan
Yeah,
The CEO needs to be anonymously informed that he needs a CIO with a higher
degree of intelligence and technical expertise. The current one is a waste
of flesh.
--Scott
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 30,
Malcolm,
The paragraph below would indicate that readers are blocking.
Readers don't block in Oracle. The only reason I can think of at
the moment for a SELECT to cause buffer busy waits is delayed
block cleanout, of which there has been a lot of discussion lately.
I could be all mixed up
AFAIK, 9iDataGuard in the current release is only a Physical Standby
database
(not logical standby database). This is similar to 8i except for the
fact that, if you
ensure that you do a clean failover-and-failback (ie have the controlfiles
and
online redo log files available) you can actually
The P3 value of 130 on the buffer busy waits does indicate that the block is being
read by another process as Malcolm stated that's the process doing the scattered read
(Full table scan). Oracle needs to protect the block while it is being read. The
others sessions are waiting until the
Normally I don't forward reader emails that I receive, but
in this case the problem seems to be urgent. Is there anyone
using AIX on this list that might have a solution for Alex
--
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com *