Re: Cache Object
NOT Hamid Alavi wrote: > > Hi All, > > I have a question regarding Cache Object in Memory, If I want to Cache a > large data table in the memory i know it will much faster but what happen > if server crash, in this case all modification on table will be gone or NOT. > Any idea about cashing tables not only lookup tables realy appreciated. > > Hamid > > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: Importing data from dump exported with different character set]
Brijesh Lal wrote: > > Hi > > The oracle version I am using is 8.15 and I am > exporting the data into 8.1.6. When I try to import > the data I get error that cannot that data cannot be > imported as it is exported from database with USASCII7 > and being impored into UTF8 format. > > Brijesh > --- "David A. Barbour" <[EMAIL PROTECTED]> wrote: > > Brijesh, > > > > What are the Oracle versions you're exporting from > > and import into? > > UTF8 is a superset of US7ASCII, so you shouldn't be > > having problems. > > What error are you receiving? If you can't get it > > to work, can you redo > > the export? There are several ways to change > > character sets, which are > > documented on OTN and Metalink. Most involve > > changing the NLS_LANG for > > the session (import or export) but there was an > > interesting piece on > > editing the export file to change the reported > > character set last month > > on the list. Go to: > > > > > http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274 > > > > for a précis on the procedure, and check out the > > various Metalink > > references. If you're going to edit the export > > file, you MUST use a > > binary editor. > > > > Brijesh Lal wrote: > > > > > > Hi All > > > > > > I have been given the task to export the data from > > the > > > database which has the character set of USASCII7 > > and > > > import it into Databse with UTF8 character. > > However > > > when I try to this the import fails with error. I > > also > > > searched oracle mannual but was unable to find any > > > relevant information. Can anyone please tell me > > how to > > > accomplish this task > > > > > > Thanks and Regards > > > > > > Brijesh > > > > > > __ > > > Do You Yahoo!? > > > Get personalized email addresses from Yahoo! Mail > > > http://personal.mail.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Brijesh Lal > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > ------------ > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > > (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: David A. Barbour > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (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!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Importing data from dump exported with different character set
Brijesh, What are the Oracle versions you're exporting from and import into? UTF8 is a superset of US7ASCII, so you shouldn't be having problems. What error are you receiving? If you can't get it to work, can you redo the export? There are several ways to change character sets, which are documented on OTN and Metalink. Most involve changing the NLS_LANG for the session (import or export) but there was an interesting piece on editing the export file to change the reported character set last month on the list. Go to: http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274 for a précis on the procedure, and check out the various Metalink references. If you're going to edit the export file, you MUST use a binary editor. Brijesh Lal wrote: > > Hi All > > I have been given the task to export the data from the > database which has the character set of USASCII7 and > import it into Databse with UTF8 character. However > when I try to this the import fails with error. I also > searched oracle mannual but was unable to find any > relevant information. Can anyone please tell me how to > accomplish this task > > Thanks and Regards > > Brijesh > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brijesh Lal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tivoli??
Actually ADSM is the backup software. They moved it over to the Tivoli "brand" last year and now call it their "Data Protection" product. Tivoli generally specializes in network management products, much like CA. See www.tivoli.com Regards, David A. Barbour "C.S.Venkata Subramanian" wrote: > > Tivoli is a backup software supplied by IBM. > -- > > On Fri, 18 May 2001 08:45:47 > Raghu Kota wrote: > >Hi Friends > > > >Could you people shed some light on tool Tivoli, Like what is > >functionality,purpose and more. > > > >Thanks > >Raghu. > > > > > >_ > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Raghu Kota > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: C.S.Venkata Subramanian > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Why I can not create temporary tablespace?
Robert, Check your syntax. CREATE TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' SIZE 50M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Regards, David A. Barbour Robert Chen wrote: > > hi, I connect as sys/change_on_install and execute this: > > create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat' > EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M; > > Error at line 1: > ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat' > ORA-27037: unable to obtain file status > SVR4 Error: 2: No such file or directory > Additional information: 3 > > Please tell me why? I even change the directory to 777(anyone can read and > write) still gotta this error. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Security & Functions
Miss yoga practice? "Gogala, Mladen" wrote: > > alter system electrocute user when an execution of [FUNCTION NAME] is > attempted; > > -Original Message- > Sent: Wednesday, May 16, 2001 4:17 PM > To: Multiple recipients of list ORACLE-L > > How do I restrict access to functions? > > Chris Rezek > Database Administrator > DotClick > http://www.dotclick.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chris Rezek > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: file output of a SP
Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your init.ora file to use the package which means you'll need to bounce the DB. Regards David A. Barbour > "Bunyamin K. Karadeniz" wrote: > > Hi Gurus, > I have a problem, > I am trying to output a txt file of my query results. But all these > will be in a stored procedure, And in the procedure , how will I open > a file and write to it and then close it ? > Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Running remote scripts
Rajesh, You can't run interactive commands using rsh. You should be able to put all your commands into a script(s) and execute those. Otherwise try rlogin. Regards, David A. Barbour Rajesh Dayal wrote: > > Hi All, > Env. is TRU64 Unix and Oracle 7.3.4 > This is a standby server configuration. I want to run > certain scripts(on secondary server), based on some incident > on primary server. And on top of that, every thing has to be > fully automated(using cron). > I got stuck at a point where I need to run some script > on secondary without explicitly logging on secondary server. > I tried using rsh, but it executes just one single command. > I would appreciate if some one can guide me on this. > > TIA, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL-procedures
Write a package. David A. Barbour [EMAIL PROTECTED] wrote: > > How can I write procedure which runs 3 different subprocedures.? > > Roland Sköldblom > > -- > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Data Reporting tools
Dick, Go with Discoverer. As the admin, you can build a subset of the data and push it out to the power users with the data labeled any way you like. You can also give you power users the ability to create their own views if you are so inclined. They accomplish this through the GUI, with no 'direct' access to the database (of course they do, you need to set up their permissions etc., but you can lock it down pretty tight and what they're really creating is data about data which you can excise without harm to your DB at any time). Training is a snap, the interface is familiar and fairly intuitive, particularly for those with Access/Excel skills and experience. I used Discoverer for our Engineering teams to access Remedy (ugh!) data. Crystal Reports was the 'preferred' solution by the vendor, who wanted to send 20+ people to user training for a week to get them up to speed. The Discoverer solution was much simpler and more cost-effective for all involved. They were quite proud of their ability to create ad-hoc reports, and very lavish with their praise of the 'support' they were getting from the DBA! Regards, David A. Barbour "Ruiz, Mary A (CAP, CDI)" wrote: > > Hi Dick: > I have a similar project on my plate. I like Business Objects. Actually, we do >not want users to have to know table/column names and need a product where we can >build a data > repository. I am not sure if we need a complete end-to-end solution as many BI >companies seem ready to provide. Other vendors on our short list are - Oracle >(Discoverer), Cognos, > Brio, Informatica (not sure if we need it) and Sagent (has a nice ETL product). > > Mary Ruiz /Atlanta > > -Original Message- > Sent: Thursday, May 10, 2001 2:11 PM > To: Multiple recipients of list ORACLE-L > > To ALL, > > I've been given a project to find a way to make data easily available to end > users, preferably via a thin client (read that as browser based). We're looking > at Discoverer 3000 and 9iAS, but the boss wants to know what other options are > out there. The general idea would be to have a client/server based tool that we > could deploy to the power users (of which we have only a few). These > individuals are NOT programmers nor in the IS group, but they know the data. We > want them to create the queries/reports (with graphics included which the > Discoverer viewer does not do) and then publish them via the database. This is > a lot of what Discoverer does, but are there other tools out there that do the > same? Any recommendations??? > > Dick Goulet > Senior Oracle DBA > Vicor Corporation > -- > 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: Ruiz, Mary A (CAP, CDI) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Taking your time when a crisis occurs
Eric, What's with you and Barbie? David A. Barbour "Eric D. Pierce" wrote: > > RE: Taking your time when a crisis occurs > > - > > http://www.amazon.com/exec/obidos/ASIN2/B4SU3E > > Barbie as Glinda from The Wizard of Oz > > > Our Price: $19.99 > Availability: Usually ships within 24 hours. > > Manufacturer's age: 3 years and up > Shipping: Currently, item can be shipped only within the U.S. > Shipping weight: 0.7 pounds. > Note: Giftwrapping not available for this item. > Packaging: This item may be delivered in the manufacturer's original > packaging, which could reveal the contents of the box. > ASIN: B4SU3E > > > > >From Toysrus.com & Amazon.com > Editorial Review > > "Are you a good witch or a bad witch?" A good witch, of course--and > pretty as well! Dressed as Glinda, the good witch of the North from > the beloved book and movie The Wizard of Oz, Barbie is welcomed to > Munchkinland. She has long, curly strawberry-blonde hair topped by a > tall lavender-pink crown, and she's wearing a sparkling pink satin > ball gown ornamented with silver stars and butterflies. She also has > on a silver braided belt. Her outfit is completed with pink heels and > a long, lavender magic wand that fits in her hand. Raise her arm (or > press the button on her back), and you'll hear the wand's magical > "brrinnng!" sound or Glinda's voice saying, "Tap your heels together > three times." Sound effects are produced by three included button > cell batteries, which can be replaced. Say it again, Glinda, just so > we'll never forget: "There's no place like home." --Marcie Bovetz > Safety Information > Choking hazard: Small parts. Not for children under 3 years. > > - > > On 7 May 2001, at 10:21, Marianne Brooks wrote: > > > Hmm, shaved head, why didn't I think of that? I would imagine a woman with > > a shaved head might be as effective...add a tatoo, some leather pants and a > > scowl and I've got a new me! :-) > > ... > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eric D. Pierce > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fwd: please help
Jared, I think you hit the nail on the head when you said "Best practice of course is to make a backup of your database in it's current condition prior to restoring it." Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see "Training a DBA" by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: > > Dick, > > Backing up the redo logs can have some serious consequences. > > Let's say you are restoring the database files, and a number of > archived logs to roll forward through. > > Following that, you are going to roll forward through all archived logs > that are still online, and then through your current redo logs for a > complete recovery. > > Restoring old redo logs would render this strategy ineffective. > > Backing them up can be a good thing, but it would be very easy > to inadvertently wipe out the current ones when restoring from tape. > > Best practice of course is to make a backup of your database in > it's current condition prior to restoring it. > > It would also be prudent to make copies of the redo logs locally > so you don't have to restore them from tape. > > Jared > > On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: > > Jonathan, > > > > It would appear that your friend has hit upon one of the problems of > > hot backups that everyone misses and actually Oracle recommends against. > > That is backing up your online redo log files and doing that LAST. The > > reason is that there are more than likely active transactions that were > > recorded therein and those logs are not available. Can he complete the > > recovery, maybe if he has the remaining logs from the active system, I'm > > assuming he is recovering to somewhere other than his production system. > > Otherwise his only recourse is OTS. > > > > Dick Goulet > > Oracle Certified 8i DBA > > > > Reply Separator > > Author: Jonathan Gennick <[EMAIL PROTECTED]> > > Date: 5/1/2001 8:55 PM > > > > Fellow list members, I received the following email from a > > reader a few minutes ago. If you skip down to where he talks > > about backup, you'll see that he's in trouble with a > > database that won't recover. I've already suggested that he > > open a TAR, and that he supply more specifics as to error > > messages and the like, but maybe someone on this list can > > draw some conclusions from what he's told me so far. If > > you're good at recovery, have a look at what he says. I'll > > post his email address later if he says its ok, and I'll > > pass on any advice/suggestions I receive in the meantime. > -- > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: E-mail from Alert Logs
Siv, Check out all the email tools available at: http://www.freedownloadscenter.com/Email_Tools/ Regards, David A. Barbour Oracle DBA, OCP Siv Chelakkara wrote: > > Bunyamin, > > Would you please send a copy of the attachment directly to me, since the list does >not allow binary attachments. Or if there is a URL where I can download or get more >info, please e-mail that URL to the list. > > Thanks, > > Sivaram > > >>> "Bunyamin K.Karadeniz" <[EMAIL PROTECTED]> 05/03/01 09:51AM >>> > There is a program (AUTOMAIL) which sends an email to anyone you idntify > when there is a change in a file. Look at it . It is attached . > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, May 03, 2001 3:00 PM > > > Hi List > > > > Is there any way of receiving an e-mail or sms , whenever a ORA- error > > appears in the Oracle Alert Log, or when something unexpected happens to > > the Oracle Instance ? > > > > > > TIA > > > > Saj > > > > -- > > Sajid Iqbal > > Database Team Leader > > > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sajid Iqbal > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Siv Chelakkara > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: images question
Check out BLOBs. They're stored externally. Can be tough to work with but also can be very worthwhile. Regards, David A. Barbour Oracle DBA,OCP "Casas, Claudia" wrote: > > Do you recommend storing images in an oracle database or just storing the > directory path to them instead. Somebody told me it would cause database > fragmentation if I store images or binary data in databases?? > > --Claudia Casas- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Casas, Claudia > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fwd: please help
Bill, Did you force a log switch before and after the hot backup? Did you backup your archive logs (or alternatively, are they available)? Sounds to me like you need to run ALTER DATABASE RECOVER UNTIL (CANCEL, TIME, CHANGE, USING BACKUP CONTROLFILE); If you didn't force the log switch, be mindful that you may have to specify one or more of the redo logs to get the requested SCN. Did you backup the controlfile? redo logs? init.ora? orapasswd? These are some generalities, which may or may not apply to your specific situation. However, given the information at hand, it's probably where I'd start looking. Regards. David A. Barbour Oracle DBA, OCP Jonathan Gennick wrote: > > Fellow list members, I received the following email from a > reader a few minutes ago. If you skip down to where he talks > about backup, you'll see that he's in trouble with a > database that won't recover. I've already suggested that he > open a TAR, and that he supply more specifics as to error > messages and the like, but maybe someone on this list can > draw some conclusions from what he's told me so far. If > you're good at recovery, have a look at what he says. I'll > post his email address later if he says its ok, and I'll > pass on any advice/suggestions I receive in the meantime. > > -- > Best regards, > > Jonathan Gennick > mailto:[EMAIL PROTECTED] * 906.387.1698 > http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org > > Tuesday, May 01, 2001, 10:27:51 PM, X wrote: > BC> Hi Jonathan, > > BC> I always read and like your articles in the Oracle > BC> Magazine. > > BC> Could you please give me a moment of your time .. > BC> I have some couple of pressing problems and questions > BC> if you don't mind as i am under fire at work .. > > BC> I have trouble with some of the Oracle databases that > BC> i manage on Sun Solaris platform, sometimes i have my > BC> shutdowns hanging and this takes a very long time to > BC> complete. Also, hanging problems with some of the sql > BC> statements. Could you lend a hand about any possible > BC> clues as to what i should do or where i should look > BC> for answers. > > BC> My last question is about hotback. > > BC> I ran a hot backup yesterday and tried recovering > BC> today. I was faced with an Oracle error saying system > BC> tablespace needs more recovery and that open resetlogs > BC> will get an error after automatically applying the > BC> redo logs. > > BC> My backup strategy went this way, > > BC> i created a backup shell script and > BC> i put all tablespaces in hotbackup mode at the same > BC> time with this syntax.. > > BC> select 'alter tablespace' || tablespace_name ||'begin > BC> backup;' > BC> from dba_tablespaces > BC> where status <> 'INVALID'; > > BC> I copied my datafiles to backup using the syntax below > BC> ... > > BC> !cp /u02/oradata/prod/system01.dbf/backup/prod > BC> !cp > BC> !cp > BC> !cp > BC> !cp > > BC> then ended backup the same way as i began backup > BC> with the ||'end backup;' > > BC> I backed up my controlfile > > BC> and everything went well. Today, I restored my > BC> datafiles from backup and i was greeted with the > BC> problem i just expalined to you. > > BC> I am the only dba DBA at this location > BC> and i need some advise on what to do as this is a > BC> serious issue with my supervisor. > > BC> Thanks, > > BC> Bill > > BC> __ > BC> Do You Yahoo!? > BC> Yahoo! Auctions - buy the things you want at great prices > BC> http://auctions.yahoo.com/ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jonathan Gennick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: unix command question
It's commands like awk, grep, xargs and troff that give UNIX a bad name. I read somewhere (more years ago than I'd care to recall) that you should always beware of an operating system with commands that sounded like bad bodily functions. Jared Still wrote: > > Haven't seen this one mentioned yet: > > find . -type d -print | xargs ls -ld > > Jared > > On Tuesday 01 May 2001 19:55, David A. Barbour wrote: > > ls -Ra | grep / > > > > That's ls -Ra 'pipe' grep / > > > > You know, the spell checker has fits with the stuff on this list. > > > > Regards, > > > > David a. Barbour > > Oracle DBA, OCP > > > > Roy Ferguson wrote: > > > what I would like to see is all directories...not files starting with a > > > particular letter but all directories... > > > > > > ls -d - doesn't work > > > ls -ld p* - doesn't work either > > > > > > >Roy, > > > > > > > >You could do say ls -ld p* to list the directories starting with p. > > > > > > > >Rgds, > > > > > > > >raja > > > >-- > > > > > > > >On Tue, 01 May 2001 13:35:46 > > > > > > > > Roy Ferguson wrote: > > > >>what is the ls command to view only a list of directories? > > > >> > > > >>ls -la lists both files and directories...I want to view only a list of > > > >>directories... > > > >> > > > >>environment is sun sparc solaris 2.6 > > > >> > > > >>thanks in advance > > > >> > > > >>roy > > > >> > > > >>-- > > > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > >>-- > > > >>Author: Roy Ferguson > > > >> INET: [EMAIL PROTECTED] > > > >> > > > >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > >>San Diego, California-- Public Internet access / Mailing Lists > > > >> > > > >>To REMOVE yourself from this mailing list, send an E-Mail message > > > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > >>the message BODY, include a line containing: UNSUB ORACLE-L > > > >>(or the name of mailing list you want to be removed from). You may > > > >>also send the HELP command for other information (like subscribing). > > > > > > > >Get 250 color business cards for FREE! > > > >http://businesscards.lycos.com/vp/fastpath/ > > > >-- > > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > >-- > > > >Author: Viraj Luthra > > > > INET: [EMAIL PROTECTED] > > > > > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > >San Diego, California-- Public Internet access / Mailing Lists > > > > > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > >the message BODY, include a line containing: UNSUB ORACLE-L > > > >(or the name of mailing list you want to be removed from). You may > > > >also send the HELP command for other information (like subscribing). > > > > > > Roy E. Ferguson II > > > Intel Sacramento > > > 916-854-1123 > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Roy Ferguson > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (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:
Re: unix command question
ls -Ra | grep / That's ls -Ra 'pipe' grep / You know, the spell checker has fits with the stuff on this list. Regards, David a. Barbour Oracle DBA, OCP Roy Ferguson wrote: > > what I would like to see is all directories...not files starting with a > particular letter but all directories... > > ls -d - doesn't work > ls -ld p* - doesn't work either > > > > >Roy, > > > >You could do say ls -ld p* to list the directories starting with p. > > > >Rgds, > > > >raja > >-- > > > >On Tue, 01 May 2001 13:35:46 > > Roy Ferguson wrote: > >>what is the ls command to view only a list of directories? > >> > >>ls -la lists both files and directories...I want to view only a list of > >>directories... > >> > >>environment is sun sparc solaris 2.6 > >> > >>thanks in advance > >> > >>roy > >> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: Roy Ferguson > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >>San Diego, California-- Public Internet access / Mailing Lists > >> > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >>the message BODY, include a line containing: UNSUB ORACLE-L > >>(or the name of mailing list you want to be removed from). You may > >>also send the HELP command for other information (like subscribing). > >> > > > > > >Get 250 color business cards for FREE! > >http://businesscards.lycos.com/vp/fastpath/ > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Viraj Luthra > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > Roy E. Ferguson II > Intel Sacramento > 916-854-1123 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Roy Ferguson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: differences between physical datafile and v$datafile
File Header David Jones wrote: > > Dear Guru: > > When I query the physical file size > > oracle:>ls -l users01.dbf > -rw-r- 1 oracle dba 104865792 Apr 10 13:56 users01.dbf > > compare with the size I get from the v$datafile > SQL> select name, sum(bytes) from v$datafile where name like '%users%' group > by name; > > NAMESUM(BYTES) > --- -- > /u02/oradata/GDB1/users01.dbf104857600 > > Why there're 8K difference ? > > Thanks > > --dj > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Jones > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FILE SYSTEM BUFFER IN JFS : ON OR OFF
What flavor of UNIX and what type of storage are you considering? Regards, David A. Barbour Raj Sakthi wrote: > > Hi List , > I posted this on friday but didn't see it on the list > so I am posting this again . I am redesigning a major > system and particular attension is being given to > filesystem configuration and IO . I got this from one > supposedly top notch Unix performance tuning expert . > I would like to know if anybody implemeted this and > what are the impacts . > > "The options you want are mount options available only > with Online JFS (not a free product, unfortunately.) > The options you want are: > RBS & TEMP files : mincache=dsync, convosync=dsync > DATAFILES & REDO files : mincache=direct, > convosync=direct > " > TIA > regards, > RS > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raj Sakthi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-07445
Sajid - Operating system error. Are you on UNIX? Bad inode reference? Check your system error log. Regards, David A. Barbour Sajid Iqbal wrote: > > Hello All > > This message is appearing in the alert log periodically.. anyone know hat > it means and how I can get rid of it > > ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] > [Address not mapped to object] [8] [] [] > > Thanks > > -- > Sajid Iqbal > Database Team Leader > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: date format ?
Mohammed, Just off the top of my head, I don't think this will work unless you bring the day, month and year in separately. At first glance I thought perhaps if you took the length of the date string (less than 6 or more than eight you've got an error), backed out the last four as the year - so far so good, but the day/month is a problem. How would you evaluate '212' - as 2 December or 21 February? Regards, David A. Barbour Oracle DBA, OCP MOHAMMAD AMER wrote: > > hi oracle gurus, > my client is very weird,he wants to enter the date in the format 'dd-mm-' > without pressing space instead of delimiters,e.g. he presses > '991999' and wants oracle to change it to '09-09-1999' .!!! > Can I do it for him? > If anyone knows how,I'll be very grateful. > > stucked with date formats > > > Get free email and a permanent address at http://www.netaddress.com/?N=1 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MOHAMMAD AMER > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: How to Automate Procedure Execution
dba_jobsLists all the jobs in the database. user_jobs Lists all jobs owned by the user. dab_jobs_running Lists all jobs in the database that are currently running (join with V$LOCK to identify jobs that have locks). Hope this helps. David A. Barbour Oracle DBA, OCP abdul latif wrote: > > Raj, > > Which view do you use to view dbms_jobs? > > tia > --- "Jamadagni, Rajendra" > <[EMAIL PROTECTED]> wrote: > > Yes, I have used with very good success it's > > all documented in T(ht) > > F(ine) M(anual). Or just open up > > $ORACLE_HOME/rdbms/admin/dbmsjob.sql ... > > this file itself is pretty good at explaining > > things. > > > > HTH > > Raj > > > __ > > Rajendra JamadagniMIS, 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 ! > > > > > * > > > > 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 ESPN at (860) 766-2000 and delete this e-mail > > message from your computer, Thank you. > > > > > * > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Jamadagni, Rajendra > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: abdul latif > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ------------ > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trace file does not reside in user_dump_dest. Why ?
Chor Ling, Go to the /dg1/oracle/niecomn/admin directory and run ls -al. If you see an arrow pointing to a directory description /dg1/oracle/nieora/8.1.6/rdbms/log, then it is a link. Regards, David A. BArbour Oracle DBA, OCP "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi David, > > How do I know whether the udump directory is a link to the > nieora/8.1.6/rdbms/log directory? My OS is Unix & I am pretty new to Unix. > Any advice ? TIA > > Regds, > Chorling > -Original Message- > From: David A. Barbour [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 27, 2001 10:41 PM > To: Multiple recipients of list ORACLE-L > Subject:Re: Trace file does not reside in > user_dump_dest. Why ? > > Catherine, > > Just a WAG, but could the udump directory be a link to the > nieora/8.1.6/rdbms/log directory? > > David A. Barbour > Oracle DBA, OCP > > "CHAN Chor Ling Catherine (CSC)" wrote: > > > > Hi Ed, > > > > SQL> select name, value > > 2 from v$parameter > > 3 where name like '%user_dump%'; > > > > NAME VALUE > > > > > user_dump_dest > /dg1/oracle/niecomn/admin/udump > > > > The user_dump_dest is /dg1/oracle/niecomn/admin/udump but > the trace file is > > dumped into another directory > /dg1/oracle/nieora/8.1.6/rdbms/log. > > The unix permission for /dg1/oracle/niecomn/admin/udump & > > /dg1/oracle/nieora/8.1.6/rdbms/log is the same. > > > > I just don't understand why the trace file is not located > in user_dump_dest. > > > > Puzzled, > > New bee > > -Original Message- > > From: Shevtsov, Eduard > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 26, 2001 6:26 PM > > To: Multiple recipients of list > ORACLE-L > > Subject:RE: Trace file does not > reside in > > user_dump_dest. Why ? > > > > Hi > > > > have you got unix permissions to write to > this directory? > > Try to logon as oracle owner and check it > by writing any > > small file there. > > > > Also look at the output of the query > > > > select name, value > > from v$parameter > > where name like '%user_dump%'; > > > > It will show your actual user dump > directory > > > > HTH > > > > Ed > > > > > > > > > > > Hi, > > > > > > I forget to mention that when I show > parameter dest* in > > > server manager , the > > > user_dump_dest is pointing to the right > directory > > > /dg1/oracle/niecomn/admin/udump. > > > > > > My earlier email : > > > I issue the command "alter > database backup > > > controlfile to > > > trace", expecting my trace file to > reside in the > > > user_dump_dest directory. > > > > > > connect / as sysdba;
Re: PLEASE HELP !
Andrea, Build one database with different schemas for each user. When they log in, they'll only have access to their own data. You'll have to decide whether to use UNIX or NT depending on a variety of factors, but if you have the available resources, I'd go with UNIX (multiple users performing multiple tasks). Regards, David A. Barbour Oracle DBA, OCP Andrea Oracle wrote: > > Hi all, > > Our trainer needs to build training database/s, she is > asking the following questions: > > 1. use Sybase or Oracle as the database server? > We have some projects using Sybase databases, and > > old training database is on Sybase. > > 2. build the database on Unix vs NT platform? > > 3. She wants each trainee has his/her own > database(!!!), since she doesn't want one use to see > other user's data. And she said in Sybase it's really > easy to do this, she has a script that can create > multiple databases. Is it doable (please give some > tip or script), or is it necessary ??? > > Any idea will be greatly appreciated!!! > > Andrea > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrea Oracle > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UTL_FILE Problem Solved
Thanks for the input Ian, I figured out the problem which really involved how I was logging into the database. There was a note on Metalink where somebody was having the same problem I was experiencing - the file would be created, but either nothing would be written, or you'd get a write error. The difference was that they were executing their procedure via a dblink and got the problem fixed when they replaced and restarted their listener. Thinking through this, I realized that this particular database had been installed by a contractor who started everything as the SAP admin user, and not as the Oracle user who "owns" the database and the listener. ps -ef showed all the core oracle processes(pmon, smon, dbwr, etc.) were owned by p01adm. So I switched to that user, went to the Oracle bin directory and started sqlplus from there, again not as the UNIX Oracle user, but as the UNIX SAP user. Logged in as normal, and voila - it works. Seems UTL_FILE picks up permissions/groups from the UNIX user that either started the database or started the listener. Hard won knowledge, but hopefully it will save somebody else the pain I've been through the last several hours. Hope everyone has a great weekend. David A. Barbour Oracle DBA, OCP (feeling a little lighter as I trod the path) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problems with hot backup via BCV's...
Jim, Don't know if this applies in your case, but a couple of years ago I had similar problems with hot backups on AIX. It seems that if the initialization parameter log_archive_buffers was set to anything higher than 1, I had the possibility of getting "Fuzzy" SCNs (they didn't call it that, they called it corrupted SCNs). There was supposed to be a patch (has to do with the AIX implementation of AIO), but I never saw it, never changed this parameter back, and haven't had any problems since. Regards, David A. Barbour Oracle DBA, OCP (still seeking the one true path) Jim Hawkins wrote: > > List, > > Oracle 8.0.4.3.0 > AIX 4.3.3 > EMC Symmetrix > SAPR/3 4.0B > 200,000+ transactions/day; 300GB database. > > Here's what we do: > 1. Put all tablespaces in hot backup mode. > 2. Split/Sync mirror. > 3. Take tablespaces out of hot backup mode (usually after only 3-5 > minutes). > 4. Take BCV backup of this mirror. > > Problem is, when restored, sometimes the database can be opened resetlogs, > and sometimes it can't. When it opens, we just apply all archive logs > generated during steps 1 through 3, then open resetlogs and it works fine. > The other half of the time, Oracle complains that the system datafile still > needs more recovery. You can keep applying logs and it will never open. > Oracle had me take header dumps to check for "fuzzy SCN's", which these do > appear to have. Oracle says this is a bad backup set even though EMC > thinks it was fine. By the way, "fuzzy SCN's" are SCN's that have a hex > value that evaluates to a nonnumeric, nonsensical number. > > Was wondering if anyone else was having issues with hot BCV backups and > restoring them. We are current in terms of EMC TimeFinder and other > software. It just seems to be hit or miss with these backups (obviously we > take other backups too, but these are the easiest and most timely). > > Thanks, > Jim > > Jim Hawkins > Lead SAPR/3 Oracle Database Administrator > MEMC Electronic Materials, Inc. > 600 Pearl Drive > St. Louis, MO 633376 > 9636) 474-7832 > [EMAIL PROTECTED] (work) > [EMAIL PROTECTED] (home) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jim Hawkins > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UTL_FILE error
Thanks IAN,
It confirmed what I already expected - it's a "write error." I can't
figure out why though. This directory is owned by the oracle user. It
creates the file, but the refuses to write to it! I've changed the
specification to 'A" and given /oracle and /P01 full permissions.
Touched the file and chmod 777 the file. Still the error.
Reran catproc.sql (I'm really out there now). If I execute the sql
statement: select osuser from v$session where audsid =
userenv('sessionid'); I get orap01, which should be the right guy.
Searched Metalink (response time isn't bad right now) with no luck.
This is on AIX 4.2.1 with which I used to pride myself on having some
sort of familiarity. Pride goeth before a fall.
Any other ideas?
David A. Barbour
Oracle DBA, OCP(and still searching for enlightenment)
This is
"MacGregor, Ian A." wrote:
>
> You need to handle the exception, for example
>
> Exception
>When no_data_found then
> dbms_output.put_line ('no data found');
>When utl_file.internal_error then
> dbms_output.put_line('internal error');
>When utl_file.invalid_filehandle then
> dbms_output.put_line('invalid filehandle');
>when utl_file.invalid_mode then
> dbms_output.put_line('invalid mode');
>when utl_file.invalid_operation then
> dbms_output.put_line('invalid operation');
>when utl_file.invalid_path then
> dbms_output.put_line('invalid path');
>when utl_file.read_error then
> dbms_output.put_line('read error');
>when utl_file.write_error then
> dbms_output.put_line('write error');
>when value_error then
> dbms_output.put_line('value error');
>when others then
> dbms_output.put_line('unspecified exception raised');
>
> --
>
> Setting the utl_file parameter to * is a dangerous thing to do. It allows writes to
>any file to which Oracle can write.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Friday, April 27, 2001 10:56 AM
> To: Multiple recipients of list ORACLE-L
>
> Morning all,
>
> I've got a problem with the UTL_FILE package on a 7.3.4 database. The
> UTL_FILE_DIR initialization parameter is set to *. I define my
> filespecs as follows:
>
> file_one UTL_FILE.FILE_TYPE;
> BEGIN
>
> file_one:= UTL_FILE.FOPEN('/oracle/P01','Jul_Dec96.csv','W');
>
> The file gets created okay:
>
> grendel:orap01> ls -al *.csv
> -rw-r--r-- 1 orap01 dba0 Apr 27 11:18 Jul_Dec96.csv
>
> I perform some selects and various data stuff then I go to add a
> line(output severely reduced for testing purposes):
>
> UTL_FILE.PUT_LINE(file_one,v_zcoanum);
> I get :
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 87
> ORA-06512: at "SYS.UTL_FILE", line 218
> ORA-06512: at "SAPR3.COAPRODX3", line 123
> ORA-06512: at line 1
>
> The variable v_zcoanum is ALWAYS present - DBMS_OUTPUT.PUT_LINE shows it
> just fine. I've bounced the instance, re-run the utlfile.sql, and tried
> changing target directories. I've even tried a PUTF -
> UTL_FILE.PUTF(file_one,'%s', v_zcoanum); but get the same type of
> errors:
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 87
> ORA-06512: at "SYS.UTL_FILE", line 188
> ORA-06512: at "SYS.UTL_FILE", line 273
> ORA-06512: at "SYS.UTL_FILE", line 299
> ORA-06512: at "SAPR3.COAPRODX3", line 123
> ORA-06512: at line 1
>
> I'm wondering if I need to re-run catproc.sql? This same procedure
> works on a test instance on a different box (same O/S, same
> init.ora). Generally I'd see these types of errors when the
> UTL_FILE package isn't installed or there are too many open file handles
> tried to eliminate this by bouncing the instance). Does anybody have a
> clue here?
>
> Thanks,
>
> David A. Barbour
> Oracle DBA, OCP (Obviously not a path to enlightenment)
> Worn to a frazzle staring at my own code and out of ideas
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David A. Barbour
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California--
Re: SQLLDR - whitespace (tab & space) problem
Helen, You can use the "optionally" parameter to specify multiple enclosed by/terminated by parameters. NULLIF is also available to assist in loading blanks. Regards, David A. Barbour Oracle DBA, OCP Helen Zhung wrote: > > Hello: > > I'm new to SQL Loader. Is there a way to code in control file that can > separate 'a tab' and 'a blank space' ? > > I use "FIELDS TERMINATED BY WHITESPACE", but it will TERMINATE a field > when there is a space or a tab. However, the data fields were > separated only by the "tab", not 'a space'. Is it possible to identify > the two? > > Thanks > > > > -- > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UTL_FILE error
Morning all,
I've got a problem with the UTL_FILE package on a 7.3.4 database. The
UTL_FILE_DIR initialization parameter is set to *. I define my
filespecs as follows:
file_one UTL_FILE.FILE_TYPE;
BEGIN
file_one:= UTL_FILE.FOPEN('/oracle/P01','Jul_Dec96.csv','W');
The file gets created okay:
grendel:orap01> ls -al *.csv
-rw-r--r-- 1 orap01 dba0 Apr 27 11:18 Jul_Dec96.csv
I perform some selects and various data stuff then I go to add a
line(output severely reduced for testing purposes):
UTL_FILE.PUT_LINE(file_one,v_zcoanum);
I get :
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 87
ORA-06512: at "SYS.UTL_FILE", line 218
ORA-06512: at "SAPR3.COAPRODX3", line 123
ORA-06512: at line 1
The variable v_zcoanum is ALWAYS present - DBMS_OUTPUT.PUT_LINE shows it
just fine. I've bounced the instance, re-run the utlfile.sql, and tried
changing target directories. I've even tried a PUTF -
UTL_FILE.PUTF(file_one,'%s', v_zcoanum); but get the same type of
errors:
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 87
ORA-06512: at "SYS.UTL_FILE", line 188
ORA-06512: at "SYS.UTL_FILE", line 273
ORA-06512: at "SYS.UTL_FILE", line 299
ORA-06512: at "SAPR3.COAPRODX3", line 123
ORA-06512: at line 1
I'm wondering if I need to re-run catproc.sql? This same procedure
works on a test instance on a different box (same O/S, same
init.ora). Generally I'd see these types of errors when the
UTL_FILE package isn't installed or there are too many open file handles
tried to eliminate this by bouncing the instance). Does anybody have a
clue here?
Thanks,
David A. Barbour
Oracle DBA, OCP (Obviously not a path to enlightenment)
Worn to a frazzle staring at my own code and out of ideas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David A. Barbour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Trace file does not reside in user_dump_dest. Why ?
Catherine, Just a WAG, but could the udump directory be a link to the nieora/8.1.6/rdbms/log directory? David A. Barbour Oracle DBA, OCP "CHAN Chor Ling Catherine (CSC)" wrote: > > Hi Ed, > > SQL> select name, value > 2 from v$parameter > 3 where name like '%user_dump%'; > > NAME VALUE > > user_dump_dest /dg1/oracle/niecomn/admin/udump > > The user_dump_dest is /dg1/oracle/niecomn/admin/udump but the trace file is > dumped into another directory /dg1/oracle/nieora/8.1.6/rdbms/log. > The unix permission for /dg1/oracle/niecomn/admin/udump & > /dg1/oracle/nieora/8.1.6/rdbms/log is the same. > > I just don't understand why the trace file is not located in user_dump_dest. > > Puzzled, > New bee > -Original Message- > From: Shevtsov, Eduard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 26, 2001 6:26 PM > To: Multiple recipients of list ORACLE-L > Subject:RE: Trace file does not reside in > user_dump_dest. Why ? > > Hi > > have you got unix permissions to write to this directory? > Try to logon as oracle owner and check it by writing any > small file there. > > Also look at the output of the query > > select name, value > from v$parameter > where name like '%user_dump%'; > > It will show your actual user dump directory > > HTH > > Ed > > > > > > > Hi, > > > > I forget to mention that when I show parameter dest* in > > server manager , the > > user_dump_dest is pointing to the right directory > > /dg1/oracle/niecomn/admin/udump. > > > > My earlier email : > > I issue the command "alter database backup > > controlfile to > > trace", expecting my trace file to reside in the > > user_dump_dest directory. > > > > connect / as sysdba; > > startup > pfile=/dg1/oracle/nieora/8.1.6/dbs/initNIE.ora > > > > In the startup file, > > User_dump_dest = > /dg1/oracle/niecomn/admin/udump > > > > However, the trace file resides in another > directory > > /dg1/oracle/nieora/8.1.6/rdbms/log. > > > > I am very... very puzzled. Could the gurus > explain this > > phenomenon ? Thanks. > > > > Regds, > > New Bee > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: CHAN Chor Ling Catherine (CSC) > >INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > > San Diego, California-- Public Internet access / > > Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail > message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be removed > from). You may > > also send the HELP command for other information (like > subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shevtsov, Eduard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > San Diego, California-- Public Internet access / > Mailing Lists > >
Re: Please Advice on Performance Tuning
NJ, >From what you've outlined here, everything should be the same except in creating the new user, did you use import/export on the tables? If you did, then I'd check to see if row chaining might not be a problem. Have you tried forcing the application to use rule-based optimizer and seeing if you get different results? Regards, David A. BArbour Oracle DBA, OCP N J Neog wrote: > > Hi David, > > Thanks for your suggestion. > I thought TRACE,TKPROF, EXPAIN PLAN > will be the last thing thing I will do. > Because There may be lot of SQL Statement I have to select from these two > Package for probable degradation. Moreover in both user same two package was > recompiled. > If inefficient SQL are there in Package then it is there in both schema, so > if in one user > takes 22-24 Min. then the same should happen in other user also or otherway > round. > The question is what to check for the degradation ? > > To add to it. > > Our Oracle Server is in RAID. > Both Schema does not have any auditing or Profile (Except default) > > Thanks once again. Regards. > > NJN. > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Friday, April 27, 2001 11:55 AM > > > NJ, > > > > For each SQL statement in each instance, run a trace, then run tkprof > > against it with the explain option. When you compare the two, it should > > tell you what they are doing differently and what you're biggest time > > waster is. > > > > Regards, > > > > David A. Barbour > > Oracle DBA, OCP > > > > > N J Neog wrote: > > > > > > Hi all, > > > > > > We have got a Payroll Application develeoped in-house. > > > > > > It takes 30-34 Minutes to Run this Batch Application. > > > General feeling is - it should be able to process it > > > within 10-15 Minutes may be less than that. > > > > > > I am to look into this problem and give a solution to it. > > > > > > Steps I had followed as > > > > > > 1. Import the payroll user to another Oracle User in the same > > > database. > > > > > > 2. Removed unnecessary Index , Put parallelism into few > > >tables by Alter table tab1 Parallel(DEGREE 5) > > > > > > 3. Analyze the tables with compute statistics; > > > > > > 4. Run the payroll without checking any inefficient SQL or > > >wrong programming logic in the those Packages( It has only > > >two Package in it no other stand alone Procedure or function). > > > > > > Payroll under this new Oracle User runs in 22-24 Minutes, 6-9 Minutes > > > less. So, I asked Payroll Person to remove those unnecessary Index, > > > asked him to put parallelism into those tables which I had done. > > > He runs the Payroll with no Improvement at all. I asked again to > > > drop those table and recreate it with new storage parameter same > > > as the one created at New User. Still no visible Improvement. > > > > > > At this stage every table in both user has same storage parameter,same > > > index ,and also analyzed. The question is why in One User > > > it runs in 22-24 Min and in another 30-34 Min ? > > > > > > Now Please advice me what do I check or to do, so that the it time > > > takes > > > to run comes down to 22-24 Min, same as the new user. > > > > > > Oracle 8.1.4 > > > Optimize goal : choose > > > Biggest table haiving record less than 6 rows. > > > > > > Thanks in Advance > > > > > > Naba > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: David A. Barbour > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: N J Neog > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538
Re: Please Advice on Performance Tuning
NJ, For each SQL statement in each instance, run a trace, then run tkprof against it with the explain option. When you compare the two, it should tell you what they are doing differently and what you're biggest time waster is. Regards, David A. Barbour Oracle DBA, OCP > N J Neog wrote: > > Hi all, > > We have got a Payroll Application develeoped in-house. > > It takes 30-34 Minutes to Run this Batch Application. > General feeling is - it should be able to process it > within 10-15 Minutes may be less than that. > > I am to look into this problem and give a solution to it. > > Steps I had followed as > > 1. Import the payroll user to another Oracle User in the same > database. > > 2. Removed unnecessary Index , Put parallelism into few >tables by Alter table tab1 Parallel(DEGREE 5) > > 3. Analyze the tables with compute statistics; > > 4. Run the payroll without checking any inefficient SQL or >wrong programming logic in the those Packages( It has only >two Package in it no other stand alone Procedure or function). > > Payroll under this new Oracle User runs in 22-24 Minutes, 6-9 Minutes > less. So, I asked Payroll Person to remove those unnecessary Index, > asked him to put parallelism into those tables which I had done. > He runs the Payroll with no Improvement at all. I asked again to > drop those table and recreate it with new storage parameter same > as the one created at New User. Still no visible Improvement. > > At this stage every table in both user has same storage parameter,same > index ,and also analyzed. The question is why in One User > it runs in 22-24 Min and in another 30-34 Min ? > > Now Please advice me what do I check or to do, so that the it time > takes > to run comes down to 22-24 Min, same as the new user. > > Oracle 8.1.4 > Optimize goal : choose > Biggest table haiving record less than 6 rows. > > Thanks in Advance > > Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ftp
Roland, Are we not in just a little bit over our heads here? You don't say what you environment(s) is (are) but in UNIX, there are a couple of ways to do this. They depend on the security you have set up on each system and whether or not the source system has Oracle installed. I'm guessing PERL isn't an option here. If you actually have to go get the file, then you'll need to execute a shell script (you might also be able to use the oragetfile function). It may be more advantageous to have the source system ftp the file to the target (again, a shell script either on the source or the target will probably be required). If you just need to read the file, you can use the UTL_FILE package. In any case, you might have to set permissions, change initialization parameters, create database links, create synonyms, create users (both O/S an/or Oracle), and allow host access before any solution will be possible. Why don't you get a logon to OTN ( http://otn.oracle.com/index.html ) and do some research They also have some dandy examples. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: > > How can I write a PL/SQL procedur that connects to a ftp server and then gets a >file from the unixsystem? > Give an example, please. > > Roland Sköldblom > > -- > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
Sinardy, I don't know if you've got access to Metalink, so why don't you go to the following URL: http://otn.oracle.com/index.html If you click on the membership link at the top right portion of the page, follow the instructions to sign up. It's free, they've never spammed me, and I haven't received any junk mail as a result of giving them the minimal information they request. Once you've signed up, there is a whole host of information and free stuff available, including ALL the documentation we've been talking about here. Hope this helps. David A. Barbour Oracle DBA, OCP Sinardy Xing wrote: > > Hi All, > > Thank you Rachel, David, Christopher and all DBAs and SAs > > May I know where to find documents that explain all those stuff with some > information how managed them > I tried ora816 document, but no much info there. It only tells the > description, I also read my initSID.ora. > > Thank you for your time > > Sinardy > > -Original Message- > Carmichael > Sent: Tuesday, 24 April 2001 9:21 PM > To: Multiple recipients of list ORACLE-L > > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > t
Re: set dml_lock value without bouncing db?
What was your exact error? Guang Mei wrote: > > Is this possible? Our 8.0.5 Oracle db (on Sun box) is 7x24. I got error > saying Maximum number of DML exceeded. I tried > > alter system set dml_lock = 300 > > but it did not work. > > TIA > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Guang Mei > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener.log
Okay, you moved the old one. Perhaps you haven't had any activity that would cause an entry to be generated for the log? Or have you changed any of the parameters in your listener.ora file? Regards, David A. Barbour Oracle DBA > Nguyen Thanh-truc wrote: > > Hello everyone, > > After moving the listener.log and compressed, there is no more log for > the listener. Could anyone help me please ? Thanks. > > Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Awfully annoying SQLLDR problem
Tom, Just cogitating and ruminating... You mentioned that you're executing the load as part of a larger procedure. Couldn't you execute a shell script that would ftp the file to the target server and run sqlldr via rsh -c? Another thought would be to have the target file on an NFS-mounted drive that could be accessed by the target and have sqlldr kicked off on the target via a trigger on a simple insert by the source into a DATA_LOAD_REQUIRED table on the target? Regards, David A. Barbour Oracle DBA [EMAIL PROTECTED] wrote: > > Thank you ever-so-much to Tim, Kirk, Peter, and especially Kirti for your > intelligent responses. I'm going to open a TAR on Metalink. I'll probably get > the quick and easy response "We don't support it anymore". I'm no fan of Oracle > but would not blame them for giving me that response. > > We will have upgraded our source database to 8.1.6.2 by mid July. Perhaps my > project will have to wait till then. > > thanks again, > > ..tom > > > -Original Message- > > From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, April 23, 2001 3:08 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Awfully annoying SQLLDR problem > > > > The missing verb is "think", as in "I don't think you can avoid...". > > > > >>> [EMAIL PROTECTED] 04/23/01 02:46PM >>> > > I don't you *can* avoid the larger issue. Oracle 8 has undergone some radical > > changes underneath the covers. I would expect SQLLDR to have changed just as > > radically... > > > > >>> [EMAIL PROTECTED] 04/23/01 02:06PM >>> > > No you are reading correctly. I have the data on a server with a 7.3.2.3 > > database and am using that databases' binary sqlldr to load into the 8.1.5 > > database. The problem is a timing issue. I need to execute the load from the > > 7.3.2.3 server as part of a larger script. I cannot ensure that the load will > > be executed i a timely manner if it is run on the distant server. > > > > Whether or not you agree with the timing issue I describe, I'd really > > appreciate > > an answer to the Oracle problem. I don't want to get into the larger issue of > > why I have to run it from one server vs. another. From an Oracle POV it > > should > > work either way. > > > > thanks, > > > > ..tom > > > > > > > > > -Original Message- > > > From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, April 23, 2001 12:27 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject:RE: Awfully annoying SQLLDR problem > > > > > > Ok,maybe i am lazy or a poor reader, but are you > > > using 732 sqlldr binaries to load an 815 db? > > > > > > Why not the 815 sqlldr binaries? > > > > > > I mean, it sounds like you have to ship data over the > > > wire no matter what you do, so...why not use the latest > > > version of the sqlldr bits? > > > > > > > > > > > > <==> -Original Message- > > > <==> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > <==> Sent: Monday, April 23, 2001 11:10 AM > > > <==> To: Multiple recipients of list ORACLE-L > > > <==> Subject: Awfully annoying SQLLDR problem > > > <==> > > > <==> > > > <==> I am executing a SQLLDR shell file from a server :: > > > <==> sourceserv; RDBMS 7.3.2.3 > > > <==> AIX 4.3.2 > > > <==> into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3 > > > <==> using a SQL*Net connect string destserv_destSID. > > > <==> > > > <==> This connect string is defined in the local tnsnames.ora > > > <==> and works. I confirmed > > > <==> this by doing sqlplus user/pass@destserv_destSID and > > > <==> verifying that I am > > > <==> connected to the correct instance. > > > <==> > > > <==> The target table exists. I am connecting as the owner > > > <==> of the target table. That > > > <==> owner has DBA. > > > <==> > > > <==> but when I run > > > <==> > > > <==> sqlldr userid=tabowner/pass@destserv_destSID > > > <==> CONTROL=localcontrolfile.ctl > > > <==> (controlfile is below) > > > <==> > > >
MTS and Cost Based Analyzer
Why would you be looking to change/implement something if you're not aware of the advantages/disadvantages? Changing to the cost based optimizer requires that both the DBA(s) and the Developer(s) understand how and why it works. Although a simple change to your init.ora file (yet another reference to that pesky animal) will enable cost based optimization, you'll probably need to set up some maintenance tasks (table/schema/database analysis comes to mind) and review slow running SQL to see how the change has affected some of your queries. There are additional initialization parameters you may or may not want to set in connection with the change. MTS is enable through another initialization parameter (I'd go to OTN and print out the doc on Initialization Parameters and become VERY familiar with it). There are however numerous other considerations, including client configuration and setup of your listener. Again, go to OTN and check out the docs. Regards, David A. Barbour Oracle DBA > Venkat_Kalepalli wrote: > > Hello folks! > > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement > MTS on the Oracle server. Next we are running with Rule based > optimizer and we want to change to costbased optimizer. > > I want to know what are the advantages we get on this and what are the > steps to implement this? > > Any help is grateful... > > Rgd > Venkat > DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MTS&Cost based Optimzer
If you have the time and horsepower, analyze the database. If not, wait until somebody complains and run a trace/tkprof against their SQL. You may want to consider using histograms on selected tables. There was a discussion on using histograms earlier this month. Steve Adams wrote a script to help in identifying possible candidates for histogram creation. It's on his web site at: http://www.ixora.com.au/scripts/query_opt.htm#consider_histogram Be judicious with its use. In general, I've found it useful to consider running an analysis of large tables used frequently in the select and where clauses of SQL statements. Regards, David A. Barbour Oracle DBA Deepender Kr Gupta wrote: > > How would you decide that out of total big and small tables (say 1500) these > are the tables need to be analysed and these are not, as in our case > Transaction types are both OLTP and DSS ?? > > -Original Message- > Carmichael > Sent: Tuesday, April 24, 2001 6:46 PM > To: Multiple recipients of list ORACLE-L > > turning on cost-based is easy: set the optimizer_mode parameter to choose > in your init.ora, stop and start your database and then analyze all your > tables. > > HOWEVER (and this is a biggie) this will not automatically make all your > queries run faster. You will need to examine each and every query to see if > it needs to be rewritten to take advantage of CBO. In fact, sometimes there > are queries that run faster in rule-based, and I have had to include hints > in queries to force the optimizer to run rule. > > >From: Venkat_Kalepalli <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: MTS&Cost based Optimzer > >Date: Tue, 24 Apr 2001 02:25:25 -0800 > > > > > Hello folks! > > > > > > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS > > > on the Oracle server. Next we are running with Rule based optimizer and > > > we want to change to costbased optimizer. > > > > > > I want to know what are the advantages we get on this and what are the > > > steps to implement this? > > > > > > Any help is grateful... > > > > > > Rgd > > > Venkat > > > DBA. > > > > > > > > > > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deepender Kr Gupta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
Sinardy, Some logs are generated by default (alert_.log) but actions triggering entries can be adjusted through either initialization parameters in the init.ora file, via commands issued by the DBA, or by users who have been granted specific privileges/roles (commands like ALTER DATABASE, ALTER SESSION and the dbms_trace package come to mind here). If you were able to get the doc on OFA, you now need to go and get the docs on Initialization Parameters and Oracle Supplied Packages as a minimum. Regards, David A. Barbour Oracle DBA Sinardy Xing wrote: > > Hi all, > > When those logs will created ? > > Thank you > > Sinardy > > -Original Message- > Sent: Tuesday, 24 April 2001 9:41 AM > To: LazyDBA mailing list > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > > Think you know someone who can answer the above question? Forward it to > them! > to unsubscribe, send a blank email to [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cdump, bdump, udump
Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your init.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where can I find real-life-examples about ORACLE installation
Remedy is a different beast all right. I found out about the schema thing when a PL/SQL function I wrote to retrieve dates (stored in seconds since the epoch) went awry, and the Oracle Discoverer templates I set up for our engineers stopped working. There are a couple tables, ARSCHEMA and I think it's FIELDS that will tell you what the table and field names are. Seagate(Crystal Reports) has an ODBC driver (ugh) that I'm told map these, or you can do what I did which is to create your own view using dynamic SQL. Good Luck. David A. Barbour Oracle DBA Jared Still wrote: > > So, he hasn't told you yet that the schemas are > generated on the fly? > > Jared > > On Friday 20 April 2001 06:00, Lanteigne, Mike wrote: > > Hello all, > > > > Funny you mention Remedy. I've been recently introduced to Remedy here at > > my new job. I was about to refresh our QA database with production data > > when I discovered the schema's were different! I took a look at the two > > schemas and WOW, was that a shock (uglyy). Seems the DEV schema is > > different from QA schema too. Next week I will meet with one the > > consultants that implemented the app here. I hope there is some method to > > the apparent madness (at least mapping between schemas). > > > > Mike Lanteigne > > > > The views expressed here are mine and do not reflect the official position > > of my employer or the organization through which the internet was accessed. > > > > > -Original Message- > > > From: Seley, Linda [SMTP:[EMAIL PROTECTED]] > > > Sent: Friday, April 20, 2001 12:30 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject:RE: Where can I find real-life-examples about ORACLE > > > installation > > > > > > With your 'free time' now would be a good time to work on putting Remedy > > > out > > > of business. ;-) It wouldn't be too hard and you'd be the hero of > > > countless DBAs! > > > > > > Linda > > > (who is very grateful never to have had to deal with AR but sure heard > > > some > > > ugly stories!) > > > > > > -Original Message- > > > Sent: Thursday, April 19, 2001 7:50 PM > > > To: Multiple recipients of list ORACLE-L > > > installations? > > > > > > > > > > > > Comments embedded > > > > > > On Thursday 19 April 2001 15:31, Eric D. Pierce wrote: > > > ... > > > > > > > As far as I know, structured denormalization is considered to be a > > > > method for modification of a normalized design. There should be > > > > disipline/method/rules that try to get the best performance increase > > > > in a trade-off for the least collateral damage (extra coding). > > > > > > > > I get the impression that this is standard operating procedure, > > > > documented in industry journals, and so forth. > > > > > > > > In your experience, what percentage of "real world" dbs are using > > > > pure normalized designs? > > > > > > In my experience, DBA's are scum and developers lobby the managers > > > with tales of how terrible life will be if they're forced to write code > > > for > > > a normalized database. > > > > > > I guess I'm saying that I can't recall starting with a completely > > > normalized > > > > > > database ( just 3rd normal form here ) and then denormalize if we found > > > it necessary for some reason. > > > > > > We've usually have had some denormalization in as soon as we started > > > doing physical modeling. Sigh. > > > > > > If you're familiar with the Help Desk software 'Remedy', you will know > > > that > > > it has one of the worst schemas ever designed by man or beast. If you > > > haven't seen it, you would have a hard time imagining it. Yes, worse > > > than Finanacials, Lawson, SAP, etc. > > > > > > ( 'where is he going with this?' you ask ) > > > > > > One of my fantasies is to build a help desk system that runs on a > > > normalized > > > schema, open source it, and put Remedy out of business. The schema > > > is that bad. > > > > > > > Has this changed as hardware becomes more powerful and cheaper? > > > > > > Hardware, and Oracle has improved in it's ability to join. I assume &
Re: Where can I find real-life-examples about ORACLE installations?
William, Have you tried to figure out Portal? Next to this beast, Remedy looks pretty good. David A. Barbour Oracle DBA "Thater, William" wrote: > > On Thu, 19 Apr 2001,Jared Still scribbled on the wall in glitter crayon: > > ->If you're familiar with the Help Desk software 'Remedy', you will know that > ->it has one of the worst schemas ever designed by man or beast. If you > ->haven't seen it, you would have a hard time imagining it. Yes, worse than > ->Finanacials, Lawson, SAP, etc. > > take a look at MetaSolv's TBS.;-) i'll stack it up against Remedy > anyday. can you say circular references? i knew you could.;-) > > -- > Bill Thater Certifieable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > Another megabytes the dust. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Need Help.
Uday, Your problem may have more than one component. There are three immediate things I'd try/look at, one of which will provide you with information, the other two that may or may not improve your performance. For information on your select statement, start a trace on the session, run the select statement, than analyze the trace file using tkprof with the explain option. If you need specifics on how to do this, check out OTN - http://otn.oracle.com/index.html - search for Explain Plan. This should give you Chapter 13 of the tuning manual, you'll need Chapter 14 as well. I'd also check with your Systems Administrator to see if you're running Veritas Quick I/O. If not, asynchronous I/O is probably not working on your box. There was a big discussion about this last year on the list, and I ended up changing my init.ora file, setting disk_asynch_io = false and using multiple DB Writers. Depending on your box, you may want to use I/O slaves instead (either time responses or use a trace and tkprof to determine which works best in your case.). Also, check to see if your optimizer_mode is set to choose or rule. If choose, analyze your schema/database with compute statistics and see if that doesn't help. You may also want to use hints in your SQL. The cost-based optimizer has a number of other parameters which may help you. You can get these from OTN by searching for Initialization Parameters, reading the summary of what each does, and getting more specific information from the tuning guide. Also get a book(s). I've got a bunch, but I highly recommend Oracle 8 - The Complete Reference by Kevin Looney and George Koch. Not complete, nothing beats experience, but you will get enough information to guide you towards determining possible solutions. If your app is using java, check out Adrian Cockcroft's Sun Performance and Tuning: Java and the Internet. Tuning is fun. Have a blast, and oh - don't forget the old standbys iostat and vmstat. You didn't mention anything about your disk configuration. Or your SGA. There's also some v$ views, v$sysstat, v$waitstat, v$buffer_pool_statistics, v$session_wait and a host of others (is timed_statistics set to true in your init.ora?). So many tools - so little time. Start with the obvious, Explain Plan, Disk I/O and Optimizer to get the biggest bang for your buck, then work your way deeper. Hope this helps. David A. Barbour Oracle DBA udaycb wrote: > > Hi All, > Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now > this database is going online very soon. When we were testing we observed > that, the application (select statement) is running very slow. (I don't know > how fast it was earlier). I have a feeling that it is not using indexes > properly. I have created 6 indexes on that table on each columns. also > created a composite indexes. How do I know that the sql is using which index > for select statement.? Is there any other ways to improve the performance? > > Thanks > Uday > > > Name: winmail.dat >winmail.datType: ABC DataAnalyzer 1.1 Chart >(application/x-unknown-content-type-ABCData) > Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Do not belive BUSH and your "army" goverment so much
Okay Robert, you've had you 15 minutes of fame. Too bad it made you look so silly. Jared, humor was banished (although it tends to flourish with tongue-in-cheek replies), how about political diatribes (or at least the political diatriber - is that a word?)? Regards, David A. Barbour Oracle DBA Robert Chen wrote: > > right now, I understand US people also just belive TV or news. The news > always controlled by goverment or service for the goverment. This fact is > for sure that US is high-handed and arbitrary. US army fly to all over the > world and control all the world. I hate this but I feel so frustrated that > US army is No.1 in this world and all over the world can not even say a "NO" > to US. > Right now, I know many US people do not understand Chinese, Chinese do love > peace very much. Many things, these days, China are better than US now. You > should go and have a look in China. Do not be so stupid and arbitrary. Do > not belive BUSH and your army goverment so much. When the army is so good, > they want to invade China or some other coutries. I hate China does not have > good people rights. But I hate US is so impolite when they know they will > win on every army fight. > What I have forcasted are becoming true now. When BUSH was selected as > president. I forcasted he would make many bad things and use his army. > Today I forcast he will invade China more and put all Chinese in extreme > misery. He will because he is the people who care too much about army...He > do not care about high-tech, you are losing your good salary now...You have > lose you stock options. > Just one more fact, yesterday I watched the TV, the announcer used > intimidatory voice that made very unhappy, "fuck you", I growl to the TV. > Just because you have the No.1 army so you can do all the things? Sorry for > this post because it is not about ORACLE. If US and China finish the > relationship, at least 10% more of you will lose your job. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, April 16, 2001 1:20 PM > > > They ought to learn flying their bikes from ET.. leave fighter plane > flying > > to others.. > > > > -Kirti > > > -Original Message- > > > From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, April 16, 2001 2:40 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: stupid DBA > > > > > > Well, according to the stereotype, they aren't very good > > > drivers, so maybe it was inevitable. > > > ep > > > > > > > > > > > >>> [EMAIL PROTECTED] 04/14 6:15 PM >>> > > > > How was it mean? Considering how well they seem to do their job, it > > > would be > > > > a heck of a lot easier to become a Chinese fighter pilot than a nurse. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: crontab script problem
Rajesh, Instead of running the .profile for the oracle user, you might try invoking the oracle user. I don't think you're seeing the $ORACLE_HOME. Try something like: su - oracle "-c sqlplus -s"< > Hi All, > > I am facing some problem while running sqlplus > scripts from crontab. Env is Tru64 Unix 4.0f and > Oracle 7.2.3. > Through crontab all system commands run fine, > but when I try to invoke sqlplus, it gives following > error: > > /oracle/test1.sh: -o: bad option(s) > > Also I have executed .profile of Oracle user > in the beginning of command. The commands written > in /oracle/test1.sh is as follows, > > . /oracle/product/723/.profile > sqlplus -s system/manager @/oracle/test2.sql > > Any help/suggestion would be greatly appreciated. > > TIA, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell script to send mail
Viraj, As I remember, your initial query mentioned you were trying to send a message from an AIX box. First check to see if sendmail is running on your system. Execute the command ps -ef |grep sendmail . You should receive a response that includes a line like the following: root 3900 2084 0 Mar 24 - 0:01 sendmail: accepting connections If you don't, then your system isn't going to send any mail, because it isn't configured. If it's running, check your /etc/sendmail.cf file. This may be the cause of your problem. Remember, if you make any changes to this file, you must recompile it and issue the refresh -s sendmail command before it becomes effective. Your problem may also lie in the /etc/aliases file. This also needs to be recompiled and the refresh command issued if changed. There is a little bit of work required in setting up sendmail on any UNIX system - not just AIX - but these are three good places to look for problems to begin with. I suggest you get a copy of O'Reilly's Sendmail if you're going to be using mail from UNIX boxes on a regular basis. Assuming your sendmail is running, AIX uses the commands mail, Mail, and mailx interchangeably. I just use mail (cause I hate to type extra characters). Make sure you're executing the mail command from the directory containing the msg file, otherwise you'll need a fully qualified path. Try using single quotes instead of double quotes around your subject. To see if your box is sending mail at all try: mail -s 'Test' myusername@myunixhostname > Hello, > > This is the second time I am writing this message, dont know what happened where the >last message went. > > Basically wanted to thank every one who ever responded, with this easy construct in >the shell. > > But the problem, is that I sent like this, > > mailx -s "from the sco box" [EMAIL PROTECTED] < msg > > where msg is a regular file and contains the string - > this is a test only > > But I have waited for a long time and it did not appear in the above address. > > Any ideas why it did not reach. I have looked at the man for mailx, and I have >already checked the various files, like dead.letter etc. but of no use, it simply >does not exist. > > Please help. > > Regards, > > Raja > -- > > On Tue, 10 Apr 2001 09:15:40 > SHAIBAL TALUKDER wrote: > > > >Raja, > > > >If you have unix mail utility you can send mail form unix. At the system prompt >type - > > > >mailx -s "Subject" [EMAIL PROTECTED] < msg > > > >hope this helps. > > > >Shaibal > > > > Viraj Luthra <[EMAIL PROTECTED]> wrote: > >Paul, > > > >I dont need that software. I need the code to write in my software itself. > > > >rgds, > > > >raja > >-- > > > >On Mon, 09 Apr 2001 21:10:52 > >Paul Drake wrote: > >>check out tripwire ... http://sourceforge.net/projects/tripwire/ > >> > >>Viraj Luthra wrote: > >>> > >>> Hello all, > >>> > >>> I need help. I need to write a shell script (aix box), when ever some loads a >piece of software. > >>> > >>> thanks > >>> > >>> raja > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: Paul Drake > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >>San Diego, California -- Public Internet access / Mailing Lists > >> > > > > > > > >- > >Do You Yahoo!? > >Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. > > Get 250 color business cards for FREE! at Lycos Mail > http://mail.lycos.com/freemail/vistaprint_index.html > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 repository
Pierre, Have you looked into CVS(Concurrent Versioning System)? CVS allows concurrent editing of sources by several users working on releases built from a hierarchical set of directories. It works great and when set up properly, can make your life (and that of your system administrator) a whole lot easier by allowing developers to refresh their source code with previous versions. All stored procedures and packages can be loaded by the DBA into production (after testing) from the source repository. It's pretty easy to set up and use. Check out this link for more info: http://www.cvshome.org/ Regards, David A. Barbour Oracle DBA [EMAIL PROTECTED] wrote: > > I would be grateful if you can advise me if there are other products than > Oracle Designer 6i which is able to build automatically a version control > baseline and track the changes at the packages and stored procedure level. > > My goal is to have in place a control version program which could be used not > by programmers, but the people from Internal Control dept which will track the > changes at the level of database level. > > Thanks in advance, > Pierre > > -- > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recovery from noarchive db corrected
Sinardy Xing wrote: > > The developer application running huge batch inserting data into database, > that is what they told me, if you are me what you will do? Sinardy, You definitely want to turn archiving on. Without it, your recovery options are limited to the last offline backup of the database. If you do an offline backup of the development DB every night, then the most that would be lost is one day's worth of development. Depending on how and where the developers write and store their code, the least that would be lost is one day's worth of transactions in the development DB. Beyond that however, is the fact that you are a developer in a sense as well. Tuning databases to avoid the kind of contention the developers are worried about is part of what you do for a living. If the developer's fears are correct, and archiving causes their database to respond poorly, what will happen when their code goes into an archived production database? There are many parameters you can alter and steps you can take to reduce, minimize, or eliminate this type of contention. Combinations of things like adding redo logs, increasing the size of the log buffer, altering checkpoints, looking at v$latch and making appropriate adjustments to log_small_entry_max_size or log_simultaneous_copies are just a few of the options available to you as the DBA. Examining the code processing the batch is another. Tuning is like detective work, and is probably my favorite part of being a DBA. Start with one of the tuning manuals off OTN, then pick up (and read) Steve Adam's "Oracle 8i Internal Services" from O'Reilly. You'll be a better DBA, and who knows, you might even be able to teach the developers a trick or two. Good Luck. David A. Barbour Oracle DBA > > -Original Message- > Testa > Sent: Friday, 6 April 2001 11:55 AM > To: Multiple recipients of list ORACLE-L > > assuming you're the dba, since when does the developer dictate > recoverability to a DBA about a database. > > sounds like a role problem there. > > joe > > Sinardy Xing wrote: > > > > Our Developer prefer the archive off, I can't change that anymore :( > > > > -Original Message- > > Sent: Thursday, 5 April 2001 8:54 PM > > To: LazyDBA mailing list > > > > Turn archiving on. > > > > > -Original Message- > > > From: Sinardy Xing [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, April 05, 2001 4:57 AM > > > To: LazyDBA mailing list > > > Subject: Recovery from noarchive db corrected > > > > > > > > > Hi, > > > > > > My database is noarchive mode, what should I do to prevent > > > from lossing any > > > transactions ? > > > Like for example incresed the REDO buffer to ... (daily buffer)? > > > Will this decrese the performance ? > > > any technique to share ? > > > > > > Sinardy > > > > > > > > > Think you know someone who can answer the above question? > > > Forward it to them! > > > to unsubscribe, send a blank email to > > > [EMAIL PROTECTED] > > > to subscribe send a blank email to [EMAIL PROTECTED] > > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > Tell yer mates about http://www.farAwayJobs.com > > > > > > > > > > > > Think you know someone who can answer the above question? Forward it to > > them! > > to unsubscribe, send a blank email to [EMAIL PROTECTED] > > to subscribe send a blank email to [EMAIL PROTECTED] > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > Tell yer mates about http://www.farAwayJobs.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sinardy 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). > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask
Re: Unable to open the database,Urgent!!!
Saroj, It appears you do not have enough semaphores available to bring up both instances. What flavor of UNIX are you operating on? David A. Barbour Oracle DBA "Dash, Saroj (CAP,CEF)" wrote: > > Hi, > > In a Unix Machine I want to create two instance on a single server.Its > memory size is 1GB. > > I am trying to up one instance it is opening well .While Creating other > instance I am getting this error. > > ORA-07279: spcre: semget error, unable to get first semaphore set. > SVR4 Error: 28: No space left on device > Additional information: 25 > Additional information: 2 > > But I tred to shutdown the first database and open the second one ,the > second one open well and Viceversa. > > But WhenTrying to open both the database it gives the above error. > > Please tell me what i wil do. > > Previously the SGA size was 15MB. > > The new one I tried to 6Mb ,then eror gives. > > Thne next method I tried SGA is 6Mb for 1st database and second is 2Mb.thne > still error > > Tell me what I will do. > > Saroj. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dash, Saroj (CAP,CEF) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Max # of Open Files for UTL_FILE in 7.3.4.3
Waleed, That is an answer. Opening and closing the files might be an option. Unfortunately, I have to work within the environment I was given. The application from which I'm extracting the data is poorly designed. Space and memory are a problem, and the table containing the master records is heavily chained and contains 27 million rows. Sorts, orders and groups are not an option. Thanks. David A. Barbour Oracle DBA "Khedr, Waleed" wrote: > > I'm not answering the question but suggesting sorting your data on that date > column and opening, writing to, and closing a file for every unique value > for this date column. > > -Original Message- > Sent: Tuesday, April 03, 2001 7:01 PM > To: Multiple recipients of list ORACLE-L > > Greetings, > > Had an situation today in 7.3.4.3 running on AIX v4.2. I was extracting > data to several different files based on the date record using > UTL_FILE. I found I couldn't have more than 10 files open at any given > time. I know the default in 8i is 50 files, but I looked on OTN and > couldn't find either the default number of files (has to be 10) or any > way to change it for 7.3x. > > Does anyone know if it can be increased and how? > > Thanks, > > David A. Barbour > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David A. Barbour > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Max # of Open Files for UTL_FILE in 7.3.4.3
Greetings, Had an situation today in 7.3.4.3 running on AIX v4.2. I was extracting data to several different files based on the date record using UTL_FILE. I found I couldn't have more than 10 files open at any given time. I know the default in 8i is 50 files, but I looked on OTN and couldn't find either the default number of files (has to be 10) or any way to change it for 7.3x. Does anyone know if it can be increased and how? Thanks, David A. Barbour Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 help - Another approach
Chaim, Along these lines, can't you disable the not null constraint, load the data, update the table/columns (UPDATE MY_TABLE SET THIS_COLUMN = 0 WHERE THIS COLUMN IS NULL) then re-enable the constraints? David Ron Rogers wrote: > > Chaim, > If on the other hand the BLANK will not work properly on a numeric filed that is to >be used in calculations. In that case you might want to have a 0(zero) loaded rather >than a null,blank. Then you could use the NVL clause in your controll statement where >the field type is numeric. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 03/30/01 02:00PM >>> > Chaim, > > Check out the sqlldr case studies on OTN. Ross has the right idea with > the NULLIF. Here's a general description from OTN: > > Loading All-Blank Fields > > Totally blank fields for numeric or DATE fields cause the record to be > rejected. To load one of these fields as null, use the NULLIF clause > with the BLANKS keyword, as described in Comparing Fields to BLANKS. > Case 6: Loading Using the Direct Path Load Method provides examples of > how to load all-blank fields as null with the NULLIF clause. > > If an all-blank CHAR field is surrounded by enclosure delimiters, then > the blanks within the enclosures are loaded. Otherwise, the field is > loaded as null. More details on whitespace are presented in Trimming > Blanks and Tabs and in Preserving Whitespace. > > Hope this helps. > > David A. Barbour > Oracle DBA, OCP > [EMAIL PROTECTED] wrote: > > > > Maybe some could help me. > > I'm having trouble trying to load a csv file with sqlldr. The destination table > > has char columns defined as not null and the csv file has missing data for these > > columns. (These columns will contain blanks in the database). > > > > Sqlldr wants to set the missing fields to null, which results in record > > rejected errors. Is there a way around this. I would be happy if I could insert > > blanks or insert any other marker-value into the field like '***'.. > > The input file lines looks something like (011101,1,31460) > > Thanks > > Chaim > > > > -- > > 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: David A. Barbour > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 help
Chaim, Check out the sqlldr case studies on OTN. Ross has the right idea with the NULLIF. Here's a general description from OTN: Loading All-Blank Fields Totally blank fields for numeric or DATE fields cause the record to be rejected. To load one of these fields as null, use the NULLIF clause with the BLANKS keyword, as described in Comparing Fields to BLANKS. Case 6: Loading Using the Direct Path Load Method provides examples of how to load all-blank fields as null with the NULLIF clause. If an all-blank CHAR field is surrounded by enclosure delimiters, then the blanks within the enclosures are loaded. Otherwise, the field is loaded as null. More details on whitespace are presented in Trimming Blanks and Tabs and in Preserving Whitespace. Hope this helps. David A. Barbour Oracle DBA, OCP [EMAIL PROTECTED] wrote: > > Maybe some could help me. > I'm having trouble trying to load a csv file with sqlldr. The destination table > has char columns defined as not null and the csv file has missing data for these > columns. (These columns will contain blanks in the database). > > Sqlldr wants to set the missing fields to null, which results in record > rejected errors. Is there a way around this. I would be happy if I could insert > blanks or insert any other marker-value into the field like '***'.. > The input file lines looks something like (011101,1,31460) > Thanks > Chaim > > -- > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Concatenate rows
Hi Wendy, Here's an example from a PL/SQL procedure: inputFromDate := startMonth||'/'||startDay||'/'||startYear; The '/' is a delimiter, if you don't want one just use: inputFromDate := startMonth||startDay||startYear; The individual data elements in this case were user input on a web browser, but the same syntax applies if the elements had been selected from tables. Hope this helps. David A. Barbour Oracle DBA, OCP Wendy Y wrote: > > Hello: > > Is there a way that we can Concatenate several rows (say 6 rows from a > select statement) into one variable? > > Thanks > > Wendy > > -- > Do You Yahoo!? > Yahoo! Mail Personal Address - Get email at your own domain with > Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Crontab - Ooops
Charlie, Some days are like that. You're right. Mike Hand had the right idea when he wrote: .. 2 choices are MM HH 22-28 * * (shell script checks for Sunday before proceeding) OR MM HH * * 0 (shell script checks for day of month between 22 and 28 before proceeding) Mike Charlie Mengler wrote: > > Just curious. > > Using your algorithm, what happens on those rare months > where there are FIVE sundays? > > "David A. Barbour" wrote: > > > Luc, > > > > One possible solution: > > > > Run the cron every Sunday and have the first part of your shell script > > check to see if that day's date plus seven days falls into another > > month. > > > > Regards, > > > > David A. Barbour > > Oracle DBA > > Formerly with the now defunct and bankrupt ConnectSouth > > > > "DEMANCHE Luc (Cetelem)" wrote: > > > > > > Hi gurus, > > > > > > I want to schedule a script to run on the fourth sunday of the month. > > > > > > How can I do that ? > > > > > > TIA > > > > > > - > > > Luc Demanche > > > CETELEM > > > Tél.: 01-46-39-14-49 > > > Fax : 01-46-39-59-88 > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: David A. Barbour > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Crontab
Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if that day's date plus seven days falls into another month. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "DEMANCHE Luc (Cetelem)" wrote: > > Hi gurus, > > I want to schedule a script to run on the fourth sunday of the month. > > How can I do that ? > > TIA > > - > Luc Demanche > CETELEM > Tél.: 01-46-39-14-49 > Fax : 01-46-39-59-88 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Insert without telling column names
Hi all -
I stand (sit?) before you with egg on my face. I KNOW you can insert
without naming column names if you're filling the entire row, I just
didn't consider that this might be what Roland was attempting to
accomplish. As Regina and Jacques both pointed out, if your package,
procedure or script is to be reused, it's probably best not to assume
the table structure you think will be there actually is there.
With humble apologies,
David A. Barbour
Oracle DBA
Formerly with the now defunct and bankrupt ConnectSouth
William Beilstein wrote:
>
> You are misinformed. If you have a table of the form
>
> col1varchar2(1)
> col2 number
> col3 date
>
> You can insert into it with the insert statement
> INSERT INTO MYTABLE VALUES('X',23,SYSDATE);
>
> As long as ALL the columns are included in the values clause in the order they were
>created in the table, you don't have to define the column names.
>
> >>> [EMAIL PROTECTED] 03/20/01 11:36AM >>>
> Roland,
>
> You can't. There are a number of ways to really cut down on the code
> required to do an insert, but if you think about it, how will Oracle
> know where the data is supposed to go if you don't give it the column
> name(at some point)?
>
> If you're using 8i, there is a direct load insert, but as far as I'm
> aware, this will work only for a select * from another table.
>
> Dynamic SQL works pretty well for this kind of stuff. What are you
> trying to do?
>
> Regards,
>
> David A. Barbour
> Oracle DBA
> Formerly with the now defunct and bankrupt ConnectSouth
>
> [EMAIL PROTECTED] wrote:
> >
> > Hallo,
> >
> > How can I create an insert statement without telling all the names of the columns?
> > Give an example, please.
> >
> > Roland Sköldblom
> >
> > --
> > 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: David A. Barbour
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: William Beilstein
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: David A. Barbour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DBMS_OUTPUT.PUT_LINE
Roland - Depending on how your inserts are being generated, why don't you use a counter or the ROWCOUNT function? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "Bunyamin K.Karadeniz" wrote: > >I looked at the documentation and could not see a function giving that . > But you can declare a variable and increase it after each insert ( if you > do the inserts in a loop , it is good). Then > dbms_output.put_line(variable_name); > Bunyamin > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, March 20, 2001 3:50 PM > > Hello, > > Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command > if I want to display the numbers of inserts done in that script? > Would appreciate it very much if anyone could help.. > > Roland Sköldblom > > -- > 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: Bunyamin K.Karadeniz > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Insert without telling column names
Roland, You can't. There are a number of ways to really cut down on the code required to do an insert, but if you think about it, how will Oracle know where the data is supposed to go if you don't give it the column name(at some point)? If you're using 8i, there is a direct load insert, but as far as I'm aware, this will work only for a select * from another table. Dynamic SQL works pretty well for this kind of stuff. What are you trying to do? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth [EMAIL PROTECTED] wrote: > > Hallo, > > How can I create an insert statement without telling all the names of the columns? > Give an example, please. > > Roland Sköldblom > > -- > 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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Is there anything called session specific tables
Tapas, As previously mentioned here, what you're looking for is a global temporary table. I used this quite successfully for a web facing sales reporting system that had some rather complex reports everybody seemed to want first thing in the the morning. The really neat thing about these tables is that when the session ended, the data retrieved was not just deleted, it was truncated, thereby reclaiming the used space. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth tapas dutta wrote: > > Hello Listers, > > I am facing a typical problem. In one of my D2K appliaction > I need to first populate the data in a particular itermediate > table and then run the reporting job. The data population > has been done in the report trigger. But the problem is if > at the same time another user fires the same report, the > data population becomes erroneous as he is also > sharing the same table. > > Is there any concept of session specific tables. > > Please help. > Regards, > > Tapas > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: tapas dutta > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Need Help For Installing Oracle On AIX
Neena, If I understand correctly, you have a server with the OS on it, and the DB on a set of external drives - right? Cable the external drives to the working server, reboot, and import the volume groups. Your database should be right there. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth NSC wrote: > > Hi All, > Our application is based on the twodatabases ( on two diff. servers , os > AIX). One of these server is down since > yesterday because of some hardware (motherboard) problem.Finding out the exact >problem and solution will take time. AMC person might > give a replacement server till that time. >We have five harddisks for this server . All are intact. OS is on the hard >disk which is attached to the server. Oracle > software and the database files harddisks are external harddisks in a separate >machine. As the server will be replaced to recognize > the new hardware we have to install OS and so Oracle. > Can anyone tell me what are the steps for installing AIX (4.3)and Oracle 7.x on AIX >4.3 ? After installing Oracle how to configure > the exisisting database and bring it up ? > > --Neena > > Terry Ball wrote: > > > We have a support contract with IBM (for server support), and the support costs > > could be deceptive if you don't know how IBM works. The cost is on a per user > > basis. So if you only got one support license, your company would only be allowed > > to have one NAMED person calling in. If anyone else called in, they would not > > get any help. And IBM is vey sticky about answering only the named person(s). > > > > Terry > > > > P.S. Thanks, Dennis. This was a great help. > > > > Dennis Taylor wrote: > > > > > Since the list doesn't allow attachments, I'm just merging in all this as > > > text. It may be messy. sorry. > > > > > > Oh, and these are Canadian prices. U.S. prices will be 50% - 67% of the > > > stated values. > > > > > > My original RFP: > > > > > > = > > > I am looking for quotes on RDBMS products for the following scenarios: > > > > > > Server Platform: > > > 2x750 MHz Intel, running Linux or NT > > > > > > DBMS: > > > Enterprise Edition or equivalent. > > > > > > Scenario 1: > > > 1 server, 1 location, 50 users. > > > > > > Scenario 2: > > > 1 server, 1 location, 400 users. > > > > > > Scenario 3: > > > 5 servers, different locations, with the following user counts: > > > 200 users > > > 100 users > > > 40 users > > > 40 users > > > 20 users > > > > > > Scenario 4: > > > 1 server, serving up data for an internet-based web server. > > > > > > I would also like information on: > > > · Annual maintenance costs > > > · Version upgrade costs and patch availabilities. > > > · Cost of a separate server which will serve up data for an > > > internet-accessible web server. Price for Enterprise and Non-enterprise > > > versions if applicable. > > > · Policies concerning maintaining backup systems, i.e. do we need a > > > separate license for a separate system that is intended only as a failover? > > > · Price of any recommended or required companion software that may not be > > > bundled with the RDBMS. > > > > > > > > > > > > Notes on the results that I got: > > > > > > · All quotes are for "Enterprise Edition" versions of the RDBMS's. > > > "Workgroup" versions are available from all companies, and are considerably > > > less expensive. They typically are limited in the ability to replicate data > > > between servers. In the case of SQLServer, for instance, the 'Standard" > > > edition of SQLServer cannot do clustering and automatic failover. In the > > > case of Oracle, the "Workgroup" edition cannot do automatic replication of > > > data to other databases. There are also system and programming features > > > missing, such as partitioning and function-based indexes in Oracle. > > > · The Enterprise editions of DB2 and SQLServer come in unlimited-user > > > versions only. The Oracle Enterprise edition requires a minimum 50-user > > > purchase at our level, and "tops out" at about 300 users, after which it > > > make more se
Re: problem with UTL_FILE.FILE OPEN
Connor - Fortunately, that requires dba privs which (see previous posts from Rachael, Lisa, et al) your folks don't have. Right? Actually though, you make a good point - there is some risk involved in setting the parameter to *. The files are created/written as the oracle user, so any filesystem oracle can write to is fair game. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth Connor McDonald wrote: > > utl_file_dir = * is VERY bad news... > > for i in ( > select file_name > from dba_data_files ) loop > open file i.file_name for write > end loop; > > and voila...No more db > > --- "Dasko, Dan" <[EMAIL PROTECTED]> wrote: > > Cool, you learn something new everyday. > > > > Dan > > > > -Original Message- > > Sent: Wednesday, March 14, 2001 8:05 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Dan - > > > > I've previously used the * to define utl_file_dir > > with no problems. > > According to the documentation: > > > > "The parameter specification UTL_FILE_DIR = * has a > > special meaning. > > This entry turns off directory access checking, and > > it makes any > > directory accessible to the UTL_FILE functions." > > > > I'm wondering if the directory location in the > > procedure or package is > > entered correctly OR the filename is invalid for the > > operating system. > > I've had that problem when trying to dynamically > > name a file. > > > > Regards, > > > > David A. Barbour > > Oracle Database Administrator > > Formerly with the now defunct and bankrupt > > ConnectSouth > > > > > > "Dasko, Dan" wrote: > > > > > > I thought that a directory had to be specified by > > name in initora. I > > don't > > > think you can specify a wildcard or a higher level > > directory. I could be > > > wrong. > > > > > > Dan > > > > > > -Original Message- > > > Sent: Wednesday, March 14, 2001 5:16 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > List hi! > > > Oracle817 on AIX. (64 bit) > > > We have defined in initora file UTL_FILE_DIR=* > > > When we start function UTL_FILE.FOPEN it raises > > exception INVALID_PATH. > > > Everything is set and available (permissions are > > 777). > > > Do you have any idea what's wrong? > > > > > > TIA, > > > Sonja > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > > (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 message has been scanned for the > > presence of all known > > computer > > > viruses by the MessageLabs Virus Control Center. > > However, it is still > > > recommended that you use local virus scanning > > software to monitor for the > > > presence of viruses. > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Dasko, Dan > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and
Re: problem with UTL_FILE.FILE OPEN
Dan - I've previously used the * to define utl_file_dir with no problems. According to the documentation: "The parameter specification UTL_FILE_DIR = * has a special meaning. This entry turns off directory access checking, and it makes any directory accessible to the UTL_FILE functions." I'm wondering if the directory location in the procedure or package is entered correctly OR the filename is invalid for the operating system. I've had that problem when trying to dynamically name a file. Regards, David A. Barbour Oracle Database Administrator Formerly with the now defunct and bankrupt ConnectSouth "Dasko, Dan" wrote: > > I thought that a directory had to be specified by name in initora. I don't > think you can specify a wildcard or a higher level directory. I could be > wrong. > > Dan > > -Original Message- > Sent: Wednesday, March 14, 2001 5:16 AM > To: Multiple recipients of list ORACLE-L > > List hi! > Oracle817 on AIX. (64 bit) > We have defined in initora file UTL_FILE_DIR=* > When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. > Everything is set and available (permissions are 777). > Do you have any idea what's wrong? > > TIA, > Sonja > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 message has been scanned for the presence of all known computer > viruses by the MessageLabs Virus Control Center. However, it is still > recommended that you use local virus scanning software to monitor for the > presence of viruses. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dasko, Dan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
