Re: whats new in oracle8.1.7
Check out this link ..it is of 8.1.5 www.akadia.com/services/ora815nf.html Azhar - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 3:35 PM http://technet.oracle.com -Original Message- Sent: Friday, June 08, 2001 10:06 To: Multiple recipients of list ORACLE-L Hi from where can I get oracle8.1.7 new features?Any website except www.oracle.com Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Azhar Siddiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Create Directory - Statemen
Nirmal, Create directory command simply creates a database object,Client system directory path can't be given during its creation. it is used with LOB manipulation, DBMS_LOB package read and write operations are related to this directorty path given during creation. For more details, do check DBMS_LOB samples. HTH Azhar - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 8:27 PM Hi all, Can anyone please tell me what is the use of the 'CREATE DIRECTORY' sql statement. Hope that it would be used on LOB datatype manipulations. Please enlighten me. Regards, Nirmal. -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Azhar Siddiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Database parameters were slightly changed for the second run and SGA was made only 140 MB. Loading was done without indexes and SQL loader parameters were changed to Readsize=10m, Bindsize=10m and Rows=5000. It took almost same time for about 21 hours but again it committed 8-10 times ( first 5) very quickly. Real bottleneck is RAM (as pointed out by all) since commit charge in NT task manager was almost double than the physical memory. But since the data is loaded , we are through. Thanks to every one who responded Azhar Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: mpo.gc.ca Subject: RE: Performance tuning Sent by: [EMAIL PROTECTED] 05/31/2001 12:56 AM Please respond to ORACLE-L I don't know what is causing this, but I would keep an eye on physical memory available vs. commit charge in Task Manager, I strongly recommend your commit charge never exceed your physical memory. I found that Oracle sometimes refuses to even start services when it runs out of physical memory, it doesn't like virtual memory very much. Shrinking the size of your SGA is preferable to exceeding the available physical memory, in my opinion. Keep in mind session memory space in your calculations, and the other programs you may be running on your machine. I recommend you stop all the services (in Services applet) that you dare stop, to lighten the load. In the virtual memory settings, allocate the amount you want, but try to avoid a range of values - when initial and max size values are different NT keeps polling the pagefile and memory statistics to figure out if the pagefile should grow or shrink. Better to do that manually up front, allocate at set amount. NT then stops doing extra work regarding memory allocation. Every little bit helps. I haven't used SQL*Loader, so I can't say much about that, except... when you start loading those first few rows, what does Commit Charge look like in Task Manager? Is it growing? If it is, notice how slowly NT does this. It can't be helped. If commit charge approaches physical memory available, you will hit a ceiling I think. Then things may well slow down to a crawl. Is there a buffer size you can set for SQL*Loader? I always set my exp buffer size to 100 to speed it up. Maybe you can do the same for SQL*Loader. That must use more memory though. Can you commit every few records? Could it be every 10 rows? Would it be better not to commit too often? As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or RAID 10. Do you have many indexes on the tables you are filling up? You may want to drop them and re-create them once the load is finished. This may sound silly but... do you have a virus checking program running
Performance tuning
HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA_FREE_SPACE - Problem gone
Did you shut down the data base and restarted ? or problem gone itself without doing anything. A really weired situation. Azhar Miller, Jay JayMiller@TDWaterTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] house.comcc: Sent by: Subject: RE: DBA_FREE_SPACE - Problem gone [EMAIL PROTECTED] 04/25/2001 08:03 PM Please respond to ORACLE-L Well, this makes me really uncomfortable but the problem went away by itself. Dba_free_space is now showing the correct free space. -Original Message- Sent: Monday, April 23, 2001 5:19 PM To: Multiple recipients of list ORACLE-L One of the other DBAs here called me over to look at a weird situation. We resized some datafiles, the size of the datafiles increased on the OS and in dba_data_files but there are no entries for that tablespace in dba_free_space. Currently: DBA_DATA_FILES - 11451M total size of datafiles (this agrees with OS) DBA_SEGMENTS DBA_EXTENTS - 10752M total size of extents/segments DBA_FREE_SPACE - no entries Oracle 8.1.5.1.0 Solaris 2.6 Any idea what might cause this? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
RE: Exp Imp Overwirte posiible or not?
Hi , destroy=y option doesn't meet the requirement . I checked the oracle docs and didn't find any option to overwrite data.I think i have to truncate data and then insert into appropriate tables as william pointed out. Thnaks to every one who responded. Azhar Siddiq, [EMAIL PROTECTED] ms.osd.mil To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Exp Imp Overwirte posiible or not? 03/28/2001 12:52 AM Please respond to ORACLE-L Thanks for the correction. I'm away from the doc CD at the moment as we are moving offices... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: William Beilstein [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Exp Imp Overwirte posiible or not? The DESTROY option on an import indicates whether the CREATE TABLESPACE commands only found in a full export should be executed. Setting DESTROY=Y destroys the data files of the database being imported into. This is only used when you want to rebuild an entire database, not to overwrite data in tables. If you really need the empty all the tables in a schema, disable the constraints on the tables, truncate them, and reenable the constraints. This will only work if the schema is self contained, and it's tables are not used as a foreign key for a table in a different schema. [EMAIL PROTECTED] 03/27/01 01:50PM IIRC, there is a flag for import "destroy=y" to do what you want. This is very dangerous and you should research all the implications before trying it. If you don't have the docs, try http://technet.oracle.com and read up on the import options. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:46 AM To: Multiple recipients of list ORACLE-L Subject: Exp Imp Overwirte posiible or not? Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent objects. Is it possible with exp , imp utilities or i have to delete data first and then import using imp utility. Is there any other possibility... Environment Oracle8i, Windows NT4 TIA Azhar Siddiq -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, incl
Exp Imp Overwirte posiible or not?
Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent objects. Is it possible with exp , imp utilities or i have to delete data first and then import using imp utility. Is there any other possibility... Environment Oracle8i, Windows NT4 TIA Azhar Siddiq -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).