[no subject]
hi, Anybody got some oracle question dumps or resources for oracle certified internet database administrator exam ?? (exam #1Z0 -411). Thanks in advance :) rgds sunil
Re: snapshot too old
Seema Singh wrote: > > Hi > At time of export i am getting following error > "EXP-8: ORACLE error 1555 encountered > ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too > small" > > Please suggest > Thanks > -Seema Mladen, any idea ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Raw I/O
Thanks Martin I guess that's what we need... Witold On 16 Jan 2002 at 12:15, Martin Kendall wrote: > Hey now, be nice :-). The best thing is to point people towards > the archives. > > Martin > > http://oracle-rescue.com > > -Original Message- > Mladen > Sent: 16 January 2002 19:57 > To: Multiple recipients of list ORACLE-L > > > Real life opinion from me: > Yes, Oxford is using it. Yes, it is faster. Yes it makes it practically > impossible > to backup without a 3rd party backup tool. Yes, it is boring to chew "raw > vs. cooked" > debate over and over again. Why doesn't someone come up with something new > and not yet discussed topic like "RAID implementations and oracle"? > > > -Original Message- > Sent: Wednesday, January 16, 2002 2:37 PM > To: Multiple recipients of list ORACLE-L > > > Hi all > > I am looking for some "real life" opinions about Oracle raw I/O - are > people using it, is there really a performance gain? Any other pros, > cons? > I have seen some info on Metalink but "real life" often is quite > different... > > Thanks > > Witold > == > Witold Iwaniec > Sr Software Developer > NovaLIS Technologies > [EMAIL PROTECTED] > http://www.novalistech.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Witold Iwaniec > 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: Gogala, Mladen > 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: Martin Kendall > 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: Witold Iwaniec 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).
[Q] can ORACLE FORMS 2.1 and 6i run under same NT computer?
Has anyone installed and run ORACLE FORMS 2.1 and 6i run time version under same NT compter? Will any problem happen? Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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).
Standby Instance questions and HA
Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. >From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: Disaster recovery using RMAN
Sona - I am planning to test a disaster recovery using RMAN also. My company won't completely trust it until I can. Like you, I currently use RMAN to back up to disk, and write the backup to tape, keeping a Level 0 backup on disk. Here are the steps I am planning for disaster recovery. 1. Export the RMAN catalog and FTP a copy to the target system each time nightly backups are complete. 2. Back the Level 0 backup to tape, along with RMAN catalog export. 3. Mount the tape on the disaster recovery test system. 4. Assume that same version of Oracle is installed on the disaster recovery test system. 5. Create an RMAN user and import the RMAN catalog export. 6. Copy the RMAN Level 0 backup to disk. If possible, put it on the same path as on the original machine. If not, create a link so it looks like the same location to the system. 7. Begin RMAN recovery, changing disk locations for the data files, as needed. I'm just listing these off the top of my head, so I may have left something out. If you or any other listers see anything amiss with my plans, please point that out. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 5:21 PM To: Multiple recipients of list ORACLE-L Hi Here in my company we are planning to put together a disaster recovery plan using RMAN would like to test various recovery scenarios using RMAN. Could anyone provide the information on the procedures followed in a testing like this? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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:[Q] can ORACLE FORMS 2.1 and 6i run under same NT compute
If I remember right forms 2.1 depends on SQL*Net V1 which is not supported on NT. Should break. Dick Goulet Reply Separator Author: "dist cash" <[EMAIL PROTECTED]> Date: 1/17/2002 4:55 AM Has anyone installed and run ORACLE FORMS 2.1 and 6i run time version under same NT compter? Will any problem happen? Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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[2]: Why doesn't Oracle kill dead connections?
I believe in your case no since the browser is not connected to the database, but the web server is and is alive. The real issue is does the web server know that the client closed his/her browser and terminate the session. I doubt it. Dick Goulet --- But in my case if DCD is set up and the browser is closed will the web server know that the connection has been closed and will it tell Oracle to kill the session? TIA -- 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: Using RMAN
Soma - RMAN will only know about the disk backup since you aren't using a media manager like Legato or Veritas. When it needs to recover, RMAN will look to that spot on the disk and expect the correct file to be there. If for some reason the version on disk is unusable and RMAN needs an older version, RMAN will complain that the correct file isn't there, then you will have to load the version RMAN wants from tape before RMAN can continue. At least this is the way I understand RMAN will work. I haven't tried it, so if someone the list has better information, I would appreciate their response. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 5:21 PM To: Multiple recipients of list ORACLE-L Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
index hint
> -Oorspronkelijk bericht- > Van: Jeroen van Sluisdam > Verzonden:donderdag 17 januari 2002 14:40 > Aan: '[EMAIL PROTECTED]' > Onderwerp:index hint > > Hi, > > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working > again > on same performance after an index has been added in order to get around > possible > deadlocks because of use of a foreign key relation. > I tried adding an hint but this doesn't work, am I making typos? > DB is on choose optimizer > > delete from plan_table; > explain plan > set statement_id = 'test' for > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */ > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime , > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full , > oa.option_type > FROM > bedfinder_published_objects bo, > option_allotments oa > WHERE > bo.contract_id = oa.contract_id > AND > bo.so_id = oa.so_id > AND >datetime >= trunc(sysdate) > ORDER BY 2,3,4,5 > > Tia, > > Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam 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: Raw I/O
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Database Views
Hello Srini We had a case like this where one of the tables was in a database that reside in a remote site. Our solution was to create a table that combine employees tables from 2 site into one TABLE in the local site. This way the select and join is done ONCE at night. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wed, January 16, 2002 10:05 PM > To: Multiple recipients of list ORACLE-L > Subject: Database Views > > I would like get your opinion on what would be the best way provide access > to data across multiple databases on just on Node (database). > > One way that I have tried is create a view on one database that reads > tables > across remaining four databases using Dblinks. Let us say there is a > table > called CUSTOMER that resides on five databases, in order to make it easier > to generate reports, a combined view can be created with dblinks on these > tables using UNION ALL on one database. > > Only concern I have is that when using Dblinks, Oracle might copy the > entire > remote table to the local database and then retrieve the data based on > where > clause. This might be a significant performance issue especially if the > tables are very BIG. > > If there are better ways to accomplish this or any ideas on this one will > be > greatly appreciated. > > Thank you, > Srini > > -- > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Using RMAN
If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 6:20 PM Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: index hint
Jeroen, You need to reference the table in the hint with the alias that you gave it in the from clause (oa), then the hint should work. Jeroen van Sluisdam wrote: > > -Oorspronkelijk bericht- > > Van: Jeroen van Sluisdam > > Verzonden:donderdag 17 januari 2002 14:40 > > Aan: '[EMAIL PROTECTED]' > > Onderwerp:index hint > > > > Hi, > > > > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working > > again > > on same performance after an index has been added in order to get around > > possible > > deadlocks because of use of a foreign key relation. > > I tried adding an hint but this doesn't work, am I making typos? > > DB is on choose optimizer > > > > delete from plan_table; > > explain plan > > set statement_id = 'test' for > > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */ > > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime , > > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full , > > oa.option_type > > FROM > > bedfinder_published_objects bo, > > option_allotments oa > > WHERE > > bo.contract_id = oa.contract_id > > AND > > bo.so_id = oa.so_id > > AND > >datetime >= trunc(sysdate) > > ORDER BY 2,3,4,5 > > > > Tia, > > > > Jeroen > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeroen van Sluisdam > 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8.1.7 install error
Hello Ron I usually get this error when some other service is still using the DLL. I then start to stop all the services that I think use Oracle and hit retry. If still in error I just starting to stop all services on the machine, and hitting retry after stopping two or three services. At the end the retry succeed. Of course the first thing that I do after the install complete is boot. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] > Sent: Wed, January 16, 2002 4:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Oracle 8.1.7 install error > > I keep getting the following error while trying to install Oracle 8.1.7 on > my NT server. > There is over 1G of freespace on the drive. If I say ignore, the > installer > continues to run. > Any ideas? > > Error in writing to file c:\winnt\system32\ctl3d32.dll > > Ron > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: index hint
Refer to aliases (in that case 'oa'), not tablenames, in hints. Jeroen van Sluisdam wrote: > > > -Oorspronkelijk bericht- > > Van: Jeroen van Sluisdam > > Verzonden:donderdag 17 januari 2002 14:40 > > Aan: '[EMAIL PROTECTED]' > > Onderwerp:index hint > > > > Hi, > > > > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working > > again > > on same performance after an index has been added in order to get around > > possible > > deadlocks because of use of a foreign key relation. > > I tried adding an hint but this doesn't work, am I making typos? > > DB is on choose optimizer > > > > delete from plan_table; > > explain plan > > set statement_id = 'test' for > > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */ > > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime , > > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full , > > oa.option_type > > FROM > > bedfinder_published_objects bo, > > option_allotments oa > > WHERE > > bo.contract_id = oa.contract_id > > AND > > bo.so_id = oa.so_id > > AND > >datetime >= trunc(sysdate) > > ORDER BY 2,3,4,5 > > > > Tia, > > > > Jeroen > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeroen van Sluisdam > 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). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: index hint
change the hint to /*+ INDEX(oa I_OPTION_ALLOTMENTS_2) */ if the statement uses an alias for a table, then the hint must use the alias too 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. " - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 15:45 > > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */ > > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime , > > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full , > > oa.option_type > > FROM > > bedfinder_published_objects bo, > > option_allotments oa > > WHERE > > bo.contract_id = oa.contract_id > > AND > > bo.so_id = oa.so_id > > AND > >datetime >= trunc(sysdate) > > ORDER BY 2,3,4,5 > > -- 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: Partitions
Having said all that, I suggest that you keep the statistics on these partitions up to date to help the optimizer... Of course, if data in some of the partitions become static, there is no need to analyze those partitions. - Kirti -Original Message- Sent: Thursday, January 17, 2002 8:02 AM To: Multiple recipients of list ORACLE-L Hamid, Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search for the data you have requested. If the table is 1 tablespace and large in size, it can take an enormous amount of resources to find the data you selected. If the table is partitioned correctly, Oracle will only search the partition/s that it needs to find your data. The application code does not need to be changed. The application will request data from a table and Oracle will determine which partition to use. ROR mª¿ªm >>> [EMAIL PROTECTED] 01/16/02 04:06PM >>> List, If we use partitioning for a big tables after finish development, do we have to change the code for accReceived: from CONNECT-MTA by galotteressing diffrent partition or this will handle by oracle itself. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Partitions
Hamid, Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search for the data you have requested. If the table is 1 tablespace and large in size, it can take an enormous amount of resources to find the data you selected. If the table is partitioned correctly, Oracle will only search the partition/s that it needs to find your data. The application code does not need to be changed. The application will request data from a table and Oracle will determine which partition to use. ROR mª¿ªm >>> [EMAIL PROTECTED] 01/16/02 04:06PM >>> List, If we use partitioning for a big tables after finish development, do we have to change the code for accReceived: from CONNECT-MTA by galotteressing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -: SQL BackTrack info
Has anybody did tests for Sqlbacktrack Vs Oracle rman? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Valuthur, Srikanth [SMTP:[EMAIL PROTECTED]] > Sent: Wed, January 16, 2002 10:40 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: OT -: SQL BackTrack info > > Its a great product for the price. I have used it in and out for 5 years > internationally and truly it is the best backup/recovery product we have. > There are some pros and cons to using the tool: > > Pros: > > 1. Great product, works brilliant & works all the time. > 2. Upgrades are simple. > > Cons: > > 1. Price > 2. Support is a mess(most of the time) > 3. You have to read the whole manual to understand it. Never skip pages > on > that. > 4. FOLLOW THEIR INSTURCTIONS. MOST IMPORTANT. NO PRESUMPTIONS ALLOWED. > Whether it is to install or deinstall, You have to follow their step by > step instructions for it to work properly. > > We tried several ways for the product to work properly and finally > surrendered to the manual. ORACLE DBAs - We cannot use the oracle > technique for SQL B/T > > My 2 cents > > Srikanth > > -Original Message- > Sent: Wednesday, January 16, 2002 1:14 PM > To: Multiple recipients of list ORACLE-L > > > We have been using it for about 5 years on both Unix and NT. We have it > connected to Netbackup to handle the tapes. We love it. I agree that the > > support is not what it used to be but we hardly ever need support. > Although, the last time we called we got a support person that knew more > about Oracle than > we did and knew SQL Backtrack inside and out. It's a great tool! > > Ron Smith > Kerr-McGee Corp > > -Original Message- > Sent: Wednesday, January 16, 2002 10:55 AM > To: Multiple recipients of list ORACLE-L > > > I am looking for some guidance from people who use this product. Is it a > value add to the organization or not. If possible also let me know how in > the hell does it do a online object extraction from the backup. > > Would appreciate all your comments and recommendations > > Thx > Gautam > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > 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: Valuthur, Srikanth > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Database Views
that works as long as you can live with possibly inconsistent data in the joint table due to either 1) updates to the employee data on either site during the day not reflected in the joint table until the nightly processing is done 2) nightly process failing and data in the joint table either non-existent or wrong --- àãø_éçéàì <[EMAIL PROTECTED]> wrote: > Hello Srini > > We had a case like this where one of the tables was in a database > that > reside in a remote site. > Our solution was to create a table that combine employees tables from > 2 site > into one TABLE in the local site. > > This way the select and join is done ONCE at night. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Sent: Wed, January 16, 2002 10:05 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Database Views > > > > I would like get your opinion on what would be the best way provide > access > > to data across multiple databases on just on Node (database). > > > > One way that I have tried is create a view on one database that > reads > > tables > > across remaining four databases using Dblinks. Let us say there is > a > > table > > called CUSTOMER that resides on five databases, in order to make it > easier > > to generate reports, a combined view can be created with dblinks on > these > > tables using UNION ALL on one database. > > > > Only concern I have is that when using Dblinks, Oracle might copy > the > > entire > > remote table to the local database and then retrieve the data based > on > > where > > clause. This might be a significant performance issue especially > if the > > tables are very BIG. > > > > If there are better ways to accomplish this or any ideas on this > one will > > be > > greatly appreciated. > > > > Thank you, > > Srini > > > > -- > > 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). > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > This e-mail was scanned by the eSafe Mail Gateway > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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: Which Character set?
Hey Ron, Here's that whitepaper I had mentioned on the list... Why We Are Moving Our Databases to the UTF8 Character Set by David F. Pennington, GlaxoSmithKline HTH Chris PS. For everyone else, you can find the whitepaper using Google, or email me direct. -Original Message- Sent: Wednesday, January 16, 2002 10:57 AM To: Multiple recipients of list ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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). Why We Are Moving Our Databases to the UTF8 Character Set.doc Description: MS-Word document
RE: How to calculate user load on the system
Raj, Maybe another option would be to "audit session" for the database. For each logon/logoff you would see the logical/physical reads and the logical writes ( in dba_audit_session) by Oracle username (or osusername). Chaim "Aponte, Tony" <[EMAIL PROTECTED]>@fatcity.com on 01/16/2002 06:15:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Then you're in luck. I'd recommend starting with Oracle Response Time Analysis from www.orapub.com. Although it won't give you exactly what you need, it will help you get to the next step. Once you understand a session's response time components, it's a short hop to figuring out the V$SESSTAT statistics that make up the CPU time, physical/logical I/O operations and memory footprint. HTH Tony -Original Message- Sent: Wednesday, January 16, 2002 5:54 PM To: Aponte, Tony; [EMAIL PROTECTED] Database Load ... is the main target at this time ... Thanks Tony, Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Wednesday, January 16, 2002 5:53 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)? Tony -- 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: Raw I/O
I have been searching for the same answers for a long time and have downloaded a lot of papers on the "raw vs cooked" and to get definitive answers is a complicated task. Simple methods and opinions and examples will go a long way in the understanding of a controversial and complicated subject. Yes, I know that it is faster, more complicated, a bear to administer but the answer is "it is used today in quite a few shops". More informative answers would be appreciated and would help in the decision process of "should we or shouldn't we use raw devices" and what are the pitfalls and advantages if we do. A guide ,reference, or link to help in the decisions would be a blessing. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: RMAN backup and restore Q?
Hi
My problem went away when I did a startup mount of the database.
I have Rman user in TEST2 just for testing purposes (same username password
on target & catalog is easier with ctrl C & ctrl V)
One more question if I may.
Do you or anybody else have an example of a very complex rman command(most
of the features used) and an example of cloning a database on the same host
with renaming of the log& datafiles? Documentation explains a lot but is
very limited in the examples and the syntax errors are easy to make.
TIA
Jack
"Jay Hostetter" <[EMAIL PROTECTED]>@fatcity.com on 16-01-2002
14:10:24
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
What version of the database are you using? My info here is based on
8.1.7.
I connect to my databases as internal to do the backups. I fire up RMAN
with either one of these commands:
rman target / catalog rman/rman@test1 (SID must be set correctly)
rman target internal/pwd@test2 catalog rman/rman@test1
I'm not sure why you have an rman user in test2, unless you set up a second
catalog so that you can backup your first catalog.
To test your restore, shutdown test2 and delete all the .dbf, .log, .arc,
and .ctl files. Then startup nomount the test2 database. Then try this:
rman target internal/pwd@test2 catalog rman/rman@test
run {
allocate channel ch1 type disk;
restore controlfile;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}
If you did a hot backup, you may need your archivelog backups. This
command backs up the archivelogs:
run
{
allocate channel ch1 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1 Gb.
backup archivelog until time 'sysdate-1/24' delete input;
backup archivelog from time 'sysdate-1/24';
}
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 01/16/02 07:25AM >>>
Hi All,
I'm in the process of figuring out the workings of RMAN and created 2 test
databases.
TEST1 = catalog database
TEST2 = target database
I have created the catalogs and registered the database with the catalog.
I than mad a full backup of the database TEST2 (is in Archivelog mode)
with the following syntax
**BACKUP
rman
Re: index hint
Try to use table alias in your hint instead of table name. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 8:45 AM > > > > -Oorspronkelijk bericht- > > Van: Jeroen van Sluisdam > > Verzonden: donderdag 17 januari 2002 14:40 > > Aan: '[EMAIL PROTECTED]' > > Onderwerp: index hint > > > > Hi, > > > > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working > > again > > on same performance after an index has been added in order to get around > > possible > > deadlocks because of use of a foreign key relation. > > I tried adding an hint but this doesn't work, am I making typos? > > DB is on choose optimizer > > > > delete from plan_table; > > explain plan > > set statement_id = 'test' for > > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */ > > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime , > > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full , > > oa.option_type > > FROM > > bedfinder_published_objects bo, > > option_allotments oa > > WHERE > > bo.contract_id = oa.contract_id > > AND > > bo.so_id = oa.so_id > > AND > >datetime >= trunc(sysdate) > > ORDER BY 2,3,4,5 > > > > Tia, > > > > Jeroen > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeroen van Sluisdam > 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -: SQL BackTrack info
We must have been lucky because BMC support really saved our butt a few months back when we got a copy of LOGMASTER to recover some data from some archived redo logs (long story). We were really impressed with their support and everyone within our group commented on how helpful and knowledgeable they were and how we wished Oracle support was the same. Never called for support on the SQL*Backtrack product but we have it and love it. Maybe it was a fluke that we got good support from BMC but I expect so little from corporations technical support staff that I was really blown away with theirs on that occasion. Oracle support has made me a very jaded person. ;-) - Brian --- [EMAIL PROTECTED] wrote: > > Ok, you guys are really missing the support issue. :) > > The support is very bad. Yes, you don't need it often. > > But when you do need it, they don't have it. > > SQL*Backtrack is normally run as a menu to the > back end tools. As I recall, even most of the commands > used in cron for scheduled backups are wrappers to > the back end tools. > > There are recovery situations that cannot be peformed from > the SQL*Backtrack menu. If you run into one of those, and > cannot figure it out, support will be unable to help you. > > They know how to use the menu mode, and that's about it. > > Just after leaving a previous job where SQL*Backslack is > still in use, a tablespace in the data warehouse was trashed. > > It took 30+ days to recover it. This is mostly due to inept support > from BMC. They like to do a lot of finger pointing, such as > 'Your Legato indexes need rebuilt', even though that does > not fix the problem. > > It used to be a great tool, and probably still is. I would not but > it based simply on support issues. > > Jared > > > > > > > "Smith, Ron > > L." To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED] cc: > > om> Subject: RE: OT -: SQL > BackTrack info > Sent by: > > [EMAIL PROTECTED] > > om > > > > > > 01/16/02 11:13 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > We have been using it for about 5 years on both Unix and NT. We have > it > connected to Netbackup to handle the tapes. We love it. I agree > that the > support is not what it used to be but we hardly ever need support. > Although, the last time we called we got a support person that knew > more > about Oracle than > we did and knew SQL Backtrack inside and out. It's a great tool! > > Ron Smith > Kerr-McGee Corp > > -Original Message- > Sent: Wednesday, January 16, 2002 10:55 AM > To: Multiple recipients of list ORACLE-L > > > I am looking for some guidance from people who use this product. Is > it a > value add to the organization or not. If possible also let me know > how in > the hell does it do a online object extraction from the backup. > > Would appreciate all your comments and recommendations > > Thx > Gautam > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > 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-Mai
Re: Standby Instance questions and HA
What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. "James McCann" lecom.com> cc: Sent by:Subject: Standby Instance questions and HA [EMAIL PROTECTED] 01/17/2002 06:40 AM Please respond to ORACLE-L Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. >From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: Allen R. Lucas 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).
AW: Database Views
You also can use materialized views (snapshots), which can be populated every night. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 17. Januar 2002 14:51 An: Multiple recipients of list ORACLE-L Betreff: RE: Database Views Hello Srini We had a case like this where one of the tables was in a database that reside in a remote site. Our solution was to create a table that combine employees tables from 2 site into one TABLE in the local site. This way the select and join is done ONCE at night. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wed, January 16, 2002 10:05 PM > To: Multiple recipients of list ORACLE-L > Subject: Database Views > > I would like get your opinion on what would be the best way provide > access to data across multiple databases on just on Node (database). > > One way that I have tried is create a view on one database that reads > tables across remaining four databases using Dblinks. Let us say > there is a table > called CUSTOMER that resides on five databases, in order to make it easier > to generate reports, a combined view can be created with dblinks on these > tables using UNION ALL on one database. > > Only concern I have is that when using Dblinks, Oracle might copy the > entire remote table to the local database and then retrieve the data > based on where > clause. This might be a significant performance issue especially if the > tables are very BIG. > > If there are better ways to accomplish this or any ideas on this one > will be greatly appreciated. > > Thank you, > Srini > > -- > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Schoen Volker 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: Standby Instance questions and HA
I think your right. But does anyone know what is use on Solaris? Thanks, Jim -Original Message- Sent: 17 January 2002 15:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. "James McCann" lecom.com> cc: Sent by:Subject: Standby Instance questions and HA [EMAIL PROTECTED] 01/17/2002 06:40 AM Please respond to ORACLE-L Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. >From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: James McCann 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).
Session info
Hi Listers, We can find the program executed from Client in 'program' field in v$session. But the problem is the field length just 48 character. Is there any other dictionary (v$ or x$ ?) to find 'the client program' completely (more than 48 character) ? Thanks. Aldi _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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).
Oracle8i and the Jserv demos
Hi I have installed Oracle 8.1.7.0 on an AIX 4.3 box and the Jserv demos do not work. I looked at the jserv.log and it seems to not be finding the java executables. I downloaded Java.rte for AIX from IBM and put it in the $ORACLE_HOME/Apache/jdk/bin directory but it still doesn't work. I am not too familiar with AIX so can anyone explain to me how and where to install java on an AIX box. I would open a tar but we renewed our licenses and ever since I have been unable to get registered properly with MetaLink. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Raw I/O
Tuning apps and SQL will nearly always yield a much bigger performance gain than using raw filesystems rather than cooked. It's not too unusual to find a very few pieces of code or SQL in an app that can provide dramatic improvements. Even with 3rd party apps there are often opportunities for improving data access via indexes and partitioning. Jared On Thursday 17 January 2002 06:50, Ron Rogers wrote: > I have been searching for the same answers for a long time and have > downloaded a lot of papers on the "raw vs cooked" and to get definitive > answers is a complicated task. Simple methods and opinions and examples > will go a long way in the understanding of a controversial and > complicated subject. Yes, I know that it is faster, more complicated, a > bear to administer but the answer is "it is used today in quite a few > shops". More informative answers would be appreciated and would help in > the decision process of "should we or shouldn't we use raw devices" and > what are the pitfalls and advantages if we do. A guide ,reference, or > link to help in the decisions would be a blessing. > ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: [Q] can ORACLE FORMS 2.1 and 6i run under same NT computer?
The only way this could work is to have a separate Oracle home for the Forms 2.1, with the appropriate binaries. And since this is a very old version of Oracle, you would need another box to put it on. And then it still might not work. Jared On Thursday 17 January 2002 04:55, dist cash wrote: > Has anyone installed and run ORACLE FORMS 2.1 and 6i run time version > under same NT compter? > > Will any problem happen? > > > Thanks. > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: SQL Loader Direct Load - Problem with Index Rebuild
Hello Jay Here is a little script that will generate the commands needed to rebuild the indexes: spool rebuild.sql select distinct 'alter table '||table_name||' modify partition '||p.partition_name||' rebuild unusable local indexes;' from user_ind_partitions p, user_TAB_PARTITIONS t where p.status='UNUSABLE' and p.partition_name=t.partition_name; select distinct 'alter index '||index_name||' rebuild;' from user_indexes where status='INVALID' or status='UNUSABLE'; spool off Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Miller, Jay [SMTP:[EMAIL PROTECTED]] > Sent: Wed, January 16, 2002 5:51 PM > To: Multiple recipients of list ORACLE-L > Subject: SQL Loader Direct Load - Problem with Index Rebuild > > Hi, > > Okay, this is the second time this has happened and while I have a guess > I'd > appreciate any feedback on the issue. Last night during a direct load to > one of our datawarehouse tables 4 of the index partition rebuilds failed > with the following errors (the remaining partitions were fine, as were all > the other indexes): > > index EIS.IDX_BKP_TRANS_DATE partition BOOK2001OCT was made unusable due > to: > ORA-01652: unable to extend temp segment by 320 in tablespace > TS_BOOKKEEPING_FACT_IDX > index EIS.IDX_BKP_TRANS_DATE partition BOOK2001NOV was made unusable due > to: > ORA-01658: unable to create INITIAL extent for segment in tablespace > TS_BOOKKEEPING_FACT_IDX > index EIS.IDX_BKP_TRANS_DATE partition BOOK2001DEC was made unusable due > to: > ORA-01658: unable to create INITIAL extent for segment in tablespace > TS_BOOKKEEPING_FACT_IDX > index EIS.IDX_BKP_TRANS_DATE partition BOOK2002JAN was made unusable due > to: > ORA-01658: unable to create INITIAL extent for segment in tablespace > TS_BOOKKEEPING_FACT_IDX > > I was able to manually rebuild the index partitions with no problem. > > There are currently 1,881 free extents of the size 320 blocks in that > tablespace. The entire index (including all partitions) only takes up 473 > extents. We have degrees=1 on the index. > > There's a metalink Forum thread (ORA 1652 During Direct Load) where a > similar problem occurred. It seems to imply each index may be claiming 2x > it's required space while being rebuilt and that SMON might not clean up > that space right away. This could certainly have caused there to be not > enough space available if it required the tablespace to be 2x the size of > *all* the indexes. In that case the fact that SMON cleaned it up before I > did the manual rebuild would explain why the latter worked. > Looking at the tablespace I see that it is currently almost 2x the size so > it's possible that's why I had avoided the problem for the last few > months. > > Has anyone else had this problem and is there a workaround short of > dropping > the indexes before the load and recreating them? I'd rather avoid that > since it's usually only a few partitions that need to be rebuilt. > > I'm on Oracle 8.1.6.3, Solaris 2.6. > > Thanks, > Jay Miller > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Database Views
This is why data marts were created. You would be much better off to create a reporting database based on the data you need to see. You won't be happy doing this with views from several databases. It won't perform well. As Rachel pointed out it will be inconsistent. At the very least you could create snapshots of these tables so that all of the data would be locally available. Just my $0.02. Jared On Wednesday 16 January 2002 12:04, [EMAIL PROTECTED] wrote: > I would like get your opinion on what would be the best way provide access > to data across multiple databases on just on Node (database). > > One way that I have tried is create a view on one database that reads > tables across remaining four databases using Dblinks. Let us say there is > a table called CUSTOMER that resides on five databases, in order to make it > easier to generate reports, a combined view can be created with dblinks on > these tables using UNION ALL on one database. > > Only concern I have is that when using Dblinks, Oracle might copy the > entire remote table to the local database and then retrieve the data based > on where clause. This might be a significant performance issue especially > if the tables are very BIG. > > If there are better ways to accomplish this or any ideas on this one will > be greatly appreciated. > > Thank you, > Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Database Views
Hello Rachel 1) Yes. You can also change your application to update the new table whenever something change in one of the file. Since personal do not change every day (hopefully) one day lag is OK for us. 2) This is done with SQL program that do delete and then insert and commit. Either the program works and I have a new copy or it didn't work and I am left with yesterday data. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Thu, January 17, 2002 4:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Database Views > > that works as long as you can live with possibly inconsistent data in > the joint table due to either > > 1) updates to the employee data on either site during the day not > reflected in the joint table until the nightly processing is done > > 2) nightly process failing and data in the joint table either > non-existent or wrong > > > --- àãø_éçéàì <[EMAIL PROTECTED]> wrote: > > Hello Srini > > > > We had a case like this where one of the tables was in a database > > that > > reside in a remote site. > > Our solution was to create a table that combine employees tables from > > 2 site > > into one TABLE in the local site. > > > > This way the select and join is done ONCE at night. > > > > Yechiel Adar, Mehish Computer Services > > [EMAIL PROTECTED] > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > > Sent: Wed, January 16, 2002 10:05 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Database Views > > > > > > I would like get your opinion on what would be the best way provide > > access > > > to data across multiple databases on just on Node (database). > > > > > > One way that I have tried is create a view on one database that > > reads > > > tables > > > across remaining four databases using Dblinks. Let us say there is > > a > > > table > > > called CUSTOMER that resides on five databases, in order to make it > > easier > > > to generate reports, a combined view can be created with dblinks on > > these > > > tables using UNION ALL on one database. > > > > > > Only concern I have is that when using Dblinks, Oracle might copy > > the > > > entire > > > remote table to the local database and then retrieve the data based > > on > > > where > > > clause. This might be a significant performance issue especially > > if the > > > tables are very BIG. > > > > > > If there are better ways to accomplish this or any ideas on this > > one will > > > be > > > greatly appreciated. > > > > > > Thank you, > > > Srini > > > > > > -- > > > 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). > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > > This e-mail was scanned by the eSafe Mail Gateway > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > > 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!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > 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
RE: Standby Instance questions and HA
Check the Sun web site. Sun has clustering. I do not know the name of the product off the top of my head since I use HP MC/ServiceGuard. -Original Message- McCann Sent: Thursday, January 17, 2002 7:06 AM To: Multiple recipients of list ORACLE-L I think your right. But does anyone know what is use on Solaris? Thanks, Jim -Original Message- Sent: 17 January 2002 15:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. "James McCann" lecom.com> cc: Sent by:Subject: Standby Instance questions and HA [EMAIL PROTECTED] 01/17/2002 06:40 AM Please respond to ORACLE-L Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. >From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: James McCann 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).
RE: Database Views
Thank you all for your opinions. The tables that I want to consolidate are 15 Million rows each. So five tables put together will constitute 75 million rows in one table. I will have to consider partitioning after that for optimum performance. Also Materialized view would take a long time to refresh all these tables especially if it is a complete refresh. - Srini -Original Message- Sent: Thursday, January 17, 2002 10:21 AM To: Multiple recipients of list ORACLE-L This is why data marts were created. You would be much better off to create a reporting database based on the data you need to see. You won't be happy doing this with views from several databases. It won't perform well. As Rachel pointed out it will be inconsistent. At the very least you could create snapshots of these tables so that all of the data would be locally available. Just my $0.02. Jared On Wednesday 16 January 2002 12:04, [EMAIL PROTECTED] wrote: > I would like get your opinion on what would be the best way provide access > to data across multiple databases on just on Node (database). > > One way that I have tried is create a view on one database that reads > tables across remaining four databases using Dblinks. Let us say there is > a table called CUSTOMER that resides on five databases, in order to make it > easier to generate reports, a combined view can be created with dblinks on > these tables using UNION ALL on one database. > > Only concern I have is that when using Dblinks, Oracle might copy the > entire remote table to the local database and then retrieve the data based > on where clause. This might be a significant performance issue especially > if the tables are very BIG. > > If there are better ways to accomplish this or any ideas on this one will > be greatly appreciated. > > Thank you, > Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Standby Instance questions and HA
"Full Moon. " (it's going through stages, waxing. give me a break.) Supposedly they named it that because wolves howl at the moon. Get it? "Wolfpack" is microsoft's clustering moniker. Give me another break. Doesn't Scott McNealy have a jacuzzi at home he can spend time in?) -Original Message- Check the Sun web site. Sun has clustering. I do not know the name of the product off the top of my head since I use HP MC/ServiceGuard. -Original Message- McCann Sent: Thursday, January 17, 2002 7:06 AM To: Multiple recipients of list ORACLE-L I think your right. But does anyone know what is use on Solaris? Thanks, Jim -Original Message- Sent: 17 January 2002 15:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. "James McCann" lecom.com> cc: Sent by:Subject: Standby Instance questions and HA [EMAIL PROTECTED] 01/17/2002 06:40 AM Please respond to ORACLE-L Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. >From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: James McCann 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
RE: Standby Instance questions and HA
Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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: Baker, Barbara 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: Session info
I just did describe v$session and the program field is 64 bytes long. Maybe you are using a tool that limits the value to 48 bytes. Oracle 8.1.6 on NT. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Aldi Barco [SMTP:[EMAIL PROTECTED]] > Sent: Thu, January 17, 2002 5:12 PM > To: Multiple recipients of list ORACLE-L > Subject: Session info > > Hi Listers, > We can find the program executed from Client in 'program' field in > v$session. But the problem is the field length just 48 character. Is there > > any other dictionary (v$ or x$ ?) to find 'the client program' completely > (more than 48 character) ? > Thanks. > > Aldi > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Aldi Barco > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Standby Instance questions and HA
Veritas also has a product that will do this for you... -Original Message- Sent: Thursday, January 17, 2002 10:46 AM To: Multiple recipients of list ORACLE-L Check the Sun web site. Sun has clustering. I do not know the name of the product off the top of my head since I use HP MC/ServiceGuard. -Original Message- McCann Sent: Thursday, January 17, 2002 7:06 AM To: Multiple recipients of list ORACLE-L I think your right. But does anyone know what is use on Solaris? Thanks, Jim -Original Message- Sent: 17 January 2002 15:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. "James McCann" lecom.com> cc: Sent by:Subject: Standby Instance questions and HA [EMAIL PROTECTED] 01/17/2002 06:40 AM Please respond to ORACLE-L Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. >From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance, and if this instance dies, a new instance is started on the second machine using the datafiles on the shared disk. The problem is that I can't find anything in the Oracle docs about this, or on Meta Link. I also want to know if this method of HA requires a clustered environment (I think it does, but just want to be sure)? Also, does it come with an Enterprise Edition license? Or is it something which each hardware vendor implements in their own way, at extra cost? We have a requirement for a fail over method on Sun Solaris. We do not want to loose any committed data (i.e. a standby database could loose some), and want the fail over to be as automatic as possible. We don't want the expense of Parallel Server (Anyone know how expensive it is these days?). The disk pack is RAID, and we may also have a standby database off site. Has anyone any recommendations? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann 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: James McCann 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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
RE: snapshot too old
Stephane... You're mean... :-) -Original Message- Sent: Thursday, January 17, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Seema Singh wrote: > > Hi > At time of export i am getting following error > "EXP-8: ORACLE error 1555 encountered > ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too > small" > > Please suggest > Thanks > -Seema Mladen, any idea ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Johnston, Tim 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: procedure error
Hello Lance This one works: CREATE OR REPLACE PROCEDURE Primus_Report AS begin execute immediate 'Drop Table PRIMUS_TEMP_DUMP'; execute immediate 'CREATE TABLE PRIMUS_TEMP_DUMP (SOLUTION_ID VARCHAR2 (85) NOT NULL) TITLEVARCHAR2 (3498)), OWNERVARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCEVARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinksVARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIEDDATE, ALERTVARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_WEEK VARCHAR2 (255), NO_LINKS_LAST_MONTH VARCHAR2 (255) )'; execute immediate 'INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution'; end; / Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Lance Prais [SMTP:[EMAIL PROTECTED]] > Sent: Wed, January 16, 2002 11:36 PM > To: Multiple recipients of list ORACLE-L > Subject: procedure error > > Why in toad when I try to create a stored proc where I drop and > create a table I get the following error: > > PLS-00103: Encountered the symbol "DROP" when expecting one of the > following: > begin function package pragma procedure subtype type use >cur > > > Here is my code: > > CREATE OR REPLACE PROCEDURE Primus_Report > AS > Drop Table PRIMUS_TEMP_DUMP; > CREATE TABLE PRIMUS_TEMP_DUMP ( > SOLUTION_ID VARCHAR2 (85) NOT NULL, > TITLEVARCHAR2 (3498), > OWNERVARCHAR2 (255), > P_TYPE VARCHAR2 (96), > AUTHOR VARCHAR2 (255), > MODIFIED_BY VARCHAR2 (255), > ESCALATION_GROUP VARCHAR2 (255), > TECH_RESOURCEVARCHAR2 (255), > P_PARTITION VARCHAR2 (96), > STATUS VARCHAR2 (96), > HyperLinksVARCHAR2 (96), > Style_reviewer VARCHAR2 (96), > DATE_CREATED DATE, > DATE_MODIFIEDDATE, > ALERTVARCHAR2 (96), > URGENCY VARCHAR2 (96), > NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), > NO_PAGEVIEWS_QUARTER VARCHAR2 (255), > NO_LINKS_LAST_WEEK VARCHAR2 (255), > NO_LINKS_LAST_MONTH VARCHAR2 (255) ); > INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT > pc_solution_id, pc_title FROM pt_solution; > end; > / > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Standby Instance questions and HA
I concur with BB.yea, I ran Sun "cluster" at and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in "my business". Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross "mit schuss" Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: snapshot too old
Oh, no! Not Gogala M Laden! -Original Message- Stephane... You're mean... :-) -Original Message- Sent: Thursday, January 17, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Seema Singh wrote: > > Hi > At time of export i am getting following error > "EXP-8: ORACLE error 1555 encountered > ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too > small" > > Please suggest > Thanks > -Seema Mladen, any idea ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partitions
Thanks Ron, So it's better I put partitions in deffrent tablespace and also for better performance in diffrent physical disks, it will helps. I am going to do the partition on Creation date or on Primary Key(PK is a sequence number), don't know can we use PK as a range for partitioning or not? Thanks again for your help. -Original Message- Sent: Thursday, January 17, 2002 6:02 AM To: Multiple recipients of list ORACLE-L Hamid, Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search for the data you have requested. If the table is 1 tablespace and large in size, it can take an enormous amount of resources to find the data you selected. If the table is partitioned correctly, Oracle will only search the partition/s that it needs to find your data. The application code does not need to be changed. The application will request data from a table and Oracle will determine which partition to use. ROR mª¿ªm >>> [EMAIL PROTECTED] 01/16/02 04:06PM >>> List, If we use partitioning for a big tables after finish development, do we have to change the code for accReceived: from CONNECT-MTA by galotteressing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Ron Rogers 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). The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Standby Instance questions and HA
We have this in place on Sun as well. It is similar to a cluster in that it has a separate box (Ultra 2) monitoring a heartbeat between both database servers. You will have a significant impact during failover. All drives common to both boxes will be unmounted on the primary and remounted on the secondary (which then becomes the primary). Since a "fsck" is run for each file system it can take upwards of 30 minutes for the failover. The database is shut down and brought back up so all connections are severed which means an interruption of service. If I wanted H/A on Sun I would move to 9i and implement a RAC. No application changes are necessary with this new version of OPS. Good luck. --Michael -Original Message- Sent: Thursday, January 17, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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: Baker, Barbara 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: Jenkins, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: Standby Instance questions and HA
It's not an Oracle thing, so there wouldn't be anything in the docs yes, you need a clustered environment, or at the least the ability for the disks to be mounted on the second server when the first one goes down. As long as the disk that oracle has been installed on is one of the ones that moves, or the install is identical, you can do this. --- James McCann <[EMAIL PROTECTED]> wrote: > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the > primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about > this, or > on Meta Link. > > I also want to know if this method of HA requires a clustered > environment (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own > way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database > could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how > expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off > site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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: Standby Instance questions and HA
Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun "cluster" at and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in "my business". Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross "mit schuss" Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
Re: Maximum number of redo log members
I got this query from the list. I can try it. JOan select decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY ') , rsnum from x$kccrs where indx in (3,4,2,9) union all select 'MAXLOGMEMBERS ',dimlm from x$kccdi / Rachel Carmichael wrote: > > I believe that the only way to see that information is to do an alter > database backup controlfile to trace > > as it is stored only in the controlfiles. This was true in 7.3 and 8.x > --- Sinard Xing <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > Where to find information about my MAXLOGMEMBERS, MAXLOGFILES ? > > > > I mean which views or tables (DD) to query from. > > > > > > > > > > Note: > > Oracle doc said "see your operating system-specific Oracle > > documentation", > > which is I don't have any : ( > > > > > > Thank you > > > > Sinardy > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sinard Xing > > 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!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh 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: Session info
I did that from sqlplus. In 816 Linux that is varchar2(48). The output is truncated so I don't know the name of the application from the client (it just showing C:\WINNT\Profiles\AldiTest\NewApplication\Sales\D). Aldi -Original Message- Sent: Thursday, January 17, 2002 10:07 AM To: Multiple recipients of list ORACLE-L I just did describe v$session and the program field is 64 bytes long. Maybe you are using a tool that limits the value to 48 bytes. Oracle 8.1.6 on NT. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] >-Original Message- >From: Aldi Barco [SMTP:[EMAIL PROTECTED]] >Sent: Thu, January 17, 2002 5:12 PM >To:Multiple recipients of list ORACLE-L >Subject: Session info > >Hi Listers, >We can find the program executed from Client in 'program' field in >v$session. But the problem is the field length just 48 character. Is there > >any other dictionary (v$ or x$ ?) to find 'the client program' completely >(more than 48 character) ? >Thanks. > >Aldi > >_ >Join the world's largest e-mail service with MSN Hotmail. >http://www.hotmail.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Aldi Barco > 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). >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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: Standby Instance questions and HA
we had it with FirstWatch from Veritas on top -- sometimes disks didn't get dismounted from the first server, or remounted on the second one.. then we had database failures --- "Baker, Barbara" <[EMAIL PROTECTED]> wrote: > > Jim: > Sorry, you're not gonna like this answer. HA is a Sun product, not > an > Oracle product. Under Sun's High Availability, you can configure > several > modules like Sybase and Oracle. (The Oracle product is Sun Cluster > HA-DBMS > for Oracle.) It does require what I believe Sun calls a cluster but > (IMHO) > is a bastardization of the term. It truly is failover, not cluster. > > We've had lots of problems with it. It's caused us lots of grief, > and only > in a few instances gained us anything. It is NOT OPS, as the > database does > not run in parallel, but only on 1 box at a time. (Everything is > double > cabled, and so the drives are re-mounted on the 2nd box if a failover > occurs.) Your users still get disconnected. You'd probably lose > less data > than with a standby (since you pick up with the same drives mounted > on the > other box), but it depends on how you have the standby implemented. > > There's no additional cost from Oracle to run this crap, but you'll > be > paying Sun great sums of money. The Sun web site has more info on > HA. > > > Let me know if you need more info. > Good luck! > > Barb > > > > -- > > From: James McCann[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Thursday, January 17, 2002 5:40 AM > > To: Multiple recipients of list ORACLE-L > > Subject:Standby Instance questions and HA > > > > Hi, > > I was reading in the book "Oracle 24/7 Tips and Techniques" about > > Standby > > Instances. > > > > Note, this is not a standby database. > > > > From the book it seams to work in the following way... > > > > There is only one database. > > The database files exist on a shared disk pack. One machine is the > primary > > instance, and if this instance dies, a new instance is started on > the > > second > > machine using the datafiles on the shared disk. > > > > The problem is that I can't find anything in the Oracle docs about > this, > > or > > on Meta Link. > > > > I also want to know if this method of HA requires a clustered > environment > > (I > > think it does, but just want to be sure)? > > > > Also, does it come with an Enterprise Edition license? > > Or is it something which each hardware vendor implements in their > own way, > > at extra cost? > > > > We have a requirement for a fail over method on Sun Solaris. > > We do not want to loose any committed data (i.e. a standby database > could > > loose some), and want the fail over to be as automatic as possible. > > > > We don't want the expense of Parallel Server (Anyone know how > expensive it > > is these days?). > > > > The disk pack is RAID, and we may also have a standby database off > site. > > > > Has anyone any recommendations? > > > > > > Thanks, > > > > Jim > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: James McCann > > 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: Baker, Barbara > 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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 PROTECTE
RE: snapshot too old
There are several ideas, but I'm working on my charming and likable personality. I must do something before the duhveleopers organize a lynch mob and burn me at stake. -Original Message- Sent: Thursday, January 17, 2002 11:11 AM To: Multiple recipients of list ORACLE-L Stephane... You're mean... :-) -Original Message- Sent: Thursday, January 17, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Seema Singh wrote: > > Hi > At time of export i am getting following error > "EXP-8: ORACLE error 1555 encountered > ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too > small" > > Please suggest > Thanks > -Seema Mladen, any idea ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Johnston, Tim 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: Gogala, Mladen 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: snapshot too old
Don't be afraid. I'm not hungry today. -Original Message- Sent: Thursday, January 17, 2002 11:31 AM To: Multiple recipients of list ORACLE-L Oh, no! Not Gogala M Laden! -Original Message- Stephane... You're mean... :-) -Original Message- Sent: Thursday, January 17, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Seema Singh wrote: > > Hi > At time of export i am getting following error > "EXP-8: ORACLE error 1555 encountered > ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too > small" > > Please suggest > Thanks > -Seema Mladen, any idea ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Disaster recovery using RMAN
Dennis, I hope you can clarify something in your plan for me. Why are you backing up to disk? By doing so, you are losing one of the chief benefits of RMAN. RMAN keeps a catalog of the tapes and knows which tapes to request to restore a backup, and which files to retrieve from those tapes. Do you backup the disk files to tape without the benefit of any tape management software? Do you manually label the tapes? Thanks, Jared DENNIS WILLIAMS TOUCH.COM>cc: Sent by: Subject: RE: Disaster recovery using RMAN [EMAIL PROTECTED] m 01/17/02 05:05 AM Please respond to ORACLE-L Sona - I am planning to test a disaster recovery using RMAN also. My company won't completely trust it until I can. Like you, I currently use RMAN to back up to disk, and write the backup to tape, keeping a Level 0 backup on disk. Here are the steps I am planning for disaster recovery. 1. Export the RMAN catalog and FTP a copy to the target system each time nightly backups are complete. 2. Back the Level 0 backup to tape, along with RMAN catalog export. 3. Mount the tape on the disaster recovery test system. 4. Assume that same version of Oracle is installed on the disaster recovery test system. 5. Create an RMAN user and import the RMAN catalog export. 6. Copy the RMAN Level 0 backup to disk. If possible, put it on the same path as on the original machine. If not, create a link so it looks like the same location to the system. 7. Begin RMAN recovery, changing disk locations for the data files, as needed. I'm just listing these off the top of my head, so I may have left something out. If you or any other listers see anything amiss with my plans, please point that out. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 5:21 PM To: Multiple recipients of list ORACLE-L Hi Here in my company we are planning to put together a disaster recovery plan using RMAN would like to test various recovery scenarios using RMAN. Could anyone provide the information on the procedures followed in a testing like this? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
used segment space in bytes
Title: Dieter Oberkofler Stationery hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one of those extents. i guess i would be able to compute the free blocks by using the dbms_space package but it just seems to complicated. any hints ... ? thank you -do
RE: OT -: SQL BackTrack info
I'm glad to hear your success story with support on SQL*Backtrack, bacause it is a very good product, usually. A year ago the support was *very* bad. Maybe they got the message and got some people trained on the product. Jared Brian Wisniewski YAHOO.COM> cc: Sent by: Subject: RE: OT -: SQL BackTrack info [EMAIL PROTECTED] 01/17/02 06:50 AM Please respond to ORACLE-L We must have been lucky because BMC support really saved our butt a few months back when we got a copy of LOGMASTER to recover some data from some archived redo logs (long story). We were really impressed with their support and everyone within our group commented on how helpful and knowledgeable they were and how we wished Oracle support was the same. Never called for support on the SQL*Backtrack product but we have it and love it. Maybe it was a fluke that we got good support from BMC but I expect so little from corporations technical support staff that I was really blown away with theirs on that occasion. Oracle support has made me a very jaded person. ;-) - Brian --- [EMAIL PROTECTED] wrote: > > Ok, you guys are really missing the support issue. :) > > The support is very bad. Yes, you don't need it often. > > But when you do need it, they don't have it. > > SQL*Backtrack is normally run as a menu to the > back end tools. As I recall, even most of the commands > used in cron for scheduled backups are wrappers to > the back end tools. > > There are recovery situations that cannot be peformed from > the SQL*Backtrack menu. If you run into one of those, and > cannot figure it out, support will be unable to help you. > > They know how to use the menu mode, and that's about it. > > Just after leaving a previous job where SQL*Backslack is > still in use, a tablespace in the data warehouse was trashed. > > It took 30+ days to recover it. This is mostly due to inept support > from BMC. They like to do a lot of finger pointing, such as > 'Your Legato indexes need rebuilt', even though that does > not fix the problem. > > It used to be a great tool, and probably still is. I would not but > it based simply on support issues. > > Jared > > > > > > > "Smith, Ron > > L." To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED] cc: > > om> Subject: RE: OT -: SQL > BackTrack info > Sent by: > > [EMAIL PROTECTED] > > om > > > > > > 01/16/02 11:13 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > We have been using it for about 5 years on both Unix and NT. We have > it > connected to Netbackup to handle the tapes. We love it. I agree > that the > support is not what it used to be but we hardly ever need support. > Although, the last time we called we got a support person that knew > more > about Oracle than > we did and knew SQL Backtrack inside and out. It's a great tool! > > Ron Smith > Kerr-McGee Corp > > -Original Message- > Sent: Wednesday, January 16, 2002 10:55 AM > To: Multiple recipients of list ORACLE-L > > > I am looking for some guidance from people who use this product. Is > it a > value add to the organization or not. If possible also let me know > how in > the hell does it do a online object extraction from the backup. > > Would appreciate all your comments and recommendations > > Thx > Gautam > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: S
RE: Standby Instance questions and HA
IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun "clustering" working, but it required some serious feet-to-fire holding and gyrations. -Original Message- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun "cluster" at and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in "my business". Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross "mit schuss" Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED
RE: USER DUMP HOW?
yes, you can use TOAD or SQL*NAVIGATOR for that. Or you can write your own scripts, I have found this one between my scripts, I have never tested, I prefer to use Import/Export for that kind of job. HTH DC - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 3:41 PM > > Hi > Is there any way to take user dump which containts > indexes,tables,constraints etc like "create table tablename ... like".I > don't want to use import option.Can I do thru export only or not? > Thanks > -sEEMA > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > 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). Create_all_procs.sql Description: Binary data
Partitioning and tkprof
All, Could of any of you ladies and gents take a peek at this and give me idea of what the explain plan is getting at ?? Rows Execution Plan--- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 PARTITION (CONCATENATED) 0 TABLE ACCESS GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF 'PG_UK_CATEGORY_VENDOR' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'PG_UK_CATEGORY_VENDOR_K' (NON-UNIQUE) My limited knowledge would lead me to guess that this is going to all the partitions (well more than one anyway) to find the info. it is looking for. There is a problem with this process as it tends to take quite a bit of time. I was just hoping to be nudged in the right direction. FYI. The partition key is not part of the index on the table. Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Oracle Financials DBA with 11i Needed in Tampa, Florida area..
Come work for a great company in the Tampa Florida area (Clearwater) that needs an Oracle Financials DBA to join it's I.T. Team. You will work with Oracle Applications and must have experience with 11i and Excellent communications skills. Looking for someone with very solid hands-on experience. *Company want someone who is willing to work in Clearwater, stay for 1 to 1 1/2 years, and be open to relocate to another east-coast city after that. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. Requirements: * Need to have 5 years DBA exp. and 3 years+ applications, 2 years 11i. * EXCELLENT COMMUNICATION SKILLS * U.S. citizenship or permanent residents only This position offers: * Stability * The opportunity to become a key member of the team. * Base salary-70-100K D.O.E., and great benefits. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Tampa/Fin.DBA/Raush All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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).
Backup Strategy
Hi List, I have a white paper for Backup Strategy on Microsoft NT but I am looking for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or link I realy appreciate. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Using RMAN
See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i have the last 2 days backup on disk (just for fatster recovery so that we can aviod going to tapes in case of a failure). Now if we start using RMAN ,we would be taking hot backups (mostly using increamental strategy) using RMAN.So for e.g. we start on say sunday taking an incremental level 0 backup on disk.RMAN only remmbers the disk backup ...right Note that we will also be copying the backups on tape but that will be independent of RMAN since it is not done using RMAN. Say the next 3 days of the week ,we do increamental level 1 backups .On the 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup on disk (which are the inceemental llevel 1 backups since the whole ideas is to keep last 2 days backup om disk). So if we have a failure on Wednesday then RMAN would look for the incremental level 0 backup of Sunday on the disk but that backup is not present on the disk now. I hope i have cleared it up enough. Now my question is can we maintain the same policy of keeping 2 days backup on disk by using RMAN. What kind of backup strategies do RMAN users follow? Are RMAN backups usually taken on tape directly ? Is it faster to take backups on tape rather on disk while using RMAN? Could RMAN users share their backup/recovery strategies ,please. TIA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 5:55 AM > If you are using a recovery catalog then rman keeps track of everything > there. He knows if you've been naughty, he know if you've been nice, he > knowsOOOPS I got carried away. But when you do a restore using rman he > will tell you what backup sets you will need. > > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 16, 2002 6:20 PM > > > Hi > Currently we are using Unix scripts to do backups.We keep last 2 days of > backups on the disk and also take the backups on tape daily. > We are planning to use RMAN for backups and would like to maintain the the > same policy of 2 days backup on disk and daily tape backups. > Is it possible to implement this using RMAN? Which backup will RMAN remember > (while restore) the disk backup or the tape backup? > If we try to use the incremental strategy ,then how would RMAN remember the > last incremental level 0 backup ? It will not be present on disk since we > only keep the last 2 days backup on it. > How do i use RMAN to do restore/recovery in this case? > > > I heard that taking backups on tape is faster than on disk when using RMAN? > Is it true? > > Could RMAN users share their backup/recovery strategies ,please. > > TIA > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > 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: Sona 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: DBA Experiences with Oracle and RAID 0+1
Mogens: Just let me disagree with you at only one point. According to my experience, I think that the size of the disks in an array does matter sometimes. It's not the same to have 24 9GB disks that to have only 3 of 73GB. You have 24 spindles againts 3, the first option (in a well configured system of course) will give you better performance in enviroments where you have a lot of concurrency and many users. However I think that what I've written above might not be correct (may be it should be tested) if the 73GB outstands for a long way the 9GB disks in terms of seek time and transfer rate. Take a look at an extract of Gaja's paper "Implementing RAID on Oracle": "5) Procure the smallest drive money can buy, keeping in mind scalability, limits of the host machine, the disk array and growth projections for the database. This is a tough one these days, with 18 GB drives considered as small drives. 6) Bigger and faster drives are not always better than smaller slower drives, as the seek times for larger and faster drives with larger form factors, may be more than their smaller and slower counterparts. This is not that big of an issue, if your drives support a built-in track buffer cache for storing an entire track's worth of data from read request(s)." HTH Greeting Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 10:25 PM > Jon, > > It's one of those "how many bags will I need in the supermarket?" > questions - it depends. > > Consider: > > - RAID 1+0 is much better than 0+1. > - Three disks is not much w.r.t. IO capability. If you have three > concurrent users you'll be OK :) > - Size doesn't matter (who cares if it's 10, 36 or 73 Gig disks? It's > the IO capabilitity that counts) > - I'm new to this list, so I don't know if this will work, but I've > attached a brilliant presentation by our old friend James Morle (check > out www.ScaleAbilities.com) regarding SAN, NAS and RAS (Random Acronym > Seminar). > - If you're only striping across three disks (is that really a SAN?) > just SAME (Stripe And Mirror Everything). It might not be good, but it's > simple. > > Jon Behnke wrote: > > >We are in the process of setting up a SAN using RAID 0+1 for our database. > >In our current environment, we are able to separate our tables, indexes, > >rollback segments, and archive logs on different disks. On the SAN we would > >have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable > >space (3 disks worth of space). > > > >Some white papers that I have read suggest attempting to separate the data, > >indexes, and rollback segments on separate RAID volumes, and others simply > >suggest that the performance boost of striping will supercede the separation > >of these items. > > > >Can anyone offer any comments or suggestions? > > > >Jon Behnke > >Applications Development Manager > >Industrial Electric Wire & Cable > >Phone (262) 957-1147 Fax (262) 957-1647 > >[EMAIL PROTECTED] > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone 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: Disaster recovery using RMAN
Dennis, Could you please share your regular backup strategies with me for me to understand this better? Thanks - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 9:00 AM > > Dennis, > > I hope you can clarify something in your plan for me. > > Why are you backing up to disk? By doing so, you are losing one of the > chief benefits of RMAN. RMAN keeps a catalog of the tapes and knows > which tapes to request to restore a backup, and which files to retrieve > from those tapes. > > Do you backup the disk files to tape without the benefit of any tape > management software? Do you manually label the tapes? > > Thanks, > > Jared > > > > > > DENNIS WILLIAMS > > TOUCH.COM>cc: > Sent by: Subject: RE: Disaster recovery using RMAN > [EMAIL PROTECTED] > m > > > 01/17/02 05:05 > AM > Please respond > to ORACLE-L > > > > > > > Sona - I am planning to test a disaster recovery using RMAN also. My > company > won't completely trust it until I can. Like you, I currently use RMAN to > back up to disk, and write the backup to tape, keeping a Level 0 backup on > disk. Here are the steps I am planning for disaster recovery. > > 1. Export the RMAN catalog and FTP a copy to the target system each time > nightly backups are complete. > 2. Back the Level 0 backup to tape, along with RMAN catalog export. > 3. Mount the tape on the disaster recovery test system. > 4. Assume that same version of Oracle is installed on the disaster recovery > test system. > 5. Create an RMAN user and import the RMAN catalog export. > 6. Copy the RMAN Level 0 backup to disk. If possible, put it on the same > path as on the original machine. If not, create a link so it looks like the > same location to the system. > 7. Begin RMAN recovery, changing disk locations for the data files, as > needed. > > I'm just listing these off the top of my head, so I may have left something > out. If you or any other listers see anything amiss with my plans, please > point that out. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > > -Original Message- > Sent: Wednesday, January 16, 2002 5:21 PM > To: Multiple recipients of list ORACLE-L > > > > Hi > > Here in my company we are planning to put together a disaster recovery plan > using RMAN would like to test various recovery scenarios using RMAN. > > Could anyone provide the information on the procedures followed in a > testing > like this? > > TIA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > 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: Sona 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: Session info
Maybe it has something to do with the client. I just did the same (ora81634 on NT) and the program contain only the program name, not the whole path. Our clients are sqlnet that came with 734 or 816. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Aldi Barco [SMTP:[EMAIL PROTECTED]] > Sent: Thu, January 17, 2002 6:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Session info > > I did that from sqlplus. > In 816 Linux that is varchar2(48). > The output is truncated so I don't know the name of the application from > the > client (it just showing > C:\WINNT\Profiles\AldiTest\NewApplication\Sales\D). > > Aldi > > -Original Message- > Sent: Thursday, January 17, 2002 10:07 AM > To: Multiple recipients of list ORACLE-L > > > I just did describe v$session and the program field is 64 bytes long. > Maybe you are using a tool that limits the value to 48 bytes. > Oracle 8.1.6 on NT. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > >-Original Message- > >From:Aldi Barco [SMTP:[EMAIL PROTECTED]] > >Sent:Thu, January 17, 2002 5:12 PM > >To: Multiple recipients of list ORACLE-L > >Subject: Session info > > > >Hi Listers, > >We can find the program executed from Client in 'program' field in > >v$session. But the problem is the field length just 48 character. Is > there > > > >any other dictionary (v$ or x$ ?) to find 'the client program' completely > > >(more than 48 character) ? > >Thanks. > > > >Aldi > > > >_ > >Join the world's largest e-mail service with MSN Hotmail. > >http://www.hotmail.com > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Aldi Barco > > 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). > >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > This e-mail was scanned by the eSafe Mail Gateway > >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > 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). > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Aldi Barco > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Raw I/O
I had responded to Witold privately but it seems that people want more so here goes: We went raw with our production billing system a few months ago because the vendor told damagement that it would be faster. We also converted our failover and testing environments because we do some combination of SRDFs and BCVs of the production system (we are an HP shop). FWIW, each of these monsters is a 2.4T OLTP database. Their code was crappy in a cooked database, and unbelievable as it may seems, performs slightly less crappy in a raw database. We have few SAs and DBAs that have ever worked with raw devices. Despite excellent documentation, configuring aio was *challenging*. The lack of experience has also given us ample opportunity to practice backups and restores. The good news is that our failover has worked flawlessly. :) The upshot is yes, we've gotten slight performance gains. Can you imagine what would happen if we tuned the code, make a few database architectural changes, etc? In the meantime, it was easier and faster to go raw rather than fix the code. Add in the poor resources and you have a weiner! My personal opinion is that we will not realize enough gains to justify going raw. I imagine it's only a matter of time before our business grows enough to bring the system to a screeching halt again. By them we will have implemented yet another version or 2 and will not be able to figure out exactly what to do. I guess, at that time, we can go back to cooked. :) It was probably done for the vendor's own job security and most of our management is totally clueless. For me personally, it's been great because I'm one of 3 DBAs here who have worked with raw before so I have more things to play with now. If you decide to go this route, make sure your SAs and DBAs are educated and careful and get thyself some good backup software. You can check out past discussions about raw vs cooked at http://www.fatcity.com/ListGuru/login.php hth, ~Ruth Ruth Dejam Senior Oracle DBA VoiceStream Wireless Do not meddle in the affairs of dragons for you are crunchy and taste good with ketchup. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 1/17/02 6:50 AM I have been searching for the same answers for a long time and have downloaded a lot of papers on the "raw vs cooked" and to get definitive answers is a complicated task. Simple methods and opinions and examples will go a long way in the understanding of a controversial and complicated subject. Yes, I know that it is faster, more complicated, a bear to administer but the answer is "it is used today in quite a few shops". More informative answers would be appreciated and would help in the decision process of "should we or shouldn't we use raw devices" and what are the pitfalls and advantages if we do. A guide ,reference, or link to help in the decisions would be a blessing. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Dejam, Ruth 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: Freeable memory
Hi Michael:
Why don't you use this Steve Adams' script to check the fragmentation
of your shared pool, it may be badly
fragmented and this problem could generate a lot of pressure at the shared
pool latch.
And this situation can also generate contention at a lower level latch (like
the library cache latch).
Make sure the session has been up and running for some time before running
it and don't execute any
shared pool flush before running it, or your data would be misleading.
Here's the script, or you can dowload it from IXORA site.
www.ixora.com.au
--
---
--
-- Script: shared_pool_free_lists.sql
-- Purpose: to check the length of the shared pool free lists
-- For: 8.0 and higher
--
-- Copyright: (c) 2000 Ixora Pty Ltd
-- Author: Steve Adams
--
-- Warning: This script queries x$ksmsp which causes it to take the
-- shared pool latch for a fairly long time.
-- Think twice before running this script on a large system
-- with potential shared pool problems -- you may make it worse.
--
---
@save_sqlplus_settings
select
decode(sign(ksmchsiz - 80), -1, 0, trunc(1/log(ksmchsiz - 15, 2)) - 5)
bucket,
sum(ksmchsiz) free_space,
count(*) free_chunks,
trunc(avg(ksmchsiz)) average_size,
max(ksmchsiz) biggest
from
sys.x_$ksmsp
where
inst_id = userenv('Instance') and
ksmchcls = 'free'
group by
decode(sign(ksmchsiz - 80), -1, 0, trunc(1/log(ksmchsiz - 15, 2)) - 5)
/
@restore_sqlplus_settings
-
HTH
Diego Cutrone
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 7:10 PM
> All,
> In trying to solve some Library Cache latch contention issues, I've been
> stumped on the following issues:
>
> 1) Do freeable chunks get coalesced during an ALTER SYSTEM FLUSH
> SHARED_POOL.
> 2) If freeable chunks are freed when a session disconnects, is there a
way
> to determine chunks per session? The idea here is better memory management
> through better session management.
>
> I've aleviated the majority of latch contention by altering the
> _kgl_latch_count parameter, but haven't addressed what I think is the root
> cause: an oversized shared pool. I've found scripts that show the amount
of
> memory occupied by the sql area and library cache, and most if the memory
is
> in freeable chunks. Before downsizing the shared pool, I'd like to have a
> better understanding of how these chunks are managed.
>
> Regards,
> Mike G
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Michael Ghelli
> 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: Diego Cutrone
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: USER DUMP HOW?
Hi Diego > Or you can write your own scripts, I have found this one between my scripts, > I have never tested, I prefer to use Import/Export for that kind of job. The easy way to do this is to get the Freeware DBATool. It will read an export file (created ROWS=N) and present you with the DDL contents in a nicely formatted and intuitive manner. It does lots of other things as well - you can generate recreate scripts for all or part of a schema. (for example: a script that recreates a role and every grant it has). The DBATool can strip of storage clause information from every DDL bit code with a single button press or dump the entire schema out to an HTML tree and just browse through the DDL as it suits you. The DBATool is currently in beta. The second beta release (which cleaned up a lot of 9i issues) was just released today. Download the DBATool from http://www.databee.com/dt_home.htm Cheers Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar 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).
Import taking up too much room with local managed tablespace
Title: Import taking up too much room with local managed tablespace Hi, I created a tablespaces in a test database to be locally managed with an extent size of 20544K. A normal database import usually will fill a datafile with 5.8GB of data (on a dictionary managed tblspace) but with the local it has run out of space with the (2) 6GB files that I allocated to it. I noticed that during the import the datafiles were filling up quite fast (too fast). Data file 1 was filling up about 4x as fast as data file 2 during the import. Why did this happen? FYI, I have the compress=y set on the export if that makes any difference. Thanks, Ben. Benjamin Conrad Sr. Network Administrator USPowerSolutions mailto:[EMAIL PROTECTED] 617.547.3800 x195 This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited. If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at [EMAIL PROTECTED] and destroy all copies of this communication and any attachments.
RE: Standby Instance questions and HA
Thanks for your help everyone. Very useful advice, although your scaring me of Sun Clusters. At the minute, Parallel server looks the best, with a standby database remotely for disaster. Does anyone know what the HP solution is like (MC Service Guard)? I think some one on this list gave it a good review in the past . Thanks, Jim -Original Message- Sent: 17 January 2002 17:12 To: Multiple recipients of list ORACLE-L IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun "clustering" working, but it required some serious feet-to-fire holding and gyrations. -Original Message- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun "cluster" at and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in "my business". Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross "mit schuss" Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To R
RE: Using RMAN
Sona, I am using Rman to backup directly (via EDM software) to a tape. It is working very nicely. Recovery has not been an issue (haven't had to recover yet), but we perform weekly Rman Validate Recovery to be sure that we can read the tape. The reason to use tape backup is that I don't need to get into the dance that you need to do when performing disk backup (deleting aged backup files, keeping last few days etc). I know this can easily be done with simple unix/nt scripting, but Edm is working nicely for us, and I don't feel the need to change. As for your plan of keeping only 3 days of backup on disk, I would change it to 5 days if you are doing a full, followed by two incremental backups. Why cut the time so close? If disk space is an issue, compress the backup file after the Rman backup has completed (be sure and test Validate Backup from the Uncompressed file to make sure all is well). Either that, or buy more disk - it is cheap now-a-days. As for what is faster - tape or disk - it all depends on what kind of tape drive you use. Intuitively, I would say disk is faster. But then, tape is safer - pretty easy to delete a disk file - not as easy to delete a tape file. I currently backup a 10 gig database in about 20 minutes on NT, using StorageTek tape library. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 17, 2002 12:46 PM To: Multiple recipients of list ORACLE-L See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i have the last 2 days backup on disk (just for fatster recovery so that we can aviod going to tapes in case of a failure). Now if we start using RMAN ,we would be taking hot backups (mostly using increamental strategy) using RMAN.So for e.g. we start on say sunday taking an incremental level 0 backup on disk.RMAN only remmbers the disk backup ...right Note that we will also be copying the backups on tape but that will be independent of RMAN since it is not done using RMAN. Say the next 3 days of the week ,we do increamental level 1 backups .On the 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup on disk (which are the inceemental llevel 1 backups since the whole ideas is to keep last 2 days backup om disk). So if we have a failure on Wednesday then RMAN would look for the incremental level 0 backup of Sunday on the disk but that backup is not present on the disk now. I hope i have cleared it up enough. Now my question is can we maintain the same policy of keeping 2 days backup on disk by using RMAN. What kind of backup strategies do RMAN users follow? Are RMAN backups usually taken on tape directly ? Is it faster to take backups on tape rather on disk while using RMAN? Could RMAN users share their backup/recovery strategies ,please. TIA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 5:55 AM > If you are using a recovery catalog then rman keeps track of everything > there. He knows if you've been naughty, he know if you've been nice, he > knowsOOOPS I got carried away. But when you do a restore using rman he > will tell you what backup sets you will need. > > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 16, 2002 6:20 PM > > > Hi > Currently we are using Unix scripts to do backups.We keep last 2 days of > backups on the disk and also take the backups on tape daily. > We are planning to use RMAN for backups and would like to maintain the the > same policy of 2 days backup on disk and daily tape backups. > Is it possible to implement this using RMAN? Which backup will RMAN remember > (while restore) the disk backup or the tape backup? > If we try to use the incremental strategy ,then how would RMAN remember the > last incremental level 0 backup ? It will not be present on disk since we > only keep the last 2 days backup on it. > How do i use RMAN to do restore/recovery in this case? > > > I heard that taking backups on tape is faster than on disk when using RMAN? > Is it true? > > Could RMAN users share their backup/recovery strategies ,please. > > TIA > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > 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 cont
RE: Partitions
Hamid, You need to think about how meaningful a range is if it is just based on Sequence Numbers as opposed to Creation Date. Martin http://www.oracle-rescue.com/ -Original Message- Sent: 17 January 2002 16:29 To: Multiple recipients of list ORACLE-L Thanks Ron, So it's better I put partitions in deffrent tablespace and also for better performance in diffrent physical disks, it will helps. I am going to do the partition on Creation date or on Primary Key(PK is a sequence number), don't know can we use PK as a range for partitioning or not? Thanks again for your help. -Original Message- Sent: Thursday, January 17, 2002 6:02 AM To: Multiple recipients of list ORACLE-L Hamid, Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search for the data you have requested. If the table is 1 tablespace and large in size, it can take an enormous amount of resources to find the data you selected. If the table is partitioned correctly, Oracle will only search the partition/s that it needs to find your data. The application code does not need to be changed. The application will request data from a table and Oracle will determine which partition to use. ROR mª¿ªm >>> [EMAIL PROTECTED] 01/16/02 04:06PM >>> List, If we use partitioning for a big tables after finish development, do we have to change the code for accReceived: from CONNECT-MTA by galotteressing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Ron Rogers 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). The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Martin Kendall 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 ma
RE: used segment space in bytes
Title: Dieter Oberkofler Stationery What about dba_segments? -Original Message-From: Oberkofler, Dieter [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 2002 12:12 PMTo: Multiple recipients of list ORACLE-LSubject: used segment space in bytes hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one of those extents. i guess i would be able to compute the free blocks by using the dbms_space package but it just seems to complicated. any hints ... ? thank you -do
8.0.5 to 8.1.7 migration problem
Evening gang; Why would the Oracle Database Migration Assistant (odma) be telling me that I am migrating a database from 8.1.5 to 8.1.7 when it is actually only a version 8.0.5 database ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8.1.7 install error
And always shutdown Antivirus-Clients. Günter Seefelt, Beth wrote: >I get a lot of those when installing on NT. I usually go into explorer, >rename the existing file to .old and hit Retry and the install continues on. > >Sometimes that won't work if the file is truly locked by another process. >In that case you have to find who has locked the file. I use the HandleEx >tool available from www.sysinternals.com to find out which process has the >file locked and stop it before continuing the installation. > >-Original Message- >Sent: Wednesday, January 16, 2002 9:10 AM >To: Multiple recipients of list ORACLE-L > >I keep getting the following error while trying to install Oracle 8.1.7 on >my NT server. >There is over 1G of freespace on the drive. If I say ignore, the installer >continues to run. >Any ideas? > >Error in writing to file c:\winnt\system32\ctl3d32.dll > >Ron > -- --- Dipl.-Inform. Günter Huerkamp Web: http://guenter-huerkamp.bei.t-online.de Email privat : mailto:[EMAIL PROTECTED] privat : mailto:[EMAIL PROTECTED] dienstlich : mailto:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?G=FCnter?= Huerkamp 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).
UNION
Hi, I try to use union and order by first column of first select statment and also first column of second select statment but get error, Any Idea how to do this?? SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY A,D Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: used segment space in bytes
Title: Dieter Oberkofler Stationery Hi Dieter: As you've said, you can use dbms_space for this job. This package tells you how many blocks has the object and where's the HWM. And if you use the dbms_space.free_blocks() procedure, it will also report how many blocks below the HWM are in the freelists. You can also use this query to know how many blocks hold at least one row: (ORACLE 7) SELECT COUNT(DISTINCT SUBSTR(rowid,15,4)||SUBSTR(rowid,1,8)) FROM TABLE. You can easily change it to work in Oracle 8 too by using the dbms_rowid package. HTH Greetings Diego Cutrone - Original Message - From: Oberkofler, Dieter To: Multiple recipients of list ORACLE-L Sent: Thursday, January 17, 2002 2:11 PM Subject: used segment space in bytes hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one of those extents. i guess i would be able to compute the free blocks by using the dbms_space package but it just seems to complicated. any hints ... ? thank you -do
RE: Standby Instance questions and HA
I also heard of horror stories regarding Sun Clusters. I worked w/ HP MC Service guard, good product. Now working w/ IBM HACMP, also good product, although more complicated to set up (but then again I am not a IBM'er). IBM tends to do everything their way ;). In the future when I upgrade to 9i, I will use Oracle's Data Guard or maybe look at a 3rd party product such as shareplex (good reviews, but pricey). Gene >>> [EMAIL PROTECTED] 01/17/02 01:05PM >>> Thanks for your help everyone. Very useful advice, although your scaring me of Sun Clusters. At the minute, Parallel server looks the best, with a standby database remotely for disaster. Does anyone know what the HP solution is like (MC Service Guard)? I think some one on this list gave it a good review in the past . Thanks, Jim -Original Message- Sent: 17 January 2002 17:12 To: Multiple recipients of list ORACLE-L IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun "clustering" working, but it required some serious feet-to-fire holding and gyrations. -Original Message- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.yea, I ran Sun "cluster" at and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in "my business". Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund... - Ross "mit schuss" Mohan -Original Message- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > -- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > 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
RE: UNION
In the order by section use the relative column numbers. Plus, you can not individually order by a single column from each union. Its a comprehensive sort of the entire column. SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 -Original Message- Sent: Thursday, January 17, 2002 12:31 PM To: Multiple recipients of list ORACLE-L Hi, I try to use union and order by first column of first select statment and also first column of second select statment but get error, Any Idea how to do this?? SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY A,D Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Kevin Lange 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: UNION
select * from ( SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF) x ORDER BY A,D > -Original Message- > From: Hamid Alavi [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 17, 2002 12:31 PM > To: Multiple recipients of list ORACLE-L > Subject: UNION > > Hi, > > I try to use union and order by first column of first select statment and > also first column of second select statment but get error, Any Idea how to > do this?? > > SELECT A,B,C FROM TABLEABC > UNION > SELECT D,E,F FROM TABLEDEF > ORDER BY A,D > > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in > error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mac Isaac, John 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: UNION
Hamid, Look in the Sql manual. For UNION clauses, you must ORDER BY the item number: SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 <= lookee here hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 17, 2002 1:31 PM To: Multiple recipients of list ORACLE-L Hi, I try to use union and order by first column of first select statment and also first column of second select statment but get error, Any Idea how to do this?? SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY A,D Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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).
RE: UNION
You have to use ORDER BY column position as in SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: UNION
Hamid Alavi wrote:
>
> Hi,
>
> I try to use union and order by first column of first select statment and
> also first column of second select statment but get error, Any Idea how to
> do this??
>
> SELECT A,B,C FROM TABLEABC
> UNION
> SELECT D,E,F FROM TABLEDEF
> ORDER BY A,D
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
Hamid,
Remember that the purpose of a union is to bring back rows from
several tables as if they were coming from a single table - a bit like a
join returns columns from several tables as if they were coming from a
single table. By convention, the column names which are assigned come
from the first table in the union. In your example, columns will be
named (A,B,C) even if actually the first part of the UNION returns no
row. Syntactically, to order the output of a union you must specified
column by position number in the select list, not by name - on your
example, it will be 'order by 1' ('1' refering to A or D indistinctly).
If you always want rows from TABLEABC to be returned before rows from
TABLEDEF, you must cheat and add a dummy column :
SELECT 1 dummy, A, B, C FROM TABLEABC
UNION
SELECT 2, D, E, F FROM TABLEDEF
ORDER BY 1, 2
(you can make the dummy column disappear from the output with SQL*Plus
by defining
col dummy noprint
In a program, just ignore it).
Note that there is a drawback to the dummy column use: with a standard
UNION (as opposed to UNION ALL) if a row in the first table is strictly
identical to a row in another table from the UNION, it appears only once
(duplicates are eliminated). With a dummy column, only duplicates from
the same table can be removed.
HTH
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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: UNION
Try: select a,b,c from tableabc union select d,e,f from tabledef order by 1; Hamid Alavi wrote: > Hi, > > I try to use union and order by first column of first select statment and > also first column of second select statment but get error, Any Idea how to > do this?? > > SELECT A,B,C FROM TABLEABC > UNION > SELECT D,E,F FROM TABLEDEF > ORDER BY A,D > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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).
Checkpoint & Redo ratio(High)
Hi I checked my database and see redo ratio is high. I ran the folling query select (req.value * 5000) / entries.value "Redo Ratio" from v$sysstat req, v$sysstat entries where req.name = 'redo log space requests' and entries.name = 'redo entries'; But the background checkpoints completed and background checkpoints started are having diffrence 1. When I do large insert and delete I receive message in alert log "Checkpoint not completed." but not regulary. My redo log file size is 20m. oracle is running on 8.1.6 on unix. LEt me know group suggestion. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: UNION
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 20:31 > > SELECT A,B,C FROM TABLEABC > UNION > SELECT D,E,F FROM TABLEDEF > ORDER BY A,D SELECT A as ord_col,B,C FROM TABLEABC UNION SELECT D as ord_col,E,F FROM TABLEDEF ORDER BY ord_col? 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: UNION
Did a little testing. I think that the columns names are decided by the first select only. The union adds the rows from the second select to the result set created by the first select. That's mean that your columns are a , b , c. So order by 'a' will work. It did in my test. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Hamid Alavi [SMTP:[EMAIL PROTECTED]] > Sent: Thu, January 17, 2002 8:31 PM > To: Multiple recipients of list ORACLE-L > Subject: UNION > > Hi, > > I try to use union and order by first column of first select statment and > also first column of second select statment but get error, Any Idea how to > do this?? > > SELECT A,B,C FROM TABLEABC > UNION > SELECT D,E,F FROM TABLEDEF > ORDER BY A,D > > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in > error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Using RMAN
I have gone through this process. We used to backup to disk using scripts as
described in Velpuri's book. We now use RMAN to backup to disk. Your backups will be
faster and smaller in size, because RMAN will skip unused blocks and it also allows
you to specify mutilple channels. I can backup a 70 Gb database in about 60 to 90
minutes. Here is a sample script:
run
{
allocate channel ch1 type disk format '/bkup9/oracle/%d/full_s%s_p%p_%t';
allocate channel ch2 type disk format '/bkup3/oracle/%d/full_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1 Gb.
set limit channel ch2 kbytes=100;
backup full database
tag='daily_full_backup';
allocate channel ch3 type disk format '/bkup3/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch3 kbytes=100;
backup (archivelog until time 'sysdate-1/24' delete input
channel ch3
);
}
I do archivelog backups with a separate command, because RMAN can be a bit touchy when
it comes to archivelogs. If none exist for the time specified, then the backup will
fail. This way my database backup will be successful if there is a problem with the
archivelog backup.
I would skip the incremental stuff. Just do full backups unless you are talking huge
databases.
To tell RMAN what backup files are available on disk, prior to a restore, run this
command:
# Check which backups are available on disk.
allocate channel for maintenance type disk;
crosscheck backup;
release channel;
or this one if you are in noarchivelog mode:
# Check which backups are available on disk.
allocate channel for maintenance type disk;
crosscheck backup of database;
crosscheck backup of controlfile;
release channel;
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 01/17/02 12:45PM >>>
See currently we are using Unix scripts to do our hot backups .We take the
backup on disk and everynight after the disk backup we copy the backup on
tape using Veritas Net Backup.
Presently we keep 2 days worth of backups on the disk and 3 days of archive
logs.That means at any point in time i have the last 2 days backup on disk
(just for fatster recovery so that we can aviod going to tapes in case of a
failure).
Now if we start using RMAN ,we would be taking hot backups (mostly using
increamental strategy) using RMAN.So for e.g. we start on say sunday taking
an incremental level 0 backup on disk.RMAN only remmbers the disk backup
...right Note that we will also be copying the backups on tape but that
will be independent of RMAN since it is not done using RMAN.
Say the next 3 days of the week ,we do increamental level 1 backups .On the
3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup
on disk (which are the inceemental llevel 1 backups since the whole ideas is
to keep last 2 days backup om disk).
So if we have a failure on Wednesday then RMAN would look for the
incremental level 0 backup of Sunday on the disk but that backup is not
present on the disk now.
I hope i have cleared it up enough.
Now my question is can we maintain the same policy of keeping 2 days backup
on disk by using RMAN.
What kind of backup strategies do RMAN users follow? Are RMAN backups
usually taken on tape directly ? Is it faster to take backups on tape rather
on disk while using RMAN?
Could RMAN users share their backup/recovery strategies ,please.
TIA
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 5:55 AM
> If you are using a recovery catalog then rman keeps track of everything
> there. He knows if you've been naughty, he know if you've been nice, he
> knowsOOOPS I got carried away. But when you do a restore using rman
he
> will tell you what backup sets you will need.
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 16, 2002 6:20 PM
>
>
> Hi
> Currently we are using Unix scripts to do backups.We keep last 2 days of
> backups on the disk and also take the backups on tape daily.
> We are planning to use RMAN for backups and would like to maintain the the
> same policy of 2 days backup on disk and daily tape backups.
> Is it possible to implement this using RMAN? Which backup will RMAN
remember
> (while restore) the disk backup or the tape backup?
> If we try to use the incremental strategy ,then how would RMAN remember
the
> last incremental level 0 backup ? It will not be present on disk since we
> only keep the last 2 days backup on it.
> How do i use RMAN to do restore/recovery in this case?
>
>
> I heard that taking backups on tape is faster than on disk when using
RMAN?
> Is it true?
>
> Could RMAN users share their backup/recovery strategies ,please.
>
> TIA
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858)
Re: UNION
SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 1:31 PM > Hi, > > I try to use union and order by first column of first select statment and > also first column of second select statment but get error, Any Idea how to > do this?? > > SELECT A,B,C FROM TABLEABC > UNION > SELECT D,E,F FROM TABLEDEF > ORDER BY A,D > > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Igor Neyman 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: UNION
Use ORDER BY 1 (ie, the first column) At 10:31 AM 1/17/02 -0800, you wrote: >Hi, > >I try to use union and order by first column of first select statment and >also first column of second select statment but get error, Any Idea how to >do this?? > >SELECT A,B,C FROM TABLEABC >UNION >SELECT D,E,F FROM TABLEDEF >ORDER BY A,D > > > > >Hamid Alavi >Office 818 737-0526 >Cell818 402-1987 > >The information contained in this message and any attachments is intended >only for the use of the individual or entity to which it is addressed, and >may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from >disclosure under applicable law. If you have received this message in error, >you are prohibited from copying, distributing, or using the information. >Please contact the sender immediately by return e-mail and delete the >original message from your system. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Hamid Alavi > 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: Regina Harter 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: Using RMAN
We use rman to backup all of our databases. But most importantly, we use it for production. Production databases are in archivelog mode. We do a level 1 backup at the end of the work day and prior to nitely batch processing. We do a level 0 backup early in the morning after batch and before users get on. We but a full days worth of backups, including the archivelog backups, on a tape in the morning. There is one tape for each day of the week, Mon-Fri. We delete archivlogs from the archive log destination after backing them up. Production is backed up while it is open. Test and developement databases are not in archivelog mode so we have to back them up while they are not available to users. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 12:45 PM > See currently we are using Unix scripts to do our hot backups .We take the > backup on disk and everynight after the disk backup we copy the backup on > tape using Veritas Net Backup. > Presently we keep 2 days worth of backups on the disk and 3 days of archive > logs.That means at any point in time i have the last 2 days backup on disk > (just for fatster recovery so that we can aviod going to tapes in case of a > failure). > Now if we start using RMAN ,we would be taking hot backups (mostly using > increamental strategy) using RMAN.So for e.g. we start on say sunday taking > an incremental level 0 backup on disk.RMAN only remmbers the disk backup > ...right Note that we will also be copying the backups on tape but that > will be independent of RMAN since it is not done using RMAN. > Say the next 3 days of the week ,we do increamental level 1 backups .On the > 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup > on disk (which are the inceemental llevel 1 backups since the whole ideas is > to keep last 2 days backup om disk). > So if we have a failure on Wednesday then RMAN would look for the > incremental level 0 backup of Sunday on the disk but that backup is not > present on the disk now. > I hope i have cleared it up enough. > Now my question is can we maintain the same policy of keeping 2 days backup > on disk by using RMAN. > What kind of backup strategies do RMAN users follow? Are RMAN backups > usually taken on tape directly ? Is it faster to take backups on tape rather > on disk while using RMAN? > > Could RMAN users share their backup/recovery strategies ,please. > > > TIA > > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 17, 2002 5:55 AM > > > > If you are using a recovery catalog then rman keeps track of everything > > there. He knows if you've been naughty, he know if you've been nice, he > > knowsOOOPS I got carried away. But when you do a restore using rman > he > > will tell you what backup sets you will need. > > > > Ruth > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 16, 2002 6:20 PM > > > > > > Hi > > Currently we are using Unix scripts to do backups.We keep last 2 days of > > backups on the disk and also take the backups on tape daily. > > We are planning to use RMAN for backups and would like to maintain the the > > same policy of 2 days backup on disk and daily tape backups. > > Is it possible to implement this using RMAN? Which backup will RMAN > remember > > (while restore) the disk backup or the tape backup? > > If we try to use the incremental strategy ,then how would RMAN remember > the > > last incremental level 0 backup ? It will not be present on disk since we > > only keep the last 2 days backup on it. > > How do i use RMAN to do restore/recovery in this case? > > > > > > I heard that taking backups on tape is faster than on disk when using > RMAN? > > Is it true? > > > > Could RMAN users share their backup/recovery strategies ,please. > > > > TIA > > > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ruth Gramolini > > 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: Sona > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -
RE: Partitions
intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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 Received: from CONNECT-MTA by galotterin the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers 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: Checkpoint & Redo ratio(High)
Seema First remember the old rule : If it's not broken don't fix it. There is a rule of thumb that redo log switches should happened app. every 30 minutes, but if you se redo log switches happening more often at some times and nobody is complaining then just ignore the it. If you have a performance problem and you se redo log switches then create bigger redo logs so that switches happen app. every 30 minute. Seema Singh wrote: > Hi > I checked my database and see redo ratio is high. > I ran the folling query > select (req.value * 5000) / entries.value "Redo Ratio" > from v$sysstat req, v$sysstat entries > where req.name = 'redo log space requests' > and entries.name = 'redo entries'; > But the > background checkpoints completed and background checkpoints started > are having diffrence 1. > When I do large insert and delete I receive message in alert log > "Checkpoint not completed." but not regulary. > My redo log file size is 20m. > oracle is running on 8.1.6 on unix. > LEt me know group suggestion. > Thanks > -Seema > > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp. > -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram 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).
Anybody in DOUG?
Anybody on this list in the Dallas Oracle Users Group? Just wondering if it is worth attending from your perspective. I am over at Park Central and I noticed the meetings are way over in Las Colinas area. In San Diego they were only a few doors down, hey but the houses are bigger... Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
SPACE FREE HOW?
Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database size.What I have to do to get that free space? Is it necessary to shutdown the database? Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Using RMAN
Ruth, I have a couple of questions 1. As I understand from your email ,you do incremental level 0 backups in the morning and level 1 backups in the evening and night everyday using RMAN...right. You mentioned that you also take the backups (i.e level 0 and 2 level 1's for a day )on tape every morning. Do you use RMAN to take the tape backups? If not then RMAN doesn't remember the tape backup . If you had a failure in the evening then you would just restore the level 0 and then apply the subsequent level 1 backup and the archived logs ,...right? My question is how big is your production database? How much time does it take to do 1. level 0 backup 2 level 1 backups Also how resource intensive are the incremenatal level 0 and level 1 backups like in terms of CPU,I/O etc since you do it in the middle of the day. Could you please tell me more about the tape backups that you do?Like what media magmt sortware are you using .We will be using Veritas Netbackup here. Thanks Sona - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 11:55 AM > We use rman to backup all of our databases. But most importantly, we use it > for production. Production databases are in archivelog mode. We do a level > 1 backup at the end of the work day and prior to nitely batch processing. > We do a level 0 backup early in the morning after batch and before users get > on. > > We but a full days worth of backups, including the archivelog backups, on a > tape in the morning. There is one tape for each day of the week, Mon-Fri. > We delete archivlogs from the archive log destination after backing them up. > > Production is backed up while it is open. Test and developement databases > are not in archivelog mode so we have to back them up while they are not > available to users. > > HTH, > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 17, 2002 12:45 PM > > > > See currently we are using Unix scripts to do our hot backups .We take the > > backup on disk and everynight after the disk backup we copy the backup on > > tape using Veritas Net Backup. > > Presently we keep 2 days worth of backups on the disk and 3 days of > archive > > logs.That means at any point in time i have the last 2 days backup on disk > > (just for fatster recovery so that we can aviod going to tapes in case of > a > > failure). > > Now if we start using RMAN ,we would be taking hot backups (mostly using > > increamental strategy) using RMAN.So for e.g. we start on say sunday > taking > > an incremental level 0 backup on disk.RMAN only remmbers the disk backup > > ...right Note that we will also be copying the backups on tape but > that > > will be independent of RMAN since it is not done using RMAN. > > Say the next 3 days of the week ,we do increamental level 1 backups .On > the > > 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup > > on disk (which are the inceemental llevel 1 backups since the whole ideas > is > > to keep last 2 days backup om disk). > > So if we have a failure on Wednesday then RMAN would look for the > > incremental level 0 backup of Sunday on the disk but that backup is not > > present on the disk now. > > I hope i have cleared it up enough. > > Now my question is can we maintain the same policy of keeping 2 days > backup > > on disk by using RMAN. > > What kind of backup strategies do RMAN users follow? Are RMAN backups > > usually taken on tape directly ? Is it faster to take backups on tape > rather > > on disk while using RMAN? > > > > Could RMAN users share their backup/recovery strategies ,please. > > > > > > TIA > > > > > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Thursday, January 17, 2002 5:55 AM > > > > > > > If you are using a recovery catalog then rman keeps track of everything > > > there. He knows if you've been naughty, he know if you've been nice, he > > > knowsOOOPS I got carried away. But when you do a restore using > rman > > he > > > will tell you what backup sets you will need. > > > > > > Ruth > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Wednesday, January 16, 2002 6:20 PM > > > > > > > > > Hi > > > Currently we are using Unix scripts to do backups.We keep last 2 days of > > > backups on the disk and also take the backups on tape daily. > > > We are planning to use RMAN for backups and would like to maintain the > the > > > same policy of 2 days backup on disk and daily tape backups. > > > Is it possible to implement this using RMAN? Which backup will RMAN > > remember > > > (while restore) the disk backup or the tape backup? > > > If we try to use the incremental strategy ,then how would RMAN remember > > the > > > last incremental level 0 backup ? It will not be present on disk since
RE: SPACE FREE HOW?
ALTER TABLE table DEALLOCATE UNUSED KEEP integer; the keep clause is optional. -sunil -Original Message- Sent: Thursday, January 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database size.What I have to do to get that free space? Is it necessary to shutdown the database? Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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).
