RE: changing the datbase server name and IP number
You may also need to indclude sqlnet.ora as well. -Original Message- Sent: Friday, March 23, 2001 06:41 To: Multiple recipients of list ORACLE-L As long as you are keeping the DB_NAME's the same you should be able to get by with changing the listener.ora and tnsnames.ora files. You will also need to change your global tnsnames or Onames server references to these db's. On Friday 23 March 2001 11:30, you wrote: We are setting up a new database server. It's HP-UX 11.0. Oracle 7.3.4 (I know, we need to upgrade !) has already been installed and configured on it. Databases have been built and are in use for testing. In a couple of weeks, we'll be exporting the production database from our old server and importing it to the new machine. Sometime during this process, we'd like to rename the new machine to have the same name as our old production server. At the same time, the IP number will be changed. The goal is to make the new production machine have the same name and IP number as the old production machine. Since Oracle has already been installed on the new server, and it already has test databases on it, what will need to change Oracle-wise when the host machine name and IP number change ? Thanks for any information you can share! Judy Hazeley Millersville University Millersville, PA [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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).
Re: Best Practice ?
Hi ! It all depends on your OPTIMIZER_MODE. I guess you will be using CHOOSE and if that is the case I would recommend analyzing the tables indexes (or ANALYZE_SCHEMA) for + or - 10 % change. - Original Message - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 5:48 PM For Analyze of Tables on a Oracle 817 Database on Cluster with OPS ? Should the Tables be Analyzed OR Not ? This is a Application with More OLTP than Batch ( Banking Product ) Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com _ 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: K Gopalakrishnan 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: Connect internal password ?
Associate that second user to the 'dba' unix group. - Original Message - To: 'lzDBA' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 4:06 PM Hi guys, (WITH SOLARIS 7 and ORACLE 8.1.6) After I create a new user that can access SVRMGRL and with user .profile updated, this user cannot connect internal - SVRMGRL ask for password, the most strange is that when I create my second user there is no such problem (first one is the DBA for oracle installation). There is no proble with the .profile because I do "copyt and paste" I heard that orapwd able to solve this problem, what is the file for ? and is that all other users have that kind of file and where Oracle store it ? Thank you for your time, Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com _ 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: K Gopalakrishnan 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: Connect internal password ?
I try to restrict other user from accessing other than sqlplus, by creating new group for them and inside my /appl/Oracle8i/bin/bla bla bla rwxrw- so i can not mix those with dba group do you have any sugestion? -Original Message- Sent: Monday, 26 March 2001 6:57 PM To: [EMAIL PROTECTED]; 'lzDBA'; [EMAIL PROTECTED] Associate that second user to the 'dba' unix group. - Original Message - To: 'lzDBA' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 4:06 PM Hi guys, (WITH SOLARIS 7 and ORACLE 8.1.6) After I create a new user that can access SVRMGRL and with user .profile updated, this user cannot connect internal - SVRMGRL ask for password, the most strange is that when I create my second user there is no such problem (first one is the DBA for oracle installation). There is no proble with the .profile because I do "copyt and paste" I heard that orapwd able to solve this problem, what is the file for ? and is that all other users have that kind of file and where Oracle store it ? Thank you for your time, Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com _ 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: Sinardy Xing 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: Unix question
For single character replacement (or removal) use "tr". For string to string replacement use sed. echo $var | tr "e" "o" -or- echo $var | sed "s/e/o/g"# (the '/g' means globally) Mandar Ghosalkar [EMAIL PROTECTED] wrote: check this question from korn faq at http://www.kornshell.com/doc/faq.html Q24. How do I do global substitutions on the contents of shell variables?A24. Use // instead of / for global substitution, ${var//aa/bb} willexpand to the value of with each "aa" replace by "bb". so i tried $ var=tester$ echo $vartester$ echo ${var//e/o}bad substitution$ anyone out there :) -Mandar -Original Message-From: Big Planet [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 7:56 PMTo: Multiple recipients of list ORACLE-LSubject: Unix question Hi geeks , How can I do substr and instr kind of operaion in unix shell script . is it possible ? like i have one paramter as "hostname" .. I want to trim quotes surrounding the hostname . One more question , is possible to read another text file line by line using a shel script and then edit that file . Actually I have this configuration file for my system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace with actual values at the time of installation by asking questions to the user. TIA --Big planet Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
Re: changing internal password
You use the orapwd utility to change the remote internal password on unix. The default file name is $ORACLE_HOME/dbs/orapw$ORACLE_SID. Also, when you log in as internal locally, you don't need a password as long as the id you log in with is part of the dba unix group. Nihar [EMAIL PROTECTED] wrote: hi pplcan any body help in changing internal pwd on solaris system. i couldn'tfind oradim on sun. Is there any similar tools like oradim on solaris..thanks- NIHAR SANGHVINetMagic Solutions Pvt. Ltd.22,Nirlon Complex,Western Express Highway,Goregaon (E), Mumabai 400 063Phone: 8723003 extn: 144www.netmagicsolutions.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: NiharINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY! ! , include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
Help...Rollback Segmenst Grow?
Gurus 1) I am doing some data movement involving a table creation based on another table create table userid.pm_stage_lg_arch tablespace user_data as select *from userid.pm_stage_lg where entry_timestamp= to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS'); This creates a table with 1,000,000 rows and grows my tablespace by 360 MB... 2) I then want to delete the rows from the original table based on the same date range. delete from nuserid.pm_stage_lg where entry_timestamp = to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS'); The problem is that when I issue this statement which deletes 1,000,000 rows my rollback segments understandably grow by 600 MB... 1) Can I issue this statement without growing the rollback segments? (no recover?) 2) Can I actually shrink the size of the rollback segments after backing up the database? 3) As you see in the statement I am basing my select on the date which I need to be exact...Is there a way I could do it as select sysdate-45 from dual and have it returned in teh same format as 'DD-MON-YY HH24:MI:SS' ??? I have been trying this for a while and cant get it.. Thanks for the help. This is a DB that is limited in Hard drive space so I need to conserve.. Scott Hahn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Hahn 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:
Read the documentation on the 'orapwd' utility. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Nihar [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 4:41 AM To: Multiple recipients of list ORACLE-L Subject: hi ppl can any body help in changing internal pwd on solaris system. i couldn't find oradim on sun. Is there any similar tools like oradim on solaris.. thanks - 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: Armstead, Michael A 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).
ORA-27101: shared memory realm does not exist
I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] Cril Telecom Software France
RE: ORA-27101: shared memory realm does not exist
What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras 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).
OLAP again
Hi Our product uses quite complex data model and we are looking for ways to speed up data access, especially large reports in the range of 25,000+ records. One of the ideas was to look into OLAP, or now Business Intelligence, tools. After some reading it seems to me that OLAP is completely separate product - it is the Express Server that runs its own database, and tools like Express Objects, Express Analyzer that use the Oracle 9iAS and Express Server technology. You can still connect to your Oracle database or import/export the data for analysis, reporting, etc. but you have to set up completely new environment. We hoped that we could use OLAP tools to point to Oracle 8i database and use it to provide faster access to our complex data model but it does not seems so straightforward. Or maybe I missed a tool. Could someone, please, correct me? Thanks Witold == Witold Iwaniec Senior Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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).
Source Code about Java Classes
Hi all, Does anyody knows how to find the source code about Forms java classes (oracle.forms.ui), i've looked for it at OTN, Technet and Metalink, and haven't found no documentation about it. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergio Boix Moriano 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).
Doc on migrating to Oracle 8.1.6 on Solaris
Hi, I checked OTN and they do not have doc on migrating to 8.1.6 for Solaris. Does anyone know where I can get this? All I found on OTN is which has no info on migration Sun SPARC Solaris 2.x, Release 8.1.5 HTML PDF Installation Guide HTML PDF Administrator's Reference Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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).
Oracle DBAs with AIX experience needed in Florida..
Position: Oracle DBAs with AIX experience Location: Ft Lauderdale, Florida Industry: Resorts Salary: Up to 95K Description: These positions are with a major entity in the resorts industry that needs Oracle DBAs who have AIX experience to provide database support. These are staff positions...so no third parties or sub-contractors please. Requirements: *They need someone with at least three years Oracle DBA experience. *Solid AIX platform experience. *Strong written and oral communication skills. **Must be a U.S. citizen or permanent resident. This position offers: * Stability * The opportunity to become a key member of the team. * Relocation assistance Please do not send your resume if you are not in the United States. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please use job code: One/DBA/Ft.Lauderdale/Linda W. Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiitiondescribed above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Unix question
this is ksh93 syntax (at least on Sun): 1453:oracle@e6500b ksh1453:oracle@e6500b var=tester1453:oracle@e6500b echo ${var//e/o}ksh: ${var//e/o}: bad substitution 1453:oracle@e6500b dtksh1453:oracle@e6500b var=tester1453:oracle@e6500b echo ${var//e/o}tostor1453:oracle@e6500b -Original Message-From: Mandar Ghosalkar [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 8:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Unix question check this question from korn faq at http://www.kornshell.com/doc/faq.html Q24. How do I do global substitutions on the contents of shell variables?A24. Use // instead of / for global substitution, ${var//aa/bb} willexpand to the value of with each "aa" replace by "bb". so i tried $ var=tester$ echo $vartester$ echo ${var//e/o}bad substitution$ anyone out there :) -Mandar -Original Message-From: Big Planet [mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 7:56 PMTo: Multiple recipients of list ORACLE-LSubject: Unix question Hi geeks , How can I do substr and instr kind of operaion in unix shell script . is it possible ? like i have one paramter as "hostname" .. I want to trim quotes surrounding the hostname . One more question , is possible to read another text file line by line using a shel script and then edit that file . Actually I have this configuration file for my system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to replace with actual values at the time of installation by asking questions to the user. TIA --Big planet
RE: ORA-27101: shared memory realm does not exist
Abiy, I'm not positive, but it appears that the server's Shared Memory may not be configured. Is the database started and open? I'm assuming not...if in fact Oracle can't allocate the SGA in Shared Memory. You may need to reconfigure your Shared Memory settings and recompile the UNIX Kernel. Check to see if these shared memory settings exist first. Ed Haskins] Oracle DBA Verizon Wireless -Original Message-From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]Sent: Monday, March 26, 2001 10:41 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-27101: shared memory realm does not exist I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] Cril Telecom Software France
RE: ORA-27101: shared memory realm does not exist
If this is NT I have had this error as well. Mine was an error in the init.ora parameters, I forgot to comment something out. Kevin -Original Message- Sent: Monday, March 26, 2001 10:58 AM To: Multiple recipients of list ORACLE-L What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras 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: Kevin Kostyszyn 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: Which is faster??
Direct patch sqlldr (and insert-append) do allow indexes - its just that you get slugged a little more on rollback and redo... I don't have any metrics to compare - typical usage of either tends be to the ol' a) drop ind, b) load, c) redindex hth connor --- Martin Kendall [EMAIL PROTECTED] wrote: I know that Direct Path of sqlldr does not allow Indexes so what is the comparative performance of this suggestion if the given Table is indexed ? Martin -Original Message- Sent: 23 March 2001 09:05 To: Multiple recipients of list ORACLE-L If you're on 8.0 or higher, try insert /*+ APPEND */ into table select * from other_table; where "table" is defined as nologging. Then you won't hit either redo logs or rollback segments..Its the equivalent of a sqlldr direct load hth connor --- CC Harvest [EMAIL PROTECTED] wrote: I have the following scripts: insert into table select * from table2 ; So if use the about bulk statement in my application, and the table2 is big, say 10 million records, my concern is that it's going to fail because of the possible rollback segments failure. So then I have to use PL/SQL to create a cursor and commit every 5 records. What's the disadvantage of this?Will it be much slower than a bulk insert? Can I do it another way: create a stored procedure for this bulk insert, then pin this procedure in memory, does it still have RBS problem? Anyone has similar experience? Thanks in Advance, Chris __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Martin Kendall 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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
Re: DBMS_REPAIR package usage
Thanks for your help! I will definitely try that later today! :D It's really nice to have a full team of people helping me out when I am in a "confused" phrase. And I really do hope that there is not any "I know it's off-topic, but I just couldn't resist .." spam over there. I use my delete keys a lot more frequent than before (it is only my opinion. I am not starting any war here..) :P Winnie yong huang [EMAIL PROTECTED] on 03/24/2001 05:04:00 AM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Hi, Winnie, How did you find the file# to be 9 (unless you messed with your original error message)? I suggest you post your message to news:comp.databases.oracle.server (or http://news.interbulletin.com/cgi-bin/ibwrn/post/comp.databases.oracle.server if your company doesn't have a news server). Hopefully it will attract attention of Jonathan Lewis, the Oracle 8i expert, and several (former) Oracle employees such as Kyle Hailey, Howard Rogers and Anjo Kolk. The good thing about that newsgroup is nobody is audacious enough to post spam messages like "tomorrow I'll post the chocolate recipe here". Yong Huang [EMAIL PROTECTED] --- [EMAIL PROTECTED] wrote: Yong, Thanks a lot for all the research! :D The file# that actaully contains this block is 9. My database is not that big at all. I did do some research myself and some Oracle analysts in the World Wide Support does suggest that the influxed blocks are very likely to be a fractured block. But I reallly have no idea how it got in there... . Winnie yong huang [EMAIL PROTECTED] on 03/23/2001 04:01:21 PM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: DBMS_REPAIR package usage Hi, Winnie, Just a little more research. I wonder how you can have an rdba that big, 0x24070020, which is 604438560 in decimal. SQL var a number; SQL exec :a := dbms_utility.data_block_address_file(604438560); PL/SQL procedure successfully completed. SQL print A - 144 SQL exec :a := dbms_utility.data_block_address_block(604438560); PL/SQL procedure successfully completed. SQL print A - 458784 This is done on 8.1.6. It says the block is in file 144, block 458784. Why does your error say file=0? Anyway, in case you do have a file numbered 144, check to see if there's an object there. If it's indeed file 0, the dba should be the same as block#, 458784, or 0x70020. DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS can confirm this. However, that file# 0 may be just an indicator that that information is lost, as multiple other 0's look like. I believe dbv reports an error when it encounters a fractured block, i.e., the first two bytes of tail (0003 in your case) does not match the last two bytes of rdba (0020). We know how a fractured block is created during hot backup. But I don't understand why an offlined datafile (as you said in another email) can contain fractured blocks. Maybe Jeremiah Wilton can give a better answer. Yong Huang [EMAIL PROTECTED] you wrote: I have a datafile in my production box (a user data tablespace), when I run dbv against it, it showed that 5 blocks are "influxed" Page 458784 is influx - most likely media corrupt *** Corrupt block relative dba: 0x24070020 file=0. blocknum=458784. Fractured block found during dbv: Data in bad block - type:0. format:0. rdba:0x last change scn:0x. seq:0x0 flg:0x00 consistancy value in tail 0x0003c204 check value in block header: 0x0, check value not calculated spare1:0x0, spare2:0x0, spare2:0x0 We can copy this file to tape, dd this file. On the OS disk level, the OS does n ot treat this as corrupted. But it is corrupted on the oracle (software) level. I've checked and can't find any object associate with these 5 corrupted blcok. That means that there is no data inside those blocks. Since the tablespace is about 12 GB on a highly active system (which only got 3 hours maintance window each month), export/import (then drop the tablespace) which Oracle support suggested is mostly out of the question. (Especially, it is very hard for me to convince the sysadmin that the blocks are corrupted as they don't see any I/O error associate with this file and the developers don' t see any problem with the application either!) I am currently thinking about upgrading this database to 8.1.6 to make use of th e DBMS_REPAIR package to make those blocks as "unusable". But I am not sure that if the DBMS_REPAIR package can run against the blocks which do not belong to any objects!! Can someone give me some guidences? thanks Winnie __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail.
UNIX CD on NT
Is there a way to read an UNIX CD correctly on NT? I want to use my CD drive (on NT) to get the files and permissions read correctly on UNIX! Thanks, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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).
(Fwd 1 of 2) Re: Forms going away?
fyi (1 of 2) --- Forwarded message follows --- Date sent: Mon, 26 Mar 2001 02:35:24 -0800 Send reply to: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sriram, Cherokee is not yet available and there are no papers on the Oracle or Technet sites yet, although there will be shortly. A sneak preview of Cherokee was published in the last ODTUG journal which provides a good overview to the tool. Anyway - the one paragraph overview: "Oracle Project Cherokee is a standards-based, declarative development tool for building high-performance, scaleable HTML transactional data-aware components which can be embedded into any JSP or Oracle Portal Page. It combines powerful transactional processing as well as a very rich interactive HTML UI with an ultra-lightweight HTML footprint. Applications run natively in commonly used browsers such as Internet Explorer and Netscape. " Regards Duncan Mills Oracle Forms Product Management - Original Message - To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sent: Saturday, March 24, 2001 12:30 AM Friends, What is Cherokee? is it a forms replacement? Where can I find more on it. I did try digging thru the ORACLE website but could not locate any white papers etc.. Thanks Sriram -Original Message- From: On Behalf Of Openshaw, Michael Sent: Friday, March 23, 2001 4:30 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: RE: Forms going away? Cherokee will substantially improve the issue, but it still will have a problem as far as I'm concerned. That is the need to load a specific component (about 200K in Cherokee's case, as opposed to Jinitiator) to work with a standard browser. The Web was *supposed* to get us away from controlling client configurations; that's why I like Webserver Generation, where browser-sensitivity is minimized (unless you specifically code for it). -Original Message- From: Jim Walski [ j w a l s k i 3 @ c l a s s i c p l a n . c o m ] Sent: Friday, March 23, 2001 2:32 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: Re: Forms going away? That was my thoughts exactly. I figure they _have_ to support it for who knows how long, but as far as new functionality, what you see is what you get. I would *love* to see this Project Cherokee perform as described. Oracle Forms over the Internet is poor at best. I just can't get my hopes up, as Oracle is great at marketing and as for delivering? Jim -Original Message- To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Date: Friday, March 23, 2001 12:15 PM Jim, Forms will be around for a Lng time. Simply because Oracle will not kill it until Oracle Apps moves off of it (and we all know the speed at which Oracle Apps moves forward; calling it glacial would be kind.) Will forms be continually enhanced? I would doubt it, past the next 12 months or so. The chances of a Forms 8 every seeing the light of day is about the same as Egypt winning the Olympic gold medal in hockey. -Original Message- From: Jim Walski Sent: Friday, March 23, 2001 12:20 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: Forms going away? I keep hearing that Forms will continually be enhanced for a long time. However, I sure find it very interesting that Oracle is building a Migration utility to move your Forms .fmb to Cherokee files. Quote from an email received from Susan Duncan "...We have a team of developers who are working on a migration utility to migrate Developer Forms to Cherokee modules " Sure sounds like all new features will be added in Cherokee. Of course knowing the speed of Oracle development I won't hold my breath for an early release of Cherokee. ... To REMOVE yourself from this mailing list, send an E-Mail message to: L i s t G u r u @ f a t c i t y . c o m (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-DEV2K-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). --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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
(Fwd 2 of 2) Re: Forms going away?
--- Forwarded message follows --- Date sent: Mon, 26 Mar 2001 02:20:18 -0800 T o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m F r o m : d u n c a n . m i l l s @ o r a c l e . c o m We are building a migration facility purely because that was one of the first things the customer base asked for when we initially showed Cherokee. You bet people would have moaned if we'd not done it. You'll note the word here is "Migration" not "Upgrade". Cherokee does not replace Forms, it will be a just another service under iAS. There is no doubt that some applications will have portions which will adapt well to the HTML interface so we offer a way of getting there via the migration tool. On the other hand you can do stuff in Forms that the Cherokee HTML interface just can't do. We believe that there is room for both products I'll take this opportunity to plug the "Migrating your 6i applications to Project Cherokee" paper in San Diego. Regards Duncan Mills Oracle Forms Product Management - Original Message - To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sent: Friday, March 23, 2001 7:20 PM I keep hearing that Forms will continually be enhanced for a long time. However, I sure find it very interesting that Oracle is building a Migration utility to move your Forms .fmb to Cherokee files. Quote from an email received from Susan Duncan "...We have a team of developers who are working on a migration utility to migrate Developer Forms to Cherokee modules " Sure sounds like all new features will be added in Cherokee. Of course knowing the speed of Oracle development I won't hold my breath for an early release of Cherokee. ... To REMOVE yourself from this mailing list, send an E-Mail message to: L i s t G u r u @ f a t c i t y . c o m (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-DEV2K-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). --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
Redo Log size used
What can I query to see how much of the redo log file is currently in use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Help...Rollback Segmenst Grow?
There is no way to stop the use of rollback segments when performing delete operation. Have you considered writing a small PL/SQL procedure to delete the rows? That way, you could commit the work at some interval to control the use of rollback segments. You can certainly shrink them manually as required. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Scott Hahn [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Subject: Help...Rollback Segmenst Grow? Gurus 1) I am doing some data movement involving a table creation based on another table create table userid.pm_stage_lg_arch tablespace user_data as select *from userid.pm_stage_lg where entry_timestamp= to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS'); This creates a table with 1,000,000 rows and grows my tablespace by 360 MB... 2) I then want to delete the rows from the original table based on the same date range. delete from nuserid.pm_stage_lg where entry_timestamp = to_date('06-feb-01 11:00:00','DD-MON-YY HH24:MI:SS'); The problem is that when I issue this statement which deletes 1,000,000 rows my rollback segments understandably grow by 600 MB... 1) Can I issue this statement without growing the rollback segments? (no recover?) 2) Can I actually shrink the size of the rollback segments after backing up the database? 3) As you see in the statement I am basing my select on the date which I need to be exact...Is there a way I could do it as select sysdate-45 from dual and have it returned in teh same format as 'DD-MON-YY HH24:MI:SS' ??? I have been trying this for a while and cant get it.. Thanks for the help. This is a DB that is limited in Hard drive space so I need to conserve.. Scott Hahn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Hahn 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: Deshpande, Kirti 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: (Fwd 1 of 2) Re: Forms going away?
The presentation at the below link might also provide you with some additional info. http://www.seouc.org/Details/13.htm Chris "May Oracle be with you...always" -Original Message- Sent: Monday, March 26, 2001 1:21 PM To: Multiple recipients of list ORACLE-L fyi (1 of 2) --- Forwarded message follows --- Date sent: Mon, 26 Mar 2001 02:35:24 -0800 Send reply to: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sriram, Cherokee is not yet available and there are no papers on the Oracle or Technet sites yet, although there will be shortly. A sneak preview of Cherokee was published in the last ODTUG journal which provides a good overview to the tool. Anyway - the one paragraph overview: "Oracle Project Cherokee is a standards-based, declarative development tool for building high-performance, scaleable HTML transactional data-aware components which can be embedded into any JSP or Oracle Portal Page. It combines powerful transactional processing as well as a very rich interactive HTML UI with an ultra-lightweight HTML footprint. Applications run natively in commonly used browsers such as Internet Explorer and Netscape. " Regards Duncan Mills Oracle Forms Product Management - Original Message - To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sent: Saturday, March 24, 2001 12:30 AM Friends, What is Cherokee? is it a forms replacement? Where can I find more on it. I did try digging thru the ORACLE website but could not locate any white papers etc.. Thanks Sriram -Original Message- From: On Behalf Of Openshaw, Michael Sent: Friday, March 23, 2001 4:30 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: RE: Forms going away? Cherokee will substantially improve the issue, but it still will have a problem as far as I'm concerned. That is the need to load a specific component (about 200K in Cherokee's case, as opposed to Jinitiator) to work with a standard browser. The Web was *supposed* to get us away from controlling client configurations; that's why I like Webserver Generation, where browser-sensitivity is minimized (unless you specifically code for it). -Original Message- From: Jim Walski [ j w a l s k i 3 @ c l a s s i c p l a n . c o m ] Sent: Friday, March 23, 2001 2:32 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: Re: Forms going away? That was my thoughts exactly. I figure they _have_ to support it for who knows how long, but as far as new functionality, what you see is what you get. I would *love* to see this Project Cherokee perform as described. Oracle Forms over the Internet is poor at best. I just can't get my hopes up, as Oracle is great at marketing and as for delivering? Jim -Original Message- To: O D T U G - D E V 2 K - L @ f a t c i t y . c o m Date: Friday, March 23, 2001 12:15 PM Jim, Forms will be around for a Lng time. Simply because Oracle will not kill it until Oracle Apps moves off of it (and we all know the speed at which Oracle Apps moves forward; calling it glacial would be kind.) Will forms be continually enhanced? I would doubt it, past the next 12 months or so. The chances of a Forms 8 every seeing the light of day is about the same as Egypt winning the Olympic gold medal in hockey. -Original Message- From: Jim Walski Sent: Friday, March 23, 2001 12:20 PM To: Multiple recipients of list ODTUG-DEV2K-L Subject: Forms going away? I keep hearing that Forms will continually be enhanced for a long time. However, I sure find it very interesting that Oracle is building a Migration utility to move your Forms .fmb to Cherokee files. Quote from an email received from Susan Duncan "...We have a team of developers who are working on a migration utility to migrate Developer Forms to Cherokee modules " Sure sounds like all new features will be added in Cherokee. Of course knowing the speed of Oracle development I won't hold my breath for an early release of Cherokee. ... To REMOVE yourself from this mailing list, send an E-Mail message to: L i s t G u r u @ f a t c i t y . c o m (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-DEV2K-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). --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Why is there air?
On Thu, 22 Mar 2001, Maser, Donna (SEA) wrote: Jared, I am still waiting/hoping for an answer... Why IS there air? - Donna It's to dilute the output from grain eating methane dispensers. Jared -- 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).
Linux, Sqlplus worksheet?
Title: Linux, Sqlplus worksheet? Hi, I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail. Can anyone recommend a gui/java/etc. SQL processor for Linux, other than command line sqlplus? Any information or referral to documentation is appreciated. Thanks, Linda
Re: do you use SQLJ ?
Oracle has repeatedly stated that PL/SQL is not going away. One good reason for this is that PL/SQL is highly optimized for DML in the database. Java is not, and will not likely ever be as efficient PL/SQL for manipulating large amounts of data. At least IMO. OOP has many benefits, but large scale DML is not one of them, at least not yet. PL/SQL will be around for awhile yet. And if you are wondering 'Should I learn Java?', the answer is 'definitely', as it is capable of many things that PL/SQL is not. Jared On Thu, 22 Mar 2001, Jeff Cox wrote: Dear List, I haven't really seen a question on this list regarding SQLJ, and it makes me wonder how many people on this list actually use SQLJ. A DBA friend of mine told me that eventually SQLJ will replace PL/SQL in preference, and I wanted to know the truth regarding his statement - so who better to ask than the experts of this list? What have you heard, or better yet, what is your opinion of SQLJ? Is SQLJ the future? Will PL/SQL die a slow death? Can you do everything in SQLJ that you can do in PL/SQL? Cheers, Jeff Cox IPS-Sendero Scottsdale, AZ -- 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).
RE: Redo Log size used
Hi Glenn, Try 'log_file_usage.sql' at http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 27 March 2001 5:51 To: Multiple recipients of list ORACLE-L What can I query to see how much of the redo log file is currently in use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Steve Adams 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).
Insert
Hi DBA's, One of my developers just asked me a question, and honestly I don't know what he's talking about. But, it made me think of my own that I do know the answer to or at least I used to:( Anyway, when doing an insert into a table, doesn't it increase performance to delete any indexes, do the insert then rebuild the index. Or do you just have to disable the index? Also, does this work the same for delete? Also...is there anyway to guestemate how long an insert is going to take? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Linux, Sqlplus worksheet?
OEM for linux is available in the 8.1.7 download from technet. Another good place to look is http://www.orasoft.org. Matthew has written a fairly good sql worksheet. They both work off the idea of a sql window and output window. Both give you command history, scrollable output, export of input/output to text, both are free. OEM is in java. Orasoft is done with gtk. The OEM sheet allows for sqlplus commands Orasoft doesn't. Orasoft is faster (it's not hogging the machine processes with java.) I use both depending on what I need. Orasoft only works with 8x db's. OEM will work with any Oracle db 7.3.4 or higher (maybe lower too, but I haven't had time to explore that) HTH On Monday 26 March 2001 15:00, Linda wrote: Hi, I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail. Can anyone recommend a gui/java/etc. SQL processor for Linux, other than command line sqlplus? Any information or referral to documentation is appreciated. Thanks, Linda --- -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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: Redo Log size used
See your alertSID.log by using tail -f alertSID.log Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 26 Mar 2001 11:51:11 -0800 What can I query to see how much of the redo log file is currently in use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Linux, Sqlplus worksheet?
Let me rephrase OEM is "free" in accordance with the license restrictions in the development download. Orasoft is GPL for the downloadable version. On Monday 26 March 2001 15:31, you wrote: OEM for linux is available in the 8.1.7 download from technet. Another good place to look is http://www.orasoft.org. Matthew has written a fairly good sql worksheet. They both work off the idea of a sql window and output window. Both give you command history, scrollable output, export of input/output to text, both are free. OEM is in java. Orasoft is done with gtk. The OEM sheet allows for sqlplus commands Orasoft doesn't. Orasoft is faster (it's not hogging the machine processes with java.) I use both depending on what I need. Orasoft only works with 8x db's. OEM will work with any Oracle db 7.3.4 or higher (maybe lower too, but I haven't had time to explore that) HTH On Monday 26 March 2001 15:00, Linda wrote: Hi, I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail. Can anyone recommend a gui/java/etc. SQL processor for Linux, other than command line sqlplus? Any information or referral to documentation is appreciated. Thanks, Linda --- -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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).
Execution Plan Qs. of SQL Script ?
Oracle ver 7.3.4.5 CASE 1 - Following query Going for FULL table scan of TAX_DED_AT_SOURCE_TABLE(Synonym=TDS) Table inspite of the presence of the index IDX_TAX_DED_AT_SOURCE_TABLE defined on Fileds(sol_id, cust_id, tds_cert_num, tran_date) SELECT SOL_ID,CUST_ID FROM TDS WHERE TDS.SOL_ID IN ( SELECT SOL_ID FROM SOL WHERE SOL.BR_CODE = '033' ) AND TDS.CUST_ID = '03313' AND TDS.TRAN_DATE = TO_DATE( '01-04-2000 00:00:00' , 'DD-MM- HH24:MI:SS' ) call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch1 1.74 1.74 8062 8068 2 1 --- -- -- -- -- -- -- total3 1.74 1.74 8062 8068 2 1 Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: RULE 1 NESTED LOOPS 368573TABLE ACCESS (FULL) OF 'TAX_DED_AT_SOURCE_TABLE' 1TABLE ACCESS (BY ROWID) OF 'SERVICE_OUTLET_TABLE' 1 INDEX (UNIQUE SCAN) OF 'IDX_SERVICE_OUTLET_TABLE' (UNIQUE) NOTE SOL is the Synonym for SERVICE_OUTLET_TABLE Table which Contains Masterdata of about 50 rows only Qs. 1 Why is Index Scan of TAX_DED_AT_SOURCE_TABLE Table NOT Happening ? Qs. 2 Am i correct in inferring from the Above That TAX_DED_AT_SOURCE_TABLE is the Driving Table because it Appears First in the Execution Plan when Reading Downwards ? CASE 2 - After Creation of Index on SERVICE_OUTLET_TABLE (SOL) table on field (br_code field), for the SAME WHERE Clause Statement , INDEX Scan of TAX_DED_AT_SOURCE_TABLE(TDS) Table is Done UPDATE TDS SET TDS.SHORTFALL_AMT = 0 WHERE TDS.SOL_ID IN ( SELECT SOL_ID FROM SOL WHERE SOL.BR_CODE = :1 ) AND TDS.CUST_ID = :2 AND TDS.TRAN_DATE = TO_DATE( :3 , 'DD-MM- HH24:MI:SS' ) call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 7 1 1 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total2 0.00 0.00 0 7 1 1 Rows Execution Plan --- --- 0 UPDATE STATEMENT GOAL: RULE 1 NESTED LOOPS 1TABLE ACCESS (BY ROWID) OF 'SERVICE_OUTLET_TABLE' 2 INDEX (RANGE SCAN) OF 'IDX_SOL_BR_CODE' (NON-UNIQUE) 2INDEX (RANGE SCAN) OF 'IDX_TAX_DED_AT_SOURCE_TABLE' (UNIQUE) NOTE - Also seemingly SERVICE_OUTLET_TABLE(SOL) Table Now Becomes the Driving Table Qs. How does Creation of an index on The Table which is Part of the Nested Query Cause the Execution plan to Change as Shown ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: Using HS
It must be a silly environment issue. Are you using a Merant driver on the Sun to SQL server (I was not aware that there is such a Merant driver), or are you using SQL*NET to get to the NT where HS is activating Merant? - If Merant driver is on the Sun, I would check the listener environment. Probably the ODBCINI environment variable is not set. - If Merant driver is on NT, the most common case is if you defined a user DSN instead of a system DSN. The listener starts HS under the system so the user DSN is not known. Hope this helps... Tzachi - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, March 23, 2001 4:55 PM The SUN/Merant = NT link is ok because it is working when using Powermart. We just want to call a stored proc on MS SQL Server which is not allowed with Powermart 4.6 (it is supposed to work with Powermart 5) . So the idea is to call an Oracle Stored proc which would called a MS SQL Server stored proc. We won't buy the Gateway since Powermart 5 should do the job in a few months. --- Tzachi Nissim [EMAIL PROTECTED] a crit : Looks like you did not setup the DSN name correctly. Merant cannot find the DSN name that HS passed to it. Look at their ODBCINI file to verify that the DSN appears there. I would suggest, however, that you get the enterprise gateway to SQL server. Performance will be better too... I hope you had more fun in your vacation... :) Tzachi - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 7:30 PM Hi, Back from vacation and trying to make HS work between Oracle 816/Solaris and MS SQl Server 6.5 or Oracle 817/Solaris MS SQl Server 6.5. The ODBC driver is Merant 360. On 816 I'm having : ORA-28500: connection from ORACLE to a non-Oracle system returned this mess age: [Transparent gateway for ODBC]DRV_InitTdp: [MERANT][ODBC lib] Data source name not found and no default driver specified (SQL State: IM002; SQL Code: 0) ORA-02063: preceding 2 lines from HSODBC On 817 I'm having ORA-28509: unable to establish a connection to a non-Oracle system ORA-02063: preceding line from HSODBC Anybody ? = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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: Tzachi Nissim 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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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
OPS Setup Steps ?
Have a Single Instance Database ( ORA 8.1.7 )Running on a 2-node Cluster ( Digital Unix 5.1) Any Doc. Listing Steps to Convert it into a 2 instance OPS Database ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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 - As to the encapsulation: Yes things should be encapsulated, fine. But are you saying you do not use any queries in your encapsulating procedures? I am using cursors ( mostly implicit ). Have you ever seen an app that was completely encapsulated? Yes, I had. Not every app needs ad hoc queries.. What about the developer that gets repeatedly reprimanded for not following corporate standards but is married to the CEO's daughter? If the CEO still keeps him, he is dumb. If the CEO is dumb, the whole company goes to hell sooner or later. What's the point of taking care of the project then? :-) You keep referring to code that has to be changed anyway. Perchance another example, we'll use the DOCTOR table from the Ghosalkar/Kilchoer thread: ... The users tell us: We need to track specialties as being primarily inpatient or outpatient so that extra information can be collected for inpatient situations (I know, those of you doing work in health care can shoot all kinds of holes in this.) Then I copy all the entries from the code table. (script that must run at the production site - asking for trouble), remove them from the old table (even more dangerous). Update the master table entry program and procedures to not allow the archived code any more. Rip through every scrap of code in the system to find any reference to I_DONT_LIKE_MASTER to make sure it does not have any need of the archived code type. I would put this into code_type = 'specialty_type_inpatient' and code_type = 'specialty_type_outpatient', not adding the inpatient_yn column. Please bear in mind that although you are being a very good programmer and using encapsulation, the idiots that got fired last week were not, so we still have to look. I would say we have to prevent this :-) "Code supervizing" they call it.. Any that are found will have to be changed. Now I create my new entry form to add the field and update the registration code. Then I sit back and wait for 1) one of the client's Access reports to return no data because they did not realize the data had been moved, So Access report does not use the packaged code? Too bad.. or 2) some of our code to break because we overlooked something. The multiple table way: CREATE TABLE SPECIALTIES (INPATIENT_YN VARCHAR2(1)) Now I create my new entry form to add the field and update the registration code. Done. Where are these other code changes that have to be done? Changes to the doctor table. All the old code (encapsulated or not) still works the way it used to. If I overlook something, it may not have the added functionality, but it will not break. PS: I think this discussion would best be continued with copious amounts of alcohol. If you are ever in Dallas, look me up. Agreed ;-) If you'll be in Washington DC, let me know! -Original Message- From: Michael Netrusov [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Single Code Table or Separate Code tables dilemma Well, in the case of 100 tables you are still hunting all the code looking for pieces which are relevant to that changed table. Depends on your code. I prefer to encapsulate mine, so reference to a table is enclosed in its own package. My point is that I can use grep to search the entire code for "order_status" and get a short list (maybe 10) of places to look. It is much more difficult to search for "code_table", get a list of 1, then filter through the results for some bastardized variety of "code_type = 'STATUS'" to get down to those same 10. Not everything can be encapsulated in a procedure. This is a database we are talking about, so people do still write queries where it is easier to join the lookup table to the master table directly. If the code has to be broken out of the central lookup table, you have to update every query that joins it in, even if all that query needs is the description. If it is already split out, the only code I really have to be concerned with is the places where the new functionality applies. Queries still can be ( and should be ) encapsulated in packages. If you are taking this to-be-enhanced 'status' entity out of the master lookup table, all you have to do is to develop a new package, change the calling code and prohibit the usage of code_type = 'status' in the master lookup table. This still would be changed if you had a separate package and table for the 'status' entity. If I were starting a product from scratch and there was a central code table I would probably code against a set of views in anticipation of the above event, so the DBA ends up creating 1 objects anyway. Views consume resources and bring new dependencies, so the administration becomes more complicated. What
RE: Linux, Sqlplus worksheet?
OEM will do just fine. It's available on 8.1.7 -Original Message- Sent: Monday, March 26, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Hi, I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail. Can anyone recommend a gui/java/etc. SQL processor for Linux, other than command line sqlplus? Any information or referral to documentation is appreciated. Thanks, Linda -- 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).
RE: IOUG university
Well, I haven't been to any classes taught by Cary Millsap, but I worked with Cary in the late '80's. One of the sharpest individuals I've ever worked with, very personable, friendly, and down to earth. I would imagine his classes/seminars are very useful. I've been to seminars put on by Gaja and Dave at OpenWorld and, if memory serves me right (very debatable), at the IOUG conference. Their presentations were very interesting and useful. In addition, Dave Ensor could probably be a stand-up comedian. Very entertaining guy. IMHO, and despite not looking at the course outlines, I'd say you can't go wrong with any of'em. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Monday, March 26, 2001 2:52 PM To: Multiple recipients of list ORACLE-L I am specifically interested in Gary Miilsap, Gaja Vaidynata and Dave Ensor courses - opinions about level, usefullness, materials etc. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: Weaver, Walt 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: Redo Log size used
Hi Glenn, Yes, your query is fine, and does just what you think. Please see http://www.ixora.com.au/q+a/0102/06135327.htm for the meaning of cpodr_bno. Please see http://www.ixora.com.au/tips/tuning/log_buffer_size.htm for the relationship between log blocks and the log buffer. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 27 March 2001 7:27 To: Steve Adams Cc: Oracledba As always your script was exactly what I was looking for. I am assuming the column sys.x_$kccle.lesiz is number of blocks which make up the logfile, and sys.x_$kcccp.cpodr_bno is number of blocks in the log file currently in use, although I can't decipher the column name meaning. Using your http://www.ixora.com.au/scripts/redo_log.htm#log_block_size.sql script, I was able to see the number of bytes in a redo log block. Again, I am assuming it is bytes (why is the redo log block size different from the log buffer size (set in the init.ora file)?). What exactly is the sys.x_$kccle.lebsz column? I wrote this query to give me the number of MB currently in use by in the redo log file. select le.leseq log_sequence#, le.lesiz * le.lebsz /1024 /1024 logmbtotal, cp.cpodr_bno * le.lebsz /1024 /1024 logmbinuse from sys.x_$kcccp cp, sys.x_$kccle le where le.inst_id = userenv('Instance') and cp.inst_id = userenv('Instance') and le.leseq = cp.cpodr_seq Am I making the correct assumptions here? -Original Message- From: Steve Adams [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 3:26 PM To: [EMAIL PROTECTED] Cc: Oracledba Subject: RE: Redo Log size used Hi Glenn, Try 'log_file_usage.sql' at http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 27 March 2001 5:48 To: [EMAIL PROTECTED] Subject: Redo Log size used What can I query to see how much of the redo log file is currently in use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams 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: Source Code about Java Classes
Sergio, It doesn't seem to likely that Oracle will provide the source for their products. Jraed On Mon, 26 Mar 2001, Sergio Boix Moriano wrote: Hi all, Does anyody knows how to find the source code about Forms java classes (oracle.forms.ui), i've looked for it at OTN, Technet and Metalink, and haven't found no documentation about it. Thanks in advance -- 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).
Solaris security ?
Hi guys, (With - Solaris 2.7) Do you have any solution how to allow "non owner" to perform backup ? with "tar command" For example: myfile.txt rw--- can you solve this puzzled ? If you think I need to write a unix script would you please teaching me and showing me the steps ? Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Execute priv to an isolated procedure inside a package
Hi friends, One cannot grant execute privilege to a specific procedure/function inside a package, but only for all or nothing that is in that package. Anybody has an idea how this limitation can be overcomed. One idea is to create a separate stand-alone procedure that will just be a wrapper around the packaged procedure and call it. Any other ideas. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: djordjej 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: IOUG university
I saw Cary present in Copenhagen VERY smart man.. father of OFA :) Gaja we all know from this list -- and I know very few (if any) people who know more about performance tuning than he does Dave Ensor also -- yes a stand-up comic, but he also is one of the most knowledgeable men about oracle that I have met. ALL these presentations will be wonderful From: "Weaver, Walt" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: IOUG university Date: Mon, 26 Mar 2001 14:36:00 -0800 Well, I haven't been to any classes taught by Cary Millsap, but I worked with Cary in the late '80's. One of the sharpest individuals I've ever worked with, very personable, friendly, and down to earth. I would imagine his classes/seminars are very useful. I've been to seminars put on by Gaja and Dave at OpenWorld and, if memory serves me right (very debatable), at the IOUG conference. Their presentations were very interesting and useful. In addition, Dave Ensor could probably be a stand-up comedian. Very entertaining guy. IMHO, and despite not looking at the course outlines, I'd say you can't go wrong with any of'em. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Monday, March 26, 2001 2:52 PM To: Multiple recipients of list ORACLE-L I am specifically interested in Gary Miilsap, Gaja Vaidynata and Dave Ensor courses - opinions about level, usefullness, materials etc. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: Weaver, Walt 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: ===CPU, memory script(need help)
select NAME, VALUE from sys.v_$sga; vmstat (solaris command) Sinardy -Original Message- Sent: Monday, 26 March 2001 8:12 PM To: [EMAIL PROTECTED] Importance: High Hi Gurus, does anyone has a script that detects in a database where a lot CPU is being used and memories.(on Solaris) if so can someone send me this. Thanks Regis Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Curious /etc/system settings in Solaris
Hello all, One of the database servers that I am currently working on is a Sun 6500, running Solaris 2.7. It's a fairly large machine, with 20 gig of memory. It's being used for development and testing for multiple applications. When I began installing our particular versions of Oracle (7.3.4.5 and 8.1.7) on the box, I noticed that there were several tunables settings in /etc/system that I had not seen on Solaris boxes previously. Is anyone familiar with the settings that I have listed below? I have placed an to the right of the tunables in question. Could they perhaps be applicable to an HP-UX server? So far I've only worked on Sun, AIX and Linux servers. The shop where this server is located has been primarily HP-UX in the past, so I thought that these might be legacy settings. On Solaris, I've heard that it isn't a good idea to fool around too much with tunables if it isn't necessary. Portions of the kernel are "dynamic", and unneeded settings could limit OS operations. Some of the typical Oracle settings don't look optimal either, for example semmns=15000!!, but that is an issue for another time. Any info would be greatly appreciated, Lou Avrami * Following paraameters added under change # 144754 for Oracle install. set tune_t_gpgslo=250 - set tune_t_minarmem=100 - set tune_t_minasmem=250 - set msgsys:msginfo_msgmap=200 - set msgsys:msginfo_msgmni=100 - set msgsys:msginfo_msgtql=80- set msgsys:msginfo_msgseg=2048 - set semsys:seminfo_semmap=100 - set semsys:seminfo_semmnu=800 - set semsys:seminfo_semume=100 - set pln:pln_enable_detach_suspend=1 - set soc:soc_enable_detach_suspend=1 - set socal:socal_enable_suspend=1- set fcaw:force32 = 1- set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=500 set semsys:seminfo_semmsl=2010 set semsys:seminfo_semmns=15000 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 * End change # 144754 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami 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).
help!!! data migration
hi ppl, i want to migrate oracle database from solaris to NT and vise versa.. can anybody tell me the best way to do it. my database sixe is around 25GB. thanks - 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).
RE: Execution Plan Qs. of SQL Script ?
Kevin wrote - "It is no surprise that the index you mention cannot be used" Qs. WHY ? ( Why is Index IDX_TAX_DED_AT_SOURCE_TABLE on the Table in the Main Query NOT being used in the Absence of the Index on the Table of the Sub-Query ? ) Or am i missing the Obvious ? -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 3:59 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Execution Plan Qs. of SQL Script ? CASE 1 - Following query Going for FULL table scan of TAX_DED_AT_SOURCE_TABLE(Synonym=TDS) Table inspite of the presence of the index IDX_TAX_DED_AT_SOURCE_TABLE defined on Fileds(sol_id, cust_id, tds_cert_num, tran_date) SELECT SOL_ID,CUST_ID FROM TDS WHERE TDS.SOL_ID IN ( SELECT SOL_ID FROM SOL WHERE SOL.BR_CODE = '033' ) AND TDS.CUST_ID = '03313' AND TDS.TRAN_DATE = TO_DATE( '01-04-2000 00:00:00' , 'DD-MM- HH24:MI:SS' ) It is no surprise that the index you mention cannot be used. 1) You need to think of the subquery as a seperate query, and produce an index that will optimize the subquery. That is why the index on SOL.BR_CODE works well. 2) Your index is otherwise overspecified in relation to your WHERE clause... your query does not include the index column TDS_CERT_NUM and any following column, so you are unable to use the TRAN_DATE component of the index as well. You could either reverse the order of the 3rd and 4th column (which may impact some other queries' performance... check on v$sqlarea for similar queries), or create another index which just has the 3 columns you are referencing. Kevin Little -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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).
olap?
Hallo, Can anyone tell me: What is OLAP and how does it work, a short description, thanks. Roland Skldblom -- 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).
Re: Source Code about Java Classes
Hi all, [EMAIL PROTECTED] wrote: Sergio, It doesn't seem to likely that Oracle will provide the source for their products. I supposed it, but I only want the source for the oracle.forms.ui or the oracle.forms.ui.vbutton. If it's not possible, i would like to have a complete information about the methods an the posibble values of the attributes for the oracle.forms.ui class. Thanks in advance. Jraed On Mon, 26 Mar 2001, Sergio Boix Moriano wrote: Hi all, Does anyody knows how to find the source code about Forms java classes (oracle.forms.ui), i've looked for it at OTN, Technet and Metalink, and haven't found no documentation about it. Thanks in advance -- 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: Sergio Boix Moriano 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).