Why is Oracle process using 25 MB of RAM when idle?
Hi, we are running 9.2 on HP-UX here. We have pg_aggregate_target configured, but I realized (in my opinion) very high memory consumption of Oracle Unix processes. a) How come that one Oracle Connection (i.e. dedicated Unix process on HP) is using up at least 22 MB of RAM? It is using 22 MB if the user is just connected, not doing anything. Any way I can modify this? b) If the user is querying data and the like, the memory consumption goes up to 60 MB. How come? Thanks! Regards, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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).
Savepoints in 9i
Title: Savepoints in 9i Hi Friends , In my application , we are having a program written in C which executes the sql command that is passed as an argument to it. When I call the procedure to Create a savepoint "SP1" and then to rollback to the named savepoint , it throws an oracle error "1086- Savepoint "SP1" never established. The same piece of code worked with Oracle 8i . Is there any differences in Oracle 9i related to savepoints. Please note that I am using a single database and no autonomous transactions. Thanks & Regards, Shankar This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com
Re: Trace versus Statspack data
Hi. Execute in sqltrace is for that particular session only whereas in statspack, it's system wide. A lot of sessions might have executed the same query. Best regards "VIVEK_SHARMA" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/17/2003 02:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: Rhojel Echano/Manila/PH/SGS) Subject: Trace versus Statspack data We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- "Execute" from SQL_TRACE = 2584 "Executions" from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,000 5.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks
RE: granting SELECT privilege on SYS.X$ TABLES
Check out Jacques e-mail address - he *works* for Quest ;) -Original Message- Wolfgang Breitling Sent: 15 November 2003 07:04 To: Multiple recipients of list ORACLE-L Someone must have created sys.x_$ views on some of the sys.x$ tables. Installing statspack does that for example for X$KCBFWAIT, X$KSPPSV, X$KSPPI, and X$KSQST. Do you have quest? I believe it does it for some of the x$ tables as well. I routinely do it for all x$ tables in my test databases and grant select to the select_catalog_role. Then I can access the x$tables without having to log on as sys. In my test databases I always At 07:14 PM 11/14/2003, you wrote: >P.S. I forgot to mention that in all the databases (including the 8.1.7 >databases) in which I tried this, init parameter >O7_DICTIONARY_ACCESSIBILITY was set to FALSE. > >I always thought that one could not grant SELECT privilege on the SYS.X$ >tables, and to make them accessible to another user one would have to >create a view on the table (as mentioned on Steve Adams' ixora website: >http://www.ixora.com.au/scripts/prereq.htm >create_xviews.sql) > >However someone told me recently that you could grant SELECT on sys.X_$... > >When I tried this, I saw results that confused me. >In Database A, Oracle 8.1.7.4.1, Windows 2000 server, I was able to >1- grant select on SYS.X_$KTFBFE to another_user ; >2- grant select on SYS.X_$KTFBHC to another_user ; >3- grant select on SYS.X_$KTFBUE to another_user ; > >BUT > >4- grant select on SYS.X_$KDXST to another_user ; >returns ORA-00942 table or view does not exist. > >In database B, using the same ORACLE_HOME as database A (i.e. identical >Oracle version and OS) >even the first three grant statements returned ORA-00942 > >When I tried it on more recent Oracle databases on Windows / SunOS >servers, it worked intermittently: >Oracle 9.0 (SunOS): all GRANTS failed >Oracle 9.2 (SunOS): GRANTS 1-3 were successful, GRANT 4 failed >Oracle 10.1 beta (Windows 2000): all GRANTS failed > >Does anyone know the reason for this strange behaviour? >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jacques Kilchoer > 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). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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).
Trace versus Statspack data
We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- “Execute” from SQL_TRACE = 2584 “Executions” from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,000 5.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks
RE: Why is Oracle process using 25 MB of RAM when idle?
Helmut, I don't know how you are measuring your numbers, but beware that what the operating system reports is often somewhat misleading. Typically, shared memory is often 'attributed' to each and every process linked to it. When you think about it it makes sense, but at the same time it does mean that n processes will really use much less than n * the amount of memory reported as used by one process. This is true both of the 'program' part of user memory (shared libraries) and of the 'data' part of it (SGA). When your process connects, it attaches the SGA and some shared libraries, and more shared libraries come into play as it starts doing something. You may have a better view of what is really used by your process by checking into V$SESSTAT, which holds a number of values about it. HTH, SF >- --- Original Message --- - >From: "Daiminger, Helmut" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Sun, 16 Nov 2003 23:09:26 > >Hi, > >we are running 9.2 on HP-UX here. > >We have pg_aggregate_target configured, but I >realized (in my opinion) very >high memory consumption of Oracle Unix processes. > >a) How come that one Oracle Connection (i.e. >dedicated Unix process on HP) >is using up at least 22 MB of RAM? It is using 22 >MB if the user is just >connected, not doing anything. > >Any way I can modify this? > >b) If the user is querying data and the like, the >memory consumption goes up >to 60 MB. How come? > >Thanks! > >Regards, >Helmut > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: wakeup time manager
Hi Arup, Yes, AQ is enabled for this database - thanks for the information. - Bill. At 07:59 13/11/2003 -0800, Arup Nanda wrote: Have you enabled Advanced Queue Manager process in the init file? aq_tm_processes? If so, this wait event occurs when the process just waits to see some messages in the queue. Yes, it is an idle event and can be ignored. Fortunately this is listed as idle event in STATSPACK, which does not report these waits. HTH. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 10:24 AM > Hi, > > I cannot find reference to the "wakeup time manager" wait event in the > FM. Can anyone explain it to me? Getting lots of waits for this in a > 9.2.0.4 database - but given that both processors and disks are pretty idle > at the moment I guess it falls under the category of "idle > events". Therefore I'm not going to worry about it too much - but would be > nice to know what it is. > > Thanks for any info > - Bill. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan 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: wakeup time manager
Hi Arup, Yes, AQ is enabled for this database - thanks for the information. - Bill. At 07:59 13/11/2003 -0800, Arup Nanda wrote: Have you enabled Advanced Queue Manager process in the init file? aq_tm_processes? If so, this wait event occurs when the process just waits to see some messages in the queue. Yes, it is an idle event and can be ignored. Fortunately this is listed as idle event in STATSPACK, which does not report these waits. HTH. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 10:24 AM > Hi, > > I cannot find reference to the "wakeup time manager" wait event in the > FM. Can anyone explain it to me? Getting lots of waits for this in a > 9.2.0.4 database - but given that both processors and disks are pretty idle > at the moment I guess it falls under the category of "idle > events". Therefore I'm not going to worry about it too much - but would be > nice to know what it is. > > Thanks for any info > - Bill. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan 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: DB Code compilation and library cache lock issue
DB Code compilation and library cache lock issueHi, To detect whether you are waiting for a compile to finish, you can just check v$session_wait and see if your current session is waiting for "library cache pin" wait event. Without such wait event ,compiling a procedure can just be finished in seconds. But I do not know whether there is any parameter to change this timeout. zhuchao - Original Message - To: Multiple recipients of list ORACLE-L Sent: Friday, November 14, 2003 9:59 PM Hi all, As we know if procedure A is currently being executed, one cannot re-compile procedure A. And when one tries to do so, the compilation appears to be _hanging_. Though it time-outs after some time. My question is , is there a way to detect this when I am compiling a procedure? Can this timeout be changed? If so, how? DB is 9202. Thanks in advance Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao 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).
Trace versus Statspack data
We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- "Execute" from SQL_TRACE = 2584 "Executions" from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks -- 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).
Bad performance because of wrong characterset?
Hi List, One of my customers gets HP Servicedesk 4.5 implemented. The database that has been created by on of the DBA's for the application is Oracle 8.1.7.4, on AIX 4.3. The database has characterset UTF8, which is the standard here. Now ServiceDesk has bad performance. HP claims that the characterset is wrong, and a new database has to be created with character set WE8ISO8859P15. I've never heard of bad performance due to differences in character sets, probably because of my lack of experience. Anyone familiar with this issue? TIA, Carel-Jan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel 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: Re[2]: var source_data varchar2(12)
Mladen, we must have started in the same era. You're describing the environment I started with, however, our disk was 10MB. So you remember SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well? > Carel, I know that. That was my first oracle version. I installed V4 on an > IBM > PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could > each hold 360k of information. Yes, you read it correctly. It was 20 MB > hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic > card was called "Hercules". I don't know why was it called "graphic card" > because it didn't have any graphic. The first real graphic was CGA and > then > EGA, VGA, XGA on PS/2 (IBM PS/2, not Playstation 2) and SVGA. > > On 2003.11.16 21:04, Carel-Jan Engel wrote: >> Hi Mladen, >> >> At 06:19 12-11-03 -0800, you wrote: >>> SQL*Plus has a ghastly and disgusting user interface, >>> implemented without "readline" or equivalent, which would give a >>> command >>> history. >>> Littering the system with those @#$%! afiedt.buf files is bad enough >>> but >>> line >>> editting commands are an indicator of how much oracle cares for the >>> user >>> interface. >> >>> and sqlplus is definitely not something that I'd like presenting to my >>> users. >> >> >> Do you know how SQL*Plus was called during Oracle V4? (And maybe >> earlier, >> but this is as far as my history with Oracle goes) >> >> They called it UFI, which means User Friendly Interface! >> >> Regards, Carel-Jan >> >> -- There will allways be another 10 last bugs -- >> >>-- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >>-- >> Author: Carel-Jan Engel >> 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). > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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: Carel-Jan Engel 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: Why is Oracle process using 25 MB of RAM when idle?
Hi Stephane, thanks for your reply. We are measuring the values by getting the OS process ID of a specific Oracle connection and then trach that process ID using glance (on HP-UX). Since the SGA is ab 1.5 GB, it is definitely not attached to the memory consumed by each process. I know that this is an issue on Solaris. We tried and used a whole bunch of different processes and they were all using 20-25 MB of RAM (doing nothing). This number seems just a little bit high to me... Example: If I have an SGA with 1 GB, 200 MB of pga-aggregate-target and 200 users connecting to the datbase (although only about 10% of them are active at the same point in time). This would mean that my memory consumption is: 1 GB + 200 MB + 200*25 MB = 6.2 GB... Regards, Helmut -Original Message- Sent: Monday, November 17, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Helmut, I don't know how you are measuring your numbers, but beware that what the operating system reports is often somewhat misleading. Typically, shared memory is often 'attributed' to each and every process linked to it. When you think about it it makes sense, but at the same time it does mean that n processes will really use much less than n * the amount of memory reported as used by one process. This is true both of the 'program' part of user memory (shared libraries) and of the 'data' part of it (SGA). When your process connects, it attaches the SGA and some shared libraries, and more shared libraries come into play as it starts doing something. You may have a better view of what is really used by your process by checking into V$SESSTAT, which holds a number of values about it. HTH, SF >- --- Original Message --- - >From: "Daiminger, Helmut" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Sent: Sun, 16 Nov 2003 23:09:26 > >Hi, > >we are running 9.2 on HP-UX here. > >We have pg_aggregate_target configured, but I >realized (in my opinion) very >high memory consumption of Oracle Unix processes. > >a) How come that one Oracle Connection (i.e. >dedicated Unix process on HP) >is using up at least 22 MB of RAM? It is using 22 >MB if the user is just >connected, not doing anything. > >Any way I can modify this? > >b) If the user is querying data and the like, the >memory consumption goes up >to 60 MB. How come? > >Thanks! > >Regards, >Helmut > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: Daiminger, Helmut 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).
Archive Destinations: quota_size
Hi all, Is anyone using the QUOTA_SIZE setting in the LOG_ARCHIVE_DEST_n parameters? I am trying to use this for a local archive destination in a non-Dataguard configuration. However if the destination fills up, although the error is correctly identified and reported (alert log and V$ARCHIVE_DEST) and archiving stops, the error never goes away when I clear out the destination. REOPEN is specified (default = 300 seconds). I can manually clear the error force the archiver to restart by doing an ALTER SYSTEM SET LOG_ARCHIVE_DEST_n = '' but I was assuming this error would automatically clear after REOPEN seconds when I empty the destination. Is this broken or am I missing something? (9.2.0.4 on Linux) Many thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan 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: modeling year and month for summary data
Randy, We have both weekly and monthly summary tables and the date data field is defined as DATE. It is populated by the pl/sql package that summarizes the data using a date value passed to the package as the ending date for the week or month. On the first of the month or Sunday we run the appropriate package and pass the date value (sysdate -1) for the package to use as the ending date. Ron >>> [EMAIL PROTECTED] 11/14/2003 5:14:25 PM >>> I have a table that will contain sales monthly summary. I am not sure which is the better way to handle the date of the data. I can create a year field and a month field or I can create a date field and force in the day e.g. 2003 November's data can be 01-Nov-03 . Is there a censuses on which way to handle the date? Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how can I make Oracle not use all processors in machine?
Hi! We are currently discussing Oracle licensing issues. Due to the number of users, named user licensing is not an option for us. Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is this possible (i.e. via the parameter cpu_count)? The other 6 CPU's will then be used by other applications ion the box (e.g. BEA WebLogic etc.). This is 9.2 on HP-UX 11.11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: RE: Why is Oracle process using 25 MB of RAM when idle?
Helmut, Seems a bit high to me as well. Concerning the PGA issue, what about running something like : col name format A25 select n.name, round(min(s.value) / 1024) "MIN K", round(avg(s.value) / 1024) "AVG K", round(max(s.value) / 1024) "MAX K" from v$statname n, v$sesstat s where n.name like 'session pga memory%' and n.statistic# = s.statistic# group by n.name / IMHO, the Oracle "insider view" will probably give you something more realistic. Now, concerning what HP-UX reports to you, I would certainly suspect the run-time linker. I guess that there are better specialists of HP-UX than myself (anybody qualifies :-)) on this list who know how to tell which dynamically loaded libraries are used by a currently running program ? HTH, SF >- --- Original Message --- - >From: "Daiminger, Helmut" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Mon, 17 Nov 2003 03:59:26 > >Hi Stephane, > >thanks for your reply. > >We are measuring the values by getting the OS >process ID of a specific >Oracle connection and then trach that process ID >using glance (on HP-UX). > >Since the SGA is ab 1.5 GB, it is definitely not >attached to the memory >consumed by each process. I know that this is an >issue on Solaris. > >We tried and used a whole bunch of different >processes and they were all >using 20-25 MB of RAM (doing nothing). This number >seems just a little bit >high to me... > >Example: If I have an SGA with 1 GB, 200 MB of >pga-aggregate-target and 200 >users connecting to the datbase (although only >about 10% of them are active >at the same point in time). >This would mean that my memory consumption is: 1 GB >+ 200 MB + 200*25 MB = >6.2 GB... > > >Regards, >Helmut > > >-Original Message- >Sent: Monday, November 17, 2003 10:30 AM >To: Multiple recipients of list ORACLE-L > > >Helmut, > > I don't know how you are measuring your numbers, >but beware that what the >operating system reports is often somewhat >misleading. Typically, shared >memory is often 'attributed' to each and every >process linked to it. When >you think about it it makes sense, but at the same >time it does mean that n >processes will really use much less than n * the >amount of memory reported >as used by one process. This is true both of the >'program' part of user >memory (shared libraries) and of the 'data' part of >it (SGA). When your >process connects, it attaches the SGA and some >shared libraries, and more >shared libraries come into play as it starts doing >something. You may have a >better view of what is really used by your process >by checking into >V$SESSTAT, which holds a number of values about it. > > >HTH, > >SF > >>- --- Original Message --- - >>From: "Daiminger, Helmut" ><[EMAIL PROTECTED]> >>To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >>Sent: Sun, 16 Nov 2003 23:09:26 >> >>Hi, >> >>we are running 9.2 on HP-UX here. >> >>We have pg_aggregate_target configured, but I >>realized (in my opinion) very >>high memory consumption of Oracle Unix processes. >> >>a) How come that one Oracle Connection (i.e. >>dedicated Unix process on HP) >>is using up at least 22 MB of RAM? It is using 22 >>MB if the user is just >>connected, not doing anything. >> >>Any way I can modify this? >> >>b) If the user is querying data and the like, the >>memory consumption goes up >>to 60 MB. How come? >> >>Thanks! >> >>Regards, >>Helmut >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
software deployment control
List, I have been asked to produce a process for documenting the request,test,deployment, etc of the server OS, client OS, and databases that we use. I have googled for 'software deployment control' and 'software change management' without much success. We are looking for a written procedure not a purchased software package. Does anyone have a source location for documentation so I can start on my project. Thanks, Ron Aren't IT audits fun??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Re[2]: var source_data varchar2(12)
I do. I thought that IAD (graphic interface which came with 2.0 in version 5) was a solution to all problems. Version 4 was used for training purposes only. First real apps were developed with 5.0 and 5.1.22. On 11/17/2003 06:14:24 AM, Carel-Jan Engel wrote: > Mladen, we must have started in the same era. You're describing the > environment I started with, however, our disk was 10MB. So you remember > SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well? > > > Carel, I know that. That was my first oracle version. I installed V4 on an > > IBM > > PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could > > each hold 360k of information. Yes, you read it correctly. It was 20 MB > > hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic > > card was called "Hercules". I don't know why was it called "graphic card" > > because it didn't have any graphic. The first real graphic was CGA and > > then > > EGA, VGA, XGA on PS/2 (IBM PS/2, not Playstation 2) and SVGA. > > > > On 2003.11.16 21:04, Carel-Jan Engel wrote: > >> Hi Mladen, > >> > >> At 06:19 12-11-03 -0800, you wrote: > >>> SQL*Plus has a ghastly and disgusting user interface, > >>> implemented without "readline" or equivalent, which would give a > >>> command > >>> history. > >>> Littering the system with those @#$%! afiedt.buf files is bad enough > >>> but > >>> line > >>> editting commands are an indicator of how much oracle cares for the > >>> user > >>> interface. > >> > >>> and sqlplus is definitely not something that I'd like presenting to my > >>> users. > >> > >> > >> Do you know how SQL*Plus was called during Oracle V4? (And maybe > >> earlier, > >> but this is as far as my history with Oracle goes) > >> > >> They called it UFI, which means User Friendly Interface! > >> > >> Regards, Carel-Jan > >> > >> -- There will allways be another 10 last bugs -- > >> > >>-- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >> Author: Carel-Jan Engel > >> 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). > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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: Carel-Jan Engel > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET
Re: Why is Oracle process using 25 MB of RAM when idle?
Your process has parts of SGA attached to it. The only way to actually find out is to examine the process address space wia kernel debugger or /proc file system. First, try with ps -lp and see how big is the RSS (resident set size). On 11/17/2003 02:09:26 AM, "Daiminger, Helmut" wrote: > Hi, > > we are running 9.2 on HP-UX here. > > We have pg_aggregate_target configured, but I realized (in my opinion) very > high memory consumption of Oracle Unix processes. > > a) How come that one Oracle Connection (i.e. dedicated Unix process on HP) > is using up at least 22 MB of RAM? It is using 22 MB if the user is just > connected, not doing anything. > > Any way I can modify this? > > b) If the user is querying data and the like, the memory consumption goes up > to 60 MB. How come? > > Thanks! > > Regards, > Helmut > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daiminger, Helmut > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Bad performance because of wrong characterset?
Carel-Jan, About two weeks ago, Faan DeSwardt <[EMAIL PROTECTED]> posted to the thread "Unicode: UTF-16 to UTF-8 conversion", saying UTF-8 is variable-length encoding and so is slower than the fixed-width UTF-16, and also US7ASCII. Maybe it's the same issue here comparing UTF-8 with WE8ISO8859P15. Faan can comment. Yong Huang --- Carel-Jan Engel <[EMAIL PROTECTED]> wrote: > Hi List, > > One of my customers gets HP Servicedesk 4.5 implemented. The database that > has been created by on of the DBA's for the application is Oracle 8.1.7.4, > on AIX 4.3. > > The database has characterset UTF8, which is the standard here. > > Now ServiceDesk has bad performance. HP claims that the characterset is > wrong, and a new database has to be created with character set > WE8ISO8859P15. > > I've never heard of bad performance due to differences in character sets, > probably because of my lack of experience. Anyone familiar with this > issue? > > TIA, Carel-Jan __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: Why is Oracle process using 25 MB of RAM when idle?
Gogala, I've been searching for a /proc filesystem implementation on HPUX for years. I don't think it's there yet. Yong Huang --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > Your process has parts of SGA attached to it. The only way to actually find > out > is to examine the process address space wia kernel debugger or /proc file > system. First, try with ps -lp and see how big is the RSS (resident set > size). > On 11/17/2003 02:09:26 AM, "Daiminger, Helmut" wrote: > > Hi, > > > > we are running 9.2 on HP-UX here. > > > > We have pg_aggregate_target configured, but I realized (in my opinion) very > > high memory consumption of Oracle Unix processes. > > > > a) How come that one Oracle Connection (i.e. dedicated Unix process on HP) > > is using up at least 22 MB of RAM? It is using 22 MB if the user is just > > connected, not doing anything. > > > > Any way I can modify this? > > > > b) If the user is querying data and the like, the memory consumption goes > up > > to 60 MB. How come? > > > > Thanks! > > > > Regards, > > Helmut > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Daiminger, Helmut > > 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). > > > > Mladen Gogala > Oracle DBA __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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).
IOUG Live2004 session confirmation
Hi! Does anyone who submitted their abstracts to IOUG-A Live! 2004 remember when was the deadline for acceptance confirmation from IOUG-A? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how can I make Oracle not use all processors in machine?
Hi! You should check the licensing agreements first, AFAIK you need a licence for each CPU in server, it doesn't matter how many of them you actually use. Also I haven't heard that HP-UX supported CPU affinity anyway... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 3:04 PM > Hi! > > We are currently discussing Oracle licensing issues. Due to the number of > users, named user licensing is not an option for us. > > Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we > are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is > this possible (i.e. via the parameter cpu_count)? > The other 6 CPU's will then be used by other applications ion the box (e.g. > BEA WebLogic etc.). > > This is 9.2 on HP-UX 11.11. > > Thanks, > Helmut > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daiminger, Helmut > 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: Tanel Poder 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: IOUG Live2004 session confirmation
Tanel, The emails/letters should be coming out soon. They have been working on scheduling. Daniel Fink Tanel Poder wrote: > Hi! > > Does anyone who submitted their abstracts to IOUG-A Live! 2004 remember when > was the deadline for acceptance confirmation from IOUG-A? > > Tanel. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > 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: Daniel Fink 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).
Configuring multi-threaded server
Oracle version 8.1.7 AIX 4.3.3 I am trying to configure mult-threaded server on one of my development databases. In my init.ora file, I set (mts_dispatchers="(address=(protocol=tcp))" mts_servers=10 When I bring up the database, I can see the dispatcher and servers. When I connect to the database with sqlnet, however, it still gives me a dedicated server. I tried forcing the connection by putting (server=shared) into the tnsnames.ora file on my client. Then I get: ORA-12520: TNS:listener could not find available handler for requested type of server What am I missing here? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Configuring multi-threaded server
Peter: 8.1.7 is pretty picky about syntax. Here's what I have in my 8.1.7.4 database. (It's Solaris, but I believe the parameter is the same) MTS_DISPATCHERS="(address=(PROTOCOL=TCP)(HOST=atex-ent-prd1))(disp=2)" mts_servers = 20 Good luck! Barb --- "Schauss, Peter" <[EMAIL PROTECTED]> wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one > of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the > dispatcher and > servers. When I connect to the database with > sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting > (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available > handler for requested type > of > server > > What am I missing here? > > Thanks, > Peter Schauss > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Schauss, Peter > 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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: IOUG Live2004 session confirmation
Talked with Stan Yellott Friday. His is scheduling and confirming today. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Tanel Poder Sent: Monday, November 17, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject:IOUG Live2004 session confirmation Hi! Does anyone who submitted their abstracts to IOUG-A Live! 2004 remember when was the deadline for acceptance confirmation from IOUG-A? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how can I make Oracle not use all processors in machine?
Helmut: I think (???) if you have MC Service Guard installed, you can specifically allocate CPUs for specific processes. For the SQL*Net stuff, not sure if you can limit these. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Daiminger, Helmut Sent: Monday, November 17, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Subject:how can I make Oracle not use all processors in machine? Hi! We are currently discussing Oracle licensing issues. Due to the number of users, named user licensing is not an option for us. Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is this possible (i.e. via the parameter cpu_count)? The other 6 CPU's will then be used by other applications ion the box (e.g. BEA WebLogic etc.). This is 9.2 on HP-UX 11.11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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: Savepoints in 9i
The fine manual doesn't seem to reveal anything new. Here's what you need to do: Write some pure PL/SQL code with which you can duplicate this problem, and post it to the list. If you can't duplicate it that way, it's very likely to be a Pro*C problem, in which case you should: Write some C and PL/SQL and post it to the list. You have checked MetaLink haven't you? Jared On Sun, 2003-11-16 at 23:39, Ramasubramanian, Shankar (Cognizant) wrote: > Hi Friends , > In my application , we are having a program written in C which executes the > sql command that is passed as an argument to it. When I call the procedure to > Create a savepoint "SP1" and then to rollback to the named savepoint , it throws an > oracle error "1086- Savepoint "SP1" never established. The same piece of code worked > with Oracle 8i . Is there any differences in Oracle 9i related to savepoints. Please > note that I am using a single database and no autonomous transactions. > > Thanks & Regards, > Shankar > > > This e-mail and any files transmitted with it are for the sole use of the intended > recipient(s) and may contain confidential and privileged information. > If you are not the intended recipient, please contact the sender by reply e-mail and > destroy all copies of the original message. > Any unauthorised review, use, disclosure, dissemination, forwarding, printing or > copying of this email or any action taken in reliance on this e-mail is strictly > prohibited and may be unlawful. > > Visit us at http://www.cognizant.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Savepoints in 9i
Here's a wild guess, could it have anything to do with turning on automatic undo and setting undo_suppress_errors (sp?) to true? Is the savepoint command erroring and not being trapped? Daniel Fink Jared Still wrote: > The fine manual doesn't seem to reveal anything new. > > Here's what you need to do: > > Write some pure PL/SQL code with which you can duplicate > this problem, and post it to the list. > > If you can't duplicate it that way, it's very likely to > be a Pro*C problem, in which case you should: > > Write some C and PL/SQL and post it to the list. > > You have checked MetaLink haven't you? > > Jared > > On Sun, 2003-11-16 at 23:39, Ramasubramanian, Shankar (Cognizant) wrote: > > Hi Friends , > > In my application , we are having a program written in C which executes the > > sql command that is passed as an argument to it. When I call the procedure to > > Create a savepoint "SP1" and then to rollback to the named savepoint , it throws > > an oracle error "1086- Savepoint "SP1" never established. The same piece of code > > worked with Oracle 8i . Is there any differences in Oracle 9i related to > > savepoints. Please note that I am using a single database and no autonomous > > transactions. > > > > Thanks & Regards, > > Shankar > > > > > > > This e-mail and any files transmitted with it are for the sole use of the intended > > recipient(s) and may contain confidential and privileged information. > > If you are not the intended recipient, please contact the sender by reply e-mail > > and destroy all copies of the original message. > > Any unauthorised review, use, disclosure, dissemination, forwarding, printing or > > copying of this email or any action taken in reliance on this e-mail is strictly > > prohibited and may be unlawful. > > > > Visit us at http://www.cognizant.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Daniel Fink 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: Configuring multi-threaded server
You have to make sure the dispatchers are registered with the listener. Use "lsnrctl services" to make sure. The error you gave shows that they are not registered. If your listener is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the dispatcher and > servers. When I connect to the database with sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available handler for requested type > of > server -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Silly SQL Question
Jacques --
Huh? I thought the question was, "give me all the usrs where there exists a
record containing a 1,5, and 7". How can that return one record, when there
are two users -- and only two users -- who have the 1,5,7 combination? The
data provided shows that both GAP and GPA have a 1, 5 and 7 and that no
other users do. My query provides that answer. If that wasn't the
question, then that won't be the answer; but if it *was* the question, then
the query is correct.
HTH,
Bambi.
=
create table gab (usr char(3),val number);
insert into gab values ('GAP',1);
insert into gab values ('GAP',5);
insert into gab values ('GAP',5);
insert into gab values ('GAP',7);
insert into gab values ('PAG',1);
insert into gab values ('PAG',7);
insert into gab values ('PAG',2);
insert into gab values ('JKL',1);
insert into gab values ('JKL',5);
insert into gab values ('JKL',5);
insert into gab values ('GPA',1);
insert into gab values ('GPA',5);
insert into gab values ('GPA',7);
insert into gab values ('GPA',8);
select usr from gab
where val=1
intersect
select usr from gab
where val=5
intersect
select usr from gab
where val=7;
USR
---
GAP
GPA
-Original Message-
Sent: Friday, November 14, 2003 7:24 PM
To: Multiple recipients of list ORACLE-L
> -Original Message-
> Bellow, Bambi
>
> Why not do it like this...
>
> select usr from gab
> where val=1
> intersect
> select usr from gab
> where val=5
> intersect
> select usr from gab
> where val=7;
Because that way you would get the wrong answer. With the sample data as
kindly provided by Mr. Begun the correct query would return one row, but
your query returns two rows.
SQL> select * from gab ;
USR VAL
-- -
GAP1
GAP5
GAP5
GAP7
PAG1
PAG7
PAG2
JKL1
JKL5
JKL5
GPA1
GPA5
GPA7
GPA8
14 ligne(s) sélectionnée(s).
SQL> select usr from gab
2 where val=1
3 intersect
4 select usr from gab
5 where val=5
6 intersect
7 select usr from gab
8 where val=7;
USR
--
GAP
GPA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
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: Bellow, Bambi
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: Re[2]: var source_data varchar2(12)
> >> > >> Do you know how SQL*Plus was called during Oracle V4? (And maybe > >> earlier, > >> but this is as far as my history with Oracle goes) > >> > >> They called it UFI, which means User Friendly Interface! > >> And that dreaded afiedt.buf came was a copy of the "Advanced User Friendly Interface Buffer" (edt was VMS's editor back then) Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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: Re[2]: var source_data varchar2(12)
Hope you don't mind the intrusion... I used HLI back in 5.0.20 days, and the big problem converting in 5.1.22 when everything had to go to IAPXIT. When were IAP|IAG replaced with IAD? I thought that came in around 1.3... was it later? Because by v2 it was SQL*Forms... Bambi. On 11/17/2003 06:14:24 AM, Carel-Jan Engel wrote: > Mladen, we must have started in the same era. You're describing the > environment I started with, however, our disk was 10MB. So you remember > SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well? > > > Carel, I know that. That was my first oracle version. I installed V4 on an > > IBM > > PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could > > each hold 360k of information. Yes, you read it correctly. It was 20 MB > > hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic > > card was called "Hercules". I don't know why was it called "graphic card" > > because it didn't have any graphic. The first real graphic was CGA and > > then > > EGA, VGA, XGA on PS/2 (IBM PS/2, not Playstation 2) and SVGA. > > > > On 2003.11.16 21:04, Carel-Jan Engel wrote: > >> Hi Mladen, > >> > >> At 06:19 12-11-03 -0800, you wrote: > >>> SQL*Plus has a ghastly and disgusting user interface, > >>> implemented without "readline" or equivalent, which would give a > >>> command > >>> history. > >>> Littering the system with those @#$%! afiedt.buf files is bad enough > >>> but > >>> line > >>> editting commands are an indicator of how much oracle cares for the > >>> user > >>> interface. > >> > >>> and sqlplus is definitely not something that I'd like presenting to my > >>> users. > >> > >> > >> Do you know how SQL*Plus was called during Oracle V4? (And maybe > >> earlier, > >> but this is as far as my history with Oracle goes) > >> > >> They called it UFI, which means User Friendly Interface! > >> > >> Regards, Carel-Jan > >> > >> -- There will allways be another 10 last bugs -- > >> > >>-- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >> Author: Carel-Jan Engel > >> 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). > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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: Carel-Jan Engel > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-
RE: Re[2]: var source_data varchar2(12)
IAD was the executable (on VMS) that the Sql*Forms command ran (D for Designer). IAG was to generate a form (G for Generate). IAP to execute it (P for something that I can't remember). This was SqlForms 3.0. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 17, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hope you don't mind the intrusion... I used HLI back in 5.0.20 days, and the big problem converting in 5.1.22 when everything had to go to IAPXIT. When were IAP|IAG replaced with IAD? I thought that came in around 1.3... was it later? Because by v2 it was SQL*Forms... Bambi. On 11/17/2003 06:14:24 AM, Carel-Jan Engel wrote: > Mladen, we must have started in the same era. You're describing the > environment I started with, however, our disk was 10MB. So you remember > SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well? > > > Carel, I know that. That was my first oracle version. I installed V4 on an > > IBM > > PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could > > each hold 360k of information. Yes, you read it correctly. It was 20 MB > > hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic > > card was called "Hercules". I don't know why was it called "graphic card" > > because it didn't have any graphic. The first real graphic was CGA and > > then > > EGA, VGA, XGA on PS/2 (IBM PS/2, not Playstation 2) and SVGA. > > > > On 2003.11.16 21:04, Carel-Jan Engel wrote: > >> Hi Mladen, > >> > >> At 06:19 12-11-03 -0800, you wrote: > >>> SQL*Plus has a ghastly and disgusting user interface, > >>> implemented without "readline" or equivalent, which would give a > >>> command > >>> history. > >>> Littering the system with those @#$%! afiedt.buf files is bad enough > >>> but > >>> line > >>> editting commands are an indicator of how much oracle cares for the > >>> user > >>> interface. > >> > >>> and sqlplus is definitely not something that I'd like presenting to my > >>> users. > >> > >> > >> Do you know how SQL*Plus was called during Oracle V4? (And maybe > >> earlier, > >> but this is as far as my history with Oracle goes) > >> > >> They called it UFI, which means User Friendly Interface! > >> > >> Regards, Carel-Jan > >> > >> -- There will allways be another 10 last bugs -- > >> > >>-- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >> Author: Carel-Jan Engel > >> 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). > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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: Carel-Jan Engel > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intend
RE: Re[2]: var source_data varchar2(12)
P was Program... it was the Y/N program file. -Original Message- Sent: Monday, November 17, 2003 11:54 AM To: Multiple recipients of list ORACLE-L IAD was the executable (on VMS) that the Sql*Forms command ran (D for Designer). IAG was to generate a form (G for Generate). IAP to execute it (P for something that I can't remember). This was SqlForms 3.0. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 17, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hope you don't mind the intrusion... I used HLI back in 5.0.20 days, and the big problem converting in 5.1.22 when everything had to go to IAPXIT. When were IAP|IAG replaced with IAD? I thought that came in around 1.3... was it later? Because by v2 it was SQL*Forms... Bambi. On 11/17/2003 06:14:24 AM, Carel-Jan Engel wrote: > Mladen, we must have started in the same era. You're describing the > environment I started with, however, our disk was 10MB. So you remember > SQL*Forms 1.3 (IAC/IAG/IAP) and HLI as well? > > > Carel, I know that. That was my first oracle version. I installed V4 on an > > IBM > > PC/XT with WD 20MB hard drive and two 5.25 floppy drives which could > > each hold 360k of information. Yes, you read it correctly. It was 20 MB > > hard drive, not 20 GB. OS was the unforgettable DOS 3.0 and the graphic > > card was called "Hercules". I don't know why was it called "graphic card" > > because it didn't have any graphic. The first real graphic was CGA and > > then > > EGA, VGA, XGA on PS/2 (IBM PS/2, not Playstation 2) and SVGA. > > > > On 2003.11.16 21:04, Carel-Jan Engel wrote: > >> Hi Mladen, > >> > >> At 06:19 12-11-03 -0800, you wrote: > >>> SQL*Plus has a ghastly and disgusting user interface, > >>> implemented without "readline" or equivalent, which would give a > >>> command > >>> history. > >>> Littering the system with those @#$%! afiedt.buf files is bad enough > >>> but > >>> line > >>> editting commands are an indicator of how much oracle cares for the > >>> user > >>> interface. > >> > >>> and sqlplus is definitely not something that I'd like presenting to my > >>> users. > >> > >> > >> Do you know how SQL*Plus was called during Oracle V4? (And maybe > >> earlier, > >> but this is as far as my history with Oracle goes) > >> > >> They called it UFI, which means User Friendly Interface! > >> > >> Regards, Carel-Jan > >> > >> -- There will allways be another 10 last bugs -- > >> > >>-- > >> Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >> Author: Carel-Jan Engel > >> 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). > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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: Carel-Jan Engel > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of
building a reporting database
hi i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good. - using aq and dq message processing - using snapshot replication - using ro standby databases. the last one will lag in data since standby database caanot have any archival log applied when opened in read only. is there any other good method to do this . my database is on 8.1.7.4 thanks sai
RE: building a reporting database
Sai - In your first sentence, you ask about modeling. Then the rest of your posting appears to relate to data movement? Which topic are you interested in discussing? For data movement, the best method often relates to the amount of data you estimate you will be moving, and how often. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 17, 2003 11:59 AM To: Multiple recipients of list ORACLE-L hi i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good. - using aq and dq message processing - using snapshot replication - using ro standby databases. the last one will lag in data since standby database caanot have any archival log applied when opened in read only. is there any other good method to do this . my database is on 8.1.7.4 thanks sai -- 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).
RE: how can I make Oracle not use all processors in machine?
Helmut Tanel's understanding matches mine. CPU-based licensing makes it wise to install Oracle only on servers used exclusively for Oracle. You might also consider Oracle Standard Edition licensing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 17, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi! You should check the licensing agreements first, AFAIK you need a licence for each CPU in server, it doesn't matter how many of them you actually use. Also I haven't heard that HP-UX supported CPU affinity anyway... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 3:04 PM > Hi! > > We are currently discussing Oracle licensing issues. Due to the number of > users, named user licensing is not an option for us. > > Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we > are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is > this possible (i.e. via the parameter cpu_count)? > The other 6 CPU's will then be used by other applications ion the box (e.g. > BEA WebLogic etc.). > > This is 9.2 on HP-UX 11.11. > > Thanks, > Helmut > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daiminger, Helmut > 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: Tanel Poder 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: software deployment control
Ron The organization that is providing concepts behind improving deployment processes is ITIL. Start at http://www.itil.org. This is not a software package (but some software packages comply with ITIL's concepts). It isn't even a set of procedures, but a set of processes that will assist you in creating procedures that will work for your particular organization. Does your organization have or plan a service desk? This process will integrate the service desk with your deployment procedures. Overall, the idea is a closed-loop process between incident reporting, incident tracking, change request, and deployment. Organizations often start this in a phased manner, beginning with one or two pieces. But it really helps if you understand where you're headed. In terms of improving the quality of deployment, most of us have test and production environments. Consider adding a third, QA or staging. This is a clone of production. The changes are first applied to staging and then tested. If the tests are satisfactory, then the exact changes are made to production. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 17, 2003 7:15 AM To: Multiple recipients of list ORACLE-L List, I have been asked to produce a process for documenting the request,test,deployment, etc of the server OS, client OS, and databases that we use. I have googled for 'software deployment control' and 'software change management' without much success. We are looking for a written procedure not a purchased software package. Does anyone have a source location for documentation so I can start on my project. Thanks, Ron Aren't IT audits fun??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bad performance because of wrong characterset?
Hi! Only string manipulation/comparision is slower with variable width charsets than with fixed width ones, because with variable width ones (UTF-8) you have to check the highest bit of each byte to check whether it shows that the next byte is "part of" current character or is part of next character. So, this means more CPU usage. But, if you migrate your whole database from UTF-8 to UTF-16 and you got a lot of character data, your database overall performance might get worse, since your strings get larger in bytes and retrieving 100 rows might mean reading 20 blocks instead of 10 like in the past. Performance depends on a lot of things, such how much string operations you got, what are the contents of your strings (are they mainly latin chars or are there lots of asian ones etc..). Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 4:54 PM > Carel-Jan, > > About two weeks ago, Faan DeSwardt <[EMAIL PROTECTED]> posted to the thread > "Unicode: UTF-16 to UTF-8 conversion", saying UTF-8 is variable-length encoding > and so is slower than the fixed-width UTF-16, and also US7ASCII. Maybe it's the > same issue here comparing UTF-8 with WE8ISO8859P15. Faan can comment. > > Yong Huang > > --- Carel-Jan Engel <[EMAIL PROTECTED]> wrote: > > Hi List, > > > > One of my customers gets HP Servicedesk 4.5 implemented. The database that > > has been created by on of the DBA's for the application is Oracle 8.1.7.4, > > on AIX 4.3. > > > > The database has characterset UTF8, which is the standard here. > > > > Now ServiceDesk has bad performance. HP claims that the characterset is > > wrong, and a new database has to be created with character set > > WE8ISO8859P15. > > > > I've never heard of bad performance due to differences in character sets, > > probably because of my lack of experience. Anyone familiar with this > > issue? > > > > TIA, Carel-Jan > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > 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: Tanel Poder 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: building a reporting database
dennis i am sorry to have been real unclear. data movement is what i am interested in.
RE: Re[2]: var source_data varchar2(12)
Bellow, Bambi scribbled on the wall in glitter crayon: Do you know how SQL*Plus was called during Oracle V4? (And maybe earlier, but this is as far as my history with Oracle goes) They called it UFI, which means User Friendly Interface! > > > And that dreaded afiedt.buf came was a copy of the "Advanced User > Friendly Interface Buffer" (edt was VMS's editor back then) EDT and EVE RULZ! that was back when Oracle was developed on VMS. a... the good old days. anybody remember TECO?;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Love is a fire. But whether it is going to warm your hearth or burn down your house, you can never tell. - Joan Crawford -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: granting SELECT privilege on SYS.X$ TABLES
Yet another case of the right hand not knowing what the left hand is doing. Now I'm curious to find out which team is creating those x_$ views. > -Original Message- > Mark Leith > > Check out Jacques e-mail address - he *works* for Quest ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: granting SELECT privilege on SYS.X$ TABLES
Boy do I feel stupid! Thank you Mr. Khedr and Mr. Breitling. I know the views are there, but at first I thought that maybe there were being created as part of the database creation process in some cases. In the first database I looked at, the X_$ views had the same creation date as the database creation date, but then one of the programmers here might have used a Quest tool on the database on the same day it was created. Now I see that in the other databases that have those views, the views were created later. I'll have to find out which product does that, most of the quest products create objects staring with QUEST (e.g. QUEST_XXX_X$KTFBUE) - actually AFAIK it's the rule for any object created in the database - but it does seem like there's one that doesn't use that naming convention. > -Original Message- > Wolfgang Breitling > > Someone must have created sys.x_$ views on some of the sys.x$ tables. > Installing statspack does that for example for X$KCBFWAIT, X$KSPPSV, > X$KSPPI, and X$KSQST. Do you have quest? I believe it does it > for some of > the x$ tables as well. I routinely do it for all x$ tables in my test > databases and grant select to the select_catalog_role. Then I > can access > the x$tables without having to log on as sys. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: software deployment control
Dennis, Thanks for the reply and I appreciate the starting URL. We have a service or help desk already and I would like to make it browser based but I am banging my head against the wall of "we don't use it or need it why train for it" mentality. You mentioned the particular servers that are available to use for deployment in your location. We have a development server with 2 years worth of data for development and test purposes and a production server with 11 years worth of data. I would love to have a test server with a full compliment of production data but that is not going to happen. Heck I am keeping my test/play Linux box up to date data wise incase it is needed for disaster recovery purposes. The reason the process documentation is needed is it was recommended by the outside auditors when we had our audit in July. Thanks, Ron >>> [EMAIL PROTECTED] 11/17/2003 1:34:33 PM >>> Ron The organization that is providing concepts behind improving deployment processes is ITIL. Start at http://www.itil.org. This is not a software package (but some software packages comply with ITIL's concepts). It isn't even a set of procedures, but a set of processes that will assist you in creating procedures that will work for your particular organization. Does your organization have or plan a service desk? This process will integrate the service desk with your deployment procedures. Overall, the idea is a closed-loop process between incident reporting, incident tracking, change request, and deployment. Organizations often start this in a phased manner, beginning with one or two pieces. But it really helps if you understand where you're headed. In terms of improving the quality of deployment, most of us have test and production environments. Consider adding a third, QA or staging. This is a clone of production. The changes are first applied to staging and then tested. If the tests are satisfactory, then the exact changes are made to production. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 17, 2003 7:15 AM To: Multiple recipients of list ORACLE-L List, I have been asked to produce a process for documenting the request,test,deployment, etc of the server OS, client OS, and databases that we use. I have googled for 'software deployment control' and 'software change management' without much success. We are looking for a written procedure not a purchased software package. Does anyone have a source location for documentation so I can start on my project. Thanks, Ron Aren't IT audits fun??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: 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: Ron Rogers 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: Configuring multi-threaded server
When I do "lsnrctl services", I get two entries for each instance. For example: tawk has 1 service handler(s) DEDICATED SERVER established:33 refused:0 LOCAL SERVER tawk has 2 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 (ADDRESS=(PROTOCOL=tcp)(HOST=bvdesi02.esid.northgrum.com)(PORT=33420)) It looks like the listener is ignoring the second entry. Any idea what is going on here? Thanks, Peter Schauss -Original Message- Sent: Monday, November 17, 2003 11:55 AM To: Multiple recipients of list ORACLE-L You have to make sure the dispatchers are registered with the listener. Use "lsnrctl services" to make sure. The error you gave shows that they are not registered. If your listener is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the dispatcher and > servers. When I connect to the database with sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available handler for requested type > of > server -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Silly SQL Question
The original question was "show me the users who have ALL the values in the list but NOT MORE than the values in the list." > -Original Message- > Bellow, Bambi > > Huh? I thought the question was, "give me all the usrs where > there exists a > record containing a 1,5, and 7". How can that return one > record, when there > are two users -- and only two users -- who have the 1,5,7 > combination? The > data provided shows that both GAP and GPA have a 1, 5 and 7 > and that no > other users do. My query provides that answer. If that wasn't the > question, then that won't be the answer; but if it *was* the > question, then > the query is correct. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: Re[2]: var source_data varchar2(12)
make love -Original Message- Sent: Monday, November 17, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Bellow, Bambi scribbled on the wall in glitter crayon: Do you know how SQL*Plus was called during Oracle V4? (And maybe earlier, but this is as far as my history with Oracle goes) They called it UFI, which means User Friendly Interface! > > > And that dreaded afiedt.buf came was a copy of the "Advanced User > Friendly Interface Buffer" (edt was VMS's editor back then) EDT and EVE RULZ! that was back when Oracle was developed on VMS. a... the good old days. anybody remember TECO?;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Love is a fire. But whether it is going to warm your hearth or burn down your house, you can never tell. - Joan Crawford -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Bellow, Bambi 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: Re[2]: var source_data varchar2(12)
Well, not all hope is lost. Look at the following URL's: http://www.makalis.fr/~bertrand/FreeVMS/indexGB.html http://www.bosbc.com/ The second one is a commercial product, but certainly provides a familiar layer. On 11/17/2003 02:04:25 PM, "Thater, William" wrote: > Bellow, Bambi scribbled on the wall in glitter crayon: > > Do you know how SQL*Plus was called during Oracle V4? (And maybe > earlier, but this is as far as my history with Oracle goes) > > They called it UFI, which means User Friendly Interface! > > > > > > > And that dreaded afiedt.buf came was a copy of the "Advanced User > > Friendly Interface Buffer" (edt was VMS's editor back then) > > EDT and EVE RULZ! that was back when Oracle was developed on VMS. a... > the good old days. anybody remember TECO?;-) > > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song > [EMAIL PROTECTED] > > Love is a fire. But whether it is going to warm your hearth or burn down > your house, you can never tell. - Joan Crawford > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thater, William > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Bad performance because of wrong characterset?
At 10:34 17-11-03 -0800, you wrote: Performance depends on a lot of things, such how much string operations you got, what are the contents of your strings (are they mainly latin chars or are there lots of asian ones etc..). Tanel. Thanks Tanel for your respond. I doubt whether a query will go from several minutes to seconds, even when a fixed-width single-byte characterset is chosen. I'm not supposed to interfere with this Service Desk project, but just couldn't keep my mouth shut when I heard HP scheduled a meeting for tomorrow (when I'm not there) and claimed that recreation of a database with the proper characterset would do the job. I suggested to do some tracing & analysis first, before start shooting at a moving target in the dark. And of course posted the question to this bunch of knowledgable people. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan 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: Silly SQL Question
Just a guess: select distinct usr from xxx where (select count(*) from xxx group by Usr) = (select count(*) from xxx group by Usr, val) -Original Message- Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Gabriel Aragon wrote: > > I have a table with like this: > > Usr val > -- > GAP 1 > GAP 5 > GAP 7 > JKL 8 > JKL 5 > > I need a query that returns the user (GAP o JKL) that > has ALL the values in a list. Example: Having the > list: 1,5,7 the result will be GAP, but with the > values 1,5 or 1,5,7,8 there will be no result. > > select distinct usr > from xxx > where val = All (1,3,5) > > I was trying the ALL operator but it works with part > of the list, I need the user that has (exactly) all > the values in the list. Any idea? > > Maybe it's a simple solution, but after several hours > I feel blocked. > > TIA > Gabriel > select usr from XXX where val in (list) group by usr having count(*) = number of values in list does it but assumes that (usr, val) is unique (which can be easily worked-around : select usr from (select distinct usr, val from XXX) group by ... ) and also that you know both the list and the number of items in the list, which looks reasonable. If your intent is to build the queries and the list dynamically, I'd rather suggest storing the list into a temporary table. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Bad performance because of wrong characterset?
Thanks Yong. I doubt whether this can have such a significant effect, or it must be that due to some incompatability an index can't be used (or simply isn't even there). They have to trace the session, alas I'm not allowed to touch the system (other project, other budget blah blah) At 06:54 17-11-03 -0800, you wrote: Carel-Jan, About two weeks ago, Faan DeSwardt <[EMAIL PROTECTED]> posted to the thread "Unicode: UTF-16 to UTF-8 conversion", saying UTF-8 is variable-length encoding and so is slower than the fixed-width UTF-16, and also US7ASCII. Maybe it's the same issue here comparing UTF-8 with WE8ISO8859P15. Faan can comment. Yong Huang Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan 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: Re[2]: var source_data varchar2(12)
We've purchased nuTPU from aSoft: http://www.asoft-dev.com/tpu_info.htm It's very good, although most of my low level EVE replacements don't work (e.g. off-screen cursor handling, custom comment handling, etc.). Development appears to be stopped as there have been no new patches or versions in a few years, but I like the idea of the stability. I also use an old version of microEMACS (uemacs) on my beloved Amiga, which reminds me a lot of EDT. Rich [insert signature here, as MS Lookout/sExchange doesn't put them in your profile] -Original Message- Sent: Monday, November 17, 2003 1:25 PM To: Multiple recipients of list ORACLE-L Well, not all hope is lost. Look at the following URL's: http://www.makalis.fr/~bertrand/FreeVMS/indexGB.html http://www.bosbc.com/ The second one is a commercial product, but certainly provides a familiar layer. On 11/17/2003 02:04:25 PM, "Thater, William" wrote: > Bellow, Bambi scribbled on the wall in glitter crayon: > > Do you know how SQL*Plus was called during Oracle V4? (And maybe > earlier, but this is as far as my history with Oracle goes) > > They called it UFI, which means User Friendly Interface! > > > > > > > And that dreaded afiedt.buf came was a copy of the "Advanced User > > Friendly Interface Buffer" (edt was VMS's editor back then) > > EDT and EVE RULZ! that was back when Oracle was developed on VMS. a... > the good old days. anybody remember TECO?;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Silly SQL Question
Using Bambi's table and values. Try this query, it's ugly but it works (kind of like the contributor...) Daniel 1 select o.usr, count(o.usr) 2 from (select distinct usr, val 3from gab 4where val in (1,5,7) 5 and usr not in (select usr 6 from gab 7 where val not in (1,5,7))) o 8 group by o.usr 9* having count(o.usr) = 3 Jacques Kilchoer wrote: > The original question was "show me the users who have ALL the values in the list but > NOT MORE than the values in the list." > > > -Original Message- > > Bellow, Bambi > > > > Huh? I thought the question was, "give me all the usrs where > > there exists a > > record containing a 1,5, and 7". How can that return one > > record, when there > > are two users -- and only two users -- who have the 1,5,7 > > combination? The > > data provided shows that both GAP and GPA have a 1, 5 and 7 > > and that no > > other users do. My query provides that answer. If that wasn't the > > question, then that won't be the answer; but if it *was* the > > question, then > > the query is correct. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jacques Kilchoer > 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: Daniel Fink 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: Re[2]: var source_data varchar2(12)
Bellow, Bambi scribbled on the wall in glitter crayon: > make love not war -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] The knack of flying is learning how to throw yourself at the ground and miss. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Configuring multi-threaded server
Peter, If you declare in the init.ora file where the listener is running, then the database automatically connects to the listener. This is the second tawk entry in your lsnrctl status listing. If you declare the database in the listener.ora file, then the listener goes looking for the database, thus the other entry in your output. I now remove the database entry in the listener.ora file, and keep all my connection info in the init.ora file. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 17, 2003 2:14 PM To: Multiple recipients of list ORACLE-L When I do "lsnrctl services", I get two entries for each instance. For example: tawk has 1 service handler(s) DEDICATED SERVER established:33 refused:0 LOCAL SERVER tawk has 2 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 (ADDRESS=(PROTOCOL=tcp)(HOST=bvdesi02.esid.northgrum.com)(PORT=33420)) It looks like the listener is ignoring the second entry. Any idea what is going on here? Thanks, Peter Schauss -Original Message- Sent: Monday, November 17, 2003 11:55 AM To: Multiple recipients of list ORACLE-L You have to make sure the dispatchers are registered with the listener. Use "lsnrctl services" to make sure. The error you gave shows that they are not registered. If your listener is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the dispatcher and > servers. When I connect to the database with sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available handler for requested type > of > server -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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: Configuring multi-threaded server
Thanks for all of the suggestions. I took a look at my init.ora file and discovered that I had the services and db_domain entries disagreed with the database global_name value and. I fixed those entries, bounced the database and the connections started coming in on the shared server. Peter Schauss -Original Message- Sent: Monday, November 17, 2003 2:14 PM To: Multiple recipients of list ORACLE-L When I do "lsnrctl services", I get two entries for each instance. For example: tawk has 1 service handler(s) DEDICATED SERVER established:33 refused:0 LOCAL SERVER tawk has 2 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 (ADDRESS=(PROTOCOL=tcp)(HOST=bvdesi02.esid.northgrum.com)(PORT=33420)) It looks like the listener is ignoring the second entry. Any idea what is going on here? Thanks, Peter Schauss -Original Message- Sent: Monday, November 17, 2003 11:55 AM To: Multiple recipients of list ORACLE-L You have to make sure the dispatchers are registered with the listener. Use "lsnrctl services" to make sure. The error you gave shows that they are not registered. If your listener is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the dispatcher and > servers. When I connect to the database with sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available handler for requested type > of > server -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Schauss, Peter 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: Bad performance because of wrong characterset?
Here's a wild guess. If the character set is changed, a 10 MB segment (from the first extent to high water mark) may become 20 MB or 5 MB. Then CBO changes the plan and it happens to be a bad one. Yong Huang --- Carel-Jan <[EMAIL PROTECTED]> wrote: > At 10:34 17-11-03 -0800, you wrote: > > >Performance depends on a lot of things, such how much string operations you > >got, what are the contents of your strings (are they mainly latin chars or > >are there lots of asian ones etc..). > > > >Tanel. > > Thanks Tanel for your respond. I doubt whether a query will go from several > minutes to seconds, even when a fixed-width single-byte characterset is > chosen. I'm not supposed to interfere with this Service Desk project, but > just couldn't keep my mouth shut when I heard HP scheduled a meeting for > tomorrow (when I'm not there) and claimed that recreation of a database > with the proper characterset would do the job. I suggested to do some > tracing & analysis first, before start shooting at a moving target in the > dark. And of course posted the question to this bunch of knowledgable people. > > > Regards, Carel-Jan __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: Re[2]: var source_data varchar2(12)
Bill, that's a wrong answer. The correct answer is "make love, not children". On 11/17/2003 02:54:42 PM, "Thater, William" wrote: > Bellow, Bambi scribbled on the wall in glitter crayon: > > > make love > not war > > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song > [EMAIL PROTECTED] > > The knack of flying is learning how to throw yourself at the ground and > miss. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thater, William > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Bad performance because of wrong characterset?
No characterset changed yet. They want us to recreate the database. the system is going live in a few weeks. I simply hate changing things because someone says so. It might be the quickest solution, but most probably not, and then it's a waste of time, energy etc. Here's a wild guess. If the character set is changed, a 10 MB segment (from the first extent to high water mark) may become 20 MB or 5 MB. Then CBO changes the plan and it happens to be a bad one. Yong Huang Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan 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: Bad performance because of wrong characterset?
Carel-Jan Look at it this way. Easier to fix the character set now. And if the performance is still bad, then they've got one less excuse. Being a DBA means learning to live with disappointment. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 17, 2003 2:24 PM To: Multiple recipients of list ORACLE-L No characterset changed yet. They want us to recreate the database. the system is going live in a few weeks. I simply hate changing things because someone says so. It might be the quickest solution, but most probably not, and then it's a waste of time, energy etc. >Here's a wild guess. If the character set is changed, a 10 MB segment >(from the >first extent to high water mark) may become 20 MB or 5 MB. Then CBO >changes the >plan and it happens to be a bad one. > >Yong Huang Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: var source_data varchar2(12)
No, sorry, that is the correct answer. The original question was "Does anyone remember TECO?" In TECO, if you entered the command "make love", it would respond "not war". Two points to Bill and thanks for the smile to both, Bambi. -Original Message- Sent: Monday, November 17, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Bill, that's a wrong answer. The correct answer is "make love, not children". On 11/17/2003 02:54:42 PM, "Thater, William" wrote: > Bellow, Bambi scribbled on the wall in glitter crayon: > > > make love > not war > > -- > Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song > [EMAIL PROTECTED] > > The knack of flying is learning how to throw yourself at the ground and > miss. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thater, William > 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). > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Bellow, Bambi 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: Configuring multi-threaded server
If you remove the database declarations from your listener.ora file does it cause a problem if the listener is not running when the database comes up? Thanks, Peter Schauss -Original Message- Sent: Monday, November 17, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Peter, If you declare in the init.ora file where the listener is running, then the database automatically connects to the listener. This is the second tawk entry in your lsnrctl status listing. If you declare the database in the listener.ora file, then the listener goes looking for the database, thus the other entry in your output. I now remove the database entry in the listener.ora file, and keep all my connection info in the init.ora file. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 17, 2003 2:14 PM To: Multiple recipients of list ORACLE-L When I do "lsnrctl services", I get two entries for each instance. For example: tawk has 1 service handler(s) DEDICATED SERVER established:33 refused:0 LOCAL SERVER tawk has 2 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 (ADDRESS=(PROTOCOL=tcp)(HOST=bvdesi02.esid.northgrum.com)(PORT=33420)) It looks like the listener is ignoring the second entry. Any idea what is going on here? Thanks, Peter Schauss -Original Message- Sent: Monday, November 17, 2003 11:55 AM To: Multiple recipients of list ORACLE-L You have to make sure the dispatchers are registered with the listener. Use "lsnrctl services" to make sure. The error you gave shows that they are not registered. If your listener is not on 1521, then the dispatchers won't know how to find it to register. You'll have to add the listener= atttribute to the mts_dispatchers parameter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 17 Nov 2003, Schauss, Peter wrote: > Oracle version 8.1.7 > AIX 4.3.3 > > I am trying to configure mult-threaded server on one of my development > databases. In my init.ora file, I set > > (mts_dispatchers="(address=(protocol=tcp))" > mts_servers=10 > > When I bring up the database, I can see the dispatcher and > servers. When I connect to the database with sqlnet, however, > it still gives me a dedicated server. > > I tried forcing the connection by putting (server=shared) into > the tnsnames.ora file on my client. Then I get: > > ORA-12520: TNS:listener could not find available handler for requested type > of > server -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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: Schauss, Peter 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 PROT
RE: Silly SQL Question
Gabriel, How about this untested code? Alan. select usr from ( select usr, sum(decode(val,1,1,0)) look1, -- flag for 1 sum(decode(val,5,5,0)) look2, -- flag for 5 sum(decode(val,7,7,0)) look3, -- flag for 7 sum(decode(val,1,0,5,0,7,0,1)) look4 -- flag for others from the_table group by usr ) where look1 = 1 AND look2 = 1 AND look3 = 1 AND look4 = 0 / -Original Message- Sent: Thursday, November 13, 2003 2:05 PM To: Multiple recipients of list ORACLE-L I have a table with like this: Usr val -- GAP 1 GAP 5 GAP 7 JKL 8 JKL 5 I need a query that returns the user (GAP o JKL) that has ALL the values in a list. Example: Having the list: 1,5,7 the result will be GAP, but with the values 1,5 or 1,5,7,8 there will be no result. select distinct usr from xxx where val = All (1,3,5) I was trying the ALL operator but it works with part of the list, I need the user that has (exactly) all the values in the list. Any idea? Maybe it's a simple solution, but after several hours I feel blocked. TIA Gabriel __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Alan Gano 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).
Reducing rollback segment tablespace sizes
I have a client where rollback segments were set up RBS01-RBS05, all in a tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, I shrank the segments to themselves down to less than 500MB total from 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let me resize it at all (it has extents scattered throughout). Anyone know how I go about shrinking it? Do I have to create a new tablespace/datafile, then drop the old one? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: software deployment control
Looks like someone has been tapped for Sarbanes Oxley. "Ron Rogers" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/17/2003 05:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: software deployment control List, I have been asked to produce a process for documenting the request,test,deployment, etc of the server OS, client OS, and databases that we use. I have googled for 'software deployment control' and 'software change management' without much success. We are looking for a written procedure not a purchased software package. Does anyone have a source location for documentation so I can start on my project. Thanks, Ron Aren't IT audits fun??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Reducing rollback segment tablespace sizes
Michael Milligan wrote: > > I have a client where rollback segments were set up RBS01-RBS05, all in a > tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, > I shrank the segments to themselves down to less than 500MB total from > 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let > me resize it at all (it has extents scattered throughout). Anyone know how I > go about shrinking it? Do I have to create a new tablespace/datafile, then > drop the old one? > > TIA, > > Michael Milligan > Oracle DBA > Ingenix, Inc. > 2525 Lake Park Blvd. > Salt Lake City, Utah 84120 > wrk 801-982-3081 > mbl 801-628-6058 > [EMAIL PROTECTED] > Waow !!! A true, live Oracle 6 database ? AFAIK, PCTINCREASE has been hard-coded to 0 for rollback segments since the beginnings of Oracle 7. Concerning your question, it all depends on where your existing rollback segments are located in the datafile (look at dba_extents). All you have to do is drop and recreate each roolback segment in tirn. Now, if this really is an Oracle6 database, RESIZE doesn't work ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how can I make Oracle not use all processors in machine?
Actually, I believe it is even more restrictive than that. It doesn't matter how many CPU's are in the machine, what matters is how many CPU's the machine is capable of holding. So what they are really licensing is not the # of CPU's, but the class of the machine. Try digging in the archives, this has been discussed recently. Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/17/2003 07:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: how can I make Oracle not use all processors in machine? Hi! You should check the licensing agreements first, AFAIK you need a licence for each CPU in server, it doesn't matter how many of them you actually use. Also I haven't heard that HP-UX supported CPU affinity anyway... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 3:04 PM > Hi! > > We are currently discussing Oracle licensing issues. Due to the number of > users, named user licensing is not an option for us. > > Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we > are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is > this possible (i.e. via the parameter cpu_count)? > The other 6 CPU's will then be used by other applications ion the box (e.g. > BEA WebLogic etc.). > > This is 9.2 on HP-UX 11.11. > > Thanks, > Helmut > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daiminger, Helmut > 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: Tanel Poder 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: Reducing rollback segment tablespace sizes
Micheal, Could you shrink the rbs even smaller? This should work if the first two extents of each rbs are in the 'first' blocks of the datafile. If not, the best solution is to create new smaller ones as you drop the others and then resize. Regardless of the solution, do this during a slow time to reduce the chance of a 1555. Daniel Fink Michael Milligan wrote: > I have a client where rollback segments were set up RBS01-RBS05, all in a > tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, > I shrank the segments to themselves down to less than 500MB total from > 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let > me resize it at all (it has extents scattered throughout). Anyone know how I > go about shrinking it? Do I have to create a new tablespace/datafile, then > drop the old one? > > TIA, > > Michael Milligan > Oracle DBA > Ingenix, Inc. > 2525 Lake Park Blvd. > Salt Lake City, Utah 84120 > wrk 801-982-3081 > mbl 801-628-6058 > [EMAIL PROTECTED] > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity to > which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified that > any dissemination, distribution or copying of this e-mail is prohibited. If > you have received this e-mail in error, please notify the sender by replying > to this message and delete this e-mail immediately. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Michael Milligan > 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: Daniel Fink 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: Bad performance because of wrong characterset?
DENNIS WILLIAMS wrote: > Being a DBA means learning to live with disappointment. Well said, well spoken, Dennis. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink 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: Reducing rollback segment tablespace sizes
The high water mark for the rollback segments is preventing you from shrinking the files. Use "alter rollback segment storage ( optimal ) " to set an optimal size for the segment, then use 'alter rollback segment shrink' to shrink the rollback. You may want to unset the optimal size when done by using NULL for the optimal size. I haven't tried this on a rollback segment with the intent of shrinking the data files, so I'm not sure it will do the trick. In that case, you can either just create a new rollback tablespace with new rbs segments, and then drop the old ones, or just drop all but the first of the rollback segments, then try your shrink of the datafile, and recreate the rbs segments. If you create a new tablespace, keep in mind that there may be scripts ( backup, etc) with the tablespace name hardcoded in them. Bad form, but it happens. HTH Jared Michael Milligan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/17/2003 01:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Reducing rollback segment tablespace sizes I have a client where rollback segments were set up RBS01-RBS05, all in a tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, I shrank the segments to themselves down to less than 500MB total from 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let me resize it at all (it has extents scattered throughout). Anyone know how I go about shrinking it? Do I have to create a new tablespace/datafile, then drop the old one? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Reducing rollback segment tablespace sizes
Thanks for the info. It's 8.1.7.4, and it's not hard-coded. I changed it from 50% to 0%, but the damage had been done. Maybe you're just nostalgiac for the good old days of v6! I did set an optimal, and used shrink. That worked fine to shrink the segments, but they are still scattered throughout the tablespace, preventing me from resizing the datafile. Thanks, Mike -Original Message- Sent: Monday, November 17, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Michael Milligan wrote: > > I have a client where rollback segments were set up RBS01-RBS05, all in a > tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, > I shrank the segments to themselves down to less than 500MB total from > 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let > me resize it at all (it has extents scattered throughout). Anyone know how I > go about shrinking it? Do I have to create a new tablespace/datafile, then > drop the old one? > > TIA, > > Michael Milligan > Oracle DBA > Ingenix, Inc. > 2525 Lake Park Blvd. > Salt Lake City, Utah 84120 > wrk 801-982-3081 > mbl 801-628-6058 > [EMAIL PROTECTED] > Waow !!! A true, live Oracle 6 database ? AFAIK, PCTINCREASE has been hard-coded to 0 for rollback segments since the beginnings of Oracle 7. Concerning your question, it all depends on where your existing rollback segments are located in the datafile (look at dba_extents). All you have to do is drop and recreate each roolback segment in tirn. Now, if this really is an Oracle6 database, RESIZE doesn't work ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Reducing rollback segment tablespace sizes
Daniel, Thank you very much. I'll do what you suggested, on both counts. I'll try shrinking them more first, then create new ones if needed. Thanks again, Mike -Original Message- Sent: Monday, November 17, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Micheal, Could you shrink the rbs even smaller? This should work if the first two extents of each rbs are in the 'first' blocks of the datafile. If not, the best solution is to create new smaller ones as you drop the others and then resize. Regardless of the solution, do this during a slow time to reduce the chance of a 1555. Daniel Fink Michael Milligan wrote: > I have a client where rollback segments were set up RBS01-RBS05, all in a > tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, > I shrank the segments to themselves down to less than 500MB total from > 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let > me resize it at all (it has extents scattered throughout). Anyone know how I > go about shrinking it? Do I have to create a new tablespace/datafile, then > drop the old one? > > TIA, > > Michael Milligan > Oracle DBA > Ingenix, Inc. > 2525 Lake Park Blvd. > Salt Lake City, Utah 84120 > wrk 801-982-3081 > mbl 801-628-6058 > [EMAIL PROTECTED] > > This e-mail, including attachments, may include confidential and/or > proprietary information, and may be used only by the person or entity to > which it is addressed. If the reader of this e-mail is not the intended > recipient or his or her authorized agent, the reader is hereby notified that > any dissemination, distribution or copying of this e-mail is prohibited. If > you have received this e-mail in error, please notify the sender by replying > to this message and delete this e-mail immediately. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Michael Milligan > 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: Daniel Fink 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, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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).
reporting database
hi data movement for a reporting database from a OLTP intensive db is what i am interested in.
Re: how can I make Oracle not use all processors in machine?
We can buy machines with the CPUs installed but turned off and only activate them when needed. I don't think we need to license Oracle for the CPUs that are turned off. Regards, Denny -- Denny Koovakattu Quoting [EMAIL PROTECTED]: > Actually, I believe it is even more restrictive than that. > > It doesn't matter how many CPU's are in the machine, what matters > is how many CPU's the machine is capable of holding. > > So what they are really licensing is not the # of CPU's, but > the class of the machine. > > Try digging in the archives, this has been discussed recently. > > Jared > > > > > > "Tanel Poder" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/17/2003 07:04 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: how can I make Oracle not use all processors in > machine? > > > Hi! > > You should check the licensing agreements first, AFAIK you need a licence > for each CPU in server, it doesn't matter how many of them you actually > use. > > Also I haven't heard that HP-UX supported CPU affinity anyway... > > Tanel. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, November 17, 2003 3:04 PM > > > > Hi! > > > > We are currently discussing Oracle licensing issues. Due to the number > of > > users, named user licensing is not an option for us. > > > > Our HP-boxes are having 10 processors each. Since the CPU's are 90% > idle, > we > > are thinking about limiting Oracle to only using 4 out of the 10 CPUs. > Is > > this possible (i.e. via the parameter cpu_count)? > > The other 6 CPU's will then be used by other applications ion the box > (e.g. > > BEA WebLogic etc.). > > > > This is 9.2 on HP-UX 11.11. > > > > Thanks, > > Helmut > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Daiminger, Helmut > > 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: Tanel Poder > 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 message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu 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: Re[2]: var source_data varchar2(12)
$ make lovemake: *** No rule to make target `love'. Stop. - Original Message - From: "Bellow, Bambi" <[EMAIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 9:24 PM Subject: RE: Re[2]: var source_data varchar2(12) > make love> > -Original Message-> Sent: Monday, November 17, 2003 1:04 PM> To: Multiple recipients of list ORACLE-L> > > Bellow, Bambi scribbled on the wall in glitter crayon:> > Do you know how SQL*Plus was called during Oracle V4? (And maybe> earlier, but this is as far as my history with Oracle goes)> > They called it UFI, which means User Friendly Interface!> > > > > > > And that dreaded afiedt.buf came was a copy of the "Advanced User> > Friendly Interface Buffer" (edt was VMS's editor back then)> > EDT and EVE RULZ! that was back when Oracle was developed on VMS. a...> the good old days. anybody remember TECO?;-)> > --> Bill "Shrek" Thater ORACLE DBA > "I'm going to work my ticket if I can..." -- Gilwell song> [EMAIL PROTECTED]> > Love is a fire. But whether it is going to warm your hearth or burn down> your house, you can never tell. - Joan Crawford > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: Thater, William> 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: Bellow, Bambi> 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: reporting database
Sai - All data in the database? How large, how active is the source database? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 17, 2003 4:10 PM To: Multiple recipients of list ORACLE-L hi data movement for a reporting database from a OLTP intensive db is what i am interested in. -- 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).
Re: Bad performance because of wrong characterset?
The "fun" part is that if the database will perform better after recreation for some reason, then the HP guys (and probably your bosses) will tell you, "we said so" or smth like that :) Of course when performance goes bad again after a week, HP guys will probably ask for a block size change + db reorg ;) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 10:24 PM > No characterset changed yet. They want us to recreate the database. the > system is going live in a few weeks. I simply hate changing things because > someone says so. It might be the quickest solution, but most probably not, > and then it's a waste of time, energy etc. > > >Here's a wild guess. If the character set is changed, a 10 MB segment > >(from the > >first extent to high water mark) may become 20 MB or 5 MB. Then CBO > >changes the > >plan and it happens to be a bad one. > > > >Yong Huang > > Regards, Carel-Jan > > -- There will allwasy be another 10 last bugs -- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Carel-Jan > 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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how can I make Oracle not use all processors in machine?
[EMAIL PROTECTED] wrote: Actually, I believe it is even more restrictive than that. It doesn't matter how many CPU's are in the machine, what matters is how many CPU's the machine is capable of holding. So what they are really licensing is not the # of CPU's, but the class of the machine. Try digging in the archives, this has been discussed recently. Jared We've licensed servers with less cpu's than they hold. According to our Oracle rep, this is fine. Number of actual cpu's only. Of course they like to check up to make sure you haven't added any recently ;) -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas 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: Bad performance because of wrong characterset?
I really hate to admit it, but I agree. Doing otherwise is a simple recipe for hypertension, stroke & an early death. Besides, it's so much more gratifying be able to say "I TOLD YOU SO". Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, November 17, 2003 4:50 PM To: Multiple recipients of list ORACLE-L DENNIS WILLIAMS wrote: > Being a DBA means learning to live with disappointment. Well said, well spoken, Dennis. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink 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: Goulet, Dick 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).
NEW: Second part of row level security paper
Hi Everyone, The second part of my new paper on row level security is out today. This part talks about the issues with row level security, the dictionary views that can be used to check configuration and also how to detect if row level security is used using trace and sql. There is a link to this paper at http://www.petefinnigan.com/orasec.htm if anyone is interested. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Silly SQL Question
Ok, guys I have to apologize twice,
First: the delay to answer your very kind emails, (you
know the urgent problems dont let you time for the
important ones)
Second: maybe my question was not clear enough,
ciertanly what Bambi says is what I need "give me all
the usrs where there exists a record containing 1 AND
5 AND 7", the criteria was the list, not the records,
so it does not matter if the user has many more
records, but if he/she has those records that are in
the list, that is what I want, the solution is as
simple as Bambi's query.
I really really appreciate all the solutions provided
for you guys, I swear I tested every one.
Below I have a copy of my original email.
Thank you very much!
Gabriel Aragon
+++
I have a table like this:
Usr val
--
GAP 1
GAP 5
GAP 7
JKL 8
JKL 5
I need a query that returns the user (GAP o JKL) that
has ALL the values in a list. Example: Having the
list: 1,5,7 the result will be GAP, but with the
values 1,5 or 1,5,7,8 there will be no result.
select distinct usr from xxx
where val = All (1,3,5)
I was trying the ALL operator but it works with part
of the list, I need the user that has (exactly) all
the values in the list. Any idea?
Maybe it's a simple solution, but after several hours
I feel blocked.
Gabriel
+++
--- "Bellow, Bambi" <[EMAIL PROTECTED]> wrote:
> Jacques --
>
> Huh? I thought the question was, "give me all the
> usrs where there exists a
> record containing a 1,5, and 7". How can that
> return one record, when there
> are two users -- and only two users -- who have the
> 1,5,7 combination? The
> data provided shows that both GAP and GPA have a 1,
> 5 and 7 and that no
> other users do. My query provides that answer. If
> that wasn't the
> question, then that won't be the answer; but if it
> *was* the question, then
> the query is correct.
>
> HTH,
> Bambi.
> =
>
> create table gab (usr char(3),val number);
> insert into gab values ('GAP',1);
> insert into gab values ('GAP',5);
> insert into gab values ('GAP',5);
> insert into gab values ('GAP',7);
> insert into gab values ('PAG',1);
> insert into gab values ('PAG',7);
> insert into gab values ('PAG',2);
> insert into gab values ('JKL',1);
> insert into gab values ('JKL',5);
> insert into gab values ('JKL',5);
> insert into gab values ('GPA',1);
> insert into gab values ('GPA',5);
> insert into gab values ('GPA',7);
> insert into gab values ('GPA',8);
>
> select usr from gab
> where val=1
> intersect
> select usr from gab
> where val=5
> intersect
> select usr from gab
> where val=7;
>
> USR
> ---
> GAP
> GPA
>
>
>
> -Original Message-
> Sent: Friday, November 14, 2003 7:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> > -Original Message-
> > Bellow, Bambi
> >
> > Why not do it like this...
> >
> > select usr from gab
> > where val=1
> > intersect
> > select usr from gab
> > where val=5
> > intersect
> > select usr from gab
> > where val=7;
>
>
> Because that way you would get the wrong answer.
> With the sample data as
> kindly provided by Mr. Begun the correct query would
> return one row, but
> your query returns two rows.
> SQL> select * from gab ;
>
> USR VAL
> -- -
> GAP1
> GAP5
> GAP5
> GAP7
> PAG1
> PAG7
> PAG2
> JKL1
> JKL5
> JKL5
> GPA1
> GPA5
> GPA7
> GPA8
>
> 14 ligne(s) sélectionnée(s).
>
> SQL> select usr from gab
> 2 where val=1
> 3 intersect
> 4 select usr from gab
> 5 where val=5
> 6 intersect
> 7 select usr from gab
> 8 where val=7;
>
> USR
> --
> GAP
> GPA
> --
=
"Any dream worth having is a dream worth fighting for"(Cualquier sueño que valga la
pena tener, es un sueño por el que vale la pena luchar)Charles Xavier
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gabriel Aragon
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: Silly SQL Question
Jacques Kilchoer wrote: > Mr. Begun: I'm not convinced that your answer is quite the right one. I've provided two solutions but I'm still confused :). Jacques, does that mean that I understand English and the original query was Ok? :) -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Gabriel Aragon wrote: Ok, guys I have to apologize twice, ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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: Bad performance because of wrong characterset?
Hi, Since everyone is just guessing, can you say more detail about the bad performance? High CPU usage with no idle so client wait for CPU time? or Low CPu usage but client still wait? or High disk io rate with 100% disk busy? Can you show us some data about your aix box and statspack of your current database? Zhu Chao. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 6:49 PM > Hi List, > > One of my customers gets HP Servicedesk 4.5 implemented. The database that > has been created by on of the DBA's for the application is Oracle 8.1.7.4, > on AIX 4.3. > > The database has characterset UTF8, which is the standard here. > > Now ServiceDesk has bad performance. HP claims that the characterset is > wrong, and a new database has to be created with character set > WE8ISO8859P15. > > I've never heard of bad performance due to differences in character sets, > probably because of my lack of experience. Anyone familiar with this > issue? > > TIA, Carel-Jan > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Carel-Jan Engel > 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: zhu chao 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: Why is Oracle process using 25 MB of RAM when idle?
Hi, I have also been researching on how to monitor oracle process memory utilization on different platform . And on hp, it seems more difficult. I once see a note on metalink talking about using kernel debugger on HP to detect it, here is a sample output, but I do not know the detailed meaning of different part. Hope some HP expert can answer it here. Oracle version is 9.2.0.1 and SGA is 840396160 bytes. $ ps -ef|grep 12436 oracle 12436 1 0 Nov 8 ? 0:47 ora_pmon_mimidb oracle 21385 21369 0 10:31:33 pts/ta0:00 grep 12436 $top result: TTY PID UID PRI NI SIZERES STATETIME %WCPU %CPU COMMAND ? 2454 101 154 20 3676K 1036K sleep0:10 0.02 0.02 tnslsnr ?12436 101 152 20 69696K 20332K run 0:47 0.02 0.02 ora_pmon_mimidb ?12438 101 156 20 69952K 21400K sleep0:58 0.02 0.02 ora_dbw0_mimidb # q4pxdb /stand/vmunix Processing Header Section... Processing GNTT Section... Processing LNTT Section... Procedures: 0 Processing SLT... Sorting Quick Lookup Tables... Re-writing ELF file... Done. # # ied q4 /stand/vmunix /dev/mem @(#) q4 $Revision: 1.79a $ $Date: 97/09/08 12:00:22 $ 0 q4: (warning) no modules in the crashdump or no INDEX file q4: (warning) q4 will try to read /dev/kmem for kernel access Reading kernel symbols ... Reading kernel data types ... /dev/mem: can't validate: expected size or checksum not available. Dump data may not be correct. Initialized PA-RISC 2.0 address translator ... Initializing stack tracer ... Get the latest Q4 news by typing "news". q4> load struct proc from proc max nproc loaded 276 struct proc's as an array (stopped by max count) q4> keep p_pid ==12436 kept 1 of 276 struct proc's, discarded 275 q4> q4> load struct vas from p_vas loaded 1 struct vas as an array (stopped by max count) q4> load struct pregion from va_ll.lle_prev next p_ll.lle_prev max 100 loaded 54 struct pregion's as a linked list (stopped by loop) q4> print -x p_type p_space p_vaddr p_count | more PT_SHMEM 0x427bc00 0xc400 0x33178 --sga size=833088K PT_MMAP 0x427bc00 0xc040 0x549 PT_MMAP 0x427bc00 0xc024 0x76 PT_MMAP 0x427bc00 0xc014 0xfb PT_MMAP 0x427bc00 0xc012 0x15 PT_MMAP 0x427bc00 0xc00f 0x26 PT_MMAP 0x427bc00 0xc00e8000 0x7 PT_MMAP 0x427bc00 0xc00d 0x16 PT_MMAP 0x427bc00 0xc00c4000 0x7 PT_MMAP 0x427bc00 0xc004 0x83 PT_MMAP 0x427bc00 0xc0038000 0x2 PT_MMAP 0x427bc00 0xc0034000 0x4 PT_MMAP 0x427bc00 0xc003 0x4 PT_MMAP 0x427bc00 0xc002c000 0x4 PT_MMAP 0x427bc00 0xc002a000 0x1 PT_MMAP 0x427bc00 0xc000 0x28 PT_STACK 0x44eb800 0x837f 0x10 PT_MMAP 0x44eb800 0x83fffc00 0x2 PT_MMAP 0x44eb800 0x83fffbffe000 0x2 PT_MMAP 0x44eb800 0x83fff800 0x2 PT_MMAP 0x44eb800 0x83fff400 0x1 PT_MMAP 0x44eb800 0x83fff000 0x1 PT_MMAP 0x44eb800 0x83ffec07c000 0x2 PT_MMAP 0x44eb800 0x83ffec00 0x7c PT_MMAP 0x44eb800 0x83ffe800 0x2 PT_MMAP 0x44eb800 0x83ffe4045000 0x8 PT_MMAP 0x44eb800 0x83ffe400 0x45 PT_MMAP 0x44eb800 0x83ffe000 0x1 PT_MMAP 0x44eb800 0x83ffdc004000 0x1 PT_MMAP 0x44eb800 0x83ffdc00 0x4 PT_MMAP 0x44eb800 0x83ffd800 0x1 PT_MMAP 0x44eb800 0x83ffd400 0x2 PT_MMAP 0x44eb800 0x83ffd000 0x1 PT_MMAP 0x44eb800 0x83ffcc00 0x3 PT_MMAP 0x44eb800 0x83ffc800f000 0xe PT_MMAP 0x44eb800 0x83ffc800 0xf PT_MMAP 0x44eb800 0x83ffc400 0x2 PT_MMAP 0x44eb800 0x83ffc000 0x4 PT_MMAP 0x44eb800 0x83ffbc00 0x2000 PT_MMAP 0x44eb800 0x83ffb800 0x2 PT_MMAP 0x44eb800 0x83ffb4018000 0x7 PT_MMAP 0x44eb800 0x83ffb400 0x18 PT_MMAP 0x44eb800 0x83ffb000 0x2 PT_MMAP 0x44eb800 0x83ffac005000 0x1 PT_MMAP 0x44eb800 0x83ffac00 0x5 PT_MMAP 0x44eb800 0x83ffa800 0x2 PT_MMAP 0x44eb800 0x83ffa400 0x2 PT_DATA 0x44eb800 0x8001 0x400 PT_UAREA 0xd37f800 0x43ff 0x8 PT_UAREA 0xae9c000 0x43ff 0x8 PT_TEXT 0xbe50c00 0x4000 0x4000 13864*4K pages = 686811728 Bytes --$ size `which oracle` --67108864 + 2097152 + 80320 = 69286336 PT_MMAP 0x5893000 0xc003f000 0x1 PT_NULLDREF 0x5893000 0 0x1 0 0 0x41bafb00 0x41bafb00 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 10:59 PM > Gogala, > > I've been searching for a /proc filesystem implementation on HPUX for years. I > don't think it's there yet. > > Yong Huang > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > Your process has parts of SGA attached to it. The only way to actually find > > out > > is to examine the process address space wia kernel debugger or /proc file > > system. First, try with ps -lp and see how big is the RSS (resident set > > size). > > On 11/17/2003 02:09:26 AM, "Daiminger, Helmut"
Re: Why is Oracle process using 25 MB of RAM when idle?
Well, the last number is, obviously, the size of the area. Only the maps of shared memory, text and data are of some interest. Text is, in case of an oracle process, $ORACLE_HOME/bin/oracle and you don't have any influence over it. The "data" section are the auxiliary structures. If you are running dedicated servers, it's where sort area, hash area, cursor statuses and alike are stored. Shmem is, of course, SGA. From the listing you gave us, I'd conclude that you're OK because SGA is by far the largest and everything else seems very small. On 2003.11.17 21:34, zhu chao wrote: Hi, I have also been researching on how to monitor oracle process memory utilization on different platform . And on hp, it seems more difficult. I once see a note on metalink talking about using kernel debugger on HP to detect it, here is a sample output, but I do not know the detailed meaning of different part. Hope some HP expert can answer it here. Oracle version is 9.2.0.1 and SGA is 840396160 bytes. $ ps -ef|grep 12436 oracle 12436 1 0 Nov 8 ? 0:47 ora_pmon_mimidb oracle 21385 21369 0 10:31:33 pts/ta0:00 grep 12436 $top result: TTY PID UID PRI NI SIZERES STATETIME %WCPU %CPU COMMAND ? 2454 101 154 20 3676K 1036K sleep0:10 0.02 0.02 tnslsnr ?12436 101 152 20 69696K 20332K run 0:47 0.02 0.02 ora_pmon_mimidb ?12438 101 156 20 69952K 21400K sleep0:58 0.02 0.02 ora_dbw0_mimidb # q4pxdb /stand/vmunix Processing Header Section... Processing GNTT Section... Processing LNTT Section... Procedures: 0 Processing SLT... Sorting Quick Lookup Tables... Re-writing ELF file... Done. # # ied q4 /stand/vmunix /dev/mem @(#) q4 $Revision: 1.79a $ $Date: 97/09/08 12:00:22 $ 0 q4: (warning) no modules in the crashdump or no INDEX file q4: (warning) q4 will try to read /dev/kmem for kernel access Reading kernel symbols ... Reading kernel data types ... /dev/mem: can't validate: expected size or checksum not available. Dump data may not be correct. Initialized PA-RISC 2.0 address translator ... Initializing stack tracer ... Get the latest Q4 news by typing "news". q4> load struct proc from proc max nproc loaded 276 struct proc's as an array (stopped by max count) q4> keep p_pid ==12436 kept 1 of 276 struct proc's, discarded 275 q4> q4> load struct vas from p_vas loaded 1 struct vas as an array (stopped by max count) q4> load struct pregion from va_ll.lle_prev next p_ll.lle_prev max 100 loaded 54 struct pregion's as a linked list (stopped by loop) q4> print -x p_type p_space p_vaddr p_count | more PT_SHMEM 0x427bc00 0xc400 0x33178 --sga size=833088K PT_MMAP 0x427bc00 0xc040 0x549 PT_MMAP 0x427bc00 0xc024 0x76 PT_MMAP 0x427bc00 0xc014 0xfb PT_MMAP 0x427bc00 0xc012 0x15 PT_MMAP 0x427bc00 0xc00f 0x26 PT_MMAP 0x427bc00 0xc00e8000 0x7 PT_MMAP 0x427bc00 0xc00d 0x16 PT_MMAP 0x427bc00 0xc00c4000 0x7 PT_MMAP 0x427bc00 0xc004 0x83 PT_MMAP 0x427bc00 0xc0038000 0x2 PT_MMAP 0x427bc00 0xc0034000 0x4 PT_MMAP 0x427bc00 0xc003 0x4 PT_MMAP 0x427bc00 0xc002c000 0x4 PT_MMAP 0x427bc00 0xc002a000 0x1 PT_MMAP 0x427bc00 0xc000 0x28 PT_STACK 0x44eb800 0x837f 0x10 PT_MMAP 0x44eb800 0x83fffc00 0x2 PT_MMAP 0x44eb800 0x83fffbffe000 0x2 PT_MMAP 0x44eb800 0x83fff800 0x2 PT_MMAP 0x44eb800 0x83fff400 0x1 PT_MMAP 0x44eb800 0x83fff000 0x1 PT_MMAP 0x44eb800 0x83ffec07c000 0x2 PT_MMAP 0x44eb800 0x83ffec00 0x7c PT_MMAP 0x44eb800 0x83ffe800 0x2 PT_MMAP 0x44eb800 0x83ffe4045000 0x8 PT_MMAP 0x44eb800 0x83ffe400 0x45 PT_MMAP 0x44eb800 0x83ffe000 0x1 PT_MMAP 0x44eb800 0x83ffdc004000 0x1 PT_MMAP 0x44eb800 0x83ffdc00 0x4 PT_MMAP 0x44eb800 0x83ffd800 0x1 PT_MMAP 0x44eb800 0x83ffd400 0x2 PT_MMAP 0x44eb800 0x83ffd000 0x1 PT_MMAP 0x44eb800 0x83ffcc00 0x3 PT_MMAP 0x44eb800 0x83ffc800f000 0xe PT_MMAP 0x44eb800 0x83ffc800 0xf PT_MMAP 0x44eb800 0x83ffc400 0x2 PT_MMAP 0x44eb800 0x83ffc000 0x4 PT_MMAP 0x44eb800 0x83ffbc00 0x2000 PT_MMAP 0x44eb800 0x83ffb800 0x2 PT_MMAP 0x44eb800 0x83ffb4018000 0x7 PT_MMAP 0x44eb800 0x83ffb400 0x18 PT_MMAP 0x44eb800 0x83ffb000 0x2 PT_MMAP 0x44eb800 0x83ffac005000 0x1 PT_MMAP 0x44eb800 0x83ffac00 0x5 PT_MMAP 0x44eb800 0x83ffa800 0x2 PT_MMAP 0x44eb800 0x83ffa400 0x2 PT_DATA 0x44eb800 0x8001 0x400 PT_UAREA 0xd37f800 0x43ff 0x8 PT_UAREA 0xae9c000 0x43ff 0x8 PT_TEXT 0xbe50c00 0x4000 0x4000 13864*4K pages = 686811728 Bytes --$ size `which oracle` --67108864 + 2097152 + 80320 = 69286336 PT_MMAP 0x5893000 0xc003f000 0x1 PT_NULLDREF 0x5893000 0 0x1 0 0 0x41bafb00 0x41bafb00 - Original Message - To: "Multiple
RE: Silly SQL Question
Mr. Begun,
I didn't answer your comment about making the query work with the decode vs. using a
user-written PL/SQL function because I wanted to compare timings for both. I created a
table with 200,000 rows and compared the VB (Vladimir Begun) query to the JRK (my)
query. The runtimes were identical (using SET TIMING ON in SQL*Plus).
I agree that PL/SQL isn't necessary but I think it's easier to read, and the
performance is the same. So there!
In any case Ms. Bellows had a correct solution, which I mistakenly thought was false,
so all this was just an intellectual exercise.
With a 4-element list
execute :list := '3,4,5,6,'
SET TIMING ON results: VB query 11.87 JRK query: 11.67 (each query was run twice)
If you don't "hardcode" the number of elements in the list in the 'AND cnt = ' clause,
the times were slightly longer but still the same: 14.71 vs. 14.32
VB query:
SELECT usr
FROM (
SELECT DISTINCT usr, val, COUNT(DISTINCT val) OVER (PARTITION BY usr) cnt
FROM gab
)
WHERE val IN (SELECT DISTINCT element FROM (
SELECT TO_NUMBER(SUBSTR(:list, p, c - p)) element
FROM (
SELECT DECODE(ROWNUM - 1, 0, 1, INSTR(:list, ',', 1, ROWNUM - 1) + 1) p
, INSTR(:list, ',', 1, ROWNUM) c
FROM gab
WHERE ROWNUM <= LENGTH(TRANSLATE(:list, ',0123456789-E', ','))
)
)
)
AND cnt = 4 -- it's "for nothing", because count can be give by caller
GROUP BY
usr
, cnt
HAVING COUNT(*) = 4 ;
JRK query:
select a.usr
from
(select distinct
b.usr, b.val, count (distinct b.val) over (partition by b.usr) cnt
from gab b
) a
where
val in (select *
from
the (select
cast (str_to_tbl (:num_list) as my_number_table)
from dual
)
)
and cnt = 4
group by
usr, cnt
having
count(*) = cnt ;
Test data creation:
drop table gab;
create table gab
(usr varchar2(10) not null, val number not null) ;
declare
insert_cnt constant pls_integer := 20 ;
commit_cnt constant pls_integer := 2000 ;
i pls_integer ;
j pls_integer ;
k pls_integer ;
l pls_integer ;
n pls_integer ;
usr gab.usr%type ;
type usrt is table of gab.usr%type index by binary_integer ;
usra usrt ;
type valt is table of gab.val%type index by binary_integer ;
vala valt ;
begin
dbms_random.initialize (dbms_utility.get_time) ;
i := 1 ;
while i <= insert_cnt
loop
usr := chr (ascii ('A') + mod (abs (dbms_random.random), 26))
|| chr (ascii ('A') + mod (abs (dbms_random.random), 26))
|| chr (ascii ('A') + mod (abs (dbms_random.random), 26)) ;
n := mod (abs (dbms_random.random), 5) + 1 ;
j := mod (i - 1, commit_cnt) + 1 ;
k := least (commit_cnt, j + n - 1) ;
for l in j..k
loop
usra (l) := usr ;
vala (l) := mod (abs (dbms_random.random), 9) + 1 ;
end loop ;
i := i + k - j + 1 ;
if k >= commit_cnt or i >= insert_cnt
then
forall m in 1..k
insert into gab (usr, val)
values (usra (m), vala (m)) ;
commit ;
end if ;
end loop ;
commit ;
end ;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
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: Silly SQL Question
Jacques,
you can use my first name -- "Mr." is too official for this list :). You have modified
the query,
however I would suggest you to check execution plan (and present it here) and remove
LENGTH(TRANSLATE(:list, ',0123456789-E', ',')) by replacing it using number of
elements in the
list i.e., in your case, 4. As I already said, it was just an example, in real life I
would think
is it Ok or not Ok to use it.
Timing is not everything you can check, consider statisticts. Did you consider
indexing val?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Jacques Kilchoer wrote:
Mr. Begun,
I didn't answer your comment about making the query work with the decode vs. using a
user-written PL/SQL function because I wanted to compare timings for both. I created a
table with 200,000 rows and compared the VB (Vladimir Begun) query to the JRK (my)
query. The runtimes were identical (using SET TIMING ON in SQL*Plus).
I agree that PL/SQL isn't necessary but I think it's easier to read, and the
performance is the same. So there!
In any case Ms. Bellows had a correct solution, which I mistakenly thought was false, so all this was just an intellectual exercise.
With a 4-element list
execute :list := '3,4,5,6,'
SET TIMING ON results: VB query 11.87 JRK query: 11.67 (each query was run twice)
If you don't "hardcode" the number of elements in the list in the 'AND cnt = ' clause, the times were slightly longer but still the same: 14.71 vs. 14.32
VB query:
SELECT usr
FROM (
SELECT DISTINCT usr, val, COUNT(DISTINCT val) OVER (PARTITION BY usr) cnt
FROM gab
)
WHERE val IN (SELECT DISTINCT element FROM (
SELECT TO_NUMBER(SUBSTR(:list, p, c - p)) element
FROM (
SELECT DECODE(ROWNUM - 1, 0, 1, INSTR(:list, ',', 1, ROWNUM - 1) + 1) p
, INSTR(:list, ',', 1, ROWNUM) c
FROM gab
WHERE ROWNUM <= LENGTH(TRANSLATE(:list, ',0123456789-E', ','))
)
)
)
AND cnt = 4 -- it's "for nothing", because count can be give by caller
GROUP BY
usr
, cnt
HAVING COUNT(*) = 4 ;
JRK query:
select a.usr
from
(select distinct
b.usr, b.val, count (distinct b.val) over (partition by b.usr) cnt
from gab b
) a
where
val in (select *
from
the (select
cast (str_to_tbl (:num_list) as my_number_table)
from dual
)
)
and cnt = 4
group by
usr, cnt
having
count(*) = cnt ;
Test data creation:
drop table gab;
create table gab
(usr varchar2(10) not null, val number not null) ;
declare
insert_cnt constant pls_integer := 20 ;
commit_cnt constant pls_integer := 2000 ;
i pls_integer ;
j pls_integer ;
k pls_integer ;
l pls_integer ;
n pls_integer ;
usr gab.usr%type ;
type usrt is table of gab.usr%type index by binary_integer ;
usra usrt ;
type valt is table of gab.val%type index by binary_integer ;
vala valt ;
begin
dbms_random.initialize (dbms_utility.get_time) ;
i := 1 ;
while i <= insert_cnt
loop
usr := chr (ascii ('A') + mod (abs (dbms_random.random), 26))
|| chr (ascii ('A') + mod (abs (dbms_random.random), 26))
|| chr (ascii ('A') + mod (abs (dbms_random.random), 26)) ;
n := mod (abs (dbms_random.random), 5) + 1 ;
j := mod (i - 1, commit_cnt) + 1 ;
k := least (commit_cnt, j + n - 1) ;
for l in j..k
loop
usra (l) := usr ;
vala (l) := mod (abs (dbms_random.random), 9) + 1 ;
end loop ;
i := i + k - j + 1 ;
if k >= commit_cnt or i >= insert_cnt
then
forall m in 1..k
insert into gab (usr, val)
values (usra (m), vala (m)) ;
commit ;
end if ;
end loop ;
commit ;
end ;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
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).
OWS-05566 caused by ORA-12202
I would like to make an application in OAS 408 to connect to an 817 database. When I try to create a DAD to establish this connection, I get this error: "OWS-05566 caused by ORA-12202: TNS internal navigation error". Can anyone enlighten me on what these errors mean and how to work around it? DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version 8.1.7.1.0. Application Server is OAS 408 on WinNT 4 SP6a, Net version 8.0.5. Any help would be appreciated. Best Regards, Rhojel Echano
Re: OWS-05566 caused by ORA-12202
Hi Rhojel, 8.1.7 comes with the 9iAS installed automatically as part of the regular software install. May I ask why you're using OAS? Regards, Melanie --- [EMAIL PROTECTED] wrote: > I would like to make an application in OAS 408 to > connect to an 817 > database. When I try to create a DAD to establish > this connection, I get > this error: "OWS-05566 caused by ORA-12202: TNS > internal navigation > error". Can anyone enlighten me on what these errors > mean and how to work > around it? > DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version > 8.1.7.1.0. > Application Server is OAS 408 on WinNT 4 SP6a, Net > version 8.0.5. > Any help would be appreciated. > > Best Regards, > Rhojel Echano > > __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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).
Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman 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: Clean temporary tablespace
Well, I mean that OS (w2k) file size of temp01.ora grows faster... I've setup multimaster replication and as a result got temporary tablespace about 10 Gb. OEM shows that used only about 1Gb, so others 9Gb are gone. I wanna to free them for my purposes. > Perhaps you could clarify what you mean by > 'it grows up faster and faster'. > > What exactly does that mean, what script or tool is > showing you that, what is its output, and why is > it a problem? > > Restarting the database seems extreme advice for > such a meager description of a problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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).
Listener without IPC
What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- Поцелуев Виталий Игоревич (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: OWS-05566 caused by ORA-12202
Hi Melanie, This was how the application was implemented in my new company, they used OAS 408. Still gettingfamiliar with their application.. this is what happened: I transferred the dev DB to another host for maintenance purposes and when I tried to configure a DAD for that DB in OAS, I got that error. BTW, I thought 817 comes with some AS components only (like Apache)? Anyway, thanks for taking the time. Best Regards, Rhojel Melanie Caffrey <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/18/2003 12:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: OWS-05566 caused by ORA-12202 Hi Rhojel, 8.1.7 comes with the 9iAS installed automatically as part of the regular software install. May I ask why you're using OAS? Regards, Melanie --- [EMAIL PROTECTED] wrote: > I would like to make an application in OAS 408 to > connect to an 817 > database. When I try to create a DAD to establish > this connection, I get > this error: "OWS-05566 caused by ORA-12202: TNS > internal navigation > error". Can anyone enlighten me on what these errors > mean and how to work > around it? > DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version > 8.1.7.1.0. > Application Server is OAS 408 on WinNT 4 SP6a, Net > version 8.0.5. > Any help would be appreciated. > > Best Regards, > Rhojel Echano > > __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Hi Don We have moved to oracle 9i (9.2.0.3) and are running Forms6i without any problem. According to the Metalink certification matrix Forms 6i patch set 13 and above are certified with Oracle 9.2 (or 9i). The matrix does not distinguish between minor releases of Oracle (i.e. 9.2.0.3 and 9.2.0.4). HTH Richard Jones Aramco -Original Message- Don Granaman Sent: Tuesday, November 18, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman 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: Richard Oliver Jones 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: OWS-05566 caused by ORA-12202
Hi Rhojel, I'm sure you know this, but that error message usually leads you straight to Oracle support. Are the protocols on each box the same? Are the sqlnet.ora files the same? Or do they at least each have AUTOMATIC_IPC set to OFF? Regards, Melanie --- [EMAIL PROTECTED] wrote: > Hi Melanie, > > This was how the application was implemented in my > new company, they used > OAS 408. > Still gettingfamiliar with their application.. this > is what happened: I > transferred the dev DB > to another host for maintenance purposes and when I > tried to configure a > DAD > for that DB in OAS, I got that error. > BTW, I thought 817 comes with some AS components > only (like Apache)? > Anyway, thanks for taking the time. > > Best Regards, > Rhojel > > > > > Melanie Caffrey <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/18/2003 12:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: OWS-05566 caused by > ORA-12202 > > > Hi Rhojel, > > 8.1.7 comes with the 9iAS installed automatically as > part of the regular software install. > > May I ask why you're using OAS? > > Regards, > Melanie > > --- [EMAIL PROTECTED] wrote: > > I would like to make an application in OAS 408 to > > connect to an 817 > > database. When I try to create a DAD to establish > > this connection, I get > > this error: "OWS-05566 caused by ORA-12202: TNS > > internal navigation > > error". Can anyone enlighten me on what these > errors > > mean and how to work > > around it? > > DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version > > 8.1.7.1.0. > > Application Server is OAS 408 on WinNT 4 SP6a, Net > > version 8.0.5. > > Any help would be appreciated. > > > > Best Regards, > > Rhojel Echano > > > > > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Melanie Caffrey > 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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: OWS-05566 caused by ORA-12202
Hi Melanie, Yup, I've checked all that. I guess that's the only option I have right now (Oracle support). There's not much documentation for this error in Metalink, I guess they want us to go to them directly on this one..=) But I'll do some double checking on those points that you've mentioned.. for the third time! =) If you have other ideas please let me know.. Thanks a lot. Rhojel Melanie Caffrey <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/18/2003 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: Rhojel Echano/Manila/PH/SGS) Subject: Re: OWS-05566 caused by ORA-12202 Hi Rhojel, I'm sure you know this, but that error message usually leads you straight to Oracle support. Are the protocols on each box the same? Are the sqlnet.ora files the same? Or do they at least each have AUTOMATIC_IPC set to OFF? Regards, Melanie --- [EMAIL PROTECTED] wrote: > Hi Melanie, > > This was how the application was implemented in my > new company, they used > OAS 408. > Still gettingfamiliar with their application.. this > is what happened: I > transferred the dev DB > to another host for maintenance purposes and when I > tried to configure a > DAD > for that DB in OAS, I got that error. > BTW, I thought 817 comes with some AS components > only (like Apache)? > Anyway, thanks for taking the time. > > Best Regards, > Rhojel > > > > > Melanie Caffrey <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/18/2003 12:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: Re: OWS-05566 caused by > ORA-12202 > > > Hi Rhojel, > > 8.1.7 comes with the 9iAS installed automatically as > part of the regular software install. > > May I ask why you're using OAS? > > Regards, > Melanie > > --- [EMAIL PROTECTED] wrote: > > I would like to make an application in OAS 408 to > > connect to an 817 > > database. When I try to create a DAD to establish > > this connection, I get > > this error: "OWS-05566 caused by ORA-12202: TNS > > internal navigation > > error". Can anyone enlighten me on what these > errors > > mean and how to work > > around it? > > DB is 8.1.7.1.1 on WinNT 4 SP6a, Net version > > 8.1.7.1.0. > > Application Server is OAS 408 on WinNT 4 SP6a, Net > > version 8.0.5. > > Any help would be appreciated. > > > > Best Regards, > > Rhojel Echano > > > > > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Melanie Caffrey > 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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).
