RE: extracting schema
Title: extracting schema If you are on 9I, you can use dbms_metadata.get_ddl. You can also use export/import without data to get schema definition. -Original Message- From: [EMAIL PROTECTED]on behalf of[EMAIL PROTECTED] Sent: Mon 1/19/2004 5:04 AM To: Multiple recipients of list ORACLE-L Cc: Subject: extracting schema Hi all , How can I produce extract schema script(tables , tiggers , objects, procedures ..) from database. Any tool , script , idea ?ThanksArslan--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Rename tablespace in 9I
Is there anyway to rename tablespace in Oracle 9202. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
Export/Import issue.
I am trying to export a table from one database to another. Table in target database is dropped before importing and is being created as part of import process. During import process data Oracle is complaining Unique constraint violated and throwing out following messages. Its complaining on index abhset1 which is on columns [asset, book, yr_end_date]. I tried to compare data in source and target. Somehow yr_end_date for year 2003 is changing to 2002 while importing data. Table doesnt have any triggers. Indexes in both source and target are same. Table definition is exactly same and created during import. Tried to export 2-3 times but same result. Anybody ran into this issue before. How should I approach to troubleshoot. Thanks Error Message Column 1 101536 Column 2 SL Column 3 5 Column 4 31-DEC-2002:00:00:00 Column 5 53.29 Column 6 0 Column 7 4.84 Column 8 96 Column 9 01-JAN-1700:00:00:00 IMP-00019: row rejected due to ORACLE error 1 IMP-3: ORACLE error 1 encountered ORA-1: unique constraint (LDDEV.ABHSET1) violated Column 1 101537 Column 2 SL Column 3 5 Column 4 31-DEC-2002:00:00:00 Column 5 38.75 Column 6 0 Column 7 4.84 Column 8 96 Column 9 01-JAN-1700:00:00:00 IMP-00019: row rejected due to ORACLE error 1 IMP-3: ORACLE error 1 encountered ORA-1: unique constraint (LDDEV.ABHSET1) violated Data in Source ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101536 SL 5 31-DEC-02 4.84 00 96 01-JAN-00 101536 SL 5 31-DEC-03 53.29 0 4.84 96 01-JAN-00 ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101537 SL 5 31-DEC-02 4.84 00 96 01-JAN-00 101537 SL 5 31-DEC-03 38.75 0 4.84 96 01-JAN-00 Data in Target. ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101536 SL 5 31-DEC-02 4.84 00 96 01-JAN-00 ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101537 SL 5 31-DEC-02 4.84 00 96 01-JAN-00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Export/Import issue.
I am 100% positive . I tried this process 2-3 times using different approach but same output. I tried to create objects first using no data. I also tried to create objects as part of loading data but no difference. I enabled 10046 trace for the import process but that also didnt help, it showing err=1 at several places but I couldnt figure out why. -Original Message- Mercadante, Thomas F Sent: Wednesday, December 24, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Avnish, Are you absolutely sure that the target table is either gone before the import, or empty? You should not be getting a unique constraint violation if the table does not exists before import. The step that Oracle import follows for importing is: Create the table import the data create constraints create triggers apply grants. If you are getting a unique constraint violation during import, then the constraints exist before the table is being imported which leads me to believe everthing is not as clean as you think. Either that, or the uniqe constraint in the source database has been disabled, and you have bad data. Make sure you drop the target table before you start the import. And look at the source data table's constraints to make sure they are all enabled. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 1:44 PM To: Multiple recipients of list ORACLE-L I am trying to export a table from one database to another. Table in target database is dropped before importing and is being created as part of import process. During import process data Oracle is complaining Unique constraint violated and throwing out following messages. Its complaining on index abhset1 which is on columns [asset, book, yr_end_date]. I tried to compare data in source and target. Somehow yr_end_date for year 2003 is changing to 2002 while importing data. Table doesnt have any triggers. Indexes in both source and target are same. Table definition is exactly same and created during import. Tried to export 2-3 times but same result. Anybody ran into this issue before. How should I approach to troubleshoot. Thanks Error Message Column 1 101536 Column 2 SL Column 3 5 Column 4 31-DEC-2002:00:00:00 Column 5 53.29 Column 6 0 Column 7 4.84 Column 8 96 Column 9 01-JAN-1700:00:00:00 IMP-00019: row rejected due to ORACLE error 1 IMP-3: ORACLE error 1 encountered ORA-1: unique constraint (LDDEV.ABHSET1) violated Column 1 101537 Column 2 SL Column 3 5 Column 4 31-DEC-2002:00:00:00 Column 5 38.75 Column 6 0 Column 7 4.84 Column 8 96 Column 9 01-JAN-1700:00:00:00 IMP-00019: row rejected due to ORACLE error 1 IMP-3: ORACLE error 1 encountered ORA-1: unique constraint (LDDEV.ABHSET1) violated Data in Source ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101536 SL 5 31-DEC-02 4.84 0 0 96 01-JAN-00 101536 SL 5 31-DEC-03 53.29 0 4.84 96 01-JAN-00 ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101537 SL 5 31-DEC-02 4.84 0 0 96 01-JAN-00 101537 SL 5 31-DEC-03 38.75 0 4.84 96 01-JAN-00 Data in Target. ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101536 SL 5 31-DEC-02 4.84 0 0 96 01-JAN-00 ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTD BEG_DEPR_LTD LIFE METH_SW_D -- -- -- - -- -- -- - 101537 SL 5 31-DEC-02 4.84 0 0 96 01-JAN-00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Export/Import issue.
Owners are different. I am using fromuser touser. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of anuSent: Wednesday, December 24, 2003 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Export/Import issue. I think data will never change like that. Are the owners the same. Or are you doing fromuser touser. You can use the show option to see the contents of the export dumpfile. Then make sure all objects are dropped. [EMAIL PROTECTED] wrote: I am 100% positive . I tried this process 2-3 times using different approach but same output. I tried to create objects first using no data. I also tried to create objects as part of loading data but no difference. I enabled 10046 trace for the import process but that also didnt help, it showing err=1 at several places but I couldnt figure out why.-Original Message-Mercadante, Thomas FSent: Wednesday, December 24, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LAvnish,Are you absolutely sure that the target table is either gone before theimport, or empty? You should not be getting a unique constraint violationif the table does not exists before import.The step that Oracle import follows for importing is:Create the tableimport the datacreate constraintscreate triggersapply grants.I! f you are getting a unique constraint violation during import, then theconstraints exist before the table is being imported which leads me tobelieve everthing is not as clean as you think. Either that, or the uniqeconstraint in the source database has been disabled, and you have bad data.Make sure you drop the target table before you start the import. And lookat the source data table's constraints to make sure they are all enabled.Good Luck!Tom MercadanteOracle Certified Professional-Original Message-[mailto:[EMAIL PROTECTED]Sent: Wednesday, December 24, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LI am trying to export a table from one database to another. Table in targetdatabase is dropped before importing and is being created as part of importprocess. During import process data Oracle is complaining Unique constraintviolated and throwing out following mes! sages. Its complaining on indexabhset1 which is on columns [asset, book, yr_end_date]. I tried to comparedata in source and target. Somehow yr_end_date for year 2003 is changing to2002 while importing data. Table doesnt have any triggers. Indexes in bothsource and target are same. Table definition is exactly same and createdduring import. Tried to export 2-3 times but same result. Anybody ran intothis issue before. How should I approach to troubleshoot. ThanksError MessageColumn 1 101536Column 2 SLColumn 3 5Column 4 31-DEC-2002:00:00:00Column 5 53.29Column 6 0Column 7 4.84Column 8 96Column 9 01-JAN-1700:00:00:00IMP-00019: row rejected due to ORACLE error 1IMP-3: ORACLE error 1 encounteredORA-1: unique constraint (LDDEV.ABHSET1) violatedColumn 1 101537Column 2 SLColumn 3 5Column 4 31-DEC-2002:00:00:00Column 5 38.75Column 6 0Column 7 4.84Column 8 96Column 9 01-JAN-1700:00:00:00IMP-00019: row rejected due to ORACLE error 1IMP-3: ORACLE error 1 encounteredORA-1: unique constraint (LDDEV.ABHSET1) violatedData in SourceASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTDBEG_DEPR_LTD LIFE METH_SW_D-- -- -- - -- -- -- -101536 SL 5 31-DEC-02 4.84 00 96 01-JAN-00101536 SL 5 31-DEC-03 53.29 04.84 96 01-JAN-00ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTDBEG_DEPR_LTD LIFE METH_SW_D-- -- -- - -- -- -- -101537 SL 5 31-DEC-02 4.84 00 96 01-JAN-00101537 SL 5 31-DEC-03 38.75 04.84 96 01-JAN-00Data in Target.ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTDBEG_DEPR_LTD LIFE METH_SW_D-- -- -- - -- -- -- -101536 SL 5 31-DEC-02 4.84 00 96 01-JAN-00ASSET BOOK COMPANY YR_END_DA DEPR_YTD DEPR_LTDBEG_DEPR_LTD LIFE METH_SW_D-- -- -- - -- -- -- -101537 SL 5 31-DEC-02 4.84 00 96 01-JAN-00-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe
RE: Performance tuning in complex environment
I will try to get the output of v$system_event and will send it you guys. In the mean time I have more question.. I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over looked rest of the chapters but didnt find an easy way to analyze thousands of lines trace file. I am not very good in analyzing big trace files and wondering how you guys analyze do that. Do you do it manually or use any tool to get summarized report. I didnt see anything in that book. I am also planning to take class from HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of your input. Thanks -Original Message- Jared Still Sent: Thursday, December 11, 2003 10:04 PM To: Multiple recipients of list ORACLE-L The wholesale system wide collection of timing data is not generally a good way to go about trouble shooting performance issues. You need to pick a process, collect the timing data for that process, and *only* that process, diagnose where the most time is being spent, and determine what can be done to speed it up. This in a nutshell is the basis of Cary's book, at least per my reading of it. Always try to fix the stuff with the biggest payoff. It could be a SQL statement, it could be a misconfigured or malfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction, then deleting the data and doing it over and over again, all the while doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in it. Just for grins though, how about running this script and posting the output for us? Sometimes you get lucky, and something may appear really out of whack. No guarantees though. Troubleshooting system performance problems takes more than an email. HTH Jared = col event format a35 head 'EVENT NAME' col total_waits format 999,999,999 head TOTAL|WAITS col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS col time_waited format 999,999,999 head TIME|WAITED|SECONDS col average_wait format 9 head AVG|WAIT|100ths set line 150 set trimspool on select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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.net -- Author: Jared Still 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,
Performance tuning in complex environment
Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Performance tuning in complex environment
Not really sure what happened and why we decided to that. I was involved in the beginning of project and remembered that PM was mentioning about talking to another Logician client who were facing same issues. -Original Message- Jamadagni, Rajendra Sent: Thursday, December 11, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Ummm ... what was the problem that prompted you guys to replace citrix servers? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot performance issues. Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers. In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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
ORA-4031 error help.
Hello List, Need some help in resolving ORA-4031 error message. We are using Lawson and for last few days users are getting ORA-4031 error 2-3 times a day in LAWSON log files but there is no error message in alert log file or any trace file. Both shared pool and large pool is set to 1GB. Below is the current init.ora file. We are on Oracle 9202 and AIX 5.1, using MTS. Thanks # Miscellaneous COMPATIBLE=9.2.0 DB_NAME=LAWSON DB_FILES=1500 GLOBAL_NAMES=TRUE DB_BLOCK_SIZE=8192 DB_CACHE_SIZE=1792M DB_KEEP_CACHE_SIZE=16M LARGE_POOL_SIZE=1024M SHARED_POOL_SIZE=1024M SGA_MAX_SIZE = 5G DB_FILE_MULTIBLOCK_READ_COUNT=8 CONTROL_FILE_RECORD_KEEP_TIME=45 CURSOR_SHARING=SIMILAR OPEN_CURSORS=750 # From Lawson--Raised from 500 to 750 10/24/03 BACKGROUND_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/bdump CORE_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/cdump USER_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/udump TIMED_STATISTICS=TRUE CONTROL_FILES=(/appl/lawdb/oracle/data/db01/LAWSON/contrl_LAWSON_01.ctl, /appl/lawdb/oracle/data/db02/LAWSON/contrl_LAWSON_02.ctl, /appl/lawdb/oracle/data/db03/LAWSON/contrl_LAWSON_03.ctl, /appl/lawdb/oracle/data/db04/LAWSON/contrl_LAWSON_04.ctl, /appl/lawdb/oracle/data/db05/LAWSON/contrl_LAWSON_05.ctl) # Archive LOG_ARCHIVE_DEST=/appl/lawdb/oracle/archive_logs/LAWSON/ LOG_ARCHIVE_DUPLEX_DEST=/appl/lawdb/oracle/archive_logs_2/LAWSON/ LOG_ARCHIVE_FORMAT=ARC_LAWSON_%S.%T LOG_ARCHIVE_START=TRUE # LOG_ARCHIVE_TRACE = 1 # Distributed, Replication and Snapshot DB_DOMAIN=PHSOR.ORG # Pools JAVA_POOL_SIZE=0 # Processes and Sessions # PROCESSES=800 Increased value per vendor JMK 6/09/03 PROCESSES=1000 SESSIONS=1140 ENQUEUE_RESOURCES=8000 TRANSACTION_AUDITING=FALSE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE FAST_START_MTTR_TARGET=1200 SORT_AREA_SIZE=0 HASH_AREA_SIZE=0 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undo UNDO_RETENTION = 10800 PGA_AGGREGATE_TARGET=1G WORKAREA_SIZE_POLICY = AUTO JOB_QUEUE_PROCESSES = 10 LOG_BUFFER = 8192000# To reduce 'log file parallel write' wait event in v$system_event CURSOR_SPACE_FOR_TIME = TRUE SERVICE_NAMES=lawson_ax3202a LOCAL_LISTENER=lawson_ax3202a # Network Registration INSTANCE_NAME=LAWSON DISK_ASYNCH_IO = FALSE BACKUP_TAPE_IO_SLAVES=TRUE PARALLEL_THREADS_PER_CPU = 6 PARALLEL_MAX_SERVERS = 6 PARALLEL_MIN_SERVERS = 1 DISPATCHERS=(ADDRESS=(PROTOCOL=TCP)(HOST=provicon)(PORT=5000))(DISPATCHERS=1) MAX_DISPATCHERS = 3 SHARED_SERVERS = 10 MAX_SHARED_SERVERS = 50 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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-4031 error help.
Full error message is ORA-04031: unable to allocate 4032 bytes of shared memory (large pool,unknown object,session heap,frame segment)) I am already monitoing both shared pool and large pool free memory every 30 minutes and there is no issue with that. As I mentioned below Oracle is not displaying any error message or trace file. -Original Message- Sent: Wednesday, October 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Well, you neet to check the full error, because otherwise there's no way to tell if you are running low on shared or large pool. The view that shows space usage in both places in v$sgastat. I suggest you start looking there. Maybe your third-party application doesn't use bind variables and is bloating the shared pool. You could verify this by observing that the sqlarea component of the shared pool is very large as seen in v$sgastat. If this is the case then you might consider testing with cursor_sharing=force. You could also count different versions of similar SQL from the application by grouping sql_text in v$sqlarea by the first 30 characters or so. This assumes your problem is shared pool sqlarea bloat. You could just be runnning out of space for MTS session heaps in the large pool. You have to look at v$sgastat first. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 29 Oct 2003, [EMAIL PROTECTED] wrote: Hello List, Need some help in resolving ORA-4031 error message. We are using Lawson and for last few days users are getting ORA-4031 error 2-3 times a day in LAWSON log files but there is no error message in alert log file or any trace file. Both shared pool and large pool is set to 1GB. Below is the current init.ora file. We are on Oracle 9202 and AIX 5.1, using MTS. # Miscellaneous COMPATIBLE=9.2.0 DB_NAME=LAWSON DB_FILES=1500 GLOBAL_NAMES=TRUE DB_BLOCK_SIZE=8192 DB_CACHE_SIZE=1792M DB_KEEP_CACHE_SIZE=16M LARGE_POOL_SIZE=1024M SHARED_POOL_SIZE=1024M SGA_MAX_SIZE = 5G DB_FILE_MULTIBLOCK_READ_COUNT=8 CONTROL_FILE_RECORD_KEEP_TIME=45 CURSOR_SHARING=SIMILAR OPEN_CURSORS=750 # From Lawson--Raised from 500 to 750 10/24/03 BACKGROUND_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/bdump CORE_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/cdump USER_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/udump TIMED_STATISTICS=TRUE CONTROL_FILES=(/appl/lawdb/oracle/data/db01/LAWSON/contrl_LAWSON_01.ctl, /appl/lawdb/oracle/data/db02/LAWSON/contrl_LAWSON_02.ctl, /appl/lawdb/oracle/data/db03/LAWSON/contrl_LAWSON_03.ctl, /appl/lawdb/oracle/data/db04/LAWSON/contrl_LAWSON_04.ctl, /appl/lawdb/oracle/data/db05/LAWSON/contrl_LAWSON_05.ctl) # Archive LOG_ARCHIVE_DEST=/appl/lawdb/oracle/archive_logs/LAWSON/ LOG_ARCHIVE_DUPLEX_DEST=/appl/lawdb/oracle/archive_logs_2/LAWSON/ LOG_ARCHIVE_FORMAT=ARC_LAWSON_%S.%T LOG_ARCHIVE_START=TRUE # LOG_ARCHIVE_TRACE = 1 # Distributed, Replication and Snapshot DB_DOMAIN=PHSOR.ORG # Pools JAVA_POOL_SIZE=0 # Processes and Sessions # PROCESSES=800 Increased value per vendor JMK 6/09/03 PROCESSES=1000 SESSIONS=1140 ENQUEUE_RESOURCES=8000 TRANSACTION_AUDITING=FALSE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE FAST_START_MTTR_TARGET=1200 SORT_AREA_SIZE=0 HASH_AREA_SIZE=0 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undo UNDO_RETENTION = 10800 PGA_AGGREGATE_TARGET=1G WORKAREA_SIZE_POLICY = AUTO JOB_QUEUE_PROCESSES = 10 LOG_BUFFER = 8192000# To reduce 'log file parallel write' wait event in v$system_event CURSOR_SPACE_FOR_TIME = TRUE SERVICE_NAMES=lawson_ax3202a LOCAL_LISTENER=lawson_ax3202a # Network Registration INSTANCE_NAME=LAWSON DISK_ASYNCH_IO = FALSE BACKUP_TAPE_IO_SLAVES=TRUE PARALLEL_THREADS_PER_CPU = 6 PARALLEL_MAX_SERVERS = 6 PARALLEL_MIN_SERVERS = 1 DISPATCHERS=(ADDRESS=(PROTOCOL=TCP)(HOST=provicon)(PORT=5000))(DISPATCHERS=1) MAX_DISPATCHERS = 3 SHARED_SERVERS = 10 MAX_SHARED_SERVERS = 50 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If
RE: RMAN - Compressing using named piped
I dont think you can compress rman files while backups are running. RMAN doesnt support external compression while backups are running 'cause RMAN has to validate backups. You can compress all the files once your backup is completed. I tried that in the past but didnt work. Infect thereare sometechnical forums onmetalink about that. I have a script which I used to validate backups and gzip files after backups are completed. If you are interested I can send you offline, script is not very good but worked fine. -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 7:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product searchDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: Oracle Compress Option
Yes please, my email id is [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 24, 2003 7:05 PM To: Multiple recipients of list ORACLE-L Compress to impress? by Julian Dyke is a good presentation on this topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.htm). I do have the article - 202 K with no compression, 147 K with compression :). Let me know if you're interested, and I'll email it directly to you. Mogens [EMAIL PROTECTED] wrote: Does anybody has any experience with Oracle 9I compression option. I did some test on 9202 with a table of more 14 million rows. Table has total 7 indexes. Surprising both table and indexes are using more space after compression. Before compression space used is 13064MB and after compression 13184MB. In both the cases I did export from source table and stored in two different tablespaces. Any insight on that and any disadvantages of using that. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.vhttp://www.ukoug.org/calendar/jan03/jan30ab.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 Standby database.
We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 Standby database.
Its possible 'cause we are two different OS and DB versions. Would it be possible if we upgrade source database from 816 to 8174 and then use Standby database. -Original Message- Sent: Thursday, September 25, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Avnish: That is not possible in 8.1.7. You need to be atleast 9.2 to do that. --- [EMAIL PROTECTED] wrote: We are planning to migrate one 600GB OPS (2 nodes) database from AIX 433 Oracle 816 to AIX5.1 Non OPS Oracle 8174. Is it possible to use Oracle standby database of two different versions of OS and database. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Multiple block sizes
Title: Message I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: Multiple block sizes
Title: Message Not really, except to watch closely your hit ratio for no default cache other than that we used alter table move and alter index rebuild online option to move tables/indexes. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Oracle Compress Option
Does anybody has any experience with Oracle 9I compression option. I did some test on 9202 with a table of more 14 million rows. Table has total 7 indexes. Surprising both table and indexes are using more space after compression. Before compression space used is 13064MB and after compression 13184MB. In both the cases I did export from source table and stored in two different tablespaces. Any insight on that and any disadvantages of using that. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: SGA Max size
In 9202, DB_BUBBER_CACHE, SHARED_POOL, LARGE_POOL and JAVA_POOL can be dynamically altered. But in 901, LARGE_POOL and JAVA POOL are static. If MAX SGA is less than 128MB then Oracle will use 4MB granule size to allocate/deallocate memory. For SGA greater than 128M, Oracle granule size is 16MB. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/20/03 11:19 AM My understanding of SGA is SGA = x + y + z where x = (dbblksize*db_blk_buf OR db_cache_Size if 9i) y=shared_pool z=java pool, log_buffer If 9i oracle introduced SGA_MAX_SIZE; the sum of x+y+z can be SGA_MAX_SIZE; if so, which part of x/y/z expands when need arises. Thanks Quriyat ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
dbms_job issue.
Hello List, I am running into weird dbms_job issue. I have a dbms_job to collect perfstat every 1 hour , job was running fine for last 8-9 months without any issue. For last 3 days job is stopping every night around 2 AM. I amnot seeing any trace file, any logs in alert file. Any idea what is cuasing this. Below is the output from dba_jobs. We are on 9202 AIX 5L. JOB LAST_DATE NEXT_DATE THIS_DATE B FAILURES TOTAL_TIME-- -- -- -- - -- -- 45 18-SEP-03 02:01:02 18-SEP-03 03:00:00 N 0 175DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: dbms_job issue.
Already tried to resubmit it twice, everytime its breaking around mid night. -Original Message-From: Venu Gopal [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003 10:40 AMTo: Multiple recipients of list ORACLE-LSubject: RE: dbms_job issue. Re-submit the jobthat should work It has a long theory!! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Thursday, September 18, 2003 11:00 PMTo: Multiple recipients of list ORACLE-LSubject: dbms_job issue. Hello List, I am running into weird dbms_job issue. I have a dbms_job to collect perfstat every 1 hour , job was running fine for last 8-9 months without any issue. For last 3 days job is stopping every night around 2 AM. I amnot seeing any trace file, any logs in alert file. Any idea what is cuasing this. Below is the output from dba_jobs. We are on 9202 AIX 5L. JOB LAST_DATE NEXT_DATE THIS_DATE B FAILURES TOTAL_TIME-- -- -- -- - -- -- 45 18-SEP-03 02:01:02 18-SEP-03 03:00:00 N 0 175 DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *** DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: dbms_job issue.
Resubmit it and it runs fine until mid night. So I really dont have any stats for this week. -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: dbms_job issue. You said for the last 3 days, so what do you do to get it running again? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Thursday, September 18, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: dbms_job issue. Hello List, I am running into weird dbms_job issue. I have a dbms_job to collect perfstat every 1 hour , job was running fine for last 8-9 months without any issue. For last 3 days job is stopping every night around 2 AM. I amnot seeing any trace file, any logs in alert file. Any idea what is cuasing this. Below is the output from dba_jobs. We are on 9202 AIX 5L. JOB LAST_DATE NEXT_DATE THIS_DATE B FAILURES TOTAL_TIME-- -- -- -- - -- -- 45 18-SEP-03 02:01:02 18-SEP-03 03:00:00 N 0 175 DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: confused about SID and SERVICE_NAME in tnsnames.ora
To use service_name, make sure that you have defined local_listener and service_name in init.ora file. -Original Message- Sent: Thursday, September 18, 2003 10:55 AM To: Multiple recipients of list ORACLE-L hi all. i have two databases running oracle 817 on different machines (AIX 4.3). I am trying to connect to these databases remotely from my desktop. when I use the SERVICE_NAME = in the connect_id for one of the databases, I get ora 12500 error. When I replace it with SID= everything works fine. For another database, SERVICE_NAME works every time. I looked and both databases and couldn't see anything to explain this . Can someone shed some light onto this. My Oracle client is 9201. thanks gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Move SQL Server Tables to Oracle
You can try to create Oracle linked server in sql server and you should be able insert from SQL Server to Oracle. I used this approach to get data from DB2 to SQL Server. -Original Message-From: Gunnar Berglund [mailto:[EMAIL PROTECTED]Sent: Thursday, September 18, 2003 1:00 AMTo: Multiple recipients of list ORACLE-LSubject: Move SQL Server Tables to Oracle Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends?Get the FREE Yahoo! MessengerDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: confused about SID and SERVICE_NAME in tnsnames.ora
Another thing I would check will be tnsnames.ora. I am using it in 9I and I defined service_name and local_listener init.ora. In the tnsnames.ora I defined SERVICE_NAME not ORACLE_SID. For listenet I am using self service registration. -Original Message- Sent: Thursday, September 18, 2003 12:15 PM To: Multiple recipients of list ORACLE-L Avnish, I have both of these parameters defined in each of the two databases. Yet, service_name only works on one. Gene --- [EMAIL PROTECTED] wrote: To use service_name, make sure that you have defined local_listener and service_name in init.ora file. -Original Message- Sent: Thursday, September 18, 2003 10:55 AM To: Multiple recipients of list ORACLE-L hi all. i have two databases running oracle 817 on different machines (AIX 4.3). I am trying to connect to these databases remotely from my desktop. when I use the SERVICE_NAME = in the connect_id for one of the databases, I get ora 12500 error. When I replace it with SID= everything works fine. For another database, SERVICE_NAME works every time. I looked and both databases and couldn't see anything to explain this . Can someone shed some light onto this. My Oracle client is 9201. thanks gene __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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
RE: log buffer space wait
I have one question regarding these wait times, may be dump.In the following wait events what is the unit of measurement for Time, I believe its in seconds as per the documentation. If yes thenhere stats are collectedfor only 51.23 Minutes (Appx 3073 seconds), how come Oracle is showing 566,516 seconds wait for log buffer space. I would appreciate if someone can explain. Thanks Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- log buffer space 1,817,258 566,516 56.24 latch free 2,964,652 334,120 33.17 log file sync 55,230 43,488 4.32 buffer busy waits 62,839 26,129 2.59 CPU time -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 02, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: log buffer space wait At a Benchmark a particular Processing + DML intensive batch Job (Accounts Interest Calculation) is experiencing log buffer space wait . Config :- On Solaris 9 Cpu_count = 72 Oracle 9.2 Online Redo logfiles are on a RAID 0+1 Volume (NOT Raw or RAID 1) Log_buffer = 10 M $ sar Command Outpuit %wio only about 6 % for Volume containing the redo logfiles Database in NOARCHIVELOG mode Qs. How can we reduce this wait event ? Would RAW / RAID 1 for redo logfiles help ? Qs. Could this be a Bug ? * STATSPACK report for DB Name DB Id Instance Inst Num Release Cluster Host --- --- --- BM2 3727568246 bm2 1 9.2.0.3.0 NO sleepy Snap Id Snap Time Sessions Curs/Sess Comment --- -- - --- Begin Snap: 240 01-Sep-03 03:09:41 23 1.5 End Snap: 241 01-Sep-03 04:00:55 24 1.7 Elapsed: 51.23 (mins) Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- log buffer space 1,817,258 566,516 56.24 latch free 2,964,652 334,120 33.17 log file sync 55,230 43,488 4.32 buffer busy waits 62,839 26,129 2.59 CPU time 22,018 2.19 - Wait Events for DB: BM2 Instance: bm2 Snaps: 240 -241 - s - second - cs - centisecond - 100th of a second - ms - millisecond - 1000th of a second - us - microsecond - 100th of a second - ordered by wait time desc, waits desc (idle events last) Avg Total Wait wait Waits Event Waits Timeouts Time (s) (ms) /txn -- -- -- log buffer space 1,817,258 139 566,516 312 54.4 latch free 2,964,652 892,594 334,120 113 88.8 log file sync 55,230 21,210 43,488 787 1.7 buffer busy waits 62,839 10,250 26,129 416 1.9 Latch Activity for DB: BM2 Instance: bm2 Snaps: 240 -241 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss (s) Requests Miss -- -- -- -- -- post/wait queue 97,357 4.7 0.4 577 1,871,155 249.5 process allocation 751 7.2 3.0 10 747 0.5 process group creation 1,502 0.0 0 0 redo allocation 24,482,283 13.5 0.4 ## 0 redo copy 675,177 99.6 1.1 ## 21,986,833 708.0 init.ora Parameters for DB: BM2 Instance: bm2 Snaps: 240 -241 End value Parameter Name Begin value (if different) - - -- _db_block_lru_latches 128 audit_trail FALSE background_dump_dest /oracle/ora92-64/rdbms/log/bdump compatible 9.2.0.3 control_files /lbmdb02/bm2/data02/control_01_bm core_dump_dest /oracle/ora92-64/rdbms/log/cdump cursor_sharing EXACT cursor_space_for_time TRUE db_block_size 8192 db_cache_size 1258291200 db_file_multiblock_read_count 32 db_files 1500 db_keep_cache_size 117440512 db_name bm2 db_writer_processes 16 dml_locks 1 enqueue_resources 68 hash_join_enabled FALSE java_pool_size 16777216 large_pool_size 16777216 log_buffer 10485760 log_checkpoint_interval 0 log_checkpoint_timeout 0 log_checkpoints_to_alert TRUE max_dump_file_size 10240 max_rollback_segments 4000 nls_date_format DD-MM- open_cursors 1000 open_links 4 optimizer_index_cost_adj 15 optimizer_mode CHOOSE os_authent_prefix
Migration Suggestion.
I am looking for some expert suggestions for the migration of 300GB database to different hardware. Currently database is 816 OPS on AIX 4.1 nodes. Database is 32bit and performance on this system is really slow. Export for 2GB table takes 2 hours. All the data is on EMC symmetric. We are planning to migrate this database to AIX5.1 Oracle 8174 32Bit. Oracle 816 on AIX5.1 is not supported. 'Cause OS is different we cannot use redirect restore and apply archive logs to bring the database up. Any suggestion regarding migration. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
ORA-3113
Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database holds RMAN catalog for more than 30 databases and really very critical. Please share your ideas. I already tried to relink and rebooting the server. Database is 816 64bit on HP-UX 11.11 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 Name Server
We are using Oracle Name Server in our environment. In the past I heard rumors that Oracle Name Server is going away. Is it true if yes what other solution Oracle is providing to replace Name Server. Is it LDAP. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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-3113
No, There is no log generated. Below is the only message I am getting. hp204:NAMES :/home/oracle svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-03113: end-of-file on communication channel SVRMGR -Original Message- Sent: Wednesday, August 06, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Any log file output? Mike -Original Message- [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 16:29 To: Multiple recipients of list ORACLE-L Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database holds RMAN catalog for more than 30 databases and really very critical. Please share your ideas. I already tried to relink and rebooting the server. Database is 816 64bit on HP-UX 11.11 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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
RE: ORA-3113
I tried relinking all and rebooting server then relink again but no luck. -Original Message- Sent: Wednesday, August 06, 2003 10:10 AM To: Multiple recipients of list ORACLE-L left over memory segments/shared memory/semaphores? ipcs is your friend, oh and its destructive brother ipcrm :) joe [EMAIL PROTECTED] wrote: No, There is no log generated. Below is the only message I am getting. hp204:NAMES :/home/oracle svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-03113: end-of-file on communication channel SVRMGR -Original Message- Sent: Wednesday, August 06, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Any log file output? Mike -Original Message- [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 16:29 To: Multiple recipients of list ORACLE-L Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database holds RMAN catalog for more than 30 databases and really very critical. Please share your ideas. I already tried to relink and rebooting the server. Database is 816 64bit on HP-UX 11.11 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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). DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
Log buffer and Shared Pool tuning.
What are the things I should monitor to make sure that Shared Pool and Log buffer are set correctly. On one database I have Shared pool GAB and Log buffer MOB, are these values too high. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: rebuild index -initial extent - magic??!!
Title: RE: rebuild index -initial extent - magic??!! Rebuild will use the same initial extent as it was before but will change the next extent size. Either drop and recreate index orYou can also think about using Locally managed Uniform Extent size tablespace, that way you dont have to worry about specifying initial and next extent. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 3:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: rebuild index -initial extent - magic??!! I did the following in Oracle RDBMS 9i: _ SQL alter index xsc_uk rebuild tablespace ax_le_small storage (initial 128K 2 next 128K); SQL select initial_extent,next_extent,index_name from dba_indexes 2 where index_name like 'XSC%'; 65536 131072 XSC_CLNT_FK_I 65536 131072 XSC_PK 131072 131072 XSC_UK _ As I wish to use uniform extent sizing and I was given an import that does have that. I am a little concerned about the initial extent changing - what if there is data in the index? - how it could possibly deallocate space if you wish to have a smaller extent size. It was very quick. Did I really end up with new extents for XSC_UK each 128KDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: upgrade to 9i
If its not an then you can simply run catalog.sql and catproc.sql to upgrade oracle dictionary tables. Also during 9I installation Oracle ask to upgrade existing databases on that system. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 3:54 PMTo: Multiple recipients of list ORACLE-LSubject: upgrade to 9i Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -akDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.