RE: GRANT REFERENCES
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, November 29, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Subject: GRANT REFERENCES Hi All, I am trying to GRANT REFERENCES on a table that resides on a different database, on a different server. Is this possible and how do I go about doing it. TIA E.
RE: Determinants of control file
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 [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 11:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
Re: Has anyone heard of Mirror Accessible?
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, 2001 2:25 PM There seems to be a bit of confusion here. RAC is not related to standby database. DataGuard is the big enhancement for standby databases in 9i. RAC is the name for the 9i incarnation of OPS (Oracle Parallel Server.). If the database to be mirrored, then it is completely independent of OPS/RAC - which shares a single database. It could be a standby database, geo-mirroring, ... The term mirror accessible sounds like it came from one of those pseudo-technical trade magazine articles that are famous for misinforming senior IT management. ;-) -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 1:10 PM Jay - I did a search on Google and that returned nada, so I don't believe that mirror accessible is a bona fide term. However, looking at your words Oracle has a product . . . database to be mirrored for reporting purposes, he might be referring to Oracle9i's Real Application Clusters. In the Oracle 8i incarnation, there was a limitation with a standby database. The standby could be made current by applying the redo logs from the production database (using recovery), then opened and used for reporting. But you couldn't have both - currency and reporting. I think I heard that with Oracle 9i RAC this limitation has been bypassed so you can do reporting while the logs are continuing to be applied. Don't take my word for it (this is Friday after all), but you might want to look at RAC, and maybe someone more knowledgeable than me will respond on this list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 30, 2001 11:47 AM To: Multiple recipients of list ORACLE-L My CIO woes continue. My manager has been told by the CIO that Oracle has a product called mirror accessible which allows the database to be mirrored for reporting purposes. He wants us to use this product. Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby and Oracle Replication but he says it isn't any of these. Any idea what he might be talking about? Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Buffer Busy Waits -- Sanity check please
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 here I guess, it's Saturday and I dont' want to think too hard about all this. Don't have time to break out the FM so I'll just sit back and wait for you to agree or refute. ;) Jared On Tuesday 27 November 2001 00:25, Thorns, Malcolm (NESL-IT) wrote: Jeff, The 3 sessions are doing the same (or similar) queries. In this case count(*) which is forcing a full table scan of the table in each session. The 3 sessions are thus trying to access the same blocks from the SGA, in the same order. Only 1 session can access a block in the SGA at a time - this is the session showing 'db file scattered read'. The other 2 sessions need to wait for the block (these waits show as 'buffer busy waits' - ie waiting for the block in the SGA). You will see the block id (and perhaps the file id) changing as the FTS's progress. Thus the sessions are 'chasing' each other through the blocks - holding each other up with SGA block contention - which shows up as 'buffer busy waits'. Hope that explains things. Regards, Malcolm -Original Message- Sent: Monday, November 26, 2001 11:21 PM To: Multiple recipients of list ORACLE-L We recently had a new website go live. Since then, I'm seeing constant buffer busy waits and after a period of time, I see sessions hung on the same block#.The SQL query is always a COUNT(*) (below). It's almost as though one session has a lock of some sort in the buffer cache and other sessions are blocked. Although, I've checked and there's no DML ongoing, so I'm unsure as to why we would see this. Note that v$session shows 78 and 393 to be INACTIVE, while 159 is ACTIVE.So it's like 159 can't write to the buffer cache because 78 and 393 have a lock there. Note that these are all defined as persistent connections, via the Vignette front-end. I'm sure all the clues are there but my brain is too fuzzed to piece it together. SID SQL_TEXT O/S User - --- 159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT FROM BBN.BBN_SRV vignette 159 _PAID_WARR_CLAIM WHERE CUSTOMER_ID = :b1 AND ENTERPRISE_CD = : vignette 159 b2 AND (CHECK_ID IS NOT NULL AND CHECK_ID != 'PENDING' ) vignette SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - -- -- --- -- - -- 78 buffer busy waitsfile# 72 block# 109177 id 130 393 buffer busy waitsfile# 72 block# 109177 id 130 159 db file scattered read file# 72 block# 109177 blocks 8 Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba http://gkmqp.tce.com/tis_dba *** * E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 *** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RE: Has anyone heard of Mirror Accessible?
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 switch to and from the standby. Never tried it and wouldn't try it till 9.0.2 (at the minimum) Hemant Miller, Jay [EMAIL PROTECTED]01/12/2001 05:45 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: Has anyone heard of Mirror Accessible? Can anyone confirm this? I've been searching technet and metalink and can't turn up any details. -Original Message- Sent: Friday, November 30, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Isn't that just in release 2 though? My understanding is that its not out yet. -Original Message- Sent: Friday, November 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Ah, this sounds likely. And it might explain why they were keen on having us upgrade to 9i. That's the problem with receiving the request filtered through two additional levels of people. Jay Miller -Original Message- Sent: Friday, November 30, 2001 1:56 PM To: Multiple recipients of list ORACLE-L 9i has a new feature on standby databases that let's you run reports in read only while continuing the managed recovery. I think they call it a logical standby database. See the 9i DataGuard manual for more information. (I just happened to be looking into this lately). This might be what they are talking about. Best, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 12:05 PM Only thing I can think of off the top of my head is a standby database opened in read only mode. Its one of the purposes totted for that -Original Message- Sent: Friday, November 30, 2001 9:47 AM To: Multiple recipients of list ORACLE-L My CIO woes continue. My manager has been told by the CIO that Oracle has a product called mirror accessible which allows the database to be mirrored for reporting purposes. He wants us to use this product. Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby and Oracle Replication but he says it isn't any of these. Any idea what he might be talking about? Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
RE: Buffer Busy Waits -- Sanity check please
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 read of that block is complete. For a definition of the P3 values see Steve Adam's website http://www.ixora.com.au/ His full explanation of P3 id 130 is 1013Block is being read by another session and no other or 130suitable block image was found, so we wait until the read is completed. This may also occur after a buffer cache assumed deadlock. The kernel can't get a buffer in a certain amount of time and assumes a deadlock. Therefore it will read the CR version of the block. Ian MacGregor -Original Message- Sent: Saturday, December 01, 2001 6:20 PM To: Multiple recipients of list ORACLE-L 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 here I guess, it's Saturday and I dont' want to think too hard about all this. Don't have time to break out the FM so I'll just sit back and wait for you to agree or refute. ;) Jared On Tuesday 27 November 2001 00:25, Thorns, Malcolm (NESL-IT) wrote: Jeff, The 3 sessions are doing the same (or similar) queries. In this case count(*) which is forcing a full table scan of the table in each session. The 3 sessions are thus trying to access the same blocks from the SGA, in the same order. Only 1 session can access a block in the SGA at a time - this is the session showing 'db file scattered read'. The other 2 sessions need to wait for the block (these waits show as 'buffer busy waits' - ie waiting for the block in the SGA). You will see the block id (and perhaps the file id) changing as the FTS's progress. Thus the sessions are 'chasing' each other through the blocks - holding each other up with SGA block contention - which shows up as 'buffer busy waits'. Hope that explains things. Regards, Malcolm -Original Message- Sent: Monday, November 26, 2001 11:21 PM To: Multiple recipients of list ORACLE-L We recently had a new website go live. Since then, I'm seeing constant buffer busy waits and after a period of time, I see sessions hung on the same block#.The SQL query is always a COUNT(*) (below). It's almost as though one session has a lock of some sort in the buffer cache and other sessions are blocked. Although, I've checked and there's no DML ongoing, so I'm unsure as to why we would see this. Note that v$session shows 78 and 393 to be INACTIVE, while 159 is ACTIVE.So it's like 159 can't write to the buffer cache because 78 and 393 have a lock there. Note that these are all defined as persistent connections, via the Vignette front-end. I'm sure all the clues are there but my brain is too fuzzed to piece it together. SID SQL_TEXT O/S User - --- 159 SELECT COUNT(*) NUM,SUM(TOTAL_CHARGE_AMT) TOT FROM BBN.BBN_SRV vignette 159 _PAID_WARR_CLAIM WHERE CUSTOMER_ID = :b1 AND ENTERPRISE_CD = : vignette 159 b2 AND (CHECK_ID IS NOT NULL AND CHECK_ID != 'PENDING' ) vignette SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - -- -- --- -- - -- 78 buffer busy waitsfile# 72 block# 109177 id 130 393 buffer busy waitsfile# 72 block# 109177 id 130 159 db file scattered read file# 72 block# 109177 blocks 8 Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba http://gkmqp.tce.com/tis_dba *** * E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be
DISPLAY under AIX 4.3.3, was Fwd: urgent!!
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 * http://MichiganWaterfalls.com * http://ValleySpur.com Saturday, December 01, 2001, 12:16:24 AM, [EMAIL PROTECTED] wrote: Sir, We are installing Oracle 8i under AIX 4.3.3 but we encounter DISPLAY variable error. It read something like 'Can't connect to fbsrv server as the value of DISPLAY variable. We followed the Oracle manual by defining DISPLAY=fbsrv:0.0 and enter the command export $DISPLAY. We also tried xhost +fbsrv command, but still we encountered the same error. What shall we do? We need your help. Thanks, Alex Almendras Energy Development Corp. - Philippines. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).