OFA and RAC on raw devices
Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: col_usage$ question
Bingo! I did pretty much the same thing for an 8i DW with plenty of ad-hoc queries. I had no way of knowing what those ad-hoc queries might look like, and they will change over time. So I set up a polling process to do a textual parse of v$sql for those SQLs with highest disk_reads and/or buffer_gets, and feed those column names directly to the analyze process to collect histograms. I started off with a restriction that only skewed columns will get histograms, and thought I had a pretty good method of defining skew. Turned out that even the columns that do not appear skewed do actually affect CBO decisions. Putting histograms on those apparently un-skewed columns produced at least similar, and in some cases, dramatically better results. So, anything in the predicate of a heavy SQL, I histogrammed it. - Original Message - . It is currently (Oracle 9) used to decide if i might be worth gathering histogram information for a column - together with the determination if the data in the column is sufficiently skewed. No point in gathering histograms on non-skewed data or on data that is never referenced in a predicate. I can imagine that Oracle 10 will use that data to recommend indexes - as Daniel suggested. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
SQL_Trace versus Statspack
We are doing Interest processing on a SET of 10,000 Bank A/cs using a Single Database connect process. SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? Qs. Have we possibly missed some SQL trace files? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
test mail ...... plz ignore
(B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: SQL_Trace versus Statspack
Vivek, as others have pointed out before, Statspack is instance wide snapshot. Trace file is session specific. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 19, 2003 5:40 AM To: Multiple recipients of list ORACLE-L We are doing Interest processing on a SET of 10,000 Bank A/cs using a Single Database connect process. SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? Qs. Have we possibly missed some SQL trace files? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: col_usage$ question
Title: col_usage$ question Thanks Tanel, I also found that whenever one issues dbms_stats.flush_database_monitoring_info(), it updated some info in col_usage$ as well with mon_mods$ of course. That's where I found this reference and hence my original email. Thanks everyone. I am currently working on a test to prove that pipelining doesn't work as advertised in some cases (... only if I could get some free time to finish the test). Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 18, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: col_usage$ question Hi! If you describe this table then you see that this table stores column usage information in filter and join predicates for database objects. From describe, you see there are several filter and join conditions tracked for an object's (obj#) columns (intcol#). You can join them to col$ table for example. Duringshutdown, the session executingshutdown, writes the column usage statistics to col_usage$. During normal operations, it's SMON who's doing that over regular intervals. You can disable collecting these statistics by setting _column_tracking_level to 0. I don't really see where CBO could use those statistics for speeding up statement execution, because during execution CBO knows all the predicates statement structure anyway. But it is probably useful for various 10g's advisories, which can make you recommendations based on how the tables (columns) are used. Also, it might help automatic statistics gathering to determine which stats need to be updated or not (this gather stale stuff). Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 18, 2003 6:29 PM Subject: col_usage$ question Does anyone know what this table (sys.col_usage$) is used for? To me it sounds like something that CBO might appreciate ... but any ideas? It is referenced by dbms_stats and dbms_stats_internal packages ... Thanks in advance Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4 **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
Any articles/books that take relational theory and make it english?
I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** find whether table or index being accessed
MG, AFAIK v$object_usage is ONLY for current user ... you have to hack it to see remaining data. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, November 18, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Well, 'ALTER INDEX MONITORING USAGE' should do the trick. Results should be in V$OBJECT_USAGE. In connection to that, here is a sweet little bug in oracle 9.2.0.4: SQL select name from v$fixed_table where name='V$OBJECT_USAGE'; no rows selected Don't tell that to oracle, they might even fix it. Hi! It's probably not a bug, since v$object_usage is completely based on Oracle's base tables (as seen from view text), then it's not a fixed view, even though it has v$ in it's name. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Database Health Template-OT
Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. winmail.dat
Re: ** find whether table or index being accessed
Well, it's code is:
select io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
where io.owner# = userenv('SCHEMAID')
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#
All of the referenced objects are tables under sys.
Maybe you were talking about v$session_object_cache?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 3:20 PM
MG,
AFAIK v$object_usage is ONLY for current user ... you have to hack it to
see remaining data.
Raj
--
--
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Tuesday, November 18, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
Well, 'ALTER INDEX MONITORING USAGE' should do the trick. Results should
be
in V$OBJECT_USAGE. In connection to that, here is a sweet little bug in
oracle 9.2.0.4:
SQL select name from v$fixed_table where name='V$OBJECT_USAGE';
no rows selected
Don't tell that to oracle, they might even fix it.
Hi!
It's probably not a bug, since v$object_usage is completely based on
Oracle's base tables (as seen from view text), then it's not a fixed view,
even though it has v$ in it's name.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
**
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, attorney
work product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
message from your computer, Thank you.
**5
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Database Health Template-OT
these are bogus. its just about giving your boss some BS, so he goes away. Been there, done that. the only useful stuff to send him would be polling the alert log for 'ORA' errors, checking for chained rows as a percentage of total rows, and check to see how much free space is in each datafile. you can also send him statspack stuff, but he wont be able to read it. might want to send him a max users count and stuff like that. but that really isnt a 'health' check. what are you sending him now? hit ratios? Those are garbage. Even though the damn OCP test says to use them(im still annoyed by that).. its garbage. From: Shibu MB [EMAIL PROTECTED] Date: 2003/11/19 Wed AM 08:50:07 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database Health Template-OT Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. encoded content removed -- binaries not allowed by ListGuruContent-Type: application/ms-tnef; The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification.
Re: Oracle shared object files on Solaris, and ELF class.
Grant, You can simply use the file command to find out the ELF class. If it reports 32-bit, it's ELFCLASS32; if it's 64-bit, i's ELFCLASS64. When you say client shadow process, I assume you mean the shadow process on the server (as a shadow of the client in dedicated configuration). You may want to check all libraries under $ORACLE_HOME/lib: cd $ORACLE_HOME/lib; file * | grep 64; file * | grep 32. If they're mixed, you need to relink. Yong Huang --- Grant Allen [EMAIL PROTECTED] wrote: Hi all, Looking for possible causes for a ELFCLASS64 version of /oracle/product/8.1.7/lib/libobk.so accidentally cropping up for a 32-bit install. This was on a client site ... so some details I can't disclose ... but it's a clean 8.1.7.0.0 install under Solaris (8 I think). Caused the client shadow process to bomb out with a fatal error (Looked like this in the trace file dlopen gets error 'ld.so.1: ora_s000_ORCL: fatal: /u01/app/oracle/product/8.1.7/lib/libobk.so: wrong ELF class: ELFCLASS64 ' when opening object ) Failing that, does anyone know of a utility that can check the elf class of .so files under Solaris? A google (and search on sun.com) for such a beast drew a blank. Thanks Fuzzy __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it english?
Title: RE: Any articles/books that take relational theory and make it english? Ryan, I often recommend Database Design for Mere Mortals by Michael J. Hernandez for my students, new database developers, and especially for programmers that I work with. It's a step above something like Databases for Dummies. Still it might be less than what you are looking for. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. Thanks.
RE: OFA and RAC on raw devices
Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. 3. UNDO (RAW FILES) - Each node will have its own UNDO. We have STRIPED RAID1+0 to have good performance. Database is not pointing to RAW FILES directly. I have created SOFT LINKS to point to RAW FILES. I have created TABLESPACE using SOFT LINKS. Muqthar Ahmed -Original Message- Sent: Wednesday, November 19, 2003 1:55 AM To: Multiple recipients of list ORACLE-L Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). * * * * * * * * * The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: v$bh.class#
I think Ixora website had the list with 9i stuff in it, but you also can get some of the class definitions out by checking gv$waitstat's source: select inst_id,decode(indx,1,'data block',2,'sort block',3,'save undo block', 4,'segment header',5,'save undo header',6,'free list',7,'extent map', 8,'1st level bmb',9,'2nd level bmb',10,'3rd level bmb', 11,'bitmap blo ck',12,'bitmap index block',13,'file header block',14,'unused', 15,'system undo header',16,'system undo block ', 17,'undo header',18,'undo block'), count,time from x$kcbwait where indx!=0 Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:14 AM In constructing my last answer, I looked at v$bh and the class# column (thinking that perhaps indexes or index headers had their own class). I came across several different values for the class# from 0 to 36 (not inclusive). Oracle's doc does not clear it up and Steve Adam's book's information does not match up to a 9i db. Before I head down the path of figuring this out on my own, anyone have a listing for the class# in 9i? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it
Data Modeling Essentials by Graeme C Simsion is a very good book. American Express made the following annotations on 11/19/2003 07:36:46 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OWS-05566 caused by ORA-12202
Is anyone else getting messages like this, just the footer added by Fat City? Thanks. Ben Schilling Wis Insurance Commission 608-266-1615 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 18, 2003 12:34 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** find whether table or index being accessed
Tanel,
Raj must be talking about userenv('SCHEMAID'). Change that to another user's
user_id as seen in dba_users, you should see that user's object usage:
SQL select * from v$object_usage;
no rows selected
SQL select io.name, t.name,
2 decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
3 decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
4 ou.start_monitoring,
5 ou.end_monitoring
6 from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
7 where io.owner# = 32
8and i.obj# = ou.obj#
9and io.obj# = ou.obj#
10and t.obj# = i.bo#;
NAME NAME DEC DEC
START_MONITORINGEND_MONITORING
-- -- --- ---
--- ---
AGENT_LICENSE_STATEPRDNO_IND AGENT_LICENSE YES YES
11/18/2003 10:06:27
...
Yong Huang
--- Tanel Poder [EMAIL PROTECTED] wrote:
Well, it's code is:
select io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
where io.owner# = userenv('SCHEMAID')
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#
All of the referenced objects are tables under sys.
Maybe you were talking about v$session_object_cache?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 3:20 PM
MG,
AFAIK v$object_usage is ONLY for current user ... you have to hack it to
see remaining data.
Raj
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: v$bh.class#
Tanel, Thanks for the info, unfortunately it does not explain what I am seeing (almost, but not quite). I'll see if I can figure it out. Daniel Tanel Poder wrote: I think Ixora website had the list with 9i stuff in it, but you also can get some of the class definitions out by checking gv$waitstat's source: select inst_id,decode(indx,1,'data block',2,'sort block',3,'save undo block', 4,'segment header',5,'save undo header',6,'free list',7,'extent map', 8,'1st level bmb',9,'2nd level bmb',10,'3rd level bmb', 11,'bitmap blo ck',12,'bitmap index block',13,'file header block',14,'unused', 15,'system undo header',16,'system undo block ', 17,'undo header',18,'undo block'), count,time from x$kcbwait where indx!=0 Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 12:14 AM In constructing my last answer, I looked at v$bh and the class# column (thinking that perhaps indexes or index headers had their own class). I came across several different values for the class# from 0 to 36 (not inclusive). Oracle's doc does not clear it up and Steve Adam's book's information does not match up to a 9i db. Before I head down the path of figuring this out on my own, anyone have a listing for the class# in 9i? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
New Virus alert from paypal
List, Any one else get word of this new virus? Ron Mar-D Greer 11/19/2003 9:34:44 AM There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: New Virus alert from paypal
Sure have I don't have a PayPall account. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 19, 2003 10:40 AM To: Multiple recipients of list ORACLE-L List, Any one else get word of this new virus? Ron Mar-D Greer 11/19/2003 9:34:44 AM There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Development vs. Production DBA
Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: New Virus alert from paypal
I received such e-mail from PayPal, didn't bother to follow instructions, just deleted it. I'm not using PayPal anymore. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Ron Rogers Sent: Wednesday, November 19, 2003 10:40 AM To: Multiple recipients of list ORACLE-L List, Any one else get word of this new virus? Ron Mar-D Greer 11/19/2003 9:34:44 AM There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
FW: SAN configuration for Banner
Title: SAN configuration for Banner Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We dont have the SAN yet, but it is due to arrive any week (if not any day). I passed Carys Is RAID 5 Really a Bargain? paper to our Sys Admin, which he read and succinctly summarized for the Technical Manager here. I have also read through a couple of papers referenced in the BAARF site. The Sys Admin comments were: Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Here is the Managers response: Any suggestions on how I can counter points 4 and 5 and the last point before his Thanks line? Currently we have two B80s (AIX 4.3.3) set up in a HA configuration. They share an external disk array. So if a hardware component in the primary box fails, then it will automatically failover to the secondary box (and at the same time, the secondary box takes control of the external disk array). I think the clustering term in point (4) is referring to this setup. Thanks for any suggestions. Sam. Sent: November 18, 2003 5:08 PM Subject: RE: SAN configuration for Banner All the points are valid...however..my thought processes were as follows: 1. The System Core Application disks are resident on the disks within the CPU and Mirrorred (Everyone OK with that I think) 2. The Databases are Resident on the SAN 3. The SAN disks are RAID 5 as the provide more usable space for the cost as compared to mirrorring 4. As the IBM Systems (B80's 6C4's) are clusterd thus effectivley Mirrors the RAID 5 Arrays mitigating the issues Sam raises re preformance degradation (which will only ever arisein the event of a failed disk/automated rebuild which is usually configurable to address performance degradation) 5. Write to Disk/Commit to Database should be a background process (although I recognise this is a transaction/write intensivebased system) This is a standard model that all servers are being deployed with and unless there are any specific technical reasons why this will not work it is the way I would like to see the systems implemented. Remeber, with the SAN...Reconfiguration of Disks is not a large issue anymore if required in the future. Although not an AIX/Oracle guy...I disagree with the statement that RAID5 is 3 times more susceptable to incur Data Loss. RAID 5 is a proven technology Thanks. Andrew -Original Message- From: Carl Nowak Sent: Tue 18/11/2003 2:56 PM To: Andrew Riem Subject: SAN configuration for Banner Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Carl
RE: ** find whether table or index being accessed
The last statement here is not always true under CBO, at least in 8i. All unique indexes (no PKs, no FKs) on our 3rd-party ERP tables are segmented, and the last segment is always company code. Even though there is only one company code value for all rows in all tables, some queries that do not specify that column will not use that index. That was probably the biggest pain going from RBO to CBO for us. So, for your example, joining YOURTABLE to MYTABLE using only N1 and N2 does not necessarily mean that index IDX2 will be used. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, November 18, 2003 4:20 PM To: Multiple recipients of list ORACLE-L I was too lazy to look for it on asktom.oracle.com, but here's what I read at the site a while ago (if you search on index usage or something like that you should find Mr. Kyte's answer). Tom Kyte has the following suggestions: a) In Oracle 8.0 and earlier - put an index all by itself in a tablespace, and check reads and writes on the tablespace. If reads are close to writes - index not being used (only read for updates.) If reads much larger than writes - indexes being used. b) In Oracle 9.0 and later - use alter index ... monitoring and check v$object_usage c) In Oracle 8.1 (your case): See Chapter 11 of his book expert one-on-one Oracle - use stored outlines. Use an ON LOGON trigger to enable automatic outline generation (and disable it after a while) - look in user_outline_hints to see if the index is being used. Finally, even though an index is used, that doesn't mean it's necessary. e.g. if you have index IDX1 on MYTABLE (N1, N2) and index IDX2 on MYTABLE (N1, N2, N3) IDX1 may be used by some queries but might not be necessary because the query could use IDX2. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Development vs. Production DBA
Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Development vs. Production DBA
I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it
On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. Hrm, I thought a key, by definition, implied a unique constraint... All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. I'm not sure what the opinion on Fabian Pascal is here on the list, but I found his Practical issues in Database Management to be very good. It's subtitled A reference for the thinking practitioner. It's not a textbook, but it does make you use your brain a bit. It might be what you're looking for. It has helped to clarify the relational model for me, but might put some people off as it's critical (without naming specific products) of most current implementations of 'relational' databases. Thanks. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ut_file limit
Thanks for reply everybody , I was not closing the file , which was causing write not to flush . Solved now -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 10:59 AM AK, Do you get INVALID_MAXLINESIZE exception? Documentation says it maxes at 32767. I didn't find file size limit. UTL_FILE.FOPEN also has a max_linesize that can be set to 32767. Yong Huang --- AK [EMAIL PROTECTED] wrote: what is max filesize for utl_limit.fopen ? I am unable to past beyond 51K . -ak __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Development vs. Production DBA
George, Early involvement and advice are certainly in my view essential to the success of a project. However, concerning the creation of packages, etc. I fear I don't share your views. Involvement is justified if it adds value. If it's just adding another layer of red tape, forget about it. I think that DBAs should _review_ installation scripts, especially those creating tables, indices, constraints (I sometimes dream of meeting a developer aware of the 'using index' clause), not necessarily to _run_ them but to check that they satisfy local standards; and if they don't, they should be returned to the sender for correction. If you correct scripts and run them, you'll have to do it again and again with each release. We have a duty to teach developers :-). Concerning procedures, if you are yourself a competent PL/SQL developer and can review the code and tell people how they can do it better and faster, great. But many competent DBAs are not necessarily competent developers themselves - and I don't think that they have to be. I don't see where having stored procedures created by DBAs on a development database can improve development quality or speed. I see more added value creating a suitable environment (generating a realistic volume of data, creating and administering the suitable roles, creating synonyms to allow people to work on separate parts of a project without having multiple copies of the same database, helping with version control, helping with developing performance monitoring tools, etc.) than running scripts. In many ways, regularly meeting the project manager at the coffe machine may prove more fruitful. My $ 0.0238 ... SF - --- Original Message --- - From: Rusnak, George A. (SEC-Lee) CTR [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 19 Nov 2003 07:50:21 Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: building a reporting database
You can try advanced replication. It has overhead of about 10% on multi master synchronous replication on the live system. Use this only if you can put the servers near enough so you can directly connect then with high speed network cable. Yechiel AdarMehish - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Monday, November 17, 2003 7:59 PM Subject: building a reporting database hi i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good. - using aq and dq message processing - using snapshot replication - using ro standby databases. the last one will lag in data since standby database caanot have any archival log applied when opened in read only. is there any other good method to do this . my database is on 8.1.7.4 thanks sai
Re: Multimaster replication as alternative backup
We are doing exactly that. We use multi master synchronous replication. In case the regular server dies, we drop replication from the backup machine. Change one parameter in the application ini file (what db name to use in connections), start the application again. About 5 minutes turn around time. Use it only if you have high speed connection and the servers are close. It adds about 10% overhead to the application. It depends on the amount of updates vs. selects of the application. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 6:54 AM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Development vs. Production DBA
Agree with Stephane on this. Finding a balance of productivity, trust and security would be the goal... -Original Message- Sent: Wednesday, November 19, 2003 10:55 AM To: Multiple recipients of list ORACLE-L George, Early involvement and advice are certainly in my view essential to the success of a project. However, concerning the creation of packages, etc. I fear I don't share your views. Involvement is justified if it adds value. If it's just adding another layer of red tape, forget about it. I think that DBAs should _review_ installation scripts, especially those creating tables, indices, constraints (I sometimes dream of meeting a developer aware of the 'using index' clause), not necessarily to _run_ them but to check that they satisfy local standards; and if they don't, they should be returned to the sender for correction. If you correct scripts and run them, you'll have to do it again and again with each release. We have a duty to teach developers :-). Concerning procedures, if you are yourself a competent PL/SQL developer and can review the code and tell people how they can do it better and faster, great. But many competent DBAs are not necessarily competent developers themselves - and I don't think that they have to be. I don't see where having stored procedures created by DBAs on a development database can improve development quality or speed. I see more added value creating a suitable environment (generating a realistic volume of data, creating and administering the suitable roles, creating synonyms to allow people to work on separate parts of a project without having multiple copies of the same database, helping with version control, helping with developing performance monitoring tools, etc.) than running scripts. In many ways, regularly meeting the project manager at the coffe machine may prove more fruitful. My $ 0.0238 ... SF - --- Original Message --- - From: Rusnak, George A. (SEC-Lee) CTR [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 19 Nov 2003 07:50:21 Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Listener without IPC
Yes Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 7:24 AM What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: New Virus alert from paypal
Since, I believe, Paypal is owned by eBay, has any that's received this sent a message to safeharbor? I would think they should be made aware of it. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Wednesday, November 19, 2003 10:40 AM To: Multiple recipients of list ORACLE-L List, Any one else get word of this new virus? Ron Mar-D Greer 11/19/2003 9:34:44 AM There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Clean temporary tablespace
What version are you on? If less then 9i use the method posted by Hemant K Chitale. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 6:44 AM Well, I mean that OS (w2k) file size of temp01.ora grows faster... I've setup multimaster replication and as a result got temporary tablespace about 10 Gb. OEM shows that used only about 1Gb, so others 9Gb are gone. I wanna to free them for my purposes. Perhaps you could clarify what you mean by 'it grows up faster and faster'. What exactly does that mean, what script or tool is showing you that, what is its output, and why is it a problem? Restarting the database seems extreme advice for such a meager description of a problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Development vs. Production DBA
I will ditto Stephane's and Brad's opinions on this. If the DBA is a competent PL/SQL developer, then sure. If not, then don't try to write the PL/SQL. Being a competent PL/SQL developer is *much* more difficult than it was a few years ago. I can write PL/SQL all day if I can stick with stuff that is 5+ years old. :) There are so many new features available to the Oracle developer that it would be very difficult for a DBA to keep up. Jared Stephane Faroult [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/19/2003 08:55 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Development vs. Production DBA George, Early involvement and advice are certainly in my view essential to the success of a project. However, concerning the creation of packages, etc. I fear I don't share your views. Involvement is justified if it adds value. If it's just adding another layer of red tape, forget about it. I think that DBAs should _review_ installation scripts, especially those creating tables, indices, constraints (I sometimes dream of meeting a developer aware of the 'using index' clause), not necessarily to _run_ them but to check that they satisfy local standards; and if they don't, they should be returned to the sender for correction. If you correct scripts and run them, you'll have to do it again and again with each release. We have a duty to teach developers :-). Concerning procedures, if you are yourself a competent PL/SQL developer and can review the code and tell people how they can do it better and faster, great. But many competent DBAs are not necessarily competent developers themselves - and I don't think that they have to be. I don't see where having stored procedures created by DBAs on a development database can improve development quality or speed. I see more added value creating a suitable environment (generating a realistic volume of data, creating and administering the suitable roles, creating synonyms to allow people to work on separate parts of a project without having multiple copies of the same database, helping with version control, helping with developing performance monitoring tools, etc.) than running scripts. In many ways, regularly meeting the project manager at the coffe machine may prove more fruitful. My $ 0.0238 ... SF - --- Original Message --- - From: Rusnak, George A. (SEC-Lee) CTR [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 19 Nov 2003 07:50:21 Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Development vs. Production DBA
George - The earlier discussion was What is a Production DBA, and I found the links by Googling Oracle-l production dba. Excellent topic. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Multimaster replication as alternative backup
Yechiel - So how do you verify your backup environment? My gut feeling is that simpler systems are less prone to catastrophe, and multimaster replication definitely adds a lot of pieces compared to conventional backups. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 11:05 AM To: Multiple recipients of list ORACLE-L We are doing exactly that. We use multi master synchronous replication. In case the regular server dies, we drop replication from the backup machine. Change one parameter in the application ini file (what db name to use in connections), start the application again. About 5 minutes turn around time. Use it only if you have high speed connection and the servers are close. It adds about 10% overhead to the application. It depends on the amount of updates vs. selects of the application. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 6:54 AM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
RE: Development vs. Production DBA
As I moved from development to DBA, I am trying to keep up with pl/sql ... it is FUN !! Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, November 19, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Development vs. Production DBAI will ditto Stephane's and Brad's opinions on this. If the DBA is a competent PL/SQL developer, then sure. If not, then don't try to write the PL/SQL. Being a competent PL/SQL developer is *much* more difficult than it was a few years ago. I can write PL/SQL all day if I can stick with stuff that is 5+ years old. :) There are so many new features available to the Oracle developer that it would be very difficult for a DBA to keep up. Jared **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re: RE: Development vs. Production DBA
there arent that many new pl/sql features. 90% of the time your using the generic stuff. the new stuff is nice, but not always that special. Or maybe its just because I do it everyday. But how much is new? PL/SQL tables? Bulk binds? Dynamic SQL? That stuff is all basic. Its minor syntax differences. ive worked with plenty of developers who dont know anything beyond cursors. I think everyone should be competetent in PL/SQL. I also think all developers should be competent in tuning and architecture. The skillsets overlap. From: [EMAIL PROTECTED] Date: 2003/11/19 Wed PM 12:50:12 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA I will ditto Stephane's and Brad's opinions on this. If the DBA is a competent PL/SQL developer, then sure. If not, then don't try to write the PL/SQL. Being a competent PL/SQL developer is *much* more difficult than it was a few years ago. I can write PL/SQL all day if I can stick with stuff that is 5+ years old. :) There are so many new features available to the Oracle developer that it would be very difficult for a DBA to keep up. Jared Stephane Faroult [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/19/2003 08:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Development vs. Production DBA George, Early involvement and advice are certainly in my view essential to the success of a project. However, concerning the creation of packages, etc. I fear I don't share your views. Involvement is justified if it adds value. If it's just adding another layer of red tape, forget about it. I think that DBAs should _review_ installation scripts, especially those creating tables, indices, constraints (I sometimes dream of meeting a developer aware of the 'using index' clause), not necessarily to _run_ them but to check that they satisfy local standards; and if they don't, they should be returned to the sender for correction. If you correct scripts and run them, you'll have to do it again and again with each release. We have a duty to teach developers :-). Concerning procedures, if you are yourself a competent PL/SQL developer and can review the code and tell people how they can do it better and faster, great. But many competent DBAs are not necessarily competent developers themselves - and I don't think that they have to be. I don't see where having stored procedures created by DBAs on a development database can improve development quality or speed. I see more added value creating a suitable environment (generating a realistic volume of data, creating and administering the suitable roles, creating synonyms to allow people to work on separate parts of a project without having multiple copies of the same database, helping with version control, helping with developing performance monitoring tools, etc.) than running scripts. In many ways, regularly meeting the project manager at the coffe machine may prove more fruitful. My $ 0.0238 ... SF - --- Original Message --- - From: Rusnak, George A. (SEC-Lee) CTR [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 19 Nov 2003 07:50:21 Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). I will ditto Stephane's and Brad's opinions on this. If the DBA is a
Re: FW: SAN configuration for Banner
Oh boy. I'd first challenge the I disagree..RAID 5 is a proven technology. Ask him for credible research and/or statistics that support his position. Sure, RAID 5 is a proven technology...so are floppy disks, and so what? Second: clustered systems with failover mitigate disk array performance considerations? Just how does THAT work? Good luck! Paul --- Sam Bootsma [EMAIL PROTECTED] wrote: Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We don't have the SAN yet, but it is due to arrive any week (if not any day). I passed Cary's Is RAID 5 Really a Bargain? paper to our Sys Admin, which he read and succinctly summarized for the Technical Manager here. I have also read through a couple of papers referenced in the BAARF site. The Sys Admin comments were: Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Here is the Manager's response: Any suggestions on how I can counter points 4 and 5 - and the last point before his Thanks line? Currently we have two B80's (AIX 4.3.3) set up in a HA configuration. They share an external disk array. So if a hardware component in the primary box fails, then it will automatically failover to the secondary box (and at the same time, the secondary box takes control of the external disk array). I think the clustering term in point (4) is referring to this setup. Thanks for any suggestions. Sam. Sent: November 18, 2003 5:08 PM All the points are valid...however..my thought processes were as follows: 1. The System Core Application disks are resident on the disks within the CPU and Mirrorred (Everyone OK with that I think) 2. The Databases are Resident on the SAN 3. The SAN disks are RAID 5 as the provide more usable space for the cost as compared to mirrorring 4. As the IBM Systems (B80's 6C4's) are clusterd thus effectivley Mirrors the RAID 5 Arrays mitigating the issues Sam raises re preformance degradation (which will only ever arise in the event of a failed disk/automated rebuild which is usually configurable to address performance degradation) 5. Write to Disk/Commit to Database should be a background process (although I recognise this is a transaction/write intensive based system) This is a standard model that all servers are being deployed with and unless there are any specific technical reasons why this will not work it is the way I would like to see the systems implemented. Remeber, with the SAN...Reconfiguration of Disks is not a large issue anymore if required in the future. Although not an AIX/Oracle guy...I disagree with the statement that RAID5 is 3 times more susceptable to incur Data Loss. RAID 5 is a proven technology Thanks. Andrew -Original Message- From: Carl Nowak Sent: Tue 18/11/2003 2:56 PM To: Andrew Riem Subject: SAN configuration for Banner Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Carl __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it en
Ryan: I think the presentation on data modeling may help you understand and explain thoroughly to your team. If not, I would obtain a copy of Robert Barker's CASE*METHOD - Entity Relationship Diagramming book. The Data Modeling Essentials book is very technical and often hard to follow for non-academics. Call if you have any questions. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 8:25 AM To: Multiple recipients of list ORACLE-L Subject:Any articles/books that take relational theory and make it english? I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Database Health Template-OT
Shibu I agree with Ryan, that in a technical sense this is bogus. But I also feel there is a grain of truth in it. Often at its core the question has to do with comfort, and if recent incidents have caused a loss of comfort, then you get some sharp questions to answer. My strategy would be to increase the level of comfort, but don't commit yourself to wasting a lot of time once the sense of comfort returns. Here is what I would consider legitimate: 1. Install an alert log scanner that will email you when an error occurs. There are several free ones available on-line. 2. If you've experienced a recent crash, demonstrate you are taking serious actions to ensure this problem doesn't recur. Actions like monitoring. Here is what I consider bogus: 1. Constantly monitoring the buffer cache hit ratio. Marginal - run STATSPACK at regular intervals. I have had situations where the database would suddenly hang or freeze or slow-down. I found that a couple of STATSPACK snapshots could provide a wealth of information about what was going on at the time of the incident. Now, my strong preference is to be notified so I can manually trigger these snapshots, but if it makes someone feel better and get off my case if I have them run at regular intervals, then I'm okay with that. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 7:50 AM To: Multiple recipients of list ORACLE-L Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it en
To me, CJ Date is the one who makes it crystal clear. Not in his main book, but in his Relational Database Readings books, which I have most of. I have also seen some good articles by Fabian Pascal. I also have a new book called Data Modeling for Everyone by Sharon Allen, published by Curlingstone Press. It deals with how to actually do it - take it from conceptual to logical to physical, going straight to a physical model - which we all sometimes have to do, and how data modeling fits into a software project. Very good book. Otherwise, throw a problem out here and see if anyone here has ideas that may help you. I've loved data modeling my whole career and believe I could write a book myself about it (I didn't say anyone would read it!). I'm afraid that by turning it into DBA speak you might mean not understanding the essentials of data modeling. That wouldn't be good. I would take the most important things to remember and have an example in the real Oracle world of what that means. I personally believe that the most important thing to remember, the essence of a lot of data modeling, is that there should always be only one place for an item of data to go. Denormalization typically creates another place for it to go, so you have to remember to update two or three or four tables with the same data. HTH -Original Message- Sent: Wednesday, November 19, 2003 6:25 AM To: Multiple recipients of list ORACLE-L english? I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Database Health Template-OT
Guys, For management reporting has anyone considered OEM V9?? Has anyone installed it - do you know that it provides a number of reports already defined that can be setup to be run periodically and available on the web - all with the installation of the OEM V9? I was thinking this would save me a lot of time and provide web-available reporting for the PHB's. Hmmm. -Original Message- Sent: Wednesday, November 19, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Shibu I agree with Ryan, that in a technical sense this is bogus. But I also feel there is a grain of truth in it. Often at its core the question has to do with comfort, and if recent incidents have caused a loss of comfort, then you get some sharp questions to answer. My strategy would be to increase the level of comfort, but don't commit yourself to wasting a lot of time once the sense of comfort returns. Here is what I would consider legitimate: 1. Install an alert log scanner that will email you when an error occurs. There are several free ones available on-line. 2. If you've experienced a recent crash, demonstrate you are taking serious actions to ensure this problem doesn't recur. Actions like monitoring. Here is what I consider bogus: 1. Constantly monitoring the buffer cache hit ratio. Marginal - run STATSPACK at regular intervals. I have had situations where the database would suddenly hang or freeze or slow-down. I found that a couple of STATSPACK snapshots could provide a wealth of information about what was going on at the time of the incident. Now, my strong preference is to be notified so I can manually trigger these snapshots, but if it makes someone feel better and get off my case if I have them run at regular intervals, then I'm okay with that. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 7:50 AM To: Multiple recipients of list ORACLE-L Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: New Virus alert from paypal
Hi, I have had loads of them so far in the last few days, they are a hoax, it is being discussed on the incident list on security focus. I guess the anti-virus product manufacturers will have details by now as well. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Unable to view reports in web browser using OEM console.
I have been using the following setup. Windows 2000 Prof. / Oracle 9.0.1 / OEM 9.0.1 While using OEM console, when I want to view the database report, it just popup a DOS windows, but it does not show the report in the web browser. But on the other hand, I can view the reports by opening the web browser to reporting web site http://myserver:3339/. Any idea what I can do to integrate my web browser with the OEM console. Thanks. Dharminder Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FW: SAN configuration for Banner
Sam, Dell was perfectly happy to configure the following for me on a CX200 unit: (2 trays of 15 drives, 1 tray 36 GB 15K, 1 tray 73 GB 10K, 1 hot spare per tray) 3 x RAID 1 for online redo logs (members a,b,c, 6 drives total) 2 x RAID 01 for datafiles (8 drives each, 16 drives total) 1 x RAID 1 for archlogs (2 drives) 1 x RAID 01 for undo (4 drives) we used less than half of the available storage, saving that for when another system is migrated to this unit. when creating filesystems, we did not format the entire RAID vols for live files, and created filesystems for storing local backup sets. You will like having datafiles on 8 drive RAID 01 (or RAID 10) volumes. RMAN backups fly like you would not believe. hth. PaulSam Bootsma [EMAIL PROTECTED] wrote: Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We don’t have the SAN yet, but it is due to arrive any week (if not any day). I passed Cary’s “Is RAID 5 Really a Bargain?” paper to our Sys Admin, which he read and succinctly summarized for the Technical Manager here. I have also read through a couple of papers referenced in the BAARF site. The Sys Admin comments were: Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Here is the Manager’s response: Any suggestions on how I can counter points 4 and 5 – and the last point before his “Thanks” line? Currently we have two B80’s (AIX 4.3.3) set up in a HA configuration. They share an external disk array. So if a hardware component in the primary box fails, then it will automatically failover to the secondary box (and at the same time, the secondary box takes control of the external disk array). I think the clustering term in point (4) is referring to this setup. Thanks for any suggestions. Sam. Sent: November 18, 2003 5:08 PMSubject: RE: SAN configuration for Banner All the points are valid...however..my thought processes were as follows: 1. The System Core Application disks are resident on the disks within the CPU and Mirrorred (Everyone OK with that I think) 2. The Databases are Resident on the SAN 3. The SAN disks are RAID 5 as the provide more usable space for the cost as compared to mirrorring 4. As the IBM Systems (B80's 6C4's) are clusterd thus effectivley Mirrors the RAID 5 Arrays mitigating the issues Sam raises re preformance degradation (which will only ever arisein the event of a failed disk/automated rebuild which is usually configurable to address performance degradation) 5. Write to Disk/Commit to Database should be a background process (although I recognise this is a transaction/write intensivebased system) This is a standard model that all servers are being deployed with and unless there are any specific technical reasons why this will not work it is the way I would like to see the systems implemented. Remeber, with the SAN...Reconfiguration of Disks is not a large issue anymore if required in the future. Although not an AIX/Oracle guy...I disagree with the statement that RAID5 is 3 times more susceptable to incur Data Loss. RAID 5 is a proven technology Thanks. Andrew -Original Message- From: Carl Nowak Sent: Tue 18/11/2003 2:56 PM To: Andrew Riem Subject: SAN configuration for Banner Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Carl Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
RE: Database Health Template-OT
[EMAIL PROTECTED] scribbled on the wall in glitter crayon: Guys, For management reporting has anyone considered OEM V9?? Has anyone installed it - do you know that it provides a number of reports already defined that can be setup to be run periodically and available on the web - all with the installation of the OEM V9? but it's OEM, i've never managed to get it configured to run other than stand alone. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Anyone who is capable of getting themselves made President should on no account be allowed to do the job. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
unix question
I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Changing character set
Anyone change character sets recently? I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it was. It sounds like they have all the steps down pat and are pretty much ready to go, but are there any gotchas they may have missed? Will this affect the RMAN backups they get nightly? I've told them to do a cold file backup first, then try on test, and if all is cool they can proceed... 20 years working with Oracle and this is a first time for me. Web interface on this note, so I hope it comes out okay... -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it
I obviously can't speak for the list, but I find Fabian Pascal to be very interesting, but quite academic. What I *think* that I mean by this is that a lot of what he says seems to make theoretical sense, but I'm unsure how applicable it is to practice. IOW the general feel that I get from Fabian (and indeed Date) is that if something doesn't meet relational theory then it is flawed. This may well be a good default position to have, but I'm unprepared to say to folk who pay my wages 'sorry your data model isn't in 3NF' or 'you shall not use a materialized view'. I *will* quite happily say 'so how will you ensure data integrity?' 'what happens if another program uses the same data' or 'why did you use computed summaries?' Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Hanks Sent: 19 November 2003 16:25 To: Multiple recipients of list ORACLE-L Subject: Re: Any articles/books that take relational theory and make it On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. Hrm, I thought a key, by definition, implied a unique constraint... All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. I'm not sure what the opinion on Fabian Pascal is here on the list, but I found his Practical issues in Database Management to be very good. It's subtitled A reference for the thinking practitioner. It's not a textbook, but it does make you use your brain a bit. It might be what you're looking for. It has helped to clarify the relational model for me, but might put some people off as it's critical (without naming specific products) of most current implementations of 'relational' databases. Thanks. -- Dan == == Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division == == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Database Health Template-OT
I did using OEM Version 2 something on 8i databases. Multiple agents - got it running - agent management was rather a pain in the ##$$%%% I agree. Still I am thinking this new version with its bells and whistles might be better. -Original Message- Sent: Wednesday, November 19, 2003 3:25 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scribbled on the wall in glitter crayon: Guys, For management reporting has anyone considered OEM V9?? Has anyone installed it - do you know that it provides a number of reports already defined that can be setup to be run periodically and available on the web - all with the installation of the OEM V9? but it's OEM, i've never managed to get it configured to run other than stand alone. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Anyone who is capable of getting themselves made President should on no account be allowed to do the job. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: unix question
How about something like ...
find /your_dir_name_here -name '*.log' -mtime +4 -exec \ rm {} \;
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Wednesday, November 19, 2003 3:21 PM
To: Multiple recipients of list ORACLE-L
I want to store some files. I make a new copy every night. I want to archive it back 4
days. So after 4 days, I want to delete the old copy. How do I do this?
However, if i miss a nightly batch and have less than 4 copies, I do not want to
delete any?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
**
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
**4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Development vs. Production DBA
Jared writes Being a competent PL/SQL developer is *much* more difficult than it was a few years ago. I can write PL/SQL all day if I can stick with stuff that is 5+ years old. :) A job with an ERP vendor awaits Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: unix question
How about something like dir=foo if [ `ls -1 $dir` -lt 4 ]; then find $dir -mtime +4 | xargs rm fi On Wed, 2003-11-19 at 15:20, [EMAIL PROTECTED] wrote: I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Please give me some good advice in your next letter. I promise not to follow it. -- Edna St. Vincent Millay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Changing character set
There's a whole spread of stuff on MetalLink about changing character sets. There is even a utility program called 'csscan' that scans the DB to find potential trouble spots. In short, though, if this DB only has 7-bit ASCII characters in in, then a switch to UTF-8 will have no immediate effect. Cheers, Mike -Original Message- Sent: Wednesday, November 19, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Anyone change character sets recently? I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it was. It sounds like they have all the steps down pat and are pretty much ready to go, but are there any gotchas they may have missed? Will this affect the RMAN backups they get nightly? I've told them to do a cold file backup first, then try on test, and if all is cool they can proceed... 20 years working with Oracle and this is a first time for me. Web interface on this note, so I hope it comes out okay... -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: unix question
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE
WITH CARE.USE WITH CARE.
COUNT=`ls -lrt dir/name|wc -l`
if [ $COUNT -ge 4 ] ;
then
find dir -name name -mtime +4 -exec rm -f {} \;
fi
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE
WITH CARE.USE WITH CARE.
HTH,
Bambi.
-Original Message-
Sent: Wednesday, November 19, 2003 2:21 PM
To: Multiple recipients of list ORACLE-L
I want to store some files. I make a new copy every night. I want to archive
it back 4 days. So after 4 days, I want to delete the old copy. How do I do
this?
However, if i miss a nightly batch and have less than 4 copies, I do not
want to delete any?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Bellow, Bambi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Any articles/books that take relational theory and make it
Agreed. And I think you'll admit it's better to be familiar with and aware of the theory, even if current db products don't live up to the model 100%, so you know to bring up the kinds of issues you mention in the first place. In that sense, I think the knowledge to be gained from Date, Darwen, Pascal, etc., can be very practical. -- Dan On Wed, 19 Nov 2003, Niall Litchfield wrote: I obviously can't speak for the list, but I find Fabian Pascal to be very interesting, but quite academic. What I *think* that I mean by this is that a lot of what he says seems to make theoretical sense, but I'm unsure how applicable it is to practice. IOW the general feel that I get from Fabian (and indeed Date) is that if something doesn't meet relational theory then it is flawed. This may well be a good default position to have, but I'm unprepared to say to folk who pay my wages 'sorry your data model isn't in 3NF' or 'you shall not use a materialized view'. I *will* quite happily say 'so how will you ensure data integrity?' 'what happens if another program uses the same data' or 'why did you use computed summaries?' Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Hanks Sent: 19 November 2003 16:25 To: Multiple recipients of list ORACLE-L Subject: Re: Any articles/books that take relational theory and make it On Wed, 19 Nov 2003 [EMAIL PROTECTED] wrote: I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. Hrm, I thought a key, by definition, implied a unique constraint... All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. I'm not sure what the opinion on Fabian Pascal is here on the list, but I found his Practical issues in Database Management to be very good. It's subtitled A reference for the thinking practitioner. It's not a textbook, but it does make you use your brain a bit. It might be what you're looking for. It has helped to clarify the relational model for me, but might put some people off as it's critical (without naming specific products) of most current implementations of 'relational' databases. Thanks. -- Dan == == Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division == == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: unix question
The following statement will delete all files older than 5 days:
find . -name 'files_you_want_to_delete*.log' -mtime +5 -exec rm {} \;
To test it, change the name of the file name and change the 'rm' to
'ls'.
It should just list the files older than 5 days. That way you know it
is working.
Ron Smith
-Original Message-
Sent: Wednesday, November 19, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH
CARE.USE WITH CARE.USE WITH CARE.
COUNT=`ls -lrt dir/name|wc -l`
if [ $COUNT -ge 4 ] ;
then
find dir -name name -mtime +4 -exec rm -f {} \;
fi
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH
CARE.USE WITH CARE.USE WITH CARE.
HTH,
Bambi.
-Original Message-
Sent: Wednesday, November 19, 2003 2:21 PM
To: Multiple recipients of list ORACLE-L
I want to store some files. I make a new copy every night. I want to
archive it back 4 days. So after 4 days, I want to delete the old copy.
How do I do this?
However, if i miss a nightly batch and have less than 4 copies, I do not
want to delete any?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Bellow, Bambi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
If you are not the intended recipient of this e-mail message, any use, distribution or
copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this message by
mistake, then delete the e-mail message.
Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: SQL_Trace versus Statspack
Vivek did mention single DB connect process, so this should increase the possibility of statspack matching the trace file Did you have parallel query occurring - as then the single trace wouldn't have caught everything. Are you SURE no other users were active at the same time - eg look at logons cumulative in v$sysstat Were the trace and snapshot for the EXACT same time interval? HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Thursday, 20 November 2003 12:15 AM To: Multiple recipients of list ORACLE-L Vivek, as others have pointed out before, Statspack is instance wide snapshot. Trace file is session specific. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 19, 2003 5:40 AM To: Multiple recipients of list ORACLE-L We are doing Interest processing on a SET of 10,000 Bank A/cs using a Single Database connect process. SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? Qs. Have we possibly missed some SQL trace files? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
_wait_for_sync , dirty buffer flushing and direct reads in parallel query
Hi! I've sometimes used setting _wait_for_sync=false during Apps upgrade projects, to upgrade performance. (As long as your database doesn't crash during the parameter is set to false, no problems should occur). I just started wondering, what would be the case if a parallel query starts during someone is modifying data... As I understand, when doing parallel query: 1) the dirty blocks which are supposed to be read by PQ in direct mode, are flushed to disk 2) PQ reads the blocks in direct mode But when _wait_for_sync is set, the writes get acknowledged immediately (or acknowledgement is not waited for). Could this result in the unlikely situation, that PQ issues the flush command to dirty buffers and starts to read them, but actually reads the old images of the blocks, since it thinks the write has already occurred? (actually, this doesn't touch only PQ, it's possible to have direct reads to PGA in serial mode too...) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OFA and RAC on raw devices
Hi Muqthar , thanks for you reply. Some more precisions : What about the OFA admin subtree (create, pfile, udump,bdump..) ? Did you duplicate it on each node ? What are the steps in Service Guard to configure failover File system ? Do you use RMAN for backups ? if yes with autolocate 9i feature ? If you used soft links for datafiles, it means you have some sort of /oradata/db_name/ structure on each node. Right ? Does this prove helpful ? Regards At 06:05 19/11/2003 -0800, you wrote: Gilles, RAC Configuration: 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. 3. UNDO (RAW FILES) - Each node will have its own UNDO. We have STRIPED RAID1+0 to have good performance. Database is not pointing to RAW FILES directly. I have created SOFT LINKS to point to RAW FILES. I have created TABLESPACE using SOFT LINKS. Muqthar Ahmed -Original Message- Sent: Wednesday, November 19, 2003 1:55 AM To: Multiple recipients of list ORACLE-L Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Any articles/books that take relational theory and make it
As Date is want to say, Theory is practical! (Chapter One, Relational Database Writings 1991-1994). IMHO, a lack of understanding of relational database theory leads directly to database designs so flawed that they can't possibly allow their application to accomplish their goals. If you don't think in terms of functional dependencies, if you don't know the trade-offs in using nulls, if you don't why you want to put some attributes in one entity and others in others, you'll be in trouble. Some people call all of this theory. I see it as the fundamental principles that you'll be dead in the water without. If you don't know what the relational in RDBMS means (nothing to do with foreign keys), you'll make a bunch of mistakes over and over, knowing something is wrong but not able to put your finger on what's wrong. Then you'll limp along with an unfixable application, held together with prayers, and not able to deliver performance or even the right data. I've been doing this for 17 years and I've seen it happen more times than I like to remember. My suggestion, my strong suggestion, is to learn the theory to such an extent that you'll know why a model is good or why it's flawed. If you don't know what a good model is, how can you possibly create one? Data modeling is hard work. There is no shortcut for it. There is also no shortcut for learning it. But you can learn from people who understand it well and can express it well, also. In my opinion, those names include C.J. Date, Hugh Darwen, Fabian Pascal, and a number of others. HTH Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Agreed. And I think you'll admit it's better to be familiar with and aware of the theory, even if current db products don't live up to the model 100%, so you know to bring up the kinds of issues you mention in the first place. In that sense, I think the knowledge to be gained from Date, Darwen, Pascal, etc., can be very practical. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FW: SAN configuration for Banner
Paul, just curious why RAID 01 rather than RAID 10. RAID 10 is much more resistant to disk failures that RAID 01. 10 drives in a RAID 01 with drives having a MTBF of say 100,000 hours. ( don't know if the 100k is low or high ) Each stripe in the RAID 01 has a MTBF of 20k hours, which is 10k hours for the array as a whole. In a RAID 10 each mirrored pair would have an MTBF of 50k hours, which also appears to give an MTBF of 10k hours, but this is where statistics are misleading. Lose one drive on each side of the RAID01 and is down. The RAID 10 could lose 5 up to drives, as long as each failure is only one side of a mirrored pair, and still stay up. Even more beneficial, in the RAID 01 if you lose on drive, you will lose 50% of read throughput. Losing a single drive in the RAID 10 will cost you about 10% throughput. If Matthew Zito is still here, he can no doubt enlighten us with no end of detail on the subject. Jared Paul Drake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/19/2003 12:20 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: FW: SAN configuration for Banner Sam, Dell was perfectly happy to configure the following for me on a CX200 unit: (2 trays of 15 drives, 1 tray 36 GB 15K, 1 tray 73 GB 10K, 1 hot spare per tray) 3 x RAID 1 for online redo logs (members a,b,c, 6 drives total) 2 x RAID 01 for datafiles (8 drives each, 16 drives total) 1 x RAID 1 for archlogs (2 drives) 1 x RAID 01 for undo (4 drives) we used less than half of the available storage, saving that for when another system is migrated to this unit. when creating filesystems, we did not format the entire RAID vols for live files, and created filesystems for storing local backup sets. You will like having datafiles on 8 drive RAID 01 (or RAID 10) volumes. RMAN backups fly like you would not believe. hth. Paul Sam Bootsma [EMAIL PROTECTED] wrote: Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We don't have the SAN yet, but it is due to arrive any week (if not any day). I passed Cary's "Is RAID 5 Really a Bargain?" paper to our Sys Admin, which he read and succinctly summarized for the Technical Manager here. I have also read through a couple of papers referenced in the BAARF site. The Sys Admin comments were: Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Here is the Manager's response: Any suggestions on how I can counter points 4 and 5 and the last point before his "Thanks" line? Currently we have two B80's (AIX 4.3.3) set up in a HA configuration. They share an external disk array. So if a hardware component in the primary box fails, then it will automatically failover to the secondary box (and at the same time, the secondary box takes control of the external disk array). I think the clustering term in point (4) is referring to this setup. Thanks for any suggestions. Sam. Sent: November 18, 2003 5:08 PM Subject: RE: SAN configuration for Banner All the points are valid...however..my thought processes were as follows: 1. The System Core Application disks are resident on the disks within the CPU and Mirrorred (Everyone OK with that I think) 2. The Databases are Resident on the SAN 3. The SAN disks are RAID 5 as the provide more usable space for the cost as compared to mirrorring 4. As the IBM Systems (B80's 6C4's) are clusterd thus effectivley Mirrors the RAID 5 Arrays mitigating the issues Sam raises re preformance degradation (which will only ever arise in the event of a failed disk/automated rebuild which is usually configurable to address performance degradation) 5. Write to Disk/Commit to Database should be a background process (although I recognise this is a transaction/write intensive based system) This is a standard model that all servers are being deployed with and unless there are any specific technical reasons why this will not work it is the way I would like to see the systems implemented. Remeber, with the SAN...Reconfiguration of Disks is not a large issue anymore if required in the future. Although not an AIX/Oracle guy...I disagree with the statement that RAID5 is 3 times more susceptable to incur Data Loss. RAID 5 is a proven technology Thanks. Andrew -Original Message- From: Carl Nowak Sent: Tue 18/11/2003 2:56 PM To: Andrew Riem Subject: SAN configuration for Banner Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has
html output
I am lookingfor autility package for throwing output in html format from a query . This should use utl_file to write the file ( no sqlplus markup ). Is there any package /procedure oracle has to do this job? This is just a html report and it will be sent to users by email. ( this is not a OAS/IAS report ). Thanks -ak
Re: html output
Maybe use HTP, HTF and OWA_UTIL packages? You still need to do some writing in using them. Yong Huang --- AK [EMAIL PROTECTED] wrote: I am looking for a utility package for throwing output in html format from a query . This should use utl_file to write the file ( no sqlplus markup ). Is there any package /procedure oracle has to do this job ? This is just a html report and it will be sent to users by email. ( this is not a OAS/IAS report ). Thanks -ak __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: html output
Have you tried using SET MARKUP HTML SPOOL ON from SQL*plus itself? It creates a neat HTML report and you canplace most of the formatting. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 19, 2003 6:50 PM I am looking for a utility package for throwing output in html format from a query . This should use utl_file to write the file ( no sqlplus markup ). Is there any package /procedure oracle has to do this job ? This is just a html report and it will be sent to users by email. ( this is not a OAS/IAS report ). Thanks -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: html output
sqlplus -M "html on" -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, November 19, 2003 6:50 PMTo: Multiple recipients of list ORACLE-LSubject: html output I am lookingfor autility package for throwing output in html format from a query . This should use utl_file to write the file ( no sqlplus markup ). Is there any package /procedure oracle has to do this job? This is just a html report and it will be sent to users by email. ( this is not a OAS/IAS report ). Thanks -ak
Local connect to database (default connection)
Hello! I have next problem: I've setup Listener and TNS Names and I can connect to database but only when SID is specified. I want to specify default database to connect to. D:\Backup\oraclesqlplus cheques/cheques SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:33:55 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error D:\Backup\oraclesqlplus cheques/[EMAIL PROTECTED] SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:34:56 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production virvitdb - my local DB on my machine. Here tnsnames.ora file: VIRVITDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = virvit)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = virvitdb.prodtorg.udm.net) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) And Listener.ora: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = virvit)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = virvitdb.prodtorg.udm.net) (ORACLE_HOME = D:\oracle\ora92) (SID_NAME = virvitdb) ) ) -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FW: SAN configuration for Banner
Oh well, even though we're not talking about RAID-F anymore, let's break the rule now and then :-). It's funny to see how the technical guys say the correct things, the vendor guy says some rubbish, and the manager guy decides to do as the vendor says. Maybe that sort of interesting decision process always happens when managers have to make decisions about expensive stuff. Maybe there's a law about big amounts. But we should rejoice: We have said the right things, and they didn't listen. We have therefor, without any loss of integrity, created a wonderful area of future work. In these times where companies are looking for RAIA-I and RAIA-C (Redundant Array of Inexpensive Asians - India/China) solutions, anything that creates future performance and availability problems in our home countries should be welcomed. Here's a useless fact: When looking yesterday at Full Disclosure Reports for various tpc-c benchmarks at www.tpc.org, I found that all of them use striping, but of course not RAID-5 (hey, benchmarks are for performance). And they never use a SAN, of course. Nobody wants all the codepath of 8-9 layers of distraction (or was it abstraction) between the OS and the disk plates. Too much overhead, and it's not needed. So I had a chat with a friend of mine who's done real benchmarks. I was commenting on the fact, that for the 1million tpc-c benchmark Oracle did recently, they used 120 73GB disks plus 2100 36GB disks. Microsoft with their 80 tpc-c benchmark only used 1754 disks or so (60 for the log, 2 for the OS, the rest for data). My friend then told me that he always believed that you should never use a SAN for a high-performance system. Always direct attach. When doing benchmarks, though, they would run into the problem that with 1000s of disks attached it could take several hours to boot the system (and you need to do that regularly when doing benchmarks!). So in the benchmark world they're moving into RAID-10 now in order to be able to sustain disk losses (they happen frequently when using 1000s of disks) without having to boot the server. We also discussed availability of standalone versus clustered nodes. I have, based on the discussion, devised the following simple formula: A = (100 - Nc)% where A is Availability and Nc is number of Nodes in a cluster. Consolidations mean future work near you! So let's support SAN's, clusters, database consolidation, and all such things. Let's increase chaos. It's our only chance of survival. Mogens Paul Baumgartel wrote: Oh boy. I'd first challenge the I disagree..RAID 5 is a proven technology. Ask him for credible research and/or statistics that support his position. Sure, RAID 5 is a proven technology...so are floppy disks, and so what? Second: clustered systems with failover mitigate disk array performance considerations? Just how does THAT work? Good luck! Paul --- Sam Bootsma [EMAIL PROTECTED] wrote: Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We don't have the SAN yet, but it is due to arrive any week (if not any day). I passed Cary's Is RAID 5 Really a Bargain? paper to our Sys Admin, which he read and succinctly summarized for the Technical Manager here. I have also read through a couple of papers referenced in the BAARF site. The Sys Admin comments were: Dell would like to know what RAID mode we want configured on the SAN for the B80 and 6C4 computers. Sam has told me that, in the Oracle community, mirroring (RAID1) is preferred over RAID 5 for various reasons (RAID5 is: more costly for write-intensive applications, 3 times more likely to incur data loss, suffers from massive performance degradation during partial outages). RAID1 will be more costly per unit of usable storage. Mirroring seems to be the best choice. Let me know what you think. Here is the Manager's response: Any suggestions on how I can counter points 4 and 5 - and the last point before his Thanks line? Currently we have two B80's (AIX 4.3.3) set up in a HA configuration. They share an external disk array. So if a hardware component in the primary box fails, then it will automatically failover to the secondary box (and at the same time, the secondary box takes control of the external disk array). I think the clustering term in point (4) is referring to this setup. Thanks for any suggestions. Sam. Sent: November 18, 2003 5:08 PM All the points are valid...however..my thought processes were as follows: 1. The System Core Application disks are resident on the disks within the CPU and Mirrorred (Everyone OK with that I think) 2. The Databases are Resident on the SAN 3. The SAN disks are RAID 5 as the provide more usable space for the cost as compared to mirrorring 4. As the IBM Systems (B80's 6C4's) are clusterd thus effectivley Mirrors the RAID 5 Arrays mitigating the issues Sam raises re preformance degradation
RE: Local connect to database (default connection)
VirVit, Looks to me like ORACLE_SID isn't specified in your windows environment. Check the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 for a string key called ORACLE_SID. If it's there, set it to your SID. If it's not, add it and set it to your SID. Alternatively, set an environment variable named ORACLE_SID to your desired SID. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -Original Message- From: VirVit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 November 2003 15:40 To: Multiple recipients of list ORACLE-L Subject: Local connect to database (default connection) Hello! I have next problem: I've setup Listener and TNS Names and I can connect to database but only when SID is specified. I want to specify default database to connect to. D:\Backup\oraclesqlplus cheques/cheques SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:33:55 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error D:\Backup\oraclesqlplus cheques/[EMAIL PROTECTED] SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:34:56 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
