V$SESSION with no osuser and no username
Hi all, I'm using Sun Solaris 7 with Sun Clustering cluster 2.2 I have 4 strange users connected in this machine Oracle 8.1.6.0.0 (Dedicated) Characteristic of unknown users (from v$session) : - 4 of them connected without USERNAME, OSUSER, PROGRAM, TERMINAL, MACHINE (they are NULLl) - Logon_time keep changing to the current time, - user# = 0 (SYS according to dba_users) - status = active - type = user - Last_call_et values are the same for four of them (20) Can someone explain who are those users Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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: TABLESPACE PCTINCREASE?
This may be true but if a uniform extent size policy (or very close to it) is adopted (or enforced with lmt's) then there is no need to coalesce anything at all - even if chunks of free space are contiguous. hth connor --- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote: The biggest problem with setting the PCTINCREASE to 0 on existing tablespaces is that it won't automatically coalesce. You may need to manually coalesce occasionally especially if you deallocate tables or rebuild indexes. Below is what I use to see tablespaces needing coalescing: select a.tablespace_name, count(a.tablespace_name) ContinguousFreeBlocks from dba_free_space a, dba_free_space b where a.tablespace_name = b.tablespace_name and a.file_id = b.file_id and a.block_id = b.block_id + b.Blocks group by a.tablespace_name; If the number of ContinguousFreeBlocks gets above 20, I coalesce. You may chose a different number depending on the size of your tablespaces. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- 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).
Re: JDBC errors?
Title: JDBC errors? I am getting weird results while trying to connect via jdbc to an Oracle 817 db on Windows 2000. I can connect via ODBC, but not JDBC, any ideas? is the weird result accompanied by an error message?
Unix permissions
Since we use utl_file to read/write files from our application directories(which are not owned by oracle), we need to set the permissions on these directories so that Oracle has permission to read and write to them. However we run into problems because Systems Admin guys do not like : 1. setting 777 permissions on the directories 2. making our application user a member of the oracle group Anyone had the same problems? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: JDBC errors?
Title: JDBC errors? Sorry, the errormessage is the following: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323) at oracle.jdbc.driver.OracleConnection.init(OracleConnection.java:263) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:177) at csTest.main(csTest.java:34) -Original Message-From: Marin Dimitrov [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 07, 2002 11:03 AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: Re: JDBC errors? I am getting weird results while trying to connect via jdbc to an Oracle 817 db on Windows 2000. I can connect via ODBC, but not JDBC, any ideas? is the weird result accompanied by an error message?
Re: V$SESSION with no osuser and no username
Sinard Xing wrote: Hi all, I'm using Sun Solaris 7 with Sun Clustering cluster 2.2 I have 4 strange users connected in this machine Oracle 8.1.6.0.0 (Dedicated) Characteristic of unknown users (from v$session) : - 4 of them connected without USERNAME, OSUSER, PROGRAM, TERMINAL, MACHINE (they are NULLl) - Logon_time keep changing to the current time, - user# = 0 (SYS according to dba_users) - status = active - type = user - Last_call_et values are the same for four of them (20) Can someone explain who are those users Thanks Sinardy Sinardy, Can be processes for jobs (most likely), Intermedia-style processes, etc. Join on V$PROCESS or V$BGPROCESS to have the fuller picture. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
stopiing write to listener.log
Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
Stored Procedures
Well, I finally got permissions to use stored procedures in one of our projects. Problem is, I'm not all that butch when it comes to SP's, so, the question is. Do any of you have any links to good tutorials that shows how to best utilize them? Would like to see some examples on what you can do with them. In our case they will be very simple. Would be gratefull for any pointers :) Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jakobsson 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).
Scrolling Sideways in SQL*Plus
Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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: Data Retrieval Tool
Hello Dennis We bought PlSqlDeveloper. The tool show you a list of the tables. Right click on a table and you get a menu that let you (among other things) query and update the data. If I remember correctly it cost 750$ for 10 user license. Go to http://www.allroundautomations.com . Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 7:13 PM To: Multiple recipients of list ORACLE-L Subject: Data Retrieval Tool Good day all, I have been asked the following question a couple of time by our database users - They have a bunch of small Access databases that they want to port into Oracle. Since most of these databases have just a few tables in them I figure I can use sql loader to load the access tables into Oracle. But the tough part is, how do we have the users access the data once it is in Oracle? Since these are pretty static databases and we don't have the resources in house to develop front end tools to retrieve the data, I am wondering if there is a slick, user friendly tool out there can help us with this. Toad partially satisfies this need but I think it is an overkill for data access only. Also, it would be nice to have a web browser interface and some data insert and update capabilities without using sql. Alright I know now I am really push it... TIA Dennis Meng Database Administrator Focal Communications Corp -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Scrolling Sideways in SQL*Plus
Change the buffer width in the environment panel. That should do it. Cheers, Kev. -Original Message- Sent: 07 February 2002 11:08 To: Multiple recipients of list ORACLE-L Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i docs
Sathish , look at http://tahiti.oracle.com Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prem J Khanna 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: Ora
Thanks All Found it. The weird thing is that it was the TEMP tablespace and I have hash_multiblock_io_count to zero (0). So why am I getting this error? Increasing the extent size to 5MB solved the problem. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 6:34 PM To: Multiple recipients of list ORACLE-L Subject: Ora Hello All I got the following error: ORA-03232: unable to allocate an extent of 127 blocks from tablespace 3 How can I know what tablespace is '3'? ora816 on nt. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?_? 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: stopiing write to listener.log
Lee, I really don't think that's what he was after. However he does ask an Alice (IWL) and Cheshire cat question. Although yes I did resist the temptation to reply with such flair. Peter -Message d'origine-De: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 12:33À: Multiple recipients of list ORACLE-LObjet: RE: stopiing write to listener.log Stop the listener !! -Original Message-From: Shibu [mailto:[EMAIL PROTECTED]]Sent: 07 February 2002 10:38To: Multiple recipients of list ORACLE-LSubject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibuThe information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: question on EXPLAIN_PLAN
Hello Kevin you wrote: And the table and index is analyzed at same way. What way? If you use estimate you can get wrong statistics. Try to do full analysis. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: kevin wang [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 11:46 PM To: Multiple recipients of list ORACLE-L Subject: Re: question on EXPLAIN_PLAN Hi, Bill You are right, there is really something to do with the index. I dropre-created that PK index, it became much faster, but after 5 minutes, it became slow again, and I am sure no records insert/delete/update happened. I dropre-created that indexes again, nothing happened this time, it is still slow! It is really weird! And I found on the bad performance database, a simplest query: select count(*) from table_namewill take 4 seconds! the explain_plan said it used cost-optimizer, using fast_full_index_scan on that PK index, what should I do with the index? I already tried to re-created the PK index. The bad performance database is on a super-box, 4 CPUs and more memory. the good performance one is on a normal box. And the table and index is analyzed at same way. thanks a lot for your reply. Kevin Wang - Original Message - From: Bill Zakrzewski mailto:[EMAIL PROTECTED] To: kevin wang mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 12:38 PM Subject: Re: question on EXPLAIN_PLAN Kevin, Have these indexes been rebuilt recently? If not, you may want to consider rebuilding the indexes. Not sure if this is your issue, but if you have inserted/deleted records from your tables over time, the index levels may have grown as well. ~ Bill Zakrzewski Senior Consultant Intactus Technology, Inc. - Original Message - From: kevin wang mailto:[EMAIL PROTECTED] To: LazyDBA.com Discussion mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 2:43 PM Subject: question on EXPLAIN_PLAN Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema structure, different data(but small difference of size). and even exactly same explain_plan of my sql query. But on one database, the cardinality of one PK index access upon one table is 27(cost=2,card=27,bytes=756) (table rows 263758) and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows 351173). so, on one DB the sql query took 300ms, one the other, it took 5 seconds! Any advise is highly appreciated. thanks, Kevin Wang Database Administrator Vivonet Canada Inc. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Re: STATSPACK impact?]
To get resonable results from the reports, your timing interval should be around 10 to 30 minutes. As running statspack collection every that often is likely to produce far too much data than you want to have space for, I always recommend running statspack collection in a system like this repeatedly: Collect, wait 15 minutes, collect, wait long time, and then subsequently do the reporting over the 15 minute intervals. And as to the impact: There is in fact some impact on busy systems, which primarily comes from loading the statspack package into the library cache. The impact isn't large, and it is clearly worth doing. Thanks, Bjrn. Joe Raube wrote: I have run it as frequently as once per hour, often times just 2 or 3 times per day - morning, noon, close of business.I have never seen any performance impact, and I don't believe therewill be any unless you change the default level of statistics gathering.-JoeOn Wed, 06 Feb 2002 12:47:48 -0800Thomas Jeff [EMAIL PROTECTED] wrote: Just curious, but if your shop uses STATSPACK, could you tell me howfrequently you run it, particularly in your OLTP databases; and whether you've noticed anyperformance issues with generating frequent STATSPACK snapshots?Thanks.Jeffery D ThomasDBAThomson Information ServicesThomson multimedia Inc.Email: [EMAIL PROTECTED]DBA Quickplace: http://gkmqp.tce.com/tis_dba _Do You Yahoo!?Get your free @yahoo.com address at http://mail.yahoo.com
Re: stopiing write to listener.log
Shibu , IF you type LSNRCTL HELP YOU WILL SEE THE SET OPTION THEN TYPE HELP SET you will see the log_status action .. type show log_status . and be sure that it is ON. Then try to make it OFF with the SET command ... Bunyamin - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 1:58 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 11:38À: Multiple recipients of list ORACLE-LObjet: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
RE: stopiing write to listener.log
Stop the listener !! -Original Message-From: Shibu [mailto:[EMAIL PROTECTED]]Sent: 07 February 2002 10:38To: Multiple recipients of list ORACLE-LSubject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: Scrolling Sideways in SQL*Plus
I also have sometimes this weird situation I usually set buffer width 1000 and linesize also 1000 Sometimes I cannot use scrollbar to the right but the cure for that is simple if I change the dimensions of my SQL/Plus window then all is just fine Not too often, but anyway I don't know Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ [EMAIL PROTECTED] Sent by: To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: Scrolling Sideways in SQL*Plus 2002.02.07 13:08 Please respond to ORACLE-L Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopie?n te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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
Re: stopiing write to listener.log
Shibu, To stop listener from writing into listener.log put the following into listener configuration file listener.ora: LOGGING_LISTENER = OFF then stop/start listener to use modified configuration file. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Shibu To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:38 AM Subject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
RE: svrmgrl
Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: stopiing write to listener.log
Hi peter I have thousands of connection in my dband listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 11:38À: Multiple recipients of list ORACLE-LObjet: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
Re: MC/Serviceguard vs Sun Clusters
Stay with HP Serviceguard! From experience, I rank HA solutions in this order: 1. HP serviceguard - easy and it works. 2. IBM HACMP - do it the way IBM wants it and it works. 3. Sun Cluster - get a high paid consultant to set it up and have them come back to change it :) Better yet, go with Veritas Trusted Cluster. Just my $.02. I know some Sun ppl on this list will disagree, but if they worked in a HP env maybe not :) Gene [EMAIL PROTECTED] 02/06/02 08:23PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi 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: Gene Sais 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 permissions
I typically set utl_file to /tmp/oracle/$ORACLE_SID. The /tmp dir (setuid bit set) allows oracle to write and anyone to read. It protects users from overwriting Oracle files. Nothing for the sysadmin to change :) Gene [EMAIL PROTECTED] 02/07/02 04:53AM Since we use utl_file to read/write files from our application directories(which are not owned by oracle), we need to set the permissions on these directories so that Oracle has permission to read and write to them. However we run into problems because Systems Admin guys do not like : 1. setting 777 permissions on the directories 2. making our application user a member of the oracle group Anyone had the same problems? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Gene Sais 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: Limiting RMAN backup size
I have used SET LIMIT CHANNEL to limit the size of the backup pieces. I haven't used SETSIZE, which limits the total byte size of a backup set. However, I don't see how this will help, since a backup command can create many backup sets. I face the same dilema. It looks like another example of Oracle giving you very a fine-grained level of control over everything except that which you want to control. [EMAIL PROTECTED] 02/06/02 09:08PM TIA, I suggest reading the section of the manual on Back Sets. I've included the link below for you. Cheers, Craig. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server. 817/a76990/rmanconc.htm#443835 http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server .817/a76990/rmanconc.htm#443835 -Original Message- Sent: Thursday, 7 February 2002 11:43 AM To: Multiple recipients of list ORACLE-L Hi I am doing RMAN incremental level 0 backup .The database size is about 150GB out of which used would be about 100GB.I don't have a single volume with 100GB of space.So I need to distribute the backup across several disks. Also I need to limit the backup size in each of the volumes depending on how much space is available in those volumes. For e.g if i want to limit /disk1 to 40GB /disk2 to 10GB /disk3 to 10GB /disk4 to 10Gb How would i do this in RMAN? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: svrmgrl
It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you can get. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 8:09 AM Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Igor Neyman 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: question on EXPLAIN_PLAN
Kevin, Have you tried it with autotrace on to see the number of reads etc? Iain -Original Message- Sent: Wednesday, February 06, 2002 10:09 PM To: Multiple recipients of list ORACLE-L Yes, Mike, I analyzed the table and PK index on the two databases at the same way, it seems that there is something wrong with the PK index, the select count(*) from table_name query took 4 seconds, and only 335199 rows atcually. it use fast_full_index scan of the PK index, and I re-created the PK index, same thing. that's very bad. it is Oracle 8.1.6 on win2000. thanks for reply. Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 1:55 PM Kevin, Have you analyzed the tables on both databases? Card is the CBO's estimate of the number of rows it will process. Mike From: kevin wang [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: question on EXPLAIN_PLAN Date: Wed, 06 Feb 2002 11:43:38 -0800 Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema structure, different data(but small difference of size). and even exactly same explain_plan of my sql query. But on one database, the cardinality of one PK index access upon one table is 27(cost=2,card=27,bytes=756) (table rows 263758) and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows 351173). so, on one DB the sql query took 300ms, one the other, it took 5 seconds! Any advise is highly appreciated. thanks, Kevin Wang Database Administrator Vivonet Canada Inc. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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 wang 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: Nicoll, Iain (Calanais) 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[2]: stopiing write to listener.log
Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off. Dick Goulet Reply Separator Author: Shibu [EMAIL PROTECTED] Date: 2/7/2002 5:14 AM Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 A : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi peter /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I have thousands of connection in mynbsp; dbnbsp;andnbsp; listener.log is growing very fastly. Inbsp; wantnbsp; to flush it manauallynbsp; every time/FONT/DIV DIVFONT face=Arial size=2I want to either stop it or flush it automatically .My db is 8.1.7 on win2k/FONT/DIV DIVFONT face=Arial size=2Do u h ave any solution for this ?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2regards,/FONT/DIV DIVFONT face=Arial size=2shibu/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, February 07, 2002 5:28 PM/DIV DIV style=FONT: 10pt arialBSubject:/B RE: stopiing write to listener.log/DIV DIVBR/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2Shibu,/FONT/SPAN/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2What do you really want?/FONT/SPAN/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log/SPAN/FONT/FONT/F ONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You could redivert this to /dev/null however this defeats the point./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You can rename it every day and archive off after 14 days./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002/SPAN/FONT/FONT/FONTnbsp;/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002User Failing to connect like/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Microsoft Transaction Server/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Look on the metalink/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Establish a grant to DBA_PENDING_TRANSACTIONS/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002HTH/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Peter/SPAN/FONT/FONT/FONT/DIV DIVSPAN class=843013411-07022002/SPANFONT face=Tahoma size=2-Message d'origine-BRBDenbsp;:/B Shibu [mailto:[EMAIL PROTECTED]]BRBEnvoyénbsp;:/B jeudi 7 février 2002 11:38BRBAnbsp;:/B Multiple recipients of list ORACLE-LBRBObjetnbsp;:/B
Re:MC/Serviceguard vs Sun Clusters
Rama, We did the MC/ServiceGuard thing some years ago. Worked well, after our SA rebuilt the servers from ground 0. Adding it on to an existing server is ok, but somewhat unstable. One item to be VERY careful of. The heartbeat cable, in our case a ethernet thin line, needs to be on a dedicated link, preferably a purchased vs. custom made cable, and protected from accidental disconnect. Ours got disconnected by a contractor working in the computer room because it was in his way. The resulting reboot of the backup server and forcible takeover of the disk farm absolutely destroyed the database. We had more file corruption than I ever could have imagined. Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet Reply Separator Author: Rama Malladi [EMAIL PROTECTED] Date: 2/6/2002 5:23 PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: svrmgrl
Thanks Igor Checked and the NT user is indeed in ORA_DBA. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you can get. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 8:09 AM Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: Migration utility from 7.3.4 to 9i ??
Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- 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: question on EXPLAIN_PLAN
I'm sure this is too simple but its not excessive extents is it? select count(*) from dba_extents where segment_name = 'PK_INDEX_NAME'; select count(*) from dba_extents where segment_name = 'TABLE_NAME'; -Original Message- Sent: Thursday, February 07, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Kevin, Have you tried it with autotrace on to see the number of reads etc? Iain -Original Message- Sent: Wednesday, February 06, 2002 10:09 PM To: Multiple recipients of list ORACLE-L Yes, Mike, I analyzed the table and PK index on the two databases at the same way, it seems that there is something wrong with the PK index, the select count(*) from table_name query took 4 seconds, and only 335199 rows atcually. it use fast_full_index scan of the PK index, and I re-created the PK index, same thing. that's very bad. it is Oracle 8.1.6 on win2000. thanks for reply. Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 1:55 PM Kevin, Have you analyzed the tables on both databases? Card is the CBO's estimate of the number of rows it will process. Mike From: kevin wang [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: question on EXPLAIN_PLAN Date: Wed, 06 Feb 2002 11:43:38 -0800 Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema structure, different data(but small difference of size). and even exactly same explain_plan of my sql query. But on one database, the cardinality of one PK index access upon one table is 27(cost=2,card=27,bytes=756) (table rows 263758) and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows 351173). so, on one DB the sql query took 300ms, one the other, it took 5 seconds! Any advise is highly appreciated. thanks, Kevin Wang Database Administrator Vivonet Canada Inc. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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 wang 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: Nicoll, Iain (Calanais) 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: Seefelt, Beth 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: Re[2]: stopiing write to listener.log
erm. to Shibu. I forgot the smiley. It was only a joke !!! -Original Message- Sent: 07 February 2002 13:56 To: Multiple recipients of list ORACLE-L Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off. Dick Goulet Reply Separator Author: Shibu [EMAIL PROTECTED] Date: 2/7/2002 5:14 AM Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 A : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi peter /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I have thousands of connection in mynbsp;d bnbsp;andnbsp; listener.log is growing very fastly. Inbsp; wantnbsp; to flush it manauallynbsp; every time/FONT/DIV DIVFONT face=Arial size=2I want to either stop it or flush it automatically .My db is 8.1.7 on win2k/FONT/DIV DIVFONT face=Arial size=2Do u h ave any solution for this ?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2regards,/FONT/DIV DIVFONT face=Arial size=2shibu/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, February 07, 2002 5:28 PM/DIV DIV style=FONT: 10pt arialBSubject:/B RE: stopiing write to listener.log/DIV DIVBR/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2Shibu,/FONT/SPAN/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2What do you really want?/FONT/SPAN/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log/SPAN/FONT/FONT /F ONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You could redivert this to /dev/null however this defeats the point./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You can rename it every day and archive off after 14 days./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002/SPAN/FONT/FONT/FONTnbsp;/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002User Failing to connect like/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Microsoft Transaction Server/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Look on the metalink/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Establish a grant to DBA_PENDING_TRANSACTIONS/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002HTH/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Peter/SPAN/FONT/FONT/FONT/DIV DIVSPAN class=843013411-07022002/SPANFONT face=Tahoma size=2-Message
Re: Scrolling Sideways in SQL*Plus
set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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).
SQL Insert question
Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table between softwares and licences cols= id, licence_id, software_id i want to populate this table with the ids from softwares and licences, so that if joined together 1 row would reflect a row in the old table sierras. What query can i write for this?? hope all that makes sense! regards IA -- 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:RE: Migration utility from 7.3.4 to 9i ??
Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- 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). -- 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: svrmgrl
You also need to be an administrator. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you can get. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 8:09 AM Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Re: Scrolling Sideways in SQL*Plus
Hi, I set the linesize larger and the buffer etc.. I do get the scrollbar and there is data to the right of the screen, but the scrollbar just won't work HTH Jack Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 07-02-2002 15:08:33 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
RE: RE: Migration utility from 7.3.4 to 9i ??
Hi Dick, According to the 9i Migration Utility Guide, the Mig Utility that comes with 9i will migrate 7.3.x database to 9i directly. Unfortunately we had no 7.3.4 database to migrate to 9.0.1. So I have not had a chance to test it myself. We migrated several 7.3.x database to 8.x using Mig Util without any problems. Of course, one can always use export/import for such things. - Kirti -Original Message- Sent: Thursday, February 07, 2002 8:22 AM To: Deshpande; Kirti; Multiple recipients of list ORACLE-L Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- 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: SQL Insert question
You could create a view across these two tables to give you the info you need. Cheers, Kev. -Original Message- Sent: 07 February 2002 14:29 To: Multiple recipients of list ORACLE-L Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table between softwares and licences cols= id, licence_id, software_id i want to populate this table with the ids from softwares and licences, so that if joined together 1 row would reflect a row in the old table sierras. What query can i write for this?? hope all that makes sense! regards IA -- 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: Thomas, Kevin 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: MC/Serviceguard vs Sun Clusters
On Thu, Feb 07, 2002 at 06:00:04AM -0800, [EMAIL PROTECTED] wrote: Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet I have been very pleased with standby stability, but find it a little awkward wrt maintenance as availability demands increase. I have not done AR yet, but hope to test this soon. Has anyone got warm and fuzzy with this technology? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Re[2]: stopiing write to listener.log
Nice one, although the pipe still sounds interesting. Peter -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:56 À : Multiple recipients of list ORACLE-L Objet : Re[2]: stopiing write to listener.log Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off. Dick Goulet Reply Separator Author: Shibu [EMAIL PROTECTED] Date: 2/7/2002 5:14 AM Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 A : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi peter /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I have thousands of connection in mynbsp; dbnbsp;andnbsp; listener.log is growing very fastly. Inbsp; wantnbsp; to flush it manauallynbsp; every time/FONT/DIV DIVFONT face=Arial size=2I want to either stop it or flush it automatically .My db is 8.1.7 on win2k/FONT/DIV DIVFONT face=Arial size=2Do u h ave any solution for this ?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2regards,/FONT/DIV DIVFONT face=Arial size=2shibu/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, February 07, 2002 5:28 PM/DIV DIV style=FONT: 10pt arialBSubject:/B RE: stopiing write to listener.log/DIV DIVBR/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2Shibu,/FONT/SPAN/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2What do you really want?/FONT/SPAN/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log/SPAN/FONT/FONT /F ONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You could redivert this to /dev/null however this defeats the point./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You can rename it every day and archive off after 14 days./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002/SPAN/FONT/FONT/FONTnbsp;/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002User Failing to connect like/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Microsoft Transaction Server/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Look on the metalink/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Establish a grant to DBA_PENDING_TRANSACTIONS/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002HTH/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN
RE: Slightly OT: PVCS Tracker 7.0 Backup Recovery Question
You know, not to cause you to worry but I have had issues with Tracker databases. In one case I could not export fully successfully. I worked with Oracle for about a week to try and get to the cause (I don't think I had their brightest working with me). Finally, Oracle said to rebuild the database. I am like How, I can't export the f*n data. Turns out I got enough out of it that I was ok. Manually reproduced the rest. -Original Message- Bruce (CALBBAY) Sent: Wednesday, February 06, 2002 5:08 PM To: Multiple recipients of list ORACLE-L David, Can simple suggestions initially that may isolate the problem: Does the database run on Sun or on something else? - I'm willing to learn but I only knew of the lite version on NT. Can you connect to the database using SQLPlus and a DBA user and specifying the SID (ie a Net8 connection) If so, what does select * from v$version tell you - this will confirm the Oracle version If so, can you select from application tables within the database If a Net8 connection doesn't work, (assuming the DB is on Unix) can you telnet to the Unix box, set your oracle_sid and then try to connect If this works but the Net8 connection didn't maybe there is a listener issue. You mention the alert log - it would be useful to see the last 30 or so lines in the alert log If you can connect to the database, the command show parameter dump should tell you the location of the alert log (parameter name background_dump_dest) show parameter dump will also tell you the user dump destination (parameter user_dump_dest) - are there any new files in the user dump directory and if so what do they contain You mention you ran out of disk space - has that been fixed now? Depending on what the above finds, maybe the database might need to be restarted or maybe the listener. I'm sure others will have many suggestions. HTH, Bruce Reardon -Original Message- Sent: Thursday, 7 February 2002 11:19 Hi List, My work group is using PVCS Tracker tool version 7.0 from Merant which tracks development defects, and runs on a lite version of Oracle 8i. Currently all users who login to PVCS receive the message: User cannot retrieve data records. We believe that a possible cause could be that we ran out of disk space, which may have caused a data integrity violation. This software is running on a Sun Unix server. Any suggestions such as viewing the Alert file would be helpful. Please be easy, I'm a first timer and I've only taken the PL/SQL and Admin and Architecture classes. Thanks, David Harris Web Technology Verizon Communications -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: svrmgrl
see? security :) --- àãø_éçéàì [EMAIL PROTECTED] wrote: You also need to be an administrator. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Subject:Re: svrmgrl It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you can get. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 8:09 AM Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the
Re: SQL Insert question
[EMAIL PROTECTED] wrote: Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table between softwares and licences cols= id, licence_id, software_id i want to populate this table with the ids from softwares and licences, so that if joined together 1 row would reflect a row in the old table sierras. What query can i write for this?? hope all that makes sense! regards IA insert into link_table (licence_id, software_id) select l.id, s.id from softwares s, licences l, sierras o where l.licence_ref = o.licence_ref and l.renewal_data = o.renewal_data and s.regno = o.regno and s.platform = o.platform (in case you would have the same regno on several platforms :)). I don't see why you need any 'id' column in the link table. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: RMAN full backup Vs Incremental level 0
You have to have an incremental level 0 in order to restore you database. If you are going to do backups once daily then you should do a level 0 one the first day of your cycle and then incremental backups after that. There are many levels of incremental and you should read about them to find out which would be right for your operation. If you have time to do a level 0 each day then that would be the best way. We used to to do a level 1 after users went home and before nightly processin and a level 0 each morning. We backup the archivlogs each time and put one days backups on tape. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 4:01 PM Hi I would like to know what are the advantages /disadvantages of full backups vs. incremental level 0 backups.Which one should be done if we decide to take backups only once daily? How is the recovery operation going to be affected if we choose either? for e.g if i decided to do incremental level 0 backups daily ,and if recovery is needed, then will i be able to restore the level 0 incremental and recover till the current point in time? Is there any other issue which would help decide whether full backups or incremental level 0 backups are better? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Instream SQL
#/bin/ksh sqlplus -s / EOF select 'x' from dual; exit; EOF Robert Pegram Oracle DBA --- Smith, Ron L. [EMAIL PROTECTED] wrote: I have a batch script running on Unix and I need to call a short SQL script (3 or 4 lines). Can someone show me the syntax to execute an inline SQL session so I can have all the code in one script? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram 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: JDBC errors?
Title: JDBC errors? When we had a similar problem it was cause of the JDBC driver that was being used. They had to upgrade from the one we had been using to connect to previous versions of the database. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marin DimitrovSent: Thursday, February 07, 2002 1:03 AMTo: Multiple recipients of list ORACLE-LSubject: Re: JDBC errors? I am getting weird results while trying to connect via jdbc to an Oracle 817 db on Windows 2000. I can connect via ODBC, but not JDBC, any ideas? is the weird result accompanied by an error message?
RE: MC/Serviceguard vs Sun Clusters
Actually, the heartbeat has been the biggest pain in the but of ServiceGuard. Its caused 99.99% of the failures. Granted once it was a failed network card. All in all though, I have been pretty happy with ServiceGuard. And ours is dedicated and protected:-) -Original Message- [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 6:00 AM To: Multiple recipients of list ORACLE-L Rama, We did the MC/ServiceGuard thing some years ago. Worked well, after our SA rebuilt the servers from ground 0. Adding it on to an existing server is ok, but somewhat unstable. One item to be VERY careful of. The heartbeat cable, in our case a ethernet thin line, needs to be on a dedicated link, preferably a purchased vs. custom made cable, and protected from accidental disconnect. Ours got disconnected by a contractor working in the computer room because it was in his way. The resulting reboot of the backup server and forcible takeover of the disk farm absolutely destroyed the database. We had more file corruption than I ever could have imagined. Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet Reply Separator Author: Rama Malladi [EMAIL PROTECTED] Date: 2/6/2002 5:23 PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DLL question
Okay, I can't find where this is documented. What .dll corresponds to ora805.dll in 8.1.6? Better yet, where is that documented? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export/import errors
I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI . importing FINANCE's objects into FINANCE . importing CIM's objects into CIM . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-9: abnormal end of export file IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.POST_IMPORT; END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors I'm looking in the fine manuals but not finding much. Any info would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Scrolling Sideways in SQL*Plus
try exiting sql plus and login in again then set the linesize 1000 (e.g.) first before you run anything else [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:33:40 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi, I set the linesize larger and the buffer etc.. I do get the scrollbar and there is data to the right of the screen, but the scrollbar just won't work HTH Jack Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 07-02-2002 15:08:33 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de
RE: stopiing write to listener.log
Peter, How do you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't remember now the parameter name that I have to set in the listener.ora (some levl=16 or something like that ?) thanks Santi -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 07, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: stopiing write to listener.log Shibu, OK so I now understand a little better your need. Of course there is listener OFF (logging_listener=off) As I said this really does defeat the point. Their are two approaches that spring to mind. Log Rotation or writing to a pipe. Log Rotation: Every x hours stop the listener, rename the file, start the listener You can then do stats on normal connections and save just the error and startups et al ... Writing to a pipe: Would mean that you create a pipe alert_SID.ora and have a process that would read from the pipe everything but normal connections. The disadvantages are - that you may not be able to do this on your NT box. - you lose all your stats of cnxs Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 14:15À: Multiple recipients of list ORACLE-LObjet: Re: stopiing write to listener.log Hi peter I have thousands of connection in my dband listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 11:38À: Multiple recipients of list ORACLE-LObjet: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
Remote Compromise in Oracle
The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Oracle Remote Compromise Systems Affected: Oracle 9, 8 Platforms: All Operating Systems Severity: High Risk Vendor URL: http://www.oracle.com/ Author: David Litchfield ([EMAIL PROTECTED]) Date: 6th February 2002 Advisory number: #NISR06022002A Advisory URL: http://www.nextgenss.com/advisories/oraplsextproc.txt Does Oracle Corp have a response on this? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
What impacts index build times on partitioned tables?
We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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: SQL Insert question
Im afraid i cant answer that question Stephane , as i dont have much to do with the design of this DB... thanks for the query... regards IA Stephane Faroult [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:53:32 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: [EMAIL PROTECTED] wrote: Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table between softwares and licences cols= id, licence_id, software_id i want to populate this table with the ids from softwares and licences, so that if joined together 1 row would reflect a row in the old table sierras. What query can i write for this?? hope all that makes sense! regards IA insert into link_table (licence_id, software_id) select l.id, s.id from softwares s, licences l, sierras o where l.licence_ref = o.licence_ref and l.renewal_data = o.renewal_data and s.regno = o.regno and s.platform = o.platform (in case you would have the same regno on several platforms :)). I don't see why you need any 'id' column in the link table. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MC/Serviceguard vs Sun Clusters
On Thu, Feb 07, 2002 at 07:18:34AM -0800, Kimberly Smith wrote: Actually, the heartbeat has been the biggest pain in the but of ServiceGuard. butt n. The larger or thicker end of an object: the butt of a rifle. My associates tell me I am an expert in this area... === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: export/import errors
Quick look in Metalink would suggest that this is a bug, I would report this to Oracle. I think there is a fix to it. Lee -Original Message- Sent: 07 February 2002 15:29 To: Multiple recipients of list ORACLE-L I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI . importing FINANCE's objects into FINANCE . importing CIM's objects into CIM . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-9: abnormal end of export file IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.POST_IMPORT; END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors I'm looking in the fine manuals but not finding much. Any info would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: What impacts index build times on partitioned tables?
I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: stopiing write to listener.log
1) lsnrctl stop RENAME %ORACLE_HOME%\NETWORK\LOG\LISTENER.LOG OLD.LOG lsnrctl start 2) see the sample in network\admin\sample. use trace_level=user (IMHO). Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Prakriteswar Santikary [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: stopiing write to listener.log Peter, How do you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't remember now the parameter name that I have to set in the listener.ora (some levl=16 or something like that ?) thanks Santi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 6:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: stopiing write to listener.log Shibu, OK so I now understand a little better your need. Of course there is listener OFF (logging_listener=off) As I said this really does defeat the point. Their are two approaches that spring to mind. Log Rotation or writing to a pipe. Log Rotation: Every x hours stop the listener, rename the file, start the listener You can then do stats on normal connections and save just the error and startups et al ... Writing to a pipe: Would mean that you create a pipe alert_SID.ora and have a process that would read from the pipe everything but normal connections. The disadvantages are - that you may not be able to do this on your NT box. - you lose all your stats of cnxs Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:15 À : Multiple recipients of list ORACLE-L Objet : Re: stopiing write to listener.log Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 À : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?àãø_éçéàì? 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).
[Q] MS Access to ORACLE migration guide line?
We plan to migrate some of our MS ACCESS database (97/2000) to ORACLE 8.1.7. Can anyone tell me where can I fond migration white paper or guide line? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: export/import errors
You have packages with status INVALID. Correct them and the errors will go away. Been there. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: export/import errors I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI . importing FINANCE's objects into FINANCE . importing CIM's objects into CIM . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-9: abnormal end of export file IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.POST_IMPORT; END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors I'm looking in the fine manuals but not finding much. Any info would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: export/import errors
Dave, Everyone gets these same errors. If you are not using replication then do not worry about these errors. If this is all you got then you are probably good to go. Rick Farnsworth, Dave DFarnsworth@AshleyfurnTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: export/import errors [EMAIL PROTECTED] 02/07/2002 10:28 AM Please respond to ORACLE-L I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI . importing FINANCE's objects into FINANCE . importing CIM's objects into CIM . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-9: abnormal end of export file IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.POST_IMPORT; END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors I'm looking in the fine manuals but not finding much. Any info would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SP2-0103: Nothing in SQL buffer to run.
Hi Oracle Gurus This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync. I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this : SQL @c:\general\ksg\ProcDisp.sql SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. |==| |Proc Name Proc Type | | Arguments Name Pos Data Type IN-OUT | |==| |ADDCHARGETYPE PROCEDURE | | | | TVCCHARGETYPE 1VARCHAR2 IN | | TVCGLNUMBER2VARCHAR2 IN | I would appreciate If you help me getting rid of following messages : SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. I want comments to be /* */ like only TIA Krishan Swarup Gupta __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com // /*Auther: Krishan S Gupta */ /*Date : 02-05-2002*/ /*Des : Procedure Descriptions*/ /*Oracle Ver: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production*/ // set serveroutput on size 10 spool c:\general\ksg\ProcDisp.txt declare print_line Varchar2(100); param_count number:=0; calls_count number:=0; called_countnumber:=0; cursor obj_cur (powner in all_arguments.owner%type, pobject_name in all_arguments.object_name%type) is select distinct owner, object_name, package_name, argument_name, position, sequence, data_type, in_out from all_arguments where owner = powner and object_name = pobject_name order by owner, object_name, position; begin dbms_output.put_line('|==|'); dbms_output.put_line('|Proc Name Proc Type |'); dbms_output.put_line('| Arguments Name Pos Data Type IN-OUT |'); dbms_output.put_line('|==|'); for r_cur_obj in (select distinct owner,name,type from all_source where owner = 'TC' and type in ('PROCEDURE','FUNCTION')) loop print_line := '|' || rpad(r_cur_obj.name,30,' ') || rpad(r_cur_obj.type,12,' ') || '|'; dbms_output.put_line(print_line); dbms_output.put_line('| |'); for r_cur_param in obj_cur(r_cur_obj.owner, r_cur_obj.name) loop print_line := '| '; if (r_cur_obj.type = 'FUNCTION' and r_cur_param.POSITION = 0) THEN print_line := print_line || rpad('Return Type',35,' ') || ' ' || rpad(r_cur_param.DATA_TYPE,30,' ') || ' ' || rpad(r_cur_param.IN_OUT,8,' ') || '|' ; else print_line := print_line || rpad(r_cur_param.ARGUMENT_NAME,30,' ') || ' ' || rpad(to_char(r_cur_param.POSITION),4,' ') || ' ' || rpad(r_cur_param.DATA_TYPE,30,' ') || ' ' || rpad(r_cur_param.IN_OUT,8,' ') || '|' ; end if; dbms_output.put_line(print_line); end loop; dbms_output.put_line('| |'); /* procedure or functions it calls */ calls_count := 0; for r_dep in (select * from all_dependencies
Re: Remote Compromise in Oracle
Ray, Yes take a look at http://otn.oracle.com/deploy/security/alerts.htm they have workarounds posted with yesterdays date. ...JIM... [EMAIL PROTECTED] 2/7/02 9:55:18 AM The post here yesterday on this topic was underwelming: NGSSoftware Insight Security Research Advisory Name:Oracle Remote Compromise Systems Affected: Oracle 9, 8 Platforms: All Operating Systems Severity: High Risk Vendor URL: http://www.oracle.com/ Author: David Litchfield ([EMAIL PROTECTED]) Date: 6th February 2002 Advisory number: #NISR06022002A Advisory URL: http://www.nextgenss.com/advisories/oraplsextproc.txt Does Oracle Corp have a response on this? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: James Howerton 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: export/import errors
I just opened a low level TAR on these errors just to make sure my data is ok. Thanks, Dave -Original Message- Sent: Thursday, February 07, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Quick look in Metalink would suggest that this is a bug, I would report this to Oracle. I think there is a fix to it. Lee -Original Message- Sent: 07 February 2002 15:29 To: Multiple recipients of list ORACLE-L I just did my first export/import and of course I got some errors at the very end of my import log file. My problem is I don't have a clue as to what they are. Below is the last few lines of the import log file About to enable constraints... . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI . importing FINANCE's objects into FINANCE . importing CIM's objects into CIM . importing DIS's objects into DIS . importing DRV's objects into DRV . importing EDI's objects into EDI IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_REPCAT_MIG_INTERNAL, line 726 ORA-06512: at SYS.DBMS_REPCAT_MIG, line 86 ORA-06512: at line 1 IMP-9: abnormal end of export file IMP-00017: following statement failed with ORACLE error 4068: BEGIN SYS.DBMS_REPCAT_MIG.POST_IMPORT; END; IMP-3: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body SYS.DBMS_REPCAT_SNA_UTL has errors I'm looking in the fine manuals but not finding much. Any info would be appreciated. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Farnsworth, Dave 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: MC/Serviceguard vs Sun Clusters
I'll second this. I worked with Sun a few years ago at another place. Here, we're an HP shop with 2 OPS clusters (2 node and 4 node). We finally moved our straggler Compaq cluster to HP a couple of months ago. I'll caveat by saying that we do have a couple of well seasoned SAs and DBAs so it's all been pretty easy to setup and we've found it to be very reliable. hth, ~Ruth Beware of the lollipop of mediocrity. One lick and you'll suck forever. -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 8:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: MC/Serviceguard vs Sun Clusters Stay with HP Serviceguard! From experience, I rank HA solutions in this order: 1. HP serviceguard - easy and it works. 2. IBM HACMP - do it the way IBM wants it and it works. 3. Sun Cluster - get a high paid consultant to set it up and have them come back to change it :) Better yet, go with Veritas Trusted Cluster. Just my $.02. I know some Sun ppl on this list will disagree, but if they worked in a HP env maybe not :) Gene [EMAIL PROTECTED] 02/06/02 08:23PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi 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: Gene Sais 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: Dejam, Ruth 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: What impacts index build times on partitioned tables?
Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie àãø éçéàì adary@mehish. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.il cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTECTED] om 02/07/02 10:20 AM Please respond to ORACLE-L I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: SP2-0103: Nothing in SQL buffer to run.
Title: RE: SP2-0103: Nothing in SQL buffer to run. Try : SQL start c:\general\ksg\ProcDisp.sql Rivaldi -Original Message- From: Krishan Gupta [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:32 AM To: Multiple recipients of list ORACLE-L Subject: SP2-0103: Nothing in SQL buffer to run. Hi Oracle Gurus This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync. I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this : SQL @c:\general\ksg\ProcDisp.sql SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. |==| |Proc Name Proc Type | | Arguments Name Pos Data Type IN-OUT | |==| |ADDCHARGETYPE PROCEDURE | | | | TVCCHARGETYPE 1 VARCHAR2 IN | | TVCGLNUMBER 2 VARCHAR2 IN | I would appreciate If you help me getting rid of following messages : SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. SP2-0103: Nothing in SQL buffer to run. I want comments to be /* */ like only TIA Krishan Swarup Gupta __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com
Re: Instream SQL
Try this: sqlplus -s EOF userid/password sql statements here ... ... EOF Venkat Somusetty Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Venkat Somusetty 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).
Breakable 9i ?
TechRepublic: www.techrepublic.com BUGS BUST OPEN 'UNBREAKABLE' ORACLE 9i TODAY'S TOP STORY U.K. security researcher David Litchfield is expected to unveil several security flaws in Oracle's flagship 9i database software at the Black Hat Windows Security Briefings conference in New Orleans Friday. Oracle has touted its 9i database as unbreakable, but Litchfield claims that last December he uncovered several flaws that could leave servers loaded with the 9i software vulnerable to hacker control. Litchfield's assertions have resulted in criticism of Oracle, whose marketing campaign for the 9i database product focused on its secure status. http://zdnet.com.com/2100-1104-831204.html snip -- 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: deleting a datafile on OPS
It isn't an OPS issue, you can't drop a datafile without dropping the entire tablespace. This has never been possible. -Original Message- Sent: Tuesday, January 29, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Hello list, Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle Parallel Server (OPS) According to Oracle, I should be able to drop a datafile that has no data written to it, but I can not. Neither DBA studio (the garbage can stays 'grayed'), nor the command line (alter tablespace, with the DROP clause) works. I had immediately taken the datafile offline (I had typed sbplus_x18.dbf instead of sbplus_x16.dbf for the datafile name to use in case you are wondering how this turn of events happened in the first place), and checked all of the books, and Meta-Link. I tried a test on a non-production machine, no go; even taking the tablespace off-line first makes no difference. And of course I get errors as one node can not see the other nodes sbplus_x18.dbf datafile. I tried an 'alter system check datafiles' to see if this would make the other node happy (as the datafile is now off-line, this may work), but I need a solution other than exporting the data, rebuilding the tablespace, then importing the export. Anyone ever come across this issue ? Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Has anyone installed 9i On Win XP Pro
Title: Message Just wanted to know if anyone has created a database on Win XP Pro using Oracle 9i.Gautam
RE: Unorthodox 8i install/upgrade
I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went to patch 8.1.7, I untarrred the patch onto my NFS mount, then I could apply the patch to any of my systems from one central location. Darren -Original Message- Sent: February 6, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Browett, Darren 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).
DB File Sequential Reads
Hi Fellas, An old SIEBEL application running against a 7.3.4 database on NT. There are performance issues. A query which runs with in no time on the QA box, takes 2 minutes on the production. Optimizer is set to RULE. The access plan is the same on both the boxed for the query. On Production, V$waitstat showed me lots of waits for 'data blocks', v$system_event showed me waits for 'db file sequential reads' and 'buffer busy waits'. From v$session_wait, I tracked this down to a single table. v$filestat shows me lot of physical reads for the disk where the datafile holding that table resides. The same table is spread across two datafiles on different drives on the QA, whereas its spread across a single drive on Production. Increasing the free lists on the table is also an option I am considering. What I would also like to know is: 1. How do you monitor I/O activity on an NT Server? Something like sar -d or iostat on Unix? 2. The status is 'WAITING' in v$session_wait, but seconds_in_wait is 0. Is it because TIMED_STATISTICS is set to FALSE? Thank You for your help. Raj -- 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: SP2-0103: Nothing in SQL buffer to run.
Krishan Gupta wrote: Hi Oracle Gurus This might be very silly problem for you gyus, but I am really geting headache. I suppose today my mind is not working in sync. I am attatching the script which i wrote. When I try to execute on sql promp, I get the result like this : SQL @c:\general\ksg\ProcDisp.sql Krishan, As you must know a '/' in first position of a line reruns the SQL command which was last run (the contents of the 'SQL buffer') - or issues the message you have if no SQL command has been run. Some versions of SQL*Plus seem to check for a '*' behind (no such problem on my 8.1.7), some do not, and that's what you seem to have ... Solution ? Do not start the comment in column 1 ... If it still doesn't work, nothing prevents you from writing -- /* This is a comment */ (I guess you are using some tool to extract comments and generate doc ?) -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: deleting a datafile on OPS
Jay is absolutely right. Paul, if you would like to know more about your datafile issue go to 'metalink.oracle.com' and check out 'Note:111316.1', which will explain everything about datafile re-org. --- Miller, Jay [EMAIL PROTECTED] wrote: It isn't an OPS issue, you can't drop a datafile without dropping the entire tablespace. This has never been possible. -Original Message- Sent: Tuesday, January 29, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Hello list, Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle Parallel Server (OPS) According to Oracle, I should be able to drop a datafile that has no data written to it, but I can not. Neither DBA studio (the garbage can stays 'grayed'), nor the command line (alter tablespace, with the DROP clause) works. I had immediately taken the datafile offline (I had typed sbplus_x18.dbf instead of sbplus_x16.dbf for the datafile name to use in case you are wondering how this turn of events happened in the first place), and checked all of the books, and Meta-Link. I tried a test on a non-production machine, no go; even taking the tablespace off-line first makes no difference. And of course I get errors as one node can not see the other nodes sbplus_x18.dbf datafile. I tried an 'alter system check datafiles' to see if this would make the other node happy (as the datafile is now off-line, this may work), but I need a solution other than exporting the data, rebuilding the tablespace, then importing the export. Anyone ever come across this issue ? Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shantanu Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle and Document Management: any real stories?
- Original Message - TOPIC: Oracle and Document Management: any real stories or information? Does anyone have any experience with Oracle and Document Management that they're willing to share? [I'm cross-posting to Oracle Apps and Oracle Server.] check Oracle Internet File System - it provides check-in/check-out and versioning functionality, access control, several interfaces to access the content http://technet.oracle.com/products/ifs/content.html hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Has anyone installed 9i On Win XP Pro
Title: Message I did, but I haven't done much with it yet. I think I used version 9.0.1.0.0, not the current release. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 07, 2002 9:21 AMTo: Multiple recipients of list ORACLE-LSubject: OT: Has anyone installed 9i On Win XP Pro Just wanted to know if anyone has created a database on Win XP Pro using Oracle 9i.Gautam
RE: export/import on the same server
Rachel and everyone else, Thanks much for your help in helping me do my first import/export. It actually worked the first time like I hoped it would. I went with the import by user schema. Got a couple of errors at the end of my import on some Replication procedures that are invalid but I don't use replication(yet). I will fix those errors when time permits. Again, thanks to all. Dave -Original Message- Sent: Tuesday, February 05, 2002 1:25 PM To: Multiple recipients of list ORACLE-L yes that should work because you aren't doing a full db import which is the only way you can destroy the files. I might do ignore=y as well are you going to drop the users first, drop just their objects or only truncate the objects? if you drop the users, you will need to recreate them or the import will load everything into mylogin for safety's sake, I'd probably run the import once for each user, and have fromuser= and touser= in the parfile --- Farnsworth, Dave [EMAIL PROTECTED] wrote: Thanks to everyone for their help. Since these are the same schema I see no reason why to do a full import. Anyway, I am in learning mode and need to learn about possible parameters to use. I am going to do an owner import from my full export file since I only need a few of the owners schema's. I'll first creat my PARFILE like FILE=C:\my_export_file.dmp FROMUSER=(dorkboy,geekgirl,sheep_lover,monkey_spanker) GRANTS=Y INDEXES=Y Then do a SET ORACLE_SID=my_test_db then IMP my_login/my_dirty_pwd parfile=my_parfile.dat My login to test is different from my live database login so I should be covered there. Does this look like it will work so that it will not try to write to the datafiles of my live database? Remember, the file I am importing into my test database is an export from my live database which both reside on the same server but have their data on different drives. Thanks much everyone, Dave -Original Message- Sent: Tuesday, February 05, 2002 10:10 AM To: Multiple recipients of list ORACLE-L unless I am misreading the 9i docs (see below) this has nothing to do with transportable tablespaces If you use DESTROY=Y and a full database import, Oracle will overwrite the datafiles as defined in the create tablespace statement that is in the dump file. It's the equivalent of issuing: create tablespace tbsname datafile 'prod file name' reuse; From the 9i Utilities manual: Specifies whether or not the existing datafiles making up the database should be reused. That is, specifying DESTROY=y causes Import to include the REUSE option in the datafile clause of the CREATE TABLESPACE statement, which causes Import to reuse the original database's datafiles after deleting their contents. Note that the export file contains the datafile names used in each tablespace. If you specify DESTROY=y and attempt to create a second database on the same system (for testing or other purposes), the Import utility will overwrite the first database's datafiles when it creates the tablespace. In this situation you should use the default, DESTROY=n, so that an error occurs if the datafiles already exist when the tablespace is created. Also, when you need to import into the original database, you will need to specify IGNORE=y to add to the existing datafiles without replacing them. --- àãø_éçéàì [EMAIL PROTECTED] wrote: Hello Dave I checked the docs. It seems to me that destroy is associated with transport_tablespaces. If you transport tablespaces destroy=y means overwrite old data files with the same name. In regular import the @database set the target database. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Tue, February 05, 2002 4:21 PM To: Multiple recipients of list ORACLE-L Subject: export/import on the same server I have a question on the export/import utility. I have my live(PROD) and test(TEST) databases are on the same server. These are basically the same schemas except that the data in TEST is old and that the datafiles for PROD are on I: drive and the datafiles for TEST are on E: drive. My question is, since these are on the same server do I have to worry about which data files will be written to during the import. For example; I do a full export of my PROD database. When I do my import into my TEST database will the data automatically go to E: drive or will it still be pointing to I: drive? I am reading the Import section of the fine manual but am a bit confused on the datafiles part of it when doing a full export/import. Do I need to use the DESTROY=N parameter? I am new to this utility but want to learn it. I am reading the manuals and some other reading material but still am not clear on this. I
RE: MC/Serviceguard vs Sun Clusters
Title: RE: MC/Serviceguard vs Sun Clusters Were you only running a single heartbeat connection? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 9:00 AM To: Multiple recipients of list ORACLE-L Subject: Re:MC/Serviceguard vs Sun Clusters Rama, We did the MC/ServiceGuard thing some years ago. Worked well, after our SA rebuilt the servers from ground 0. Adding it on to an existing server is ok, but somewhat unstable. One item to be VERY careful of. The heartbeat cable, in our case a ethernet thin line, needs to be on a dedicated link, preferably a purchased vs. custom made cable, and protected from accidental disconnect. Ours got disconnected by a contractor working in the computer room because it was in his way. The resulting reboot of the backup server and forcible takeover of the disk farm absolutely destroyed the database. We had more file corruption than I ever could have imagined. Consequently we abandoned ServiceGuard are going to standby databases instead. Dick Goulet Reply Separator Author: Rama Malladi [EMAIL PROTECTED] Date: 2/6/2002 5:23 PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unorthodox 8i install/upgrade
We have followed the HP model and set up a software distribution (HP calls it a Software Depot) node. We copy the CDs into appropriate directories as the Oracle administrator. Then we allow NFS mounts of the SD node file systems and install from the SD node. We also are running Samba here and install the Oracle clients from this node as well. Works like a charm. Yes, it's a little slower than a local CD, but it's much easier to use and administrate. Between distributions for HP, Solaris, and Windows, and versions 7.x, 8.x, 8i, 8iR2, 8iR3 and 9i, I was a more a librarian than DBA. When we install, each ORACLE_HOME is a different mount point (on UNIX). We use the OFA model, slightly modified. Individual mount points look like this: Volume Group Mount Point --- vgora /ofa/u01/app/oracle vgora /ofa/u01/app/oracle/product/x.x.x vgora /ofa/u01/app/oracle/product/y.y.y vgsid1/ofa/u01/oradata/SID1 vgsid1/ofa/u02/oradata/SID1 vgsid2/ofa/u01/oradata/SID2 vgsid2/ofa/u02/oradata/SID2 (etc etc etc)...you get the picture, right? It makes refreshing easier, too. You can down a single database, say SID1, and use cpio to copy the files to the refresh system, and not hinder the running of the other SIDs. I wish I could claim credit for this strategy 'cause it works well for us, but it's been a team effort and is still very much a work in progress. Just my $0.02. Mike -Original Message- Sent: Thursday, February 07, 2002 9:33 AM To: Multiple recipients of list ORACLE-L I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went to patch 8.1.7, I untarrred the patch onto my NFS mount, then I could apply the patch to any of my systems from one central location. Darren -Original Message- Sent: February 6, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
Advanced Queueing
Hi - Is anybody using Oracle's AQ feature with MQ Series? If so, please contact me, I have some questions on what is needed - ie. Gateway from MQ, Gateway from Oracle. Thank you! Lisa Yttri IBM Global Services Oracle Database Administration (262) 636-6797 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa 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: What impacts index build times on partitioned tables?
Hello Cherie Your talk about other applications made me think that you allowed the DB to be accessed during this time. Anyway, I think that you need to monitor CPU, I/O, page faults and all the other nice things in the machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 6:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: What impacts index build times on partitioned tables? Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie adary@mehish. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.il cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTECTED] om 02/07/02 10:20 AM Please respond to ORACLE-L I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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). Wz?^!r9,B?m??(??a 0!z1!*zW(r?...j?#^ +'''?|9?E9?NuI??( b~?nX{^wi???j)b?!9Q2zW???+j)b b???-g'?^pN?^-X'???F?z?N ^r[yb(?)P?@ azvz?j)b b??z~bk?axq =?(tm)?~wf?G -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Unorthodox 8i install/upgrade
I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't need to phone up a DC operator and have the CD put into the tray. Richard -Original Message- Sent: Thursday, February 07, 2002 12:33 PM To: Multiple recipients of list ORACLE-L I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went to patch 8.1.7, I untarrred the patch onto my NFS mount, then I could apply the patch to any of my systems from one central location. Darren -Original Message- Sent: February 6, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Browett, Darren 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: Ji, 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).
TFM
We are getting ready to sign a contract with Oracle for Financials. I have been looking for the manuals so I can read up on what their suggestions are for installation, tuning... for the 3000+ tables and associated other back end stuff... anyone know where they can be found. I can find some on Oracle Apps Net, but not really the kind of stuff I am looking for... are their other? April Wells Oracle DBA Corporate Systems Amarillo Texas begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE %;G0N#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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: STATSPACK impact?
REF: PG 3 MARCH/APRIL 2000 DBAs can set specific level of running statspack. Level 0 Level 5 does not impact resource usage that much so that you notice the difference. But Oracle warns not to run Level 10 cause it is marked as resource intensive. Level 10 Statspack collects all statistics from level 0 and level 5 as well as child-latch information. Level 5 is the default. Hope this helps. Shaibal From: Joe Raube <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: STATSPACK impact? Date: Wed, 06 Feb 2002 13:01:36 -0800 I have run it as frequently as once per hour, often times just 2 or 3 times per day - morning, noon, close of business. I have never seen any performance impact, and I don't believe there will be any unless you change the default level of statistics gathering. -Joe On Wed, 06 Feb 2002 12:47:48 -0800 Thomas Jeff <[EMAIL PROTECTED]>wrote: Just curious, but if your shop uses STATSPACK, could you tell me how frequently you run it, particularly in your OLTP databases; and whether you've noticed any performance issues with generating frequent STATSPACK snapshots? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba _ 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: Joe Raube 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). MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder 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:RE: Migration utility from 7.3.4 to 9i ??
Dick, Even if you take export/import route it should be fine. As far as the rowid is concerned it should be the same as rowid in version 8. so logically there will be a conversion of the row-ids from older format(v 7.3.4) to the new format( v 8 or v 9), and nothing is needed to be done explicitly, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. I have not migrated to 9 from 7.3.4. Still on 8.1.7. Shaibal From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re:RE: Migration utility from 7.3.4 to 9i ?? Date: Thu, 07 Feb 2002 06:23:42 -0800 Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: "Deshpande; Kirti" <[EMAIL PROTECTED]> Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- 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). -- 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). MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder 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: Unorthodox 8i install/upgrade
Ditto here. Me too! Me too! Me too! Bambi. -Original Message- Sent: Thursday, February 07, 2002 1:05 PM To: Multiple recipients of list ORACLE-L I did the same thing too. One of the advantage is when all of my servers are at a data center physically located else where. I don't need to phone up a DC operator and have the CD put into the tray. Richard -Original Message- Sent: Thursday, February 07, 2002 12:33 PM To: Multiple recipients of list ORACLE-L I have installed 8.1.7 on a Tru64 5.1 system. I simply copied the CD's into separate directories on our NFS mounts, then logged into the system where I wanted to do the install, found the installer program, and ran it. I don't remember there being any problems. I did the same thing when I went to patch 8.1.7, I untarrred the patch onto my NFS mount, then I could apply the patch to any of my systems from one central location. Darren -Original Message- Sent: February 6, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Environment: Tru64 V5.1 on Alpha 4100/8100 ORA 8.0.6 I have upgraded our sandbox system to 8.1.7.2 last month, and will be upgrading several other machines shortly. The problem is the stage ORACLE_HOME mount points have insufficient disk space and our systems folks have told me that it will be very difficult to add any more space to these mount points. There are other mount points that currently have enough space, so my questions are, has anyone done a 8i/UNIX install/upgrade from a directory other than under /oracle/stage, or used a symbolic link to download the CD's contents to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Browett, Darren 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: Ji, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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: question on EXPLAIN_PLAN
Hi, Rafiq Thank you for your advise, and thanks everyone, the handsome guys, reply me. You are right, it seems like a High Water Mark problem, after lots of other try, finally I drop that table and re-create that table, copy data, build PK index, analyzed in same way as before, and test the performance, the SQL statement is as fast as we expected. The select count(*) from table_name is still slower than the good guy, but much faster than before. As a problem, it is fixed now. But I still don't understand how can the stupid HWM make such a slow-down on performance? I did lots of tests, I am sure there is nothing to do with analyze,SGA,session_wait,resource. On both two databases, that table and its PK index use one extent on different tablespace on different datafile. Actually, the table in the good performance database has the same HWM as the bad performance buy. I mean, re-create table can fix the problem, but, the problem is not only with the HWM. I will do some further investigation. thanks a lot, Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 2:18 PM Try to reduce High Water Mark on your table by creating as select a backup table truncate original table insert into original table from backup table... This is based on your info for full table scan...Please also rebuild indexes on that table and analyze table if you are on COST BASED.. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 06 Feb 2002 13:45:44 -0800 Hi, Bill You are right, there is really something to do with the index. I dropre-created that PK index, it became much faster, but after 5 minutes, it became slow again, and I am sure no records insert/delete/update happened. I dropre-created that indexes again, nothing happened this time, it is still slow! It is really weird! And I found on the bad performance database, a simplest query: select count(*) from table_namewill take 4 seconds! the explain_plan said it used cost-optimizer, using fast_full_index_scan on that PK index, what should I do with the index? I already tried to re-created the PK index. The bad performance database is on a super-box, 4 CPUs and more memory. the good performance one is on a normal box. And the table and index is analyzed at same way. thanks a lot for your reply. Kevin Wang - Original Message - From: Bill Zakrzewski To: kevin wang Sent: Wednesday, February 06, 2002 12:38 PM Subject: Re: question on EXPLAIN_PLAN Kevin, Have these indexes been rebuilt recently? If not, you may want to consider rebuilding the indexes. Not sure if this is your issue, but if you have inserted/deleted records from your tables over time, the index levels may have grown as well. ~ Bill Zakrzewski Senior Consultant Intactus Technology, Inc. - Original Message - From: kevin wang To: LazyDBA.com Discussion Sent: Wednesday, February 06, 2002 2:43 PM Subject: question on EXPLAIN_PLAN Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema structure, different data(but small difference of size). and even exactly same explain_plan of my sql query. But on one database, the cardinality of one PK index access upon one table is 27(cost=2,card=27,bytes=756) (table rows 263758) and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows 351173). so, on one DB the sql query took 300ms, one the other, it took 5 seconds! Any advise is highly appreciated. thanks, Kevin Wang Database Administrator Vivonet Canada Inc. MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kevin wang INET: [EMAIL PROTECTED] Fat City Network
RE: stopiing write to listener.log
SHibu, In lsnrctl, set log_status=off. Chuan Oracle DBA Transact Communication, Ltd. -Original Message- Sent: Thursday, 7 February 2002 9:38 PM To: Multiple recipients of list ORACLE-L Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang 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: MC/Serviceguard vs Sun Clusters
I'm amazed that failover doesn't seem to be any more robust or reliable than the first time I worked with it 8 years ago, on some platforms anyway. Jared On Thursday 07 February 2002 08:55, Dejam, Ruth wrote: I'll second this. I worked with Sun a few years ago at another place. Here, we're an HP shop with 2 OPS clusters (2 node and 4 node). We finally moved our straggler Compaq cluster to HP a couple of months ago. I'll caveat by saying that we do have a couple of well seasoned SAs and DBAs so it's all been pretty easy to setup and we've found it to be very reliable. hth, ~Ruth Beware of the lollipop of mediocrity. One lick and you'll suck forever. -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 8:18 AM To: Multiple recipients of list ORACLE-L Subject:Re: MC/Serviceguard vs Sun Clusters Stay with HP Serviceguard! From experience, I rank HA solutions in this order: 1. HP serviceguard - easy and it works. 2. IBM HACMP - do it the way IBM wants it and it works. 3. Sun Cluster - get a high paid consultant to set it up and have them come back to change it :) Better yet, go with Veritas Trusted Cluster. Just my $.02. I know some Sun ppl on this list will disagree, but if they worked in a HP env maybe not :) Gene [EMAIL PROTECTED] 02/06/02 08:23PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi 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: Gene Sais 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail 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: question on EXPLAIN_PLAN
Re the HWM causing a slowdown: A needle in a haystack is much easier to find when the haystack has been removed. Jared On Thursday 07 February 2002 13:06, kevin wang wrote: Hi, Rafiq Thank you for your advise, and thanks everyone, the handsome guys, reply me. You are right, it seems like a High Water Mark problem, after lots of other try, finally I drop that table and re-create that table, copy data, build PK index, analyzed in same way as before, and test the performance, the SQL statement is as fast as we expected. The select count(*) from table_name is still slower than the good guy, but much faster than before. As a problem, it is fixed now. But I still don't understand how can the stupid HWM make such a slow-down on performance? I did lots of tests, I am sure there is nothing to do with analyze,SGA,session_wait,resource. On both two databases, that table and its PK index use one extent on different tablespace on different datafile. Actually, the table in the good performance database has the same HWM as the bad performance buy. I mean, re-create table can fix the problem, but, the problem is not only with the HWM. I will do some further investigation. thanks a lot, Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 2:18 PM Try to reduce High Water Mark on your table by creating as select a backup table truncate original table insert into original table from backup table... This is based on your info for full table scan...Please also rebuild indexes on that table and analyze table if you are on COST BASED.. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 06 Feb 2002 13:45:44 -0800 Hi, Bill You are right, there is really something to do with the index. I dropre-created that PK index, it became much faster, but after 5 minutes, it became slow again, and I am sure no records insert/delete/update happened. I dropre-created that indexes again, nothing happened this time, it is still slow! It is really weird! And I found on the bad performance database, a simplest query: select count(*) from table_namewill take 4 seconds! the explain_plan said it used cost-optimizer, using fast_full_index_scan on that PK index, what should I do with the index? I already tried to re-created the PK index. The bad performance database is on a super-box, 4 CPUs and more memory. the good performance one is on a normal box. And the table and index is analyzed at same way. thanks a lot for your reply. Kevin Wang - Original Message - From: Bill Zakrzewski To: kevin wang Sent: Wednesday, February 06, 2002 12:38 PM Subject: Re: question on EXPLAIN_PLAN Kevin, Have these indexes been rebuilt recently? If not, you may want to consider rebuilding the indexes. Not sure if this is your issue, but if you have inserted/deleted records from your tables over time, the index levels may have grown as well. ~ Bill Zakrzewski Senior Consultant Intactus Technology, Inc. - Original Message - From: kevin wang To: LazyDBA.com Discussion Sent: Wednesday, February 06, 2002 2:43 PM Subject: question on EXPLAIN_PLAN Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema structure, different data(but small difference of size). and even exactly same explain_plan of my sql query. But on one database, the cardinality of one PK index access upon one table is 27(cost=2,card=27,bytes=756) (table rows 263758) and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows 351173). so, on one DB the sql query took 300ms, one the other, it took 5 seconds! Any advise is highly appreciated. thanks, Kevin Wang Database Administrator Vivonet Canada Inc. MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.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
Re: question on EXPLAIN_PLAN
Kevin, select count(*) from table_name This was the key on the basis of that I suggested this solution...Your Test definately don't have that high water mark... As regard still some slowness, check for number of extents and it is sizing...If more extents 'select counts' goes for full table scan and takes longer...If extents are rightly sized and minimum in numbers performance shall be better for select count Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 13:06:49 -0800 Hi, Rafiq Thank you for your advise, and thanks everyone, the handsome guys, reply me. You are right, it seems like a High Water Mark problem, after lots of other try, finally I drop that table and re-create that table, copy data, build PK index, analyzed in same way as before, and test the performance, the SQL statement is as fast as we expected. The select count(*) from table_name is still slower than the good guy, but much faster than before. As a problem, it is fixed now. But I still don't understand how can the stupid HWM make such a slow-down on performance? I did lots of tests, I am sure there is nothing to do with analyze,SGA,session_wait,resource. On both two databases, that table and its PK index use one extent on different tablespace on different datafile. Actually, the table in the good performance database has the same HWM as the bad performance buy. I mean, re-create table can fix the problem, but, the problem is not only with the HWM. I will do some further investigation. thanks a lot, Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 2:18 PM Try to reduce High Water Mark on your table by creating as select a backup table truncate original table insert into original table from backup table... This is based on your info for full table scan...Please also rebuild indexes on that table and analyze table if you are on COST BASED.. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 06 Feb 2002 13:45:44 -0800 Hi, Bill You are right, there is really something to do with the index. I dropre-created that PK index, it became much faster, but after 5 minutes, it became slow again, and I am sure no records insert/delete/update happened. I dropre-created that indexes again, nothing happened this time, it is still slow! It is really weird! And I found on the bad performance database, a simplest query: select count(*) from table_namewill take 4 seconds! the explain_plan said it used cost-optimizer, using fast_full_index_scan on that PK index, what should I do with the index? I already tried to re-created the PK index. The bad performance database is on a super-box, 4 CPUs and more memory. the good performance one is on a normal box. And the table and index is analyzed at same way. thanks a lot for your reply. Kevin Wang - Original Message - From: Bill Zakrzewski To: kevin wang Sent: Wednesday, February 06, 2002 12:38 PM Subject: Re: question on EXPLAIN_PLAN Kevin, Have these indexes been rebuilt recently? If not, you may want to consider rebuilding the indexes. Not sure if this is your issue, but if you have inserted/deleted records from your tables over time, the index levels may have grown as well. ~ Bill Zakrzewski Senior Consultant Intactus Technology, Inc. - Original Message - From: kevin wang To: LazyDBA.com Discussion Sent: Wednesday, February 06, 2002 2:43 PM Subject: question on EXPLAIN_PLAN Hi, guys The problem belows is really make me confused and gave me big trouble, is there someone can give me some hlep? I have two databses, same version(oracle 8.1.6),same O/S(win2000), same schema structure, different data(but small difference of size). and even exactly same explain_plan of my sql query. But on one database, the cardinality of one PK index access upon one table is 27(cost=2,card=27,bytes=756) (table rows 263758) and the other is 11706 (cost=3,card=11706,bytes=199002)( table rows 351173). so, on one DB the sql query took 300ms, one the other, it took 5 seconds! Any advise is highly appreciated. thanks, Kevin Wang Database Administrator Vivonet Canada Inc. MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq
Bitmap Indexes
Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone whole hog with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not taking all of our medication, as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes or, Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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:Breakable 9i ?
I really hate it when someone like Uncle Larry makes a claim like this. Sure enough that one claim will spur someone to find a hole that they can then rub into everyone's face. It's kind of like tossing lit matches at a can of gasoline, sooner or later your going to get burned. It's just a matter of time. Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 2/7/2002 9:01 AM TechRepublic: www.techrepublic.com BUGS BUST OPEN 'UNBREAKABLE' ORACLE 9i TODAY'S TOP STORY U.K. security researcher David Litchfield is expected to unveil several security flaws in Oracle's flagship 9i database software at the Black Hat Windows Security Briefings conference in New Orleans Friday. Oracle has touted its 9i database as unbreakable, but Litchfield claims that last December he uncovered several flaws that could leave servers loaded with the 9i software vulnerable to hacker control. Litchfield's assertions have resulted in criticism of Oracle, whose marketing campaign for the 9i database product focused on its secure status. http://zdnet.com.com/2100-1104-831204.html snip -- 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). -- 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: Oracle and Document Management: any real stories?
Internet File System Separate product, but free. Todd -Original Message- Hilary Sent: Thursday, February 07, 2002 11:21 AM To: Multiple recipients of list ORACLE-L TOPIC: Oracle and Document Management: any real stories or information? Does anyone have any experience with Oracle and Document Management that they're willing to share? [I'm cross-posting to Oracle Apps and Oracle Server.] The past 5 years, I've been hearing about how Oracle (1) is a document management system and/or (2) integrates quickly and easily with popular document management systems We've tried the usual approaches and can't get any lists or info from Oracle (Metalink, Forums, Tars, tech docs) as to details. The Forum messages (we're not the first) don't even get answered. Our records manager also has been sold on the idea that Oracle has magical document management capabilities (and that's why I'm writing to Oracle Apps also just in case one of those products IS the document management system!). I have researched a little each year. To date, I have concluded that Oracle COULD BE USED for document management, if N programmers create M lines of code. (Or the users learn SQL for BLOBS) Also I have concluded that if Oracle integrates with popular document management systems, either it is the base for the system (hidden under OEM relabeling) or it is only integrated if N programmers create a different M lines of code. (Or the users learn SQL for BLOBS) We are running Apps 11i, I'm the DBA and my users are trying to convice me that there's either some profile setting or ini param and all I have to do is hit that switch and we'll be operating a document management system and the users won't have to learn SQL for BLOBS to use it! Is that true or not? Stories, comments, ideas are welcome. Thanks in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreter, Hilary 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: Todd Carlson 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:Bitmap Indexes
Ethan, Our data warehouse has both bit map and b-tree indexes and we normally do not have a problem. One headache we do have is that one of the indexes is on a column that accumulates a lot on new values each time the warehouse is loaded which really makes a mess of the load process, namely it takes way too long. The answer is to drop the bitmap indexes before loading new data and then rebuilding them afterwards. Come to think of it that may be part of the reason why the bit maps don't cause a problem. Since a bit map index is only usable by the cost based optimizer and the user who built the warehouse refuses to compute the statistics on those indexes, so their not in use. Interesting, I'll have to do some experimenting now!! Dick Goulet Reply Separator Author: Post; Ethan [EMAIL PROTECTED] Date: 2/7/2002 1:06 PM Posted on behalf of a friend... Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this note now): I have a question regarding Oracle's bitmap indexes. We have been DABBLING with bitmap indexes with mixed results here. In many cases, they are great solutions. In some cases, where we have a mix of bitmap and b-tree indexes on the same table, we occasionally get into trouble --- this has to do with the Oracle optimizer deciding, on the fly, to convert a regular b-tree index into a bitmap. It does this so that it can AND or OR the various bitmap indexes together. Sounds great on the surface but when this occurs, response time goes in the toilet. In one situation we have, we have a fact table with two bitmap indexes and a few other b-tree indexes. A particular query we run bogs down (NEVER COMPLETES) with this mix of indexes. Based on the access path that's being chosen, we know which b-tree index is being converted on the fly. If we convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and Oracle does not need to create the third one on the fly), the query really runs well. If we replace the bitmap indexes with b-tree indexes (so we only have b-tree indexes), we get decent response times. (This is all on Oracle 8.1.7.2.0, by the way.) I'm wondering if the rest of you data warehouse DBAs have gone whole hog with bitmap indexes. My testing shows that when Oracle doesn't have to create a bitmap index on the fly, the queries respond wonderfully. So, I'm wondering if our dabbling is actually a bad validation approach and, instead, we should be 'running' with LOTS bitmap indexes instead of 'crawling' with only a few of them. In other words, maybe we're not taking all of our medication, as someone else put it recently. Any insight would be most appreciated. I'm not looking for insight on the query I have used as an example. I'm looking for a generalized answer that says, Yes, if you start using bitmap indexes, you should go TOTALLY to bitmap indexes or, Hmmm, we're using some bitmap indexes and some b-tree indexes and don't have the problem you have. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What impacts index build times on partitioned tables?
Please check following Are you creating indexes with parallel clause or not? Are you using unrecoverable/nologging or not Is your sort_area_size is ok? What type of TEMP tablespace are you using with temp file or datafile and sizing of extents are proper? Is your target tablespace is not that much fragmented? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 08:55:47 -0800 Yechiel, There is no other activity in this warehouse database while the index builds are being done. The users access is shut off, no batch jobs for this database are running, and the nightly data loads have already finished. Thanks, Cherie àãø éçéàì adary@mehish. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.il cc: Sent by: Subject: RE: What impacts index build times on partitioned tables? [EMAIL PROTECTED] om 02/07/02 10:20 AM Please respond to ORACLE-L I think that it is related to the activity against the DB. Not only there is more load on the DB but access path that use the index can default to full table scan if the index is not available because you are rebuilding it just now. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: What impacts index build times on partitioned tables? We drop and recreate many indexes on our large partitioned fact table in our data warehouse nightly. The amount of data in the table increases gradually with time but there aren't huge fluctuations in the amount of data in the partitions from day to day. The problem is that the amount of time that it takes to recreate the indexes varies widely. From 40 minutes to almost three hours. I am inclined to believe that this is a scheduling issue related to the time of the day and the day of the week. I think we may be experiencing competition from other batch jobs from other applications. One application, in particular, is sort of a black box because it is not on Oracle and it belongs to people who reside in a remote site. However, I want to make sure I've considered all of the possibilities. What factors might influence how long it takes to rebuild indexes on existing partitions? If I just did some maintenance to split out some data for a new time period into a new partition, might that make a difference in how long it takes to build the indexes? These indexes are all locally partitioned indexes. Thanks for any insight you can lend. Cherie Machler Oracle DBA Gelco Information Network -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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). MOHAMMAD RAFIQ _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Re:RE: Migration utility from 7.3.4 to 9i ??
Shaibal, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. To avoid this situation, just after migration from 7.3.4 to 8i, we normally export full database to a null device so that this issue may be avoided during application usage... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 07 Feb 2002 13:06:47 -0800 MOHAMMAD RAFIQ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ---BeginMessage--- Dick, Even if you take export/import route it should be fine. As far as the rowid is concerned it should be the same as rowid in version 8. so logically there will be a conversion of the row-ids from older format(v 7.3.4) to the new format( v 8 or v 9), and nothing is needed to be done explicitly, whenever a table is being accessed by the user for the first time after the migration, row-ids will be converted to ne format implicitly. I have not migrated to 9 from 7.3.4. Still on 8.1.7. Shaibal From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re:RE: Migration utility from 7.3.4 to 9i ?? Date: Thu, 07 Feb 2002 06:23:42 -0800 Kirti, I believe the question is: is there any way to migrate from 7.3.4 directly to 9i. Assuming that to be correct the answer obviously is no, unless you want to take the export/import route. The reason is that in migrating from 7x to 8x the rowid's in the database went through a major change that you can't bypass. Dick Goulet Reply Separator Author: "Deshpande; Kirti" <[EMAIL PROTECTED]> Date: 2/7/2002 6:05 AM Not to my knowledge. But there are other 3rd party tools to unload and load data. Any particular reason to not use what's provided by Oracle? - Kirti -Original Message- Sent: Thursday, February 07, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi Is there any Migration utility from 7.3.4 to 9i availabel ? , other than provided by Oracle , Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] -- 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). -- 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). MSN Photos is the easiest way to share and print your photos: Click Here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder 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). ---End Message---