RE: [OT] List of Spam Subjects * I'm Looking for an Oracle Financials DBA for Miami,
No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SyncSort - Unix - Datawarehousing.
Hi, Thanks Witold for the info. I have some more Q's. 1. For the Conversion part - I believe you must have used some other tools like - FilePort ( from the SyncSort company). Is it right? 2. Also, the conversion is from Mainframe flat file to Unix Flat file - but not directly in Oracle DB . Right? 3. Last Q, Would I be right in saying that SyncSort replaces/enhances the capability provided by awk in Unix? TIA, Rajaram -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject:RE: SyncSort - Unix - Datawarehousing. Hi I used Syncsort on UNIX few years ago working on a large data conversion project - converting millions of records from mainframe to Oracle database. Syncsort was a great tool and it has number of extra options. We used it to sort files, eliminate duplicate records, merge files, extract certain columns only, etc. And many of the files were over 500 MB, maybe even close to 1GB in size. In my case I mixed Syncsort with C++ programs. Should I ever work on a similar project, syncsort would definitely be part of it - well, I would like it to be part of it... HTH Witold Kevin Lange [EMAIL PROTECTED] on 06/15/2001 09:51:52 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) -Original Message- Hi, I want some informarmation about SyncSort for Unix. If anyone is using sincsort under unix - I need the following details: 1. What is the basic purpose of syncsort? ( I have gone thru www.syncsort.com - So, I dont want this answer). 2. How is sync sort used in data loads or data warehousing? Is there any documentation online? Any whitepapers? TIA, Rajaram -- 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SyncSort - Unix - Datawarehousing.
Hi, I want some informarmation about SyncSort for Unix. If anyone is using sincsort under unix - I need the following details: 1. What is the basic purpose of syncsort? ( I have gone thru www.syncsort.com - So, I dont want this answer). 2. How is sync sort used in data loads or data warehousing? Is there any documentation online? Any whitepapers? TIA, Rajaram NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Digestive
Did you say Bombay? BTW, what is Bombay Sapphire dirty Martini ? -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:03 PM To: Multiple recipients of list ORACLE-L Subject:Re: Digestive How about a Bombay Sapphire dirty Martini, straight up, spicy olives? Yum. Jared On Tuesday 12 June 2001 11:43, Igor Neyman wrote: LOL, May I be more specific: SET ORACLE-L JINTONIC Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 1:46 PM WHY NOT JUST SET ORACLE-L APERITIF? -Original Message- Sent: Tuesday, June 12, 2001 1:27 PM To: Multiple recipients of list ORACLE-L SET ORACLE-L DIGESTIVE = Hamid Alavi 4268 Flintlock LN Westlake Village 91631 PH: 818-8790966 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle on Windows 98
Hi, I have installed Oracle 8.1.5 Personal Edition on Windows 98. It works fine. Trouble came up when I tried to install Oracle Forms 4.5 on the same machine. I was tring to install Oracle Forms to a different home. I think I messed my Oracle Home. The Forms Installation failed and now, I am not able to started my Oracle 8.1.5 which I was fine earlier. I think I have to tweak in to the Registy, but I dont know what to do. I would like some pointers. in this regards I have installed Oracle 8.1.5 to this Directory - C:\Oracle\Ora81 I have also included my registry settings below ( I have included only the relevant portion) ** [HKEY_LOCAL_MACHINE\Software\ORACLE] ORACLE_HOME=C:\\ORAWIN95 SHARED_ORACLE_HOME=c:\\Oracle\\OraForms API=C:\\ORAWIN95\\DBS COMPANY_NAME=Aet ORACLE_GROUP_NAME=Oracle for Windows 95 D2K20_COMPONENTS=Developer 2000 R2.0 Comps D2K20_ADMINISTRATION=Developer 2000 R2.0 Admin D2K20_DEMOS=Developer 2000 R2.0 Demos D2K20_DOCS=Developer 2000 R2.0 Doc D2K20_GROUP=Developer 2000 R2.0 D2K20_DRIVERS=Developer 2000 R2.0 Direct Drivers OPEN2K20_DOCS=Open 2000 R2.0 Documentation NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 [HKEY_LOCAL_MACHINE\Software\ORACLE\Misc_Reg_Entries] [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES] [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE1] inst_loc=C:\\Program Files\\Oracle\\Inventory OO4O=c:\\Oracle\\Ora81\\OO4O\\mesg NAV81=c:\\Oracle\\Ora81\\NAV81 ORACLE_DATABASE_HOME=Software\\ORACLE\\HOME0 ORACLE_HOME=c:\\Oracle\\Ora81 ORACLE_HOME_NAME=OraHome81 API=c:\\Oracle\\Ora81\\dbs ORACLE_GROUP_NAME=Oracle - OraHome81 NLS_LANG=NA [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE1\ALL_HOMES] HOME_COUNTER=1 DEFAULT_HOME=OraHome81 LAST_HOME=0 [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE1\ALL_HOMES\ID0] NAME=OraHome81 PATH=c:\\Oracle\\Ora81 NLS_LANG=NA [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE1\HOME0] ORACLE_GROUP_NAME=Oracle - OraHome81 ORACLE_HOME_NAME=OraHome81 ORACLE_HOME=c:\\Oracle\\Ora81 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ORACLE_HOME_KEY=Software\\ORACLE\\HOME0 MSHELP_TOOLS=c:\\Oracle\\Ora81\\MSHELP SQLPATH=c:\\Oracle\\Ora81\\dbs RDBMS_CONTROL=c:\\Oracle\\Ora81\\DATABASE RDBMS_ARCHIVE=c:\\Oracle\\Ora81\\DATABASE\\ARCHIVE ORACLE_BASE=c:\\Oracle PO8=yes DBA_AUTHORIZATION=oracle ORACLE_SID=ORCL DATABASE_STARTUP=AUTO LISTENER_STARTUP=NOAUTO ORA_ORCL_PFILE=c:\\Oracle\\Ora81\\database\\initorcl.ora [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE1\OO4O] CacheBlocks=20 FetchLimit=100 FetchSize=4096 HelpFile=c:\\Oracle\\Ora81\\MSHELP\\oracleo.hlp PerBlock=16 SliceSize=256 TempFileDirectory=c:\\temp OO4O_HOME=c:\\Oracle\\Ora81\\OO4O [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE2] ORACLE_HOME=C:\\ORAWIN95 SHARED_ORACLE_HOME=c:\\Oracle\\OraForms API=C:\\ORAWIN95\\DBS COMPANY_NAME=Aet ORACLE_GROUP_NAME=Oracle for Windows 95 D2K20_COMPONENTS=Developer 2000 R2.0 Comps D2K20_ADMINISTRATION=Developer 2000 R2.0 Admin D2K20_DEMOS=Developer 2000 R2.0 Demos D2K20_DOCS=Developer 2000 R2.0 Doc D2K20_GROUP=Developer 2000 R2.0 D2K20_DRIVERS=Developer 2000 R2.0 Direct Drivers OPEN2K20_DOCS=Open 2000 R2.0 Documentation NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 [HKEY_LOCAL_MACHINE\Software\ORACLE\ORACLE_HOMES\ORACLE2\Misc_Reg_Entries] * Thanks in A, Rajaram NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: to list administrator
No Wonder, U may be getting one from Lazy Dba list and Other from this List!! Check it out. -Original Message- From: Arslan Bahar [SMTP:[EMAIL PROTECTED]] Sent: Saturday, June 02, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Subject:to list administrator i have been receiving each mail two times -Original Message- Sent: Saturday, June 02, 2001 7:30 PM To: Multiple recipients of list ORACLE-L Hi all! There have been several posts lately regarding how to kill or remove jobs from the job queue once they're running, so here are the steps. Background -- * Removing a job from the job queue, removes it from the queue, but does NOT abort the job if it is currently running (i.e. in DBA_JOBS_RUNNING). * If the job# in dba_jobs_running doesn't exist in dba_jobs, then the job has already been removed from the job queue. * You can only manage your own jobs, even if you're a DBA user. Someone else mentioned using BECOME USER to manage another user's jobs; sounds like a great idea, but I haven't had a chance to try that to see if it works. * Jobs in the job queue are not run by the SNP processes when the db is started up in restricted mode or when JOB_QUEUE_PROCESSES=0, but may be run manually. To kill a currently running job --- 1. First you must break or remove the job in the job queue, otherwise the job will just start right back up again the next time the SNP processes check for jobs to run (based on job_queue_interval). As the job owner: execute dbms_job.broken(job#,true); or execute dbms_job.remove(job#); 2. Kill the SNP process at the OS level. You can identify the process to kill using the SID from DBA_JOBS_RUNNING: select s.sid, p.spid from v$session s, v$process p where s.paddr=p.addr and s.sid=sid; p.spid is the OS process ID 3. As with any session that is killed, it will need to be rolled back and cleaned up. To restart a broken job --- A job will be marked as unbroken the next time it is successfully run or when it is marked as unbroken. As the job owner: execute dbms_job.run(job#); or execute dbms_job.broken(job#,false); Also check out Note 61730.1 Using the DBMS_JOB Package HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Analyze table and locking
I think thats the reason why we have two options - Estimate and Compute Statistics. Rajaram. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 7:22 AM To: Multiple recipients of list ORACLE-L Subject:Analyze table and locking All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Analyze table and locking
Yes, thats true... you need a lock on an object only when you are changing the object. So, analyze table does not have anything to do with locks.. Rajaram. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject:RE: Analyze table and locking Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need a lock? Are you saying I can estimate sample 99 percent, and get what amounts to a compute and avoid the supposed lock? Does that make any sense? No. Validate structure cascade holds a lock. The most the others do is grab some resource [very] briefly at the end to update the dictionary. People claiming that compute holds a lock, please post documentation to support that statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 30 May 2001, Raghu Kota wrote: Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. From: Robertson Lee - lerobe [EMAIL PROTECTED] Anyone know if there are any locking issues while analyzing statistics for objects ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Script and control file
Inside Pl/SQL u cannot use the host command.. HOST is Sql*PLUS command not a SQL. So, u cannot use with in Pl?SQL Rajaram -Original Message- From: William Beilstein [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 12:08 PM To: Multiple recipients of list ORACLE-L Subject:Re: Script and control file see the host command in pl/sql [EMAIL PROTECTED] 05/29/01 11:15AM First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using SQL language. Is it possible do this inside a .sql file ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: MS access
FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: redo copy latch low??
Just pulled up this info from Oracle Docs Well, If you could give some inputs as to the performance issues that u r facing bacause of this - it would be useful. Also, what type of application are u running? Here is the info: * Reducing Contention for Redo Copy Latches On multiple-CPU computers, multiple redo copy latches allow multiple processes to copy entries to the redo log buffer concurrently. The default value of LOG_SIMULTANEOUS_COPIES is the number of CPUs available to your Oracle instance. If you observe contention for redo copy latches, add more latches by increasing the value of LOG_SIMULTANEOUS_COPIES. It can help to have up to twice as many redo copy latches as CPUs available to your Oracle instance. ** Rajaram. -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Subject:redo copy latch low?? Hi Friends My redo copy latch showing 16.7% (Hit Ratio). How can I increase this one?? Any suggestions?? I got this from utlb/utle stats. 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bad SQL.....
Remember - Drink responsibly - Kidding.
Raj.
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Bad SQL.
Thank you very much. I was thinking that I needed to do a nested select.
It worked great. I'll have a beer for you after I leave work! :)
Dave
-Original Message-
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
I think it's just Friday. You need to rewrite your statement to read
something like this:
UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt
to_date('31-DEC-2049','DD-MON-') )
At 09:01 AM 5/25/01 -0800, you wrote:
I am trying to write an update statement but seem to be having problems.
Below is my statement and the error in SQL*Plus.
1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
2WHERE available_power.driver_id = manpowerprofile.mpp_id
3*and manpowerprofile.mpp_terminationdt
TO_DATE('31-DEC-2049','DD-MON-')
SQL /
and manpowerprofile.mpp_terminationdt
TO_DATE('31-DEC-2049','DD-MON-')
*
ERROR at line 3:
ORA-00904: invalid column name
I know that manpowerprofile.mpp_terminationdt is a valid table column. Do
I
need to do some type of join on these two tables? Or is it just Friday and
I should give up and go have a cold beer!!:o) Any advice would be
appreciated.
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajaram
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
FW: Transient Delivery Failure
Someone please do something about this... This stupid southampton address
keep coming to my mail box... I hope its happening the same with the other
listers
Will anyone look at it and remove it?
Rajaram
(PS: the Failed message follows)
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 5:41 PM
To: [EMAIL PROTECTED]
Subject:Transient Delivery Failure
The attached message had transient non-fatal delivery errors
THIS IS A WARNING MESSAGE ONLY - YOU DO NOT NEED TO RESEND YOUR MESSAGE!
This server is configured to automatically retry delivery at configured
intervals. Subsequent attempts to deliver this message are pending.
--- Partial Session Transcript ---
Host [sccemail] resolved to [172.21.4.74]
Waiting for socket connection...
30 second wait for connect timeout exceeded.
This message is 61 minutes old; it has 0 minutes left in this queue
Primary queue lifetime exceeded; message placed in retry queue
--- End Transcript ---
: Message contains [1] file attachments
-Original Message-
From: Rajaram [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Bad SQL.
Remember - Drink responsibly - Kidding.
Raj.
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Bad SQL.
Thank you very much. I was thinking that I needed to do a nested select.
It worked great. I'll have a beer for you after I leave work! :)
Dave
-Original Message-
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
I think it's just Friday. You need to rewrite your statement to read
something like this:
UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt
to_date('31-DEC-2049','DD-MON-') )
At 09:01 AM 5/25/01 -0800, you wrote:
I am trying to write an update statement but seem to be having problems.
Below is my statement and the error in SQL*Plus.
1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
2WHERE available_power.driver_id = manpowerprofile.mpp_id
3*and manpowerprofile.mpp_terminationdt
TO_DATE('31-DEC-2049','DD-MON-')
SQL /
and manpowerprofile.mpp_terminationdt
TO_DATE('31-DEC-2049','DD-MON-')
*
ERROR at line 3:
ORA-00904: invalid column name
I know that manpowerprofile.mpp_terminationdt is a valid table column. Do
I
need to do some type of join on these two tables? Or is it just Friday
and
I should give up and go have a cold beer!!:o) Any advice would be
appreciated.
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http
RE: sum of file size ????
You will get the summary data in the first line of its output ( ls -l ). The number returned is in terms of OS blocks. Rajaram. -Original Message- From: Andrea Oracle [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Subject:sum of file size Hi, OK, as you know, I don't know too much about Unix: When you do a ls -l and see the individual file size, is there a command to show the sum of all the file size? Thank you! 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: job offer from SAUDI ARABIA
Just as a coin has two side, every thing has two sides - I'd say - good and bad. What you are is determined by your behaviour Your behaviour is determinied by your surroundings - be it parents , friends or foes. Similarly, what a nation is determined by its ruler and its neighbours. So, It largely depends on our attitude - how we take it. As, one poet says - Our attitude determines our altitude in life So, to sum it up - if you are going to make a living from Saudi - then you have to trust them and befriend them and respect them - and you will get respected.. I can keep writing like this on and on - but I think I'll stop here.. Bye now, Rajaram. -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 8:06 PM To: Multiple recipients of list ORACLE-L Subject:RE: job offer from SAUDI ARABIA reality check. Consider the poignant implications of the recent anniversary of the Oklahoma city terrorism. The simple fact is that a very high percentage of professional women that have jobs like real estate sales requiring isolated contact with strangers *are* armed (as you state, many with boutique designer guns). it is because they have been assaulted or threatened, or are close to women that have told vivid stories of such. Employees at this campus are required to take *mandatory* campus violence workshops now. Last year a professor was severly beaten by some petty thieves after leaving a night class about 2 minutes walk from my office. Several years ago, someone held an admission counselor hostage at gun point in the building I work in. The person was upset that they weren't admitted to the university. regards, ep (unarmed, but unrepentantly politically incorrect) On 17 May 2001, at 13:16, Marianne Brooks wrote: Date sent: Thu, 17 May 2001 13:16:06 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SET MODE SILLY ON Damn, I *knew* I forgot to buy something on my last shopping trip to Nordstroms! Note to self: - buy gun I didn't know I needed. Remember to purchase extras for friends who don't have them either(the gift that keeps on taking?) ... -- 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Export Split Script
If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject:Export Split Script I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Export Split Script
1. Create a Pipe , say usr1.pipe. A pipe is a FIFO structure. /bin/rm /dsk1/usr1.pipe /bin/mknod /dsk1.usr1.pipe p ( See your version of UNIX - mknod differs in its usage - i mean the syntax - some strains require that u mention -p ) 2. Let compress listen at one end of the pipe. cat /dsk1/usr1.pipe |compress /dsk9/usr1.dmp.Z In the above step while making compress listen to one end of the pipe - you are also sending its output to a different file. So, compress captures data at one end of the pipe and as and when it encounters data it compresses it and sends it to an output file. Make sure to run it in background. 3. Now do an export - in place of the export dump file mention the pipe. By doing this exp will be putting data at one end of the pipe ( and compress will be taking data at the other end) exp / file=/dsk1/usr1.pipe buffer=64000 2 usr1.log While importing, In a similar fashion, let uncompress listen at one end while imp TAKES data at the other end. Rajaram The value of an idea lies in the using of it. - Thomas Edison -Original Message- From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:04 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject:RE: Export Split Script Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the table level just to keep our files less than 2GB. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: Export Split Script I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: How to make DBA cannot 'see' User's Tables?
If its a stored procedure i know that you can use a oracle tool called warp ( or wrap?) to encrypt the code. Its a comand line utility. Rajaram. -Original Message- From: Ahmadsyah Algozhi Nugroho [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Subject:How to make DBA cannot 'see' User's Tables? Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 File: ATT2.html NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mean/Median
I did a procedure for median some time back. Here is the algorithm that I used. 1. Define a Cursor - Dont forget to use the Order by Column while defining. Ofcourse, U should order by the column on which you need median. 2. Get a count of records that cursor would return ( Regarding How to get a count - U have to define a similar cursor with the same where clause but one that returns count ). Or, simply do a select count into variable. 3. Supposing N is the number of records that the cursor would return, 4. If N is Odd, Then (N/2)+1 th record is the the median record 5. If N is even, then the average of the (N/2) th record and (N/2)+1 the record is the median value of the set. 6. Now Loop thru the cursor until you encounter (N/2)+1 th record and then calculate the median as determined in the steps 4 and 5. May be I goofed up somewhere - But I am sure my code worked - I checked it against a statistical package ( Cornerstone) generated median. Correct me if I am wrong. Rajaram. -Original Message- From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:27 PM To: Multiple recipients of list ORACLE-L Subject:RE: Mean/Median Well, no, it doesn't work at all. The definition of Median is a value where half your list of values is above, and half is below. If the values all tend toward the mininum or the maximum, this equation would be way out of line. [EMAIL PROTECTED] 05/15/01 01:35PM Oops, this only works for *even* numbers of samplesgeez || -Original Message- || From: Mohan, Ross || Sent: Tuesday, May 15, 2001 12:28 PM || To: '[EMAIL PROTECTED]' || Subject: RE: Mean/Median || || || geez louise, || || Median := avg(Max,Min) || || || -Original Message- || || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || || Sent: Monday, May 14, 2001 10:56 PM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: Mean/Median || || || || || || || || || || Any scripts (sql or pl/sql) out there to compute various || || statistical things || || in Oracle? || || || || || || Would depend on just what you are looking for. A quick look at || || Oracle's SQL functions showed avg, st. deviation, and variance || || although no median but that should be easier to write than || || some of the || || others. || || || ||Pat || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Pat Hildebrand || || INET: [EMAIL PROTECTED] || || || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || To REMOVE yourself from this mailing list, send an E-Mail message || || to: [EMAIL PROTECTED] (note EXACT spelling of || 'ListGuru') and in || || the message BODY, include a line containing: UNSUB ORACLE-L || || (or the name of mailing list you want to be removed || from). You may || || also send the HELP command for other information (like || subscribing). || || || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
RE: cdump, bdump, udump
1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one method of free space checking - Using du, bdf, sam or sysadmin tools. -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Subject:RE: cdump, bdump, udump Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry Rao, Maheswara wrote: Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log file size is 500 MB size and then you delete the alert.log, still you would not be able to get a disk free space of 500 MB. This space would be released once you bounce the database. The above scenario is similar even if you copy alert.log to a different location and then delete the rows. The above scenario applies to Solaris environment. I do not know what happens in NT environment. Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR ma?am [EMAIL PROTECTED] 04/24/01 09:21AM 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 ? NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Look like this message did not get thru.. sending again. Pl. Ignore if repeat 1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one method of free space checking - Using du, bdf, sam or sysadmin tools. -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Subject:RE: cdump, bdump, udump Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry Rao, Maheswara wrote: Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log file size is 500 MB size and then you delete the alert.log, still you would not be able to get a disk free space of 500 MB. This space would be released once you bounce the database. The above scenario is similar even if you copy alert.log to a different location and then delete the rows. The above scenario applies to Solaris environment. I do not know what happens in NT environment. Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR ma?am [EMAIL PROTECTED] 04/24/01 09:21AM 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 ? NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mean/Median - Another method
Another way to compute median is here: 1. You should know that there is a linear relationship between Mean, Median and Mode. Find that relationship. 2. Find the mean of the data. Its nothing but the average. 3. Next you have find the mode. Mode is nothing but the most frequent data. suppose, sal is the column for which you want to find the median, then proceed like this - select sal, count(*) Number_of_people from emp group by sal order by 2 Desc; Now the first record returned by the above query represents the mode. Caputure the sal from this first record and call it as mode. 4. Now, Using the relationship u determined in step 1, calculate the median values by substituting the mode and mean values. PS: I know this is going to work is salary is an interger field. But I doubt it if its a real number. Listers,letme know if I am wrong. Also, I did not watch earlier mails on this topic,. so, pardon me if its a repeat. Rajaram. -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Mean/Median HELP Are you stupid? -- 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NOLOGGING/LOGGING
There was similar Q from Vikas@innoventry a few days back You cannot turn off logging. Reason: Search through your mails dated 3 days back. Rajaram. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject:NOLOGGING/LOGGING I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Turning off redo logging
When you are doing a DIRECT LOAD INSERT, I know of a way to disable logging. First what is a Direct LOad Insert, An Insert stmt is said to be a Direct-Load insert when the INSERT INTO SELECT command is used. This option is not available when INSERT INTO VALUES command is used. So, to disable logging during a Direct load insert, do the following: INSERT /*+APPEND */ INTO scott.emp NOLOGGING SELECT * FROM scott.old_emp; 1. The Append Hint above makes the insert a Direct load insert. 2. You can use no logging with direct load insert. U can also Use ALTER TABLE tblname NOLOGGING But, even then, you have to use DIRECT LOADING for nologging to take effect. If anyone knows ways to disable logging Correct me if I am wrong. Rajaram. -Original Message- From: Vikas Kawatra [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 6:40 PM To: Multiple recipients of list ORACLE-L Subject:Turning off redo logging If I use NOLOGGING as part of a CREATE TABLE or INDEX - it means that I don't want the creation of these objects logged. However , say I want to turn off the logging for conventional Inserts - through transactions - how can I do that ? vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LSNRCTL Password
If password protection is being used, you must set the password before you can issue the STOP command. When using passwords for the listener, you cannot issue the STOP command at the operating system level because the password can only be set within the lsnctrl utility. There are two types of password mechanisms in lsnctrl. 1. Unencrypted and 2. U guessed it right - Encrypted. Here is some theory: In the listener.ora file add this line: PASSWORDS_PRODUCTION_LISTENER = (password1, password2) U can add as many passwords as u like. U can use any one of them to control the listened. Now, a word about the encrypted passwords: At the prompt LSNRCTL CHANGE_PASSWORD This will prompt you to enter a new password. Now, You have an encrypted password. TO STOP THE LISTENER, U HAVE TO MANUALLY ENTER OR TYPE IN THE PASSWORD IF YOU ARE USING ENCRYPTED PASSWORD. However, if u are using an unencrypted password, then just creat a script file to contain these lines: set password password1 ( I am not sure of this syntax - check this one) stop listener --- and at the OS level, u can just say lsnctrl @Script_File Correct me if I am wrong. Rajaram. -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 6:46 PM To: Multiple recipients of list ORACLE-L Subject:LSNRCTL Password Can anyone tell me what the syntax is to start, stop, or reload the listener when there is a password on it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inserts slowing down on OLTP systems
Hi, Can u elaborate? What does the statement Inserts slow down by 100% from levels 15 days ago? mean. I did not understand especially the levels part of it. Also, mention as to how you are doing the inserts. Are the inserts done as select * from another_table? or Using SQLLOADER? or Pro*C or anyother? I want these details 'Cos - Each method of loading data has its own optimization technique. Rajaram. -Original Message- From: Vikas Kawatra [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 07, 2001 8:55 PM To: Multiple recipients of list ORACLE-L Subject:Inserts slowing down on OLTP systems Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
