RE: RAID or NOT to RAID? What's the diff???
Guy Harrison - Oracle SQL High Performance Tuning Jonathan Lewis - Practical Oracle 8i and at the moment - Couchman and Schwinn - Oracle 8i DBA Certification Exam Guide. Regards Lee -Original Message- Sent: 14 August 2001 18:07 To: Multiple recipients of list ORACLE-L On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote: and very nice they are too. Great book by the way. Hmmm, so what would folks consider their essential Oracle books? maybe your personal top 2 or 3? -s -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Armijo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Speed up Truncate tables
Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAID or NOT to RAID? What's the diff???
Oh yes, and when I save up some money after buying the Certification book, I should be purchasing DBA 101, can't remember who wrote that one though :-) Lee -Original Message- Sent: 15 August 2001 08:50 To: Multiple recipients of list ORACLE-L Guy Harrison - Oracle SQL High Performance Tuning Jonathan Lewis - Practical Oracle 8i and at the moment - Couchman and Schwinn - Oracle 8i DBA Certification Exam Guide. Regards Lee -Original Message- Sent: 14 August 2001 18:07 To: Multiple recipients of list ORACLE-L On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote: and very nice they are too. Great book by the way. Hmmm, so what would folks consider their essential Oracle books? maybe your personal top 2 or 3? -s -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Armijo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman/standby
Title: RE: rman/standby Ravindra, Two thoughts 1) Why not copy the archivelogs as they are created by setting the log_archive_dest_1 parameter in your init.ora. This will make 2 copies of the archivelog file, the 2nd one of which can be either be local or to the remote server. 2) In RMAN is it not possible to put a host command in your script prior to the 2nd backup command.This host command can then unix cp the files to an alternate directory or FTP as appropriate John -Original Message- From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]] Sent: 15 August 01 02:41 To: Multiple recipients of list ORACLE-L Subject: rman/standby I have configured a standby database operating in manual mode for our production database. I will have to apply the archive logs manually for the standby database. The Archive logs that are genarated on the production server is backed up by RMAN/netbackup and deleted after the backup.I have the stopped the deletion of archive files from the RMAN script. I want to find the best way of getting both RMAN/netbackup to happen and also delete the archive logs.But before they are deleted they need to be copied to a seperate directory so that I can apply those backed up files to the standby database.I want to make sure that I don't loose any of the archive files that the standby database needs to be in sync with the production database inclucing the current archive logs that may be backed up on the production database. The rman script is like this run { allocate channel t1 type 'SBT_TAPE'; backup incremental level 1 tag Dialy_Incremental_Backup_Level1 filesperset 5 format 'Data_%d_%s_%p_%t' (database); sql 'alter system archive log current'; backup filesperset 20 format 'Arch_%d_%s_%p_%t' # (archivelog all delete input); (archivelog all); } How do I do it.? Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Speed up Truncate tables
Title: RE: Speed up Truncate tables Chuan, Are you sure you were using the TRUNCATE TABLE command rather than DELETE It sounds as if you are running a delete, especially if the HWM was not shrunk John -Original Message- From: Chuan Zhang [mailto:[EMAIL PROTECTED]] Sent: 15 August 01 09:10 To: Multiple recipients of list ORACLE-L Subject: Speed up Truncate tables Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Splitting a database: pro and cons
Title: RE: Splitting a database: pro and cons Quick thoughts Downside Resource overhead of another instance (system temp tablespace memory etc) Support requirements Conectivity between the 2 instances via db_links although if theye are on the same server network traffic is negated Upside Upgrade paths can be different which is especially important when different vendors are involved Service Level Agreements are easier to manage No performance impact from one application on the other as far as Oracle is concerned (still need to monitor O/S) Backup strategy - hot cold, archivelog etc can be different as necessary Tuning can be more specific for each vendor app especially instance wide from the init.ora parameter I am sure there are lots more John -Original Message- From: Djordje Jankovic [mailto:[EMAIL PROTECTED]] Sent: 14 August 01 23:52 To: Multiple recipients of list ORACLE-L Subject: Splitting a database: pro and cons Hi list, I have two applications running against one database (in fact I have a few but for the sake of this question two are enough). The two apps have different upgrade patterns and I would like to split them in two databases that will be on the same unix server. There are some views that are used extensively that join data from both apps/schemas, and after the split those should be made using db links. I did some tests and comparisons of queries going through links versus running them directly on the database, and did not see a lot of difference. Does anybody see or know of any downside in splitting the database in two :-(. And any advantage :-). What is the general strategy when installing different apps (from different vendors) - put them on separate databases or combining them. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
An SQL question , not easy ;-)
Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Consider there are 4 calls , one started at 12:10 and ended at 12:40 second started at 12:15 and ended at 12:30 third started at 12:25 and ended at 12:55. fourth started at 12:45 and ended at 12:47. So the first 3 calls are simultanious , for example they overlap at 12:28 , i.e. there are 3 pairs of persons having phone conversation at 12:28. The third and fourth calls are simultanious at 12:46 ,i.e. there are 2 pairs of persons having phone conversation at 12:46. So , i need the maximum number of concurrent phone conversations in my table. Thanks a lot !!! Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: I admit this is dumb. NT/W2K Services?
Title: I admit this is dumb. NT/W2K Services? Hi Lisa, Yes, I agree it can be confusing. The service is a background process that provides an environment for Oracle to execute in - I don't know about the specifics in this case, but Oracle on Unix is comprised of two logical parts, the VOS and Oracle itself. You don't see this because its all started from a single binary. Oracle's own engineering is split into two groups, VOS, or "virtual operating system" who maintain a version of VOS for each operating system Oracle supports, and the Oracle database itself, which uses the VOS API rather than the underlying Unix (or whatever) APIs. So, things that are the same on all Oracle platforms, like say the SQL parser, are actually the same code, making calls to VOS, and VOS is different on every platform. So if Oracle want to support a new OS, they simply develop a version of VOS for it, then use it to recompile the main codebase - and the people working on their core products never need to worry about operating systems and can concentrate on "pure" algorithms and functionality. I assume that the service (for example, OracleServiceTEST on my workstation) is VOS for NT. When you start the service, set ORACLE_SID then connect / as sysdba and type "startup", I guess what you are doing is invoking the platform-independent parts of Oracle's code, compiled for VOS on Intel. Cheers, g -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 6:22 PMTo: Multiple recipients of list ORACLE-LSubject: I admit this is dumb. NT/W2K Services? I'm playing with Oracle on w2k out of sheer boredom. So now I'm forced to learn a little bit about w2k. I was looking at oradim and it has starttype and shuttype with options srvc and inst. OK, I understand the instance part. But what on earth are services? Below is what the help says about it. So to translate this into Unix-speak, is this similar to a daemon? I guess I'm confused because as far as I know there's nothing additional that needs to be running on Unix to just start up a database. If that's the case, then why would you want to shut down an instance and not services? For RMAN? I guess I'm at a loss here. Can someone give me an example of when you'd want to do this? Plus, there's notes on Metalink about recreating services. Why/when would you want to do that? Here's the overly-generic definition I found. A program, routine, or process that performs a specific system function to support other programs, particularly at a low (close to the hardware) level. When services are provided over a network, they can be published in Active Directory, facilitating service-centric administration and usage. Some examples of Windows2000 services are Security Accounts Manager service, File Replication Service, and Routing and Remote Access Service. Any descriptions or web sites that can describe this would be appreciated. Lisa Koivu Oracle Database Administrator and Self-Professed W2K Idiot. Fairfield Resorts, Inc. 954-935-4117
RE: An SQL question , not easy ;-)
Quick and dirty solution: Pick a time and look for all calls which started before that time and ended after that time. That will tell you how many calls were in progress at that time. Repeat this at, say, half hour intervals, and graph the results. This will show you a trend. Where it looks like a peak, try narrowing the band of time you are looking at. Alternatively, use curve fitting to find a peak value. g -Original Message- Sent: Wednesday, August 15, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FW: An SQL question , not easy ;-)
Give me some time :-))) Jan Pruner Dne st 15. srpen 2001 12:40 jste napsal(a): Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Consider there are 4 calls , one started at 12:10 and ended at 12:40 second started at 12:15 and ended at 12:30 third started at 12:25 and ended at 12:55. fourth started at 12:45 and ended at 12:47. So the first 3 calls are simultanious , for example they overlap at 12:28 , i.e. there are 3 pairs of persons having phone conversation at 12:28. The third and fourth calls are simultanious at 12:46 ,i.e. there are 2 pairs of persons having phone conversation at 12:46. So , i need the maximum number of concurrent phone conversations in my table. Thanks a lot !!! Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Locally Managed Tablespaces and autoextend
Quick follow up to the bitmap sizing for larger files: I've quoted this 20-30,000 figure in my book as applying to both 'ordinary' LMTs and 'temporary' LMTs. However following our discussions, and a conversation with Ken Robinson from Oracle, I've run a couple of tests on 8.1.7 and the 2-bytes per extent that led to me quoting these figures applies only to temporary LMTs. In an ordinary LMT, one bit equates to one extent, so for an 8K block size, which gives you 6 blocks (64K - 2 blocks) in the first bitmap you could build ca. 380,000 extents in a single file before adding more bitmap at the end; for a very small file with its special one-block bitmap, you could still at about 63,500 extents without a new chunk of bitmap appearing. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html | Earlier experiments indicated that for very | large files, with small extents, so that the | total extent count exceeded about 20,000 - | 30,000 (related to block size and therefore | number of blocks actually available from the | 64K for bitmap) - an extra 64K space would | be pre-allocated at the head of file. I did not | test for further extremes - if you have small | extents you should not have very large files. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Performance analysis (enqueue and buffer busy waits)
Ignore (or at least treat very lightly) the comments about DBWm. Excessive database writes can cause log file sync waits, as dbwr calls lgwr to write the log protecting the blocks it is about to write. In this case, you will see v$session_event for the db writers showing log file waits. Unfortunately I have a mental block that makes me explain this phenomenon 100% the wrong way round every 6 months or so. And that is what I did last night. I suspect you are also going to tell me that the anomalous difference between CPU and elapsed time on the one big update is because everything else is done by triggers, and the update is waiting for triggers to complete ;( 4GB of redo log in 50 minutes is quite a lot. Unless I've done the arithmetic wrong, that's close to 1.4MB per second (or 2.8 since you are using Oracle duplexing). It seems a little odd that you are getting 'log file sync' as a problem without getting (in your case) 'log buffer space' and 'log file ... write'. What is your average log file write size ? (redo blocks written / redo writes). and what do you other 'redo%' stats look like over the period ? How many CPUs ? Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FW: An SQL question , not easy ;-)
1. Create table CC with 2 fields: DT DATE, CALL_COUNT NUMBER . 2. Fill table CC with tuples with DT started from MIN(CALL_START) up to MAX(CALL_END) and CALL_COUNT = 0. Step of DT value is 1 minute (or second = 36mil tuples/year). 3. for every tuple in a table of phone calls update table CC and set CALL_COUNT = CALL_COUNT + 1 WHERE DATE = CALL_START AND DATE = CALL_END . 4. select max(call_count) from CC. It's very lazy :-))), but you will get right number. Jan Pruner Dne st 15. srpen 2001 12:40 jste napsal(a): Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
Pursuing Guy's method in a non-procedural way: select ts.timestamp, count(*) from ( select to_date('1-jan-2001','dd-mon-') + (rownum / 1440) timestamp from short_narrow_table_of_numbers where rownum = 1440 )ts, phone_calls where ts.timestamp between pc.start_date and pc.end_date and pc.start_date between to_date('1-jan-2001','dd-mon-') and to_date('2-jan-2001','dd-mon-') group by ts.timestamp ; Adjust constants to suit precision and resources. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 15 August 2001 11:42 Quick and dirty solution: Pick a time and look for all calls which started before that time and ended after that time. That will tell you how many calls were in progress at that time. Repeat this at, say, half hour intervals, and graph the results. This will show you a trend. Where it looks like a peak, try narrowing the band of time you are looking at. Alternatively, use curve fitting to find a peak value. g -Original Message- Sent: Wednesday, August 15, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
Thanks Guy ! The problem is that i need it in one non-interactive PL/SQL block . Thanks a lot !! -Original Message- Sent: Wednesday, August 15, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Quick and dirty solution: Pick a time and look for all calls which started before that time and ended after that time. That will tell you how many calls were in progress at that time. Repeat this at, say, half hour intervals, and graph the results. This will show you a trend. Where it looks like a peak, try narrowing the band of time you are looking at. Alternatively, use curve fitting to find a peak value. g -Original Message- Sent: Wednesday, August 15, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datafile Migration Tool
Like the block editor Oracle used to make available ? BDE or something like that? DUL tool would be cool, too. Especially, if it handled the odd-ball cases like LMTs and IOTs. I would only use DUL on production if it was total S.O.L. and there was nothing left (besides READING won't make the muck worse). However, I would love to play with something like these on my sandbox area. Babette -Original Message- Gopalakrishnan Sent: Tuesday, August 14, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Kirti, Frankly speaking , (as of now) I have to support the database and I don't think Oracle will support. But if you have luxury..you can always reorgaze the database and oracle HAS to suport the database. Initially I can give this tool for learning oracle and playing with oracle databases, I can pack this tool with a custom block editor where you can edit the databases, and an unloader tool (like DUL) which gives you the data in text format from the data files. But I don;t think Oracle will support any of these tools. :( --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Gopal, So who do we call if there is a problem in the converted datafile later down the road and the database is down? The Tool Supplier or Oracle Support? Thanks. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
How about: - declare l_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count ) end loop; end; Haven't tried it, but it looks feasible. HTH David Lord -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 11:21 To: Multiple recipients of list ORACLE-L Subject: An SQL question , not easy ;-) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
mambar for Oracle by luminate
Anybody using Mamba without the luminate.net service. Opinions of it. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Speed up Truncate tables
Check the extent sizes... truncate can take a VERY long time if there are a very large number of extents. At one point we had a large table with approximately 60,000 extents (accidentally created with INITIAL/NEXT 80k MAXEXTENTS UNLIMITED), which took about 2.5 hours to truncate. After recreating it sane extent sizes, it now takes only a few seconds. -Original Message- From: chuan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 3:10 AM To: ORACLE-L Cc: chuan Subject: Speed up Truncate tables Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT -- Dilbert on 2-day classes that teach everything
http://www.dilbert.com/comics/dilbert/archive/dilbert-20010723.html Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph: (902) 426-4774 -Original Message- From: Guy Hammond [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject:RE: I admit this is dumb. NT/W2K Services? Hi Lisa, Yes, I agree it can be confusing. The service is a background process that provides an environment for Oracle to execute in - I don't know about the specifics in this case, but Oracle on Unix is comprised of two logical parts, the VOS and Oracle itself. You don't see this because its all started from a single binary. Oracle's own engineering is split into two groups, VOS, or virtual operating system who maintain a version of VOS for each operating system Oracle supports, and the Oracle database itself, which uses the VOS API rather than the underlying Unix (or whatever) APIs. So, things that are the same on all Oracle platforms, like say the SQL parser, are actually the same code, making calls to VOS, and VOS is different on every platform. So if Oracle want to support a new OS, they simply develop a version of VOS for it, then use it to recompile the main codebase - and the people working on their core products never need to worry about operating systems and can concentrate on pure algorithms and functionality. I assume that the service (for example, OracleServiceTEST on my workstation) is VOS for NT. When you start the service, set ORACLE_SID then connect / as sysdba and type startup, I guess what you are doing is invoking the platform-independent parts of Oracle's code, compiled for VOS on Intel. Cheers, g -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 6:22 PM To: Multiple recipients of list ORACLE-L Subject: I admit this is dumb. NT/W2K Services? I'm playing with Oracle on w2k out of sheer boredom. So now I'm forced to learn a little bit about w2k. I was looking at oradim and it has starttype and shuttype with options srvc and inst. OK, I understand the instance part. But what on earth are services? Below is what the help says about it. So to translate this into Unix-speak, is this similar to a daemon? I guess I'm confused because as far as I know there's nothing additional that needs to be running on Unix to just start up a database. If that's the case, then why would you want to shut down an instance and not services? For RMAN? I guess I'm at a loss here. Can someone give me an example of when you'd want to do this? Plus, there's notes on Metalink about recreating services. Why/when would you want to do that? Here's the overly-generic definition I found. A program, routine, or process that performs a specific system function to support other programs, particularly at a low (close to the hardware) level. When services are provided over a network, they can be published in Active Directory, facilitating service-centric administration and usage. Some examples of Windows 2000 services are Security Accounts Manager service, File Replication Service, and Routing and Remote Access Service. Any descriptions or web sites that can describe this would be appreciated. Lisa Koivu Oracle Database Administrator and Self-Professed W2K Idiot. Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -Original Message- Sent: 15 August 2001 14:11 To: Multiple recipients of list ORACLE-L How about: - declare l_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count ) end loop; end; Haven't tried it, but it looks feasible. HTH David Lord -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 11:21 To: Multiple recipients of list ORACLE-L Subject: An SQL question , not easy ;-) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Locally Managed Tablespaces and autoextend
Thanks for investigating and sharing this with us - Babette -Original Message- Lewis Sent: Wednesday, August 15, 2001 7:16 AM To: Multiple recipients of list ORACLE-L Quick follow up to the bitmap sizing for larger files: I've quoted this 20-30,000 figure in my book as applying to both 'ordinary' LMTs and 'temporary' LMTs. However following our discussions, and a conversation with Ken Robinson from Oracle, I've run a couple of tests on 8.1.7 and the 2-bytes per extent that led to me quoting these figures applies only to temporary LMTs. In an ordinary LMT, one bit equates to one extent, so for an 8K block size, which gives you 6 blocks (64K - 2 blocks) in the first bitmap you could build ca. 380,000 extents in a single file before adding more bitmap at the end; for a very small file with its special one-block bitmap, you could still at about 63,500 extents without a new chunk of bitmap appearing. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html | Earlier experiments indicated that for very | large files, with small extents, so that the | total extent count exceeded about 20,000 - | 30,000 (related to block size and therefore | number of blocks actually available from the | 64K for bitmap) - an extra 64K space would | be pre-allocated at the head of file. I did not | test for further extremes - if you have small | extents you should not have very large files. [snipped] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NYOUG
Rachel Carmichael wrote: wish we could... we are not setup to record the presentations. One of these years, when we become a rich users group (or is that an oxymoron?) Hey, I'm lucky I can persuade people to give me the slides and papers... there are a few people on this list who still owe me one or the other or both of those (You know who you are, don't make me send the cats out after you!) Rachel no no, not the cats!;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. Manual Writer's Creed: Garbage in, gospel out. -- 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).
RE: How can I get my DB back if I lost one of my rollback segment
When you restored, did you restore the control files etc... EVERYTHING from the cold backup? It should not have been looking at the new file at all if you added it after the backup. Now... rewrite your cold backup script to read the names of the datafiles, logfiles and controlfiles to be backed up from a file. In the script, before you shutdown the database, do a spool to a file of this select statement (this is the file you will read in the script to tell you the names of the files to backup). select name from v$datafile union select member from v$logfile union select name from v$controlfile / this will give you the name of all the datafiles, controlfiles and logfiles that you will need to backup in your cold backup script. And you will never have to worry about forgetting to add in a new file name because you will be getting the accurate information from the database always From: Hermanto P [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How can I get my DB back if I lost one of my rollback segment Date: Tue, 14 Aug 2001 19:30:20 -0800 Thanks Rachel, What I meant is, actually I do the cold backup. I do it by the script. Before the backup processing/running, I made a new rollback segment which I miss to add the name into the script. So, when I do the backup, this rollback did not recorded. Further, I experimenting with other thing in application. Since I got the problem, I want to restore the old backup. But after I restore, I can not startup Oracle DB successfully. svrmgrl SVRMGRconnect internal Connected to an idle instance SVRMGRstartup; ORACLE instance started. Total System Global Area 17950752 bytes Fixed Size 38987 bytes Variable Size 111845589 bytes Database Buffers65764666 bytes Redo Buffers 1564323 bytes Database mounted. ORA-01122 : database file 14 failed verification check ORA-01110 : data file 14: '/data_dev/cybprod/rbs02.dbf' ORA-01207: file is more recent than control file - old control file Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 491147 / 491354 HP: 0812-752-3092 Dream as if you'll live forever, live as if you'll die today -Original Message- Sent: Tuesday, August 14, 2001 08:41 PM To: Multiple recipients of list ORACLE-L segment (rb Hermanto, some more information would be helpful -- why are you restoring? are you restoring from a cold or hot backup? if it was from a cold backup, you can comment out the rollback_segments parameter in the init.ora and start the database. Then I would drop the rollback tablespace and recreate it, with the rollback segments you want. Then change the init.ora and shutdown and restart the database Rachel From: Hermanto P [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How can I get my DB back if I lost one of my rollback segment (rb Date: Tue, 14 Aug 2001 00:35:21 -0800 Hi gurus, Recently, I have forgotten to backup one of rollback segment file (rbs02.dbf). When I want to restore..the db can not startup normally. Anyone can give me advise.. Thanks in advance. Warm regards, Hermanto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/intl.asp -- 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: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: Datafile Migration Tool
Hi, Oracle'e block editor is called BBED and it will be in your $ORACLE_HOME/bin. DUL will not be in standard oracle instalations and it is a support tool. --- Babette Turner-Underwood [EMAIL PROTECTED] wrote: Like the block editor Oracle used to make available ? BDE or something like that? DUL tool would be cool, too. Especially, if it handled the odd-ball cases like LMTs and IOTs. I would only use DUL on production if it was total S.O.L. and there was nothing left (besides READING won't make the muck worse). However, I would love to play with something like these on my sandbox area. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN cold backups continued
living on the bleeding edge are we?, let me try it on my 9.0.1 and let you know. joe [EMAIL PROTECTED] 08/15/01 10:07AM Thanks to everyone who replied yesterday. It appears I had already been onthe right track, as I did attempt backups with the database in noarchivelogmode and mounted but not open.Hot backups, with DB in archivelog mode, worked fine. However, coldbackups, performed in the manner stated above, fail (see below) with errorsmentioning "database keyword" and "character set". This is Oracle 9.0.1 onSolaris. I'll appreciate any ideas; thanks! Paul BaumgartelMortgageSight Holdings, LLC[EMAIL PROTECTED]RMAN shutdown immediate2 startup mount3 run {4 allocate channel t1 type disk;5 backup incremental level 06 format '/dbbackup/%d/t%t_s%s_p%p'7 database8 ;9 release channel t1;10 }11 exitdatabase closeddatabase dismountedOracle instance shut downconnected to target database (not started)Oracle instance starteddatabase mountedTotal System Global Area 235701300 bytesFixed Size 279604 bytesVariable Size 167772160 bytesDatabase Buffers 67108864 bytesRedo Buffers 540672 bytesusing target database controlfile instead of recovery catalogallocated channel: t1channel t1: sid=10 devtype=DISKStarting backup at 15-AUG-01released channel: t1RMAN-00571: ===RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===RMAN-00571: ===RMAN-00579: the following error occurred at 08/15/2001 08:57:33RMAN-03002: failure during compilation of commandRMAN-03013: command type: backupRMAN-06003: ORACLE error from target database: ORA-06550: line 1, column166:PLS-00553: character set name is not recognizedORA-06550: line 0, column 0:PL/SQL: Compilation unit analysis terminatedRMAN-06031: could not translate database keywordRecovery Manager complete.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Paul Baumgartel INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: An SQL question , not easy ;-)
Note that whenever a call starts, this increases the current number of calls by 1, and whenever a call ends, this decreases the current number of calls by 1. Hence you can uncouple the start and end times - you don't need to know that a given start time and a given end time belong to the same call! (Think about it - it's a bit counterintuitive, but it's true!). So: SELECT CALL_START_DATE eventtime, 'start' eventtype FROM calltable UNION ALL SELECT CALL_END_DATE eventtime, 'end' eventtype FROM calltable ORDER BY 1 Then you set a current number of calls variable to zero, and move the cursor through the results, adding 1 to the variable for each 'start' and subtracting 1 for each 'end'. Whenever you add 1, if the current number of calls is higher than its highest value so far, store the new highest value so far. When you've finished, this latter variable will contain the maximum number of simultaneous conversations. Hope this helps. Paul Paul Vincent Database Administrator, University of Central England -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 11:21 To: Multiple recipients of list ORACLE-L Subject: An SQL question , not easy ;-) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
I'm working on this one, almost got a solution... ;-) Kev. -Original Message- Sent: 15 August 2001 14:05 To: Multiple recipients of list ORACLE-L Thanks Guy ! The problem is that i need it in one non-interactive PL/SQL block . Thanks a lot !! -Original Message- Sent: Wednesday, August 15, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Quick and dirty solution: Pick a time and look for all calls which started before that time and ended after that time. That will tell you how many calls were in progress at that time. Repeat this at, say, half hour intervals, and graph the results. This will show you a trend. Where it looks like a peak, try narrowing the band of time you are looking at. Alternatively, use curve fitting to find a peak value. g -Original Message- Sent: Wednesday, August 15, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lost of all Control Files
Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: An SQL question , not easy ;-)
Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:mambar for Oracle by luminate
Yes, it's pretty good although it does take quite a punch out of the server running it. What I really like is that it provides a deep look into the database for non-dba types without allowing them to do anything harmful to the database. I was somewhat surprised when I spent a little time teaching key folks what they were really seeing how some performance problems disappeared almost overnight. Once they saw what they were doing tuning their applications took on a new and very bright light. Dick Goulet PS: If your doing PeopleSoft it's almost indispensable. Reply Separator Author: Jeffrey Beckstrom [EMAIL PROTECTED] Date: 8/15/2001 5:05 AM Anybody using Mamba without the luminate.net service. Opinions of it. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4616.200 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Courier New; MARGIN-LEFT: 2px DIVAnybody using Mamba without the luminate.net service.nbsp; Opinions of it./DIV DIVnbsp;/DIV DIVJeffrey BeckstromBRDatabase AdministratorBRGreater Cleveland Regional Transit AuthorityBR1240 W. 6th StreetBRCleveland, Ohio 44113BR(216) 781-4204/DIV/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: I admit this is dumb. NT/W2K Services?
Title: RE: I admit this is dumb. NT/W2K Services? DING! (That's the light bulb going on in my head) That makes complete sense. Thanks Guy for outlining this in email. I understand now. It took me ~4 hours to create my very first ORA-600 on my w2k oracle database and crash it. :) That has GOT to be a record! LK -Original Message- From: Guy Hammond [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 6:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: I admit this is dumb. NT/W2K Services? Hi Lisa, Yes, I agree it can be confusing. The service is a background process that provides an environment for Oracle to execute in - I don't know about the specifics in this case, but Oracle on Unix is comprised of two logical parts, the VOS and Oracle itself. You don't see this because its all started from a single binary. Oracle's own engineering is split into two groups, VOS, or virtual operating system who maintain a version of VOS for each operating system Oracle supports, and the Oracle database itself, which uses the VOS API rather than the underlying Unix (or whatever) APIs. So, things that are the same on all Oracle platforms, like say the SQL parser, are actually the same code, making calls to VOS, and VOS is different on every platform. So if Oracle want to support a new OS, they simply develop a version of VOS for it, then use it to recompile the main codebase - and the people working on their core products never need to worry about operating systems and can concentrate on pure algorithms and functionality. I assume that the service (for example, OracleServiceTEST on my workstation) is VOS for NT. When you start the service, set ORACLE_SID then connect / as sysdba and type startup, I guess what you are doing is invoking the platform-independent parts of Oracle's code, compiled for VOS on Intel. Cheers, g -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 6:22 PM To: Multiple recipients of list ORACLE-L Subject: I admit this is dumb. NT/W2K Services? I'm playing with Oracle on w2k out of sheer boredom. So now I'm forced to learn a little bit about w2k. I was looking at oradim and it has starttype and shuttype with options srvc and inst. OK, I understand the instance part. But what on earth are services? Below is what the help says about it. So to translate this into Unix-speak, is this similar to a daemon? I guess I'm confused because as far as I know there's nothing additional that needs to be running on Unix to just start up a database. If that's the case, then why would you want to shut down an instance and not services? For RMAN? I guess I'm at a loss here. Can someone give me an example of when you'd want to do this? Plus, there's notes on Metalink about recreating services. Why/when would you want to do that? Here's the overly-generic definition I found. A program, routine, or process that performs a specific system function to support other programs, particularly at a low (close to the hardware) level. When services are provided over a network, they can be published in Active Directory, facilitating service-centric administration and usage. Some examples of Windows 2000 services are Security Accounts Manager service, File Replication Service, and Routing and Remote Access Service. Any descriptions or web sites that can describe this would be appreciated. Lisa Koivu Oracle Database Administrator and Self-Professed W2K Idiot. Fairfield Resorts, Inc. 954-935-4117
Re: RE: UNCUT ORACLE-L The Motion Picture
She was from the Tammy Fae school of makeup application. Big hair too. Charles Wolfe To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED][EMAIL PROTECTED] tcom.comcc: Sent by: Subject: Re: RE: UNCUT ORACLE-L The Motion root@fatcity.Picture com 08/14/2001 06:51 PM Please respond to ORACLE-L Don't you mean rogue college intern? :) - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 14, 2001 10:47 AM UNCUT ORACLE-L Coming to theaters near you. Oracle-L, the UNCUT version is rated NC-17. Directed by Bruce. Produced by Jared Still. Starring: Lisa Koivu. Watch as she machetes a user who left his userid and password on a post-it on his PC allowing a rouge college intern to hack the system and destroy data. /Clip Lisa: YOU'VE USED THAT PASSWORD FOR THE LAST TIME MISTER, User: NOo! Hack hack slice slice Lisa: Now where's that intern... /Clip Ross Mohan as her feisty sidekick. (envision Joe Pesci) /Clip Nice Cutting Lisa. So l-user, is it funny now? Does she make you laugh? Like a clown? Looks like we'll have to rewrite that song. 'The ankle bone's connected to the spinal cord...' /Clip Rachel Carmichel, as the goddess of manager destruction. Watch as she stuffs a chair down the throat of a manager for his really stupid ideas. /Clip Manager: But Rachel, don't you think that we could eliminate that 450g worth of data and save a lot of money in training, dba costs and license fees if we converted everything to Excel Spreadsheets? Why are you looking at me like that? No, now put down that chair that could be an OHSA recordable. Open Wide? Oh, you silly. I've already had brunch with the steering committee. That's where this excellent excel idea came from. We can do this right? I figure 450 g isn't that much is it? All we have to do is get some PC's and a couple secretaries and... No, back away. N. Stuff, cram, cram. /Clip Eric Pierce as Master Po giver of infinite knowledge. /Clip Grasshopper. You will find all you need at these links. /Clip Director Jared Still, in a special appearance. He dispatches another developer for bad locking practices: /Clip Six table locks? For a three table select? I asked for code and you bring me this. What have I done to deserve this disrespect. To the acid baths with him... /Clip Christopher Bowes as the thoroughly confused rookie: /Clip: HELP!... Am I an idiot? Well, no I don't think so. What's an idiot? RTFM? What's an RTFM? Read the what? What's a concepts manual. What's a concept? That's nice, but what is a database? I've got to build one for my boss today. I told him I would and my performance review is at 3pm... Is 15 minutes enough time to build a 40 terabyte base? But I thought DBA's did nothing but get in the way of us developers... What's a tablespace? What's a table /Clip Other special appearances by Steve Adams, Christopher Spence, Joe Testa and lots of others from the Oracle-L. See them all as you've never seen them before. See Oracle-L, the UNCUT version. Coming this fall. Sorry, folks, slow day... -- 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]
RE: RMAN cold backups continued
I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks. Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 15, 2001 9:10 AM To: '[EMAIL PROTECTED]' Thanks to everyone who replied yesterday. It appears I had already been on the right track, as I did attempt backups with the database in noarchivelog mode and mounted but not open. Hot backups, with DB in archivelog mode, worked fine. However, cold backups, performed in the manner stated above, fail (see below) with errors mentioning database keyword and character set. This is Oracle 9.0.1 on Solaris. I'll appreciate any ideas; thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] RMAN shutdown immediate 2 startup mount 3 run { 4 allocate channel t1 type disk; 5 backup incremental level 0 6format '/dbbackup/%d/t%t_s%s_p%p' 7database 8; 9 release channel t1; 10 } 11 exit database closed database dismounted Oracle instance shut down connected to target database (not started) Oracle instance started database mounted Total System Global Area 235701300 bytes Fixed Size 279604 bytes Variable Size167772160 bytes Database Buffers 67108864 bytes Redo Buffers540672 bytes using target database controlfile instead of recovery catalog allocated channel: t1 channel t1: sid=10 devtype=DISK Starting backup at 15-AUG-01 released channel: t1 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00579: the following error occurred at 08/15/2001 08:57:33 RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06003: ORACLE error from target database: ORA-06550: line 1, column 166: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated RMAN-06031: could not translate database keyword Recovery Manager complete. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- training
Yes. It does. But, as someone pointed out earlier, as an individual it's only partially deductible. If you're a business then it is an expense that can be offset against income (and thus is 100% deductible). If you're not already a DBA (or at least in an IT field) then it's probably not deductible. As always, check with a real tax lawyer. Me? I just slept at a Holiday Inn last night. Regarding registering as a non-profit -- 2 points. 1. The IRS requires that you have some socially beneficial activity as your only mission (education, religion, etc.). 2. You can never make a profit. They're pretty picky about this. (LOL) lhoska@calibr esys.com To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] root@fatcity.cc: com Subject: RE: OT -- training 08/14/2001 05:41 PM Please respond to ORACLE-L Speaking about progressing in your current field wouldn't technical training of dba qualify for a tax break under the same category as training for FAA ground instructor? Otherwise, your FAA ground instructor registered as a private business (and we're back to the beginning of our discussion). Doesn't surprise me neither does it make me jealous. There are so many different career decisions you can make. I like being a dba.. Btw, I am pretty sure you can write off your technical book fees even as an individual.. -Original Message- Sent: Tuesday, August 14, 2001 4:54 PM To: Multiple recipients of list ORACLE-L Appearances to the contrary, Canada is a separate country with their own tax laws. However, the tax dodge that you mention is common here too. Here's a really good one -- become a Certified FAA Ground Instructor. You teach people how to pass the FAA ground exam. Since it's not life threatening, it's relatively simple to get this certificate. Then get a student or two. After that you can buy an airplane. The airplane, the gas to fly it, the maintenance and hangering of the airplane, the cost of getting the experience necessary to become a Certified Flight Instructor (CFI), books, aircraft simulator software, landing fees, even the cost of overnight lodging in some cases, instructors' fees (in short, a whole ton of things that make flying a hobby for the rich) become tax deductable because they are helping you progress in your field as an instructor. The IRS does not allow you to deduct training that qualifies you for a new field but it does allow you to deduct training that allows you to progress in your current field. Because of the FAA requirements for becoming a CFI almost anything having to do with flying will count as training. Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED][EMAIL PROTECTED] mpo.gc.ca cc: Sent by: Subject: RE: OT -- training [EMAIL PROTECTED] 08/14/2001 04:17 PM Please respond to ORACLE-L I know in Canada that some high-paid executives have farms in rural areas (ahem, cottages really) where they grow forage, seed, or raise a couple of sheep, rabbits, a few pigs, some chickens, or one cow. All for tax deductions of course. It helps if the farm is near a lake. Another good one is horse farm. There is a particularly big one in Ontario that specializes in horse racing... and never makes a profit. Ha ha ha ha ha ha... This is my opinion, of course. But I saw many of these when I used to enter farm tax records for Statistics Canada years ago. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message-
RE: RAID or NOT to RAID? What's the diff???
some hack writer who haunts this list. don't believe anything she says :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RAID or NOT to RAID? What's the diff??? Date: Wed, 15 Aug 2001 00:40:23 -0800 Oh yes, and when I save up some money after buying the Certification book, I should be purchasing DBA 101, can't remember who wrote that one though :-) Lee -Original Message- Sent: 15 August 2001 08:50 To: Multiple recipients of list ORACLE-L Guy Harrison - Oracle SQL High Performance Tuning Jonathan Lewis - Practical Oracle 8i and at the moment - Couchman and Schwinn - Oracle 8i DBA Certification Exam Guide. Regards Lee -Original Message- Sent: 14 August 2001 18:07 To: Multiple recipients of list ORACLE-L On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote: and very nice they are too. Great book by the way. Hmmm, so what would folks consider their essential Oracle books? maybe your personal top 2 or 3? -s -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Armijo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Speed up Truncate tables
truncate doesn't change the hwm unless you drop storage also, depending on the number of extents (not the number of rows), it can take a long time to free up storage if you do truncate table ... drop storage. Oracle has to update the UET$ and FET$ tables for each extent you release. From: Hallas John [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Speed up Truncate tables Date: Wed, 15 Aug 2001 01:25:59 -0800 Chuan, Are you sure you were using the TRUNCATE TABLE command rather than DELETE It sounds as if you are running a delete, especially if the HWM was not shrunk John -Original Message- Sent: 15 August 01 09:10 To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
OT: HANSEN Inventory and Work Order System
We have decided to get Hansen's IWOS system to interface with out Utility Billing System and I am looking for any information about it from organizations which may already have it. Operating System Number of Utility Billing Accounts? How long have you been using it? size and growth ? Are you interfaced with a Utility Billing System (which one)? We have SCT's Utility Billing System. Are you interfaced with a GIS System (which one)? We have ESRI's GIS. Are you using wireless connectivity? Any problems with installation? How much time is spent maintaining the database? Any other things we should be aware of? This probably has little interest to others on this list, so please respond directly to me. Thanks. -- Paul Del Mastro City of Raleigh 222 W. Hargett Street Raleigh, N.C. 27601 (919) 890-3018 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Del Mastro INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN cold backups continued
running it on 9.0.1 on linux no problems, only change to your script was location of where to put the files. i've not doing the controlfile thing, i've got a repository. joe [EMAIL PROTECTED] 08/15/01 10:07AM Thanks to everyone who replied yesterday. It appears I had already been onthe right track, as I did attempt backups with the database in noarchivelogmode and mounted but not open.Hot backups, with DB in archivelog mode, worked fine. However, coldbackups, performed in the manner stated above, fail (see below) with errorsmentioning "database keyword" and "character set". This is Oracle 9.0.1 onSolaris. I'll appreciate any ideas; thanks! Paul BaumgartelMortgageSight Holdings, LLC[EMAIL PROTECTED]RMAN shutdown immediate2 startup mount3 run {4 allocate channel t1 type disk;5 backup incremental level 06 format '/dbbackup/%d/t%t_s%s_p%p'7 database8 ;9 release channel t1;10 }11 exitdatabase closeddatabase dismountedOracle instance shut downconnected to target database (not started)Oracle instance starteddatabase mountedTotal System Global Area 235701300 bytesFixed Size 279604 bytesVariable Size 167772160 bytesDatabase Buffers 67108864 bytesRedo Buffers 540672 bytesusing target database controlfile instead of recovery catalogallocated channel: t1channel t1: sid=10 devtype=DISKStarting backup at 15-AUG-01released channel: t1RMAN-00571: ===RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===RMAN-00571: ===RMAN-00579: the following error occurred at 08/15/2001 08:57:33RMAN-03002: failure during compilation of commandRMAN-03013: command type: backupRMAN-06003: ORACLE error from target database: ORA-06550: line 1, column166:PLS-00553: character set name is not recognizedORA-06550: line 0, column 0:PL/SQL: Compilation unit analysis terminatedRMAN-06031: could not translate database keywordRecovery Manager complete.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Paul Baumgartel INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Speed up Truncate tables
Title: RE: Speed up Truncate tables Chuan, You can use the 'REUSE STORAGE' clause of truncate table. That's a heck of a lot faster if you have a whole load of extents allocated to the table. What it does is mark the table as empty and keep all extents. However, I have a feeling that if you really want to release all storage, you'll have to suffer through the complete truncation (without reuse storage). I don't know if there's a way around that. HTH Lisa Koivu Am I an Idiot? (and DBA) Ft. Lauderdale, FL, USA -Original Message- From: Chuan Zhang [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:10 AM To: Multiple recipients of list ORACLE-L Subject: Speed up Truncate tables Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lost of all Control Files
If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs. You will loose the archiving and RMAN (if you have it) info though. At least you will not forget now to backup control files regularly ;-). Djordje -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 10:22 AMTo: Multiple recipients of list ORACLE-LSubject: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RMAN cold backups continued
Thanks to everyone who replied yesterday. It appears I had already been on the right track, as I did attempt backups with the database in noarchivelog mode and mounted but not open. Hot backups, with DB in archivelog mode, worked fine. However, cold backups, performed in the manner stated above, fail (see below) with errors mentioning database keyword and character set. This is Oracle 9.0.1 on Solaris. I'll appreciate any ideas; thanks! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] RMAN shutdown immediate 2 startup mount 3 run { 4 allocate channel t1 type disk; 5 backup incremental level 0 6format '/dbbackup/%d/t%t_s%s_p%p' 7database 8; 9 release channel t1; 10 } 11 exit database closed database dismounted Oracle instance shut down connected to target database (not started) Oracle instance started database mounted Total System Global Area 235701300 bytes Fixed Size 279604 bytes Variable Size167772160 bytes Database Buffers 67108864 bytes Redo Buffers540672 bytes using target database controlfile instead of recovery catalog allocated channel: t1 channel t1: sid=10 devtype=DISK Starting backup at 15-AUG-01 released channel: t1 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00579: the following error occurred at 08/15/2001 08:57:33 RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06003: ORACLE error from target database: ORA-06550: line 1, column 166: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated RMAN-06031: could not translate database keyword Recovery Manager complete. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Designer 2000 install on Linux
Thanks for the advice Jared- Have you tried wine? I've looked at win4lin, but they don't seem to support my distribution/kernel level (Suse/2.4.7). Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Either lead by example, or become a terrible warning jkstill@cybco n.comTo: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: Designer 2000 install on Linux com 08/11/01 07:56 PM Please respond to ORACLE-L two options I have tried Use Win4Lin. I bought it mostly to use MS Word on my Linux box. Works very well. Haven't tried Oracle Designer on it, but don't know why it wouldn't work. There's nothing special about it. i.e. no direct-X video or other hardware access. Buy a laptop or another computer. I went the laptop route so I can get out of the loft and present some pretense of being with my family. ;) Jared On Wednesday 08 August 2001 08:06, Kevin Hedger wrote: Hello everyone. I am in need of some advise. I have a class that is requiring that I install Oracle Designer 2000. The class provides Designer 2000 for windows with the book Rapid Applications Development with Oracle Designer 2000 Billings, Chris / Billings, Maria / Tower, Julia. The problem is that I have Oracle 8i Enterprise Edition loaded on a Redhat 6.2 Linux box. I need to know where I can download designer 2000 for Linux and if anyone has done this install I would greatly appreciate any advice or direction anyone can give me. Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Hedger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Checking if Oracle Connection still valid
Yusron, One item I have noted from those who love OCI is that they rarely if ever include the sqlca.h file which defines a structure called sqlca (wonder where that name came from).This is regrettable since it works with OCI just as well as Pro*C. There is a data point in sqlca called sqlca.sqlerrm which under normal circumstances is set to 0 by Oracle on the completion of every call. Now if your session is no longer valid you'll find it set to -1012 in which case you need to reconnect to the database. Dick Goulet BTW: One other kind of an irk in the side I have with OCI programs that do not include sqlca.h is that when they want to retrieve a pile of data they go and count all of the rows that fulfill the where clause so as to know when they have fetched all of the data. Well instead you can fetch a row of data and then check sqlca.sqlerrm. If it's 0 then you've gotten all of the data there is. Reply Separator Author: Yusron Hilmy [EMAIL PROTECTED] Date: 8/14/2001 9:20 PM Hi All, I am using OCI to build my oracle application. In OCI, how I can check if oracle connection/session is still valid ? like dbdead() in MSSQL. Thanks, Yusron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yusron Hilmy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Splitting a database: pro and cons
I'm currently engaged in trying to join two databases that were split. The databases are supposed to be twin images of each other but, of course, they're not. But you may be taking a different route. WIll any objects in database A be twinned in database B? Do you have lookup tables that will be in both databases? Are your primary keys generated by sequences and will the sequences be twinned in both databases? Will the manager of application A go to the boss of the manager of application B and tell him that database B doesn't produce the same results as database A? If the answer to all of the above is, No, then you probably do have two logical databases. Go ahead and split them. Otherwise, you've got a world of grief ahead of you trying to keep them synchronized. Think about policies and procedures to keep the data structures (much less the data) synchronized. Djordje Jankovic [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L canada.ca [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Splitting a database: pro and cons 08/14/2001 06:51 PM Please respond to ORACLE-L Hi list, I have two applications running against one database (in fact I have a few but for the sake of this question two are enough). The two apps have different upgrade patterns and I would like to split them in two databases that will be on the same unix server. There are some views that are used extensively that join data from both apps/schemas, and after the split those should be made using db links. I did some tests and comparisons of queries going through links versus running them directly on the database, and did not see a lot of difference. Does anybody see or know of any downside in splitting the database in two :-(. And any advantage :-). What is the general strategy when installing different apps (from different vendors) - put them on separate databases or combining them. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: An SQL question , not easy ;-)
oops, should be not :o) select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start Cheers Greg -Original Message- Sent: 15 August 2001 15:43 To: '[EMAIL PROTECTED]' Or use a self-join select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Greg Solomon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 HRMS System Administrator Needed in San Jose..
This client, a world leader in the electronic manufacturing industry, in San Jose, CA is currently seeking an Oracle HRMS System Administrator. You will facilitate and maintain the setup of the Application so the users can work in a stable environment that produces expected results. Must be very experienced with Oracle Human Resources (not Financials or Manufacturing). This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * RESPONSIBILITIES Maintain module specific information (i.e. cross-validation rules, setup features) unavailable to users. Assign and create application responsibilities, security access profiles. Create User IDs and disable users no longer with organization or no longer requiring an access. Manage the Concurrent Manager(s) ensuring that it's always up and running and activating when necessary. Ensures that all interfaces run properly and as scheduled. Create and/or disable Key Flexfields and Descriptive Flexfields. Create new customized application forms. Monitor Self Service Workflow/Issues. Create/Modify Discoverer/NoetixViews Folders Views. Understanding of the integration of modules contact points between systems tables. * REQUIREMENTS * 3-7 or more years overall experience in IT, HRIS, and/or HR * 1-2 years System Administration experience in Oracle HRMS on Unix (Sun Solaris preferred) * Must have Oracle HR 11.X or higher, and Oracle Database 7.3 or higher * Several of the of the following additional skills: OTA, HRSS, Oracle Forms, WorkFlow, PL/SQL, Discoverer, NoetixViews * BS/BA degree preferred, but not mandatory * U.S. Citizens or permanent residents only This position offers: * Opportunity to become a key member of the I.T. team * Competitive Salary and Benefits..Base up to 100K (maybe more) * Relocation assistance if needed For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please do not send a resume or call if you need sponsorship or are a third party! Please use job code: One/San Jose/HRMS/Carroll Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition attached to Synonym
Hi All, Once again sinking into the depths of Oracle code. BUG INFO Bug:1716968 / Bug:1273906 Base Bug:743019 Fixed In Ver: 9.0.2 Abstract: CANNOT DROP PARTITION IF ADDED VIA SYNONYM - ORA-2149 Still waiting for instructions on how to cleanup my data dictionary. Oracle support can reproduce it and feel that's enough. Sigh Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: computer history stories - Now: IQ, etc.
Apologies for reviving a dead thread, but I was incommunicado for a week and just now saw this rather interesting thread. One of my pet rants is about the difference between knowledge and understanding. I am not sure of the clinical definitions of the words used in this discussion, but will offer this postulation, in IT terms. Knowledge is essentially accumulated data. Understanding is more like the ability to process data. Of the two, understanding is far more valuable - and far more rare. I once had a physics professor/mentor who invented the mathematical field of product calculus to support his doctoral research in physics. (Note: product calculus - multiplying infinitesimal bits of stuff, not adding. I may be a geezer, but am not old enough to have studied under Newton!) The mathematical community was suitably impressed and told him that if he would write up all the proofs and do the formal theory, the Field's medal would be a certainty. (There is no Nobel prize for Mathematics. The Field's medal is the equivalent.) He replied that he was a tool user, not a tool maker - that the only reason he did it was because appropriate tools did not previously exist. He finished his doctorate in physics, others did the mathematical background work, and nobody got the Field's medal for product calculus. The moral is that he did not have the knowledge required, but did have a very deep understanding of mathematics. To compensate for this lack of knowledge, his own and other's, he used his understanding to create new knowledge. Another illustration... In the beginning, there is trigonometry. One has to memorize lots of half-angle formulae, double-angle formulae, ad nausem. Pure knowledge - just plug in values and crank out answers. Further down the line, one learns Euler's equation and how to effectively use it. Usually, that static data - all those formulae - get purged from primary memory. If one needs them, they can be easily derived in a few minutes - a much more powerful technique. There is little sense cluttering up valuable primary memory with such trivia. In the field of Oracle database administration, some knowledge is essential. However, understanding is the seminal distinction between the lower and higher levels of expertise. After all, how many of the most challenging situations you have been in, or toughest projects you have done, could have been well handled on the basis of knowledge alone? Knowledge will only get you so far. Serious critical reasoning skills are required to transcend the existing knowledge barrier. Consider also in this context the large and firmly entrenched knowledge base about ratio-based tuning versus more reasoned wait-based tuning. (setq minor-rant-mode ON) This is my main complaint about the OCP program. The tests are almost exclusively knowledge based. The old Chauncey exams had a much higher understanding requirement. (setq minor-rant-mode OFF) -Don Granaman [certifiable Orasaurus] (Real life doesn't have the correct answers in the back.) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 1:39 PM IQ from what I understand is COMPLETELY related to how fast you learn. IQ is your ability to learn, nothing to do with how Smart you are. Smart is how much you know, nothing to do with how you learn. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datafile Migration Tool
Hense transportable tablespaces. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 14, 2001 6:17 PM To: Multiple recipients of list ORACLE-L Actually, this could be an interesting tool. Our production database is on HP. But I would like to setup several test instances on linux or other platforms for the developers. Moving 30-40Gb of data around via export/import would be a real pain. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Either lead by example, or become a terrible warning kaygopal@yaho o.comTo: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: Datafile Migration Tool com 08/14/01 02:41 PM Please respond to ORACLE-L Kirti, Frankly speaking , (as of now) I have to support the database and I don't think Oracle will support. But if you have luxury..you can always reorgaze the database and oracle HAS to suport the database. Initially I can give this tool for learning oracle and playing with oracle databases, I can pack this tool with a custom block editor where you can edit the databases, and an unloader tool (like DUL) which gives you the data in text format from the data files. But I don;t think Oracle will support any of these tools. :( --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Gopal, So who do we call if there is a problem in the converted datafile later down the road and the database is down? The Tool Supplier or Oracle Support? Thanks. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: An SQL question , not easy ;-)
Or use a self-join select a.call_start, count(b.call_start) interruptions from phone_call a, phone_call b where a.call_start = b.call_start and a.call_end b.call_start group by a.call_start -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Greg Solomon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Usage of Number type for table columns
List, In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that this location_ID would never cross beyond 3 digits. Also, we know that this specific column does not require any digits to the right of the decimal point. --- (This column is only an example). He does not want to specify any precision or scale for the number type columns. His point is --- Oracle would use only that much space depending on the actual number of digits he enters into the column. Thus, he is not wasting any space. Also, he says, during the beginning of application, we might not know the maximum limits for number column. Hence, leaving them as floating point ( Location_ID NUMBER), gives him flexibility and he need not change the number column precision or scale during the entire life cycle of the application. He says, it is upto the application program (JAVA/EJB) to control and check the maximum length permissible against a column depending on the business rules. I do not know whether this is a correct approach. Intuitively, I feel that this approach is not correct. However, I am not able to come up with any valid reason to negate his approach. Please inform whether the approach is correct or having any problems, from your experience. Thanks, Rao [EMAIL PROTECTED] DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
user holding session even after a re-boot
I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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).
RE: Speed up Truncate tables
I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: An SQL question , not easy ;-)
Is this not flawed in that given these results: eventtimeevent - 01-AUG-2001 12:10:00 start add 1- 1 01-AUG-2001 12:15:00 start add 1- 2 01-AUG-2001 12:25:00 start add 1- total 3 01-AUG-2001 12:30:00 end subtract 1 - 2 01-AUG-2001 12:40:00 end subtract 1 - 1 01-AUG-2001 12:45:00 start add 1- 2 01-AUG-2001 12:47:00 end subtract 1 - 1 01-AUG-2001 12:55:00 end subtract 1 - 0 The highest total is 3 this is incorrect by 1. There have been a total of 4 simultaneous calls 3 of which were simultaneous and 1 which ran simultaneously with the one of the three calls! IMHO Kev. still working on a solutionhere's what I have so far...lot's of dbms outputs so it may look very confusing. Based on the data that Andrey first provided. based on the table; create table phone ( call_start date ,call_end date ) / -Original Message- Sent: 15 August 2001 15:22 To: Multiple recipients of list ORACLE-L Note that whenever a call starts, this increases the current number of calls by 1, and whenever a call ends, this decreases the current number of calls by 1. Hence you can uncouple the start and end times - you don't need to know that a given start time and a given end time belong to the same call! (Think about it - it's a bit counterintuitive, but it's true!). So: SELECT CALL_START_DATE eventtime, 'start' eventtype FROM calltable UNION ALL SELECT CALL_END_DATE eventtime, 'end' eventtype FROM calltable ORDER BY 1 Then you set a current number of calls variable to zero, and move the cursor through the results, adding 1 to the variable for each 'start' and subtracting 1 for each 'end'. Whenever you add 1, if the current number of calls is higher than its highest value so far, store the new highest value so far. When you've finished, this latter variable will contain the maximum number of simultaneous conversations. Hope this helps. Paul Paul Vincent Database Administrator, University of Central England -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 11:21 To: Multiple recipients of list ORACLE-L Subject: An SQL question , not easy ;-) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). phone.sql
RE: Datafile Migration Tool
At which version of Oracle did they remove this? It is NOT in any my directories. I checked: - 8.0.3 ORACLE_HOME/bin - 8.1.5 ORACLE_HOME/bin - 8.1.6 ORACLE_HOME/bin - 7.3.4 ORACLE_HOME/bin Thanks, Babette -Original Message- Gopalakrishnan Sent: Wednesday, August 15, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Hi, Oracle'e block editor is called BBED and it will be in your $ORACLE_HOME/bin. DUL will not be in standard oracle instalations and it is a support tool. --- Babette Turner-Underwood [EMAIL PROTECTED] wrote: Like the block editor Oracle used to make available ? BDE or something like that? DUL tool would be cool, too. Especially, if it handled the odd-ball cases like LMTs and IOTs. I would only use DUL on production if it was total S.O.L. and there was nothing left (besides READING won't make the muck worse). However, I would love to play with something like these on my sandbox area. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Checking if Oracle Connection still valid
sqlca has been around for a LONG LONG time. I used it years ago with my COBOL SQL Reports. Its the SQL Communications Area. -Original Message- Sent: Wednesday, August 15, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Yusron, One item I have noted from those who love OCI is that they rarely if ever include the sqlca.h file which defines a structure called sqlca (wonder where that name came from).This is regrettable since it works with OCI just as well as Pro*C. There is a data point in sqlca called sqlca.sqlerrm which under normal circumstances is set to 0 by Oracle on the completion of every call. Now if your session is no longer valid you'll find it set to -1012 in which case you need to reconnect to the database. Dick Goulet BTW: One other kind of an irk in the side I have with OCI programs that do not include sqlca.h is that when they want to retrieve a pile of data they go and count all of the rows that fulfill the where clause so as to know when they have fetched all of the data. Well instead you can fetch a row of data and then check sqlca.sqlerrm. If it's 0 then you've gotten all of the data there is. Reply Separator Author: Yusron Hilmy [EMAIL PROTECTED] Date: 8/14/2001 9:20 PM Hi All, I am using OCI to build my oracle application. In OCI, how I can check if oracle connection/session is still valid ? like dbdead() in MSSQL. Thanks, Yusron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yusron Hilmy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LDAP and Oracle
Title: LDAP and Oracle Anyone use LDAP to work with Oracle to handle single login between various applications. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863
RE: OT: RE: UNCUT ORACLE-L The Motion Picture
So, would that be irrational or imaginary? BTW - I once made a mistake on a blackboard demonstration and ended up presenting Newton's Macroscope instead of Newton's Microscope. Turns out the math works as well for infinitudes as for infinitesimals. (g) Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L -SMI.com[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: OT: RE: UNCUT ORACLE-L The com Motion Picture 08/14/2001 06:31 PM Please respond to ORACLE-L remove a Dedekind cut? It's like finding out there *is* no such thing as the number next to zero -Original Message- Sent: Tuesday, August 14, 2001 2:08 PM To: Multiple recipients of list ORACLE-L Momento - No. Not likely to see it. I might go to the movies once a year and the next three years are already reserved. Dedekind - Yes. Many years. All brain cells no longer functional. If you uncut a Dedekind cut, what would happen? Does it matter since it's irrational or imaginary anyway? Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L -SMI.com[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: OT: RE: UNCUT ORACLE-L The com Motion Picture 08/14/2001 11:50 AM Please respond to ORACLE-L ROFL But, reallywhy do I have to be Joe Pesci? I really must cut down on my delivery speed...sigh. Oh well...reminds me of my first shamanic journey to the middle worldturns out my power animal was a squirrel. A friggin' squirrel. LoL Ah well, I am an oracle dba...I *do* have to compensate Ross p.s. It's Dedekind Cut. He was brilliantwow. -Original Message- Sent: Tuesday, August 14, 2001 11:10 AM To: Multiple recipients of list ORACLE-L The unkindest uncut of all - the Dedican uncut. LOL Bowes, Chris To: Multiple recipients of list ORACLE-L Chris.Bowes@[EMAIL PROTECTED] kosa.comcc: Sent by: Subject: OT: RE: UNCUT ORACLE-L The Motion root@fatcity.Picture com 08/14/2001 10:47 AM Please respond to ORACLE-L UNCUT ORACLE-L Coming to theaters near you. Oracle-L, the UNCUT version is rated NC-17. Directed by Bruce. Produced by Jared Still. Starring: Lisa Koivu. Watch as she machetes a user who left his userid and password on a post-it on his PC allowing a rouge college intern to hack the system and destroy data. /Clip Lisa: YOU'VE USED THAT PASSWORD FOR THE LAST TIME MISTER, User: NOo! Hack hack slice slice Lisa: Now where's that intern... /Clip Ross Mohan as her feisty sidekick. (envision Joe Pesci) /Clip Nice Cutting Lisa. So l-user, is it funny now? Does she make you laugh? Like a clown? Looks like we'll have to rewrite that song. 'The ankle bone's connected to the spinal cord...' /Clip Rachel Carmichel, as the goddess of manager destruction. Watch as she stuffs a chair down the throat of a manager for his really stupid ideas. /Clip Manager: But Rachel, don't you think that we could eliminate that 450g worth of data and save a lot of money in training, dba costs and license fees if we
RE: user holding session even after a re-boot
I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: mambar for Oracle by luminate
Title: Message I believe they discontinued it, I used it like that, and it was ok. Didn't really give alot of information. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: mambar for Oracle by luminate Anybody using Mamba without the luminate.net service. Opinions of it. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
Re:RE: Checking if Oracle Connection still valid
Kevin, Very true, I remember it from way back in 85 on Version 4 of Oracle. The problem with sqlca and OCI is that it's not required and therefore often left out. Dick Goulet Reply Separator Author: Kevin Lange [EMAIL PROTECTED] Date: 8/15/2001 8:50 AM sqlca has been around for a LONG LONG time. I used it years ago with my COBOL SQL Reports. Its the SQL Communications Area. -Original Message- Sent: Wednesday, August 15, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Yusron, One item I have noted from those who love OCI is that they rarely if ever include the sqlca.h file which defines a structure called sqlca (wonder where that name came from).This is regrettable since it works with OCI just as well as Pro*C. There is a data point in sqlca called sqlca.sqlerrm which under normal circumstances is set to 0 by Oracle on the completion of every call. Now if your session is no longer valid you'll find it set to -1012 in which case you need to reconnect to the database. Dick Goulet BTW: One other kind of an irk in the side I have with OCI programs that do not include sqlca.h is that when they want to retrieve a pile of data they go and count all of the rows that fulfill the where clause so as to know when they have fetched all of the data. Well instead you can fetch a row of data and then check sqlca.sqlerrm. If it's 0 then you've gotten all of the data there is. Reply Separator Author: Yusron Hilmy [EMAIL PROTECTED] Date: 8/14/2001 9:20 PM Hi All, I am using OCI to build my oracle application. In OCI, how I can check if oracle connection/session is still valid ? like dbdead() in MSSQL. Thanks, Yusron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yusron Hilmy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
WARNING Dangerous Upgrade path!
Ok, settle down. I just migrated from 80520 to 81600 on Siemens and the migrate consistently choked on the AQ$ update stuff. Something to do with objects...raw data types Oracle provided a patch which did not work. We finally had to migrate holding the database at compatible=8.0.5.2.0, butwe think the AQ$ stuff may be held back at that levelnot sure, and oracle sure as hell ain't telling. anyway, heads up. -Original Message- Sent: Wednesday, August 15, 2001 10:01 AM To: Multiple recipients of list ORACLE-L truncate doesn't change the hwm unless you drop storage also, depending on the number of extents (not the number of rows), it can take a long time to free up storage if you do truncate table ... drop storage. Oracle has to update the UET$ and FET$ tables for each extent you release. From: Hallas John [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Speed up Truncate tables Date: Wed, 15 Aug 2001 01:25:59 -0800 Chuan, Are you sure you were using the TRUNCATE TABLE command rather than DELETE It sounds as if you are running a delete, especially if the HWM was not shrunk John -Original Message- Sent: 15 August 01 09:10 To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lost of all Control Files
Thanks, And what is the sintax of the create controlfile command ? How do I use it ? Now I will backup them :-) Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado el: Wednesday, 15 August, 2001 10:37 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs. You will loose the archiving and RMAN (if you have it) info though. At least you will not forget now to backup control files regularly ;-). Djordje -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 10:22 AMTo: Multiple recipients of list ORACLE-LSubject: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Re:RE: Lost of all Control Files
I've stayed out of this one up till now. But based on the original I assume that all of the control files where on the same disk drive directory. Bad idea. If you have a problem with the drive and/or controller then you've been had. Place the control files on multiple spindles that are preferably on different controllers. And periodically, like at every shutdown, run the 'alter database backup controlfile to trace' command. It would even be a good thing to occasionally issue 'alter database backup controlfile to somewhere safe'. Dick Goulet Reply Separator Author: INF/MEKKAOUI [EMAIL PROTECTED] Date: 8/15/2001 7:41 AM hi, if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Ramon Estevez [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 15 août 2001 14:22 A : Multiple recipients of list ORACLE-L Objet : Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.00.2920.0 name=GENERATOR/HEAD BODY DIVFONT color=#ff face=Arial size=2SPAN class=644383015-15082001hi,/SPAN/FONT/DIV DIVFONT color=#ff face=Arial size=2SPAN class=644383015-15082001if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file./SPAN/FONT/DIV DIVFONT color=#ff face=Arial size=2SPAN class=644383015-15082001/SPAN/FONTnbsp;/DIV DIVnbsp;/DIV DIVFONT face=Arial size=2Best Regards,/FONT/DIV DIVFONT face=Arial size=2Nabila Mekkaoui/FONT/DIV DIVFONT face=Arial size=2DBA Oracle/FONT/DIV BLOCKQUOTE style=MARGIN-RIGHT: 0px DIV align=left class=OutlookMessageHeader dir=ltrFONT face=Tahoma size=2-Message d'origine-BRBDenbsp;:/B Ramon Estevez [mailto:[EMAIL PROTECTED]]BRBEnvoyénbsp;:/B mercredi 15 août 2001 14:22BRBAnbsp;:/B Multiple recipients of list ORACLE-LBRBObjetnbsp;:/B Lost of all Control FilesBRBR/DIV/FONT DIVFONT face=VerdanaSPAN class=902011014-15082001Hi gurus,/SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001/SPAN/FONTnbsp;/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) /SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001Ora-00202 'c:\oracle\oradata\control01.con'/SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001Ora-00207 /SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001/SPAN/FONTnbsp;/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001I have 3 controlfiles, no copies, sorry, shame./SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001/SPAN/FONTnbsp;/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error./SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001/SPAN/FONTnbsp;/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001Don't know what to do.nbsp; /SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001/SPAN/FONTnbsp;/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001I don't have backups of the control files./SPAN/FONT/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001/SPAN/FONTnbsp;/DIV DIVFONT face=VerdanaSPAN class=902011014-15082001Saludos,/SPAN/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=VerdanaRamon E. Estevez/FONT/DIV DIVFONT face=VerdanaA href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/F ONT/DIV DIVFONT face=Verdana809-565-3121/FONT/DIV DIVnbsp;/DIV/BLOCKQUOTE/BODY/HTML -- 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
Re: X$_kglcursor.kglnaobj
Ian and Riyaj, These table_... objects look like Java classes. The way to find this out is matching the kgl handle address and looking at the indx column of x$kglob. Matching this indx column with dba_objects.object_id. Yong Huang [EMAIL PROTECTED] you wrote: I use the following statment when monitoring the database select sid, s.username,s.osuser, c.kglnaobj from sys.x$kglpn p, sys.x$kglcursor c, v$session s where p.kglpnhdl = c.kglhdadr and p.kglpnses = s.saddr; Here is some output showing sid and kglnaobj: 28 table_1_0_116_0_0_ ... __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Speed up Truncate tables
A truncate (reuse storage) should not do that - it simply drops the HWM to zero and updates the segment header. However, when a truncate is issued, and dirty blocks in the buffer from that object have to be written to disk before the truncate takes place, so that might be slowing things (a little). The only other case I can think of is that truncating a table which is actually stored in a cluster does NOT do a truncate, it does a delete. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 15 August 2001 17:34 |I had the same problem when truncating a huge table (24 Mill rows). It |turned out that the reason my table was taking so long was the amount of |extents I had on it. I could look at what was actually happening during a |truncate and it had to go and take each individual block and put them back |in the available lists. | |Well, after changing the settings on the table to make larger extents (and |therefore fewer) the truncates on that table went hundreds of times faster |(we had real bad settings on that table before). | |You might investigate your storage parms and see just how many extents you |do have on that table. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: user holding session even after a re-boot
If the user already has his information displayed on the screen( retrieve already took place) and his/her machine freezes it is definitely application problem, may be networking problem but not back end problem. Printing problem is not an Oracle problem. If he/she is retrieving while printing it may be either. But still indications are your programmers didn't write good code. As to your question regarding the session I think it is not an unusual behavior. Check it in couple of minutes. It should be gone. -Original Message- Sent: Wednesday, August 15, 2001 12:11 PM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:user holding session even after a re-boot
Dave, Yes it is normal. The original session was communicating with the PC when the re-boot abnormally terminated the connection. It is now an orphan and will remain so until either you restart Oracle or the DB finds a way to close the session, most likely leaving it sniped. The reason is that to properly close a session Oracle needs to handshake with the client that it has done so. Until then it remains. That was the purpose of Dead Connection Detection. Pity that Oracle never got it to work cleanly. Dick Goulet Reply Separator Author: Farnsworth; Dave [EMAIL PROTECTED] Date: 8/15/2001 8:11 AM I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PS lock
Hi, DBAs Anybody knows about PS lock , mode in 6, and exchange deadlocks equal to 1 in v$sysstat, can this be a problem? this is ver 8.0.5 on hp unix. thanksregards, Li -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: WARNING Dangerous Upgrade path!
I think I had some issues with this also when we went from 805 to 816 on Solaris 2.6. Remeber removing all AQ params from my init.ora (job_queue* params). --- Mohan, Ross [EMAIL PROTECTED] wrote: Ok, settle down. I just migrated from 80520 to 81600 on Siemens and the migrate consistently choked on the AQ$ update stuff. Something to do with objects...raw data types Oracle provided a patch which did not work. We finally had to migrate holding the database at compatible=8.0.5.2.0, butwe think the AQ$ stuff may be held back at that levelnot sure, and oracle sure as hell ain't telling. anyway, heads up. -Original Message- Sent: Wednesday, August 15, 2001 10:01 AM To: Multiple recipients of list ORACLE-L truncate doesn't change the hwm unless you drop storage also, depending on the number of extents (not the number of rows), it can take a long time to free up storage if you do truncate table ... drop storage. Oracle has to update the UET$ and FET$ tables for each extent you release. From: Hallas John [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Speed up Truncate tables Date: Wed, 15 Aug 2001 01:25:59 -0800 Chuan, Are you sure you were using the TRUNCATE TABLE command rather than DELETE It sounds as if you are running a delete, especially if the HWM was not shrunk John -Original Message- Sent: 15 August 01 09:10 To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the
Re:RE: mambar for Oracle by luminate
True, but just enough. Dick Goulet Thought for the day: Never be afraid to try something new. Remember that a lone amateur built the Ark. A large group of professionals built the Titanic. Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 8/15/2001 6:26 AM I believe they discontinued it, I used it like that, and it was ok. Didn't really give alot of information. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 15, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Anybody using Mamba without the luminate.net service. Opinions of it. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=us-ascii TITLEMessage/TITLE META content=MSHTML 5.50.4807.2300 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Courier New; MARGIN-LEFT: 2px DIVSPAN class=858442113-15082001I believe they discontinued it, I used it like that, and it was ok.nbsp; Didn't really give alot of information./SPAN/DIV DIVnbsp;/DIV!-- Converted from text/rtf format -- PFONT face=Times New RomanDo not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes./FONT/P PFONT face=Script size=5Christopher R. Spence/FONT BRFONT face=Comic Sans MS size=2Oracle DBA/FONT BRFONT face=Comic Sans MS size=2Phone: (978) 322-5744/FONT BRFONT face=Comic Sans MS size=2Fax:nbsp;nbsp;nbsp; (707) 885-2275/FONT /P PFONT face=Comic Sans MS size=2Fuelspot/FONT BRFONT face=Comic Sans MS size=273 Princeton Street/FONT BRFONT face=Comic Sans MS size=2North, Chelmsford 01863/FONT BRFONT face=Comic Sans MS size=2/FONTnbsp; /P BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV/DIV DIV class=OutlookMessageHeader lang=en-us dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]] BRBSent:/B Wednesday, August 15, 2001 9:05 AMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B mambar for Oracle by luminateBRBR/FONT/DIV DIVAnybody using Mamba without the luminate.net service.nbsp; Opinions of it./DIV DIVnbsp;/DIV DIVJeffrey BeckstromBRDatabase AdministratorBRGreater Cleveland Regional Transit AuthorityBR1240 W. 6th StreetBRCleveland, Ohio 44113BR(216) 781-4204/DIV/BLOCKQUOTE/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: An SQL question , not easy ;-)
My apologies David, I was reading Andreys initial email as give me the number of concurrent calls being made of which there are 4. Kev (eating humble pie by the spadeful!) ;-) -Original Message- Sent: 15 August 2001 16:02 To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Usage of Number type for table columns
Rao, The boss is somewhat right, but are you absolutely certain that the current program interface to the data will remain forever? What is the likelihood of someone having to correct the data via SQL*Plus or some other method where the restrictions will have no effect. The main reason of applying the constraints at the database level is that is the lowest level of granularity for the data and consequently the one place where one can be absolutely certain that business rules get applied irregardless of where the data comes from. Dick Goulet Reply Separator Author: Rao; Maheswara [EMAIL PROTECTED] Date: 8/15/2001 7:41 AM List, In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that this location_ID would never cross beyond 3 digits. Also, we know that this specific column does not require any digits to the right of the decimal point. --- (This column is only an example). He does not want to specify any precision or scale for the number type columns. His point is --- Oracle would use only that much space depending on the actual number of digits he enters into the column. Thus, he is not wasting any space. Also, he says, during the beginning of application, we might not know the maximum limits for number column. Hence, leaving them as floating point ( Location_ID NUMBER), gives him flexibility and he need not change the number column precision or scale during the entire life cycle of the application. He says, it is upto the application program (JAVA/EJB) to control and check the maximum length permissible against a column depending on the business rules. I do not know whether this is a correct approach. Intuitively, I feel that this approach is not correct. However, I am not able to come up with any valid reason to negate his approach. Please inform whether the approach is correct or having any problems, from your experience. Thanks, Rao [EMAIL PROTECTED] DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: An SQL question , not easy ;-)
Andrey, At first glance, I think this SQL statement gives you the answer. It gives you a count of the simultaneous calls for each call. If you like this, then all you have to do is find the row with the maximum count. select a.call_start,a.call_end,count(*)+ 1 from pc a, pc b where a.call_end = b.call_start and a.call_start = b.call_end and a.call_start b.call_start and a.call_end b.call_end and a.call_start b.call_start group by a.call_start,a.call_end Chaim Andrey Bronfin [EMAIL PROTECTED] on 08/15/2001 06:20:40 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) Dear gurus ! I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END DATE . I need an SQL statement or a PL/SQL block to calculate the maximum number of SIMULTANIOUS phone conversations. Please help !!! Thanks a lot in advance ! Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Usage of Number type for table columns
I hate to be on the side of management but much time is spent going back and resizing fields and applications because the field defined is no longer big enough. Been there and done that many times. -Original Message- Sent: Wednesday, August 15, 2001 10:41 AM To: Multiple recipients of list ORACLE-L List, In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that this location_ID would never cross beyond 3 digits. Also, we know that this specific column does not require any digits to the right of the decimal point. --- (This column is only an example). He does not want to specify any precision or scale for the number type columns. His point is --- Oracle would use only that much space depending on the actual number of digits he enters into the column. Thus, he is not wasting any space. Also, he says, during the beginning of application, we might not know the maximum limits for number column. Hence, leaving them as floating point ( Location_ID NUMBER), gives him flexibility and he need not change the number column precision or scale during the entire life cycle of the application. He says, it is upto the application program (JAVA/EJB) to control and check the maximum length permissible against a column depending on the business rules. I do not know whether this is a correct approach. Intuitively, I feel that this approach is not correct. However, I am not able to come up with any valid reason to negate his approach. Please inform whether the approach is correct or having any problems, from your experience. Thanks, Rao [EMAIL PROTECTED] DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Datafile Migration Tool
Chris, True, but you can't transport them across OS platforms. Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 8/15/2001 6:56 AM Hense transportable tablespaces. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 14, 2001 6:17 PM To: Multiple recipients of list ORACLE-L Actually, this could be an interesting tool. Our production database is on HP. But I would like to setup several test instances on linux or other platforms for the developers. Moving 30-40Gb of data around via export/import would be a real pain. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Either lead by example, or become a terrible warning kaygopal@yaho o.comTo: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: Datafile Migration Tool com 08/14/01 02:41 PM Please respond to ORACLE-L Kirti, Frankly speaking , (as of now) I have to support the database and I don't think Oracle will support. But if you have luxury..you can always reorgaze the database and oracle HAS to suport the database. Initially I can give this tool for learning oracle and playing with oracle databases, I can pack this tool with a custom block editor where you can edit the databases, and an unloader tool (like DUL) which gives you the data in text format from the data files. But I don;t think Oracle will support any of these tools. :( --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Gopal, So who do we call if there is a problem in the converted datafile later down the road and the database is down? The Tool Supplier or Oracle Support? Thanks. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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
Re: LDAP and Oracle
No, but I'd also be mighty interested to hear about the details. My problem here is that I've got a couple of applications (heck, most of the applications - including all the Oracle ones) that are not LDAP compliant. Most have their own internal security setup. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@fuels cc: pot.com Subject: LDAP and Oracle Sent by: [EMAIL PROTECTED] om 08/15/2001 10:01 AM Please respond to ORACLE-L Anyone use LDAP to work with Oracle to handle single login between various applications. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: user holding session even after a re-boot
Where can I find their profiles. If your talking about the .profile then is there a Windoze equivalent cuz I'm not on unix. :( Dave -Original Message- Sent: Wednesday, August 15, 2001 11:41 AM To: Multiple recipients of list ORACLE-L I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: Datafile Migration Tool
Hi Babette, I think you are -UNIX. Check M$ and you will find that under /ORANT/bin. --- Babette Turner-Underwood [EMAIL PROTECTED] wrote: At which version of Oracle did they remove this? It is NOT in any my directories. I checked: - 8.0.3 ORACLE_HOME/bin - 8.1.5 ORACLE_HOME/bin - 8.1.6 ORACLE_HOME/bin - 7.3.4 ORACLE_HOME/bin Thanks, Babette -Original Message- Gopalakrishnan Sent: Wednesday, August 15, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Hi, Oracle'e block editor is called BBED and it will be in your $ORACLE_HOME/bin. DUL will not be in standard oracle instalations and it is a support tool. --- Babette Turner-Underwood [EMAIL PROTECTED] wrote: Like the block editor Oracle used to make available ? BDE or something like that? DUL tool would be cool, too. Especially, if it handled the odd-ball cases like LMTs and IOTs. I would only use DUL on production if it was total S.O.L. and there was nothing left (besides READING won't make the muck worse). However, I would love to play with something like these on my sandbox area. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lost of all Control Files
hi, if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine-De: Ramon Estevez [mailto:[EMAIL PROTECTED]]Envoyé: mercredi 15 août 2001 14:22À: Multiple recipients of list ORACLE-LObjet: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: computer history stories - Now: IQ, etc.
I have a simplistic view of things: Knowledge = ideas linked by associations, purely intellectual in nature. You can do the word association game re. these, quite fun. Understanding = experience involving the whole person, including movement, emotions and intellect. So to understand, you must go through the experience. P.S. Are Orasoruses herbivores, or carnivores? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Subject:Re: computer history stories - Now: IQ, etc. Apologies for reviving a dead thread, but I was incommunicado for a week and just now saw this rather interesting thread. One of my pet rants is about the difference between knowledge and understanding. I am not sure of the clinical definitions of the words used in this discussion, but will offer this postulation, in IT terms. Knowledge is essentially accumulated data. Understanding is more like the ability to process data. Of the two, understanding is far more valuable - and far more rare. I once had a physics professor/mentor who invented the mathematical field of product calculus to support his doctoral research in physics. (Note: product calculus - multiplying infinitesimal bits of stuff, not adding. I may be a geezer, but am not old enough to have studied under Newton!) The mathematical community was suitably impressed and told him that if he would write up all the proofs and do the formal theory, the Field's medal would be a certainty. (There is no Nobel prize for Mathematics. The Field's medal is the equivalent.) He replied that he was a tool user, not a tool maker - that the only reason he did it was because appropriate tools did not previously exist. He finished his doctorate in physics, others did the mathematical background work, and nobody got the Field's medal for product calculus. The moral is that he did not have the knowledge required, but did have a very deep understanding of mathematics. To compensate for this lack of knowledge, his own and other's, he used his understanding to create new knowledge. Another illustration... In the beginning, there is trigonometry. One has to memorize lots of half-angle formulae, double-angle formulae, ad nausem. Pure knowledge - just plug in values and crank out answers. Further down the line, one learns Euler's equation and how to effectively use it. Usually, that static data - all those formulae - get purged from primary memory. If one needs them, they can be easily derived in a few minutes - a much more powerful technique. There is little sense cluttering up valuable primary memory with such trivia. In the field of Oracle database administration, some knowledge is essential. However, understanding is the seminal distinction between the lower and higher levels of expertise. After all, how many of the most challenging situations you have been in, or toughest projects you have done, could have been well handled on the basis of knowledge alone? Knowledge will only get you so far. Serious critical reasoning skills are required to transcend the existing knowledge barrier. Consider also in this context the large and firmly entrenched knowledge base about ratio-based tuning versus more reasoned wait-based tuning. (setq minor-rant-mode ON) This is my main complaint about the OCP program. The tests are almost exclusively knowledge based. The old Chauncey exams had a much higher understanding requirement. (setq minor-rant-mode OFF) -Don Granaman [certifiable Orasaurus] (Real life doesn't have the correct answers in the back.) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 1:39 PM IQ from what I understand is COMPLETELY related to how fast you learn. IQ is your ability to learn, nothing to do with how Smart you are. Smart is how much you know, nothing to do with how you learn. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes.
RE: user holding session even after a re-boot
Title: RE: user holding session even after a re-boot Well, that sounds like an optimal environment, Kevin. I've seen Oracle client zombie sessions hang around for days and chew up CPU. I had to write a shell script to identify these sessions and kill them in both the OS and in Oracle. This was HP/UX. I've seen the same thing on Solaris. And so I'm told OpenVMS does not have this problem. Profiles will timeout a session that is idle, not one that is busy cranking away on who knows what statement it was executing when the messy app either dropped the connection unexpectedly or the user rebooted. That is, unless you set a different resource limit on the profile and assign it to the app user. I found that was very messy and I got more complaints than anything else. Guess the bottom line is the behavior of a released connection is platform dependent. Lisa Koivu Gimp and Oracle DBA Ft. Lauderdale, FL, USA -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 12:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: user holding session even after a re-boot I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: An SQL question , not easy - GOT IT . MANY THANKS !!!!!!!
Dear Gurus ! Lots of thanks to everybody who replied. I've got numerous great solutions from U - now i need to choose one among them ;-) This is a great list with genius people subscribed ! I love to belong to Oracle DBAs brotherhood. Thank U all very much have a great day ! -Original Message- Sent: Wednesday, August 15, 2001 5:02 PM To: Multiple recipients of list ORACLE-L Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Speed up Truncate tables
Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view) for the table in question, and modify them before you load the data. You can modify the INITIAL extent by issuing an 'alter table allocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (next x)' command to change the NEXT extent. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 11:02 AM To: Multiple recipients of list ORACLE-L I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent Help Required ORA-65535
Hi All, I am facing a very different problem. I am using Oracle as a XA Resouce Manager for Encina. The Encina applications built using Oracle 8.0.6 are working fine. When we moved the Oracle version to Oracle 8.0.6.3 the applications are not able to connect to the database. It gives the following error: ORA-65535 ( No description) I was not able to find the description for the same anywhere in Oracle documentation. The SQLNet Log has entries like *** Fatal NI connect error -1, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=sysfep))(CONNECT_DATA=(SID=sysfep)(CID=(PROGRAM=)(HOST=fbm ntfp2)(USER=poise VERSION INFORMATION: TNS for HPUX: Version 8.0.6.3.0 - Production Time: 13-AUG-2001 16:14:43 Tracing to file: /tmp/stu_client.log_24465.trc *** I also creates a XA trace file with its entries like: 161443.24465.0: xaolog: Could not open file in directory /opt/oracle/product/8.0.6.3/rdbms/log ORACLE XA: Version 8.0.6.0.0. RM name = 'Oracle_XA'. 161443.24465.0: ORA-65535: Message 65535 not found; product=RDBMS; facility=ORA * I would be really great if any of you'all can help me ASAP. Regards Kamesh. *** Important. This E-mail is intended for the above named person and may be confidential and/or legally privileged. If this has come to you in error you must take no action based on it, nor must you copy or show it to anyone; please inform the sender immediately. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: user holding session even after a re-boot
I was talking about the connection profiles that you can use to set resource limits when you run the create profile command. With this you can create a profile for a set of users that you can then attach to a user either when you create it or thru the alter user command. The profile lets you set such things as CONNECT_TIME and IDLE_TIME. Maybe the IDLE_TIME setting might let those processes drop off. To see what your current profile settings are when logged in as one of the users do a select * from user_resource_limits. Mine currently say : COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USERUNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSIONUNLIMITED LOGICAL_READS_PER_CALL UNLIMITED IDLE_TIMEUNLIMITED CONNECT_TIME UNLIMITED PRIVATE_SGA UNLIMITED I have no profile setup for this user and my default sets all to unlimited. -Original Message- Sent: Wednesday, August 15, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Where can I find their profiles. If your talking about the .profile then is there a Windoze equivalent cuz I'm not on unix. :( Dave -Original Message- Sent: Wednesday, August 15, 2001 11:41 AM To: Multiple recipients of list ORACLE-L I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: user holding session even after a re-boot
Title: RE: user holding session even after a re-boot DBA_PROFILES, and if a user has been assigned a profile other than default, it will be in DBA_USERS -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: user holding session even after a re-boot Where can I find their profiles. If your talking about the .profile then is there a Windoze equivalent cuz I'm not on unix. :( Dave -Original Message- Sent: Wednesday, August 15, 2001 11:41 AM To: Multiple recipients of list ORACLE-L I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Usage of Number type for table columns
In this case, I think your boss is right. If you feel the need to have some integrity checking at the DB level, use FKs. CHECK and possibly NOT NULL constraints will subject you to the type of application/database maintenance a well-thought out plan should endeavor to avoid. Just be sure that your use of the foreign key is tightly tied to business rules. As an example, a three digit location code in a telecommunications package could tie back to an NPA_NXX_PAIR_CODE table. If for whatever reason this becomes a four-digit number (skip the technical explanations of why that will NEVER happen, just think of the logical approach - we dial 1 to get long-distance, why not a an additional digit(s) to access a region, kind of like what you do now if you use one of those 10-10 numbers), you will still have a valid app (although you may have to do some updates on existing records). David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rao, Maheswara Maheswara.Rao@Sung To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ardp3.comcc: Sent by: Subject: Usage of Number type for table columns [EMAIL PROTECTED] 08/15/2001 10:41 AM Please respond to ORACLE-L List, In one of our applications, my boss wants to define all the numeric columns as NUMBER or leave it as floating point. He wants to define all the tables like this wherever numeric column is defined in the table. Example: Location_ID NUMBER We know, from our application character, that this location_ID would never cross beyond 3 digits. Also, we know that this specific column does not require any digits to the right of the decimal point. --- (This column is only an example). He does not want to specify any precision or scale for the number type columns. His point is --- Oracle would use only that much space depending on the actual number of digits he enters into the column. Thus, he is not wasting any space. Also, he says, during the beginning of application, we might not know the maximum limits for number column. Hence, leaving them as floating point ( Location_ID NUMBER), gives him flexibility and he need not change the number column precision or scale during the entire life cycle of the application. He says, it is upto the application program (JAVA/EJB) to control and check the maximum length permissible against a column depending on the business rules. I do not know whether this is a correct approach. Intuitively, I feel that this approach is not correct. However, I am not able to come up with any valid reason to negate his approach. Please inform whether the approach is correct or having any problems, from your experience. Thanks, Rao [EMAIL PROTECTED] DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RE: An SQL question , not easy ;-)
I think I have an alternative solution that, if you're using 8.1.6 or better, would provide a pure SQL solution. It's probably not the tidiest SQL, but it works (as far as I can tell): SELECT c1 AS start_time , c2 AS end_time , total FROM (SELECT LAG (call_time, 1) OVER (ORDER BY call_time) AS c1 , call_time AS c2 , incr , SUM (incr) OVER (ORDER BY call_time RANGE UNBOUNDED PRECEDING) AS total FROM (SELECT TO_CHAR (call_start, 'DD-MON-RR HH24:MI:SS') AS call_time , 1 AS incr FROM calls UNION ALL SELECT TO_CHAR (call_end, 'DD-MON-RR HH24:MI:SS') AS call_time , -1 AS incr FROM calls)) WHERE c1 IS NOT NULL AND TO_DATE (c2, 'DD-MON-RR HH24:MI:SS') TO_DATE (c1, 'DD-MON-RR HH24:MI:SS') AND total = (SELECT MAX (total) AS max_sim_calls FROM (SELECT LAG (call_time, 1) OVER (ORDER BY call_time) AS c1 , call_time AS c2 , incr , SUM (incr) OVER (ORDER BY call_time RANGE UNBOUNDED PRECEDING) AS total FROM (SELECT TO_CHAR (call_start, 'DD-MON-RR HH24:MI:SS') AS call_time , 1 AS incr FROM calls UNION ALL SELECT TO_CHAR (call_end, 'DD-MON-RR HH24:MI:SS') AS call_time , -1 AS incr FROM calls))); Jon Walthour From: Lord, David - CS [EMAIL PROTECTED] Date: 2001/08/15 Wed AM 11:01:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: An SQL question , not easy ;-) Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the maximum (and a little histogram) you could amend it as follows: - declare l_count pls_integer := 0; l_max_count pls_integer := 0; begin for rec in ( select call_start time, 1 incr from table union all select call_end time, -1 incr from table order by 1 ) loop l_count := l_count + rec.incr; if( l_count l_max_count ) then l_max_count := l_count; end if; dbms_output.put_line( to_char(rec.time) || ' - ' || l_count || ' ' || lpad('*',l_count) ) end loop; dbms_output.put_line( 'Maximum concurrent calls = ' || to_char(l_max_count) ); end; Regards David Lord -Original Message- From: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Sent: 15 August 2001 15:07 To: Multiple recipients of list ORACLE-L Subject: RE: An SQL question , not easy ;-) David, Here's the output from your suggestion based on a table with the following rows; CALL_STARTCALL_END - - 01-AUG-2001 12:10 01-AUG-2001 12:40 01-AUG-2001 12:15 01-AUG-2001 12:30 01-AUG-2001 12:25 01-AUG-2001 12:55 01-AUG-2001 12:45 01-AUG-2001 12:47 - 01-AUG-2001 12:10 - 1 01-AUG-2001 12:15 - 2 01-AUG-2001 12:25 - 3 01-AUG-2001 12:30 - 2 01-AUG-2001 12:40 - 1 01-AUG-2001 12:45 - 2 01-AUG-2001 12:47 - 1 01-AUG-2001 12:55 - 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Splitting a database: pro and cons
Our setup is one application per database (9 instances and growing), not all databases are integrated, but the majority are. Some of the things to consider : If one database goes down, the others have to right away. Or at least those ones that have integration. As we are a distrubuted environment, we may not be able to roll forward our systems in the event of problem (this is something I been meaning to post to the list to see if I am correct). The level of complexity increases, not only do you have to support the application, but you now have to support the integration. When creating a test environment you have to copy both databases to ensure the integration is intact. If using snapshots, if one database goes down, a large number of snapshot errors are generated on the alert.log. Unix scripts are a little more complex as you now have to consider a number of databases as opposed to one, with each database having its own setup. You can now tune the database for that particular application, as opposed to trying to balance it. Darren -Original Message- Sent: August 14, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Hi list, I have two applications running against one database (in fact I have a few but for the sake of this question two are enough). The two apps have different upgrade patterns and I would like to split them in two databases that will be on the same unix server. There are some views that are used extensively that join data from both apps/schemas, and after the split those should be made using db links. I did some tests and comparisons of queries going through links versus running them directly on the database, and did not see a lot of difference. Does anybody see or know of any downside in splitting the database in two :-(. And any advantage :-). What is the general strategy when installing different apps (from different vendors) - put them on separate databases or combining them. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: user holding session even after a re-boot
Kevin, I believe that is because Oracle on NT is a single multi-threaded process where one can handle this easier. On HP-UX and most other Unix variant OS's that I know Oracle runs as a bunch of independent processes, including the dedicated servers, and consequently it's harder. BTW: the behavior you state is true on HP when your using shared servers. Dick Goulet Reply Separator Author: Kevin Lange [EMAIL PROTECTED] Date: 8/15/2001 8:40 AM I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles. -Original Message- Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query SELECT sid,serial#,osuser from v$session; That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal?? 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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Lost of all Control Files
If did 'alter database backup control file to trace' prior to your control files going bad check your user dump directory. Open that control file (it'll have .trc extension). They syntax will be right there. You will have to edit it deleting unnecessary info. HTH, [Lyuda Hoska] -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files Thanks, And what is the sintax of the create controlfile command ? How do I use it ? Now I will backup them :-) Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado el: Wednesday, 15 August, 2001 10:37 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs. You will loose the archiving and RMAN (if you have it) info though. At least you will not forget now to backup control files regularly ;-). Djordje -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 10:22 AMTo: Multiple recipients of list ORACLE-LSubject: Lost of all Control Files Hi gurus, When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1) Ora-00202 'c:\oracle\oradata\control01.con' Ora-00207 I have 3 controlfiles, no copies, sorry, shame. In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error. Don't know what to do. I don't have backups of the control files. Saludos, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Re: auditing ... getting offending SQL ??
On Mon, 13 Aug 2001, [EMAIL PROTECTED] wrote: Who is the vendor for EZSQL? Do you have a web site for them? www.google.com, type in ezsql and the first thing you get is http://www.ezsql.net/ -- Galen Boyer It seems to me, I remember every single thing I know. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: An SQL question , not easy ;-)
Hi All: There's one really neat thing about this thread...it's helped me solve an on-going problem. I've got managers who want to see graphs of their system's usage. Using this mechanism applied against the DBA_AUDIT_TRAIL view works perfectly. Thanks! Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JMS vrs AQ
Never got an answer from my JMS person here. Which we don't technically have one. I do know we have two topics, one used for all the price feeds, and one for the heartbeat and trade updates. I believe it is on a Raid 1 (Veritas VM) volume. There are a few disks for Export and other such unix mount points, and it is on it's own set of disks under /opt. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 5:51 AM To: Multiple recipients of list ORACLE-L Hello Christopher, How many queues do you have on how many disks ? We have 10 queues on 10 disks E4500 also. Regards Henrik --- Experience is a hard teacher because she gives the test first, the lesson afterward. -- Vernon Law Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Tue, 31 Jul 2001, Christopher Spence wrote: -!-Using JMS on E450 on Solaris we are lucky to do 4/s without having problems. -!- -!-300/s would be great. -!- -!- -!-Walking on water and developing software from a specification are easy if -!-both are frozen. -!- -!-Christopher R. Spence -!-Oracle DBA -!-Fuelspot -!- -!- -!- -!--Original Message- -!-[mailto:[EMAIL PROTECTED]] -!-Sent: Tuesday, July 31, 2001 4:00 AM -!-To: Multiple recipients of list ORACLE-L -!- -!- -!-Hello, -!- -!-Which performance do you need ? -!-We have really bad performance with AQ (300 req/s) or JMS from Oracle. We -!-will use a JMS driver from an other company. -!- -!-Regards -!-Henrik -!- -!-- -- -!-Experience is a hard teacher because she gives the test first, the lesson -!-afterward. -!- -!--- Vernon Law -!- -!-Henrik Ekenberg Anoto AB -!-Direct+46 (0)8 410 78 577 Vasagatan 7 -!-Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden -!-www.anoto.com Switchb. +46 (0)8 410 78 500 -!-E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -!- -!- -!-On Mon, 30 Jul 2001, Christopher Spence wrote: -!- -!--!-I was wondering if anyone has compared performance of JMS and AQ, used -!--!-both, or know of some good documents. -!--!- -!--!-We currently use JMS, which I have never been a fan off, I am not much -!--!-of an AQ person. -!--!- -!--!-Any feedback would be great, I think I am going to setup some benchmarks -!--!-with AQ and JMS. -!-We use very small amount of JMS right in database, -!-and most of our JMS -!-is via separate JMS file systems. -!--!- -!--!- -!--!-Walking on water and developing software from a specification are easy -!--!-if both are frozen. -!--!- -!--!-Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA -!--!-Oracle DBA -!--!-Phone: (978) 322-5744 -!--!-Fax:(707) 885-2275 -!--!- -!--!-Fuelspot -!--!-73 Princeton Street -!--!-North, Chelmsford 01863 -!--!- -!--!- -!--!- -!--!- -!- -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] [EMAIL PROTECTED] -!- -!-Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 -!-San Diego, California-- Public Internet access / Mailing Lists -!- -!-To REMOVE yourself from this mailing list, send an E-Mail message -!-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the -!-message BODY, include a line containing: UNSUB ORACLE-L (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). -!- -- Please see the official ORACLE-L FAQ:
Re: computer history stories - Now: IQ, etc.
Boivin, Patrice J wrote: P.S. Are Orasoruses herbivores, or carnivores? i thought they were omni[back]vores.;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. It said, Insert disk #3, but only two will fit! -- 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).
Re[2]: Usage of Number type for table columns
Wednesday, August 15, 2001, 2:10:58 PM, David wrote: If for whatever reason this becomes a four-digit number (skip the technical explanations of why that will NEVER happen, just think of the logical approach - we dial 1 to get long-distance, why not a an additional digit(s) to access a region, kind of like what you do now if you use one of those 10-10 numbers) To reinforce what David said, I remember when those 10-10 numbers used to be just 10 numbers. I used to dial 10288 to get ATT, not I believe I'd need to dial 1010288. I don't recall what the reason was for the expansion. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- 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).
RE: Speed up Truncate tables
You are correct, unless your using 9i, you cannot alter the initial extent without dropping the table. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 15, 2001 3:07 PM To: Multiple recipients of list ORACLE-L Thomas, are your sure you can change the initial extent? My senior dba told me once it is not possible; you have to drop and recreate table if there is a need to change Initial extent. I am going to play with it today. -Original Message- Sent: Wednesday, August 15, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Chuan, Kevin is correct. If your truncate table is taking a *long* time (and the table is not locked by another process), it's because your storage params are incorrect for the amount of data you are holding. Look at initial and next in comparison with the number of extents (DBA_EXTENTS view) for the table in question, and modify them before you load the data. You can modify the INITIAL extent by issuing an 'alter table allocate extent(size x)' command to grow the INITIAL extent. You can also modify the NEXT extent by issuing an 'alter table storage (next x)' command to change the NEXT extent. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 15, 2001 11:02 AM To: Multiple recipients of list ORACLE-L I had the same problem when truncating a huge table (24 Mill rows). It turned out that the reason my table was taking so long was the amount of extents I had on it. I could look at what was actually happening during a truncate and it had to go and take each individual block and put them back in the available lists. Well, after changing the settings on the table to make larger extents (and therefore fewer) the truncates on that table went hundreds of times faster (we had real bad settings on that table before). You might investigate your storage parms and see just how many extents you do have on that table. -Original Message- Sent: Wednesday, August 15, 2001 3:10 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to speed up the truncating a big table with 12 million rows? Basically, I implemented truncating that big table on Production, but it affected the performance much, so I had to stop it in the middle of way. All the rows were truncated but the HWM was not shrunk at all. I want to do it again to get the space back. Is there any way to speed up this process? Platform: Oracle EE8.0.6 and Solaris 2.7 Thanks a lot in advance. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet