test
Yahoo! Personals - New people, new possibilities. FREE for a limited time!
Priority paging and Solaris 8
List, This is not entirely an Oracle question, more related to Solaris 8. We had some reports which run for 5 to 10 minutes and the unix process gone to sleep for an hour before it woke up and finished. The Oracle session showed that they are waiting for SQL message from client. During the same period, there were a lot of paging activity happening on the swap disk and the Oracle database itself is not doing much. I remember in Solaris 2.6, we have to set priority_paging to 1 in /etc/system to improve paging performance, so Solaris won't page out application executable. However, this is Solaris 8, I just checked the documentation, we are not suppose to set priority_paging. I am a bit confuse, I am seeing the symptom of application code being paged out but this problem seem to be fixed in Solaris 8. Is anyone had any experience with paging performance on Solaris 8? Jos http://search.yahoo.com.au - Yahoo! Search - Looking for more? Try the new Yahoo! Search -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Jos?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase tablespace, which way is better?
Please correct me if I am wrong. With option 1, the datafile will dynamically extend, 1M at a time and there is no guarantee the datafile is contiguous on disk. That will increase your I/O time when Oracle need to find data all over the disk. And also with autoextend, you may run out of space on that disk at any time (ie someone else created a big datafile on that disk), with option 2 at least you know you have 100M available for that datafile on the disk. Jos"Liu, Jack" <[EMAIL PROTECTED]> wrote: Hi, I want to increase tablespace, just want to know which way is better:1. ALTER TABLESPACE SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m; Thanks, Jack Yahoo! Mobile - Check & compose your email via SMS on your Telstra or Vodafone mobile.
Re: fast full index scan
Jonathan, I think you are right, it came out from 7.3. I was working on a 8.0.5 database running RBO and have to use index_ffs to force fast index scan when doing select count(*) on a big table. Cheers, Jos Jonathan Lewis <[EMAIL PROTECTED]> wrote: I'm fairly sure it was available in 7.3.3, althoughyou may have had to use the index_ffs hint tomake it work.RegardsJonathan Lewishttp://www.jlcomp.demon.co.ukComing soon one-day tutorials:Cost Based OptimisationTrouble-shooting and TuningIndexing Strategies(see http://www.jlcomp.demon.co.uk/tutorial.html )UK___March 19thUK___April 8thUK___April 22ndUSA_(FL)_May 2ndNext Seminar dates:(see http://www.jlcomp.demon.co.uk/seminar.html )USA_(CA, TX)_AugustThe Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: 03 March 2003 09:53>> List,>> Can anyone tell me on what ! version of Oracle database does fast fullindex scan first became available?>> Jos>>>> -> Yahoo! Mobile> - Exchange IMs with Messenger friends on your Telstra or Vodafonemobile phone.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jonathan LewisINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
fast full index scan
List, Can anyone tell me on what version of Oracle database does fast full index scan first became available? Jos Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
Re: temporary tablespace using tempfile
Connor, Thanks for your reply. Where can I find these information about what temporary segment will generate redo/undo? Jos Connor McDonald <[EMAIL PROTECTED]> wrote: "depends" but tpically, a lot less.Exceptions are easy to find - eg, you need undo for aglobal temp table because you are allowed to'rollback' etchthconnor--- Jos <[EMAIL PROTECTED]>wrote: > > List,> > When with temporary tablespace using tempfile, does> Oracle generate redo/undo information for temporary> segments?> > Jos> > > > > > -> Yahoo! Mobile> - Exchange IMs with Messenger friends on your> Telstra or Vodafone mobile phone. =Connor McDonaldweb: http://www.oracledba.co.ukweb: http://www.oaktable.netemail: [EMAIL PROTECTED]"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"! __Do You Yahoo!?Everything you'll ever need on one web pagefrom News and Sport to Email and Music Chartshttp://uk.my.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: =?iso-8859-1?q?Connor=20McDonald?=INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
temporary tablespace using tempfile
List, When with temporary tablespace using tempfile, does Oracle generate redo/undo information for temporary segments? Jos Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
test
Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
test
Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
Multiple block sizes in 9i
List, Oracle 9i supported multiple block sizes, I am wondering under what circumstances one would setup a database with multiple block sizes? Jos Yahoo! Greetings - Send your seasons greetings online this year!
RE: Linux and Oracle Cluster File System
Thanks for the clarification, a lot more to read. Richard Ji <[EMAIL PROTECTED]> wrote: Jos, Yes, you are right that if you use OCFS then you can just have one mount point and create all data files under it, because OCFS is a file system. It makes it a lot easier to manage space and you can use commands like: cp, mv, rm etc which you can't do to a raw partition. Backup on OCFS is also easier than using raw. Richard Ji -Original Message-----From: Jos [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: OT: Linux and Oracle Cluster File SystemList,I am a newbie on Linux and Clustering technology, I need to setup a RAC system and have been reading somedocumentation on how to do it. I am a bit confuse about the difference between setting the disk up with Linux raw partition and Oracle cluster file system, I hope someone on the list can give me some hints oruseful reference for reading. The document said for Lunix raw partition I need to setup a partition pertablespace, this is quit a lot considering for Oracle Apps there is about 200 tablespaces. I am wonderingif I am using Oracle Clustering file system (OCFS), can I define one big partition for OCFS and mount it! on /u01 and create all the files under this one mount point or the one raw partition per tablespace rule stillapplies.Jos Yahoo! Greetings- Send your seasons greetings online this year! Yahoo! Greetings - Send your seasons greetings online this year!
OT: Linux and Oracle Cluster File System
List,I am a newbie on Linux and Clustering technology, I need to setup a RAC system and have been reading somedocumentation on how to do it. I am a bit confuse about the difference between setting the disk up with Linux raw partition and Oracle cluster file system, I hope someone on the list can give me some hints oruseful reference for reading. The document said for Lunix raw partition I need to setup a partition pertablespace, this is quit a lot considering for Oracle Apps there is about 200 tablespaces. I am wonderingif I am using Oracle Clustering file system (OCFS), can I define one big partition for OCFS and mount it on /u01 and create all the files under this one mount point or the one raw partition per tablespace rule stillapplies.Jos Yahoo! Greetings - Send your seasons greetings online this year!
Setting up raw partition on Linux
Dear List: I am not an unix admin nor I know a lot about Linux, however I need to setup RAC on Linux, I am confused about setting up raw partitions for RAC. On the Linux installation Disk setup screen, I can create new partition, however I don't know what type I should use for the raw partition, none of types ext2, ext3, raid, swap and vfat seem to be appropriate. Any ideas?? Any reference link to know more about this?? Jos Yahoo! Greetings - Send your seasons greetings online this year!
Shared_pool
List, How do I find out how full my shared_pool is? Jos Yahoo! Careers - 1,000's of jobs waiting online for you!
Testing
Gene Sais <[EMAIL PROTECTED]> wrote: another suggestion:disable default roles.grant create session to all users.use application to enable roles with password.hth,gene>>> [EMAIL PROTECTED] 08/09/02 01:58PM >>>Why to find who and when. the best thing is to restrict the access.-Original Message-Sent: Friday, August 09, 2002 10:44 PMTo: Multiple recipients of list ORACLE-LUse a logon trigger to capture everything from v$session and you can look atprogram name etc...it will be pretty easy to figure out who and when.Something like this in the trigger...select distinct sid into l_sid from v$mystat;insert into session_log (select * from v$session where sid = l_sid;Ethan Postperotdba (AIM), epost1 (Yahoo)-Original Me! ! ssage-Sent: Friday, August 09, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LFolks,Before I go off re-inventing the wheel once again I'll ask the group isanyone has tried this before. What I have is a request from damanagement totell them when someone connects to our PeopleSoft database using the schemausername, but outside of PeopleTools. The reason is that there have beensome"unexplained" changes to data that have occurred over the last month that iscausing a pile of concern. It is believed that someone who has the schemapassword is using SQL*Plus or Toad to update the data when they should notbedoing so. Now auditing connects for the schema account is not a problem,butdetermining which are suspicious and which are due to the damned PeopleSoftpanel processor I can't see a way around easily from sys.aud$. Anyone elsebeenthere, done that??Dick Goulet-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, EthanINET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo! ! REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Naveen NahataINET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command ! ! for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gene SaisINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Yahoo! Digital How To - Get the best out of your PC!
Re: Oracle Corp. move to India
Based on the services we got from Oracle Support there, I can't imagine what the Oracle software will be like if they move the development over there Ray Stell <[EMAIL PROTECTED]> wrote: Heard on the BBC radio at lunch that Oracle Corp. is moving alot ofoperations to India, 1800 new jobs. ===Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ray StellINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subs! ! cribing). Yahoo! Digital How To - Get the best out of your PC!
Re: Size of Oracle server processes
Tim, I think your observation is correct, every Apps logon does create two sessions. How is that affecting the size of the server process? Do you mean the size is the sum of the two sessions? In glance, most of the memory size came out of the data segment of the process. Jos --- Tim Gorman <[EMAIL PROTECTED]> wrote: > This is a pure guess, and I don't have my own > OraApps system to check it upon first, so this might > be embarrassing, but here goes... > > Often I see 2 sessions started for every dedicated > server process when Oracle Forms is in use with > Oracle Apps, from R10.7 on up. I think the > Jinitiator applet is creating the second session > associated with the process. To verify this, you > could try running the following query and see if it > returns two rows instead of one: > selectsid, serial#, username, osuser, process > from v$session > where paddr in (select addr from v$process > where spid = > ) > Plug in the PID for the server process into > "" where you are seeing the > large RSS. If you do get two rows back from the > query, then this might be an explanation for the > increased size....? > > Hope this helps... > > -Tim > - Original Message - > From: Jos Someone > To: Multiple recipients of list ORACLE-L > Sent: Monday, July 15, 2002 1:18 PM > Subject: Size of Oracle server processes > > > I have a question to ask regarding Oracle server > process (oracle) size. We have just installed > Oracle Apps 11i, while monitoring the system using > glance, I notice something strange, the oracle > server processes - process which has a name > oracle has a very big RSS size in glance, these > processes were associated with the f60webmx > processes. I was curious about the size of it, > normally these processes are about 2-3M big. I did a > quick test by logging on to the database using > sqlplus and observe the size of the oracle server > process, it showed a size of 2M. So why the > oracle processes size is so big where they are > assoicated with f60webmx, is it something special > about them? Or the RSS size shown in glance is > doubling up on something? > > Jos > > > > > > > > -- > SOLD.com.au - Find yourself a bargain! > http://www.sold.com.au - SOLD.com.au - Find yourself a bargain! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Jos=20Someone?= 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).
Size of Oracle server processes
I have a question to ask regarding Oracle server process (oracle) size. We have just installed Oracle Apps 11i, while monitoring the system using glance, I notice something strange, the oracle server processes - process which has a name oracle has a very big RSS size in glance, these processes were associated with the f60webmx processes. I was curious about the size of it, normally these processes are about 2-3M big. I did a quick test by logging on to the database using sqlplus and observe the size of the oracle server process, it showed a size of 2M. So why the oracle processes size is so big where they are assoicated with f60webmx, is it something special about them? Or the RSS size shown in glance is doubling up on something? Jos SOLD.com.au - Find yourself a bargain!
