RE: Privileges needed for truncate /thanks all
Hi Thx all those that replied. I've decided to create a procedure to truncate the table and grant execute to the user. Jack Ron Rogers RROGERS@galotterTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] y.org cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Privileges needed for truncate [EMAIL PROTECTED] 24-09-2002 21:08 Please respond to ORACLE-L Jack, I have found that if a user needs to truncate a table then make the user the owner of the table that way the user will have all privileges on the table. The user then will grant the DBA all privileges with the grant option so the DBA can have some resemblence of control over the table. If you only allow a user to delete then as the DBA you have to export the table, truncate the table, and import the data to clean it up and defrag it. Ron ROR mª¿ªm [EMAIL PROTECTED] 09/24/02 02:43PM I agree that this is a security hole. It scares me that someone would need this. I would have expected Oracle to correct this situation, but as of now, they have not. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct:(248) 865-4350 Mobile:(248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Tuesday, September 24, 2002 1:59 PM To: Multiple recipients of list ORACLE-L delete wasn't enough for me. had to grant 'drop any table'. From the Oracle8i SQL Reference Release 3 (8.1.7) manal: To truncate a table or cluster, the table or cluster must be in your schema or you must have DROP ANY TABLE system privilege. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Privileges needed for truncate To truncate you need delete privileges. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 10:23 AM Hi I need to create a user/role that among other stuff must be able to truncate a table. I can't figure out which privileges are needed (DBA is a bit OTT :-)) Try them one by one does not sound appealing at all TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden.
RE: How to display a precedure from sql plus
for procedure source you could query user_source to describe the procedure you could use SQL desc procedure_name -- From: Alaa Mostafa[SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:37 PM To: LazyDBA.com Discussion Subject: How to display a precedure from sql plus Hi All We Create a precedure from sql plus , and we want to desplay it ? thanx _ Do you Yahoo!? New DSL Internet Access http://rd.yahoo.com/evt=1207/*http://sbc.yahoo.com/ from SBC Yahoo! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Subject: Hash Cluster Statistics
List, Does anyone know of some good resources about gathering statistics on Hash Clusters. I am particularly interested in finding out how full our buckets are and any chained links we have currently. Thanks before hand for you help. Tim Boles DBA Lockheed Martin Information Systems [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle InterMedia/Blob,Clob
Hi Experts, Oracle interMedia enables Oracle8i to manage image, audio, video in an integrated fashion with other enterprise information. This means that complex multimedia data can be stored, retrieved, and manipulated by Oracle8i in the same fashion as traditional relational data using data types ORDAudio, ORDImage and ORDVideo. Using JDeveloper i can quickly easily build JSP applications using these data types for storing , retrieving and manipulating image, audio and video files. My questions is how can we achieve the same results with document formats which contain text like *.pdf , *.doc , *.ppt etc ??. I suspect we can use BLOB or CLOB data types to store them but then how the be retrieved and manipulated using web based applications developed using JDeveloper? Kindly recommend any web links or share u'r experience in handling document formats which contain text like *.pdf , *.doc , *.ppt stored in Blobs or Clobs and accessed using web applications. TIA '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Omar Khalid/IT/LotusCert/Pk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN need for alter system archive log all
Thanks for posting the results, Robert. I like the new feature. At least, I don't see how it hurts anyone. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 5:58 PM To: Multiple recipients of list ORACLE-L 9i backup results. Note current log archived message. Starting backup at 24-SEP-02 current log archived channel TMSP_t1: starting archive log backupset channel TMSP_t1: specifying archive log(s) in backup set input archive log thread=1 sequence=110 recid=1 stamp=473438751 input archive log thread=1 sequence=111 recid=2 stamp=473438824 input archive log thread=1 sequence=112 recid=3 stamp=473444662 input archive log thread=1 sequence=113 recid=4 stamp=473444730 channel TMSP_t1: starting piece 1 at 24-SEP-02 released channel: TMSP_t1 8i Results RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: t1 RMAN-08500: channel t1: sid=21 devtype=SBT_TAPE RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 - Release 3.4GA (030800) RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08009: channel t1: starting archivelog backupset RMAN-08502: set_count=133 set_stamp=473445972 creation_time=24-SEP-02 RMAN-08014: channel t1: specifying archivelog(s) in backup set RMAN-08504: input archivelog thread=1 sequence=3039 recid=1 stamp=473445815 RMAN-08013: channel t1: piece 1 created RMAN-08503: piece handle=45e3gdik_1_1 comment=API Version 2.0,MMS Version 3.2.0. 0 RMAN-08525: backup set complete, elapsed time: 00:01:36 RMAN-08031: released channel: t1 No sign of current log being archived, and it didn't show up in the archivelog directory. So, I'd say this is a 9i new feature. Interesting. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Tuesday, September 24, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Egads, I made a stupid misfire of the brain. The current log IS switched during an archive log backup (i.e. BACKUP ARCHIVELOG ALL). Sorry for the mistypo... RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Tuesday, September 24, 2002 2:35 PM To: '[EMAIL PROTECTED]' What version of RMAN are you talking about. In the 9iR2 documentation for RMAN is clearly states that during backups using the PLUS ARCHIVELOG command, RMAN does force a log switch. When you do a backup using the PLUS ARCHIVELOG command RMAN will: Run ALTER SYSTEM ARCHIVE LOG CURRENT Runs the BACKUP ARCHIVELOG ALL command. Backs up the files specified in the BACKUP command. Run ALTER SYSTEM ARCHIVE LOG CURRENT again. Back up any remaining archived redo logs. A normal backup of archived redo logs such as BACKUP ARCHIVELOG ALL will not result in a log switch. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Tuesday, September 24, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Dennis, I don't think that Rman automatically performs a SYSTEM ARCHIVE. At least. I've not seen it. In my archive Rman database backups, I issue an 'alter system archive log current' before I backup the archive files to make sure that I have the latest archive I can possible get. Unless I'm convinced that Rman is doing this for me, I have no reason to change my procedures. You could certainly include this command both within an Rman script or elsewhere to make sure that you get the same benefit. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Ruth - At this point we just RMAN to disk. Someone on this list provided that advice as start simple. I was using RMAN to store the archive logs, but that just used up twice the disk space and I could discern no benefit so I stopped it (always open to new reasons). On recovery, RMAN uses the original archive logs just fine. I just want to make sure we have the right archive logs on tape, and this morning I posted an update to my original question, namely that I found where RMAN automatically issues an ALTER SYSTEM ARCHIVE LOG CURRENT. I'm a little confused about the timestamp on the archive logs, but I guess I just have to take it on faith that Oracle and RMAN are doing the right thing. Thanks Ruth. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original
RE: ORA-03113 with dbms_output and sysdate
Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3 END; 4 / WED, SEP 25 15:32:28002 PL/SQL procedure successfully completed. SQL ; 1 BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3* END; SQL / ERROR: ORA-03114: not connected to ORACLE BEGIN * ERROR at line 1: ORA-12571: TNS:packet writer failure SQL hth, Nirmal. -Original Message- Sent: Tuesday, September 24, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03113 with dbms_output and sysdate
Seems like not a network then. Have you read a note 1020463.6 (mind you, it is a bit dated)? inka -Original Message- Sent: Tuesday, September 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L I will try that. The confusing part is I can run : select TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') into datevar from dual; dbms_output.put_line( datevar); and it works fine. I can run all my other sql scripts without error. I'd be surprised if it was a network error, but I'm willing to look at anything. steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 1:23 PM It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to do for point at the first line of openned cursor
Hi Friends Is there any way to point at the first line of openned cursor ? For example : After apply the for ... loop at the finished i would like to set the first line , but i don't want to open it again Regards Eriovaldo Andrietta [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Initialzation of c:\winnt\system32\DLL user32.dll failed
Hi DBAs, WinNT service pack 6. Oracle 8.1.6. On several of the servers I am getting Initialzation of c: \winnt\system32\DLL user32.dll failed. Notes on MetaLink are not applicable. The only thing added to these servers was TrendMicro server protect 5.31. I do not know if coincidence or cause. The error is intermittent. Has anyone else had this failure? If so please share any cause/resolution. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Changing ONAMES enrtries fiasco
Hey all, I want to make changes to the ONAMES region database (8.0.5.0.1 on OpenVMS) entries because I didn't fully qualify the host names in the network aliases. And now that I can VPN in to work (thanks to DirecTV DSL!), I can't use ONAMES because my machine at home is in a different IP domain. After going round with Oracle Support because they thought I wanted to default domain the alias instead of the IP host, they say that the only way to change an existing ONAMES alias is to drop and recreate it. W! So, I've experimented with directly modifying the rows of the ONRS_REGION table in the region database with some success. e.g. I've changed this: (DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) (CONNECT_DATA = (SID = mysid) to this: (DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.qtiworld.com)(PORT = 1521)) (CONNECT_DATA = (SID = mysid) ...in the aforementioned table and reloaded the primary and secondary ONAMES servers with NAMESCTL RELOAD. A 9iR2 tnsping using ONAMES for names resolution proved that the new address was used successfully. Has anyone else done this change safely and successfully in a production environment? I'm not able to reproduce the production Oracle Networking environment, so I can't really make a valid test area. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i : Segment space management
Does anyone know of a way to modify existing tablespaces to use the Auto SEGMENT SPACE MANAGEMENT in a 8i dbs upgraded to 9i ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kawatra V (Vikas) at Aera INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-03113 with dbms_output and sysdate
SET SERVEROUTPUT ON BEGIN dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); END; / WED, SEP 25 10:20:10002 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:38 AM Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3 END; 4 / WED, SEP 25 15:32:28002 PL/SQL procedure successfully completed. SQL ; 1 BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); 3* END; SQL / ERROR: ORA-03114: not connected to ORACLE BEGIN * ERROR at line 1: ORA-12571: TNS:packet writer failure SQL hth, Nirmal. -Original Message- Sent: Tuesday, September 24, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Initialzation of c:\winnt\system32\DLL user32.dll failed
First, try a simple reinstall of your current service pack. If that fails to solve the problem then see if this link applies: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q142676; Is another virus protect product running at the same time as TrendMicro server protect? If so then try shutting down the services for the other product. Good Luck, Ed -Original Message- Sent: Wednesday, September 25, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Hi DBAs, WinNT service pack 6. Oracle 8.1.6. On several of the servers I am getting Initialzation of c: \winnt\system32\DLL user32.dll failed. Notes on MetaLink are not applicable. The only thing added to these servers was TrendMicro server protect 5.31. I do not know if coincidence or cause. The error is intermittent. Has anyone else had this failure? If so please share any cause/resolution. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?
Let me clarify my original question. I do not expect the FreeList for a table to get updated instantaneously after I change the PCTFREE/PCTUSED. What I meant by is the effect ... immediate is that do the new values come into play immediately -- even for existing blocks. Suppose I have a table where PCTFREE was high (40) and PCTUSED high (50 or 60). Thus, ignoring deletes [and overheads], there would have been about 60% [100-40] usage in the block -- these could mean a large number of rows. Now, I want to reduce the number of rows in a block -- the particular table is a hot table where some blocks become very hot spots [extremely high rate of updates to existing rows, updates which do not increase the size of existing rows]. My cache buffer chains latch contention is high. I further introduce the possibility of deletes [e.g. a purge job running daily]. Because PCTUSED is high, and not very many rows in a block get deleted at each purge, the block is unlikely to come into the FreeList early. It would be a number of days before enough rows are deleted from the block. Therefore, to reduce the contention for the hot blocks, I decide to have only 1 row in each block. Normally, with a *NEW* table, PCTFRE 99 and PCTUSED 1 would ensure that I have only 1 row per block. But if I have a large number of blocks in a few extents created when PCTFREE was 40 and PCTUSED 50 or 60. When would these existing blocks start behaving as if they were created with PCTFREE 99 and PCTUSED 1 ? How about new blocks ? Would new [empty] blocks in existing extents immediately behave such that they allow only one row per block ? Or would only new blocks in new extents take the PCTFREE 99 and PCTUSED 1 attributes ? Hemant At 03:53 PM 24-09-02 -0800, you wrote: I replied too soon earlier, I think. Yes, what you state is correct. Jraed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend that if a table is fully loaded upto its pctfree/pctused limits and there are no available blocks on the freelist then by changing the pctfree/pctused values no additional blocks will suddenly appear on the freelist. I do agree however that if a block is amended by having a row deleted or a row updated then the new values come into play and the blockcould then be available on the freelist. I think I am correct on this but as with anything I am always ready to be proved wrong - it has happened before and wil lhappen may times in the future John -Original Message- Sent: 24 September 2002 15:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Are you sure about that John? On Tuesday 24 September 2002 04:28, [EMAIL PROTECTED] wrote: No, it is not retrospective. You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?
Hemant, If I understand your question correctly, trying using the alter table move command and specify new values for pctfree and pctused. This should affect existing blocks. Make sure to rebuild any indicies. HTH, -- Alan Davey [EMAIL PROTECTED] On 9/25/2002 11:38 AM, Hemant K Chitale [EMAIL PROTECTED] wrote: Let me clarify my original question. I do not expect the FreeList for a table to get updated instantaneously after I change the PCTFREE/PCTUSED. What I meant by is the effect ... immediate is that do the new values come into play immediately -- even for existing blocks. Suppose I have a table where PCTFREE was high (40) and PCTUSED high (50 or 60). Thus, ignoring deletes [and overheads], there would have been about 60% [100-40] usage in the block -- these could mean a large number of rows. Now, I want to reduce the number of rows in a block -- the particular table is a hot table where some blocks become very hot spots [extremely high rate of updates to existing rows, updates which do not increase the size of existing rows]. My cache buffer chains latch contention is high. I further introduce the possibility of deletes [e.g. a purge job running daily]. Because PCTUSED is high, and not very many rows in a block get deleted at each purge, the block is unlikely to come into the FreeList early. It would be a number of days before enough rows are deleted from the block. Therefore, to reduce the contention for the hot blocks, I decide to have only 1 row in each block. Normally, with a *NEW* table, PCTFRE 99 and PCTUSED 1 would ensure that I have only 1 row per block. But if I have a large number of blocks in a few extents created when PCTFREE was 40 and PCTUSED 50 or 60. When would these existing blocks start behaving as if they were created with PCTFREE 99 and PCTUSED 1 ? How about new blocks ? Would new [empty] blocks in existing extents immediately behave such that they allow only one row per block ? Or would only new blocks in new extents take the PCTFREE 99 and PCTUSED 1 attributes ? Hemant At 03:53 PM 24-09-02 -0800, you wrote: I replied too soon earlier, I think. Yes, what you state is correct. Jraed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend that if a table is fully loaded upto its pctfree/pctused limits and there are no available blocks on the freelist then by changing the pctfree/pctused values no additional blocks will suddenly appear on the freelist. I do agree however that if a block is amended by having a row deleted or a row updated then the new values come into play and the blockcould then be available on the freelist. I think I am correct on this but as with anything I am always ready to be proved wrong - it has happened before and wil lhappen may times in the future John -Original Message- Sent: 24 September 2002 15:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Are you sure about that John? On Tuesday 24 September 2002 04:28, [EMAIL PROTECTED] wrote: No, it is not retrospective. You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
datafile sizing question
Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?
Hemant wrote Therefore, to reduce the contention for the hot blocks, I decide to have only 1 row in each block. Normally, with a *NEW* table, PCTFRE 99 and PCTUSED 1 would ensure that I have only 1 row per block. But if I have a large number of blocks in a few extents created when PCTFREE was 40 and PCTUSED 50 or 60. When would these existing blocks start behaving as if they were created with PCTFREE 99 and PCTUSED 1 ? How about new blocks ? Would new [empty] blocks in existing extents immediately behave such that they allow only one row per block ? Or would only new blocks in new extents take the PCTFREE 99 and PCTUSED 1 attributes ? I would guess the following Hemant, After changing the PCTFREE/PCTUSED values I do not think existing blocks will be changed until sufficient rows are deleted so that a block will be available on the freelist. If as you say there is only 1 row to a block then that would need to be deleted so that the block became available on the freelist and the new values would apply once a new row was inserted. Moving on from there it seems logical to me (that may be where I am going wrong!!) that an existing empty block will have it's values changed and will remain on the freelist but with revised parameters. I cannot say for certain without performing some tests but that is my gut feel HTH John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
Hi Rachel, I know the guy who creates the warehouses here uses 4Gb datafiles (I believe he creates them at 4050Mb). We are on Tru64 Unix He is on his honeymoon at the moment so I cannot ask him his reasoning. Regards Lee -Original Message- Sent: 25 September 2002 17:33 To: Multiple recipients of list ORACLE-L Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** The information contained in this 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. Thank You. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Yet another request for your experiences
On a system with ASYNC IO Enabled, have you seen any benefits from enabling multiple DBWR processes, and if so how much of an impact did you see? I've experimented with this before and didn't see much improvement, but I'm curious what others experiences are. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: For the MicroSoft bashers
Google search leads to Gates of 'hell' Type go to hell (using the quotation marks) into Google's search engine, and the first result served up is Microsoft.com. http://computerworld.com/newsletter/0%2C4902%2C74566%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle trace file question
Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID SOURCE_REFERENCE 101 INDEX RANGE SCAN (object id 3294) 100 TABLE ACCESS BY INDEX ROWID ACCOUNT_MASTER 101 INDEX RANGE SCAN (object id 3214) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help on Effect of changing NLS_LANGUAGE to maerican_america.utf8
Hi Gurus We customize pharmaceutical processing industry applications. One of our client is going global. The client needs to change NLS_LANGUAGE setting to NLS_LANG="american_america.utf8". I would like to know how to change this and what impacts will it have on reports and forms already custom developed for this client? There are some barcode checksum calculation procedures for some reports. Willthey get impacted by changing the NLS_LANG? A input on this is highly appreciated Regards Shiva Baswannappa
Re:Backup Strategy - Informal Surve
See Note:199416.1 and the Bug No.2410612 CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT on metalink. I recently had problem while reorganizing some tables in our Baan production database using export and import. The import was failing with duplicate key s in table errors. Manmohan. Tired of all the SPAM in your inbox? Switch to LYCOS MAIL PLUS http://www.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anubha Jalsingh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load
Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
I know that wuth 64 bit HP-UX and 64 bit Oracle RDBMS, I have no problems with 1 8GB file. I don't know much about Solaris, but I suppose the following will work: nm $ORACLE_HOME/lib/libclntsh.so|grep lseek64 Results should be nonempty and look something like this: __lseek64 | |undef |code | __lseek64 | 6589540|uext |stub | __lseek64 | 7173576|uext |stub | That meens that lseek64 is used, as an external symbol, from the OS libraries. That, in turn, means that your oracle is using 64 bit routines and is, therefore, 64 bit itself and can handle large files. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject: datafile sizing question Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i : Segment space management
You want to use compressed table? Just do a quick ALTER TABLE and everything will be cool. -Original Message- From: Kawatra V (Vikas) at Aera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Subject: 9i : Segment space management Does anyone know of a way to modify existing tablespaces to use the Auto SEGMENT SPACE MANAGEMENT in a 8i dbs upgraded to 9i ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kawatra V (Vikas) at Aera INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle InterMedia/Blob,Clob
The interMedia Text option certainly handles PDF, DOC PPT. I believe JDeveloper is pretty well integrated with interMedia Text, so I suspect that it does what you're looking for. At 06:33 AM 9/25/2002, Omar Khalid/IT/LotusCert/Pk wrote: Hi Experts, Oracle interMedia enables Oracle8i to manage image, audio, video in an integrated fashion with other enterprise information. This means that complex multimedia data can be stored, retrieved, and manipulated by Oracle8i in the same fashion as traditional relational data using data types ORDAudio, ORDImage and ORDVideo. Using JDeveloper i can quickly easily build JSP applications using these data types for storing , retrieving and manipulating image, audio and video files. My questions is how can we achieve the same results with document formats which contain text like *.pdf , *.doc , *.ppt etc ??. I suspect we can use BLOB or CLOB data types to store them but then how the be retrieved and manipulated using web based applications developed using JDeveloper? Kindly recommend any web links or share u'r experience in handling document formats which contain text like *.pdf , *.doc , *.ppt stored in Blobs or Clobs and accessed using web applications. TIA '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Omar Khalid/IT/LotusCert/Pk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
Are you going with 2048M or the traditional 2000m? A quick dirty way to not waste the space is to use 2001m or 2041m. You 'waste' a little space, but not much. Dan Fink -Original Message- Sent: Wednesday, September 25, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on Effect of changing NLS_LANGUAGE to maerican_america.utf8
What version of the database? What version of forms/reports? What platform? What is the current characterset of the database? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/25/02 10:03 AMcc: Please respond toSubject: Help on Effect of changing NLS_LANGUAGE to ORACLE-L maerican_america.utf8 Hi Gurus We customize pharmaceutical processing industry applications. One of our client is going global. The client needs to change NLS_LANGUAGE setting to NLS_LANG=american_america.utf8. I would like to know how to change this and what impacts will it have on reports and forms already custom developed for this client? There are some barcode checksum calculation procedures for some reports. Will they get impacted by changing the NLS_LANG? A input on this is highly appreciated Regards Shiva Baswannappa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Best Practice - Partitioned object, one partition per tablespace,
We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file question
Okay, I think I answered my own question. If you look at the Fetch line on the select * calls, it is zero. My guess is that ADO is just checking for the existence of each table before it makes the real SQL call. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID SOURCE_REFERENCE 101 INDEX RANGE SCAN (object id 3294) 100 TABLE ACCESS BY INDEX ROWID ACCOUNT_MASTER 101 INDEX RANGE SCAN (object id 3214) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
Fwd: Diets
The Japanese eat very little fat and suffer fewer heart attacks than the British or Americans. The French eat a lot of fat and also suffer fewer heart attacks than the British or Americans. from a friend,,, The Japanese drink very little red wine and suffer fewer heart attacks than the British or Americans. The Italians drink excessive amounts of red wine and also suffer fewer heart attacks than the British or Americans. The Germans drink a lot of beers and eat lots of sausages and fats and suffer fewer heart attacks than the British or Americans. CONCLUSION: Eat and drink what you like. Speaking English is apparently what kills you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
Title: RE: datafile sizing question We created two datafiles of 16GB+64K all LMT autoallocate ... never gave a problem. A basic testing concluded that fixed size allocation of 128M caused unnecessary delays whereas autoallocate was much faster. I don't know the full details yet, but I'll know soon. Of course this is undergoing lot of testing (the whole application, no problems with datafiles yet), but we will probably settle for about 4GB+64K. This is AIX5L 64 bit running Oracle 9iR2. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: datafile sizing question
AHA!I was going to go with 2000M so that's beautiful, 2001M would work perfectly without going over. I don't mind wasting less than a meg. I love the logic everyone here at work has. disk is cheap, don't worry about it. Except every time I ask for more disk, I hear it's too expensive Rachel --- Fink, Dan [EMAIL PROTECTED] wrote: Are you going with 2048M or the traditional 2000m? A quick dirty way to not waste the space is to use 2001m or 2041m. You 'waste' a little space, but not much. Dan Fink -Original Message- Sent: Wednesday, September 25, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Yet another request for your experiences
On VMS, I believe the I/O is async by default (probably via $QIO calls), so there's no benefit there. This is from memory, as I'm not able to confirm or deny that with a quick search. On HP/UX, you can't use async with a cooked volume, and in MetaLink 139272.1 it says not to use multiple DBWRs with async (not recommended). It doesn't state wether or not this is generic advice or platform specific. HTH! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Subject: Yet another request for your experiences On a system with ASYNC IO Enabled, have you seen any benefits from enabling multiple DBWR processes, and if so how much of an impact did you see? I've experimented with this before and didn't see much improvement, but I'm curious what others experiences are. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file question
Dennis, I've seen ADO do some pretty strange stuff under the covers on my project also. Ny guess is that ADO is sending these sql statements kinda like a prepare statement, just to see if the query will pass muster - like basic security checks - does the table exists, etc. My guess is that it just compiles the sql, but does not fetch any data. We had something similar with all of our PL/SQL Package call statements. We traced ADO doing a DBMS_DESCRIBE {package_name} first, getting the parameter names, then calling the package directly. We got Microsoft in here for another problem, and he told the developers how to stop ADO from doing that. It was all an un-documented item, by the way. If you can, post the question to the Microsoft development team and see what they say about it. My guess is that they could help you resolve the problem. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 25, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID
RE: Oracle trace file question
That's one way to get a 99.99% buffer cache hit ratio for the statement! -Original Message- Sent: Wednesday, September 25, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID SOURCE_REFERENCE 101 INDEX RANGE SCAN (object id 3294) 100 TABLE ACCESS BY INDEX ROWID ACCOUNT_MASTER 101 INDEX RANGE SCAN (object id 3214) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the
RE: datafile sizing question
I'm betting that it's not 64-bit Oracle. See, I am the development DBA. As an employee, I get to create the scripts, but I don't get to run them or even get access as oracle to the servers. In other words, all the grunt work, all the responsibility for problems (production is managed by a hosting company) but none of the power to make sure it's right. I love my job. Why? Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: I know that wuth 64 bit HP-UX and 64 bit Oracle RDBMS, I have no problems with 1 8GB file. I don't know much about Solaris, but I suppose the following will work: nm $ORACLE_HOME/lib/libclntsh.so|grep lseek64 Results should be nonempty and look something like this: __lseek64 | |undef |code | __lseek64 | 6589540|uext |stub | __lseek64 | 7173576|uext |stub | That meens that lseek64 is used, as an external symbol, from the OS libraries. That, in turn, means that your oracle is using 64 bit routines and is, therefore, 64 bit itself and can handle large files. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject: datafile sizing question Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best Practice - Partitioned object, one partition per tablesp
Title: RE: Best Practice - Partitioned object, one partition per tablespace, BTW, moving partitions from one tablespace to another is quick and easy so if later you have a real reason to have more tablespaces you can create them - our I/O configuration and access path did not warrant it at this time. -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Best Practice - Partitioned object, one partition per tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best Practice - Partitioned object, one partition per tablesp
Robert - That is how I've generally done it. If you are partitioning because the table is very large, then separate tablespaces gives you the flexibility to place these partitions on separate devices so you can get some parallel I/O going. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
I believe that the OS filesystem has to be configured for large file support (on HP-UX, it's a kernel parameter) to allow files 2 GB. I usually just add 1 MB to the file size to allow for the header. Personally, I'd play it safe and go with however many 2001 MB files you need to accommodate your objects. --- Rachel Carmichael [EMAIL PROTECTED] wrote: I'm betting that it's not 64-bit Oracle. See, I am the development DBA. As an employee, I get to create the scripts, but I don't get to run them or even get access as oracle to the servers. In other words, all the grunt work, all the responsibility for problems (production is managed by a hosting company) but none of the power to make sure it's right. I love my job. Why? Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to reproduce a hanging connect attempt
OK, maybe adequate was the wrong word. It *can* be done with ksh. But it's rather ungainly. In Perl: my $dbh = ''; eval { local $SIG{ALRM} = sub { die }; alarm 60; my $dbh = DBI-connect( 'dbi:Oracle:' . $db, 'scott','tiger', ); }; alarm 0; unless ($dbh) { print db $db is down; } In addition, there are a number of other things I do with my monitoring scripts that could probably be done in ksh, but Perl is a much better tool for the job. Notification of DBA's on a rotating schedule, optional notification of a manager. Set hours of operation per database, don't page the DBA outside those hours, just send email. Set hours to page immediately, outside of those hours don't page until a configurable number of attempts have been made. etc, etc, etc. Now I'm getting far afield, and I'll stop. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 05:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How to reproduce a hanging connect attempt Jared, It is adequate. Below is snip from Steve Adams's script (db_check.sh) and I successfully used similar technique for some time. -- snip rm -f $READY print connect nobody/really host touch $READY exit | sqlplus /nolog $SPOOL # wait for up to 59 seconds # ((timeout = 60)) while ((timeout -= 1)) [[ ! -r $READY ]] do sleep 1 done # check for hang # [[ -r $READY ]] || { kill $! msg=$PROGRAM: Oracle instance $ORACLE_SID is not responding $DEBUG logger -p oracle.err $msg STATUS=1 $INTERACTIVE $msg continue } -- snip Alex. -Original Message- Sent: Tuesday, September 24, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Thanks for the info Ian. I've been asked to prove why sqlplus and ksh are not adequate for checking connectity. The third possibility, a hang, is exactly that reason. I'm trying to duplicate what can actually happen to cause a hanging connection. I've been burned by that in the past when my script didn't properly allow for hangs. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How to reproduce a hanging connect attempt Have you fooled with the CONNECT_TIMEOUT_LISTENER parameter of listener.ora? Setting it to 0 won't guarantee a connection will hang, but will tell a process to wait forever to connect. Hanging connections were a problem for us with the earlier Oracle 6 releases. My solution was less elegant. It used one program which attempted to connect, wrote a timestamp, and signaled if the connection failed ; another checked the timestamp against the current time and signaled if yhe difference was too great I cannot recall seeing the hanging problem for years, but we still run the program to check for it. I've been stating that three things can happen on an Oracle connection attempt for years: it can be successful, it can fail, or it can hang and return nothing. Yet, 100% of the scripts I see which attempt to connect to the database to ensure it is functional do not consider the third possibility. Seems with your upcoming article that percentage will drop to 99.. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 10:03 PM To: Multiple recipients of list ORACLE-L Dear List, As an example for an article I'm working on, I'm showing how a hanging connect can be timed out in a Perl script via the alarm() call. By 'hanging connect' I mean a connection attempt that never connects and never returns an error code. I have one right now on my Linux box. I started a database, did kill -9 on the oracle processes, and now attempts to login to the database hang. It's been that way for 24 hours now. e.g. sqlplus scott/tiger@ts98 . never returns an error code, never connects. Guess it isn't going to connect. This could be a problem in a ksh script written to check connectivity. ( which is why I use Perl ) The question is, why? What is a consistent way to reproduce this error? The method I used isn't consistent. This is something that I see happen from time to time on Oracle databases, both NT and Unix platforms, hence the reason for the timeout on the connect. Any thoughts on how to consistently reproduce this, on either platform? Thanks, Jared -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
Re: Best Practice - Partitioned object, one partition per tablespace,
That's the way I've done it. It let's you drop a partition and drop the tablespace so nothing is left. --- Freeman, Robert [EMAIL PROTECTED] a écrit : We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best Practice - Partitioned object, one partition per tablespace,
it's what I'm planning on doing... seems to me that when we decide to remove partitions, we can easily do so and retrieve the disk space this way --- Freeman, Robert [EMAIL PROTECTED] wrote: We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load
-Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
V$sql_area 0 affected but commited.
Hi, We have a strange behavior on our Oracle 8.1.7.x Db on Solaris. We have an update that 'probably' update all rows from a table. But when we check the v$sql_area view we have 0 rows affected and 1 execution. How is it possible ? // W.B __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Place for oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Two Q's for SAP DBA's
Got a couple of questions for those of you dealing with SAP: 1) Has anyone heard of a timeline as to when (or if) SAP R3 will support Oracle 9.x? And, 2) Has anyone implemented table partitions as a method of space management in conjunction SAP archiving? The table dependencies within SAP Archive objects would seem to make this difficult at best? Thanks for any feedback. Mike Hand Polaroid Corp - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load
It is your own fault. You should have called all interested parties with details as soon as that problem was resolved. And remember: if by any chance the problem resolution takes all night, call hourly with the progress report. -Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best Practice - Partitioned object, one partition per tablesp
Title: RE: Best Practice - Partitioned object, one partition per tablespace, What if working on limited I/O so that striping is done at the OS level mostly. In this case there is no advantage to one partition - one tablespace and if there are many partitions it just gets hard to maintain. Partition elimination without separate I/O is the advantage of partitioning along with local indexes which is not dependent on the partitions tablespace. Therefore, I have grouped historical partitions into one tablespace then created separated tablespace on the most accessed partitions - say last 10 years. I find this easier to manage. -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Best Practice - Partitioned object, one partition per tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file question
Boy, I go to a new job and I don't have any of my old notebooks. I remember something like this from the past from a third-party app. The first three queries would just be verifying the existance of the object. Can't remember if it was via a SELECT * (I don't think so) or some other similar query. Your app isn't really doing a SELECT * since the fetch.count and fetch.rows are both 0, so I bet it is also just object verification. Henry -Original Message- WILLIAMS Sent: Wednesday, September 25, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID SOURCE_REFERENCE 101 INDEX RANGE SCAN (object id 3294) 100 TABLE ACCESS BY INDEX ROWID ACCOUNT_MASTER 101 INDEX RANGE SCAN (object id 3214) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: Diets
No habla Ingles. -Original Message- From: Regina Harter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Fwd: Diets The Japanese eat very little fat and suffer fewer heart attacks than the British or Americans. The French eat a lot of fat and also suffer fewer heart attacks than the British or Americans. from a friend,,, The Japanese drink very little red wine and suffer fewer heart attacks than the British or Americans. The Italians drink excessive amounts of red wine and also suffer fewer heart attacks than the British or Americans. The Germans drink a lot of beers and eat lots of sausages and fats and suffer fewer heart attacks than the British or Americans. CONCLUSION: Eat and drink what you like. Speaking English is apparently what kills you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best Practice - Partitioned object, one partition per tablesp
That's the strategy I have followed in my databases. Each table partition and each index partition is in its own tablespace. Helps me a lot when I do any maintenance operations. Partitioning is by 4 digit calendar year. - Kirti -Original Message- Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
Rachel, that is the same thing as with money itself. Everybody keeps telling me that money isn't everything and that there are many things in life which are more important then money, but when I ask for a check to $10,000 nobody wants to give it to me. Humans are so hard to comprehend for us Vogons. Let me know if you'd like me to recite some poetry. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: datafile sizing question AHA!I was going to go with 2000M so that's beautiful, 2001M would work perfectly without going over. I don't mind wasting less than a meg. I love the logic everyone here at work has. disk is cheap, don't worry about it. Except every time I ask for more disk, I hear it's too expensive Rachel --- Fink, Dan [EMAIL PROTECTED] wrote: Are you going with 2048M or the traditional 2000m? A quick dirty way to not waste the space is to use 2001m or 2041m. You 'waste' a little space, but not much. Dan Fink -Original Message- Sent: Wednesday, September 25, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
Rachel, if you can execute sqlplus, you can do the nm thing. You don't need to log in as oracle. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: datafile sizing question I'm betting that it's not 64-bit Oracle. See, I am the development DBA. As an employee, I get to create the scripts, but I don't get to run them or even get access as oracle to the servers. In other words, all the grunt work, all the responsibility for problems (production is managed by a hosting company) but none of the power to make sure it's right. I love my job. Why? Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: I know that wuth 64 bit HP-UX and 64 bit Oracle RDBMS, I have no problems with 1 8GB file. I don't know much about Solaris, but I suppose the following will work: nm $ORACLE_HOME/lib/libclntsh.so|grep lseek64 Results should be nonempty and look something like this: __lseek64 | |undef |code | __lseek64 | 6589540|uext |stub | __lseek64 | 7173576|uext |stub | That meens that lseek64 is used, as an external symbol, from the OS libraries. That, in turn, means that your oracle is using 64 bit routines and is, therefore, 64 bit itself and can handle large files. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject: datafile sizing question Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11
Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help on Effect of changing NLS_LANGUAGE to maerican_america.u
Sorry Gurus The database version is: 8.1.6.0.0 Reports: 6.0.5.28.0 Forms: 6.0.5.2 Current NLS_LANGUAGE: AMERICAN Current NLS_NCHAR_CHARACTERSET: WE8ISO8859P1 Current NLS_CHARACTERSET: WE8ISO8859P1 Current NLS_CALENDAR: GREGORIAN Appreciate your response Shiva -Original Message- Sent: Wednesday, September 25, 2002 1:38 PM To: Multiple recipients of list ORACLE-L maerican_america.utf8 What version of the database? What version of forms/reports? What platform? What is the current characterset of the database? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 09/25/02 10:03 AMcc: Please respond toSubject: Help on Effect of changing NLS_LANGUAGE to ORACLE-L maerican_america.utf8 Hi Gurus We customize pharmaceutical processing industry applications. One of our client is going global. The client needs to change NLS_LANGUAGE setting to NLS_LANG=american_america.utf8. I would like to know how to change this and what impacts will it have on reports and forms already custom developed for this client? There are some barcode checksum calculation procedures for some reports. Will they get impacted by changing the NLS_LANG? A input on this is highly appreciated Regards Shiva Baswannappa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Changing ONAMES enrtries fiasco
After having little success with registering and dropping using the namesctl commands. I have used direct insert, update to the ONRS_REGION table as the peferred method to tp update the region database. No problems so far. make sure you have no space in any descriptions. I even have script to do the registering. #!/usr/bin/ksh ### ### created by J. JOB 11/22/2001 # This Script registers a database to the Oracle Names server. # Parameters expected are # 1: SID : SID of the databse # 2: Service Name: The Name by which the database will be called. # 3: Host Name : The Name of the machine on which the database resides # 4: Connection type : dedicated or shared ### PATH=/usr/local/bin PATH=${PATH}:. PATH=${PATH}:/bin:/sbin:/usr/bin:/usr/sbin:/etc export PATH SID_NAME=$1 SERVICE_NAME=$2 HOST_NAME=$3 DEDI_SHARED=$4 DESCRIPTION=(DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP)(HOST=${HOST_NAME})(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=${SID_NAME})(ser ver=${DEDI_SHARED}) echo $DESCRIPTION . local_oraenv ORTL sqlplus EOF oname/oname@ORTL insert into ONRS_REGION values('(root)','${SERVICE_NAME}','${DESCRIPTION}'); commit; exit EOF --- Jesse, Rich [EMAIL PROTECTED] wrote: Hey all, I want to make changes to the ONAMES region database (8.0.5.0.1 on OpenVMS) entries because I didn't fully qualify the host names in the network aliases. And now that I can VPN in to work (thanks to DirecTV DSL!), I can't use ONAMES because my machine at home is in a different IP domain. After going round with Oracle Support because they thought I wanted to default domain the alias instead of the IP host, they say that the only way to change an existing ONAMES alias is to drop and recreate it. W! So, I've experimented with directly modifying the rows of the ONRS_REGION table in the region database with some success. e.g. I've changed this: (DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) (CONNECT_DATA = (SID = mysid) to this: (DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.qtiworld.com)(PORT = 1521)) (CONNECT_DATA = (SID = mysid) ...in the aforementioned table and reloaded the primary and secondary ONAMES servers with NAMESCTL RELOAD. A 9iR2 tnsping using ONAMES for names resolution proved that the new address was used successfully. Has anyone else done this change safely and successfully in a production environment? I'm not able to reproduce the production Oracle Networking environment, so I can't really make a valid test area. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best Practice - Partitioned object, one partition per tablesp
Exactly the way we do it as well. Each table and index partition are in their own tablespaces (indexes are local and not global) Regards Lee -Original Message- Sent: 25 September 2002 20:54 To: Multiple recipients of list ORACLE-L tablespace, it's what I'm planning on doing... seems to me that when we decide to remove partitions, we can easily do so and retrieve the disk space this way --- Freeman, Robert [EMAIL PROTECTED] wrote: We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** The information contained in this 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. Thank You. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to reproduce a hanging connect attempt
In Perl: my $dbh = ''; eval { local $SIG{ALRM} = sub { die }; alarm 60; my $dbh = DBI-connect( 'dbi:Oracle:' . $db, 'scott','tiger', ); }; alarm 0; unless ($dbh) { print db $db is down; } Humm do you know what the alarm function on windows 2000 pro is?? Im gettting The Unsupported function alarm function is unimplemented at C:\evaldb.pl line 11. It looks like alarm is a perl function I can see the doc from Perldoc -f alarm Nevertheless I get the unsupported function Line 11 is alarm 0; ?? Thanks rob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file question
Dennis, Ask Anjo about his Magic utility. Using that utility one has to set an environment variable on the client which would tune and avoid extra parse sql before they are sent to Oracle. Infact Cary mentions about this in his emails. btw we use delphi 3rd party ODAC component instead of ADO/BDE which avoids extra parse. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Subject: Oracle trace file question Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? ** ** select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 ** ** select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 ** ** select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 ** ** select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID SOURCE_REFERENCE 101 INDEX RANGE SCAN (object id 3294) 100 TABLE ACCESS BY INDEX ROWID ACCOUNT_MASTER 101 INDEX RANGE SCAN (object id 3214) ** ** *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS
BLOB through java stored procedure
Hi, Is it possible to write a BLOB as a file on the OS through a Java stored procedure? Regards, Manav. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manavendra Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
I think it's automatic on Solaris 2.8 but I don't know for sure so I'd rather not rely on it. I'm going with 2001M and creating about a year's worth of tablespaces/partitions. 101 datafiles and tablespaces. Just to START. my aching typing fingers! --- Paul Baumgartel [EMAIL PROTECTED] wrote: I believe that the OS filesystem has to be configured for large file support (on HP-UX, it's a kernel parameter) to allow files 2 GB. I usually just add 1 MB to the file size to allow for the header. Personally, I'd play it safe and go with however many 2001 MB files you need to accommodate your objects. --- Rachel Carmichael [EMAIL PROTECTED] wrote: I'm betting that it's not 64-bit Oracle. See, I am the development DBA. As an employee, I get to create the scripts, but I don't get to run them or even get access as oracle to the servers. In other words, all the grunt work, all the responsibility for problems (production is managed by a hosting company) but none of the power to make sure it's right. I love my job. Why? Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best Practice - Partitioned object, one partition per tablespace,
We have a database which stores 5 years data with most of the tables partitioned on year_month. We have three tablespces each for each table, with tablespace_1 having 01,04,07,10 months and tablespace_2 having 2,5,8,11 and tablespace_3 having 3,6,9,12 --- Rachel Carmichael [EMAIL PROTECTED] wrote: it's what I'm planning on doing... seems to me that when we decide to remove partitions, we can easily do so and retrieve the disk space this way --- Freeman, Robert [EMAIL PROTECTED] wrote: We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Changing ONAMES enrtries fiasco
Excellent! Glag to see I won't exactly be a guinea pig for this. One question: Do you issue an ONAMES RELOAD after this is done? I'm not sure how else the Names Server would be made aware of the change, except after it's daily (by default) region DB refresh. Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Changing ONAMES enrtries fiasco After having little success with registering and dropping using the namesctl commands. I have used direct insert, update to the ONRS_REGION table as the peferred method to tp update the region database. No problems so far. make sure you have no space in any descriptions. I even have script to do the registering. #!/usr/bin/ksh ### ### created by J. JOB 11/22/2001 # This Script registers a database to the Oracle Names server. # Parameters expected are # 1: SID : SID of the databse # 2: Service Name: The Name by which the database will be called. # 3: Host Name : The Name of the machine on which the database resides # 4: Connection type : dedicated or shared ### PATH=/usr/local/bin PATH=${PATH}:. PATH=${PATH}:/bin:/sbin:/usr/bin:/usr/sbin:/etc export PATH SID_NAME=$1 SERVICE_NAME=$2 HOST_NAME=$3 DEDI_SHARED=$4 DESCRIPTION=(DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIP TION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP)(HOST=${HOST_NAME})(PORT=1521)))(CONNECT_DATA=(S ERVICE_NAME=${SID_NAME})(ser ver=${DEDI_SHARED}) echo $DESCRIPTION . local_oraenv ORTL sqlplus EOF oname/oname@ORTL insert into ONRS_REGION values('(root)','${SERVICE_NAME}','${DESCRIPTION}'); commit; exit EOF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load
That sounds about right! You can get back to your boss with a little sleep deprivation tactics. Beep him hourly with the progress report and he'll trust you much more the next time. You can even beep you bosses boss and tell him that your boss told you to beep him hourly with a progress report. That should read something like : applied archive sequences 789001 to 789567, 3456 more to go. That might result in some interesting career opportunities. One of these days I have to start my very own BDBAFH site. -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load It is your own fault. You should have called all interested parties with details as soon as that problem was resolved. And remember: if by any chance the problem resolution takes all night, call hourly with the progress report. -Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load - BDBAFH #1
It's backup day today so I'm pissed off. Being the BDBAFH, however, does have it's advantages. I reassign null to be the tape device - it's so much more economical on my time as I don't have to keep getting up to change tapes every 5 minutes. And it speeds up RMAN too, so it can't be all bad can it? Of course not. A user rings ... -Original Message- Sent: Wednesday, September 25, 2002 4:34 PM To: Multiple recipients of list ORACLE-L That sounds about right! You can get back to your boss with a little sleep deprivation tactics. Beep him hourly with the progress report and he'll trust you much more the next time. You can even beep you bosses boss and tell him that your boss told you to beep him hourly with a progress report. That should read something like : applied archive sequences 789001 to 789567, 3456 more to go. That might result in some interesting career opportunities. One of these days I have to start my very own BDBAFH site. -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load It is your own fault. You should have called all interested parties with details as soon as that problem was resolved. And remember: if by any chance the problem resolution takes all night, call hourly with the progress report. -Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Changing ONAMES enrtries fiasco
Yes, you need a reload so that it takes immediate effect. --- Jesse, Rich [EMAIL PROTECTED] wrote: Excellent! Glag to see I won't exactly be a guinea pig for this. One question: Do you issue an ONAMES RELOAD after this is done? I'm not sure how else the Names Server would be made aware of the change, except after it's daily (by default) region DB refresh. Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Changing ONAMES enrtries fiasco After having little success with registering and dropping using the namesctl commands. I have used direct insert, update to the ONRS_REGION table as the peferred method to tp update the region database. No problems so far. make sure you have no space in any descriptions. I even have script to do the registering. #!/usr/bin/ksh ### ### created by J. JOB 11/22/2001 # This Script registers a database to the Oracle Names server. # Parameters expected are # 1: SID : SID of the databse # 2: Service Name: The Name by which the database will be called. # 3: Host Name : The Name of the machine on which the database resides # 4: Connection type : dedicated or shared ### PATH=/usr/local/bin PATH=${PATH}:. PATH=${PATH}:/bin:/sbin:/usr/bin:/usr/sbin:/etc export PATH SID_NAME=$1 SERVICE_NAME=$2 HOST_NAME=$3 DEDI_SHARED=$4 DESCRIPTION=(DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIP TION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP)(HOST=${HOST_NAME})(PORT=1521)))(CONNECT_DATA=(S ERVICE_NAME=${SID_NAME})(ser ver=${DEDI_SHARED}) echo $DESCRIPTION . local_oraenv ORTL sqlplus EOF oname/oname@ORTL insert into ONRS_REGION values('(root)','${SERVICE_NAME}','${DESCRIPTION}'); commit; exit EOF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Yet another request for your experiences
Not on raw, but occasionally on filesystem-based async IO (Solaris) especially when using massive caches But generally - I'm in agreement with your observation hth connor --- Freeman, Robert [EMAIL PROTECTED] wrote: On a system with ASYNC IO Enabled, have you seen any benefits from enabling multiple DBWR processes, and if so how much of an impact did you see? I've experimented with this before and didn't see much improvement, but I'm curious what others experiences are. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i : Segment space management
Unless you've got lots and lots on concurrent transactions on tables, I wouldn't touch ASSM if I were you. I've been told of some horror stories hth connor --- Kawatra V (Vikas) at Aera [EMAIL PROTECTED] wrote: Does anyone know of a way to modify existing tablespaces to use the Auto SEGMENT SPACE MANAGEMENT in a 8i dbs upgraded to 9i ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kawatra V (Vikas) at Aera INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i : Segment space management
How does ASSM relate to compressed tables? --- Gogala, Mladen [EMAIL PROTECTED] wrote: You want to use compressed table? Just do a quick ALTER TABLE and everything will be cool. -Original Message- From: Kawatra V (Vikas) at Aera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Subject: 9i : Segment space management Does anyone know of a way to modify existing tablespaces to use the Auto SEGMENT SPACE MANAGEMENT in a 8i dbs upgraded to 9i ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kawatra V (Vikas) at Aera INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Web forms via PL/SQL
I need to write a pl/sql procedure to produce a form via the pl-sql cartridge. Not a problem- been doing this kinda thing now for a couple of years. Now I need to handle a INPUT TYPE=FILE tag in the form. Anyone know how to process the result via pl/sql or am I going to need to write a cgi script to handle it. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
use_hash HINT
Hi All, Please give me inputs on this hint and the affect of having a large HASH_AREA. Thanks, Rajesh
RE: How to reproduce a hanging connect attempt
Unfortunately, this is one of those things that *doesn't* work on Windoze, no support in the kernel. Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2002 01:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How to reproduce a hanging connect attempt In Perl: my $dbh = ''; eval { local $SIG{ALRM} = sub { die }; alarm 60; my $dbh = DBI-connect( 'dbi:Oracle:' . $db, 'scott','tiger', ); }; alarm 0; unless ($dbh) { print db $db is down; } Humm do you know what the alarm function on windows 2000 pro is?? Im gettting The Unsupported function alarm function is unimplemented at C:\evaldb.pl line 11. It looks like alarm is a perl function I can see the doc from Perldoc -f alarm Nevertheless I get the unsupported function Line 11 is alarm 0; ?? Thanks rob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: MIcrosoft Blackmail
Title: OT: MIcrosoft Blackmail This came to our DBA team today. I'd appreciate your thoughts. I'm not a business guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice by MS? It is important from an Architecture point of view that we understand all the various approaches to web services (also known as grid computing -- see my recent report). Microsoft's dot Net initiative is their approach to this grand overarching software strategy. There is a second reason why we might be interested specifically in dot Net. Subsidiary XYZ earns $xyz a year for us from Microsoft by [performing certain services], etc. Microsoft has told our management that one of their criteria for evaluating their vendors will be how good of a MS customer is the potential vendor. Specifically, has the vendor bought in to the dot Net strategy. Now we aren't going to make our global enterprise solutions strategy decisions based upon that point alone, but it's not something we are going to ignore either. Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING.
RE: Help on Effect of changing NLS_LANGUAGE to maerican_america.u
Since WE8ISO8859P1 is not a strict subset of UTF8, you will need to recreate the database. Since you need to recreate, take to opportunity to upgrade to 8.1.7.4 or 9.0.2 Also, I would suggest upgrading to at least Dev 6i, patchset 6 (6.0.8.15), but preferable patchset 10 (6.0.8.19). This resolved a lot of UTF8 issues we had. Also, see note below from metalink. Also realize that your services (forms, reports, listener,etc) sould also run in a UTF8 environment. It will be up to the client to translate to the required regional encoding. Also realize that printing will now become an issue. Most printers can not handle UTF8 encoded data. You will need to investigate the PASTA print utility, or optionally, run a separate report server for each regional environment. Also realise... As you can see, this is not a decision to be made lightly. I'm still struggling with some of these issues. I support an Oracle Applications installation that is multi-national (US, Brazilian Portuguese, and Simplified Chinese)- it's been loads of fun! - ## We know that WE8ISO8859P1 is not a strict subset of UTF8, ## so is a DB receation required to use the new Char Set? Yes, it is. ## What are the implications of this conversion? All strings that are not pure ASCII (codes 0-127) will expand because the non-ASCII WE8ISO8859P1 characters will occupy 2 bytes each. This must be accounted for in the new table definitions. ## Please outline the steps in performing this conversion. General steps are: - Use the Character Set Scanner (see otn.oracle.com) to verify that all your WE8ISO8859P1 data in the old database are Convertible (no Exceptions). Illegal WE8MSWIN1252 characters (like the TM sign, smart quotes, etc.) may appear in WE8ISO885P1 databases used with Windows clients - Create a new UTF8 database - If you have scripts to create your application tables, correct
Another datafile sizing question
I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application certifications. I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to create a 800mb datafile and move all the data into it, The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile. Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
fast_start_mttr_target in Oracle 9i
Is anyone using this new init.ora parameter? Does it really seam to help recovery times? Does anyone have any good or bad stories about this? Thanks!! Nick
Re: Oracle trace file question
It's ODBC, I think. The MS ODBC driver (are they using ODBC? If so, is it an MS driver or an Oracle driver?) tends to do SELECTs like this in lieu of a DESCRIBE. They don't fetch from the cursors; they just read the select-column information returned in order to perform a crude DESCRIBE of the table... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:53 AM Hello all I am trying to debug a mysterious sporadic error that a Visual Basic program using ADO is hitting. In reviewing the trace file, we see an odd series of SQL statements. Before performing a 3 table join, a select * from table is issued for each of the tables to be joined. The developer swears ADO isn't doing this. I can't think Oracle would decide to spontaneously do this. These are large tables so if it were really occurring, the communications line would be tied up for a long time, but the developer is able to get subsecond response. Has anyone seen anything like this before? select * from source_reference call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.04 0.12 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.04 0.12 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from account_master call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.05 0.10 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- - total 95 0.05 0.10 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from school_demographics call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 95 0.13 0.07 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 95 0.13 0.07 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 select * from source_reference sr, account_master am, school_demographics sd where am.lid = 1 and am.lid = 100and am.lid=sr.lid and am.lid=sd.lid order by am.lid asc, sr.source_num asc call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.03 0.07 7 27 0 100 --- -- -- -- -- -- -- total 10 0.06 0.10 7 27 0 100 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 18 Rows Row Source Operation --- --- 100 SORT ORDER BY 100 HASH JOIN 100TABLE ACCESS BY INDEX ROWID SCHOOL_DEMOGRAPHICS 101 INDEX RANGE SCAN (object id 3290) 100HASH JOIN 100 TABLE ACCESS BY INDEX ROWID SOURCE_REFERENCE 101 INDEX RANGE SCAN (object id 3294) 100 TABLE ACCESS BY INDEX ROWID ACCOUNT_MASTER 101 INDEX RANGE SCAN (object id 3214) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: DBA work load - BDBAFH #1
Steve, this is great! I must bow to the master! -Original Message- From: STEVE OLLIG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 5:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 It's backup day today so I'm pissed off. Being the BDBAFH, however, does have it's advantages. I reassign null to be the tape device - it's so much more economical on my time as I don't have to keep getting up to change tapes every 5 minutes. And it speeds up RMAN too, so it can't be all bad can it? Of course not. A user rings ... -Original Message- Sent: Wednesday, September 25, 2002 4:34 PM To: Multiple recipients of list ORACLE-L That sounds about right! You can get back to your boss with a little sleep deprivation tactics. Beep him hourly with the progress report and he'll trust you much more the next time. You can even beep you bosses boss and tell him that your boss told you to beep him hourly with a progress report. That should read something like : applied archive sequences 789001 to 789567, 3456 more to go. That might result in some interesting career opportunities. One of these days I have to start my very own BDBAFH site. -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load It is your own fault. You should have called all interested parties with details as soon as that problem was resolved. And remember: if by any chance the problem resolution takes all night, call hourly with the progress report. -Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
Re: Web forms via PL/SQL
Hi Ron, In short (as I am hitting the bed) What I have here is done via 9ias. It (ias) requiers that you define a document table with some specifick column (you can add your own ) (look in the documentation) The script I am sending you requiers some other scripts and access diffrent kind of tables, but I hope it can give you a hint. If you need some more details I'll be back tomorrow reards Torben Navn NULL?Type - ID NUMBER NAME NOT NULL VARCHAR2(128) MIME_TYPE VARCHAR2(128) DOC_SIZE NUMBER DAD_CHARSETVARCHAR2(128) LAST_UPDATED DATE CONTENT_TYPE VARCHAR2(128) CONTENTLONG RAW BLOB_CONTENT BLOB STATUS VARCHAR2(45) OWNER VARCHAR2(30) CUSTOMERID NUMBER DOC_NAME VARCHAR2(128) SHORT_DESCRIPTION VARCHAR2(4000) EMPID NUMBER DATO DATE create or replace package MaintainVisitReports is procedure main; procedure show(p_customerid number := null); procedure upload(p_customerid number := null, p_short_description in varchar2 := null, p_initials in varchar2 := null, file in varchar2 := null); procedure download(p_name varchar2); procedure deletefile(p_customerid number := null, p_id number); procedure filelist ; end ; / create or replace package body MaintainVisitReports is Procedure main is begin ccs.ccs; htp.p('TABLE'); htp.p('TR'); htp.p('TD'); htp.p('a href=mirres.MaintainVisitReports.show TARGET=mainUpload/a'); htp.p('/TD'); htp.p('TD'); htp.p('a href=mirres.MaintainVisitReports.filelist TARGET=mainList/a'); htp.p('/TD'); htp.p('/TR'); htp.p('/TABLE'); htp.p('HR'); end main; -- - -- -- - procedure show(p_customerid number := null) is l_custname varchar2(50); cursor GetCustomer is select custname from customer where customerid = p_customerid; begin open GetCustomer; fetch Getcustomer into l_custname; close GetCustomer; ccs.ccs; Javascript.script; javascript.call_popup; Javascript.end_script; -- htp.p('html'); htp.p('body'); -- htp.p('FORM enctype=multipart/form-data action=mirres.MaintainVisitReports.upload method=POST'); if p_customerid is not null then htp.p('INPUT TYPE=SUBMIT VALUE=Luk style=border-style: solid; border-width: 1 onClick=window.close()'); end if; htp.p('TABLE background= border=0 cellPadding=0 cellSpacing=0 style=CURSOR: auto; WIDTH: 100% width=100%'); htp.p('TR'); htp.p('TD class=label WIDTH=120px'||misc.get_translation('Kunde')||'/TD'); htp.p('TD'); htp.p('INPUT TYPE=TEXT VALUE='||l_custname||' onfocus = blur() SIZE=50 MAXLENGTH=50'); if p_customerid is null then htp.p('nbsp;A HREF=javascript:call_popup(1)IMG SRC=/images/list.gif alt=LIST border=0 align=bottom /Anbsp;a href=javascript:clearcustomer()IMG SRC=/images/viper.gif alt=vipe border=0 align=bottom/A/TD'); else htp.p('TD'); end if; -- htp.p('INPUT TYPE=HIDDEN NAME=p_customerid VALUE='||p_customerid||' SIZE=0 MAXLENGTH=32/TD'); htp.p('/TR'); -- htp.p('TR rowspan=100%'); htp.p('TD class=label WIDTH=70px'||misc.get_translation('Initialer')||'/TD'); htp.p('TD '); components.initials; htp.p('/TD'); htp.p('/TR'); -- htp.p('TR'); htp.p('TD class=labelBeskrivelse:/TD'); htp.p('TD'); htp.p('TEXTAREA name=p_short_description style=HEIGHT: 87px; WIDTH: 283px maxlength=512/TEXTAREA'); htp.p('/TD'); htp.p('/TR'); -- htp.p('TR'); htp.p('TD class=label WIDTH=120px'||misc.get_translation('Fil der skal uploades')||'/TD'); htp.p('TDINPUT type=file name=file style=border-style: solid; border-width: 1 /TD'); htp.p('/TR'); -- htp.p('TR'); htp.p('TDnbsp;/TD'); htp.p('TDINPUT type=submit value=Upload file style=border-style: solid; border-width: 1 /TD'); htp.p('/TR'); -- htp.p('/TABLE'); htp.p('/FORM'); if p_customerid is not null then htp.p('HR'); htp.p('pFiles/p'); htp.p('TABLE background= border=1 cellPadding=0 cellSpacing=0 style=CURSOR: auto; WIDTH: 100% width=100%'); if p_customerid is null then htp.p('TH ALIGN=leftKunde/TH'); end if; htp.p('TH ALIGN=leftFilnavn/TH'); htp.p('TH ALIGN=leftBeskrivelse/TH'); htp.p('TH ALIGN=leftOpdateret/TH'); htp.p('TH ALIGN=leftInitialer/TH'); htp.p('TH
RE: Another datafile sizing question
Is there a reason you can't just resize the existing file? -Original Message- Sent: Wednesday, September 25, 2002 7:43 PM To: Multiple recipients of list ORACLE-L I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application certifications. I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to create a 800mb datafile and move all the data into it, The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile. Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another datafile sizing question
Darren - My advice would be to read up on Locally Managed Tablespaces (LMT) and uniform extents. This is a new feature that will ease your management work. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 6:43 PM To: Multiple recipients of list ORACLE-L I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application certifications. I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to create a 800mb datafile and move all the data into it, The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile. Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ? Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another datafile sizing question
It's late at night maybe that's why I do not understand your answer but I do not see the link between LMT and the number/size of datafiles. One reason of multiple datafiles id to spread IO but since nowadays a majority of sites goes on huge disk box using raid 5 (that's what we have, the unix guys are the IT master here) multiple files is less meaningful. What I liked is a file politics where you restrained the number of file size. Here we have from 15M up to 8.5G file size with all the possibility in between. I'm trying to standardize all that. Another factor to consider is backup and recovery. Restoring a 10G file will take more time than a 2G file. In your case, if file placement is not possible than go for a 800M file and use a second one for the future growth. -- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Darren - My advice would be to read up on Locally Managed Tablespaces (LMT) and uniform extents. This is a new feature that will ease your management work. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 6:43 PM To: Multiple recipients of list ORACLE-L I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application certifications. I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to create a 800mb datafile and move all the data into it, The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile. Would that be a good practise, or should I stay with multiple 200/300/400/500 etc datafiles ? Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administratorusing 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Advanced Queues for dummies
Hi, We're investigating the use of Advanced Queues as a way of transferring information between OSI's PI and Oracle. The data will originate on the Oracle side and end up in PI. We were thinking of using Oracle's Heterogeneous services and PI's ODBC driver, but ran into 2 phase commit errors (how do you tell a commit not be a 2-phase commit) and problems (ie not supported until 9iR2) with autonomous transactions and database links. We're using Oracle 81714 (soon to be 81745) on Windows. Having not used Advanced Queues before, I will look at the manuals, but is their a site or book on Advanced Queues for dummies (otherwise known as Intro to Advanced Queues in Oracle). For those who use Advanced queues, one of our developers read that Creating a queue table in a tablespace will disable that particular tablespace for point-in-time recovery. -Do you normally put your AQ tables in a separate tablespace? - Who normally owns the queues and queue tables - system or the application schema. Any suggestions, links or books would be appreciated. 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing question
Mladen, I'd love to hear your poetry -- but only if you are reciting it at the December NYOUG meeting as the keynote speaker. I still need a keynote speaker for that meeting... Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: Rachel, that is the same thing as with money itself. Everybody keeps telling me that money isn't everything and that there are many things in life which are more important then money, but when I ask for a check to $10,000 nobody wants to give it to me. Humans are so hard to comprehend for us Vogons. Let me know if you'd like me to recite some poetry. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: datafile sizing question AHA!I was going to go with 2000M so that's beautiful, 2001M would work perfectly without going over. I don't mind wasting less than a meg. I love the logic everyone here at work has. disk is cheap, don't worry about it. Except every time I ask for more disk, I hear it's too expensive Rachel --- Fink, Dan [EMAIL PROTECTED] wrote: Are you going with 2048M or the traditional 2000m? A quick dirty way to not waste the space is to use 2001m or 2041m. You 'waste' a little space, but not much. Dan Fink -Original Message- Sent: Wednesday, September 25, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing
RE: datafile sizing question
I can't with the account they have given me. At least, not yet :( this is so well planned I will be amazed if it goes live on time. and I (and my boss) are living by two mottos failure to plan on your part does not constitute an emergency on mine and if it fails, it will NOT be because of anything the DB group did or failed to do --- Gogala, Mladen [EMAIL PROTECTED] wrote: Rachel, if you can execute sqlplus, you can do the nm thing. You don't need to log in as oracle. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: datafile sizing question I'm betting that it's not 64-bit Oracle. See, I am the development DBA. As an employee, I get to create the scripts, but I don't get to run them or even get access as oracle to the servers. In other words, all the grunt work, all the responsibility for problems (production is managed by a hosting company) but none of the power to make sure it's right. I love my job. Why? Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: I know that wuth 64 bit HP-UX and 64 bit Oracle RDBMS, I have no problems with 1 8GB file. I don't know much about Solaris, but I suppose the following will work: nm $ORACLE_HOME/lib/libclntsh.so|grep lseek64 Results should be nonempty and look something like this: __lseek64 | |undef |code | __lseek64 | 6589540|uext |stub | __lseek64 | 7173576|uext |stub | That meens that lseek64 is used, as an external symbol, from the OS libraries. That, in turn, means that your oracle is using 64 bit routines and is, therefore, 64 bit itself and can handle large files. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject: datafile sizing question Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M. What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB. We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this. I hate to waste most of 20M just for the bitmap header. Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done? thanks! Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: How to reproduce a hanging connect attempt
For more information see $ perldoc perlport Not much more information, mind you, but at least a positive statement that alarm is not implemented on Win32. This document also describes all the other stuff without which I can't believe an operating system can survive commercially... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Unfortunately, this is one of those things that *doesn't* work on Windoze, no support in the kernel. Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2002 01:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How to reproduce a hanging connect attempt In Perl: my $dbh = ''; eval { local $SIG{ALRM} = sub { die }; alarm 60; my $dbh = DBI-connect( 'dbi:Oracle:' . $db, 'scott','tiger', ); }; alarm 0; unless ($dbh) { print db $db is down; } Humm do you know what the alarm function on windows 2000 pro is?? Im gettting The Unsupported function alarm function is unimplemented at C:\evaldb.pl line 11. It looks like alarm is a perl function I can see the doc from Perldoc -f alarm Nevertheless I get the unsupported function Line 11 is alarm 0; ?? Thanks rob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
NOMAIL ORACLE-L __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
migrating 8.x-9i and charsets
Title: migrating 8.x-9i and charsets Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the new National Character Set will be UTF8. Otherwise, the National Character Set is changed to AL16UTF16. the character set at the time was AMERICAN_AMERICA.WE8ISO8859P1 which my understanding is that the character set would become AL16UTF16. I never could get the character set scanner to accept the tochar=AL16UTF16 or tochar=al16utf16 parameter(s). It would result in CSS-00115: invalid character set name AL16UTF16 or CSS-00115: invalid character set name al16utf16. I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8. This test database houses the 11i applications objects. TIA for any information
RE: migrating 8.x-9i and charsets
Title: RE: migrating 8.x-9i and charsets what I found odd after reading the migration manual is that the 9i upgrade database is still showing: NLS_CHARACTERSET WE8ISO8859P1 NLS_NCHAR_CHARACTERSET WE8ISO8859P1 I haven't found any issues with functionality, keeping in mind this two tier instance doesn't contain any buisness data either. Most of this questioning is derived from my lack of understanding the charsets, not knowing what warrants choosing one over the other, and well maybe the part about the conversion possibly creating truncated or expanded data. again TIA to anyone who has any input. -Original Message- From: Markham, Richard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 9:28 PM To: Multiple recipients of list ORACLE-L Subject: migrating 8.x-9i and charsets Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the new National Character Set will be UTF8. Otherwise, the National Character Set is changed to AL16UTF16. the character set at the time was AMERICAN_AMERICA.WE8ISO8859P1 which my understanding is that the character set would become AL16UTF16. I never could get the character set scanner to accept the tochar=AL16UTF16 or tochar=al16utf16 parameter(s). It would result in CSS-00115: invalid character set name AL16UTF16 or CSS-00115: invalid character set name al16utf16. I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8. This test database houses the 11i applications objects. TIA for any information
RE:
Ooops!!! Got tired of us, eh! Now, you're sure going to miss Mladen's poetry !! ;) - Kirti -Original Message- Sent: Wednesday, September 25, 2002 10:43 PM To: Multiple recipients of list ORACLE-L NOMAIL ORACLE-L __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best Practice - Partitioned object, one partition per tablesp
placing them in different tablespaces also allows you to place older tablespaces into READ ONLY mode and reduce the volume of backups. also permits moving less-frequently accessed tablespaces to near-line storage, such as tape-based file-systems or CDROM... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:38 PM Robert - That is how I've generally done it. If you are partitioning because the table is very large, then separate tablespaces gives you the flexibility to place these partitions on separate devices so you can get some parallel I/O going. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace, We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA work load - BDBAFH #1
It's backup day today so I'm pissed off. Being the BDBAFH, however, does have it's advantages. I reassign null to be the tape device - it's so much more economical on my time as I don't have to keep getting up to change tapes every 5 minutes. And it speeds up RMAN too, so it can't be all bad can it? Of course not. A user rings ... The phone rings. It'll be him again, I know. That annoys me. I put on a gruff voice: Payroll! Oh, I'm sorry, I've got the wrong number Yeah? Well, what's your name, buddy? Do you know *WASTED* phone calls cost money? DO YOU? I've got a good mind to subtract your wasted time, my wasted time, and the cost of this call from your wages! IN FACT I WILL! By the time I've finished with you, you'll owe US money! WHAT'S YOUR NAME - AND DON'T LIE, I'VE GOT CALLER ID!! I hear the phone drop and the sound of running feet - he's obviously going to try and get an alibi by being at the IT Director's office. I look up his username and find his department. I ring the department's executive assistant. Hello? she answers. BDBAFH here. Listen, when that guy comes running into your office in about 15 seconds, can you give him a message? I think so... she quavers... Please tell him, `HE CAN RUN, BUT HE CAN'T HIDE!' Um. OK. Like, sure... And, don't forget now, please? I wouldn't want everyone to find out about that table in your account with all of your passwords for in-house apps and credit card numbers for ecommerce sites in it... A muffled cry and I hear her scrambling at her keyboard. Don't bother. It's been backed up a zillion times; piece of cake to restore it. Just pass the message on like a love? Over the phone, I can hear the distant sound of pounding feet growing louder in the background... She sobs her assent and I hang up. And the worst thing is, I was just guessing about the table. I look for it, find it, and bring it up in TOAD; maybe I can do some shopping online tonight... The phone rings. Another user. Still pissed off, I pick it up... -Original Message- Sent: Wednesday, September 25, 2002 4:34 PM To: Multiple recipients of list ORACLE-L That sounds about right! You can get back to your boss with a little sleep deprivation tactics. Beep him hourly with the progress report and he'll trust you much more the next time. You can even beep you bosses boss and tell him that your boss told you to beep him hourly with a progress report. That should read something like : applied archive sequences 789001 to 789567, 3456 more to go. That might result in some interesting career opportunities. One of these days I have to start my very own BDBAFH site. -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load It is your own fault. You should have called all interested parties with details as soon as that problem was resolved. And remember: if by any chance the problem resolution takes all night, call hourly with the progress report. -Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
Re: Best Practice - Partitioned object, one partition per tablespace,
Another approach is to partition according to your load strategy, but make them reside in tablespaces according to how you want to set them to READ ONLY. For example, if you load daily, partition daily. But if you want to set the data into READ ONLY to reduce backup volumes on a quarterly basis, then put all of those daily partitions into quarterly tablespaces. So, each tablespace will have roughly 90-91 partitions for each table... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:48 AM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).