RE: Installing Oracle on W2k
Hi Robert, Yea, you got the right point. I was using a server, which had a P4 processor. After lots of searches on metalink, I found the problem and The workarounds ;-)) Great Bug for Great architecture ;-) Thanks for your response, Rajesh -Original Message- Sent: Sunday, December 09, 2001 12:05 PM To: Multiple recipients of list ORACLE-L >Any-body had any similar experience? Oh yeahand how. Yours is a Pentium 4 box ? then read on... It's a well-known problem... The reason for this is that the P4 architecture has problems with the Java Just In Time installer. I'm not going to repeat it here. The detailed answers are on orafaq.com, just search on "installation windows 2000" Robert - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 12:30 AM > Hi All, > > I am trying to install oracle 8.1.7 on W2k Server. > OUI doesn't start at all. What could be wrong? Any-body had > any similar experience? > > TIA, > Rajesh > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: RAJESH DAYAL > 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: Robert Chin 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: RAJESH DAYAL 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: Backups
Ryn, I know nothing about the VxFS/UFS snapshot utlities, but from a backup standpoint, other than using RMAN, the only way a valid backup can be taken with the database up and running is to put the tablespaces in backup mode before the datafiles, or the filesystems on which they reside, are copied. If this is similar to a disk split, for example, you can restore the split and open the database because this is essentially the same case as starting up a db after a shutdown abort and SMON will do instance recovery. This is NOT a valid backup, however, and attempting to do media recovery and apply archived logs will write warnings to the alert.log that you are attempting to recover from a fuzzy backup and the db will not open. HTH, --Anita --- Ryn <[EMAIL PROTECTED]> wrote: > Hello folks, > > We are looking into the VxFS/UFS snapshot utlities, > and I am curious how you can > quiesce an Oracle instance? I would like all changes > to the buffer cache to be > flushed > to the file system and checkpoints to occur. What > would I need to run to do > this? I > assume this would give the file system a consistent > view of the database. We are > going > to play with this in our test environment. > > Thanks for any info, > > - Ryn __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: diagnosing latch free
Hi Doug! It sounds like SMON is busy doing something else, most likely coalescing free space or deallocating temp segments. See metalink Note: 61997.1 "SMON - Temporary Segment Cleanup and Free Space Coalescing" While there are events that can be set to prevent smon from coalescing or cleaning up temp segments, they are only a temporary measure to allow one to defer the cleanup to a more convenient time. The best bet is to let smon finish its job and then set proper extent sizes for temp tablespaces or use locally managed temp tablespaces. Did the db crash or was a shutdown abort done? SMON could be doing instance recovery. I've seen cases where SMON was "stalled" when doing recovery when FAST_START_PARALLEL_ROLLBACK was set. Shutting down and setting FAST_START_PARALLEL_ROLLBACK = FALSE allowed SMON to finish recovery. As a workaround in any of the above situations, you can create a permanent tablespace and redirect users' temporary tablespace to that permanent tablespace. HTH, -- Anita --- Doug C <[EMAIL PROTECTED]> wrote: > Ok.. it's a sort segment latch.. any way to find out > why? It's been sitting > around for over an hour ... > > On Sat, 08 Dec 2001 14:35:18 -0800, you wrote: > > >oops, probably only want the events that are latch > frees: > > > >select ln.name from v$session_wait sw, v$latchname > ln where sw.p2 = > >ln.latch# and sw.event = 'latch free'; > > > >On Saturday, December 8, 2001, at 04:50 PM, George > Schlossnagle wrote: > > > >> Try: > >> > >> select ln.name from v$session_wait sw, > v$latchname ln where sw.p2 = > >> ln.latch#. > >> > >> Best, > >> > >> George > >> > >> www.pythian.com -- [EMAIL PROTECTED] -- > 877-PYTHIAN > >> Smarter than adding another team member, Pythian > has new services for > >> supplementing DBAs: get our help with monitoring, > 24x7 on-call, daily > >> verifications, storage management, performance > and more. > >> > >> > >> On Saturday, December 8, 2001, at 04:05 PM, Doug > C wrote: > >> > >>> I have a session that seems to be hung on a > sql_statment. > >>> > >>> Here is it's session_wait entry: > >>> > >>>SID SEQ# > >>> -- -- > >>> EVENT > >>> > > >>> P1TEXT > > >>> P1 > >>> > > > >>> -- > >>> P1RAWP2TEXT > >>> > >>> > > >>> P2 P2RAW > >>> -- > >>> P3TEXT > > >>> P3 > >>> > > > >>> -- > >>> P3RAW WAIT_TIME SECONDS_IN_WAIT STATE > >>> -- --- > --- > >>> 62 1239 > >>> latch free > >>> address > > >>> 805352248 > >>> 3000B338 number > >>> 88 0058 > >>> tries > > >>> 923 > >>> 039B 0 0 WAITING > >>> > >>> > >>> The seq# goes up from time to time. > >>> My question is how to determine what kind of > latch is bothering it? > >>> Does P2 (88) indicate what type of latch? Can I > join with some other > >>> table to > >>> find out what 88 is? > >>> > >>> Thanks, > >>> D __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Where is the memory gone?
WinterSun, Hmm, this doesn't sound like bug 1397603. That bug manifests itself as a memory leak in the 'State objects' area of the shared pool, not the 'Miscellaneous' area. Bug 1397603 is also fixed in the 8.1.7.2 patchset, so if you already have that applied (hint, hint!) you're not encountering this bug and there's no need to set _db_handles_cached = 0. I believe the bug Kimberly is referring to is bug 1240484, which is a process memory leak (i.e. ORA-4030, not ORA-4031) with MTS shared server sessions when there are frequent connect/disconnects. That bug is fixed in 8.1.7.1. If IOT's are involved, you could be hitting bug 1642964 if the IOT is the inner table in a nested loop join. Fixed in 9.0.1. Workaround: set optimizer_index_caching = 1 I'm more inclined to believe you're hitting bug 1921561 or bug 1970290, both of which have been awaiting more info from the customer for whom the bug was filed. The workaround for both of them was to set STAR_TRANSFORMATION_ENABLED = FALSE or _db_file_noncontig_mblock_read_count = 1. If you use bitmap indexes, disabling star transformation is likely to cause a noticeable performance hit so you might want to try the other workaround. Otherwise, if you can reproduce this in a test environment, it would be helpful to file a tar with support so a bug can be filed. HTH, -- Anita --- WinterSun Zhao <[EMAIL PROTECTED]> wrote: > Hi, Kimberly: >Thank you for your guide. >I checked Metalink and find that is a bug. Bug > No. 1397603. >I think I will add the parameter > _db_handles_cached to 1 later. I will also patch it > to 8.1.7.2 too. >Thank all of you. >B.R. > > > This sound pretty much like the same problem I had > with 8.1.7 on HP. > > They have a memory leak when you > connect/disconnect and it you have > > a lot of those you start to see it in your SGA. I > had to patch to > > 8.1.7.1 plus an additional bug fix. Check on > Metalink to see if there > > is the same problem with Windows. It also could > be that you really > > do need more then 50M. Pin in the bigger packages > you use (including > > Oracle's) right after startup and see where you > are memory wise. > > > > -Original Message- > > Zhao > > Sent: Sunday, December 09, 2001 5:30 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, DBAs: > > I find that one of our database's Shared > Pool's memory decreased every > > day. > > It is Oracle 8.1.7 on Windows 2K, with 512M > Physical memory. > > When I check v$sgastat, I find the > "miscellaneous" part of "shared pool" > > increased every day, it begans with 500K, then, > after two days, it increased > > to 5586228 bytes, after about 10 days, it > increased to 40M, and because I > > had allocated 50M to the Shared Pool, So the > memory available became less > > and less. And I had to shutdown and restart the > database when the available > > memory of shared pool is below 5M. > >I want to know why the memory occupied by > "miscellaneous" part is > > increased? The other database on solaris did not > increased. How can I find > > out what is it? How to prevent it or resolve it > without shutdown and restart > > the database? ( alter system flush shared pool > only flush the sql and > > library cache, and it didn't decrease the > miscellaneous part's memory > > usage. ) > >Thank you very much! > > > > WinterSun __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cannot Drop Column
Did you check COMPATIBLE ? What is it set to ? 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: Friday, December 07, 2001 12:05 PM Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm >>> [EMAIL PROTECTED] 12/07/01 02:25PM >>> Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz fsys.com>cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? 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: 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: RE: Where is the memory gone?
Hi, Kimberly: Thank you for your guide. I checked Metalink and find that is a bug. Bug No. 1397603. I think I will add the parameter _db_handles_cached to 1 later. I will also patch it to 8.1.7.2 too. Thank all of you. B.R. > This sound pretty much like the same problem I had with 8.1.7 on HP. > They have a memory leak when you connect/disconnect and it you have > a lot of those you start to see it in your SGA. I had to patch to > 8.1.7.1 plus an additional bug fix. Check on Metalink to see if there > is the same problem with Windows. It also could be that you really > do need more then 50M. Pin in the bigger packages you use (including > Oracle's) right after startup and see where you are memory wise. > > -Original Message- > Zhao > Sent: Sunday, December 09, 2001 5:30 PM > To: Multiple recipients of list ORACLE-L > > > Hi, DBAs: > I find that one of our database's Shared Pool's memory decreased every > day. > It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory. > When I check v$sgastat, I find the "miscellaneous" part of "shared pool" > increased every day, it begans with 500K, then, after two days, it increased > to 5586228 bytes, after about 10 days, it increased to 40M, and because I > had allocated 50M to the Shared Pool, So the memory available became less > and less. And I had to shutdown and restart the database when the available > memory of shared pool is below 5M. >I want to know why the memory occupied by "miscellaneous" part is > increased? The other database on solaris did not increased. How can I find > out what is it? How to prevent it or resolve it without shutdown and restart > the database? ( alter system flush shared pool only flush the sql and > library cache, and it didn't decrease the miscellaneous part's memory > usage. ) >Thank you very much! > > WinterSun > -- > ¹úÄÚÊÕ·ÑÓÊÏäË×îÇ¿£¬Ê×´ÎȨÍþÆÀ²â¼û·ÖÏþ > http://news.21cn.com/domestic/21CN/2001-11-19/550568.html > ÂòÆóÒµÓÊÏ䣬»ñÔùÓòÃû > http://mail.21cn.com/corporation/010.html > ÊÕ·ÑÓÊÏäÕæÄÜ´óÐÐÆäµÀ£¬¸øÎÒÒ»¸öÀíÓÉ > http://mail.21cn.com/bijiao/index2-7.html > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: WinterSun Zha > 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: Kimberly 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). -- ¹úÄÚÊÕ·ÑÓÊÏäË×îÇ¿£¬Ê×´ÎȨÍþÆÀ²â¼û·ÖÏþ http://news.21cn.com/domestic/21CN/2001-11-19/550568.html ÂòÆóÒµÓÊÏ䣬»ñÔùÓòÃû http://mail.21cn.com/corporation/010.html ÊÕ·ÑÓÊÏäÕæÄÜ´óÐÐÆäµÀ£¬¸øÎÒÒ»¸öÀíÓÉ http://mail.21cn.com/bijiao/index2-7.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: diagnosing latch free
A sort extent pool latch? That's weird. You can get the sid of the guy holding the latch by joining v$latch.addr (or v$latchchildren if it's a latch with children - sort extent is not) against v$latchholder.laddr. something like select sid from v$latch l, v$latchholder lh where l.addr = lh.laddr and l.name = 'sort extent pool'; On Saturday, December 8, 2001, at 06:20 PM, Doug C wrote: > Ok.. it's a sort segment latch.. any way to find out why? It's been > sitting > around for over an hour ... > > On Sat, 08 Dec 2001 14:35:18 -0800, you wrote: > >> oops, probably only want the events that are latch frees: >> >> select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = >> ln.latch# and sw.event = 'latch free'; >> >> On Saturday, December 8, 2001, at 04:50 PM, George Schlossnagle wrote: >> >>> Try: >>> >>> select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = >>> ln.latch#. >>> >>> Best, >>> >>> George >>> >>> www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN >>> Smarter than adding another team member, Pythian has new services for >>> supplementing DBAs: get our help with monitoring, 24x7 on-call, daily >>> verifications, storage management, performance and more. >>> >>> >>> On Saturday, December 8, 2001, at 04:05 PM, Doug C wrote: >>> I have a session that seems to be hung on a sql_statment. Here is it's session_wait entry: SID SEQ# -- -- EVENT P1TEXT P1 -- P1RAWP2TEXT P2 P2RAW -- P3TEXT P3 -- P3RAW WAIT_TIME SECONDS_IN_WAIT STATE -- --- --- 62 1239 latch free address 805352248 3000B338 number 88 0058 tries 923 039B 0 0 WAITING The seq# goes up from time to time. My question is how to determine what kind of latch is bothering it? Does P2 (88) indicate what type of latch? Can I join with some other table to find out what 88 is? Thanks, D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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: George Schlossnagle >>> INET: [EMAIL PROTECTED] >>> >>> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>> San Diego, California-- Public Internet access / Mailing Lists >>> >>> To REMOVE yourself from this mailing list, send an E-Mail message >>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>> the message BODY, include a line containing: UNSUB ORACLE-L >>> (or the name of mailing list you want to be removed from). You may >>> also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Doug C > 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: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
RE: OCP
I wouldn't suggest it. That's probably TOO much information to digest. Best, Ed On Sun, 9 Dec 2001, CHAN Chor Ling Catherine (CSC) wrote: > Hi, > > Does the material from technet.oracle.com sufficient to pass the exam ? > > Regds, > New Bee > > -Original Message- > From: Ed [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 08, 2001 12:05 AM > To: Multiple recipients of list ORACLE-L > Subject:Re: OCP > > Just finished this a few months ago. My advice is to use the > Oracle Exam > Guide, Sybex Exam Guides, and Exam Cram as a third choice, > but get the other > two first. The ExamCram has much more detail, but does not > explain concepts > well. The STS (selftestsoftware.com) practice tests are > really very good. > I only used one, but it was done very well. I passed all > tests on the first > try with an average of about 90%. The actual tests are MUCH > harder than the > practice tests in the study guides (any of them). > > Also note, you not only need to study, but also TRY things. > I installed > Oracle on Linux at home and tinkered to my heart's content. > Make sure you > understand the DBA and V$ views or you won't pass. > > Best of luck, > > Ed > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Friday, December 07, 2001 4:40 AM > > > > Hi > > > > I have been a DBA for a few years now, I am consdering > doing the OCP exams > > > > I have bought the Oracle 8i DBA certification Exam Guide. > > > > However I have been informed by a fellow DBA that he > bought the same book, > > studied it and took the practice tests and was getting > around 90% in > > these tests.. however when he came to doing the actual he > just failed ! > > > > Does anyone have any thoughts on this ? > > > > Also is it possible to get mock exams that are more > reflective of the > > actual exams , from anywhere > > > > Regards > > > > Saj > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Sajid Iqbal > > 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: Ed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > San Diego, California-- Public Internet access / > Mailing Lists > > > To REMOVE yourself from this mailing list, send an E-Mail > message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). > You may > also send the HELP command for other information (like > subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: CHAN Chor Ling Catherine (CSC) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other informati
Re: Generating a SQLLDR Sequence Number
try replacing document_number sequence (max,80,1), with document_number sequence (max,1), sqlloader is taking 80 as your increment... docs show only 2 arguments for sequence function... hth > -Original Message- > Sent: Tuesday, December 04, 2001 11:01 AM > To: Multiple recipients of list ORACLE-L > > Tom: > > Ran into another problem. I need to generate a sequence number for one of > the DB columns. Here is the CTL code: > > document_number sequence (max,80,1), > > It runs but I keep getting the 80 that doubles for each record (80, > 160, 320, etc.). The book only shows the syntax but doesn't give an > example of how it works. > > Any ideas? > Thanks, > Ken > > -Original Message- > Sent: Tuesday, December 04, 2001 7:35 AM > To: Multiple recipients of list ORACLE-L > Subject:RE: SQL Loader Commit Point? > > Ken > > Did you look at the Sql*Loader log file? > Maybe all your records were rejected and placed into the .bad file? Does a > .bad file exist? Sql*Loader does not really consider rejected records an > error - it just moves them there. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > -Original Message- > Sent: Monday, December 03, 2001 4:33 PM > To: Multiple recipients of list ORACLE-L > > I am working on a control script that I have restricted to only loading 5 > records as a test. Basically I am taking data from the load file and > putting it into a table SQL Loader runs and gives me this. > > - > > SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001 > > (c) Copyright 2000 Oracle Corporation. All rights reserved. > > Commit point reached - logical record count 5 > > -- > > When I do a select on this table I get no rows selected. > > I don't get an error message from SQL Loader. > > So any ideas as to what the problem is? > > 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: Mercadante, Thomas F > 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: 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). > > 1> > This e-mail and any attachments may contain confidential and privileged information. >If you are not the intended recipient, please notify the sender immediately by return >e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this >information by a person other than the intended recipient is unauthorized and may be >illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the >author and are not endorsed by the author's employer. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumar, Dharminder > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---
RE: Where is the memory gone?
This sound pretty much like the same problem I had with 8.1.7 on HP. They have a memory leak when you connect/disconnect and it you have a lot of those you start to see it in your SGA. I had to patch to 8.1.7.1 plus an additional bug fix. Check on Metalink to see if there is the same problem with Windows. It also could be that you really do need more then 50M. Pin in the bigger packages you use (including Oracle's) right after startup and see where you are memory wise. -Original Message- Zhao Sent: Sunday, December 09, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Hi, DBAs: I find that one of our database's Shared Pool's memory decreased every day. It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory. When I check v$sgastat, I find the "miscellaneous" part of "shared pool" increased every day, it begans with 500K, then, after two days, it increased to 5586228 bytes, after about 10 days, it increased to 40M, and because I had allocated 50M to the Shared Pool, So the memory available became less and less. And I had to shutdown and restart the database when the available memory of shared pool is below 5M. I want to know why the memory occupied by "miscellaneous" part is increased? The other database on solaris did not increased. How can I find out what is it? How to prevent it or resolve it without shutdown and restart the database? ( alter system flush shared pool only flush the sql and library cache, and it didn't decrease the miscellaneous part's memory usage. ) Thank you very much! WinterSun -- ¹úÄÚÊÕ·ÑÓÊÏäË×îÇ¿£¬Ê×´ÎȨÍþÆÀ²â¼û·ÖÏþ http://news.21cn.com/domestic/21CN/2001-11-19/550568.html ÂòÆóÒµÓÊÏ䣬»ñÔùÓòÃû http://mail.21cn.com/corporation/010.html ÊÕ·ÑÓÊÏäÕæÄÜ´óÐÐÆäµÀ£¬¸øÎÒÒ»¸öÀíÓÉ http://mail.21cn.com/bijiao/index2-7.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: Kimberly 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).
Where is the memory gone?
Hi, DBAs: I find that one of our database's Shared Pool's memory decreased every day. It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory. When I check v$sgastat, I find the "miscellaneous" part of "shared pool" increased every day, it begans with 500K, then, after two days, it increased to 5586228 bytes, after about 10 days, it increased to 40M, and because I had allocated 50M to the Shared Pool, So the memory available became less and less. And I had to shutdown and restart the database when the available memory of shared pool is below 5M. I want to know why the memory occupied by "miscellaneous" part is increased? The other database on solaris did not increased. How can I find out what is it? How to prevent it or resolve it without shutdown and restart the database? ( alter system flush shared pool only flush the sql and library cache, and it didn't decrease the miscellaneous part's memory usage. ) Thank you very much! WinterSun -- ¹úÄÚÊÕ·ÑÓÊÏäË×îÇ¿£¬Ê×´ÎȨÍþÆÀ²â¼û·ÖÏþ http://news.21cn.com/domestic/21CN/2001-11-19/550568.html ÂòÆóÒµÓÊÏ䣬»ñÔùÓòÃû http://mail.21cn.com/corporation/010.html ÊÕ·ÑÓÊÏäÕæÄÜ´óÐÐÆäµÀ£¬¸øÎÒÒ»¸öÀíÓÉ http://mail.21cn.com/bijiao/index2-7.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: OCP
Hi, Does the material from technet.oracle.com sufficient to pass the exam ? Regds, New Bee -Original Message- From: Ed [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 08, 2001 12:05 AM To: Multiple recipients of list ORACLE-L Subject:Re: OCP Just finished this a few months ago. My advice is to use the Oracle Exam Guide, Sybex Exam Guides, and Exam Cram as a third choice, but get the other two first. The ExamCram has much more detail, but does not explain concepts well. The STS (selftestsoftware.com) practice tests are really very good. I only used one, but it was done very well. I passed all tests on the first try with an average of about 90%. The actual tests are MUCH harder than the practice tests in the study guides (any of them). Also note, you not only need to study, but also TRY things. I installed Oracle on Linux at home and tinkered to my heart's content. Make sure you understand the DBA and V$ views or you won't pass. Best of luck, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 4:40 AM > Hi > > I have been a DBA for a few years now, I am consdering doing the OCP exams > > I have bought the Oracle 8i DBA certification Exam Guide. > > However I have been informed by a fellow DBA that he bought the same book, > studied it and took the practice tests and was getting around 90% in > these tests.. however when he came to doing the actual he just failed ! > > Does anyone have any thoughts on this ? > > Also is it possible to get mock exams that are more reflective of the > actual exams , from anywhere > > Regards > > Saj > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > 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: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Backups
Hello folks, We are looking into the VxFS/UFS snapshot utlities, and I am curious how you can quiesce an Oracle instance? I would like all changes to the buffer cache to be flushed to the file system and checkpoints to occur. What would I need to run to do this? I assume this would give the file system a consistent view of the database. We are going to play with this in our test environment. Thanks for any info, - Ryn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ryn 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: Installing Oracle on W2k
>Any-body had any similar experience? Oh yeahand how. Yours is a Pentium 4 box ? then read on... It's a well-known problem... The reason for this is that the P4 architecture has problems with the Java Just In Time installer. I'm not going to repeat it here. The detailed answers are on orafaq.com, just search on "installation windows 2000" Robert - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 12:30 AM > Hi All, > > I am trying to install oracle 8.1.7 on W2k Server. > OUI doesn't start at all. What could be wrong? Any-body had > any similar experience? > > TIA, > Rajesh > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: RAJESH DAYAL > 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: Robert Chin 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).
