Re: function index for like '%string%'
How unpleasant, the answer I expected but didn't want to hear. At points of loopy desperation I've tried dumbest things to make this work, eg., creating the index as lower('%email_addy%') which produces the expected useless result in dba_ind_expressions: SQL create index idx_test on test (lower('%email_addy%') ; SQL select index_name, column_expression from dba_ind_expressions where table_name = 'TEST' INDEX_NAME COLUMN_EXPRESSION -- - IDX_TEST '%email_addy%' My suggested workaround to the developers is to store the string lower case. For some strings this is okay, but obviously not a great solution for strings which may be case-dependent. fbi = f**ing boneheaded index :) Suzy Joseph S. Testa wrote: i spent about a week about 6 months ago looking for something to fill that possibility to no avail. joe Rachel Carmichael wrote: she knows why it isn't being used. What Suzy wants to know (and I do too, because I have a similar situation) is if there is a way to create an index that will let you search with the like clause. Unfortunately my gut instinct is that you can't make Oracle do that From: Hillman, Alex [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: function index for like '%string%' Date: Fri, 01 Jun 2001 14:11:08 -0800 index is not used because you have leading % in the like predicate. Alex Hillman -Original Message- Sent: Friday, June 01, 2001 5:09 PM To: Multiple recipients of list ORACLE-L I've created a function index for lower(column_name). However the query does a like comparison rather than equality so the index isn't used. Is there a way to create a function index for this? Here's the index and query: create index fx1_auth_users on auth_users (lower(current_email) tablespace app01_midx ; select current_email from auth_users where lower(current_email) like '%datsit.com%' ; Thanks much, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LDAP/OID
Four years ago, I worked on a project to publish employee/people data sourced in Oracle to Netscape LDAP. We first mapped our relational data to V3 objectclasses attributes, and defined our own objectclasses attributes as needed. Then we created a table that held: primary_key table_name transaction_type transaction_date ldap_update_status. Change events were logged to this table using triggers, and a PERL script generated LDIF changes based on events in this table. PERL used DBD/DBI to Oracle, and CL utilities ldapsearch/ldapmodify to LDAP. Not exactly elegant, but for a low-volume transaction database (approx 6000 changes per day) it worked well. We did this back when LDAP was relatively new, and we had experience with X500 so it was considered a huge improvement. Oracle remained the data source for employee/people published to LDAP, and LDAP was the data source for other data like passwords, certificates and preferences. LDAP served the needs of 70,000+ employees who used it for directory lookups, password certificate authentication, e-mail and calendar prefs, group lists, etc. We also integrated LDAP authentication and access control for hundreds of web-based applications. LDAP is definately worthwhile, good planning on schema design is must. Haven't done anything yet with OID except install and look at it. Suzy Dave Morgan wrote: Hi all, OID is not worth the hassle of installing, but, has anyone used a regular LDAP server to hold Oracle database information? Details would be appreciatted. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Order of columns in a table
select table_name, column_name from dba_tab_columns where table_name = 'SOMETABLE' order by column_id ; The column order is the same as you'd see with describe or select * You can eliminate VALUES from insert when inserting a value (or null) for each column and in the proper order. Helmut Daiminger wrote: Hi! How can I find out what the order of columns in a table is? If I do a select * from tablename, the columns appear in a specific order. The same order than they appear when I do a describe tablename. I can even do an insert without specifying the columns in my VALUES (.,) when they are in that specific order. How and where can I find the order of the columns within a table? Any ideas? Yhis is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: change filename case
for i in `ls` do x=`echo $i | tr [a-z] [A-Z]` mv $i $x done Note that cat will translate the contents of the file, not filename Mitchell wrote: Hi DBAs I have a lof of file name like IDP2000.z for tuxedo servers. I need to changed name to idp2000.Z. Mitchell I rewrite the script and failed again. Any idea how to user typeset -l and tr command. Mitchell #!/usr/bin/ksh # init_idp.ksh # 2001-05-09 /Mitchell # ls -la IDP* | awk ' { print $9 } ' tobechanged # while read file do typeset -l lfile=$file; cat $lfile | tr lzl [Z] $lfile mv $file $lfile; done tobechanged # echo 'Job is done !' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Order of columns in a table
Am I an idiot?? Meant to say, you can eliminate the COLUMN list not VALUES, doh! SuzyV wrote: select table_name, column_name from dba_tab_columns where table_name = 'SOMETABLE' order by column_id ; The column order is the same as you'd see with describe or select * You can eliminate VALUES from insert when inserting a value (or null) for each column and in the proper order. Helmut Daiminger wrote: Hi! How can I find out what the order of columns in a table is? If I do a select * from tablename, the columns appear in a specific order. The same order than they appear when I do a describe tablename. I can even do an insert without specifying the columns in my VALUES (.,) when they are in that specific order. How and where can I find the order of the columns within a table? Any ideas? Yhis is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]
I would execute catalog.sql and catproc.sql, change the passwords for SYS and SYSTEM (and other default passwds), and figure out who has/needs DBA role privs. zabair ahmed wrote: Stefan I've recently inherited this database and the developers who have used the database in the past say that it worked fine and they have had no problems. My first reaction was the same as yours but i'm assured by the developers that this database has worked fine before. The problem is the previous DBA has left and there is no documentation on the database. From: Stefan Jahnke [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-06553: PLS-707: unsupported construct or internal error [2603] Date: Thu, 10 May 2001 06:31:12 -0800 zabair ahmed schrieb: Has anybody seen the following error on logon to sqlplus sqlplus dbu/dbu SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 14:29:27 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-06553: PLS-707: unsupported construct or internal error [2603] Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-06553: PLS-707: unsupported construct or internal error [2603] Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL show user USER is DBU SQL There are a number of invalid views belonging to SYS. SYS.GV_$ARCHIVED_LOG SYS.GV_$BACKUP_DATAFILE SYS.GV_$BACKUP_PIECE SYS.GV_$DATAFILE_COPY SYS.GV_$DISPATCHER_RATE SYS.GV_$LOCK_ SYS.GV_$MTS SYS.GV_$PROXY_ARCHIVEDLOG SYS.GV_$PX_SESSTAT SYS.V_$DISPATCHER_RATE SYS.V_$BACKUP_SET SYS.V_$BACKUP_PIECE SYS.V_$ARCHIVED_LOG SYS.GV_$TEMP_EXTENT_MAP SYS.GV_$SYSTEM_PARAMETER SYS.GV_$SORT_USAGE SYS.GV_$SGASTAT SYS.GV_$SESSION SYS.V_$SESSION SYS.V_$ROLLNAME SYS.V_$PROXY_DATAFILE SYS.V_$PROXY_ARCHIVEDLOG SYS.V_$MTS SYS.V_$LOADPSTAT SYS.GV_$PROXY_DATAFILE SYS.GV_$PARAMETER SYS.GV_$MLS_PARAMETERS SYS.GV_$LOADPSTAT SYS.GV_$DELETED_OBJECT SYS.GV_$BACKUP_SET When i try to recompile these i get the following error messge SQL alter VIEW SYS.V_$BACKUP_PIECE compile; alter VIEW SYS.V_$BACKUP_PIECE compile * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00904: invalid column name Anybody seen this before i had a quick look in Metalink but couldn't find anything useful. Oracle 8.1.7.0.0 on Solaris 5.6 TIA Zabair Hi, has your dictionary been created correctly during database creation ? Did you run catalog and catproc and whatever else you need without any errors ? Looks like some stuff is missing. -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Re: Do you know any good concentrated short cut book for Orac
I've always thought that buying any of the dummies books was self-hating :) Boivin, Patrice J wrote: Oracle for Dummies - my friends and I laughed pretty hard when we first saw that at the computer store, we were studying for the DBA exam at the time: How could a dummy make Oracle run... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 3:33 PM To: Multiple recipients of list ORACLE-L Subject:Re:Do you know any good concentrated short cut book for Orac Waleed, Are you talking about something for a beginer? There is always the Oracle for Beginners, Oracle for Dummies, and Beginers guid to Oracle books. They're available from BarnesNobel, Borders, and Amazon.com. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT RE: comp.oracle.databases.server vs ORACLE-L: deathmatch
] (note EXACT spelling of || 'ListGuru') and in || || the message BODY, include a line containing: || UNSUB ORACLE-L || || (or the name of mailing list you want to be || removed from). You may || || also send the HELP command for other information || (like subscribing). || || || -- || Please see the official ORACLE-L FAQ: || http://www.orafaq.com || -- || Author: Mohan, Ross ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || San Diego, California-- Public Internet || access / Mailing Lists || || || To REMOVE yourself from this mailing list, send an || E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of || 'ListGuru') and in || the message BODY, include a line containing: UNSUB || ORACLE-L || (or the name of mailing list you want to be removed || from). You may || also send the HELP command for other information || (like subscribing). || || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: A. Bardeen || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
select for update...
What are the negatives of using 'select for update'? Seem to recall it locks all rows within a block causing other transactions to wait on rows needed in the same block. What about performance impacts?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle books
PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tracking JDBC clients in V$SESSION
On Unix I run 'netstat -a', count the number of SQLNet connections per remote host, then compare that with the number of connections per username in v$session. With that you can kinda deduce what hosts are connected to what username. Maybe there is a better way... Jesse, Rich wrote: So, there I am, trying to find out what client a connection to an 8.1.7 DB on Solaris is coming from. Naturally, I SELECT USERNAME, MACHINE, TERMINAL FROM V$SESSION; Lo and behold, there is a generic login for the username, column MACHINE in all rows contains jdbcclient and TERMINAL contains unknown. With SQLNet and Net8 these two columns are populated as one would expect. Also, the OSUSER column is generic, so I'm not able to use that info. Never having used JDBC (yet), is there a setting in the JDBC client to set these? More importantly, if there is, WHY would there be such a setting? And how am I supposed to track this down, aside from SHUTDOWN ABORT (ick)? TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Name: InterScan_Disclaimer.txt InterScan_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Meeting at IOUG
Margaritas? I'm there :) Ari D Kaplan wrote: Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari D Kaplan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 5
Re: SGA Parameters ...
This Metalink doc has what you're looking for http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1008866.6 Harsh Agrawal wrote: Hi, Can u help me to knoe what are the initDB.ora parameters contributing these ? Pl. give one to one or one to many mapping of these with the parameters. - Total System Global Area 57124108 bytes Fixed Size70924 bytes Variable Size 40198144 bytes Database Buffers 16777216 bytes Redo Buffers 77824 bytes Thanks, - Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).