Which tables are in buffer cache.?
Hi all gurus, I want to learn the way to ook at Which tables are in buffer cache./Analyzed? Is there a system view showing these tables?? Thanks to All. Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
Re: URGENT..not importing previous export!!!!!!!!
Hi, Error messages??? Not sure if it matters, but could it be that export was done with 8.0.4 binaries, and impirt tried with 8.1.5 binaries? If I'm not mistaken you can run the catexp.sql that belongs to the 8.0.4 database (List ??) Jack Saurabh Sharma To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] saurabhs@fcsl cc: td.com Subject: URGENT..not importing previous export Sent by: [EMAIL PROTECTED] om 02-05-2001 09:45 Please respond to ORACLE-L hi all, there is an urgent problem that cropped up while i had some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching. = 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.
URGENT..not importing previous export!!!!!!!!
hi all, there is an urgent problem that cropped up while ihad some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching.
RE: Which tables are in buffer cache.?
Bunyamin, You can check how many blocks are in the buffer cache for segments through the x$bh and v$bh views. Try this query, select count,b.object_name from (select count(*) count,objd from v$bh group by objd) a, user_objects b where a.objd=b.data_object_id / Regards Suhen Hi all gurus, I want to learn the way to ook at Which tables are in buffer cache./Analyzed? Is there a system view showing these tables?? Thanks to All. Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 command question
from root (or from the starting directory you want to search from) do the following find . -type d 2/dev/null Regards Lee -Original Message- Sent: 02 May 2001 00:05 To: Multiple recipients of list ORACLE-L what I would like to see is all directories...not files starting with a particular letter but all directories... ls -d - doesn't work ls -ld p* - doesn't work either Roy, You could do say ls -ld p* to list the directories starting with p. Rgds, raja -- On Tue, 01 May 2001 13:35:46 Roy Ferguson wrote: what is the ls command to view only a list of directories? ls -la lists both files and directories...I want to view only a list of directories... environment is sun sparc solaris 2.6 thanks in advance roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Roy E. Ferguson II Intel Sacramento 916-854-1123 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
UTL_FILE_DIR = in init.ora
Currectly I have specified UTL_FILE = * in my init.ora file because we access files from several directories, including directories which are only created at runtime. Is it possible to specify UTL_FILE so that it gives access to all files under a parent directory. Or is it the case that we must specify each directory individually if we don't use UTL_FILE= * John -- 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: DB link for nonoracle databases
You have to setup heterogeous services. Check in the Net8 guide under Configuring connections to non-Oracle Databases Services. Here what I've done to have a dblink between Oracle 816/Solaris and SQLServer 6.5 via ODBC MERANT. Modify listener.ora to listen to hsodbc. Add en entry in tnsnames.ora to point on hsodbc. Create a dblink on hsodbc. I was able to read/write on tables on SQLServer. Even if it's not support, I was able to run a stored proc on SQLServer with dbms_hs_passthrough.execute_immediate. The only bad thing is that all processes were frozen on SQLServer until I log out. --- Deepender Kr Gupta [EMAIL PROTECTED] a écrit : Hi All !! I have a DBA question. Can we make a DB link for nonoracle databases ! The answer is 'YES' , I know. But How. The documentation says you will have to use Oracle hetrogeneous services. There is no explaination any further. I want my Oracle database to gather data from a SQL server . Both are on NT. Thanks in Advance. Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- marketing (was Windows vs. UNIX)
At the moment they are doing and I kid you not, a range of Indian themed burgers. Lamb Korma Chicken Tikka Masala and another one. Apart from the veggie burger, chicken sandwich and the filet-o-fish which have been around for years and years the non-beef burgers are usually special promotions (Chinese, Italian etc...) and are advertised for a couple of months at a time. Bloody cannot stand them myself.. -Original Message- Sent: 01 May 2001 19:37 To: Multiple recipients of list ORACLE-L Actually, Lee, you should enlighten us. The last time I was in the U.K. for any length of time (1998) the McD's there had far more non-beef and even vegetarian options, which are only now catching on here. So what can we expect in the next few years from the enlightened McD's of Europe? Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 P: 919.466.7337 F: 919.466.7427 E: [EMAIL PROTECTED] -- 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). 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: unix command question
oops, I missed off the -exec bit. find . -type d -exec ls -ld {} \; 2/dev/null Cheers Lee 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: X$ tables ??
Bunyamin, You should be able to view these tablesfrom the SYS schema. Regards Suhen I see that there is no X$ tables in my database or I can not view them . My O.S. is NT . How can I view them.?? Thanks Bunyamin K.Karadeniz Database Group / Information Systems Department HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729
Strange report from 'vmstat'
Hi all! Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)). It concerns AIX memory 'problem'. When I issue vmstat command, we got following result: /u01/app/oracle/product/8.1.7.vmstat 2 4 kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 580556 554 0 0 0 14 34 0 126 137 63 11 5 82 1 0 2 580556 549 0 0 0 00 0 708 527 206 0 0 99 0 0 2 580557 548 0 0 0 00 0 829 99854 421 2 10 88 0 0 2 580557 548 0 0 0 00 0 637 111 35 0 0 99 0 Analysing this output, it seams that we have cca 2GB RAM (example: (580557 + 548)* 4096 = 2,2 GB), while we expected min 8GB. This gap between 8GB and output from vmstat report, increases in time. The question is if our calculation was right, is this the right way to analyse this at all? Maybe it is important to say, that our Oracle is installed on OFA using data files, max size 2GB, in same volume group(not on raw devices). Do you know of any AIX memory problems which can manifests as mentioned above? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anybody getting ORA-00600 [729] [space leak] on a regular base?`
In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: can't reproduce problem to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFF-TOPIC: comp.databases.oracle.server
Hi, As I understand, deja had been acquired by a company. How to read/post messages to new usenet including web based or Netscape Messenger ? I could not read by Netscape Messenger. thanks... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Enterprise VS. Standard???
Does anyone out there know what the best method would be to migrate from Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? It appears from the docs that the only way to migrate from Enterprise to Standard is to do an entire rebuild of the database. (Export, de-install, re-install, Build all tablespaces, etc. and Import). Is this correct? OS: Windows NT 4.0 DB: Oracle 8.1.6 Enterprise (going to Standard) Thank you. -Fred Smith Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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).
Q: WILLING_TO_WAIT_COPY 1%
Hi list, I have a problem with one of my customers databases. The value of WILLING_TO_WAIT_COPY = 100. I have read that this value should be smaller than 1. Parameter LOG_SIMULTANEOUS_COPIES is set to 4 in init.ora. Database is Oracle 8.0.5 under Windows NT 4.0. Hardware is a 2 CPU machine. Now my question: What should I do so that WILLING_TO_WAIT_COPY 1%? Here is the select which gives me the values. SELECT round(a.misses/(a.gets + 0.01)*100,2) willing_to_wait_copy FROM v$latch a, v$latchname b WHERE b.name = 'redo copy' AND b.latch# = a.latch#; TIA Regards Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: V$session
Title: RE: V$session It's in v$process. Here's a script that displays it that I got off this list a while ago set linesize 2000 column logon_time format a17 column username format a16 column unix_pid format a8 column machine format a20 column client_Program format a20 set pagesize 200 select s.username, s.sid, s.serial#, to_char(p.spid) unix_pid, s.status, to_char(logon_time, 'mm/dd/yy hh24:mi:ss') logon_time, -- idle time -- days added to hours --( trunc(LAST_CALL_ET/86400) * 24 ) || ':' || -- days separately substr('0'||trunc(LAST_CALL_ET/86400),-2,2) || ':' || -- hours substr('0'||trunc(mod(LAST_CALL_ET,86400)/3600),-2,2) || ':' || -- minutes substr('0'||trunc(mod(mod(LAST_CALL_ET,86400),3600)/60),-2,2) || ':' || --seconds substr('0'||mod(mod(mod(LAST_CALL_ET,86400),3600),60),-2,2) idle_time, substr(s.program,1,20) client_program, s.machine, s.process client_process, s.osuser, substr(p.program,1,20) server_program from v$session s, v$process p where s.username is not null and p.addr = s.paddr order by username, 2 / Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Subject: V$session Hi Which column in v$session indicate os process? Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
running unix commands from java stored procedure
Does anyone have any examples of how to run a unix command from a java stored procedure, and returning the exit code of the unix command? John -- 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).
off topic: c, c++ and java list
Title: off topic: c, c++ and java list Hi, all Could anyone tell me there is any list regarding C, C++ and Java ? thanks li
_ROW_CACHE_BUFFER_SIZE
Performance/Internals Wizards! Anyone ever play with _row_cache_buffer_size? I am having trouble with a crappy application and out of control packages ( too big ) and public synonyms out the ying yang. My 734 instance has DD cache size swells that remind me of A Perfect Storm, except I bear zero resemblance to George Clooney. It may be a derived parameter ( depending on shpool size, processes, etc) but, if so, I cannot find the root parameter. I would like to apply an init.ora bandaid to the DD cache without having to touch the crApplication yet. Yes, it would be an indirect fix at best, especially given that V$LATCH_MISSES indicates it is the DD find obj that is the problem, not the parse. sigh How I despise public synonyms, developers, and and and sputtering into silence . If you've played with _row_cache_buffer_size, please let me know. I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively that the space/size is due to Public Synonyms. Any guidance there would be most welcome, as well. Thanks! - Ross p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is 10, and yes i know (a) oracle says the default is fine, and (b) using undocumented parameters is bad ) || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: WILLING_TO_WAIT_COPY 1%
Title: RE: WILLING_TO_WAIT_COPY 1% I had the same problem. Its shows 56% on 8.0.5 database. But here is a thought. When I upgraded to 8.1.6 it shows 0%. I still have one database on 8.0.5 where it shows 57% Also this parameter LOG_SIMULTANEOUS_COPIES is gone in 8.1.6 Brijesh -Original Message- From: Schoen Volker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Q: WILLING_TO_WAIT_COPY 1% Hi list, I have a problem with one of my customers databases. The value of WILLING_TO_WAIT_COPY = 100. I have read that this value should be smaller than 1. Parameter LOG_SIMULTANEOUS_COPIES is set to 4 in init.ora. Database is Oracle 8.0.5 under Windows NT 4.0. Hardware is a 2 CPU machine. Now my question: What should I do so that WILLING_TO_WAIT_COPY 1%? Here is the select which gives me the values. SELECT round(a.misses/(a.gets + 0.01)*100,2) willing_to_wait_copy FROM v$latch a, v$latchname b WHERE b.name = 'redo copy' AND b.latch# = a.latch#; TIA Regards Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UTL_FILE_DIR = in init.ora
You hit the nail on the head here: Or is it the case that we must specify each directory individually if we don't use UTL_FILE= * Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: please help
Sound to me the same thing had happened. He did not force a log switch after he finished back up all the datafiles to tape. If the required log (probably archive log) which is generated during the hot backup of the database can no longer be found. Part of that hot backup will be unusable. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~ (@ @) @}-`-,-`-,--- Winnie Liu --',-'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--oInfonet Services Corporation `~`~ #mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ David A. Barbour To: Multiple recipients of list ORACLE-L dbarbour@nuce[EMAIL PROTECTED] ntrix.netcc: Sent by: Subject: Re: Fwd: please help [EMAIL PROTECTED] om 05/02/01 07:24 AM Please respond to ORACLE-L Bill, Did you force a log switch before and after the hot backup? Did you backup your archive logs (or alternatively, are they available)? Sounds to me like you need to run ALTER DATABASE SID RECOVER UNTIL (CANCEL, TIME, CHANGE, USING BACKUP CONTROLFILE); If you didn't force the log switch, be mindful that you may have to specify one or more of the redo logs to get the requested SCN. Did you backup the controlfile? redo logs? initSID.ora? orapasswd? These are some generalities, which may or may not apply to your specific situation. However, given the information at hand, it's probably where I'd start looking. Regards. David A. Barbour Oracle DBA, OCP Jonathan Gennick wrote: Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC Hi Jonathan, BC I always read and like your articles in the Oracle BC Magazine. BC Could you please give me a moment of your time .. BC I have some couple of pressing problems and questions BC if you don't mind as i am under fire at work .. BC I have trouble with some of the Oracle databases that BC i manage on Sun Solaris platform, sometimes i have my BC shutdowns hanging and this takes a very long time to BC complete. Also, hanging problems with some of the sql BC statements. Could you lend a hand about any possible BC clues as to what i should do or where i should look BC for answers. BC My last question is about hotback. BC I ran a hot backup yesterday and tried recovering BC today. I was faced with an Oracle error saying system BC tablespace needs more recovery and that open resetlogs BC will get an error after automatically applying the BC redo logs. BC My backup strategy went this way, BC i created a backup shell script and BC i put all tablespaces in hotbackup mode at the same BC time with this syntax.. BC select 'alter tablespace' || tablespace_name ||'begin BC
RE: URGENT..not importing previous export!!!!!!!!
" import the exported files after making the same structue(tablespace and users) as there were in previous install." You don't have to create the users. The import will create it for you. Also in your case you don't have to create the database as the same path already exists as old database. It may be not importing because you have already created the users and when import file tries to create the user it fails and skips it. Try this -- create fresh 8.1.5 database -- run catexp.sql and import complete database. Brijesh -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 02, 2001 2:46 AMTo: Multiple recipients of list ORACLE-LSubject: URGENT..not importing previous export hi all, there is an urgent problem that cropped up while ihad some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching.
Re: DB link for nonoracle databases
'Oracle heterogeneous services' are purchased separately. They are services that run on the target systems that allow Oracle to talk to them through Net*8. We use an Oracle gateway to talk to our AS400s. For the most part, this works well. Call your rep. Todd Carlson Oracle 8i Certified DBA Bunge Corporation Deepender Kr Gupta To: Multiple recipients of list ORACLE-L deepender.gupta@[EMAIL PROTECTED] wipro.com cc: Sent by: Subject: DB link for nonoracle databases [EMAIL PROTECTED] 05/02/2001 12:05 AM Please respond to ORACLE-L Hi All !! I have a DBA question. Can we make a DB link for nonoracle databases ! The answer is 'YES' , I know. But How. The documentation says you will have to use Oracle hetrogeneous services. There is no explaination any further. I want my Oracle database to gather data from a SQL server . Both are on NT. Thanks in Advance. Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepender Kr Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: No listner and tns packet error
Everything u have specified set correctly it was network problem as specified by jared and I was able to solve the problem. Thanks for ur help Brijesh --- Behar, Rivaldi [EMAIL PROTECTED] wrote: If ping is Ok and listener is running, try using IP address in your tnsnames.ora instead of machine name. Rivaldi -Original Message- Sent: Tuesday, May 01, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Did you include this database in your listener.ora file? Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 12:30 PM Hi I am facing one funny oracle failure. If i try to connect the client machine to linux oracle8i server I receive the error no listner. However when I see at linux server the listner is altready running.Again after sometime when I try to connect to oracle server I get same error for some time and then I get TNS packet failure error. After sometime I get connected to oracle server and then get disconenct after few minutes and again I get the same error no listner. I am totally puzzled with this problem can anyone help me in solving me this problem Looking forward for response from u all Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Constraint dependencies
Lisa, This is unfortunately quite difficult -- and if you have any circular dependencies it's pretty much impossible. Otherwise, what you need to do is follow the dependencies in the dba_constraints view. For the drop order. 1) Drop all of the tables for which their PK constraint is not referenced by any FK constraints select constraint_name from user_constraints c1 where not exists (select constraint_name from user_constraints c2 where c2.r_constraint_name = c1.constraint_name) 2) Now that you've dropped the first group, you can do the same query again. If you are just creating a drop script, you'll need to keep track of the ones you've dropped so you can restrict the query. The creation order is simpler -- you need to create all of the primary key constraints first, then the foreign keys. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 P: 919.466.7337 F: 919.466.7427 E: [EMAIL PROTECTED] Yttri, Lisa lisa.yttri@cTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] nh.com cc: Sent by: Fax to: root@fatcity.Subject: Constraint dependencies com 05/01/2001 05:50 PM Please respond to ORACLE-L Hi - When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would like to be able to identify the order that the constraints should be dropped (or added) so that I can write a script to be automated ( for example, to refresh test data from production). If anyone has any good ideas on how to do this, I'd really be interested in hearing from you. Thanks - Lisa -- 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: unix command question
ls -ld `find * -type d -prune` note that those are back-quotes around the find command. If you're worried about blowing your command-line buffer, if you've got a *lot* of directories, use: find * -type d -prunt | xargs ls -ld At 03:05 PM 5/1/01 -0800, you wrote: what I would like to see is all directories...not files starting with a particular letter but all directories... ls -d - doesn't work ls -ld p* - doesn't work either Roy, You could do say ls -ld p* to list the directories starting with p. Rgds, raja -- On Tue, 01 May 2001 13:35:46 Roy Ferguson wrote: what is the ls command to view only a list of directories? ls -la lists both files and directories...I want to view only a list of directories... environment is sun sparc solaris 2.6 thanks in advance roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Roy E. Ferguson II Intel Sacramento 916-854-1123 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Dennis Taylor It was a book to kill time for those who liked it better dead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT..not importing previous export!!!!!!!!
What kind of error you are getting from the import? Since you already have created the tablespaces and users in your new database, did you put IGNORE=Y when you perform the import? Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~ (@ @) @}-`-,-`-,--- Winnie Liu --',-'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--oInfonet Services Corporation `~`~ #mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Gupta, Brijesh Brijesh.Gupta@AirliTo: Multiple recipients of list ORACLE-L quide.com [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: RE: URGENT..not importing previous export 05/02/01 11:06 AM Please respond to ORACLE-L import the exported files after making the same structue(tablespace and users) as there were in previous install. You don't have to create the users. The import will create it for you. Also in your case you don't have to create the database as the same path already exists as old database. It may be not importing because you have already created the users and when import file tries to create the user it fails and skips it. Try this -- create fresh 8.1.5 database -- run catexp.sql and import complete database. Brijesh -Original Message- Sent: Wednesday, May 02, 2001 2:46 AM To: Multiple recipients of list ORACLE-L hi all, there is an urgent problem that cropped up while i had some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching. -- 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: unix command question
At 07:20 PM 5/1/01 -0800, you wrote: Haven't seen this one mentioned yet: find . -type d -print | xargs ls -ld Jared This one does a recursive list. The one I posted only does the current directory. Not sure which variation the poster wanted. Dennis Taylor It was a book to kill time for those who liked it better dead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Os block size
Could someone please tell what is OS block size on solaris 8 Mujeeb Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sample Scripts
Hi, We recently lost our DBA, and as I was standing too close to our IT manager, now I'm it. As I get started on reading and studying, I quickly need some scripts to monitor 'normal' stuff on 7.3.4. I'm used to SQL as a developer, so that helps. So, do you know of a source where I can download some quality scripts? TIA, Rick __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: please help
I'm starting to feel my signature is inadequate! Mark (plain and simple boring me) -Original Message- [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 06:57 To: Multiple recipients of list ORACLE-L Sound to me the same thing had happened. He did not force a log switch after he finished back up all the datafiles to tape. If the required log (probably archive log) which is generated during the hot backup of the database can no longer be found. Part of that hot backup will be unusable. -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~``~ (@ @) @}-`-,-`-,--- Winnie Liu --',-'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~ o--m-m--oInfonet Services Corporation `~`~ #mailto:[EMAIL PROTECTED]`~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ David A. Barbour To: Multiple recipients of list ORACLE-L dbarbour@nuce[EMAIL PROTECTED] ntrix.netcc: Sent by: Subject: Re: Fwd: please help [EMAIL PROTECTED] om 05/02/01 07:24 AM Please respond to ORACLE-L Bill, Did you force a log switch before and after the hot backup? Did you backup your archive logs (or alternatively, are they available)? Sounds to me like you need to run ALTER DATABASE SID RECOVER UNTIL (CANCEL, TIME, CHANGE, USING BACKUP CONTROLFILE); If you didn't force the log switch, be mindful that you may have to specify one or more of the redo logs to get the requested SCN. Did you backup the controlfile? redo logs? initSID.ora? orapasswd? These are some generalities, which may or may not apply to your specific situation. However, given the information at hand, it's probably where I'd start looking. Regards. David A. Barbour Oracle DBA, OCP Jonathan Gennick wrote: Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC Hi Jonathan, BC I always read and like your articles in the Oracle BC Magazine. BC Could you please give me a moment of your time .. BC I have some couple of pressing problems and questions BC if you don't mind as i am under fire at work .. BC I have trouble with some of the Oracle databases that BC i manage on Sun Solaris platform, sometimes i have my BC shutdowns hanging and this takes a very long time to BC complete. Also, hanging problems with some of the sql BC statements. Could you lend a hand about any possible BC clues as to what i should do or where i should look BC for answers. BC My last question is about hotback. BC I ran a hot backup yesterday and tried recovering BC today. I was faced with an Oracle error saying system BC tablespace needs more recovery and that open resetlogs BC will get an error after automatically applying the BC redo logs. BC My backup strategy went this way, BC i created a backup shell script and BC i put all tablespaces in hotbackup mode at the same BC time with this syntax.. BC select 'alter tablespace' || tablespace_name ||'begin BC backup;' BC from dba_tablespaces BC where status 'INVALID'; BC I copied my datafiles to backup using the syntax below BC ... BC !cp /u02/oradata/prod/system01.dbf/backup/prod BC !cp BC !cp BC !cp BC !cp BC then ended backup the same way as i began backup BC with the ||'end backup;' BC I backed up my controlfile BC and everything went well. Today, I restored my BC datafiles from backup and i was greeted with the BC problem i just expalined to you. BC I am the only dba DBA at this location BC and i need some advise on what to do as this is a BC serious issue with my supervisor. BC Thanks, BC Bill BC __ BC Do You Yahoo!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: Strange report from 'vmstat'
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Sonja, The 'fre' column is not exactly as it appears. It appears to show free RAM memory pages at 4K each. However pages are not given back to the fre list until needed. In particular when the system uses large amounts of memory from for I/O caching then these pages are given back only when the free list is getting empty. The sum of the 'avm' and 'fre' columns do not need to add up to the real memory size of the machine. (roughly transcribed from the AIX Survival Guide) What exactly is the problem you have identified here? John -Original Message- From: Sonja Sehovic [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 15:20 To: Multiple recipients of list ORACLE-L Subject:Strange report from 'vmstat' Hi all! Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)). It concerns AIX memory 'problem'. When I issue vmstat command, we got following result: /u01/app/oracle/product/8.1.7.vmstat 2 4 kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 580556 554 0 0 0 14 34 0 126 137 63 11 5 82 1 0 2 580556 549 0 0 0 00 0 708 527 206 0 0 99 0 0 2 580557 548 0 0 0 00 0 829 99854 421 2 10 88 0 0 2 580557 548 0 0 0 00 0 637 111 35 0 0 99 0 Analysing this output, it seams that we have cca 2GB RAM (example: (580557 + 548)* 4096 = 2,2 GB), while we expected min 8GB. This gap between 8GB and output from vmstat report, increases in time. The question is if our calculation was right, is this the right way to analyse this at all? Maybe it is important to say, that our Oracle is installed on OFA using data files, max size 2GB, in same volume group(not on raw devices). Do you know of any AIX memory problems which can manifests as mentioned above? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas, John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: V$session
The column named PROCESS. [EMAIL PROTECTED] 05/02/01 12:00PM Hi Which column in v$session indicate os process? Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Virus Found in Attachment (Subject: Uniquely Weird - duplicate
Lisa, your attachment had a virus in it. My local server detected it. Everyone, DO NOT OPEN THE ATTACHMENT in emails with the Subject: Uniquely Weird - duplicate rows. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Constraint dependencies
Basically you should drop the constraints of type 'R' first, then drop the constraints of type 'P' and 'U'. See the CONSTRAINT_TYPE in the USER_CONSTRAINTS view. [EMAIL PROTECTED] 05/01/01 05:50PM Hi - When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would like to be able to identify the order that the constraints should be dropped (or added) so that I can write a script to be automated ( for example, to refresh test data from production). If anyone has any good ideas on how to do this, I'd really be interested in hearing from you. Thanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: URGENT..not importing previous export!!!!!!!!
Remember use ignore=yes to ignore create errors on existing tables, users. If you don't, the import will probably fail. [EMAIL PROTECTED] 05/02/01 02:06PM import the exported files after making the same structue(tablespace and users) as there were in previous install. You don't have to create the users. The import will create it for you. Also in your case you don't have to create the database as the same path already exists as old database. It may be not importing because you have already created the users and when import file tries to create the user it fails and skips it. Try this -- create fresh 8.1.5 database -- run catexp.sql and import complete database. Brijesh -Original Message- Sent: Wednesday, May 02, 2001 2:46 AM To: Multiple recipients of list ORACLE-L hi all, there is an urgent problem that cropped up while i had some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Hi We had ORA-00600 [729] problem on a regular basis too. I am not sure about your database errors, but in out database these errors are due to audit_trail being turned on. In the PGA Ptvt. Audit Info memory chunks are not being considered and they are being falsely identified as space leak. If you look at the trace file and add up all the chunk sizes for the Prvt. Audit Info chunks, you could see that they match to the bytes reported in the ORA-600 parameter. grep Pvt. audit info otmxp02_ora_10424.trc |awk '{sum+=$4}END {print sum}' 25256 From the trace file: *** 2001.04.17.09.29.42.000 *** SESSION ID:(30.22436) 2001.04.17.09.29.42.000 ERROR: UGA memory leak detected 25256 ** Hope this helps! Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Nuno Souto [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L nd.net.au [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Anybody getting ORA-00600 [729] [space leak] on a regular base?` 05/02/01 09:19 AM Please respond to ORACLE-L In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: can't reproduce problem to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
It is relating to incomplete/terminated export of database or any large table. You may check this happening to your systemOracle patch 7.3.4.5 claims that it is fixed but it is still the problem... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 02 May 2001 06:19:31 -0800 In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: can't reproduce problem to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: please help
would it be reasonable, then to alter system archive log current, and then back up all archived logs ... are there any pitfalls? ... thanks you Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 02, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Tuesday, May 01, 2001, 10:27:51 PM, X wrote: BC Hi Jonathan, BC I always read and like your articles in the Oracle BC Magazine. BC Could you please give me a moment of your time .. BC I have some couple of pressing problems and questions BC if you don't mind as i am under fire at work .. BC I have trouble with some of the Oracle databases that BC i manage on Sun Solaris platform, sometimes i have my BC shutdowns hanging and this takes a very long time to BC complete. Also, hanging problems with some of the sql BC statements. Could you lend a hand about any possible BC clues as to what i should do or where i should look BC for answers. BC My last question is about hotback. BC I ran a hot backup yesterday and tried recovering BC today. I was faced with an Oracle error saying system BC tablespace needs more recovery and that open resetlogs BC will get an error after automatically applying the BC redo logs. BC My backup strategy went this way, BC i created a backup shell script and BC i put all tablespaces in hotbackup mode at the same BC time with this syntax.. BC select 'alter tablespace' || tablespace_name ||'begin BC backup;' BC from dba_tablespaces BC where status 'INVALID'; BC I copied my datafiles to backup using the syntax below BC ... BC !cp /u02/oradata/prod/system01.dbf/backup/prod BC !cp BC !cp BC !cp BC !cp BC then ended backup the same way as i began backup BC with the ||'end backup;' BC I backed up my controlfile BC and everything went well. Today, I restored my BC datafiles from backup and i was greeted with the BC problem i just expalined to you. BC I am the only dba DBA at this location BC and i need some advise on what to do as this is a BC serious issue with my supervisor. BC Thanks, BC Bill BC __ BC Do You Yahoo!? BC Yahoo! Auctions - buy the things you want at great prices BC http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
That error is in their knowledge and they can check in patchset note for 7.3.4.5 for fixes and they claim it is fixed but problem still exist while terminating export while database goes down. We have this problem with HP-10.20 and version 7.3.4.5 Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] base?` Date: Wed, 02 May 2001 09:30:28 -0800 _ Get your FREE download of MSN Explorer at http://explorer.msn.com Oracle rep told us to report ORA-600 to Oracle which would inturn help them in developing bug fixes. HTH. JyotiGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti Randive INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sample Scripts
Metalink has some really good scripts. I'd try that (it's actually been running half-way decent lately, you might get lucky =). -::YEX::- ))) -Original Message- Sent: Wednesday, 02 May, 2001 11:37 AM To: Multiple recipients of list ORACLE-L Hi, We recently lost our DBA, and as I was standing too close to our IT manager, now I'm it. As I get started on reading and studying, I quickly need some scripts to monitor 'normal' stuff on 7.3.4. I'm used to SQL as a developer, so that helps. So, do you know of a source where I can download some quality scripts? TIA, Rick __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OCI drivers
Where can I download the OCI drivers from ?I need the drivers for Unix and NT. Should I install the Oracle client to install the oci drivers.? I was told that OCI drivers with JDBC connection pooling helps to improve the performance. Can pls anyone comment or contirubute their experience on this topic. thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: _ROW_CACHE_BUFFER_SIZE
Ross, Is this OPS? According to Steve Adams ( this is how you make mail show up in his mailbox :) that is for OPS. Sorry, that's all I have to offer. http://www.ixora.com.au/q+a/0008/31163237.htm Jared On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: Performance/Internals Wizards! Anyone ever play with _row_cache_buffer_size? I am having trouble with a crappy application and out of control packages ( too big ) and public synonyms out the ying yang. My 734 instance has DD cache size swells that remind me of A Perfect Storm, except I bear zero resemblance to George Clooney. It may be a derived parameter ( depending on shpool size, processes, etc) but, if so, I cannot find the root parameter. I would like to apply an init.ora bandaid to the DD cache without having to touch the crApplication yet. Yes, it would be an indirect fix at best, especially given that V$LATCH_MISSES indicates it is the DD find obj that is the problem, not the parse. sigh How I despise public synonyms, developers, and and and sputtering into silence . If you've played with _row_cache_buffer_size, please let me know. I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively that the space/size is due to Public Synonyms. Any guidance there would be most welcome, as well. Thanks! - Ross p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is 10, and yes i know (a) oracle says the default is fine, and (b) using undocumented parameters is bad ) || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). -- 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
standby database in managed recovery mode
Suggestions anyone?? I'm attempting to get a standby database to run in managed recovery mode, so that the archived logs are automatically applied, however, when running the command 'recover managed standby database' I receive the following error message: SVRMGR recover managed standby database; ORA-00308: cannot open archived log '/u03/apps/oracle/admin/db/arch/1_194.arc' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 This is after I've brought the primary and standby up to the same max recid number in the v$log_history. I have attempted to rebuild the standby database and also to execute the command 'recover standby database until cancel' after confirming that all archived log files were in the proper location, however I'm always prompted for the next archive log which doesn't exist yet and I can't get into managed recovery mode. I've also went to the primary database, forced a log switch and then applied the newest archived log file, but that hasn't worked either. Richard Huntley Software Developer Phone: (800) 223-3732 (614) 880-1817 E-mail: [EMAIL PROTECTED] MindLeaders (www.mindleaders.com) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: _ROW_CACHE_BUFFER_SIZE
Hi All, Yes, '_row_cache_buffer_size' does nothing for single instance Oracle. There is a tip on setting '_row_cache_cursors' at http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web site. Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in there, the best thing for you to do would be to create private synonyms. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Thursday, 3 May 2001 7:26 To: Multiple recipients of list ORACLE-L Ross, Is this OPS? According to Steve Adams ( this is how you make mail show up in his mailbox :) that is for OPS. Sorry, that's all I have to offer. http://www.ixora.com.au/q+a/0008/31163237.htm Jared On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: Performance/Internals Wizards! Anyone ever play with _row_cache_buffer_size? I am having trouble with a crappy application and out of control packages ( too big ) and public synonyms out the ying yang. My 734 instance has DD cache size swells that remind me of A Perfect Storm, except I bear zero resemblance to George Clooney. It may be a derived parameter ( depending on shpool size, processes, etc) but, if so, I cannot find the root parameter. I would like to apply an init.ora bandaid to the DD cache without having to touch the crApplication yet. Yes, it would be an indirect fix at best, especially given that V$LATCH_MISSES indicates it is the DD find obj that is the problem, not the parse. sigh How I despise public synonyms, developers, and and and sputtering into silence . If you've played with _row_cache_buffer_size, please let me know. I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively that the space/size is due to Public Synonyms. Any guidance there would be most welcome, as well. Thanks! - Ross p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is 10, and yes i know (a) oracle says the default is fine, and (b) using undocumented parameters is bad ) || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like
RE: Sample Scripts
Title: RE: Sample Scripts He was the one between Rick and Rick's IT manager. -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sample Scripts I'm sorry to hear that about your DBA. How did he die? --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Wednesday, May 02, 2001 9:37 AM To: Multiple recipients of list ORACLE-L Hi, We recently lost our DBA, and as I was standing too close to our IT manager, now I'm it. As I get started on reading and studying, I quickly need some scripts to monitor 'normal' stuff on 7.3.4. I'm used to SQL as a developer, so that helps. So, do you know of a source where I can download some quality scripts? TIA, Rick __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: _ROW_CACHE_BUFFER_SIZE
Thanks Steve. The only useful reference to this parameter is on your web site. :) Jared On Wednesday 02 May 2001 14:22, Steve Adams wrote: Hi All, Yes, '_row_cache_buffer_size' does nothing for single instance Oracle. There is a tip on setting '_row_cache_cursors' at http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web site. Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in there, the best thing for you to do would be to create private synonyms. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 May 2001 7:26 To: Multiple recipients of list ORACLE-L Subject: Re: _ROW_CACHE_BUFFER_SIZE Ross, Is this OPS? According to Steve Adams ( this is how you make mail show up in his mailbox :) that is for OPS. Sorry, that's all I have to offer. http://www.ixora.com.au/q+a/0008/31163237.htm Jared On Wednesday 02 May 2001 11:01, Mohan, Ross wrote: Performance/Internals Wizards! Anyone ever play with _row_cache_buffer_size? I am having trouble with a crappy application and out of control packages ( too big ) and public synonyms out the ying yang. My 734 instance has DD cache size swells that remind me of A Perfect Storm, except I bear zero resemblance to George Clooney. It may be a derived parameter ( depending on shpool size, processes, etc) but, if so, I cannot find the root parameter. I would like to apply an init.ora bandaid to the DD cache without having to touch the crApplication yet. Yes, it would be an indirect fix at best, especially given that V$LATCH_MISSES indicates it is the DD find obj that is the problem, not the parse. sigh How I despise public synonyms, developers, and and and sputtering into silence . If you've played with _row_cache_buffer_size, please let me know. I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively that the space/size is due to Public Synonyms. Any guidance there would be most welcome, as well. Thanks! - Ross p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is 10, and yes i know (a) oracle says the default is fine, and (b) using undocumented parameters is bad ) || -Original Message- || From: Steve Adams [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 01, 2001 11:00 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle What savepoints are active for a given session? || || || Hi Venkata, || || There is no V$ view or X$ table that contains this || information. The only || solution that occurs to me is to dump the savepoints to the || process trace file || with || || alter session set events 'immediate trace name savepoints'; || || and then use UTL_FILE to read and parse the trace file || information. Here is an || example of what you might get: || || SAVEPOINT FOR CURRENT PROCESS || -- ||flag: 0x3 ||name: S3 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082 ||status: VALID, next: 3822f60 ||name: S2 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046 ||status: VALID, next: 37f63ec ||name: S1 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602 ||status: VALID, next: 0 || || This process has three savepoints named S1, S2 and S3 respectively. || || @ Regards, || @ Steve Adams || @ http://www.ixora.com.au/ || @ http://www.christianity.net.au/ || || || -Original Message- || Sent: Tuesday, 1 May 2001 18:20 || To: Multiple recipients of list ORACLE-L || || || HI PLEASE SEND ME ANSWER || Question Title: Oracle What savepoints are active for a || given session? || || Detailed Question: Does anybody know IF and HOW can I get a list of || active savepoints for the current session? I need a native way, not || solutions based on additional application-level || housekeeping. Some query || on the V$ tables/views would be the kind of answer I'm looking for. || Details: Within one stored proc I'd like to obtain a list || (in any form) || of the savepoints issued currently in the current || transaction. Example: || Proc A issues savepoint svA; then proc B issues savepoint || svB; and then || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or || something like that. Of course, there are no intervening commits or || rollbacks. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Steve Adams || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists ||
9iAS Forms Server Stability
Listers, 6i Forms Server in a test environment is crashing quite frequently, 3 to 4 times a day. I'm relaying this question, and I'm not real familiar with the back end configuration details, so I might be off on some things. They have an 8.1.7 test environment with 9iAS 1.0.2. Platform is HP-UX 11. 9iAS 1.0.2, I believe that would be using Forms 6i patch 2. They are using JInitiator. Access is via NT (sp4) clients using IE 5.5. The servlet, not CGI, approach is being used. They are specifying connectmode as HTTP. In the test environment, DB and 9iAS are on the same box. In production, they will be using 4 dedicated HP D class boxes for the forms servers just as they currently do. Anyway, the Forms Server is going down quite a bit in the test environment, 3 or 4 times a day. They currently use Forms 5.0 in a production web deployed environment. While there are some things that are a bit of a pain when web deploying forms, the 5.0 Forms Server has been very stable for them. So, there is some concern about the stability when using 9iAS with the included Apache server along with the Forms Server for 6i. Anyone have success or horror stories they would like to relay? Their current thinking is to wipe everything clean, do a clean re-install (they ran into a few road bumps during the install and wonder if a clean install would help), and see what happens from there. Regards, Larry G. Elkins [EMAIL PROTECTED] -- 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: Anybody getting ORA-00600 [729] [space leak] on a regular base?`
Space leaks = Oracle malloced memory and did not free it when done. There is actually an init.ora event that can be set to ignore memory leaks so you don't have to see them in your alert log. 10262, 0, Don't check for memory leaks // *Cause:Setting this event to level one causes memory leak checking to //be disabled. Setting this event to any other non-zero number //allows that number to be used as a threshold value when checking //for memory leaks in the PGA, SGA, and UGA heaps. Jared On Wednesday 02 May 2001 07:19, Nuno Souto wrote: In the alert log? HP9K, HP-UX, Oracle 8.0.6.0. I'm getting about 6 a day. No apparent harm to the DB. Metalink as usual says: can't reproduce problem to most of these bugs. Couldn't find a concrete fix to this anywhere. Nope, I'm not using direct export. TIA for any feedback. Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- 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: Enterprise VS. Standard???
Please change the settings in your mail software so that mail is sent out as plain text, at least for this list. Jared On Wednesday 02 May 2001 09:20, Fred Smith wrote: htmlDIV PFONT face=Courier NewDoes anyone out there know what the best method would be to migrate from BROracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? BRBRIt appears from the docs that the only way to migrate from Enterprise to BRStandard is to do an entire rebuild of the database.nbsp; (Export, de-install, BRre-install, Build all tablespaces, etc. and Import).nbsp; Is this correct? BRBROS:nbsp; Windows NT 4.0 BRDB:nbsp; Oracle 8.1.6nbsp; Enterprise (going to Standard) BRBRThank you. BR-Fred Smith /FONTBR/P/DIVbr clear=allhrGet your FREE download of MSN Explorer at a href=http://explorer.msn.com;http://explorer.msn.com/abr/p/html -- 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: Performance of views
Helmut, Oracle *can* push the criteria down into the view definition in many situations. Certain operations, though, will not allow this to happen. You can find some info on Metalink, and, in the Oracle 8i Designing and Tuning for Performance manual. There are other source as well. Here is a little snippet from the Oracle 8i Designing and Tuning for Performance manual: start To merge the views query into a referencing query block in the accessing statement, the optimizer replaces the name of the view with the names of its base tables in the query block and adds the condition of the views querys WHERE clause to the accessing query blocks WHERE clause. This optimization applies to select-project-join views, which are views that contain only selections, projections, and joinsthat is, views that do not contain set operators, aggregate functions, DISTINCT, GROUP BY, CONNECT BY, and so on (as described in Mergeable and Non-mergeable Views on page 4-77). end Your best bet is to do explain plans on queries against the view(s) and verify the access paths are optimal. Lots more to say but I'm trying to keep this brief. Regards, Larry G. Elkins [EMAIL PROTECTED] Hi! Some of our developers are having concerns about using views in the application. So they approached me and wanted to clarify some of their issues. When I issues a select * from viewname, Oracle executes the underlying select statement of the view. This underlying statement should be optimized (using availabale indexes on tables etc.) If I issue a select * from viewname where condition 3 or the like, will the indexes still be used. Or how is this statement executed? Does Oracle first run the underlying select statement and then apply the where condition 3 to the returned result set? Or is the statement being rewritten internally? The Oracle documentation is not very clear on this. Any ideas would be appreciated. This is 8.1.6 on Win2k. Thanks, Helmut -- 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: 9iAS Forms Server Stability
Larry, I haven't worked with 9iAS yet, but have set up the previous version of iAS on Solaris with Forms 6i. This also uses the Apache server, Jakarta, etc, and we did not experience the problems that you are. Could be that 9iAS is still a bit on the bleeding edge. :) Also, I was using the CGI method. Jared On Wednesday 02 May 2001 17:05, [EMAIL PROTECTED] wrote: Listers, 6i Forms Server in a test environment is crashing quite frequently, 3 to 4 times a day. I'm relaying this question, and I'm not real familiar with the back end configuration details, so I might be off on some things. They have an 8.1.7 test environment with 9iAS 1.0.2. Platform is HP-UX 11. 9iAS 1.0.2, I believe that would be using Forms 6i patch 2. They are using JInitiator. Access is via NT (sp4) clients using IE 5.5. The servlet, not CGI, approach is being used. They are specifying connectmode as HTTP. In the test environment, DB and 9iAS are on the same box. In production, they will be using 4 dedicated HP D class boxes for the forms servers just as they currently do. Anyway, the Forms Server is going down quite a bit in the test environment, 3 or 4 times a day. They currently use Forms 5.0 in a production web deployed environment. While there are some things that are a bit of a pain when web deploying forms, the 5.0 Forms Server has been very stable for them. So, there is some concern about the stability when using 9iAS with the included Apache server along with the Forms Server for 6i. Anyone have success or horror stories they would like to relay? Their current thinking is to wipe everything clean, do a clean re-install (they ran into a few road bumps during the install and wonder if a clean install would help), and see what happens from there. Regards, Larry G. Elkins [EMAIL PROTECTED] -- 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:Fwd: please help
Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, and I'll pass on any advice/suggestions I receive in the meantime. -- 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: X$ tables ??
On Wednesday 02 May 2001 08:30, Mark Leith wrote: You will need to either be connected as SYS or SYSDBA: Well, you can easily remedy that. http://www.ixora.com.au/scripts/sql/create_xviews.sql Courtesy of Steve Adams. Jared -- 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: truncate a table
On Wednesday 02 May 2001 12:50, Behar, Rivaldi wrote: Hi, I want to grant to Scott to Truncate my Emp table (not to truncate all table). How can I do that ? Rivaldi 2 ways. 1. grant DROP ANY TABLE to the user. This is not recommended. 2. create a stored procedure to truncate the table, write a wrapper for the specific table, grant execute on the wrapper. Below are 2 pieces of code. The first is the simple script to set this up and test it. Below that is the trunc_tab procedure code, which you will actually need to create first. Jared test code for truncate wrapper create table test_names ( name varchar2(30)); insert into test_names values( 'jared'); insert into test_names values( 'scott'); commit; create procedure truncate_test_names as begin trunc_tab('TEST_NAMES','JKSTILL'); end; / grant execute on truncate_test_names to scott; trtab.prc --- -- jkstill 10/28/97 -- added 'towner' to specify object owner -- this allows other users the ability to execute -- the 'truncate' if so desired -- eg. -- create or replace procedure ced_detail_truncate -- as -- begin -- ced.trunc_tab('CED_DETAIL','CED'); -- end; -- grant execute on ced_detail_truncate to ced_dev -- create or replace procedure trunc_tab (tname varchar2, towner user_constraints.r_owner%TYPE default user,reuz boolean default false) as /*-\ | Name: Trunc_tab | Description: Given a table name will truncate the table. The table is |assumed to be in the users schema. As a possible |enhancement add a table which has user table mapping, |and check the table before any processing if the current user |has rights to truncate the said (tname) table. | Parameters:tname --- Varchar2, In ; table to be truncated |towner --- varchar2, In ; owner of table - default to USER function |reuz --- Boolean, In ; Option to reause space | Date Written: 12-Feb-95 | Written By:Raj Pande |--- | Mod History: | 12-Feb-95Date Written | 12-Feb-96Given a table, Check dependencies, disable Fk's truncate | Table and then enable Fk constraints. | \*-*/ lv_chld_tableuser_constraints.table_name%TYPE; lv_chld_ownr user_constraints.r_owner%TYPE; lv_chld_cons user_constraints.constraint_name%TYPE; lv_parnt_consuser_constraints.r_constraint_name%TYPE; --lv_ownr user_constraints.r_owner%TYPE := user; lv_ownr user_constraints.r_owner%TYPE; src_cursor integer; stmt_string varchar2(800) ; temp_str varchar2(200); rc integer; lv_cons_countinteger; type str_tab is table of varchar2(800) index by binary_integer; enb_cons_tab str_tab; dsbl_cons_tabstr_tab; CURSOR C_CHILD_TABS is select chld.owner ownr, chld.table_name tabl, chld.constraint_name ccon, chld.r_constraint_name crcon from user_constraints parnt, all_constraints chld where chld.constraint_type = 'R' and chld.r_constraint_name = parnt.constraint_name and chld.r_owner = parnt.owner and chld.status = 'ENABLED' and parnt.table_name = upper(trunc_tab.tname); CURSOR C_CHILD_COLS is SELECT column_name from all_cons_columns WHERE owner = lv_chld_ownr and table_name = lv_chld_table and constraint_name = lv_chld_cons; /*\ | Subroutine: DO_DDL_DSQL | Description: Subroutine to actually execute the dynamic sql(ddl) \*/ PROCEDURE DO_DDL_DSQL is BEGIN dbms_output.put_line('DDL Execute ' || stmt_string); dbms_sql.parse(src_cursor, stmt_string, dbms_sql.native); rc := dbms_sql.execute(src_cursor); dbms_output.put_line('Return code (DDL) is ' || rc); END; /*\ | Subroutine: DO_DML_DSQL | Description: Subroutine to actually execute the dynamic sql(ddl) \*/ FUNCTION DO_DML_DSQL return Number is BEGIN rc := 0; dbms_output.put_line(' DML Execute ' || stmt_string); dbms_sql.parse(src_cursor, stmt_string, dbms_sql.native); rc := dbms_sql.execute(src_cursor); rc := dbms_sql.fetch_rows(src_cursor); dbms_output.put_line('Return code (DML) is ' || rc); return rc; END; /*\ | Subroutine: BLD_DSBL_CON. | Description: A subroutine to build the disabled foreign key definitions
Re: Windows vs. UNIX (you are so ready for B*LLSH*T marketing, *!NOT!*)
On Wednesday 02 May 2001 12:51, Eric D. Pierce wrote: Jared, Apparently there are super geniuses at IBM may have invented a time machine (along with free underground golf planners) that explains the 90 days business. The fact that these 'super geniuses' have hitched their carts to Win2K makes them suspect. Jared -- 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: unix command question
Lee, If you quit using -exec you will do yourself a big favor. That line will fork a shell for each directory found by find. It can be rewritten as: find . -type d | xargs ls -ld Jared On Wednesday 02 May 2001 02:05, Robertson Lee - lerobe wrote: oops, I missed off the -exec bit. find . -type d -exec ls -ld {} \; 2/dev/null Cheers Lee 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: 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).
Question re listener
On system A I am running oracle 8.1.7 on Solaris 5.7. I have a listener.ora file which specifies port 1521. I start the listener. After about 1 to 2 minutes the PMON process registers the second listener and things look like this... LSNRCTL services Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=dbis2.ucdavis.edu)) Services Summary... dbis2 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER dbis2 has 2 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: regulus, pid: 19474 (ADDRESS=(PROTOCOL=tcp)(HOST=regulus)(PORT=46895)) DEDICATED SERVER established:0 refused:0 LOCAL SERVER The command completed successfully LSNRCTL The tnsnames file on system B running 8.1.6 on solaris 7 specifies port 1521 on system A. From system B in sqlplus connect scott@dbis2 (dbis2 is on system a) will allow a connection immediately after the listener on system A is started. After the listener on system A has been running for a minute or two and the second listener has been started I receive the following... SQL connect scott@dbis2 Enter password: ERROR: ORA-12451: TNS:nolistener Warning: You are no longer connected to ORACLE. If however I now change the specified port in the tnsnames on system B to 46895 I am able to connect. I don't understand why the services are starting as they are and why, once the second service is started I am unable to connect via sqlplus. On other systems I look at each listener only has one service handler. The 2 service handlers on the second listener seems to be the problem. I don't understand what is going on here and any help would be greatly appreciated. Thanks. Bill Wagman Univ. of California at Davis Information Resources [EMAIL PROTECTED] (530) 754-6208 - I like to pick up hitchhikers. When they get in the car I say, 'Put on your seat belt. I want to try something. I saw it once in a cartoon, but I think I can do it.' - Steven Wright -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Wagman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
question: create schema ?
Hi all, Do you have a handy way or some scripts to create a schema which is identical to an existing schema (has the same objects, data, grants, etc)? Thank you. Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance of multi datafile tablespaces
Hi, We have a number of large tables that we want to increase the performance of queries against. This will be using 8171 on NT utilising the Parallel query option (PQO) on a server with 4 CPUs. Ideally we would like to partition the tables but due to the cost of the partitioning option (hundreds of thousands of dollars across our 3 sites) we have all but ruled this out for the moment. So, what is being considered is manual striping of datafiles within tablespaces. That is, each tablespace will consist of multiple datafiles (4 is being considered) with each datafile on separate hardware mirror sets. Locally Managed Tablespaces (LMTs) will also be used. I am interested in feedback on this option - eg past experiences, comments, other alternatives etc. Also, do you know of any references / whitepapers on this topic? So far I have found the following: http://www.revealnet.com/newsletter/disk_io_distribution.doc which suggests Physically stripe the temporary tablespace across multiple disks by allocating multiple datafiles with sizes mapped to the tablespace's extent size (so each datafile contains exactly one extent). Metalink articles suggesting using minextent clause on tables / indexes and the need to ensure that the objects don't fit into just 1 extent - or in our case that the objects will require at least 4 extents. Chapter 20 of the Oracle8i Designing and Tuning for Performance manual (8.1.7) under Striping Disks Manually. and such commands as ALTER TABLE ... ALLOCATE EXTENT DATAFILE '...' but the manual reference only refers to when the datafiles are filled by 1 object. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- 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).
RE: Enterprise VS. Standard???
Same exact box, same instance. On NT, I found that I can do an ORADIM -delete, deinstall the software, reinstall the new software, do and ORADIM -new, and then run u0801050.sql. Problem is it leave all of the remnants of enterprise options such as MDSYS,CTXSYS, and AURORA$ORB$UNAUTHENTICATED users. From: "Kevin Kostyszyn" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Enterprise VS. Standard??? Date: Wed, 02 May 2001 08:56:54 -0800 On the same box or different box? That is how I did it, of course it was a really small schema. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Fred Smith Sent: Wednesday, May 02, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Enterprise VS. Standard??? Does anyone out there know what the best method would be to migrate from Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? It appears from the docs that the only way to migrate from Enterprise to Standard is to do an entire rebuild of the database. (Export, de-install, re-install, Build all tablespaces, etc. and Import). Is this correct? OS: Windows NT 4.0 DB: Oracle 8.1.6 Enterprise (going to Standard) Thank you. -Fred Smith -- Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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: Sample Scripts
I'm sorry to hear that about your DBA. How did he die? --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Wednesday, May 02, 2001 9:37 AM To: Multiple recipients of list ORACLE-L Hi, We recently lost our DBA, and as I was standing too close to our IT manager, now I'm it. As I get started on reading and studying, I quickly need some scripts to monitor 'normal' stuff on 7.3.4. I'm used to SQL as a developer, so that helps. So, do you know of a source where I can download some quality scripts? TIA, Rick __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). shousers.sql space_check.sql
RE: Enterprise VS. Standard???
Hi Fred, On Friday, April 20, 2001 4:21 PM, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] answered the same question for version 8.1.7 I actually did this yesterday and I seems to have worked fine on Windows 2000 for Oracle 8.1.7. I don't know if you can do this for 8.1.6 though. Here are the instructions from [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I got the following answers from Oracle support: You can convert from Enterprise Edition to standard edition. You need to shutdown and backup the database and software. -- De-install 817 Enterprise Edition. -- install 817 Standard Editon -- start the database and run catalog.sql and catproc.sql Hope this helps Troy -Original Message- Sent: Wednesday, May 02, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Does anyone out there know what the best method would be to migrate from Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? It appears from the docs that the only way to migrate from Enterprise to Standard is to do an entire rebuild of the database. (Export, de-install, re-install, Build all tablespaces, etc. and Import). Is this correct? OS: Windows NT 4.0 DB: Oracle 8.1.6 Enterprise (going to Standard) Thank you. -Fred Smith _ Get your FREE download of MSN Explorer at http://explorer.msn.com http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thompson, Troy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).