Re: Not able to add DB which is ruuning on the local node
Is this database on the same O_H as OEM or a different one ? Also you may want to review MEtalink articles on How OEM discovers a node on Metalink... Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 10:44 AM Hi List: I installed Oracle 9i on Windows NT,configured OEM on Windows and could successfully connect to OEM. Discover node works fine for remote machines(adds database,listener,http server,ect) but not allowing me to add database which isrunning on local machine. Even OEM is not allowing me to add DB using manual configuration. What could be wrong? Did anyone come across this scenario? Any help would be really appreciated. TIA -Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babu Nagarajan 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: events number and meaning
you can find the list of events under $ORACLE_HOME/rdbms/mesg/oraus.msg. babu - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 26, 2003 7:08 AM Subject: FW: events number and meaning -Original Message-From: Paulo Gomes Sent: quarta-feira, 26 de Março de 2003 11:17To:Subject: events number and meaning Hi guys. Where can i find a list of Oracle Db (8i, 9i and 9iR2) events and menning? and by the way how can i fire a Stored procedure if a event (ex.: Shutdown or Startup) is ocurring? Thanks PG
Re: Large Export Problem ......
2) A caveat of using this method: Important: Incremental, cumulative, and complete Exports are obsolete features that will be phased out in a subsequent release I think this has already happened with 9i... I would suggest going to RMAN and taking incremental cold backups and taking weekly/daily 1. full export w/o data (to get the structure) 2. data export of non-static data using (tablespaces=(list) - a 9i feature but i think u can install 9i anduse the exp binary against the 8i db you have. i have not tried it though) monthly/whatever 1. export of static data (this can be run during the day with consistent=n to minimize downtime) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:44 PM Babu, First, if it were me, I'd put this thing in archive log mode. If we may need to recover between full backups, that is the tried and true means. But, on to your question. I'd look at a plan utilizing incremental exports. You start with a 'base' full export (weekly, monthly, whichever), and do daily incremental or cumulative exports. I'm not going to offer too much detail here because I've never actually used this and because you really should read all of the oracle documentation on this before implementing it ... http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/toc. htm Two things I'll point out from that document: 1) A quote which directly addresses one of your issues... You can do incremental, cumulative, and complete exports only in full database mode (FULL=Y). 2) A caveat of using this method: Important: Incremental, cumulative, and complete Exports are obsolete features that will be phased out in a subsequent release Please let us know how this turns out for you or if additional help is needed. Thanks, Darrell [EMAIL PROTECTED] 03/25/03 01:59PM Dear List, I have a large unarchived decission support database of size 270gig. We do take coldbackup of database files every sunday. We also take export backup to suplement the coldbackup. Export is taking too much time which we can't afford now. I need to reduce the export time to fit the weekend schedule. In the last few weeks it is failing as the database is down for coldbackups while the export is running. The database structure is as follows: Partitioned tables size: 200gig [static partitions(prior years) size 150 gig, and non-static partitions(current yr) size 50gig] non-partitioned tables: 70gig I don't need to export static partitions every week. Once in 3/6months is OK. I don't think I can eliminate static partitions in one full export script/parameter file. Iam thinking of eliminating the static partitions by taking export in TABLE mode, which includes only NON-STATIC partitions and the remaining NON-PARTITION tables. I may have to hardcode the table names. The database has lots of packages/stored procs which will be stored in the dictionary I believe. My questions are: [1] How can I reconstruct a database using this type of export if needed? [2] How can I simulate full export in this type (Table Mode) of export? [3] How can I export packages/stored procs and import to new DB if necessary? [4] Is there any other way to export the full database and eliminate the static partitions in a single step? [5] What is the best way to solve my export problem?? Any ideas are appreciated. Thanks, -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: Darrell Landrum 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: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City
Re: Passing DB-Link name in a Loop
Hemant I faced the same problem when setting up a centralized monitoring utility (very much similar to what you are trying to accomplish here, I think) For the Ora-2020 - either increase the distributed_transactions parameter or use dbms_sql instead of execute immediate where you can explicitly close the connection by dbms_sql.close(cursor) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 21, 2003 4:49 AM Thanks Tim ! That works ! now I just have to resolve the ORA-02020: too many database links in use error ! Thanks again. Hemant --- Tim Onions [EMAIL PROTECTED] wrote: Hemant In case nobody has yet replied I believe your error is that you cannot use a bind variable in an execute immediate for the db link name as you are trying to do with this statement: exec_string := 'select sum(bytes)/1048576 from dba_data_files@:b1'; Changing it to this might work (I've not checked it myself so no guarantees) exec_string := 'select sum(bytes)/1048576 from dba_data_files@'||remote_db; execute immediate exec_string into db_size; T¬ -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: 21 March 2003 01:34 To: Multiple recipients of list ORACLE-L Subject: Passing DB-Link name in a Loop Guys, help me here. This SQL [below] returns the error : connecting to AM3C01 declare * ERROR at line 1: ORA-01729: database link name expected ORA-06512: at line 16 [AM3C01] is the first db_link fetched. tti 'Database Sizes (excluding TEMPFILEs) ' center spool DB_Sizes set serveroutput on size 5; declare cursor c1 is select db_link from user_db_links; remote_DB varchar2(128); db_size number; exec_string varchar2(255); begin open c1; loop fetch c1 into remote_DB; exit when c1%NOTFOUND; dbms_output.put_line('connecting to '||remote_DB); -- select sum(bytes)/1048576 into db_size from [EMAIL PROTECTED]; exec_string := 'select sum(bytes)/1048576 from dba_data_files@:b1'; execute immediate exec_string into db_size using remote_DB; dbms_output.put_line('DB : '||remote_DB||':'||db_size); end loop; close c1; commit; end; / spool off Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Babu Nagarajan 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: Force to use a tablespace
create table table_name column_list tablespace tablespace_name; babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 6:53 AM Hallo, anyone who knows how to force a table to use a special tablespace? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babu Nagarajan 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: Veritas Quick I/O for Oracle
we recently moved from t64 to sun and had io related perf issues w/o quick io. once the veritas db version (which which quick io comes) was installed, the performance was back on par with t64... babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:14 AM Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new Solaris systems with fiber channel and Veritas File System, and the Veritas salesperson is claiming up to 400 times faster. I would like to know if anyone else has discovered this miracle and what benefits you are seeing. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babu Nagarajan 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: File Restoration/Recovery
you are right and the developer is not. cold backups taken with the db open are worthless. you cannot use them to open it back to a consistent state babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:44 AM All... A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires a nightly backup (by simply copying them to a backup directory) of the datafiles of an active instance. I explain that it will be a waste of tape because the files will be corrupt and useless. He counters, As long as these files are there, irrespective of their state, oracle [sic] provides the tools to restore the skeleton database based on these files. Will this be the case? I understand that there will [most likely] be some loss of data, but will Oracle fix itself to a point where it's useful again? TIA Gary Chambers //-- // Lucent Technologies ITO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers 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: Babu Nagarajan 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 Tools
Checkout Oracle Lite Babu Sultan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: Oracle Tools [EMAIL PROTECTED] 03/05/03 06:49 AM Please respond to ORACLE-L Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: oracle version
did u try the inventory logs ? Babu kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: om Subject: Re: FW: oracle version Sent by: [EMAIL PROTECTED] 03/05/03 01:09 PM Please respond to ORACLE-L Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle version From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa 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: Hatzistavrou John 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! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: How to improve queries remotely
Limit the data you get across the network... Take the query that gets sent across the db link (u can get it from the explain plan or oem sql analyze) and runit on the remote db and check its access path Thanks a lot... Babu Nguyen, David M [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: How to improve queries remotely [EMAIL PROTECTED] 03/05/03 04:54 PM Please respond to ORACLE-L What is a guideline to improve remotely query using database link? Regards, David _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Statistics on SYS?
I think you are not supposed to collect statistics on sys tables till 9i... Babu Chuck Hamilton [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] net cc: Sent by: Subject: Statistics on SYS? [EMAIL PROTECTED] 02/28/03 12:09 PM Please respond to ORACLE-L What's the current recommendation for gathering statistics on system schema objects like SYS, and OUTLN? Are they still saying not to do it? I am on 8.1.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton 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 transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance issues on Sun - solved
Thanks to Cary, Jared, Ferenc whose inputs helped a lot in solving the problem. Ferenc's document did the trick... Once we converted the files to use Qio, the performance was much much better... Thanks a lot... Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: performance issues on sun
My bad. I should also have posted the 10046 trace. I did a 10046 trace and also a STATSPACK report. Of the total time, more than 50% of the time is spent waiting on DIRECT PATH WRITE and around 40% of the time it waits on DIRECT PATH READ. This is what prompted me to do a truss and see what it is doing.. From one of the Veritas whitepapers - I found this Quick I/O allows databases to access regular files on a VxFS file system as raw character devices, improving throughput for Oracle databases. Unlike raw devices, Quick I/O files can still be managed as regular UNIX files. There are three requirements to use Quick I/O: 1. Quick I/O driver (VRTSqio) must be loaded before a regular file can be accessed through the Quick I/O interface. 2. Files must be preallocated on a VxFS file system. The file must be preallocated because the file cannot be extended through writes via its Quick I/O interface. This preallocation can be done using the qiomkfile command. This command ensures that the file is created as a single large extent, or as a chain of direct extents. Using direct extents is inherently faster than using indirect extents. 3. The file must be accessed via its Quick I/O name extension (::cdev:vxfs:). In a VxFS file system, a file can be accessed using two types of interface: regular file and device file. The device file interface allows a regular file to be accessed as a raw character device. This is achieved by using the Quick I/O naming extension of ::cdev:vxfs: while accessing a regular file. For example, a file named system.dbf can be accessed as a raw character device when the name system.dbf::cdev:vxfs: is used for database access. Converting Oracle Database Files on VERITAS File System to use Quick/IO The scripts getdbfiles.sh and mkqio.sh are provided to easily change Oracle database files to use Quick I/O. The database files must be on VxFS file systems before they can be converted. The getdbfiles.sh script is a shell script that can be run by the Oracle DBA (with appropriate user ID) while the database instance is up and running. This script extracts the filenames from the system tables of the database and stores the filenames in a file called mkqio.dat. Alternatively, you can manually create the mkqio.dat file containing the Oracle database filenames to convert for use with Quick I/O. The mkqio.sh script processes a list of filenames in the file mkqio.dat and converts them to use Quick I/O. This conversion process should be performed while the database is closed. The mkqio.sh script must also be run by the Oracle user of the database instance to avoid any permission problems. I think Quick IO is needed on VxFS to perform KAIO calls. Have anyone done this before? Any input is greatly appreciated. Babu Cary Millsap [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sos.com cc: Sent by: Subject: RE: performance issues on sun [EMAIL PROTECTED] 02/25/03 05:23 PM Please respond to ORACLE-L I wish now that I hadn't deleted what I composed this morning... It was this: People probably get sick of seeing me say the same thing over and over and over... You have some interesting information from the truss that you've done. But you can't tell how long
Re: trace (get) sql script
Run STATSPACK at Level 5 (default). It will capture most of the offending SQL Statements Babu [EMAIL PROTECTED] anzcp.co.thTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: trace (get) sql script 02/26/03 03:33 AM Please respond to ORACLE-L Dear All, Here we have about 14 Oracle devlopers and some times they run a sript which down grade the database performance. I nicely asked for a script that a developer has run for testing but sometimes they won't give away it so easily. So I would like to know that is it possible to get the script the develper is running from Oracle v$ views or table ? so I can be on top of the problem and provide a good answer to other. I believe that in each site, there is a developer who not easily to tell DBA what he/she is doing until they really cause a problem. Thanks you for help. Ukrit K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OEM - Automation of Start of Collection for Performance Reports
I have seen some folks record the performance data and then play it back in OEM. I think it is there in the performance manager add in. Is that what you want? How different you expect this to be from STATSPACK? Babu VIVEK_SHARMA [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] osys.comcc: Sent by: Subject: OEM - Automation of Start of Collection for Performance Reports [EMAIL PROTECTED] 02/25/03 09:38 PM Please respond to ORACLE-L How can Start of Collection of Performance Reports be automated in OEM 9.2 , before a Transactions' Run ? There Exist about 100 such Performance Reports . Manually starting Collection of these individually takes too much effort collection has to be started much before the actual transactions' run thereby containing lots of unnecessary data . NOTE - Collection for All these STARTed performance reports can be STOPPED by a Single Click . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: performance issues on sun
Ferenc Thanks for the document. I am working with the SAs to try to implement it. Will update the results once complete.. Thanks a lot... Babu Ferenc Mantfeld [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] us.net.au cc: Sent by: Subject: Re: performance issues on sun [EMAIL PROTECTED] 02/26/03 02:14 PM Please respond to ORACLE-L Agree with Jared. However, if you have determined that the synchronous IO and all that is slowing you down, and you want to proceed to direct IO, and Qio is what you want, I would suggest that you get Veritas to help you. It will take about 1 - 2 hours to set up for a 100 GB DB. I have a document outlining all the steps I took to do this (as root), I will forward to you from my other email). You will have to drop and recreate your TEMP tablespace as outlined in the doc. Cheers : Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 5:21 AM The failed KAIO calls normally happen very quickly and have little impact on your system. I did run into some buggy Hitachi/Solaris/Vxfs configuration once that took a very long time to fail the KAIO calls. You could always just set disk_asynch_io=false in init.ora. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/26/2003 04:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: performance issues on sun My bad. I should also have posted the 10046 trace. I did a 10046 trace and also a STATSPACK report. Of the total time, more than 50% of the time is spent waiting on DIRECT PATH WRITE and around 40% of the time it waits on DIRECT PATH READ. This is what prompted me to do a truss and see what it is doing.. From one of the Veritas whitepapers - I found this Quick I/O allows databases to access regular files on a VxFS file system as raw character devices, improving throughput for Oracle databases. Unlike raw devices, Quick I/O files can still be managed as regular UNIX files. There are three requirements to use Quick I/O: 1. Quick I/O driver (VRTSqio) must be loaded before a regular file can be accessed through the Quick I/O interface. 2. Files must be preallocated on a VxFS file system. The file must be preallocated because the file cannot be extended through writes via its Quick I/O interface. This preallocation can be done using the qiomkfile command. This command ensures that the file is created as a single large extent, or as a chain of direct extents. Using direct extents is inherently faster than using indirect extents. 3. The file must be accessed via its Quick I/O name extension (::cdev:vxfs:). In a VxFS file system, a file can be accessed using two types of interface: regular file and device file. The device file interface allows a regular file to be accessed as a raw character device. This is achieved by using the Quick I/O naming extension of ::cdev:vxfs: while accessing a regular file. For example, a file named system.dbf can be accessed as a raw character device when the name
Re: Partitioning
what do you mean by storage size? if you mean the initial, next and so on - yes you can. if you are talking about how big it should be - i dont think you can do it... Babu Conrad Meertins [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] e-data.com cc: Sent by: Subject: Partitioning [EMAIL PROTECTED] 02/26/03 04:44 PM Please respond to ORACLE-L If you have a table partitioned, can you specify the storage size of each partition in that tables I looked at dba_tab_partitions and dba_segments views. Although the show me storage information, I am unable to create a table where I can specify the storage size for each partition. Am I doing something wrong Or you cannot specify a storage size for partitions. Please help.. Thanks Conrad... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Conrad Meertins 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 transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
performance issues on sun
All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take 20 min on T64. I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES. The index tablespace and the temporary tablespace are on separate mountpoints which reside on separate disks. I am doing a truss on the session and see that its doing the following kaio(AIOWAIT, 0x) Err#22 EINVAL pread(364, \b02\0\0\v\099E1 f h ECB.., 1048576, 0x26784000) = 1048576 kaio(AIOWAIT, 0x) Err#22 EINVAL lwp_cond_wait(0x7CED7F70, 0x7CED7F80, 0x) = 0 pwrite(408, 0602\0\0\nC41007 f h SDD.., 49152, 0x10401C000) = 49152 pwrite(408, 0602\0\0\nC410\n f h SDD.., 49152, 0x104028000) = 49152 pwrite(408, 0602\0\0\nC410\r f h SDD.., 49152, 0x104034000) = 49152 pwrite(408, 0602\0\0\nC41010 f h SDD.., 49152, 0x10404) = 49152 pwrite(408, 0602\0\0\nC41013 f h SDD.., 49152, 0x10404C000) = 49152 pwrite(408, 0602\0\0\nC41016 f h SDD.., 49152, 0x104058000) = 49152 pwrite(408, 0602\0\0\nC41019 f h SDD.., 49152, 0x104064000) = 49152 pwrite(408, 0602\0\0\nC4101C f h SDD.., 49152, 0x10407) = 49152 pwrite(408, 0602\0\0\nC4101F f h SDD.., 49152, 0x10407C000) = 49152 pwrite(408, 0602\0\0\nC410 f h SDD.., 49152, 0x104088000) = 49152 pwrite(408, 0602\0\0\nC410 % f h SDD.., 49152, 0x104094000) = 49152 pwrite(408, 0602\0\0\nC410 ( f h SDD.., 49152, 0x1040A) = 49152 pwrite(408, 0602\0\0\nC410 + f h SDD.., 49152, 0x1040AC000) = 49152 pwrite(408, 0602\0\0\nC410 . f h SDD.., 49152, 0x1040B8000) = 49152 pwrite(408, 0602\0\0\nC410 1 f h SDD.., 49152, 0x1040C4000) = 49152 pwrite(408, 0602\0\0\nC410 4 f h SDD.., 49152, 0x1040D) = 49152 fdsync(408, O_RDONLY|O_SYNC)= 0 pwrite(408, 0602\0\0\nC410 7 f h SDE.., 49152, 0x1040DC000) = 49152 pwrite(408, 0602\0\0\nC410 : f h SDE.., 49152, 0x1040E8000) = 49152 pwrite(408, 0602\0\0\nC410 = f h SDE.., 49152, 0x1040F4000) = 49152 pwrite(408, 0602\0\0\nC410 @ f h SDE.., 49152, 0x10410) = 49152 pwrite(408, 0602\0\0\nC410 C f h SDE.., 49152, 0x10410C000) = 49152 lwp_cond_wait(0x7CF0DF70, 0x7CF0DF80, 0x) = 0 lwp_cond_signal(0x7CF0DF70) = 0 pread(364, \b02\0\0\v\09A ! f h ECB.., 16384, 0x26884000) = 16384 I think it is trying to do a KAIO call and failing. Then it attempts a synchronous PWRITE call. But our SAs are not able to help us to confirm this. Have any of you seen this issue? Any inputs would be greatly appreciated. I'll gladly provide you with addl info if you need. Thanks in advance Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: performance issues on sun
- Where is the tablespace of the table? Shared disk with temp or index tablespace? Its on a different mountpoint (and disk) from the index or the temp tablespaces - Check your SORT_AREA_SIZE on both systems. Its 1 Mb. I have done the tests with as much as 250M but same results - Do some basic disk I/O tests. On both the Compaq and Solaris, move a large file from one drive to another, just to see what time it takes. If the Solaris system is significantly slower, discuss this with your system administrators. If I do a simple cp, I am not able to see any big performance difference Thanks a lot... Babu DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] UCH.COM cc: Sent by: Subject: RE: performance issues on sun [EMAIL PROTECTED] 02/25/03 10:14 AM Please respond to ORACLE-L Babu - I would recommend checking: - Where is the tablespace of the table? Shared disk with temp or index tablespace? - Check your SORT_AREA_SIZE on both systems. - Do some basic disk I/O tests. On both the Compaq and Solaris, move a large file from one drive to another, just to see what time it takes. If the Solaris system is significantly slower, discuss this with your system administrators. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 8:11 AM To: Multiple recipients of list ORACLE-L All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take 20 min on T64. I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES. The index tablespace and the temporary tablespace are on separate mountpoints which reside on separate disks. I am doing a truss on the session and see that its doing the following kaio(AIOWAIT, 0x) Err#22 EINVAL pread(364, \b02\0\0\v\099E1 f h ECB.., 1048576, 0x26784000) = 1048576 kaio(AIOWAIT, 0x) Err#22 EINVAL lwp_cond_wait(0x7CED7F70, 0x7CED7F80, 0x) = 0 pwrite(408, 0602\0\0\nC41007 f h SDD.., 49152, 0x10401C000) = 49152 pwrite(408, 0602\0\0\nC410\n f h SDD.., 49152, 0x104028000) = 49152 pwrite(408, 0602\0\0\nC410\r f h SDD.., 49152, 0x104034000) = 49152 pwrite(408, 0602\0\0\nC41010 f h SDD.., 49152, 0x10404) = 49152 pwrite(408, 0602\0\0\nC41013 f h SDD.., 49152, 0x10404C000) = 49152 pwrite(408, 0602\0\0\nC41016 f h SDD.., 49152, 0x104058000) = 49152 pwrite(408, 0602\0\0\nC41019 f h SDD.., 49152, 0x104064000) = 49152 pwrite(408, 0602\0\0\nC4101C f h SDD.., 49152, 0x10407) = 49152 pwrite(408, 0602\0\0\nC4101F f h SDD.., 49152, 0x10407C000) = 49152 pwrite(408, 0602\0\0\nC410 f h SDD.., 49152, 0x104088000) = 49152 pwrite(408, 0602\0\0\nC410 % f h SDD.., 49152, 0x104094000) = 49152 pwrite(408, 0602\0\0\nC410 ( f h SDD.., 49152, 0x1040A) = 49152 pwrite(408, 0602\0\0\nC410 + f h SDD.., 49152, 0x1040AC000) = 49152 pwrite(408, 0602\0\0\nC410 . f h SDD.., 49152, 0x1040B8000) = 49152 pwrite(408, 0602\0\0\nC410 1 f h SDD.., 49152, 0x1040C4000) = 49152 pwrite(408, 0602\0\0\nC410 4 f h SDD.., 49152, 0x1040D) =
RE: performance issues on sun
I did this and its taking the same amount of time. The difference this time is that it does not do the KAIO call. But the time has not improved. Its still doing pwrite calls. TIA Babu John Kanagaraj [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ds.com cc: Sent by: Subject: RE: performance issues on sun [EMAIL PROTECTED] 02/25/03 01:04 PM Please respond to ORACLE-L Babu, I think it is trying to do a KAIO call and failing. Then it attempts a synchronous PWRITE call. But our SAs are not able to help us to confirm this. Have any of you seen this issue? I think you have hit the nail on the head. By default, the Oracle port on Solaris sets 'disk_async_io' to TRUE. Set this to FALSE by introducing such an entry in init.ora. Let us know if tihis solves your issue... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj 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 transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS_STATS
I think since DBMS_STATS also gathers histograms its taking more time Babu Tim Gorman [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: Re: DBMS_STATS [EMAIL PROTECTED] 02/25/03 02:59 PM Please respond to ORACLE-L Could it have to do with the fact that ANALYZE is running against a different partition than DBMS_STATS? - Original Message - From: Terrian, Tom (Contractor) (DAASC) To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 25, 2003 11:12 AM Subject: DBMS_STATS I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster. Runs in 45 seconds: analyze table log_trans partition (log_trans_20030104) estimate statistics sample 5 percent; Takes over 2 hours: execute dbms_stats.gather_table_stats(ownname = 'LDGADMIN', - tabname = 'LOG_TRANS', - partname = 'LOG_TRANS_20030102', - estimate_percent = 5); Am I missing something? Aren't both commands the same? Thanks, Tom _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: File Table Overflow on Oracle DB Server
Here is Kirti's reply to it (long time back in June). I think it was to you that time also... Babu Vivek, You are right, this is an OS related issue, but a DBA must be aware of why it happens ;) Error 23 means 'File Table Overflow' and it is generated when the system wide limit for the number of simultaneously open files is exceeded. It is controlled by a kernel parameter 'nfile'. which defaults to a value arrived at by a formula that uses 'maxusers' (and a couple of other) kernel parameters. You can check the values set for 'maxusers' and 'nfile' on these servers, and get your SA to increase those on the server where you had a problem starting the database. Use '/usr/sbin/kmtune -q ' command to check currently set value for 'nfile' and 'maxusers'. Read more about 'nfile' at http://docs.hp.com/hpux/onlinedocs/os/KCparam.Nfile.html. HTH, - Kirti VIVEK_SHARMA [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] osys.comcc: Sent by: Subject: File Table Overflow on Oracle DB Server [EMAIL PROTECTED] 02/24/03 06:28 AM Please respond to ORACLE-L We have the following query reg. an error on HP-UX ORacle DB server. We are encountering HPUX Error: 23: File table overflow' on the Oracle database server while executing stress tests for our application. We are not opening any files on the database server through the application still this error keeps coming after running the test for some duration. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: direct path read waits
John All the tablespaces are on different disks - Sorry I should have mentioned this in the original post itself... Babu John Kanagaraj john.kanagaraj@hTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ds.com cc: Sent by: Subject: RE: direct path read waits [EMAIL PROTECTED] 02/20/03 03:11 PM Please respond to ORACLE-L Your answer was buried in the question itself. If the TEMP tablespace had to contend with Tablespace C on the same 'disk' then such a result is expected. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 11:41 AM To: Multiple recipients of list ORACLE-L Subject: direct path read waits All We are doing some performance testing while moving from one server to another. I was trying to time some index rebuilds and noticed something that I cant explain. I am rebuilding an index on a 1 million row table. Lets say its on tablespace A and when I rebuild it to tablespace B it does in 33 seconds. I put it back on A and then rebuild it on tablespace C it takes 1 min 40 seconds. The only change here is the target tablespace. When I set 10046 level 12 and counted time waited (ela column) From A - B (33 seconds) sum of elapsed in DIRECT PATH READ = 394 ( i think this is cs) From A - C (1 min 40 sec) sum of elapsed in DIRECT PATH READ = 6251 The P1 of all of these waits point to the same file (#4 part of TEMP tablespace) Why should the change in the target tablespace affect the time taken to read from the TEMP tablespace? TIA Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: direct path read waits
We actually had lengthy discussions with our SAs and convinced them that we need different mountpoints on different disks. We have our SA's guarantee that no physical disk is used by the two mountpoints... Will try to get a sar -d output from them.. Babu John Kanagaraj john.kanagaraj@hTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ds.com cc: Sent by: Subject: RE: direct path read waits [EMAIL PROTECTED] 02/20/03 04:45 PM Please respond to ORACLE-L Babu, You: All the tablespaces are on different disks - Sorry I should have mentioned this in the original post itself... Me: Your answer was buried in the question itself. If the TEMP tablespace had to contend with Tablespace C on the same 'disk' then such a result is expected. Note that I enclosed the 'disk' above within quotes. Different filesystems and mount points does not necessarily mean much in these days where a single storage array may be shared among multiple servers. As long as you are not using JBODs, i.e. you are on a SAN/NAS, there is no physical guarantee that the disks are where they purport to be. Can your SA verify that these 'disks' are actually different? A 'sar -d' during that period may reveal some interesting results. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj 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 transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: direct path read waits
Yes.. I did it multiple times... With same results though :-( Babu Henry Poras [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] edu cc: Sent by: Subject: RE: direct path read waits [EMAIL PROTECTED] 02/20/03 04:38 PM Please respond to ORACLE-L Babu, Did you run each scenario more than once to make sure it is not an anomaly? Henry -Original Message- [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 2:41 PM To: Multiple recipients of list ORACLE-L All We are doing some performance testing while moving from one server to another. I was trying to time some index rebuilds and noticed something that I cant explain. I am rebuilding an index on a 1 million row table. Lets say its on tablespace A and when I rebuild it to tablespace B it does in 33 seconds. I put it back on A and then rebuild it on tablespace C it takes 1 min 40 seconds. The only change here is the target tablespace. When I set 10046 level 12 and counted time waited (ela column) From A - B (33 seconds) sum of elapsed in DIRECT PATH READ = 394 ( i think this is cs) From A - C (1 min 40 sec) sum of elapsed in DIRECT PATH READ = 6251 The P1 of all of these waits point to the same file (#4 part of TEMP tablespace) Why should the change in the target tablespace affect the time taken to read from the TEMP tablespace? TIA Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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 transmission and any attachments to it are intended
max block size on sun solaris
Hi Is anyone running ORacle on Sun solaris with db_block_size 16K? We are getting an error while creating a 32K block size database on Sun and Oracle says 16K is the max on Sun solaris.. Thanks a lot... Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: max block size on sun solaris
I forgot to mention that the Oracle version is 8.1.7.4 TIA Babu babu.nagarajan@Cu mmins.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: max block size on sun solaris 02/13/03 10:03 AM Please respond to ORACLE-L Hi Is anyone running ORacle on Sun solaris with db_block_size 16K? We are getting an error while creating a 32K block size database on Sun and Oracle says 16K is the max on Sun solaris.. Thanks a lot... Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HyperRoll Experience (http://www.hyperroll.com)
All Have any of you worked with this product that is supposed to improve the performance of a RDBMS or a OLAP database... Damagement heard about this product form somewhere and wants us to investigate... Any feedback is appreciated.. TIA Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQLplus question unusual behavior
Just a thought - is facility a table or is it some synonym/view pointing somewhere else.. Babu |-+--- | | John Shaw | | | John.Shaw@correctio| | | nscorp.com | | | Sent by:| | | [EMAIL PROTECTED]| | | | | | | | | 01/20/03 10:30 AM | | | Please respond to | | | ORACLE-L| | | | |-+--- ---| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: SQLplus question unusual behavior | ---| I am trying to update a small table from a remote table with sqlplus 9.2.0.2 . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I suffering from a severe lack of caffine or is this really odd? SQL select count(*) from facility; COUNT(*) -- 0 SQL insert into facility (select * from facility@dev); 233 rows created. SQL select count(*) from facility; COUNT(*) -- 0 SQL commit; Commit complete. SQL select count(*) from facility; COUNT(*) -- 0 _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database tracking
A more comprehensive solution would be statspack. A simpler solution would be to get the sum of wait time (not counting the idle ones) . it could provide you with some measure of database performance... You need to arrive at a baseline wait time as being normal for your database and any deviation from that could mean some change in performance... Babu Terrian, Tom (Contractor) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] (DAASC) cc: [EMAIL PROTECTED]Subject: Database tracking a.mil Sent by: [EMAIL PROTECTED] 01/15/2003 12:53 PM Please respond to ORACLE-L All, I would like to track the performance of my production databases by running the same SQL statement against each database every 5 minutes or so and recording the results. For example: sql set timing on; sql select count(*) from dba_tables; That was I would know if they are getting faster or slower over time. As anyone already done this? Would there be a good SQL statement to use? Thanks, Tom Terrian _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: email out of oracle
$ oerr ora 29540 29540, 0, class %s does not exist // *Cause: Java method execution failed to find a class with the indicated name. // *Action: Correct the name or add the missing Java class. Looks like you are missing some Java Class... Do you actually get the email it sends? Also if you get the SQLERRM you might get the name of the class Babu Leonard, George george.leonard@fTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] arnell.com cc: Sent by: Subject: email out of oracle [EMAIL PROTECTED] 01/07/03 11:13 AM Please respond to ORACLE-L Hi there Trying to email out from Oracle. Utl_smtp is installed, executing procedure currently as a DBA. This sun Machine does send email notifications out via the crontab to me so I know I can send email via the exchange smtp server. Problem, Email packages execute, if I do a print I see code SQL print NP -- -29540 Package executed with following command: var np number; exec send_mail('[EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'testmsg', :np); Below is the code of the send_mail package, can anyone see the problem or know what this error code means. Thx George System Oracle 8.1.6.3 EE 32 Bit Solaris 2.6 -- -- Sending email out of Oracle using a stored procedure. -- Create or replace PROCEDURE send_mail (senderIN VARCHAR2, recipient IN VARCHAR2, message IN VARCHAR2, nStatus OUT NUMBER) IS mailhostVARCHAR2(30) := '90.1.1.100'; mail_conn utl_smtp.connection; BEGIN nStatus := 0; mail_conn := utl_smtp.open_connection(mailhost, 25); utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn, sender); utl_smtp.rcpt(mail_conn, recipient); utl_smtp.data(mail_conn, message); utl_smtp.quit(mail_conn); EXCEPTION WHEN OTHERS THEN nStatus := SQLCODE; END send_mail; / George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Sent: 07 January 2003 14:09 PM To: Multiple recipients of list ORACLE-L I read it and love it. The only thing I was wondering about is the fact, that he uses tcl/tk, which I found most people don't use anymore. Nice surprise. I wasn't quite sure wether oraora was looking for books that gives more of a general overview of books that delve into the depth of unix internals. Anyway, here is my favorite on Unix internals (hence, the name of the book ;): UNIX Internals: The New Frontiers by Uresh Vahalia Eventhough it was published in 1995, it gives you a very good understanding about how things really work and why they work the way they do. Regards, Stefan -Ursprüngliche Nachricht- Von: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 6. Januar
Re: Cant install statspack !
I remember seing a script on Steve Adam's site that will delete the views created so that STATSPACK can install correctly Babu Barbara Baker barbarabbaker@yaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hoo.com cc: Sent by: Subject: Re: Cant install statspack ! [EMAIL PROTECTED] 01/07/03 01:37 PM Please respond to ORACLE-L Bob: I have a slightly different version. My spcreate.sql involkes 3 scripts: @@spcusr, @@spctab,@@spcpkg. The problem that I had was that spcusr was creating some x_ views that already existed in the database (perhaps from Steve Adams' script). When the spcusr script encounters the errors, it quits and does not proceed with the remainder of the creation. I had to modify the script and take out all the references to the x_ views (or delete them, I don't remember which) in order to get a clean install. You should have the equivalent of an spdrop. If so you can run it and start over, but this will not remove the x_ views and synonyms. (Also make sure you're not using svrmgrl. statspack does not like svrmgrl) Good luck! Barb Bob Metelsky [EMAIL PROTECTED] wrote: Hello All I seem to be missing something very basic as no matter what I do I cant get statspack to install This is 8.16 on WIN2kpro I downloaded the newest version of stataspack and placed it into %oracle_home%\rdbms\admin C:\Oracle\Ora81\RDBMS\ADMINdir stats* 02/08/2000 07:36p 1,805 statsauto.sql 02/08/2000 07:36p 891 statscauto.sql 12/30/1999 02:13p 1,832 statscbps.sql 02/08/2000 07:36p 882 statscre.sql 02/08/2000 07:36p 28,088 statsctab.sql 02/08/2000 07:36p 27,879 statsctaba.sql 02/08/2000 07:36p 5,098 statscusr.sql 02/08/2000 07:36p 4,384 statscusra.sql 02/08/2000 07:36p 829 statsdrp.sql 02/08/2000 07:36p 3,344 statsdtab.sql 02/08/2000 07:36p 1,136 statsdusr.sql 02/08/2000 07:34p 28,516 statspack.doc 02/08/2000 07:36p 51,400 statspack.sql 02/08/2000 07:36p 48,205 statsrep.sql 01/19/2000 06:53p 52,610 sta! tsrep80.sql 02/08/2000 07:36p 579 statsuexp.par 16 File(s) 257,478 bytes I log onto the db sqlplusw internal/pw@instance SQL@%oracle_home%\rdbms\admin\statscre.sql the script seems to create the user.. but then blinks out. Apparently its soupposed to generate .lis files but there are no such files I tried to spool a log file but It only captures the first line... as the script blinks out if I try to SQL execute statspack.snap I get PLS-00201: identifier 'STATSPACK.SNAP' must be declared I try to prefix it with perfstat. or sys. but no joy what can I be doing wrong?? Ive tried to hack the scripts(so they would stay up) but there are so many variables that it dosnt seem practical Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://w! ww.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
Re: Cant install statspack !
I think the SQL_PATH is not pointing to $ORACLE_HOME/rdbms/admin - so its unable to find the scripts... Open a DOS window, cd to the folder and try running using sqlplus and not sqlplusw.. Or edit the SQL_PATH in yr registry.. Or edit the STATSCRE.SQL to include the full path Babu Bob Metelsky bmetelsky@cps92.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: Cant install statspack ! [EMAIL PROTECTED] 01/07/03 01:04 PM Please respond to ORACLE-L Hello All I seem to be missing something very basic as no matter what I do I cant get statspack to install This is 8.16 on WIN2kpro I downloaded the newest version of stataspack and placed it into %oracle_home%\rdbms\admin C:\Oracle\Ora81\RDBMS\ADMINdir stats* 02/08/2000 07:36p 1,805 statsauto.sql 02/08/2000 07:36p 891 statscauto.sql 12/30/1999 02:13p 1,832 statscbps.sql 02/08/2000 07:36p 882 statscre.sql 02/08/2000 07:36p 28,088 statsctab.sql 02/08/2000 07:36p 27,879 statsctaba.sql 02/08/2000 07:36p 5,098 statscusr.sql 02/08/2000 07:36p 4,384 statscusra.sql 02/08/2000 07:36p 829 statsdrp.sql 02/08/2000 07:36p 3,344 statsdtab.sql 02/08/2000 07:36p 1,136 statsdusr.sql 02/08/2000 07:34p 28,516 statspack.doc 02/08/2000 07:36p 51,400 statspack.sql 02/08/2000 07:36p 48,205 statsrep.sql 01/19/2000 06:53p 52,610 statsrep80.sql 02/08/2000 07:36p 579 statsuexp.par 16 File(s)257,478 bytes I log onto the db sqlplusw internal/pw@instance SQL@%oracle_home%\rdbms\admin\statscre.sql the script seems to create the user.. but then blinks out. Apparently its soupposed to generate .lis files but there are no such files I tried to spool a log file but It only captures the first line... as the script blinks out if I try to SQL execute statspack.snap I get PLS-00201: identifier 'STATSPACK.SNAP' must be declared I try to prefix it with perfstat. or sys. but no joy what can I be doing wrong?? Ive tried to hack the scripts(so they would stay up) but there are so many variables that it dosnt seem practical Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating,
RE: Prevent FTS
Read Tim Gorman's The Search For Intelligent Life in the Cost-Based Optimizer. I think its on his website - http://www.evdbt.com/papers.htm Babu manoj.gurnani@orb itech.co.in To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Prevent FTS 01/06/03 02:49 PM Please respond to ORACLE-L What is the significance of parameter OPTIMIZER_INDEX_COST_ADJ ? When I tried to change the value the explain plan has changed . alter session set OPTIMIZER_INDEX_COST_ADJ = 10 table access for Z was by index rowid alter session set OPTIMIZER_INDEX_COST_ADJ = 100 table access for Z was full How can I make effective use of this parameter . If i dont want to use this in alter session,can this value be set elsewhere. what is the difference between setting this parameter to some other value than default compared to using hints in sql stmt. I've tried some hints like rowid,index but it did not work for the join stmt as it still used the FTS of Z before I tried to change the above parameter to 10. -Original Message- Sent: Monday, January 06, 2003 11:03 PM To: '[EMAIL PROTECTED]' Hi All, I've 3 tables table x,y,z pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is (col_1,col_2) where clause is : where x.col_1 = y.col_1 and x.col_2 = y.col_2 and x.col_1 = z.col_1 and x.col_2 = z.col_2 and y.col_1 = z.col_1 and y.col_2 = z.col_2 and x.col_3 in ('val1','val2','val3') and. .. Explain plan shows that there is a FTS of table z . what can be the reason for this and how to prevent this. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: Full table scan error
You have a outer join in yr history table. Also you have a IN condition for the history table for which the CBO might think a FTS might be cheaper.. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 03, 2003 7:19 AM Hi List, I have the below query whose explain plan is showing that it is doing full table scan on Historie table: select F1.AMTLICHESKENNZEICHEN AMTLICHESKENNZEICHEN,F1.OID,F1.VERKAUFSBEZEICHNUNG,B1.FAHRZEUGARTTEXT,B1.FAH RZEUGHERSTELLERTEXT,B1.FAHRZEUGTYPTEXT,B1.FIN,B1.VERKAUFSBEZEICHNUNG,H1.AUFT RAGSPOSITIONSNR,H1.DATUMSTR,H1.OID,H1.PRODUKT,H1.VORGANGSNUMMER,'Stamm' SOURCE from ZPAB.FAHRZEUG F1 , ZPAB.FZGBRIEF B1 , ZPAB.HISTORIE H1 where F1.FZGBRIEF = B1.OID AND F1.OID = H1.MYTECHOBJEKT(+) AND ((H1.produkt, TO_DATE(H1.DATUMSTR,'-MM-DD')) IN (select ZPAB.HISTORIE.produkt, TO_DATE(MAX(ZPAB.historie.DATUMSTR),'-mm-dd') from ZPAB.historie, ZPAB.FAHRZEUG WHERE ZPAB.FAHRZEUG.OID = ZPAB.historie.MYTECHOBJEKT AND ZPAB.FAHRZEUG.OID = F1.OID AND ZPAB.historie.PRODUKT IN('HU','AU','SP','HUPlus','GGVS','P193','P21','UVVFahrzeuganbau','Ersatzpla kette','SOL') group by ZPAB.historie.produkt) OR H1.PRODUKT IN ('StandardGutachten','SchadenGutachten','BewertungZustandspruefung','MagBewe rtungZustandspruefung','Transportschadenbericht','Reparaturpruefung','Rechnu ngspruefungsbericht','Reparaturpruefungsbericht','FzgSchadengutachten','Hage lschadenbericht','Massenschadenbericht','Kalkulationsbericht','Schadenberich t','Bericht','DekraSiegel','NfzSchadenGutachten','HypoWBWGutachten','MagGuta chten','MagBewertung','Bewertung') OR F1.OID NOT IN (SELECT ZPAB.FAHRZEUG.OID FROM ZPAB.FAHRZEUG,ZPAB.HISTORIE WHERE ZPAB.FAHRZEUG.OID = ZPAB.historie.MYTECHOBJEKT)) AND (F1.AMTLICHESKENNZEICHEN LIKE 'DD%')AND rownum =10 and for HISTORIE, it is showing TABLE ACCESS FULL. I have created indexes on produkt and mytechobjekt columns of historie table. Still I am getting full table scan errors. I am sending herewith the snapshot of the explain plan as seen in spotlight. Could you please advise me as to how do I eradicate the full table access error on Historie table? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath Doc1.doc WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babu Nagarajan 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: Centralized StatsPack Repository
Title: RE: Centralized StatsPack Repository Raj I did this sometime back but later on somehow this went on to the backburner.. (I also had half-developed XL based interface to the central statspack data) In the central repository create the set of tables that statspack uses to store data under user "central". Create individual schema's with different instance names (that you want monitored). Under each of the schemas 1) create a db link with a dba user to the database that this schema monitors 2) create private synonyms for all of the v$, dba* views that statspack queries usingdb links created above (create synonym v$session for sys.v$session@target_db) 3) create private synonyms for all of the statspack tables to point to the "central" schema Now when you schedule statspack.snap it will read from the target db and insert data into the "central" user... Babu - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, January 03, 2003 10:08 AM Subject: RE: Centralized StatsPack Repository Hmmm... FAGC ?? Jared, I am stumped ... I can't put these 2 2 together. I was planning on a new instance called "dbmon". One schema for each production database instance. Statspack will be installed for each schema and other monitoring scripts that we use internally. I am thinking of best ways to propogate datasets from individual databases to this central db. Could you explain more about (your idea on) how FAGC would be useful?? Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 8:03 PM To: [EMAIL PROTECTED] Cc: Jamadagni, Rajendra Subject: RE: Centralized StatsPack Repository Importance: High Have you considered FGAC? ( fine grained access control ) I haven't tried it, but it seems like a good candidate for centralizing stats pack data with as little code as possible. Jared
Re: ORA-1410 Silliness
Title: ORA-1410 Silliness Lisa I dont recollect exactly but I think I have seen this happen when you start getting too close to the max_open_cursor limit... something like Oracle cant open a cursor as it is at the max limit and a fetch call might be issued.. Checkyr max_open_cursor limit and also check the v$open_cursor when the error happens... Babu - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday, January 02, 2003 8:14 AM Subject: RE: ORA-1410 Silliness Hi Waleed, No. This is the name of the package. Thanks Lisa -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness I see "ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary key index for a table? If yes, then it may need to be rebuilt. Regards, waleed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 Has anyone seen this error before? I run into this error periodically during data loads. I have done the following to search for the root of the problem: 1. No code references ROWID. Deletes are never applied to this table. 2. No inline views in any of the code. 3. Ran dbv on all datafiles while database was down. No problems identified. 4. Ran analyze table table name validate structure cascade on all recent partitions. No rows found in INVALID_ROWS table. 5. Was able to export the entire table without any problem. I can't easily drop the indexes and recreate them. This is a very large table - ~25GB, 38 million rows. I also can't easily export/drop/recreate/import. Usually when this happens I can re-fire the load and it will complete, no problem. It's a big annoyance and it seems like every time I take a day off it happens. Any ideas, suggestions, or thoughts are appreciated. Thanks everyone. Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
Re: Oracle 8i (8.1.7) for Windows XP Home Edition
Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition i was able to install 8.1.5 sometime back.. but it made my xp terribly slow.. some jdk issues, i guess.. babu - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 11:49 AM Subject: RE: Oracle 8i (8.1.7) for Windows XP Home Edition Didn't try 8.1.7, but 9i went in just fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:54 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 8i (8.1.7) for Windows XP Home Edition Quick question, has anyone managed to sucessfully install 8.1.7 on Windows XP Home Edition. I have read on metalink that this is not officially supported by Oracle, but wanted to know if anyone has managed to install it for test purposes on their home/work PC's tia Zabair -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Shared Pool Size
Statspack is installed under the username PERFSTAT. You should be able to tell if such user exists by quering the dba_users table. There are two good articles on the Oracle Magazine on how to install and use Statspack. Search the technet.oracle.com site Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 9:59 PM Dennis, The Toad provides Waits... but there's a lot of events like buffer busy waits,control file parallel write,control file sequential read,. Can you point me to the correct direction or suggest some informations about how to analyse those events? For STATSPACK, how to tell whether it's installed? and which scripts should be run in order to use it? Wellyes, i'm working for a taiwanese company, they insist to include Chinese name in signature. sorry for the inconvenience cause. and thanks for the help. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 02, 2002 9:38 PM Shuan - Bumping up the memory for shared pool and database buffers may well turn out to be the answer, but before you just jump in and make the changes and hope for the best, why not dig into the root causes of the slowness first? Specifically, collect information on the top wait events. I'm not familiar with Toad, but perhaps it can provide these. My personal favorite is STATSPACK, which comes with Oracle, but you'll have to install it. Or you can just directly query the V$ views. If the wait statistics confirm the need to increase these buffers, once you make the change you can measure these statistics again and confirm that you are making a positive improvement. Also, does your signature have some sort of foreign language font? When I opened your email I got an error message about that. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: Function-based Index
why would you want to create function based index on a column that you are not using in the where clause. for your sql statement a index on cnfr_no would work great... babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 4:09 PM I have the following statement that I would like to create a function-based index for: SELECT MIN(tran_dt) FROM ach_tran WHERE cnfr_no = :b1 I'd like the index to include columns cnfr_no and tran_dt (in that order). The examples I've seen are just single-column indexes. Is it possible to have this additional column in a function-based index that is not involved in the actual function? If yes, what would the index creation statement look like? This is version 9.2.0.1 on Sun Solaris 2.6. Thanks in advance for any assistance. Cherie Machler Gelco DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: Common PL/SQL package to truncate tables
Title: Common PL/SQL package to truncate tables Of the top of my head, there is a way where you can run a procedure under the invoker's rights rather than the procedure owner's rights. if u create it that way, you need not bother checking if the user who is calling the procedure has the rights to truncate the table - oracle will do it for you babu - Original Message - From: Thomas Jeff To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 11, 2002 4:23 PM Subject: Common PL/SQL package to truncate tables We have a DSS database containing numerous datamarts, each stored in it's own schema. Each datamart schema has a corresponding OPS$ batch account, which does the ETL work. DML privs on all tables within a schema are granted to a {schema}_LOAD_ROLE, which in turn is granted to the pertinent batch account. Previously, each schema has it's own copy of a common utilty package, which provided among other things, a routine to truncate a specified table. The batch account would call this routine to perform all truncates. As the number of datamarts grew it started becoming a pain to maintain and compile the same package in multiple schemas. So, the idea is to use a database-wide common utility package which would be compiled under a DBA ID, with execute granted to the OPS$ batch accounts. This package's truncate routine would verify a truncate request by checking the calling USER against DBA_ROLE_PRIVS to ensure it had the requisite {schema}_LOAD_ROLE for the {schema}.table_name passed as a parameter. Any security holes or caveats with this idea? Or maybe a more elegant way to accomplish this? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages'
limiting temp space per user
All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: limiting temp space per user
Thats what I have now. But these adhoc reports keep running out of temp space and and ends up paging me :-) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:48 PM The way we do it is that create two temporary tablespaces. Use one for the production applicationa and other for adhoc users so that adhoc users do not mess up the production. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:04 AM SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: Utl_file and OPENVMS
); Utl_File.Put (L_Par_File_Hand,'Log='||P_Load_Log_File_Dir||'/'||P_Current_Table_Name||to_ char(P_Run_Date,'mmdd')||'.LOG'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Bad='||P_Load_Bad_File_Dir||'/'||P_Current_Table_Name||to_ char(P_Run_Date,'mmdd')||'.BAD'); Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Discard='||P_Load_Discard_File_Dir||'/'||P_Current_Table_N ame||to_char(P_Run_Date,'mmdd')||'.DSC'); as Utl_File.New_Line(L_Par_File_Hand); Utl_File.Put (L_Par_File_Hand,'Data='||P_Load_Data_File_Dir||'/'||P_Current_Table_Name||' /'|| P_Current_Table_Name||to_char(P_Run_Date,'mmdd')||'.DAT'); -- Close the file after printing. Utl_File.Fclose(L_Par_File_Hand); Exception When Others then Dbms_Output.Put_line(to_char(sqlcode)||'-'||SQLERRM); End; Thanks, Any assistance would be appreciated. I am just getting in to the OPENVMS OS. Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: Strange performance problem
I have seen something like this in the past and it was because there were two tables - named the same in two different schemas (public synonym, private synonym and all that mess).. Do you know whether this could be the same case as yours? Also check to see if the explain plan differs when u run it under different schemas. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 1:33 PM I got a call from a customer earlier. He said that he was trying to run a query and it was taking way too long. He ran the same query last Friday and it came back in seconds. I looked at it in OEM and noticed that two of the tables were being accessed by full table scans. These tables have 22,000+ and 24,000+ rows each. I took the sql from OEM and ran it in a svrmgrl session (connected internal), and it came back in seconds. His still hadn't come back. To further complicate things, I connected as the owner of the tables (the same user he was using) and ran the query again. This time, I ended up killing it after 10 minutes. I'm confused as to what can cause such a difference in performance from sys to another user. The server did crash sometime over the weekend. He said that it was fine before the crash. I ran a dbverify on all of the data files and came up with nothing. The vitals are: Oracle 8.1.6.0.0 Digital Unix V4.0F (Rev. 1229) Unfortunately, upgrading Oracle isn't an option because the processor is too old. Oracle won't support it on any versions higher than 8.1.6. A patchset may be possible, though. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: Strange performance problem
I have seen something like this in the past and it was because there were two tables - named the same in two different schemas (public synonym, private synonym and all that mess).. Do you know whether this could be the same case as yours? Also check to see if the explain plan differs when u run it under different schemas. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 1:33 PM I got a call from a customer earlier. He said that he was trying to run a query and it was taking way too long. He ran the same query last Friday and it came back in seconds. I looked at it in OEM and noticed that two of the tables were being accessed by full table scans. These tables have 22,000+ and 24,000+ rows each. I took the sql from OEM and ran it in a svrmgrl session (connected internal), and it came back in seconds. His still hadn't come back. To further complicate things, I connected as the owner of the tables (the same user he was using) and ran the query again. This time, I ended up killing it after 10 minutes. I'm confused as to what can cause such a difference in performance from sys to another user. The server did crash sometime over the weekend. He said that it was fine before the crash. I ran a dbverify on all of the data files and came up with nothing. The vitals are: Oracle 8.1.6.0.0 Digital Unix V4.0F (Rev. 1229) Unfortunately, upgrading Oracle isn't an option because the processor is too old. Oracle won't support it on any versions higher than 8.1.6. A patchset may be possible, though. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: Strange performance problem
I have seen something like this in the past and it was because there were two tables - named the same in two different schemas (public synonym, private synonym and all that mess).. Do you know whether this could be the same case as yours? Also check to see if the explain plan differs when u run it under different schemas. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 1:33 PM I got a call from a customer earlier. He said that he was trying to run a query and it was taking way too long. He ran the same query last Friday and it came back in seconds. I looked at it in OEM and noticed that two of the tables were being accessed by full table scans. These tables have 22,000+ and 24,000+ rows each. I took the sql from OEM and ran it in a svrmgrl session (connected internal), and it came back in seconds. His still hadn't come back. To further complicate things, I connected as the owner of the tables (the same user he was using) and ran the query again. This time, I ended up killing it after 10 minutes. I'm confused as to what can cause such a difference in performance from sys to another user. The server did crash sometime over the weekend. He said that it was fine before the crash. I ran a dbverify on all of the data files and came up with nothing. The vitals are: Oracle 8.1.6.0.0 Digital Unix V4.0F (Rev. 1229) Unfortunately, upgrading Oracle isn't an option because the processor is too old. Oracle won't support it on any versions higher than 8.1.6. A patchset may be possible, though. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: To_Char Problem
Why would you want to do that - convert two dates into a char and then compare them ? This is not a problem but it is how char comparisions work. They are compared char by char to see which one is greater on the ASCII chart. See this : SQL select '1' from dual where '3' '10'; ' - 1 Babu karthikeyan S [EMAIL PROTECTED]@fatcity.com on 08/14/2002 11:53:53 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi All, I am using the to_char function in the following query. But it treats the date '31/12/2001' as greater than '01/01/2002'. Is there any solution to fix this problem? select distinct(a.default_type_id), a.new_val from amend_default_value a, amend_default_value b where a.effective_from = sysdate and a.effective_to= sysdate and a.group_id = '942' and a.default_type_id = b.default_type_id and to_char(a.updated_date,'dd/mm/ hh:mi:ss') = ( select max(to_char(updated_date,'dd/mm/ hh:mi:ss')) from amend_default_value c where c.effective_from = sysdate and c.effective_to= sysdate and c.group_id = '942' and c.default_type_id = b.default_type_id); Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SAN
Tim, Jared and Kirti Jared, Kirti : Thanks a lot for your input. and yes, I read the Sane SAN paper. Tim : Many thanks to you for pointing out some of the big misassumptions I had made. I have corrected most of the stuff you had mentioned except for these .* I'm less clear on whether SANs themselves perform read-ahead and the conditions under which they do so. I'm pretty sure that they are smarter about it than what you describe; usually read-ahead mechanisms are triggered by detected patterns of usage, not algorithms as simple as described... Will the smarter algorithm look inside the contents of a file before reading it? If it does not, then how will it be able to intelligently read ahead what data Oracle wants from inside its datafile? If it does, how does it decipher the Oracle's way of storage? * your example about read-ahead conflicts makes some invalid assumptions, namely about space being allocated in blocks not extents (when does *that* ever happen?) and about read-ahead being set to 3 blocks (again, when does *that* ever happen?). It does not happen. However I am going to be talking to a bunch of non-Oracle folks and management so I want to keep it as simple as possible. Altogether, empirical evidence (i.e. many successful SAN implementations under Oracle over several years) does not lend credence to your basic assertion that SAN and Oracle don't go well together. It is a fact that they do... I am not trying to make a statement SAN and Oracle dont go well together. I am trying to convince my management that buying a SAN does not mean that we never need to worry about IO any more. Even a SAN needs to be configured. Currently they are under the impression that there are no IO problems but my database IO waits are 50% of the total response time. All my index, table data are scattered all over the disks - many on the same disk and the answer I get is No, we are not tasking the SAN at all. There are no IO issues Thanks a lot Babu Tim Gorman [EMAIL PROTECTED]@fatcity.com on 08/13/2002 07:58:29 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Babu, Is it possible that you are confusing the term SAN with the term NAS? As I read through your email, I couldn't help thinking that you discussing network-attached storage rather than storage-area networks. If so, some of my comments below might change slightly, but not much... --- Most of your major assumptions are correct, but there are important errors... * DBWR only does RW, never RR or SR. Mostly Oracle server processes do RR and SR, but ARCH also does SR, as do backup processes (whatever they are); everyone always forgets to add backup processes to the mix... * SW is characteristic of LGWR and ARCH, but also of processes performing sorting (i.e. direct writes wait-event). I think you'll agree that databases generating a lot of redo (and archived redo) and performing lots of sorting are not necessarily misconfigured. The amount of redo generated is really a characteristic of the application itself, not the database configuration. High amounts of sorting can possibly be tuned, but that too is more a characteristic of the application and users usage of it than database configuration... * I'm not sure what your conclusions regarding RAID5 chunks or RAID0 stripes are, but I suspect they are incorrect. Oracle DB_BLOCK_SIZE should not come close to matching RAID5 chunksize of RAID0 stripesize; even (DB_BLOCK_SIZE * DB_FILE_MULTIBLOCK_READ_COUNT), which denotes the largest I/O requests (for full-table scans) generated by Oracle should be much smaller than RAID5 chunksize or RAID0 stripesize, for most databases. So, whatever conclusions you are drawing from that point about sizes is likely incorrect... * I'm less clear on whether SANs themselves perform read-ahead and the conditions under which they do so. I'm pretty sure that they are smarter about it than what you describe; usually read-ahead mechanisms are triggered by detected patterns of usage, not algorithms as simple as described... Anyway, based on your mistaken assumptions, your list of conflicts between SAN and Oracle are quite mistaken as well... * the difference between the stripe width and DB_BLOCK_SIZE is not excess I/O at the SAN level; the disk drives do not necessary read the entire stripe or chunk; they merely *store* data in those extents on the device. They don't have to read/write in those increments... * your example about read-ahead conflicts makes some invalid assumptions, namely about space being allocated in blocks not extents (when does *that* ever happen?) and about read-ahead being set to 3 blocks (again, when does *that* ever happen?). You do have some of the basic ideas right, but please remember that your assumptions may be overly simplistic or just unlikely. Moreover, remember that some of your basic
Re: SAN
But inside a Oracle datafile a table may not lie in contigious blocks. so I you are doing a full table scan 2 extents can lie next to each other than then the remaining 2 can sit at the end of the datafile. Will the non-Oracle process be able to decipher this and do a read ahead of those two extents? Probably not... Babu Yechiel Adar [EMAIL PROTECTED]@fatcity.com on 08/13/2002 01:50:15 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: You wrote: Will the smarter algorithm look inside the contents of a file before reading it? If it does not, then how will it be able to intelligently read ahead what data Oracle wants from inside its datafile? If it does, how does it decipher the Oracle's way of storage? How about using a variation of the algorithm ADABAS (database) is using for sequential user reads: 1) Return the block requested. 2) If the next block is requested in a short period read the next 5 blocks to the controller cache. 3) If those are read in order and request come for the next block read each time 10 blocks. This is just from the top of my head but will assist greatly for full table scan of big tables. Also remember that in Oracle before 9i blocks used in FTS are put at the end of lru so are great candidates to be overwritten and you will read them again and again. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 5:30 PM Tim, Jared and Kirti Jared, Kirti : Thanks a lot for your input. and yes, I read the Sane SAN paper. Tim : Many thanks to you for pointing out some of the big misassumptions I had made. I have corrected most of the stuff you had mentioned except for these .* I'm less clear on whether SANs themselves perform read-ahead and the conditions under which they do so. I'm pretty sure that they are smarter about it than what you describe; usually read-ahead mechanisms are triggered by detected patterns of usage, not algorithms as simple as described... Will the smarter algorithm look inside the contents of a file before reading it? If it does not, then how will it be able to intelligently read ahead what data Oracle wants from inside its datafile? If it does, how does it decipher the Oracle's way of storage? * your example about read-ahead conflicts makes some invalid assumptions, namely about space being allocated in blocks not extents (when does *that* ever happen?) and about read-ahead being set to 3 blocks (again, when does *that* ever happen?). It does not happen. However I am going to be talking to a bunch of non-Oracle folks and management so I want to keep it as simple as possible. Altogether, empirical evidence (i.e. many successful SAN implementations under Oracle over several years) does not lend credence to your basic assertion that SAN and Oracle don't go well together. It is a fact that they do... I am not trying to make a statement SAN and Oracle dont go well together. I am trying to convince my management that buying a SAN does not mean that we never need to worry about IO any more. Even a SAN needs to be configured. Currently they are under the impression that there are no IO problems but my database IO waits are 50% of the total response time. All my index, table data are scattered all over the disks - many on the same disk and the answer I get is No, we are not tasking the SAN at all. There are no IO issues Thanks a lot Babu Tim Gorman [EMAIL PROTECTED]@fatcity.com on 08/13/2002 07:58:29 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Babu, Is it possible that you are confusing the term SAN with the term NAS? As I read through your email, I couldn't help thinking that you discussing network-attached storage rather than storage-area networks. If so, some of my comments below might change slightly, but not much... --- Most of your major assumptions are correct, but there are important errors... * DBWR only does RW, never RR or SR. Mostly Oracle server processes do RR and SR, but ARCH also does SR, as do backup processes (whatever they are); everyone always forgets to add backup processes to the mix... * SW is characteristic of LGWR and ARCH, but also of processes performing sorting (i.e. direct writes wait-event). I think you'll agree that databases generating a lot of redo (and archived redo) and performing lots of sorting are not necessarily misconfigured. The amount of redo generated is really a characteristic of the application itself, not the database configuration. High amounts of sorting can possibly be tuned, but that too is more a characteristic of the application and users usage of it than database configuration... * I'm not sure what your
Re: set sql*trace VB/Crystal
Try to find out the sid and serial# of her session. From a dba user use exec dbms_system.set_sql_trace_in_session(sid, serial#,true); Babu Baker, Barbara [EMAIL PROTECTED]@fatcity.com on 08/12/2002 03:23:23 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: List: We have a crystal report performing badly. (No! ,you say. You're shocked!) The report has a visual basic front end. Our developer wants to set sql trace in the VB code. It's not working. When I tkprof her trace file, all that's in there is the ALTER SESSION SET SQL_TRACE TRUE command. Is there some trick here? I don't know VB at all, so I don't know how to advise her. She looked on the Microsoft site, but it was not helpful. Thanks for any help! Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SAN
All I have a meeting tomorrow where I am going to point out why SAN and Oracle does not go very well together. Here are my thoughts. Can you pick holes in this argument, modify it or suggest any changes TIA Babu SAN and Oracle ? Conflicting IO behavior * There are four types of IO in Oracle 1.Random Reads (RR) ? DBWR - Using indexes 2.Sequential Reads (SR) ? DBWR - Full table scans 3.Random Writes (RW) ? DBWR ? Writing dirty blocks 4.Sequential Writes (SW) ? LGWR, Arch ? Writing redo logs and Redo Archival + Control files * Bulk of any Oracle database's IO is done in RR, SR and RW. If SW is very high it denotes configuration problems. * SAN (or for that matter any RAID device) is configured for writing or reading large chunks at a time. The stripe size on most SANs and RAID devices are 256K or more. Compare this to the Oracle block size of 4k/8k in most databases (going upto 32K in datawarehouses) * SANs do *Read Ahead*. If one block is requested, they read more than one blocks *while at the disk* hoping that the same process will request the other blocks some time soon. Here is the conflict. * When ever Oracle does a RR, SR or RW it writes randomly and not sequentially. It will read/write a particular block at a time in case of RR and RW and 'x' blocks (where x = dbfile_multi_block_read_count) in case of SR. Therefore only during SR will Oracle use the entire stripe width. In all other cases, The difference in the stripe width and db_block_size will be excess IO. * Why *read ahead* will cause a conflict : * The internal structure of a datafile could be as follows. The file consists of 10 blocks. These are occupied by 3 tables. The blocks shown below are numbered using table_name.block_number |-+-+-+-+-+-+-+-+-+-| | | | | | | | | | | | | | 1.1 | 1.2 | 2.1 | 3.1 | 3.2 | 3.3 | 2.2 | 1.3 | 2.3 | | 3.4 | | | | | | | | | | | | | |-+-+-+-+-+-+-+-+-+-| * The first block on the datafile is the first block of table 1, second block is the second block of table 1, the third block is the first block of table 2 and so on.. (For simplicity sake, I am assuming Oracle will allocate space in blocks and not in extents) * Now assume Oracle requests the first block of table 1. Assume read ahead is set to three blocks (three blocks will be read instead of 2 blocks). In this case the SAN will read 2.1, 3.1,3.2. * The blocks 3.1 and 3.2 will be entirely useless as Oracle is never going to read it. SAN cannot tell that the block 2.2 that Oracle might possible request next is the 7th block in the datafile and so it can never *read ahead* intelligently. Why the buffer of SAN has very little impact w.r.t Oracle read performance? * Oracle has its own buffering for all IO types * DBWR reads and writes uses the DB Buffer Cache * LGWR uses the Log buffer * Db buffer Cache is managed by a LRU Algorithm (Touchcount from 9I). * Bulk of the IO done by Oracle is Logical IO (LIO) and not Physical IO (PIO). * Assume the buffer cache hit ratio is 80%. This means that only 20% of the IO calls are PIO. Only 20% of the calls ever hit the SAN's cache. Since this 20% is probably the least requested/never requested data (going by Oracle's LRU algorithm) , its quite likely that the SAN's buffers don't have this either. * Given that Oracle is going to cache even this 20% in its buffers, the next PIO call is going to be for something totally different ? which is not there in the SAN's buffer. * Couple this with the read-ahead (discussed earlier), Our SAN's buffer is now populated with lots of data that Oracle might never use a PIO to retrieve. * Thus the SAN's buffer can never really provide to Oracle the data it reads most ? Its already there in Oracle. To be fair, SAN's huge buffers will come as a boon to small databases ? where the entire database can be cached in the SAN's buffers. -- 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: Which table to check whether my SQL_TRACE is on for the user
It should be run from svrmgr Babu CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]@fatcity.com on 08/09/2002 10:53:19 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: user Hi KG, Is ORADEBUG PEEK an utility that only works in 9I ? Could I use it in the user account .ie. not sys account ? I am using Version Version 8.0.6 and it does not work for me. Please advise. Thanks. SQL ORADEBUG peek unknown command beginning ORADEBUG p... - rest of line ignored. Regds, New Bee -Original Message- From: K Gopalakrishnan [mailto: [EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 11:18 PM To: Multiple recipients of list ORACLE-L Subject:RE: Which table to check whether my SQL_TRACE is on for the user Raj: You are right. But you can find the with PGA dump or ORADEBUG PEEK.. KG -Original Message- Rajendra Sent: Thursday, August 08, 2002 6:33 AM To: Multiple recipients of list ORACLE-L user Dear 'New Bee', If I remember correctly, I read an reply by Steve Adams that this trace flag is in the PGA (??) so not possible to find. O Wise Men/Women ... please correct me if I am wrong ... Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, August 07, 2002 11:08 PM To: Multiple recipients of list ORACLE-L user Hi Dave, Thanks but the command does not work. In SQLPLUS, SQL alter SESSION SET SQL_TRACE=TRUE 2 / Session altered. SQL SHOW PARAMETER SQL_TRACE unknown SHOW option PARAMETER unknown SHOW option SQL_TRACE I am using Oracle Database 8.1.6. Any other suggestions ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Heterogenous Services
I think I am jumping into this thread a bit late. Take a look at http://www.unixodbc.com for some good info on ODBC on Unix. I am not sure where to get Oracle ODC drivers for Unix. Try installing a Unix client and see if it comes along with it... Babu Robertson Lee - lerobe [EMAIL PROTECTED]@fatcity.com on 07/31/2002 11:53:36 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Mladen, I have been told that I definitely need the odbc driver installed on my UNIX server. How do I get these from OTN, they have the odbc software for Windows but not for UNIX. (Not that I can see anyway !!) Lee -Original Message- Sent: 31 July 2002 17:29 To: Multiple recipients of list ORACLE-L If it's just a regular ODBC connection, download the driver from OTN, configure it appropriately and enjoy. No heterogeneous services needed. Heterogeneous services are needed only if you have more then one protocol on your network (like LU 6.2, TCP/IP and IPX). -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 To: Multiple recipients of list ORACLE-L And is it needed?. I am sure I have set up odbc connections between Oracle 8i databases on Unix and Access/Excel and I have never heard of Heterogeneous Services before -Original Message- Sent: 31 July 2002 13:24 To: Multiple recipients of list ORACLE-L I did a bit of research on Heterogeneous Services, apparently it lets you create ODBC connections between Oracle on UNIX and Windows apps. Can this be true? Does it actually work? What is the performance like? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) . -Original Message- Sent: Wednesday, July 31, 2002 6:48 AM To: Multiple recipients of list ORACLE-L Hi, Oracle 8.1.7.3 Tru64 5.1 MSAccess 2000 Preparing to be shot down in flames but I have been looking through some documentation and also some White Papers but for some reason I just don't get it. I need to see Access tables from an Oracle DB. The paper I am reading (from Metalink) states that I should be able to do this via Heterogeneous Services and ODBC agent but I cannot see how it all hangs together. Has anyone done this and if so could you point me in the right direction please. I don't need an idiots guide (or maybe I do) but a gentle nudge in the right direction should suffice. Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- 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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Re: Space Contention and LOG_BUFFER size
More than the number of time you are waiting for 'redo log space requests' its more important to find out how long you are waiting for that. 27 times out of a million might not be a big deal for you to tune. having said that, here is a posting by Steve Adams on this topic Q : Every day our production database has more than 10 redo log space requests. Oracle suggested that this number should be near 0. I resized the log files, and increased the log buffer to 1M. What else can I do? A : This idea of increasing the log_buffer to get space requests down to 0 is both ineffective and bad for performance. There is always a risk of space requests at log switches and a few other points when redo generation is disabled entirely. It does not matter how big your log buffer is then. You will get space request waits if you try to generate redo at that time. Also, a large log buffer is actually much worse for performance than the occasional space request, even if that is a genuine log buffer space wait. hth babu Farnsworth, Dave [EMAIL PROTECTED]@fatcity.com on 07/30/2002 12:19:02 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I am doing some performance monitoring on an 8.1.7 DB on Windoze. I ran the following query; SQL select name,value 2 from v$sysstat 3 where name = 'redo log space requests'; NAME VALUE -- redo log space requests 27 If the number of 'redo log space requests' is much over zero then I should increase the LOG_BUFFER size in my init.ora, at least that is what I get from RTFM. One question I have is that does the size of the LOG_BUFFER parameter have to be a multiple of the DB_BLOCK_SIZE parameter? I vaguely remember that it shuold be but have not found anything in TFM to verify this. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Host System Commands from PL/SQL blocks
Take a look at Doc Id 50868.1 on metalink Babu John Weatherman [EMAIL PROTECTED]@fatcity.com on 07/30/2002 02:56:37 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: OK, I checked Google and my own old mail and I know I've seen this here before, but can't find my notes, so please forgive this same old question... I need to execute a system call from within a PL/SQL block. Specifically, I am looking at starting out report request demons as part of a post startup trigger. Help? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: order by in subquery workaround
For databases 8i you need to run statsrep80.sql Babu Jack van Zanen [EMAIL PROTECTED]@fatcity.com on 07/12/2002 02:53:21 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi I have in the past seen a download for a backported statspack on I believe OTN. This would work on Oracle 8.0.5 Maybe still there Jack Baker, Barbara bbaker@denvernewspaperTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] agency.comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: order by in subquery workaround [EMAIL PROTECTED] 11-07-2002 19:38 Please respond to ORACLE-L Solaris 2.6 Oracle RDBMS v8.0.5.2.1 List: I'm trying to run a retrofit of statspack on an 8.0.5 database. (ya, I know. upgrading would actually be easier) The statspack stuff came from an 8.1.7 install I have on the same box. The spreport.sql report encounters errors in the order by clause. The problem is that you can't do an order by on a subquery before version 8.1.something-or-other I know there's some kind of work around for this. I had something to do with a hint. Even after 3 cups of coffee, I can't remember what it is. Can anyone help? Thanks! Barb here are the errors: Shared Pool StatisticsBegin End -- -- Memory Usage %: 75.99 70.05 % SQL with executions1: 21.95 48.60 % Memory for SQL w/exec1: 11.28 21.84 order by time desc, waits desc * ERROR at line 24: ORA-00907: missing right parenthesis pmon timer 1,184 1,177 355,304 3001 0.2 - order by (e.buffer_gets - nvl(b.buffer_gets,0)) desc, e.hash_value, st.piece * ERROR at line 41: ORA-00907: missing right parenthesis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.
oratab file
All On one of the database servers we have, the oratab file has been changed to include a :parameter after each entry and that parameter is used to determine whether the database is supposed to be shutdown at a certain time. It kind of struck me as a odd way to do this... This created problems for me when I was trying to get OEM discover this database and I had to remove this parameter to get OEM discover the database. So the question is : Have you seen this some where else? Is this (editing of oratab)supported? PS : This is not my database. I had to look into it for some other reason and I discovered this. TIA Babu
list of events
All I know this has been mentioned on this list before but I forget... Which is the script in $ORACLE_HOME/rdbms/admin folder thatcontains the list of all events? TIA Babu
Re: list of events
Suzy Thanks a lot.. .This was the one I was looking for... I thought it was under admin and was desperately grepping the files there :-) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 5:08 PM $ORACLE_HOME/rdbms/mesg/oraus.msg does list events, for example: 10046, 0, enable SQL statement timing // *Cause: // *Action: Most events are in the range of 1 to 10999. Suzy [EMAIL PROTECTED] wrote: actually that's the list of error messages, not events and it's not under the admin directory in any case the path to the error messages is: $ORACLE_HOME/rdbms/mesg/roaus.msg |+--- || | || | || Rajendra.Jamadagn| || [EMAIL PROTECTED] | || | || 05/14/2002 04:23 | || PM | || Please respond to| || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: list of events | | $ORACLE_HOME/rdbms/admin/mesg/oraus.msg Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Babu Nagarajan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Subject: list of events All I know this has been mentioned on this list before but I forget... Which is the script in $ORACLE_HOME/rdbms/admin folder that contains the list of all events? TIA Babu(See attached file: ESPN_Disclaimer.txt) Name: ESPN_Disclaimer.txt ESPN_Disclaimer.txt Type: Plain Text (text/plain) Encoding: base64 Description: Text - character set unknown -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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: Babu Nagarajan 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: Correcting user sql inside the database
Anjo, Can you tell us more on the sneaky way? Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 8:43 AM Outlines is one way, but there is another sneaky way, but that involves a lot of programming depending on what you want to change. And it also depends on where the client runs and how it is linked Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 2:48 PM Hello list This time I need your help on how to implement a weird idea. We have a third party application that fire wasteful SQL's to the database. (Remember the discussion on using x$dual Vs dual some days ago?) I am wondering: Is there a way to change the SQL that the user send? In ADABAS on the mainframe I can activate a user exit that gets the command that the user send to the database and change it (Not only can, but we are doing it!). Is there a way to do the same with SQL in Oracle? In the server (preferably) or in the client. Thanks Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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: Anjo Kolk 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: Babu Nagarajan 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: Renaming files on Unix via PL/SQL
Sorry to get on this thread so late... To answer Emre's question, we can do it if you have a extproc listener configured and have a external procedure to do the same. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 8:53 AM HOST is a SQL*Plus command only. --- John Weatherman [EMAIL PROTECTED] wrote: What about issueing a HOST command through dbms_sql? Not saying it will work (I haven't tried it) but it seems like it should. -Original Message- Sent: Friday, April 19, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840 241 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:95222984 0241 Regards, Mike Hately -Original Message- Sent: 19 April 2002 10:03 To: Multiple recipients of list ORACLE-L Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan 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: PX Deq: Table Q qref
All I have some more information on this. I turned on event 10046 on this. From this I was able to note the following... 1. I start the sql script and spool the results 2. It waits for less than a second on process startup and PX Deq: Join ACK. I think these are waits for starting up the parallel query slaves and then they acknowledging the startup. 3. Then it starts waiting on PX Deq Credit: need buffer and PX Deq Credit: send blkd. I think these are when PQ actually returns data to the QC 4. Then it starts witing on PX Deq: Execute Reply. I see numerous waits on this. I am not sure on what this wait means. 5.After two hours, it starts waiting on PX Deq: Table Q qref and SQL*Net message to client. By this time, it has finished writing to the spool file. I verified this from the unix timestamp. The trace also shows FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=57419669 6. After about 3-4 hours later the SQL prompt returns to me. During this time it has not written to the spool file. So I am not sure what is being done in this time... What is it doing during the Step5 desciribed above? Also why does it show Fetch when I have already gotten the data.. Can any of you pl comment on the above... Am I missing anything or am I interpreting it wrong... Thanks a lot Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 4:03 AM Not entirely sure, but I think this is a query slave trying to make, or break a link from another layer in the DFO. As the query gets to completion, I would expect to see the QC gathering results, and the slaves either in: PX Deq Send Blkd (i.e. more data to send but another slave is currently passing data to the QC) or PX Deq Execution message (roughly, this is from memory) which means all its data has been transmitted and it is waiting for a message from the QC to tell it to die. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 10 April 2002 18:05 All What does this wait event mean? I have a process that connects to the database through ODBC and this process is waiting on this event and SQL*Net message from client. Often this process waits for an unreasonable amout of time (4 seconds or more) on SQL*Net MEssage from client and PX Deq: Table Q qref before it successfully completes... TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Babu Nagarajan 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).
PX Deq: Table Q qref
All What does this wait event mean? I have a process that connects to the database through ODBC and this process is waiting on this event and SQL*Net message from client. Often this process waits for an unreasonable amout of time (4 seconds or more) on SQL*Net MEssage from client and PX Deq: Table Q qref before it successfully completes... TIA Babu
Re: PX Deq: Table Q qref
Thats what I thought. But here is more details on the issue.. I am running a SQL*PLus session with a massive query that returns about 2.5g of data, i am spooling the data to file - that is something similar to what the essbase application is trying to do. that session spooled the data in around 2 hours- so the access paths are fine. after getting the data though, my sql session has still not completed. from the size of the spool file i can see the data came more then three hours ago. this session is still doing something and these waits are increasnig and sql is not returning the SQL prompt to me... trying to find out why... babu - Original Message - From: Deshpande, Kirti To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 2:52 PM Subject: RE: PX Deq: Table Q qref Looks like you have PQ enabled. These waits are considered idle. The PQ slave processes arewaiting for work to do. - Kirti -Original Message-From: Babu Nagarajan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 10, 2002 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: PX Deq: Table Q qref All What does this wait event mean? I have a process that connects to the database through ODBC and this process is waiting on this event and SQL*Net message from client. Often this process waits for an unreasonable amout of time (4 seconds or more) on SQL*Net MEssage from client and PX Deq: Table Q qref before it successfully completes... TIA Babu
Re: PX Deq: Table Q qref
No. i am running it from the foreground... babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:48 PM Babu - Are you running this session in the background? On my system (Compaq Tru64), when I run a SQL*Plus script in the background, I have to put the EXIT command as the last command of the script. Otherwise the script just sits there and echos the prompt into the spool file until it fills up the disk. My system administrator isn't too happy when this occurs, so I try to be careful. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 10, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Thats what I thought. But here is more details on the issue.. I am running a SQL*PLus session with a massive query that returns about 2.5g of data, i am spooling the data to file - that is something similar to what the essbase application is trying to do. that session spooled the data in around 2 hours - so the access paths are fine. after getting the data though, my sql session has still not completed. from the size of the spool file i can see the data came more then three hours ago. this session is still doing something and these waits are increasnig and sql is not returning the SQL prompt to me... trying to find out why... babu - Original Message - To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ; [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 2:52 PM Looks like you have PQ enabled. These waits are considered idle. The PQ slave processes are waiting for work to -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Babu Nagarajan 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: Strange problem deleting rows
Rick If you are waiting on rollback, this script (written by Steve Adams) will help you find out how long the rollback will take. set serveroutput on set feedback off prompt prompt Looking for transactions that are rolling back ... prompt declare cursor tx is select s.username, t.xidusn, t.xidslot, t.xidsqn, t.used_ublk from sys.v_$transaction t, sys.v_$session s where t.used_ublk 1 and s.saddr = t.ses_addr; user_name varchar2(30); xid_usnnumber; xid_slot number; xid_sqnnumber; used_ublk1 number; used_ublk2 number; begin open tx; loop fetch tx into user_name, xid_usn, xid_slot, xid_sqn, used_ublk1; exit when tx%notfound; if tx%rowcount = 1 then sys.dbms_lock.sleep(10); end if; select sum(used_ublk) into used_ublk2 from sys.v_$transaction where xidusn = xid_usn and xidslot = xid_slot and xidsqn = xid_sqn; if used_ublk2 used_ublk1 then sys.dbms_output.put_line( user_name || '''s transaction ' || xid_usn || '.' || xid_slot || '.' || xid_sqn || ' will finish rolling back at approximately ' || to_char( sysdate + used_ublk2 / (used_ublk1 - used_ublk2) / 6 / 60 / 24, 'HH24:MI:SS DD-MON-' ) ); end if; end loop; if user_name is null then sys.dbms_output.put_line('No transactions appear to be rolling back.'); end if; end; / Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 25, 2002 3:13 PM I created a procedure to remove up to 2.4 million records out of a 13+ million record table with bulk binds and forall. Figured that would be the fastest way. While doing this delete, other processes were accessing the table, but not the rows that were being deleted. Things went fine. Eventually, records that were being deleted were being updated, then the probelms started. The job that did the big delete was killed in favor of deleteing the records in smaller batches. However, whenever I try to delete or update some of the records that were affected, the process hangs, like it's waiting on a commit or rollback from a previous transaction. I have bounced the db and this is still occuring. Is there a way to check if the blocks are indeed waiting for a commit or rollback and provide that as needed? Thank you -- 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: Babu Nagarajan 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: not using indexes
are all your tables/indexes analyzed? if the statistics are not current then the plans chosen by the CBO can be very bad. babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 04, 2002 12:40 AM Dear All, I have been entrusted to tune a web based application. This product is at development stage. I generated the trace file and found out the indexes on the table. So I specified hints in all the queries and tested the application. There was a remarkable increase in performance. Can any one tell me why we have to specify the hints in the queries, when the tables are having index already. Platform: WinNT Oracle 8.1.6. Application is developed in JSP and Web server is iPlanet Enterprise Edition. TIA Regards Venkat -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Babu Nagarajan 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: Shared pool wait for library cache pin
-- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Babu Nagarajan 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: Moving Oracle software
i dont think you need a relink all. the path is always taken from your env variables so it does not need a relink... may be on some patch levels you might need a relink. try it w/o relinking and it it works its fine i have tried it w/o relinking and it works fine... babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 2:51 PM If I copy the oracle software directories from one machine to another, should I run relink allbefore using them? This is an 8.1.6.3 implementation running under Solaris 2.7. The directory names are different on the new box (i.e. ORACLE_BASE is not the same), and the O/S patch level is off a little. As a test, I moved the oracle software from one directory to another (on the same machine), and the database came up fine. I ran relink all just to get familiar with it; it seems to have worked fine, but it produces a lot of messages and it's hard to decide whether they can all be ignored or not. Thanks Kurt Wiegand IBM Global Services Cable Wireless Communications Vienna VA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wiegand, Kurt 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: Babu Nagarajan 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: insert privilege across db link
in the db link are you using the same user as the table owner in the remote db. in your case are you using the user b in your dblink? babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 3:35 PM database is 8.1.7 how do I grant insert privilege to a user in a different database? Note: the database link in place in both database and I can describe tables in each just fine. In the trigger I already have the insert into b.address@bschema. When I try to execute the trigger I get insufficient privileges. I have tried the trigger locally and it works just fine it is when I try to insert a row across the database link I get insufficient privileges. What am I missing/forgetting? Thanks Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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: Babu Nagarajan 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: root.sh wasn't run, help!
root.sh will update your oratab file. this is needed by many of the oracle tools. actually the root user can edit the file thru vi and update it/add the details to it. also it initializes some other directories - one of which could be your orainventory directory (i am making a guess here. pl correct me if i am worng) i think you should be okay.. babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 3:55 PM Well, I opened a TAR with Oracle but they still haven't gotten back to me and I need to know before I leave tonight (as I might not be leaving tonight). I was installing 8.1.7 on a server prior to doing an upgrade this weekend. Over an hour had passed after asking my SA to run root.sh for me and while looking something up the cover of my Koch book hit the enter key on my workstation. Boom, the installation process continued even though root.sh had not been run. There were no errors on the GUI side but the following errors in the log: Error :*** Alert: A configuration script needs to be run as root before installa tion can proceed. Please leave this window up, go run /oracle/product/8.1.7/root .sh as root from another window, then come back here and click OK to continue. * ** User selected: Yes/OK Initializing installer save inventory WCCE Unable to read /oracle/oraInventory/Contents/OracleHomesList.ser. Some inventory information may be lost. Unable to read /oracle/oraInventory/Contents/CompsList0.ser. Some inventory info rmation may be lost. Unable to read /oracle/oraInventory/Contents/PatchesList0.ser. Some inventory in formation may be lost. Unable to read /oracle/oraInventory/Contents/LibsList.ser. Some inventory inform ation may be lost. So my question is: Is there any way to recover from this or do I need to uninstall and reinstall from the beginning? TIA, 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: Babu Nagarajan 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: insert privilege across db link
what is the user in the db link. it it b or some other user? babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 4:30 PM the db link is a public one owned by system. User B is only in Bshema. User A with the trigger is only is Aschema. Kathy -Original Message- Sent: Thursday, January 03, 2002 1:16 PM To: Multiple recipients of list ORACLE-L in the db link are you using the same user as the table owner in the remote db. in your case are you using the user b in your dblink? babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 3:35 PM database is 8.1.7 how do I grant insert privilege to a user in a different database? Note: the database link in place in both database and I can describe tables in each just fine. In the trigger I already have the insert into b.address@bschema. When I try to execute the trigger I get insufficient privileges. I have tried the trigger locally and it works just fine it is when I try to insert a row across the database link I get insufficient privileges. What am I missing/forgetting? Thanks Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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: Babu Nagarajan 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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: Babu Nagarajan 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
Re: METABLINK on the Fritz?
Title: METABLINK on the Fritz? u are not alone... i've been trying since about 3:00 pm est... its crawling.. - Original Message - From: Mohan, Ross To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 30, 2001 4:06 PM Subject: METABLINK on the Fritz? Am I the only one having trouble roundabout 4pm EST?