Re: init.ora processes ??
Another thing to consider is this: From OraPerf: The LGWR needs to scan all processes to find each process that is waiting for the commit to be written. So when you have an excess of process LGWR works harder. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 16, 2002 8:43 PM How about with Microsoft Windows NT ? --- Fink, Dan [EMAIL PROTECTED] wrote: For each process 'reserved' by oracle, there is a small amount of space allocated in the SGA and a semaphore is reserved at the O/S level (assuming UNIX). A lesser number of processes will allocate a slightly smaller amount of SGA and fewer semaphores. Until a session is started, no other memory is allocated. Dan Fink -Original Message- Sent: Friday, August 16, 2002 10:44 AM To: Multiple recipients of list ORACLE-L All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage if I start database with 100 processes versus 200 processes as init.ora parameter (assuming that I have same number of sessions in both cases). Thanks for your help. Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Fink, Dan 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!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: init.ora processes ??
For each process 'reserved' by oracle, there is a small amount of space allocated in the SGA and a semaphore is reserved at the O/S level (assuming UNIX). A lesser number of processes will allocate a slightly smaller amount of SGA and fewer semaphores. Until a session is started, no other memory is allocated. Dan Fink -Original Message- Sent: Friday, August 16, 2002 10:44 AM To: Multiple recipients of list ORACLE-L All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage if I start database with 100 processes versus 200 processes as init.ora parameter (assuming that I have same number of sessions in both cases). Thanks for your help. Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Fink, Dan 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: init.ora processes ??
the larger the number of processes in the init.ora, the larger the number of semaphores you need on most Unix systems. Not all, I *think* from reading the list that AIX doesn't use semaphores (I've only worked on HP-UX and SUN, both of which use semaphores) If the processes parameter is set so high that there are no more semaphores available, your database won't open --- Bob Robert [EMAIL PROTECTED] wrote: All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage if I start database with 100 processes versus 200 processes as init.ora parameter (assuming that I have same number of sessions in both cases). Thanks for your help. Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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).
RE: init.ora processes ??
How about with Microsoft Windows NT ? --- Fink, Dan [EMAIL PROTECTED] wrote: For each process 'reserved' by oracle, there is a small amount of space allocated in the SGA and a semaphore is reserved at the O/S level (assuming UNIX). A lesser number of processes will allocate a slightly smaller amount of SGA and fewer semaphores. Until a session is started, no other memory is allocated. Dan Fink -Original Message- Sent: Friday, August 16, 2002 10:44 AM To: Multiple recipients of list ORACLE-L All, What is the impact of processes init.ora parameter other than restricting number of user sessions ? I know it needs more memory (like stack size + sort area size + etc. ) whenever it gets new connection. My question is: Is there any additional resource (does it take more memory? ) usage if I start database with 100 processes versus 200 processes as init.ora parameter (assuming that I have same number of sessions in both cases). Thanks for your help. Bob __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Fink, Dan 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!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Init.ora and Config.ora
I tend to only use the init.ora file --- Fink, Dan [EMAIL PROTECTED] wrote: Beware...DBA heresy below... I am in the process of cleaining up parameter files and wonder why we still maintain an init.ora and config.ora. The original rational was that one contained the database configuration/creation parameters while the other was used for tuning. Is there a good reason why we have 2 files instead of a single file? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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).
Re: Init.ora and Config.ora
Can be useful on servers with multiple databases. config.ora can contain parameters that you may wish to be common among all databases on the server. e.g. NAME VALUE VAL? MOD? MOD? - -- audit_trail DB NNN db_block_size 8192 NNN db_files 1024 NNN global_names FALSE NYI job_queue_interval30 NNN job_queue_processes 2 NNI log_archive_start TRUE NNN max_dump_file_size10240 NYI max_enabled_roles 30 NNN os_authent_prefix NNN timed_statistics TRUE NYI Jared Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/13/2002 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Init.ora and Config.ora Beware...DBA heresy below... I am in the process of cleaining up parameter files and wonder why we still maintain an init.ora and config.ora. The original rational was that one contained the database configuration/creation parameters while the other was used for tuning. Is there a good reason why we have 2 files instead of a single file? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Init.ora and Config.ora
I always thought it was for separating instance-specific parameters from database-specific parameters in an OPS environment. At least, that's one place where it is very useful to have separate files. Of course, it was a matter of style whether "config.ora" was the database-level one or vice-versa... Also, somewhere back in the mists of time, any ".ora" file for initialization parameters had to be less than 10,000 characters in size; anything beyond that boundary was simply not used(I kid you not!). So, having multiple files related by "ifile=" was the workaround, especially for those neurotic souls who insisted on leaving comments for documentation... - Original Message - From: Fink, Dan To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 10:48 AM Subject: Init.ora and Config.ora Beware...DBA heresy below... I am in the process of cleaining up parameter files and wonder why we still maintain an init.ora and config.ora. The original rational was that one contained the database configuration/creation parameters while the other was used for tuning. Is there a good reason why we have 2 files instead of a single file? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456
Re: Init.ora and Config.ora
REAL DBAs don't need comments? :) --- Tim Gorman [EMAIL PROTECTED] wrote: I always thought it was for separating instance-specific parameters from database-specific parameters in an OPS environment. At least, that's one place where it is very useful to have separate files. Of course, it was a matter of style whether config.ora was the database-level one or vice-versa... Also, somewhere back in the mists of time, any .ora file for initialization parameters had to be less than 10,000 characters in size; anything beyond that boundary was simply not used (I kid you not!). So, having multiple files related by ifile= was the workaround, especially for those neurotic souls who insisted on leaving comments for documentation... - Original Message - From: Fink, Dan To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 10:48 AM Subject: Init.ora and Config.ora Beware...DBA heresy below... I am in the process of cleaining up parameter files and wonder why we still maintain an init.ora and config.ora. The original rational was that one contained the database configuration/creation parameters while the other was used for tuning. Is there a good reason why we have 2 files instead of a single file? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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).
RE: Init.ora and Config.ora
Dan, I agree with Rachel. I have one init.ora file for each database instance. I personally *HATE* the "ifile" business. All that it does is make me go searching in another directory to see what the parameters are set to. I like to go to one directory/one file to set/review my init params. I can see everything in one place, and I don't have to go searching/remembering where things are. I also keep this file in the ORACLE_HOME/dbs or database directory (depending on OS). Frig the pfile directory. Another lousy idea from somebody. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Init.ora and Config.ora I always thought it was for separating instance-specific parameters from database-specific parameters in an OPS environment. At least, that's one place where it is very useful to have separate files. Of course, it was a matter of style whether "config.ora" was the database-level one or vice-versa... Also, somewhere back in the mists of time, any ".ora" file for initialization parameters had to be less than 10,000 characters in size; anything beyond that boundary was simply not used(I kid you not!). So, having multiple files related by "ifile=" was the workaround, especially for those neurotic souls who insisted on leaving comments for documentation... - Original Message - From: Fink, Dan To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 10:48 AM Subject: Init.ora and Config.ora Beware...DBA heresy below... I am in the process of cleaining up parameter files and wonder why we still maintain an init.ora and config.ora. The original rational was that one contained the database configuration/creation parameters while the other was used for tuning. Is there a good reason why we have 2 files instead of a single file? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456
RE: Init.ora and Config.ora
I agree about OPS/RAC distinctions. I wonder if that was the original justification that then took hold elsewhere. I distinctly remember a few days at a certain unamed media outlet that were spent trying to figure out why rollback segments weren't coming online... Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Init.ora and Config.ora I always thought it was for separating instance-specific parameters from database-specific parameters in an OPS environment. At least, that's one place where it is very useful to have separate files. Of course, it was a matter of style whether "config.ora" was the database-level one or vice-versa... Also, somewhere back in the mists of time, any ".ora" file for initialization parameters had to be less than 10,000 characters in size; anything beyond that boundary was simply not used(I kid you not!). So, having multiple files related by "ifile=" was the workaround, especially for those neurotic souls who insisted on leaving comments for documentation... - Original Message - From: Fink, Dan To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 10:48 AM Subject: Init.ora and Config.ora Beware...DBA heresy below... I am in the process of cleaining up parameter files and wonder why we still maintain an init.ora and config.ora. The original rational was that one contained the database configuration/creation parameters while the other was used for tuning. Is there a good reason why we have 2 files instead of a single file? Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456
RE: init.ora params for quick i/0
As suggested by Frank, turning on Cached option of Quick I/O really helped the reads (at the same time with some negative impact on writes). At this point I have enabled cache quick i/o on data file systems. This is on a sun e10k with 28 cpu and 28g ram. If anyone who has used cached quick i/o can comment if there are any pros/cons of using this option, would be great. Thanks Mohammed Ahsanuddin Oracle DBA -Original Message- Sent: Tuesday, May 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you will find it invaluable. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:init.ora params for quick i/0 Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O related waits for a process (db file sequential read, db file parallel write etc..) and would like to involve our sys admin in tuning this particular process..If anyone has any idea what I can specifically ask the sys admin to look at, please do let me know.. I really appreciate any feedback I could get.. Thanks Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: init.ora params for quick i/0
Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you will find it invaluable. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:init.ora params for quick i/0 Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O related waits for a process (db file sequential read, db file parallel write etc..) and would like to involve our sys admin in tuning this particular process..If anyone has any idea what I can specifically ask the sys admin to look at, please do let me know.. I really appreciate any feedback I could get.. Thanks Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: init.ora params for quick i/0
Jarred, Here is a sample what I get from truss..There are no error messages saying which indicates that AIO calls are falling back to standard IO calls...Is there any other way of identifying that? And also thanks for the book suggestion..I was waiting for a newer release though, but will go with the current one. === 24230: kaio(AIOWAIT, 0xFFBEDF78) = 28239248 24228: kaio(AIOWRITE, 369, 0x88BC, 8192, 0x3B75A000, 0x01BA7234) = 0 24228: kaio(AIOWRITE, 355, 0x89E9C000, 8192, 0x1AF46000, 0x01BA13E8) = 0 24228: kaio(AIOWRITE, 365, 0x89704000, 8192, 0x3B998000, 0x01B822E0) = 0 24228: kaio(AIOWRITE, 365, 0x89532000, 8192, 0x3BA28000, 0x01B66BA8) = 0 24228: kaio(AIOWRITE, 365, 0x8986C000, 8192, 0x3BAFC000, 0x01BAEE1C) = 0 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28844768 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28996148 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28732328 24228: kaio(AIOWAIT, 0xFFBEDF78) = 29027868 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28972008 24234: kaio(6, 0x, 0x, 0x0001, 0xFFBED44C, 0x0004, 0x) (sleeping...) 24232: kaio(AIOWRITE, 399, 0xA1954000, 8192, 0x727CC000, 0x01BCDBD4) = 0 24232: kaio(AIOWAIT, 0xFFBEDF78) = 29154260 24230: kaio(AIOWRITE, 401, 0x8E714000, 8192, 0x1B12, 0x01B68CAC) = 0 24230: kaio(AIOWAIT, 0xFFBEDF78) = 28740780 24234: kaio(AIOWRITE, 402, 0xA816A000, 8192, 0x1AFE2000, 0x01AFAD24) = 0 24234: kaio(AIOWRITE, 402, 0xAA084000, 8192, 0x1B00E000, 0x01B984E8) = 0 24234: kaio(AIOWRITE, 390, 0xA900, 8192, 0x50822000, 0x01C165A0) = 0 24234: kaio(AIOWAIT, 0xFFBEDF78) = 28935400 24234: kaio(AIOWAIT, 0xFFBEDF78) = 28290340 = Mohammed Ahsanuddin Oracle DBA Verizon Wireless Work : 845 365 7203 Pager : 800 366 2337 pin : 16040 -Original Message- Sent: Tuesday, May 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you will find it invaluable. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:init.ora params for quick i/0 Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O related waits for a process (db file sequential read, db file parallel write etc..) and would like to involve our sys admin in tuning this particular process..If anyone has any idea what I can specifically ask the sys admin to look at, please do let me know.. I really appreciate any feedback I could get.. Thanks Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
RE: init.ora params for quick i/0
There would be an error value at the end of the call, and the next call would be a standard write call ( pwrite I think ). Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 02:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: init.ora params for quick i/0 Jarred, Here is a sample what I get from truss..There are no error messages saying which indicates that AIO calls are falling back to standard IO calls...Is there any other way of identifying that? And also thanks for the book suggestion..I was waiting for a newer release though, but will go with the current one. === 24230: kaio(AIOWAIT, 0xFFBEDF78) = 28239248 24228: kaio(AIOWRITE, 369, 0x88BC, 8192, 0x3B75A000, 0x01BA7234) = 0 24228: kaio(AIOWRITE, 355, 0x89E9C000, 8192, 0x1AF46000, 0x01BA13E8) = 0 24228: kaio(AIOWRITE, 365, 0x89704000, 8192, 0x3B998000, 0x01B822E0) = 0 24228: kaio(AIOWRITE, 365, 0x89532000, 8192, 0x3BA28000, 0x01B66BA8) = 0 24228: kaio(AIOWRITE, 365, 0x8986C000, 8192, 0x3BAFC000, 0x01BAEE1C) = 0 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28844768 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28996148 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28732328 24228: kaio(AIOWAIT, 0xFFBEDF78) = 29027868 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28972008 24234: kaio(6, 0x, 0x, 0x0001, 0xFFBED44C, 0x0004, 0x) (sleeping...) 24232: kaio(AIOWRITE, 399, 0xA1954000, 8192, 0x727CC000, 0x01BCDBD4) = 0 24232: kaio(AIOWAIT, 0xFFBEDF78) = 29154260 24230: kaio(AIOWRITE, 401, 0x8E714000, 8192, 0x1B12, 0x01B68CAC) = 0 24230: kaio(AIOWAIT, 0xFFBEDF78) = 28740780 24234: kaio(AIOWRITE, 402, 0xA816A000, 8192, 0x1AFE2000, 0x01AFAD24) = 0 24234: kaio(AIOWRITE, 402, 0xAA084000, 8192, 0x1B00E000, 0x01B984E8) = 0 24234: kaio(AIOWRITE, 390, 0xA900, 8192, 0x50822000, 0x01C165A0) = 0 24234: kaio(AIOWAIT, 0xFFBEDF78) = 28935400 24234: kaio(AIOWAIT, 0xFFBEDF78) = 28290340 = Mohammed Ahsanuddin Oracle DBA Verizon Wireless Work : 845 365 7203 Pager : 800 366 2337 pin : 16040 -Original Message- Sent: Tuesday, May 21, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you will find it invaluable. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:init.ora params for quick i/0 Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O related waits for a process (db file sequential read, db file parallel write etc..) and would like to involve our sys admin in tuning this particular process..If anyone has any idea what I can specifically ask the sys admin to look at, please do let me know.. I really appreciate any feedback I could get.. Thanks Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
Re: init.ora (un documented) parameters
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 14:10 Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that only 203 parameters only documents, remaining are undocumented. This i read on a white paper. Where should i get information about these parameters? Just i want to know. the only place (outdated now) I'm aware of is http://www.fortunecity.com/skyscraper/oracle/699/orahtml/misc/undoc.html also a good place to start is downloading OraSnap from http://www.stewartmc.com/oracle/orasnap/ and playing with the Undoc'd Init.ora Params section in the reports produced On the same white paper i read, the parameter _trace_files_public=true will do my request. take a look at http://www.ixora.com.au/q+a/0009/15165340.htm hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Init.ora Compabible Setting
Ken, If you set the compatible to 817, then, you would be able to take advantage of 817 version. Or, if you have some software which is compatible with 8.1.0, then, it is better to leave like that. I personally prefer setting it to 817. Rao -Original Message- Sent: Monday, December 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Rao, Maheswara 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: Init.ora Compabible Setting
Well, if you are using any functionality related to 8.1.0 then leave it as it is.. or atleast boost it up to 8.1.5 or 8.1.6 .. This will enable your DROP COLUMN too.. As might have been suggested.. Higher the better. if you are not using anything related to previous version. Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 06:30 AM My init.ora compatible is set to 8.1.0. Is this correct for 8.1.7? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Nikunj Gupta 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: init.ora file and UTL_FILE package
cuell!!! ;o) -Original Message- Sent: 03 October 2001 18:06 To: Multiple recipients of list ORACLE-L Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:30 AM Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: Steve Smith 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: Thomas, Kevin 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
RE: init.ora file and UTL_FILE package
Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: init.ora file and UTL_FILE package
i prefer utl_file=/tmp/oracle/$sid. you don't want to give rights everywhere. also, developers can access their stuff in /tmp/... dir. [EMAIL PROTECTED] 10/03/01 12:50AM utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Gene Sais 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: init.ora file and UTL_FILE package
Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:30 AM Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: Steve Smith 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: init.ora file and UTL_FILE package
I knew about the security hole utl_file_dir=* but wanted to keep the production and development enviroments the same so I decided that wasn't a great option. I take it the utl_file parameter cannot be changed on the fly, huh? thanks for everybody's reponses ReedK -Original Message- Sent: Wednesday, October 03, 2001 11:05 AM To: Multiple recipients of list ORACLE-L Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:30 AM Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: Steve Smith 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: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: init.ora file and UTL_FILE package
Correct. Its not adjustable on the fly. (at least on 8.0.5) -Original Message- Sent: Wednesday, October 03, 2001 1:06 PM To: Multiple recipients of list ORACLE-L I knew about the security hole utl_file_dir=* but wanted to keep the production and development enviroments the same so I decided that wasn't a great option. I take it the utl_file parameter cannot be changed on the fly, huh? thanks for everybody's reponses ReedK -Original Message- Sent: Wednesday, October 03, 2001 11:05 AM To: Multiple recipients of list ORACLE-L Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:30 AM Remember this has security implications however as anyone can read/write files from otherwise private directories. Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 03 October 2001 05:50 To: Multiple recipients of list ORACLE-L utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: Thomas, Kevin 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: Steve Smith 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: Kempf,
RE: init.ora file and UTL_FILE package
Title: RE: init.ora file and UTL_FILE package (see answer below) -Original Message- From: Kempf, Reed [mailto:[EMAIL PROTECTED]] I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. This isn't exactly what you're looking for, but did you know about this feature? Metalink Doc ID: Note:1016653.4 Bulletin: Steps to verify setup for UTIL_FILE Package on Windows NT ... The security and directory accessibility are controlled by the UTL_FILE_DIR parameter. If the INIT.ORA file contains UTL_FILE_DIR = * then database permissions are disable and all files and directories are accessible to all users. ... Of course, when saying UTL_FILE_DIR = *, developpers can overwrite any file on which the oracle executable has write privileges.
Re: init.ora file and UTL_FILE package
utl_file=* On the development server.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 5:55 PM I have a question concerning the init.ora file and using the supplied package UTL_FILE I am finding it a real inconvenience to bounce the database everytime I need to add a UTL_FILE directory, especially on the development machine. Since the coding is very dynamic and many people are developing on the same database, when I add a UTL_FILE directory, I need to notify everyone involved, have them stop what they are doing and bounce the database... yuk! Is there any possible way to add UTL_FILE directories on the fly without bouncing the database (alter session, alter system, etc) and then at a more convenient time add all of the changes at once to the init.ora file and bounce the database once. Any suggestions would be useful. Thanks in advance ReedK just another Montana DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Steve Smith 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: init.ora
do a select select name from v$database; you will get a name , and your init file will be initthe_selected_name.ora hope this will help you regards Digs --- prasad maganti [EMAIL PROTECTED] wrote: hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti 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!? For regular News updates go to http://in.news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?D=20B?= 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: init.ora
Title: RE: init.ora Hi Prasad, When your issue STARTUP command in svrmgrl or sqlplus, Oracle will check the file called initSID.ora in the $ORACLE_HOME/dbs directory. You could specify a initSID.ora file with this command : STARTUP PFILE=/PATH/initSID.ora Luc -Message d'origine- De: prasad maganti [mailto:[EMAIL PROTECTED]] Date: Monday, July 23, 2001 11:21 AM À: Multiple recipients of list ORACLE-L Objet: init.ora hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti 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: init.ora
Prasad: There is no way to tell from inside Oracle exactly what init.ora you used to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between the two init.ora files and querying sys.v_$parameter to check those differences. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:20 AM hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti 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: Jon Walthour 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: init.ora
This won't tell you of aditional config files (referenced using ifile= in you init file) but it will tell you the primary file. select * from v$parameter where name = 'ifile'; Rodd Holman Original Message On 7/23/01, 6:35:50 AM, Jon Walthour [EMAIL PROTECTED] wrote regarding Re: init.ora: Prasad: There is no way to tell from inside Oracle exactly what init.ora you used to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between the two init.ora files and querying sys.v_$parameter to check those differences. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:20 AM hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti 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: Jon Walthour 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: Rodd Holman 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: Re: init.ora
Rood: Not exactly correct. The ifile parameter will tell you all the files included in the init.ora via this method. However, it will not necessarily give you the location of the init.ora itself. Now, on a Windows NT system, this is how Oracle is able to keep the init.ora in the %ORACLE_ADMIN%\%ORACLE_SID%\pfile directory and still have a link to it in the %ORACLE_HOME%\dbs directory. However, on UNIX, where symlinks are used, there may be no ifile parameter in the init.ora and certainly probably not one pointing to the init.ora itself. Therefore, at best, this parameter is unreliable for finding the init.ora. Jon Walthour --- Original Message --- From: Rodd Holman [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:20:54 AM This won't tell you of aditional config files (referenced using ifile= in you init file) but it will tell you the primary file. select * from v$parameter where name = 'ifile'; Rodd Holman Original Message on 7/23/01, 6:35:50 am, jon walthour [EMAIL PROTECTED] wrote regarding Re: init.ora: Prasad: There is no way to tell from inside Oracle exactly what init.ora you u sed to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between t he two init.ora files and querying sys.v_$parameter to check those difference s. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 23, 2001 5:20 AM hi dbas is there anyway to see using what init.ora file i start my instance/db bcoz i hv somany init files in the same dir. they have same parameters. i forgot to remember what init file i used to start the db. can it be found from any table/or anyother source? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messe nger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lis ts To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour 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: Rodd Holman 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: Jon Walthour 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: Init.ora .. OPTIMIZER parm: optimizer_index_cost_adj
I've used this in an attempt to make the optimizer prefer a hash join over a nested loops join. The desired results were not achieved. Jared On Tue, 30 Jan 2001 [EMAIL PROTECTED] wrote: Has any one messed with optimizer_index_cost_adj on 8.1.7 ?? The default is 100, but my boss thinks 10 is a better value for Cost based Opmtzr.. doesn't make any sense to me.. why would reducing the cost of using an optimizer make it more CBO or go faster.. what if its a large table? Is it a good strategy to reduce this value to 10 or so .. any one played with this on a 30GB database ? or any other size db? thanks, Bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Init.ora .. OPTIMIZER parm: optimizer_index_cost_adj
This parameter tells the optimizer how much weight to give to indexes when evaluating a query. That's the short answer, it's really more complicated than that. A client I have uses a value of 4 for this parameter. This was arrived at using the old fashion method of changing the value and running some test queries and capturing timings for them. [EMAIL PROTECTED] 01/30/01 03:41PM Has any one messed with optimizer_index_cost_adj on 8.1.7 ?? The default is 100, but my boss thinks 10 is a better value for Cost based Opmtzr.. doesn't make any sense to me.. why would reducing the cost of using an optimizer make it more CBO or go faster.. what if its a large table? Is it a good strategy to reduce this value to 10 or so .. any one played with this on a 30GB database ? or any other size db? thanks, Bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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).