RE: redo size and log_checkpoint_interval
Mitchell, if ur current Log_checkpoint_interval is 2097152 (20 mb) then is ur os block size = 20 mb/2097152 = 10 bytes? look like is ur want to say that Log_checkpoint_interval = 20971520 but Log_checkpoint_interval shld be set ito OS blocks. so if u want to set to 20 mb then assuming ur os block size is 512 bytes then Log_checkpoint_interval = 40960 Assume this is set to 40960. Oracle continually calculates the address of the redo record that was written 40960 records (OS blocks) ago. In order to satisfy this parameter, the checkpoint position must advance at least as far as this redo record. Should the checkpoint position point to a redo record written earlier than this target position (written over 40960 records before the record at the end of the log), Oracle writes dirty buffers and advances the checkpoint until it points at a redo record written less than 40960 records ago. Should the checkpoint position point to a redo record newer than this target position (written less than 40960 records ago), Oracle does nothing to satisfy this target for it is already satisfied. -Mandar -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Subject: redo size and log_checkpoint_interval Dear DBA I have 130 gb database running on 7/24 basis. redo logfile size is 40mb and oracle create about most to 400 archivive log. that mean log switch happend at 3-4 min at peak time. As oracle suggest, it is better log switch between 30min. (Why, if so that need more recovery time?) If I will increase the size to 100mb and make time around 30 min. How about Log_checkpooint_interval. My currently setting is 2097152 (20mb). log_checkpoint_timeout = 0 As my understand, the interval based on volume. If setting is 100mb, mean 5 check point will occured at 20mb interval. I am right? Any suggest? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TRUTH and versioning
I came to know today THE TRUTH. i didnt knew it bfore :-) Oracle APPS do not use Primary Key and Foreign Key constraints. They use not null and unique indexes for primary key type columns. Also they do not keep database triggers. All the integrity is maintained thru application. The PK,FK and triggers are not kept cos of performance reasons. I am fighting with my client which wants to implement versioning for each row and across relationship. so if a dept attribute changes a new row shld be created and all dependents shld be somehow made aware of the change. Also if an employee attribute changes, a new employee version to be maintained while keeping the relationship with the dept. The only solution coming to my mind is keeping a surrogate key for every table. Guys do ull hv any IMPLEMENTED WORKING solution? i can see my weekend:( -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Birthday List !!
Happy Birthday List. I hv got more confidence by reading and answering mails on this list, than asking friends or reading manuals. Thanks to all those guys who maintain this list. -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle's pricing
so much of venting goin around here Why dont we folks (who get their paychecks for hving oracle db skills) instead of praising/*#@^ Oracle for its pricing start sending CC's for each pricing rant mail to larry/oracle marketing/oracle sales. Or write an open letter to larry. something to vent our frustration in a productive way. -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Steve- Sub-optimal RBS query
Hello Guys, i hv been trying to tune our RBS. i was using Steve's query http://www.ixora.com.au/scripts/sql/sub_optimal.sql to calculate the optimal size. on the page http://www.ixora.com.au/scripts/rbs.htm it says This script suggests raising the OPTIMAL setting if rollback segments of that size have been shrinking more than once per reuse cycle, and have shrunk at least twice. What does he mean by reuse cycle? Also if i comment a line from the query it shows some output, otherwise no rows are returned. where s.shrinks 1 and -- s.shrinks s.wraps / ceil(s.optsize / ((s.rssize + p.value) / s.extents)) and r.optsize = s.optsize and r.status = 'ONLINE' and n.usn = r.usn can someone(Steve/?) xplain me what is the significance of the comment line Thanks Mandar the query is *** select n.name, s.optsize, ( ceil(s.extents * (s.optsize + s.aveshrink)/(s.rssize + p.value)) * (s.rssize + p.value) / s.extents ) - p.value new_opt from ( select optsize, avg(rssize) rssize, avg(extents)extents, max(wraps) wraps, max(shrinks)shrinks, avg(aveshrink) aveshrink from sys.v_$rollstat where optsize is not null and status = 'ONLINE' group by optsize ) s, ( select kvisval value from sys.x_$kvis where kvistag = 'kcbbkl' ) p, sys.v_$rollstat r, sys.v_$rollname n where s.shrinks 1 and s.shrinks s.wraps / ceil(s.optsize / ((s.rssize + p.value) / s.extents)) and r.optsize = s.optsize and r.status = 'ONLINE' and n.usn = r.usn * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Large Redo Logs
Guys, i was checking my statspack report on oraperf and i came across this statement. "Never split index and data files to different sets of disks." can anyone xplain the logic behind this. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Statspack statement - Never split index???
Guys, Sorry wrong subject before. i was checking my statspack report on oraperf and i came across this statement. "Never split index and data files to different sets of disks." can anyone xplain the logic behind this. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Entity Relationship diagrams Qdesigner using same engine as P
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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NOT A SINGLE MAIL!
E-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to store orace errors in database (UNIX scripting challen
Ok guys, spent my weekend on learning sed. heres what i hv cooked up, just for fun a shell script to get all ora errors into a SDF format, which can be uploaded into a table using sql*loader. issues faced and asking for answers * how to insert a new-line. so broke the sed into next line to insert the new line char. * typeset was not working with /bin/ksh (maybe not ksh93), so used /usr/dt/bin/dtksh * how to install ksh93 on release 5.7 ? * what are the licensing issues related to installing ksh93 * why dont i hv ksh93? why why why? :) * its very slw script starts here #/usr/dt/bin/dtksh tmpfile=/tmp/err$$ #temporary file errfile=err.dat #error data file typeset -Z5 count #fixed width var count=1 typeset -L256 errm errcause erraction #fixed width var while [ count -ne 20001 ] do var=`oerr ora $count` if [ -n "$var" ] then echo $var | sed 's/\/\/ \*Cause: /\ /;s/\/\/ \*Action:/\ /;s/ \/\/ / /g' $tmpfile #remove "*Cause" "*Action" "//" and add newline instead errm=`sed -n 1p $tmpfile` errcause=`sed -n 2p $tmpfile` erraction=`sed -n 3p $tmpfile` echo "$errm""$errcause""$erraction" $errfile fi count=`expr $count + 1` done secript ends here is there any oracle site where i can dump this script for everybody's use? -Mandar Reply Separator Author: "kaushikdas" [EMAIL PROTECTED] Date: 3/21/2001 11:35 PM Hello I am Kaushik Das from india .I am new to your group. I had a query ,i hope some one will reply to this mail. Just like we can store help of sql commands in HELP table in oracle database.In a semilar way can we store ORACLE errors in database for example to see oracle error in unix we write oerr ora 1)what command should we write in nt to see the complete info of this error. 2) How to store and retrive complete oracle error messages in oracle database. 3) is there any sql file which dba should run to create such table and toad data. Thanks in advance. regards kaushik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NT Server very slow
cant find it -Original Message- From: Jerry C [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: NT Server very slow check out Doc ID 941798 at Metalink... - Original Message - To: [EMAIL PROTECTED] Sent: Friday, March 23, 2001 3:36 PM There is a bug with some version of Oracle (I believe it was 8.1.6.0.0, but don't quote me on that), where even with NO users, oracle.exe would eventually consume your whole CPU. The CPU utilization ramps up after a db restart until it gets to 99 or 100. Open Task Manager and check the oracle.exe process. I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure. Good luck! - Jerry - Original Message - From: "Jim Walski" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 12:17 PM Subject: Re: NT Server very slow Since you mention there are only a few users, I would take a look at the jobs these users are running. Maybe one of these users is firing off a poorly tuned job that brings the database to a grinding halt. Is the database the only product on the Server? Or are there other applications ( email server, web server...) Jim -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Friday, March 23, 2001 7:50 AM I have an Oracle 8.1.6 instance on an NT Server. The application has only a few users. Very often throughout the day it seems response time drops to about 20 seconds. By the time I log on to look at the problem everything is back to normal. If I do a simple query the result is returned immediately. I have looked at SQL through Quest's SQLAB and there is nothing that stand out. The hit ratio averages between 88% and 92%. Is there a good way to diagnose this type of problem? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single Code Table or Separate Code tables dilemma
CREATE TABLE I_DONT_LIKE_MASTER ( CODE_TYPE VARCHAR2(4) NOT NULL, CODE_VALUE VARCHAR2(3) NOT NULL, CODE_DESC VARCHAR2(20) , PRIMARY KEY (CODE_TYPE, CODE_VALUE) ) SPLTN SDFLJDSL SPLTFP SDFSDKFDS SPLTOBG SFLSDJFSD TYPEMD SDFLSDFSDF TYPEFP SDFJDSFJ TYPEOPH SDLFJDSKF CREATE TABLE DOCTOR (., SPECIALITY_CODE_TYPEVARCHAR2(4), SPECIALITY_CODE_VALUE VARCHAR2(3), TYPE_CODE_TYPE VARCHAR2(4), TYPE_CODE_VALUE VARCHAR2(3), ., foreign key (SPECIALITY_CODE_TYPE,SPECIALITY_CODE_VALUE) references I_DONT_LIKE_MASTER, foreign key (TYPE_CODE_TYPE, TYPE_CODE_VALUE ) references I_DONT_LIKE_MASTER ) D1 SPLTN TYPEOPH D2 SPLT N TYPEMD but u can also create surrogate key and make (CODE_TYPE, CODE_VALUE) as alternate key (unique) and then reference the surrogate key in ur doctor table, instead of two cols as one foreign key -MANDAR -Original Message- Sent: Friday, March 23, 2001 7:31 PM To: Multiple recipients of list ORACLE-L I'm still not quite sure I understand the "single code table" business. Let me give an example (taken from a live example at one of my previous jobs). I have a table called DOCTOR that has two fields - SPECIALTY and TYPE. The acceptable values for SPECIALTY are N, FP, OBG, etc... The acceptable values for TYPE are MD, FP, OPH, etc... If I have a "single code table", how can I create a Foreign key constraint on the SPECIALTY column and another one on the TYPE column? -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to store orace errors in database (UNIX scripting challen
Guys how about creating a shell script #/bin/ksh count=1 while [ $count -ne 10 ] do oerr ora $count count="$(($count + 1))" done 00088, 0, "command cannot be executed by MTS server " // *Cause: Debug command issued on MTS server. // *Action: Reissue the command using a dedicated server. 00089, 0, "invalid instance number in ORADEBUG command " // *Cause: An invalid instance number was specified in an OPS ORADEBUG // command. // *Action: Reissue the command with valid instance numbers. the output needs to be parsed and stored into a table. UNIX shell scripting masters can give me some hints how i can use maybe sed or awk to break each error output into three variables step1. first line till line before "*Cause" into first variable "error_message" step2. line containing "*Cause" onwards till line before "*Action" into second variable "error_cause" step3. line containing "*Action" onwards till end any hints to start the work would be appreciated. now no RTFM pls..:) -Mandar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Subject: Re:how to store orace errors in database Kaushik, There is nothing that I know of that does a help_table for error messages. One can use the selerrm function to return the text of any error although it does not send back the reason why nor the corrective action. I'm not sure about NT and oerr. I haven't found it yet there, but then I don't use NT as a db server platform. Dick Goulet Reply Separator Author: "kaushikdas" [EMAIL PROTECTED] Date: 3/21/2001 11:35 PM Hello I am Kaushik Das from india .I am new to your group. I had a query ,i hope some one will reply to this mail. Just like we can store help of sql commands in HELP table in oracle database.In a semilar way can we store ORACLE errors in database for example to see oracle error in unix we write oerr ora 1)what command should we write in nt to see the complete info of this error. 2) How to store and retrive complete oracle error messages in oracle database. 3) is there any sql file which dba should run to create such table and toad data. Thanks in advance. regards kaushik -- - IFFCO's Website Address - www.iffco.nic.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kaushikdas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single Code Table or Separate Code tables dilemma
-Original Message- From: Michael Netrusov [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: Single Code Table or Separate Code tables dilemma Referential integrity is still present if you create Master lookup table with type attribute This requires a "composite referential integrity constraint" such as: alter table tname add constraint fk_whatever foreign key (extra_column_for_code_table_key, column_i_really_care_about) references master_codes(lookup_id, lookup_type); Still don't like it. Maybe it's just a preference thing... What's wrong with a composite foreign key constaint? Works for me all the time.. As a duhveloper wont u like to pass one argument to a procedure rather than two? granular control over the individual code table You DON'T have granular control for caching specific tables because everything is mixed together. (Hawaiian pidgin translation: "All kalikaka li' dat. Da' kine chop suey. Easy Brah." :) No control for different indexing requirements or not even having an index for small tables where it would be better to do a FTS. I DO. Nothing is mixed - you can even partition this table if you prefer to keep unlike data in different places. so u will create one single table and then partition it. do u think partitioning is cheap from maintenance point? prefer to have multiple numerous small tables or one large? Numerous small tables are not a problem, actually a benefit because you have more granular control for tuning. I once had the misfortune of having to do reports where the "mother of all code tables" had around 100,000 rows. (It was a big, dumb 3rd party app with roots in COBOL and it had a lot of unmaintained junk in it). To pick up a description in a large multi-table join query I had to join against the mother of all code tables where a small 10 row table would have sufficed. I don't think a join to 100K rows table versus a join to 10 rows table would make a big difference.. Most likely the join was slow was it? ) because of some other factors. u dont mind searching 10 starbuck's shops to find one cup of coffee? also u dont mind releasing 10 different versions of ur programs to ur client and then let the client search thru them for the best one. I'm not exactly a relational purist and for some apps code tables may work just fine. But usually it's just for duhveloper convenience (laziness) and why make life easy for them ;-) at the expense of "normal" relational design. Especially if they haven't bothered to answer the challenge I posed below? When I was a developer I had a set of objected oriented class libraries and could bang out a new window for a lookup table in 60 seconds. Of course I probably spent 600 hours developing and maintaining my libraries... sigh. Oh yeah, developer designed tables containing metadata come in handy also. Do developers design ER models in your shop? It should be you or a DA. :-) Duhveloper combat is so much fun! :-) Unfortunately they usually outnumber us DBA's so we have to be particularly nimble. ;-) In my current shop I am a pl/sql developer :-) ... as well as a DA and a DBA. This saves me a LOT time and nerves. so whose is the PM and client? I taste blood :) Har Har Mahadev ... Thats a Battle Cry :-) Regards, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Warehouse Builder (OWB)
check out DataJunction also. -Original Message- From: Majumdar, Uttam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Warehouse Builder (OWB) OWB is relatively new in the ETL market. We did use OWB, ACTAWORKS and INFORMATICA in our enterprise. We are sticking with INFORMATICA because of its flexibility to integrate data from different oracle/non-oracle databases and ERPs. regards: Uttam Majumdar -Original Message- Sent: Thursday, March 22, 2001 4:06 PM To: Multiple recipients of list ORACLE-L Hi, Have installed OWB 2.1 on NT workstation(128 MB RAM) and is connected to a small database (8.1.6) with 35MB SGA. There is no other activity going on against this database. OWB takes a long time to come up and is very slow afterwards. Is anyone using this tool and if so what is the configuration of your machine? Also please let me know your thoughts about this tool. TIA Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). PGE National Energy Group and any other company referenced herein that uses the PGE name or logo are not the same company as Pacific Gas and Electric Company, the regulated California utility. Neither PGE National Energy Group nor these other referenced companies are regulated by the California Public Utilities Commission. Customers of Pacific Gas and Electric Company do not have to buy products from these companies in order to continue to receive quality regulated services from the utility. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Majumdar, Uttam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS_REPAIR package usage
ay also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single Code Table or Separate Code tables dilemma
at last i convinced my duhvelopers to go for individual tables. -Original Message- From: Steve Orr [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 5:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Single Code Table or Separate Code tables dilemma Regarding "lookup" or validation tables and more complex "rules" tables... do they ALL go into your master code table? For instance, what about a "code table" for all valid U.S. zip codes? Do they go into your master code table? we r in the process for defining country---state/province---city and airports tables. there would be another 30-40 masters and all in different tables :-) sweet smell of victory State abbreviations too? What about valid city/state/zip code combinations which you can get from the U.S.P.O.? At what point are validation/lookup/rules data not in the master code table and how do you decide? i blive every logical entity should hv its seperate physical presence. but then every solution is an "Engineering Compromise". So i wont mind some give and take. but its fun to have an occasional fight with a duhveloper. The code table technique may be fine for smaller apps but couldn't it become unwieldy for larger apps with 5000+ tables? Of which 1-3000 would be "lookup/validation tables?" Do Oracle ERP or SAP ERP apps do this? Curious. check out PSAPOOLD tablespace in http://www.oreilly.com/catalog/sapadm/chapter/ch01.html#18406 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: identifying shared memory segments
David, this is what i am getting. any ideas? $ sysresv ld.so.1: sysresv: fatal: libclntsh.so.8.0: open failed: No such file or directory Killed $ -Mandar -Original Message- From: Lord David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 11:03 AM To: Multiple recipients of list ORACLE-L Subject: RE: identifying shared memory segments Under unix (Solaris at least): set your oracle environment and run $ORACLE_HOME/bin/sysresv. No idea about windoze. HTH David Lord -Original Message- Sent: 21 March 2001 16:02 To: Multiple recipients of list ORACLE-L Me too! Thanks,Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:00 AM A while back someone posted a method for determining which shared memory segments belonged to an instance. Can someone repost that and CC me? Thanks. - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: multiple instance
Nihar, 1. create new entries in the /etc/oratab and listener.ora files for your new instance, setup environment variables for the new instance : ORACLE_SID should be set to the new instance name, ORACLE_HOME to your existing Oracle home dir. 2. Then just create the new database with these new settings. u can use $ORACLE_HOME/bin/dbassist to create the shell scripts and then run them manually good luck keep the list posted with ur results -Mandar p.s. do u really use biometric access in ur company??? -Original Message- From: Nihar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 12:59 PM To: Multiple recipients of list ORACLE-L Subject: multiple instance hi folks how to create multiple oracle 8 instances on solaris. regards - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Conversion of man (unix) into Txt file-Gogala
looks like this list is turning out to be a "ANSWER FOR ALL LIST" btw neena try opening a text file in Windoze MS Word -Mandar -Original Message- From: chandan [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 5:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Conversion of man (unix) into Txt file-Gogala Hi Gogala, , Word documents will also do. Tell me how to convert the man pages to word documents ? -- neena "Gogala, Mladen" wrote: You can't. Unix people can not be converted into text files, only word documents or excell spreadsheets. As for the Unix manual pages, try with man |ul -t dumb/tmp/textfile.txt -Original Message- Sent: Sunday, March 18, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Hi All, Does anyone know how to convert unix MAN into a text file ? -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chandan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chandan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Audit statement
SELECT user_name, timestamp, obj_name,action_name FROM dba_audit_trail ORDER BY user_name; action_name would give u the statement dba_audit_trail is a view made up of aud$ and few other tables. -Mandar -Original Message- From: Aldi Barco [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 4:50 PM To: Multiple recipients of list ORACLE-L Subject: Audit statement Hi Fellows, I would like to know who changed (DML statement) a record. (for example I wanti to know who changed the salary of Blake in emp table, not just who changed the salary in emp table). So, I want to audit : what statements were executed and by who. I have set 'audit_trail=db' in init.ora. I can find 'by who' from 'terminal' field in aud$ table. Where I can find 'what statements' ? Thanks in advance. Aldi __ ___ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FK Constraints
I'm a beginner too, but without a table FK (relation) how you make a join statements ? Do you normalize your tables ? since when do u require FK's to make a join? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby db license for 8.1.6
Hi Dennis, In my previous job as a dba in a dot com, it was found db2 to be more attractive in terms of price/features. are u including database clients software, hardware for the database server and backup infrastructure for the concerned databases would be glad to receive ur summary. -Mandar -Original Message- From: Dennis Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Standby db license for 8.1.6 I'm in the process of doing comparitive pricing betwwen oracle, sqlserver, and db2. Unless someone objects, I'll give a general summary once the info is in. At 09:35 AM 3/9/01 -0800, you wrote: You can open a standby database in read-only mode now. How are you going to prove that you are not using it. Don't get me wrong, I don't agree with Oracle licensing but the argument is off. -Original Message- Sent: Friday, March 09, 2001 7:47 AM To: Multiple recipients of list ORACLE-L Yup, they want you to pay for it, because it is an additional x number of processors. They don't care that it's not really "on" or being accessed. At filefrenzy, this policy actually led us to turn off a few of our processors. ;-) Diana -Original Message- Sent: Friday, March 09, 2001 9:55 AM To: Multiple recipients of list ORACLE-L If we put together a standby db (SUN 4500) is Oracle going to want more license money? Our thinking is, the license(s) we already own on the production server (also a 4500) cover us to keep the standby db going. We will not use the stand-by server for anything else. There will be no user access at all. Our (hungry?) Oracle rep is telling us that this is a clear case of "multiply by existing license(s) by 2", doubling our license costs. (Let's ignore all of the issues of power unit, named users, etc. for this conversation.) What has your experience been on this license issue for a standby db? Thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy, II INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Dennis Taylor Hindsight is always 20-20. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S
RE: Oracle Compiler Bug? (+) symbol in Decode Allowed?
Hey Sam, Dont take it so seriously. Ur "Lead Developer" is just testing ur patience. -Mandar -Original Message- From: Sam Bootsma [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 2:22 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Compiler Bug? (+) symbol in Decode Allowed? I am running Oracle 8.1.6 on Windows NT. The query below to create a view compiles on Oracle 8.1.6.1.0, but not on 8.1.6.3.0. If I remove the (+) from within the decode statement, it compiles in 8.1.6.3.0. Our lead developer insists it is valid and he also insists the query gives different results when the (+) sign in the decode is removed. I have not confirmed this. According to my understanding of outer joins (and from what I have seen in the documentation) the (+) in the decode is invalid syntax. Can somebody confirm this for me? Here is the view in question: CREATE OR REPLACE VIEW RULE$TYPE (ruletype, caption, genlevel, defaultval, exposetype, switch, override) AS SELECT A.*,DECODE(B.RULETYPE(+),NULL,'G','M') FROM RULETYPE A, RULETYPE_OVERRIDE B WHERE B.RULETYPE(+)=A.RULETYPE And here is an excerpt from the documentation: Outer Joins An outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and those rows from one table for which no rows from the other satisfy the join condition. Such rows are not returned by a simple join. To write a query that performs an outer join of tables A and B and returns all rows from A, apply the outer join operator (+) to all columns of B in the join condition. For all rows in A that have no matching rows in B, Oracle returns NULL for any select list expressions containing columns of B. See the syntax for an outer join in "SELECT and Subqueries" ch4l2.htm ch4l2.htm. Outer join queries are subject to the following rules and restrictions: * The (+) operator can appear only in the WHERE clause or, in the context of left-correlation (that is, when specifying the TABLE clause) in the FROM clause, and can be applied only to a column of a table or view. Thanks for any input... Sam Bootsma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ODBC version errors
Title: OT: ODBC version errors Lisa, Dont ever use Oracle 8/8i drivers. I had a pretty bad experience with them. I was called at a clients place to check their web app. they were using silk test to check the load performance against SQL Server 7 and Oracle 8i. when connected to SQL Server the app was reporting an avg response of 1.5 secs, whereas with Oracle it was around 17 secs. After checking it was found that the Oracle odbc driver was the culprit. after switching to MS provided Oracle driver, Oracle performance was a beau. I have all the statspack reports before and after the driver switch -Mandar -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 07, 2001 3:11 PMTo: Multiple recipients of list ORACLE-LSubject: OT: ODBC version errors Hi everyone - I have several developers telling me that their web applications (some are purchased packages and some are developed in-house) do not work with Oracle ODBC drivers if they are version 8. Every one of their applications seems to run fine with the 7.3.4 ODBC drivers. They get a variety of errors - some get odd messages when they try to login, others get Dr. Watson errors when there are more than x number of users connecting. Does anyone know of existing problems (or fixes) related to the 8 (both 8.0 and 8.1) drivers? or, can you point me to any documents / sites / user groups that could better answer my question? Thanks very much - Lisa
RE: guidance for career in US as D.B.A.
Hi neena Hi All , I am in India . I am an OCP DBA (8i) having three years IT experience ( Oracle( 7.3, 8 ) and Developer2000 , OS - windows NT).Three months back I have joined one of the known company of India. The role of mine in the present job is of DBA. I have to handle two Oracle 7.3 databases on AIX of an application which is stable since last five years. As the application is stable I am not getting good / challenging exposure to DBA activities. First imp thing is that u always be in this situation. once the app becomes stable u will always find urself idle. 1. Design a Disaster Recovery plan doc for ur db 2. Write db health check routines 3. research and find out how fatal bugs in 7.3 can stop ur production site 4. find out what wld stop (techincally) from migrating to 8i 5. learn AIX My aim is to go to US . Can you guide me : Well the green paper is always yummy... 1.. How to get the list of good firms in US , to apply for a DBA post ? www.dbajobs.com www.dice.com 2. Shall I change my present job , just because the database is of older version ( which I was not knowing while joining ) ? change ur job if u dont hv work. not the question of version. its the question of what u know in that version. remember versions will keep on coming. by the time u come to US and settle here, it may be 9i, who knows. there r many gurus on this list who r masters in 7.x, cos that what their job demanded. i met a guy in LA who had worked for NASA and had been working on almost all types of unixes and oracle 7, was a dba, but hardly knew any features of 8i. well he didnt found a need to keep up to date. 3. Will certification of Sun Solaris System Administration be helpful to me? learning an OS never harms. it wld certainly add to ur resume. 4. Will an Advanced DBA course ( Oracle parallel server, Replication, distributed DB) be helpful to me ? where will u apply that? well u can always learn everything, but try to balance it against ur job requirements and in which sector of Oracle admin u want to excel. For a start why dont u try getting ur OCP in 8i. -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script for heaven
select * from dict_comments -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 8:26 PM To: Multiple recipients of list ORACLE-L Subject: Script for heaven Hi guys, I'm new in Oracle8i for Solaris 2.7, I'm not familiar with those data dictionary view, do you have any scripts to share such as to display redologs, tablespaces, earlier potential problems ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Old INACTIVE and KILLED sessions
Henry, set the following parameter in the sqlnet.ora on the server and not on the client. the unit is minutes. 10 mins shld be enuf. test with ur environment. if set less then maybe it may hv an impact on SQL*Net performance. SQLNET.EXPIRE_TIME= 10 -Mandar -Original Message- From: "HENRY, Benot" [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject: Old INACTIVE and KILLED sessions Hi there, I'm new to Oracle, coming from (gulp!) Informix. I hope to find on this newsgroup a great help from you. (it was the case in the Informix newsgroup ;-))) We are in the developing phase, and during tests, our front-end application crashes often and our server application who access the database still alive. They are remaining INACTIVE and KILLED processes in Oracle. These eat a lot of memory (Oracle 8.0.5 on Windows NT4). I would like to find a init parameter (like transaction time-out=24*60), or a system procedure to disconnect automaticaly the user sessions older than 24 hours, and free all the ressources. Can someone help me, or give some ideas or tips to manage this ? Thanks in advance Ben. select substr(sid,1,5) sid,status,process,type, substr(logon_time,1,12) logon_time from dba_v$session order by status,logon_time; SID STATUS PROCESS TYPE LOGON_TIM = = == = 1 ACTIVE 00123 BACKGROUND 02-MAR-01 2 ACTIVE 00124 BACKGROUND 02-MAR-01 3 ACTIVE 00125 BACKGROUND 02-MAR-01 4 ACTIVE 00126 BACKGROUND 02-MAR-01 5 ACTIVE 00127 BACKGROUND 02-MAR-01 6 ACTIVE 00128 BACKGROUND 02-MAR-01 37ACTIVE 358:396 USER 05-MAR-01 10INACTIVE 160:250 USER 02-MAR-01 22INACTIVE 132:361 USER 02-MAR-01 24INACTIVE 353:352 USER 02-MAR-01 23INACTIVE 351:349 USER 02-MAR-01 34INACTIVE 409:402 USER 02-MAR-01 33INACTIVE 409:402 USER 02-MAR-01 32INACTIVE 386:385 USER 02-MAR-01 31INACTIVE 305:309 USER 02-MAR-01 30INACTIVE 386:385 USER 02-MAR-01 29INACTIVE 372:344 USER 02-MAR-01 27INACTIVE 369:368 USER 02-MAR-01 26INACTIVE 353:352 USER 02-MAR-01 25INACTIVE 369:368 USER 02-MAR-01 21INACTIVE 364:348 USER 02-MAR-01 17INACTIVE 337:336 USER 02-MAR-01 18INACTIVE 372:344 USER 02-MAR-01 20INACTIVE 132:361 USER 02-MAR-01 19INACTIVE 305:309 USER 02-MAR-01 16INACTIVE 322:329 USER 02-MAR-01 35INACTIVE 358:396 USER 05-MAR-01 7 KILLED 351:349 USER 02-MAR-01 15KILLED 303:319 USER 02-MAR-01 8 KILLED 321:318 USER 02-MAR-01 12KILLED 322:329 USER 02-MAR-01 13KILLED 337:336 USER 02-MAR-01 14KILLED 321:318 USER 02-MAR-01 11KILLED 303:319 USER 02-MAR-01 9 KILLED 364:348 USER 02-MAR-01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?=22HENRY=2C_Beno=EEt=22?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Init properties
did u checked sys.v$resource_limit ? next question to myself do i need to check sys.v$resource_limit ? -Mandar -Original Message- Sent: Friday, February 16, 2001 3:45 PM To: Multiple recipients of list ORACLE-L I am trying to up the processes parameter, but it is complaining that I am at a resource limit. Is that due to other parameters - like shared memory or something? any help would be cool. thanks adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adam Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
