Re: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as
Thanks Tanel, Frank is on top of it already. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/30/2004 08:24 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: [Fwd: ! READ THIS - [EMAIL PROTECTED] is shutting down as Jared, I think you should ask the maintainers of orafaq.com to update their information about oracle-l as well, it's the first hit in google when you search for oracle-l. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 30, 2004 5:44 PM Jared Still scribbled on the wall in glitter crayon: A repost of a previous message. This is the last day for this address folks. good-bye fatcity my old friend, won't get to talk to you again... -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] This planet has -- or rather had -- a problem, which was this: most of the people living on it were unhappy for pretty much of the time. Many solutions were suggested for this problem, but most of these were largely concerned with the movements of small green pieces of paper, which is odd because on the whole it wasn't the small green pieces of paper that were unhappy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
The Windows service implements Oracle's VOS ( virtual OS ) This is not noticed on *versions, as there is no separate step. See James Morle's book 'Scaling Oracle 8i'. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/30/2004 07:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star Dharminder, Changes the service to AutoStart when the machine reboots. As Thomas said, the NT service has to be running for you to be able to start the database. The service will stay running even if you shut the database down. Think of the service as a backgrouond placeholder for the database. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. Dharminder SofthomeTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] dharminder cc: @softhome.net Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
Bye...
bye...
[Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as of
A repost of a previous message. This is the last day for this address folks. --- [EMAIL PROTECTED] is shutting down as of 1/31/2004 If you have already subscribed to the new location for Oracle-L, then you may discard this message. To those of you still reading: [EMAIL PROTECTED] will be offline as of 1/31/2004. You will not longer receive posts from Oracle-L as of 1/31/2004, and you will not be able to post to [EMAIL PROTECTED] as of 1/31/2004. The last day for this address is 1/30/2004. The new address is [EMAIL PROTECTED], and instructions for subscribing to the new address may be found at the following URL: http://www.cybcon.com/~jkstill/util/maillist/maillist.html Thanks for reading. Jared ( List Owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNION ALL Query: Riddle
If what you are describing is completely accurate, ( no DML, change S_A_S fixes the problem ) then it would appear you have encountered a bug. A search on MetaLink is in order, and failing that, you need to open a TAR. Jared On Thu, 2004-01-29 at 04:59, Wendry wrote: I have the same problem like you Rajesh, the query also gives different rowcount each time executed eventhough there's no one updating base tables, in my opinion it's because of the sorting operation (your group by clause). In my case after I remove some group functions, the result goes well. Also I reduce the use of order by clause where it's not needed. I still haven't found the exact solution to this problem. But just now I've tried to decrease the sort area size parameter value (I think I oversize it), and run the query again, the result goes stable with the problematic query but it runs slower. I haven't tried intensively, I try to do that tomorrow. Meanwhile if, there's any of the Gurus can give us clearer explanation, please do so... Thank you all in advance. Regards, Wendry. -Original Message- Pillai, Rajesh Sent: Thursday, January 29, 2004 2:24 AM To: Multiple recipients of list ORACLE-L Hi Jared, Thanks for your response. different results mean that number of records are different sometimes, and sometimes the some of the quantities are not correct. Your help is really appreciated. Thanks, Rajesh -Original Message- Sent: Tuesday, January 27, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Q: What does different results mean? Different row count? Completely different data? Partially different data? Some columns have incorrect value? What about doing it without the parallel hints? The tables aren't so big that it would take a long time to find out. Jared Pillai, Rajesh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/27/2004 01:09 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:UNION ALL Query: Riddle Hi All, The following query is giving different results in each run. I assure that no data modified between consecutive runs - INSERT /* append parallel (z,8) */ INTO some_table (SELECT /*parallel (a,8) */ a.item, a.loc, SUM(a.qty_type_1), SUM(a.qty_type_2) FROM (select /*parallel (x,8) */ item, loc, qty_type_1, to_number(NULL) from table_a x UNION ALL select /*parallel (y,8) */ item, loc, to_number(NULL), qty_type_2 from table_b y ) a GROUP BY a.item, a.loc); Additional info - Number of records in table_a and table_b is around 3M and 6M. SQL select * from v$version; BANNER Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I would appreciate any help in solving this mystery and all hints are welcome. Thanks, Rajesh Pillai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City
Re: [Q] wait time /lob def
That is an interesting use of an alternate block size Jonathan. Jonathan Lewis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/29/2004 09:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: [Q] wait time /lob def There is a note in one of the manuals about nologging lobs (or nocache lob, I forget which) that points out that the unrecoverable SCN for file that holds the LOB has to be updated in the control file whenever the LOB is updated. If you actually have a performance problem because of this - i.e. if lots of people/processes are running slowly because they are waiting on control file writes - then you might want to make the LOB cache/loggong. But control file writes are not inherently a bad thing to be blocked. Of course, if the LOBs are quite large, then the time taken to write the LOB may be far greater than the time taken to update the controlfile - which would make any concerns about the controlfile update irrelevant. So there is no 'obvious' correct answer to your question, without examing your current activity. The note (which I think Steve Adams' also has on his website) mentions an event that can be set to stop the controlfile update when the LOB is updated. This may not be a good idea, though, as it may affect some aspects of recoverability. If you do make the LOB 'cached', then remember that all reads and writes go through the db_block_buffer, which could affect all the other I/O activity adversely, so you might want to consider putting the LOBs into a tablespace with a non-standard block size so that the LOB activity doesn't affect the rest of the cache. (You do also have the option in more recent versions of refining the caching properties so the LOB can be readcache only, writecache only or read/write cache or nocache, I believe). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk
RE: !!Please Read - Oracle-L is moving!!
You sir, have obviously never done this. I have. :) Nor read my first post on the matter. No, it would not be easier, not by a long shot. This is free service, so my thinking is, share the workload. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/27/2004 11:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: !!Please Read - Oracle-L is moving!! Hi List Manger- Couldn't a immigration of our subscribed accounts been the most logical and error free option ? All this fire would have been avaoided. CSW Simon.
Re: measuring TPM
My reply would be something along the lines of A transaction as you would like it to be measured is best measured in the application. I can provide you with IO per minute, broken down into reads and writes, and a number of other statistics. What they are asking for cannot be measured from database statistics, as the oracle concept of a transaction is a unit of work terminated by a COMMIT or ROLLBACK. eg. SAP can provide the type of metrics they want via its BASIS admin utilities. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/2004 07:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:measuring TPM I've been asked to provide value for the Transactions Per Minute going through our primary OLTP production database. I believe I can use deltas in SCN values to measure transactions which do INSERT/UPDATE/DELETE and then COMMIT; Is there any way to measure/count the number of SELECTs which occur? If so, how? How would you derive a value for TPM for your DB? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNION ALL Query: Riddle
(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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] wait time on stat
How did you determine the size of the logs?
Or are you just guessing that they are significantly
less than 250m?
Could just be a very busy database that needs redo
and controlfile on faster disk.
Jared
On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
Increase redo logs to 250M each. You're checkpointing.
On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
WE have ORACLE 9.2.0.3 database run under Win2000. I
run statspack and found Top 5 timed event. Look
like control file parallel write and redo file
parallel write take lots time. How to fix?
Top 5 Timed Events
~~
% Total
Event
WaitsTime (s) Ela Time
---
control file parallel write
5,499 1,14190.37
CPU time
97 7.70
log file parallel write
1,305 12 .95
db file parallel write
162 6 .44
log file switch completion
10 2 .16
-
Wait Events for DB: 9IDEV Instance: 9idev Snaps: 5
-6
- s - second
- cs - centisecond - 100th of a second
- ms - millisecond -1000th of a second
- us - microsecond - 100th of a second
- ordered by wait time desc, waits desc (idle events
last)
Avg
Total Wait waitWaits
Event Waits Timeouts
Time (s) (ms) /txn
--
-- --
control file parallel write 5,499 0
1,141207211.5
log file parallel write 1,305 1,299
12 9 50.2
db file parallel write162 0
6 34 6.2
log file switch completion 10 0
2204 0.4
control file sequential read3,827 0
2 0147.2
db file sequential read 176 0
1 7 6.8
direct path write 92 0
1 6 3.5
log file sync 14 0
0 33 0.5
log file single write 20 0
0 13 0.8
log file sequential read 35 0
0 6 1.3
direct path read 92 0
0 2 3.5
SQL*Net break/reset to clien 44 0
0 0 1.7
SQL*Net more data to client 7 0
0 0 0.3
async disk IO 4 0
0 0 0.2
virtual circuit status 6,826496
19,650 2879262.5
wakeup time manager 530530
19,179 36187 20.4
SQL*Net message from client 6,457 0
12,084 1871248.3
jobq slave wait 402381
1,227 3051 15.5
SQL*Net message to client 6,458 0
0 0248.4
-
Background Wait Events for DB: 9IDEV Instance: 9idev
Snaps: 5 -6
- ordered by wait time desc, waits desc (idle events last)
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dba1 mcc
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Problem with jobs
Have you checked DBA_JOBS for the last/next execution times? Is the job broken? Please check DBA_JOBS. Jared On Mon, 2004-01-26 at 06:04, Mauricio Vlez wrote: Hi, This is the situation: I'm woriking on NT and there are two 8i databases on it One database can execute jobs normally, but the other one not execute any job. I proved submitting the same procedure to both databases and worked on the first one but not on the second one. If I manually execute this:(On the database that have the problem): Exec dbms_job.run(job_number); Then the job is successful executed (without any error) and is programmed to the next interval but after that its not executed any more. And It doesnt appear broken (Its like the queue process were not working). I know all jobs are not executed because the column last_date on dba_jobs its not updated on any job (so next_date column its not updated) and the procedure of each job are not doing what they must do. Its happens since one week ago and before that they were working well. When I submit the Job I issued commit and I dont receive any error message So the Jobs doesnt appear broken (Its like the queue process were not working) But the initialization parameter are job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file So I repeat, the jobs were working well until one week ago, and I havent change nothing special on database. the view dba_job_running appear empty all the time. I removed all jobs and I recreated them again and it didnt resolve the problem. Im not using Oracle Enterprise Management, so I cant see diagnostic error messages and in the alert file it doesnt appear nothing related with the jobs. So early at morning I have to run the jobs manually Im thinking on shutdown down database but I want It to be the last option. I hope you can help me Thanks Mauricio __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: When does Oracle use 'Index Fast Scan'
Of course you also need to consider the application. Will there be large number of users? Does this query run often, or just occasionally? Scalability comes into play, and a method that requires fewer oracle resources ( latches ) is preferable, if possible. Jared David Hau [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/27/2004 08:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: When does Oracle use 'Index Fast Scan' This is where the access time of your disks (or SAN) makes a difference. If your disks have really fast access time, then a random-access pattern would not cause much performance degradation and so a range scan would not be slow at all, even though it's traversing the b-tree index structure. If you're only striping together disks with relatively slow access time (e.g. using a striped IDE disk array), then you have high throughput but not that fast an access time. In this case, fast full index scan would be much faster than an index range scan because the fast full scan reads the blocks sequentially and a sequential disk I/O requires only positioning the head once (assuming the disk is not fragmented). The rest of the time depends on the throughput. If you stripe together a large enough number of IDE disks, then your throughput is great but your access time is still the access time of a single IDE drive which is not that fast. This is assuming you need to do a physical I/O to obtain the blocks. Of course, if the blocks already reside in the buffer cache, then it's a different story. Regards, Dave [EMAIL PROTECTED] wrote: btw, in many cases range scan is faster than a fast full scan. Range scan recursively hits the nodes that are needed and skips the ones that are not. So it reads less blocks. So if you are looking for a 'range' or a specific value, range scan beats fast full scan most of the time. Less Logical and Physical I/Os. test it and hint your queries From: David Hau [EMAIL PROTECTED] Date: 2004/01/26 Mon PM 10:34:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: When does Oracle use 'Index Fast Scan' Correction: the Index Range Scan can be parallelized when it involves multiple partitions. - Dave David Hau wrote: I assume you're talking about the Fast Full Index Scan. This is used when the index contains all the columns necessary to answer the query. It's faster than a Full Table Scan because indexes are smaller than entire rows, so a Fast Full Index Scan will scan fewer blocks than a Full Table Scan. It's faster than an Index Range Scan firstly because Fast Full Index Scan scans the blocks in sequential order, whereas the Index Range Scan traverses the B-tree index structure in scanning the blocks, resulting in a random access I/O pattern which is slower. This is also why the Oracle documentation says that with a Fast Full Index Scan, the result is not sorted by the index key (because the result is not obtained by traversing the index structure.) Secondly, the better performance is also because the Fast Full Index Scan uses multiblock reads and is capable of parallel operation, whereas the Index Range Scan is capable of neither. Regards, Dave. [EMAIL PROTECTED] wrote: I have found that the vast majority of time that Oracle chooses this method, my statistics are stale and the query is sub-optimal. One time, Oracle changed from a 'range scan' to this type of scan with a FIRST_ROWS hint and this reduced performance. This is just a full scan of the index, one block at a time right? When would this ever be superior to a Fast Full Scan or a Range Scan? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Hau INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: David Hau INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re: UNION ALL Query: Riddle
Q: What does different results mean? Different row count? Completely different data? Partially different data? Some columns have incorrect value? What about doing it without the parallel hints? The tables aren't so big that it would take a long time to find out. Jared Pillai, Rajesh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/27/2004 01:09 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:UNION ALL Query: Riddle Hi All, The following query is giving different results in each run. I assure that no data modified between consecutive runs - INSERT /* append parallel (z,8) */ INTO some_table (SELECT /*parallel (a,8) */ a.item, a.loc, SUM(a.qty_type_1), SUM(a.qty_type_2) FROM (select /*parallel (x,8) */ item, loc, qty_type_1, to_number(NULL) from table_a x UNION ALL select /*parallel (y,8) */ item, loc, to_number(NULL), qty_type_2 from table_b y ) a GROUP BY a.item, a.loc); Additional info - Number of records in table_a and table_b is around 3M and 6M. SQL select * from v$version; BANNER Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production PL/SQL Release 8.1.7.2.0 - Production CORE 8.1.7.0.0Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I would appreciate any help in solving this mystery and all hints are welcome. Thanks, Rajesh Pillai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What to look for in STATSPACK report
If you're new to perl, setting this up might be somewhat difficult. It requires installing DBD::Chart, which in turn requires some graphics libraries to be installed, among them ImageMagic if I recall correctly. Installing ImageMagic can be rather difficult depending on platform. On Linux it is possible to just install the binaries, other platforms may present problems. YYMV Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L [EMAIL PROTECTED] 01/22/2004 09:19 AM cc: Please respond to ORACLE-L Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: String manipulation
Here is an example for you. You might want to spend some more time studying the instr() function in the SQL manual to understand how this works. :) define t = 'mystr1~mystr2~mystr3' var t varchar2(30) begin select 't' into :t from dual; end; / select substr(:t,1,instr(:t,'~')-1) t1 , substr(:t,instr(:t,'~')+1, instr(:t,'~')-1) t2 , substr(:t,instr(:t,'~',instr(:t,'~')+1)+1, instr(:t,'~')-1) t2 from dual / or the somewhat simpler: select substr(:t,1,instr(:t,'~')-1) t1 , substr(:t,instr(:t,'~')+1, instr(:t,'~')-1) t2 , substr(:t,instr(:t,'~',1,2)+1, instr(:t,'~')-1) t2 from dual / HTH Jared Stefick Ronald S Contr ESC/HRIDA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/26/2004 03:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:String manipulation I'm trying to separate a string into 3 values: The string is: mystr1~mystr2~mystr3 Here is the code so far: 1 select substr(subject,1,instr(subject,'~')-1) first, 2 substr(subject,instr(subject,'~')+1, instr(subject,'~',1,2)-1) second, 3 substr(subject,instr(subject,'~',1,2)+1,length(subject)) 4 from test_table 5 where test_column=1700455 The result I get is: mystr1 mystr2~mystr3 mystr3 The result I want is: mystr1 mystr2 Mystr3 TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED] 210-565-2540
! READ THIS - Oracle-L@fatcity.com is shutting down as of 1/31/2004
[EMAIL PROTECTED] is shutting down as of 1/31/2004 If you have already subscribed to the new location for Oracle-L, then you may discard this message. To those of you still reading: [EMAIL PROTECTED] will be offline as of 1/31/2004. You will not longer receive posts from Oracle-L as of 1/31/2004, and you will not be able to post to [EMAIL PROTECTED] as of 1/31/2004. The last day for this address is 1/30/2004. The new address is [EMAIL PROTECTED], and instructions for subscribing to the new address may be found at the following URL: http://www.cybcon.com/~jkstill/util/maillist/maillist.html Thanks for reading. Jared ( List Owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROWID PROBLEM
You need to understand that Oracle inserts data where space is available in a table, and dependent on previous DML in a table, that could be almost anywhere. If you want to see the data in timestamp order, then order it by that column. And please don't use ALL CAPS. It is difficult to read. Jared On Sun, 2004-01-25 at 07:19, Waleed Haggagy wrote: HI ALL.. I HAVE PROBLEM THE ROWID FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Solaris: Finding the cause for disk space growth
One way to determine where to start looking is via find: find / -mtime -1 -type f -print | xargs ls -ld This will find all files touched within the list day. If you get the gnu version of find, you can use '-mmin -30' to find all files touched in the last 30 minutes. You can then play with sort, and sort on the size of the file and pipe it through head to see the most recently touched files. eg. find /u03 -mtime -1 -type f -print | xargs ls -ld | sort -nr -k5.1|head -5 This command finds all files in the /u03 file system that have been touched in the last day, pipes it to ls, sorts in reverse by file size and then shows you the five largest files. You can run this on /, it will probably take several minutes. Jared Naveen, Nahata (IE10) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 12:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OT: Solaris: Finding the cause for disk space growth Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen
Re: What to look for in STATSPACK report
I run it on Linux. Should work ok on Win2k, though I haven't tried it. The modified YAPPPACK and Perl scripts are at http://www.cybcon.com/~jkstill/util/zips/yapp_chart.tgz Works in 8i and 9i. Jared Quamrul Polash [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 09:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Hi Jared, Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI from ActivePerl before (on Windows 2000). I shall try again. Thanks, Quamrul From: Joan Hsieh Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: Re: What to look for in STATSPACK report Date: Fri, 23 Jan 2004 08:19:25 -0800 Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L 01/22/2004 09:19 AM cc: Please respond to ORACLE-L Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
Re: Oracle 8.1.7 can only use the first 15th indexes?
Ah, we've discussed this system a couple times in the past. Jared PS. Ok, ya'll move to the new list now, ya hear! Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 08:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle 8.1.7 can only use the first 15th indexes? Amen to that. I had a table with about 40 indexes on v7.0.16. I don't think that it was possible that any of them could have been ignored, because all of them were used. I can't verify that, because this system was born and died (subsequently cremated) over 10 years ago and I never thought to check while it was breathing, but like I said, all 40 or so indexes were absolutely necessary... Redesign? Well, according to the architect, this was the perfect design. Over 150 logical entities were encapsulated within this single table, which also happened to be the only table in the entire application (at least in the beginning). Appropriately enough, its name was DATA... on 1/21/04 2:44 AM, Nuno Souto at [EMAIL PROTECTED] wrote: Let's be realistic: any table with 15 indexes PROBABLY needs a little bit of a re-design exercise? ;) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - snip (I assume the report intended to say the first 15 indexes on a specific table, 'cos the data dictionary alone has rather more than 15 indexes). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help - 9ias broke - hostname was changed
Seriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changed Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord David Sent: Friday, January 23, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't see for looking -- David Lord Senior DBA Iron Mountain (UK) Ltd -Original Message- From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Its easy to disable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data. If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that
Re: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Yes indeed, it is genuine. Jared On Thu, 2004-01-22 at 00:29, Venu Gopal wrote: Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To: [EMAIL PROTECTED] Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/ Searchable archives - http://www.freelists.org/archives/oracle-l Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !!Please Read - Oracle-L is moving!!
Well, I did check with them first to ensure the volume would be OK. It is running a bit slow. I'm not sure if it is just freelists.org, or a general internet slowdown. Sending mail from work to home it seems that it is taking much too long. Jared Ron Thomas [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 10:24 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: !!Please Read - Oracle-L is moving!! The list members must be really hammering their servers now. I've tried to sign up using both the web and email methods and have yet to receive a conformation/response. I can see the headlines now, oracle-l slashdots freelists.org ;-) Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] mTo:[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: !!Please Read - Oracle-L is moving!! .com 01/21/2004 11:49 PM Please respond to ORACLE-L Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/. Searchable archives - http://www.freelists.org/archives/oracle-l -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of '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: !!Please Read - Oracle-L is moving!!
Give it a little time, you'll get it. Jared Arnold, Sandra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 11:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: !!Please Read - Oracle-L is moving!! I went through the webpage but never got the confirmation email back containing the code to be entered. -Original Message- Sent: Thursday, January 22, 2004 2:00 PM To: Multiple recipients of list ORACLE-L It's working for me, but slowly. I tried to do it through the webpage and got the first confirmation e-mail back (containing a code to enter on the webpage.) Then I subscribed to the new list, got a second e-mail back to confirm my subscription, and replied to that. I'm sure more things will show up shortly. One caveat though: the first response was caught by my work's spam filter and flagged as spam. -Original Message- Ron Thomas The list members must be really hammering their servers now. I've tried to sign up using both the web and email methods and have yet to receive a conformation/response. I can see the headlines now, oracle-l slashdots freelists.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Arnold, Sandra INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to get unique value using AWK?
And please notice that no sorting of the input is required, unlike awk|sort|uniq
Jared
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/22/2004 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: How to get unique value using AWK?
There is much improved version of awk called perl
and it has something called hashes. Code snippet would
look something like this:
my %Godot;
while (} {
chomp;
if (/\'([^\']+)/ {
next if exists $Godot{$1};
$Godot{$1}=undef;
}
}
foreach (sort keys %Godot) {
print $_\n;
}
On 01/22/2004 11:09:26 AM, [EMAIL PROTECTED] wrote:
Hi All,
My manager wants to get all the unique wait events from the trace
file.
I tried the below but how do i get DISTICT wait event name?
Any help would be really appreciated.
$ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3 $4 $5
$6}'|more
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='library cache lock' ela=
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
nam='SQL*Net message from client'
nam='SQL*Net message to client'
Thanks
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: test please ignore
oops! wrong list, eh? :) EPS - DBA (Group) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 11:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:test please ignore Test new oracle-l -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: EPS - DBA (Group) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What to look for in STATSPACK report
Here's a sample chart. These are generated every morning and available via our intranet. http://www.cybcon.com/~jkstill/yapppack_chart.png Hmmm... Looks like someone is doing a lot of commits at 02:30 and 05:15. Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 09:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What to look for in STATSPACK report
If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 09:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Disk capacity planning
See the Ratio Modeling paper at Orapub.com It is a quick and dirty method for capacity planning. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 01:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: FW: Disk capacity planning Mladen, I agree you can measure how many IOs are being done and how many a disk sub- system, such as those provided by EMC, can perform and still give good performance. What I meant is that it is hard and some would say impossible to estimate how many IOs per sec a new application will do. A combination of paper calculations, testing, experience and looking at comparable systems will help to provide a good estimate. Cheers, Chris Quoting Mladen Gogala [EMAIL PROTECTED]: Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform and they even have tools to measure it. Speaking of monitoring I/O, there used to be an old OS, which is mostly dead today and it used to have command monitor io/item=queue which would show length of the I/O queues per device, which was extremely useful, because you could quickly find out which devices are hot and which are not. On 2004.01.20 04:19, [EMAIL PROTECTED] wrote: Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
Re: pga_aggregate_target and a memory leak
Kirti, you're back! Must have finished the book. :) Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Did you try increasing P_A_T to a larger number? Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? I've been curious as to what the effects would be of having P_A_T too low. Oracle is supposed to grab whatever memory it needs. I'm assuming at this point that doing so involves a different code path as it needs to alloc the memory. Don't know what the cost of that is, haven't tried to test it. It seems likely that the OS was out of memory, regardless of the P_A_T value. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: help
LOL!! Ok, Ashish, the problem is you sent 'help' to the list address. Send HELP to [EMAIL PROTECTED] and all will be well. Ok, now back to work everyone. Jared Odland, Brad [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 07:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Ashish realizing his time is short he crawls to the terminal and with his last remaining strength double clicks the outlook icon, clicks the new button selects New Mail Message button, using the shift key he types H - E - L - P in the message body window and hits send and then CANCEL to stop the spell checker, and then YES to send his message anyway. His message careens through the internet as he slumps to the floor as the world goes dark. The world will be safe now if they can break the code are his final thoughts before oblivion takes him. Minutes later hundreds of Information Systems professionals are reading his message wondering what horror occurred that drove a man to do this. They pause to reflect and then selecting the message in their inbox they press the delete key and go get a fresh cup of coffee. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Funny ... Ashish is from Weight Watchers and asking for HELP my advise ... stop starving yourself ... go eat something. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish Sahasrabudhe Sent: 21 January 2004 14:34 To: Multiple recipients of list ORACLE-L Subject: HELP
!!Please Read - Oracle-L is moving!!
Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/. Searchable archives - http://www.freelists.org/archives/oracle-l -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NEW LYRICS TO BEATLES SONGS - OT but nice
Please, let's not turn this into a bulletin board. Spontaneous humor in a conversation (thread) is one thing, cutting and pasting completely non-relevant articles is another. For those of you that are non-native English speakers, the one thing... another thing phrase means don't do this. Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/20/2004 01:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:NEW LYRICS TO BEATLES SONGS - OT but nice Write in C (Let it Be) When I find my code in tons of trouble, Friends and colleagues come to me, Speaking words of wisdom: Write in C. As the deadline fast approaches, And bugs are all that I can see, Somewhere, someone whispers: Write in C. Write in C, Write in C, Write in C, oh, Write in C. LOGO's dead and buried, Write in C. I used to write a lot of FORTRAN, For science it worked flawlessly. Try using it for graphics! Write in C. If you'veI'll fix this tonight I vow! ...
Re: Spool to Excel File
Strange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com There are 2 versions, one for web output and one for excel output. SYLK allows cell references, etc, if needed, which you won't get with CSV. Jared Mudhalvan, Moovarkku [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 08:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Spool to Excel File Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Developer Mailing List
There is no other list similar to this one. Mark Burgess [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/20/2004 01:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OT: Developer Mailing List Hi Folks, does anyone know if there is a similar mailing list for Oracle development topics? Regards, Mark http://personals.yahoo.com.au - Yahoo! Personals New people, new possibilities. FREE for a limited time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Mark=20Burgess?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Spool to Excel File
If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet! Didn't realize. In any case, Perl is a much superior tool for this. The SpreadSheet::WriteExcel module allow you to write to individual pages in a workbook. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/20/2004 12:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Spool to Excel File SYLK allows cell references, etc, if needed, which you won't get with CSV. Ahh. but you can with my method! If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet! Tom Mercadante Oracle Certified Professional -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Spool to Excel File Strange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com There are 2 versions, one for web output and one for excel output. SYLK allows cell references, etc, if needed, which you won't get with CSV. Jared Mudhalvan, Moovarkku [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 08:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Spool to Excel File Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parallel Query determined by?
No other replies yet, so here goes. First of all, what does it really mean when you say: users are complaining that Precise is showing a whole lot of time in Parallel Sync Wait. Are these end users, or developers? Seems rather curious that users would be mentioning this. Second, what % of wait time do the Sync Waits contribute to? If a small % of total, then there's not much point in spending time on it. Third, is this actually causing a performance problem, or is it just appearing as a 'trouble' item on some monitor? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/20/2004 11:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Parallel Query determined by? I've inherited a system that has a whole lot of indexes set to degree 10 and many tables set to 2 4. The users are complaining that Precise is showing a whole lot of time in Parallel Sync Wait. It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy. Are there various init.ora settings that help the Parallel servers sync up, or is this just too high a setting? I'm suggesting we back of a good many of these things to simply 2 or 4 and then work our way up from there. Some of those indexes set to 10 are only 20 meg and 4 extents. There's no way they are getting 10 on that I would think. Can't find a whole lot on Metalink either. Or a good book on 800 gig warehouses using parallel? -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What to look for in STATSPACK report
You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nrgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS Privilege
If you haven't done so, you need to set the environment variable ORACLE_SID. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 03:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SYS Privilege the password still is chamge_on_install I could connect as a normal user means it's there but not enough privilege to connect as sysdba. -Original Message- Sent: Monday, January 19, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Do you have that password in your password file? -Original Message- Sent: Monday, January 19, 2004 4:14 PM To: Multiple recipients of list ORACLE-L here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM To: Multiple recipients of list ORACLE-L What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
RE: Oracle vs Mysql
If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
Re: Oracle vs Mysql
-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OS authentication; remote login; domain qualification
You must set OSAUTH_PREFIX_DOMAIN=true in the registry to use externally identified domain accounts. I can't recall if the default value is true or false, but try setting it explicitly. Jared On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote: Hi All, The client machine is an NT machine and it belongs to a domain GALAXY Oracle Db server is on Solaris. client sqlnet.ora has the following setting: NAMES.DIRECTORY_PATH= (TNSNAMES) LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log USE_DEDICATED_SERVER=ON SQLNET_AUTHENTICATION_SERVICES=NTS initialization parameters: REMOTE_OS_AUTHENT=TRUE os_authent_prefix = - with an user name Without the domain remote connection is possible.. ** SQL create user USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL grant connect to USER1; Grant succeeded. C:\sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:51:45 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production SQL show user USER is USER1 SQL select username, osuser from v$session; USERNAME OSUSER -- -- SYS oracle USER1 USER1 *** But when i try the username with the NT domain it fails to connect remotely: * SQL create user GALAXY\USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL grant connect to GALAXY\USER1; Grant succeeded. When I connect try using sqlplus /@sn1 it fails C:\sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:49:56 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied What I think issue here is, the connection is thru tns-listener and the NT domain and the server machine are different. Is there any solution for this / Is it possible to connect the remote unix DB server with OS authentication from an NT client with domain name ? Thanks and Regareds B S Pradhan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reset sequence at midnight
Did you request the lock in share mode to request next val ? This would help to reduce the contention. Normal users would then only queue on the exclusive lock that you would take for the fix-up. lock(shared) increment sequence release Good point. No I didn't. :( actually the sequence is lock(exclusive) release increment sequence When the maintenance is done, the sequence requestor must wait on the lock taken by the maintenance routine. Otherwise there is very little waiting on the lock, as it is released immediately. Jared Jonathan Lewis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/14/2004 11:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Reset sequence at midnight Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 7:09 PM Interesting, I've actually had to do this before. Be forewarned that this is not a good method to use for a very busy app, as it does introduce some level of serialization. control access to the sequence through a package Within the package use a function that sets a lock via dbms_lock.request and then immediately release the lock. Did you request the lock in share mode to request next val ? This would help to reduce the contention. Normal users would then only queue on the exclusive lock that you would take for the fix-up. lock(shared) increment sequence release The purpose of this will become clear in a moment. Create a procedure within the package that will be used to reset the sequence to 0. It is not necessary to drop the sequence to do this. eg. drop sequence s; create sequence s start with 100; select s.nextval from dual; declare vs integer; inc integer; junk integer; begin lock(exclusive) select s.nextval into vs from dual; inc := 0 - vs; execute immediate 'alter sequence s minvalue ' || inc; execute immediate 'alter sequence s increment by '||inc; select s.nextval into junk from dual; execute immediate 'alter sequence s increment by 1'; release() end; / select s.nextval from dual; The procedure that does this just needs to take the same dbms_lock.request that the function mentioned earlier takes. The difference is that it does not release the lock until the modification of the sequence is completed. This forces any requests for new sequence numbers to wait for the modification to the sequence to complete. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
List problems
Folks, It seems that a fair number of emails are not being retransmitted to the list. Some of mine and a few others have not appeared in list traffic sent out to subscribers. Searching by author at fatcity.com reveals that the posts made it there, but either are not being sent out, or getting shanghaied along the way. I'll let you know when I find out. I am of course, assuming that some of you will get this one... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: read-only simple snapshot/materialised view refresh
Leng, You didn't mention the frequency of the refresh. I also don't see mention of which database is generating the ora-1555 errors. Jared Kaing, Leng [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/13/2004 09:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:read-only simple snapshot/materialised view refresh Hello everyone, We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 slave. master and slave are on different servers. Snapshots are refreshed by the FAST method using dbms_refresh.refresh. However, do to the extremely high transaction rates on our database, we're getting ORA-1555 when trying to refresh the snapshots. The mlog$ tables builds up and the slave just keeps on falling behind. From what I can see, snapshots are refreshed as a single large transaction. So if there are 500K rows in the mlog$ table, all 500K will be processed in one go. There are no intermediate commits. So my question is: how do you specify a commit point with snapshots? I'm looking for parameters similar to that of the exp and sqlldr utility where you can specify commit points. I've logged an iTAR with Oracle Support and there answer is that it's not possible. ARGH!! Here's another crazy question is - has anyone updated the dbms_refresh package to add a commit point? Or, have you tried to interogate the mlog$ and write a PL/SQL procedure to process the rows in there, thereby having your own commit points? mlog$ provides the primary keys and the DML type. So surely it's just a matter of going through each one of the row and applying it to the slave? TIA, Leng, -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reset sequence at midnight
Interesting, I've actually had to do this before. Be forewarned that this is not a good method to use for a very busy app, as it does introduce some level of serialization. control access to the sequence through a package Within the package use a function that sets a lock via dbms_lock.request and then immediately release the lock. The purpose of this will become clear in a moment. Create a procedure within the package that will be used to reset the sequence to 0. It is not necessary to drop the sequence to do this. eg. drop sequence s; create sequence s start with 100; select s.nextval from dual; declare vs integer; inc integer; junk integer; begin select s.nextval into vs from dual; inc := 0 - vs; execute immediate 'alter sequence s minvalue ' || inc; execute immediate 'alter sequence s increment by '||inc; select s.nextval into junk from dual; execute immediate 'alter sequence s increment by 1'; end; / select s.nextval from dual; The procedure that does this just needs to take the same dbms_lock.request that the function mentioned earlier takes. The difference is that it does not release the lock until the modification of the sequence is completed. This forces any requests for new sequence numbers to wait for the modification to the sequence to complete. Jared Oracle [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/14/2004 09:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Reset sequence at midnight Hi, I have a sequence which i want to reset to 0 at midnight everyday. What is the best way to do this? Db version - 9.2.0.1.0 Thanks Imran -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cold Fusion and Bind Variables
Thanks Suzy, CFQUERYPARM is what he needs. Jared Vordos, Suzy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/13/2004 05:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cold Fusion and Bind Variables Hi Jared, Look at QFQUERYPARM: Usage The CFQUERYPARAM is designed to do the following things: Allows the use of SQL bind parameters. Allows long text fields to be updated from an SQL statement. Improves performance. The ColdFusion ODBC, DB2, Informix, Oracle 7 and Oracle 8 drivers support SQL bind parameters. However, at present, the ColdFusion Sybase 11 driver and Sybase native driver do not support SQL bind parameters. If a database does not support bind parameters, ColdFusion still performs validation and substitutes the validated parameter value back into the string. If validation fails, an error message is returned. Suzy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED] Sent: Monday, January 12, 2004 6:49 PM To: Multiple recipients of list ORACLE-L Subject: Cold Fusion and Bind Variables Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importance of knowing the difference. While it is easy to demonstrate this in PL/SQL or Perl, I have no idea how to do so in CF. A few minutes of googling didn't really turn up anything useful. I'm looking for some examples of using bind variables in SQL as used in Cold Fusion that connects to Oracle 8i. If you have one, the virtual beer is on me. :) Jared
Import foibles
on this system are *so* slow is what made it worth investigating. This 1 gig file took 10 hours to load. On our speedy linux dev box with fast IO it took quite awhile, though I'm not going to run it again to get the exact timing. And that without indexes or constraints. It's sqlloader from now on. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yep.....it's a Monday......
I had an SA do that to my 500G DW once, in the middle of the day. Took a few minutes to figure out why tablespaces were successively going offline... Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/12/2004 08:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Yep.it's a Monday.. almost as good as the SAN CE coming in and instead of formatting the new SAN, format the existing one, wiping out OS/databases/redo logs, etc. joe Bobak, Mark wrote: While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI *Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Server DBA Position
FYI - I'm forwarding this on Lisa's behalf. Please reply to [EMAIL PROTECTED] - Please do not reply to m Please do not reply to the list. - My employer, Fairfield Resorts (www.fairfieldresorts.com) is looking to hire a SQL Server DBA with several years' worth of experience. We are primarily an Oracle shop. It would be nice if this person had Oracle experience, but I don't think that's necessary. He is mostly interested in hiring an experienced SQL Server person. The office is in southern Orlando, FL, and I don't believe relo is included. However, as an employee the benefits are unparalleled. There are boxes and boxes of hardware in the hallway here this company is going to be expanding in the next year and I think it's going to be fun. This is a nice change from the last couple of years here! Resumes can be forwarded to me, I'll be sure my boss receives them. Lisa Koivu [EMAIL PROTECTED] Senior Database Administrator Cendant Timeshare Resort Group 8427 South Park Circle Orlando, FL 32819
Cold Fusion and Bind Variables
Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importance of knowing the difference. While it is easy to demonstrate this in PL/SQL or Perl, I have no idea how to do so in CF. A few minutes of googling didn't really turn up anything useful. I'm looking for some examples of using bind variables in SQL as used in Cold Fusion that connects to Oracle 8i. If you have one, the virtual beer is on me. :) Jared
Re: What is the fastest way to dump oracle data into a human
I also have one in Perl that I use to dump an entire schema to flat files, generating sqlldr parameter and control files as is goes. sqlunldr.pl is part of the PDBA toolkit: http://www.oreilly.com/catalog/oracleperl - click on 'Toolkit' Jared On Sat, 2004-01-10 at 19:39, Rachel Carmichael wrote: Jared has a utility to dump tables to flat files http://www.cybcon.com/~jkstill/util/ on the lefthand menu, under Utilities click on Dump Tables to Flat Files --- Guang Mei [EMAIL PROTECTED] wrote: Hi: I have a program (running on oracle 8173 server) that writes 48 Millions lines of data into various text files . The selected data is from various tables and I have the query pretty much optimized. Now I am trying to find the fastest way to dump the selected data into a text file on the same oracle server. The program (written as a pl/sql package) now works something like this: str varchar2(32767) := ''; NL char(1) := chr(10); -- new line character begin fpn := utl_file.fopen(directory, filename, 'w', 32767); for x in cur1 loop str := str || x.str || NL; -- keep building the str if (length (str) 31000 ) then str := substr (str,1, length(str) -1 ); utl_file.put_line(fpn, str); str := ''; end if; end loop; -- dump the last part: str := substr (str,1, length(str) -1 ); utl_file.put_line(fpn, str); utl_file.fflush(fpn); utl_file.fclose(fpn); end ; The above code works perfect fine now. But I am wondering if there is another way that could increase the writing siginificantly faster. This porgram does not have to be in pl/sql. I can think of a couple of potential approaches: 1. Write a perl program, basically using perl's DBI/DBD to select the data from the database, then calling perl's print to write data into a file. I have not tested this and don't know if it is faster that utl_file.put_line. 2. Write a C program, using ProC to talk to DB, then use C's fopen and fwrite(?) to dump data into text file. 3. Write a C program,using OCI to talk to DB, then use C's fopen and fwrite(?) to dump data into text file. I don't have direct experience with ProC and OCI, so I don't know how faster (or any) it would be by doing Option 2 or 3 above. Does anyone know if I would see siginificant performance boost by using C? Any other suggestions? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups in a DW Environment
/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export / Import Question
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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Suggestions Needed: Latch free - library cache
Tanel, I'm fairly sure that Rachel was not implying that a role could own a synonym, public or private. The point was that using role based privilege management, you either create private synonyms for each user, or create public synonyms. Another alternative is a logon trigger that does an 'alter session set current_schema=schema', though that might become unwieldy with a large number of users, or when forced to work with an app that connects/disconnects repeatedly. Jared On Sat, 2004-01-10 at 10:24, Tanel Poder wrote: Hi! If you intend to use roles to simplify privilege management, you are almost forced to use public synonyms, as you cannot create a private synonym owned by a role. Your other alternative is to hard-code the How can you create a public synonym OWNED by a role? This is new to me, despite the knowledge that roles and usernames are kept in the same base table... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups in a DW Environment
Would it be incorrect to assume that you never do inserts into newly loaded partitions, or updates that could increase the length of rows? 1 pctfree could be problematic in that case. Jared On Sat, 2004-01-10 at 05:04, Ryan wrote: I can understand the concern about ingesting large amount of data. We ingest about 200 GB a night. To get around the archiving problem we make a noarchivelog 'staging' instance, to run our loads. Then we use transportable tablespaces to move the data to production. Its alot quicker and easier to restore a backup copy transportable tablespace than it is to roll forward plus we dont have to generate massive amounts of redo. If you can do your loads in the middle of the night and very few production users are on then, you can put your staging instance right on your production server. We don't do this, but we have them all on the same netapp. If you do this, I recommend using 99 percent free and 1 percent used in order to 'compact' your tablespace. This keeps the tablespace as small as possible and decreases how long it takes to copy. This speeds up the load process(getting data to production), backups, and recovery. We were able to knock a 28 GB tablespace down to 12 GBs. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:04 PM Mohammed, Comments inline... on 1/9/04 2:24 PM, mkb at [EMAIL PROTECTED] wrote: Have a question on backups in a DW environment. Our DW is somewhat small at the moment but projected to grow. I seem to be having a hard time trying to convince the sys admin that I don't want archive logging turned on. To me, it does'nt make much sense. On the contrary, not using archivelog mode is what makes less sense, thus justifying more careful consideration and justification. Archivelogging is the industry standard and makes complete sense in all but a few extreme cases. Have you considered what archive logging actually provides for you, and what is necessary to engineer the same effects on your own? Think it through... He's proposed using EMC BCV's which I've agreed to (and also sounds like a good idea) but also wants to turn on archiving. My thinking is why turn on archiving if I can restore my DB from last night's BCV's and then bring it up to date by re-loading any data that was loaded after the BCV split. The rebuild-then-reload method seems to make sense on paper, but it is the cause of extreme difficultly in actual practice. If you have not yet already implemented a very mature change-management procedure, to record all changes in the database, complete with all of the security to prevent it being bypassed, then you are in for a rough time. Robust change-management and ironclad security always makes sense, but the extra insurance of being able to recover every change using archivelogging makes sense also. Also, on the topic of BCV splits, one of the problems of using BCV splits (or file-system snapshots or similar snapshot schemes) is that, while it makes backups very easy, it does not make recovery any easier. This type of backup-centric thinking is very seductive. What is the purpose of the whole exercise? Taking backups? Or being recoverable? Oracle Recovery Manager (RMAN) is not named Backup Manager for a reason. RMAN is recovery-centric. It seems more complex on the backup end of things (it isn't), but it is undeniably easier on the recovery side of things. Try to work RMAN into your strategy at all times. It is worth the extra consideration. Our system is not 24x7 so we can shutdown before the BCV split. Also, it's not directly accessed by users for ad-hoc queries. Automated processes access the database and build cubes using Cognos tools. Users access these and not the DB directly. Any data warehouse that is shutdown, even for a few minutes, just to take a backup, has been engineered to fail. People keep data warehouses busy on a 24x7 basis just like any other system. So, again I don't see the need for archive logging. Any thoughts? mohammed Hope this helps... -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
Re: Books on rac
Ouch! That's a little harsh isn't Ryan? Especially for a public forum. The first Oracle book I bought was by Mike Ault. It was fairly decent, and was certainly better than just having the manuals. I no longer have it, as it was Oracle 7 specific. The second book was Gurry and Corrigan's. You can find very un-useful books from any publisher. You can also find errors or misconceptions in nearly any Oracle book published. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2004 12:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Books on rac beware the rampant press books. Most of them seem to be total garbage. All in large print with little detail. I didnt think much of the Ault Internals book from Rampant... its basically stuff you can copy and paste from metalink. Dont know about his RAC book. However, all the other non-Ault books from Rampant are total trash. There is another RAC book with some stuff on 10g by a guy who monitors this listserv(Murali Vallath). I have a copy of it, but have not read it yet. Anyone read either of those RAC books? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 3:19 PM Joe, Last year at the midaltantic Oracle users group seminars there was a presentation by Mike Ault what was very informative on RAC with a budget. I believe that he has some decent information available. You might check www.rampant-books.com for his works. Ron [EMAIL PROTECTED] 01/09/2004 2:59:26 PM any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Books on rac
Ryan, This kind of post does not belong on this list. The quote from a private email exhibits some rather bad judgement IMO, even if it was anonymously attributed. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2004 02:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Books on rac OK, that statement wasn't fair. I have not looked at Arup's book. I have no interest in HIPAA. So I shouldn't speak on it. These are the Rampant books I have skimmed through that I do not like. However, I have skimmed through several. All the one's I have looked at appear to have been rushed out. Weak editing. Much of it is practically copy and pasted from the docs or copy and pasted from other books written by the authors. Sorry Arup. I shouldn't have made a statement quite that strong. If you plan on writing a quality book, why would you go with this publisher anyway? The low quality of other books from the press make many people unlikely to buy your book. I recently got an email from a Rampant author who said the following(this person will remain nameless) Don't back down... I feel the same way. I love to write, and it was between other writing Gigs when Don asked if I would write it... so I agreed. They do boiler plate (at least the ENTIRE interview series is Boiler plate), and they do it VERY badly... He swore at me more times than I can count because I cared about my writing and he cared about getting the books out as quickly and inexpensively as possible. I THOUGHT that since Mike Ault and a few others wrote for him, that he was more reputable... - Original Message - From: Arup Nanda To: Multiple recipients of list ORACLE-L Sent: Friday, January 09, 2004 5:14 PM Subject: Re: Books on rac all the other non-Ault books from Rampant are total trash. That's a pretty strong statement, Ryan! Mine is a non-Ault Rampant book; does it count, too? Before you trash the book and commit the statement, can I interest you in at least taking a look at it? http://www.amazon.com/exec/obidos/ASIN/0972751394/qid%3D1073685823/sr%3D11-1/ref%3Dsr%5F11%5F1/104-5146136-6379164 Six months of hard work gotta deserve something better than the recyclebin, I sincerely hope. Regards, Arup Nanda
RE: RAC setup on linux
Rich, Before now, I've not heard of setting localhosts to the real IP address. I've only seen it aliased to loopback ( 127.0.0.1 ). Why would you do otherwise? Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2004 12:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RAC setup on linux Joe, In random order, here's some hints: Make sure you visit Werner's site, http://www.puschitz.com He has all sorts of non-RAC ideas on how to install Oracle on all sorts of RH flavors. Beware that RH AS 2.1 is bloody old. You may have problems with it recognizing your newer hardware. Since this was just a test for us on a pair of 2.4Ghz P-IVs, I said Screw it! and went with RH9, which config'd our Intel D845 MB, the built-in video, and the built-in 100baseT Ethernet (our older 3com 100baseT PCI card for the private network was recognized OK). Something I have not seen anywhere else (perhaps it's just my lack of understand of a proper network setup), but when you are creating the /etc/hosts file, do NOT alias ANY nodenames to localhost! The Cluster Manager will fail. For example, alias localhost to 127.0.0.1 and NOT to 192.168.1.1 (or whatever your public/domain IP address is). If you need to change kernel settings permanently, instead of echoing values to a pseudo-file in /proc on boot, make the change in /etc/sysctl.conf If you want to try OCFS, you *must* follow Wim's guide on OTN (can't remember the URL, but it was an OracleWorld presentation!). Without following that, 1.08 and 1.09 are deathly slow to the point of unusability. Also beware that OCFS won't work out-of-the box with RH9. I patched 1.08, following guidelines that IBM used to patch XFS for RH9. If you want the patched source, let me know. The rest of my notes seem to mostly relate to that MetaLink doc. If you have problems, post here! There's enough of us that have tried it, that I'm sure you'll get an answer faster than Oracle Support. :) HTH! GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, January 09, 2004 1:54 PM To: Multiple recipients of list ORACLE-L Ok spent 1K for hardware, got 2, 2.0Ghz cpu, 1 G of ram, couple of ethernet cards(one for private heartbeat, other to put on internal network) computers and external firewire drive, doing RH AS 2.1, OCFS, etc. gonna build a lab setup next week. any pointers as to what gotchas would be appreciated, otherwise i'll hack my way thru it like usual :) thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Any way to syncronize sequences between database?
see http://www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2004 11:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Any way to syncronize sequences between database? When doing a partial data refresh, using export/import, is there any way to synchronize Sequences between the two databases? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backups in a DW Environment
The license is for the software that interfaces Veritas NetBackup to RMAN. RMAN has an API and NBU has an API. The intersection of the 2 will set you back about $1500 US IIRC. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2004 04:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Backups in a DW Environment I never heard about the required license from veritas and legato. Can someone else confirm that this is necessary? They actually charge you more money to do use another product with veriftas and legato? What is a 'BCV'? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:19 PM Let's assume RMAN is not an option since we don't have a license or busget to use a third party backup tool like Legato or Veritas with RMAN (used in a previous life with Legato NetWorker. Loved it!!) So now I'm left with archive log mode. Archive logs backed up nightly and a full backup once a week. I have to set aside at least as much disk space for the data files as the size of the physical db which will later be copied to tape. Plus, I also need disk space for my BCVs'. I can't have both (budgetry constraints). I'm leaning towards BCV's. Wouldn't it be just as quick to restore the entire BCV as to do an Oracle recovery from tape? Also Gene, you mention that while loading data, you turn off archiving. So if you lost that dbf during a load, how would you recover the db? Restore the dbf, apply the logs and restart the load, right? In the same scenario in my environment I'd just restore the entire BCV set and re-start the load. Not an expert on EMC's BCV technology but my sysadmin says it can be done and yes, I'll test before I sign off on it. True, I'd be nice to have archive logging aswell. But is it a necassity or have we all been programmed into believing that ALL PRODUCTION DATABASES MUST BE IN ARCHIVE LOG REGARDLESS. Should we not be progressing beyond this like we did with hit ratios and one large extents etc...? mohammed - jumping into flame proof suit --- Gene Sais [EMAIL PROTECTED] wrote: I put all databases in archive mode, i.e. dev, test, and production. I can use test db's to test backup/recovery scenario's. The only time they are not in archive mode is when I am doing a major load (import,sqlload,etc). After I am done loading data, I put them back into archive mode. What does it cost you, a few archives? Ha, well worth it :). Gene PS. On a side note, Robert Freeman, your book is a must have using RMAN. Thanks for writing it! [EMAIL PROTECTED] 01/09/04 04:54PM My personal opinion is all production databases should be in archivelog mode. Period. End of story. Less down time, more recovery optionsit's all good. Having said that, given a specific business case, with a specific set of requirements, one could argue for noarchivelog mode, and you might even convince me...but I doubt it...;-) -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 09, 2004 4:25 PM To: Multiple recipients of list ORACLE-L Have a question on backups in a DW environment. Our DW is somewhat small at the moment but projected to grow. I seem to be having a hard time trying to convince the sys admin that I don't want archive logging turned on. To me, it does'nt make much sense. He's proposed using EMC BCV's which I've agreed to (and also sounds like a good idea) but also wants to turn on archiving. My thinking is why turn on archiving if I can restore my DB from last night's BCV's and then bring it up to date by re-loading any data that was loaded after the BCV split. Our system is not 24x7 so we can shutdown before the BCV split. Also, it's not directly accessed by users for ad-hoc queries. Automated processes access the database and build cubes using Cognos tools. Users access these and not the DB directly. So, again I don't see the need for archive logging. Any thoughts? mohammed __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
Re: ORACLE-L Digest -- Volume 2004, Number 008 (Out of Office
At least he's on digest mode. Otherwise I would have unsubscribed him some time ago. On Thu, 2004-01-08 at 04:06, Richard Foote wrote: Let's hope he's not on long service leave :) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 08, 2004 8:44 PM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
Me thinks CBO is probably never going to be bug free. What works for you, won't work for me unless we run identical systems, it is a general purpose system, CBO doesn't know your system or data usage. At this point it would seem beneficial to differentiate between a bug and a logic error. Roughly, a bug would seem to be code that falls into one of two categories: * code that doesn't do what the developer intended * code that generates errors A logic error would be found in code that does exactly what the developer intended, but what the developer intended is the wrong thing to do. This could be expanded to include the inability of CBO to properly identify a usage pattern. just my opinion. Jared On Thu, 2004-01-08 at 08:49, Jamadagni, Rajendra wrote: Me thinks CBO is probably never going to be bug free. What works for you, won't work for me unless we run identical systems, it is a general purpose system, CBO doesn't know your system or data usage. Still it tries to make a better judgment .. Hey it is a whale lot better than those RDBMS where there are no hints to use in case optimizer goes crazy. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 08, 2004 11:29 AM To: Multiple recipients of list ORACLE-L 2- the CBO like any other piece of code, is sometimes buggy? Always, not sometimes Tanel. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A free sql analysis tool
interesting. you might want to hack it for time slices being in uS on 9i, otherwise you get some rather interesting results. Jared On Thu, 2004-01-08 at 02:59, Hatzistavrou John wrote: Dear All, I have found this Perl script that makes an analysis of 10046 SQL trace http://brainshed.com/software/ Kind Regards, Hatzistavrou Yannis -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA position
http://careers.lifetouch.com/Job.asp?Job_id=1050seas=Office+%2D+FullTime The domain name may be familiar, a prolific poster on this list happens to be there as well. The location is Minneapolis, MN, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
Yeah, copped a copy of 10g new features from somewhere, but it was sorely lacking in detail. I seem to have missed the CBO bit. Jared On Thu, 2004-01-08 at 10:49, Jamadagni, Rajendra wrote: Right Jared, But this is where the new 'learning CBO' comes into picture isn't it? in 10g CBO looks at the history and then modified the execution plans. This is all from Oracle 10g propaganda sheets, I'll agree when I see it in action. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 08, 2004 1:40 PM To: Multiple recipients of list ORACLE-L Me thinks CBO is probably never going to be bug free. What works for you, won't work for me unless we run identical systems, it is a general purpose system, CBO doesn't know your system or data usage. At this point it would seem beneficial to differentiate between a bug and a logic error. Roughly, a bug would seem to be code that falls into one of two categories: * code that doesn't do what the developer intended * code that generates errors A logic error would be found in code that does exactly what the developer intended, but what the developer intended is the wrong thing to do. This could be expanded to include the inability of CBO to properly identify a usage pattern. just my opinion. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trigger Question
When an AFTER INSERT trigger is fired (row level) has the row been committed to the database at this stage? No If so is it ok to call a package in the trigger that selects that row and changes some values in the row? No See the following snippet from the fine SQL manual. Jared PS. Your email had a virus attached to it. AFTER Specify AFTER to cause Oracle to fire the trigger after executing the triggering event. For row triggers, the trigger is fired after each affected row is changed. Restrictions on AFTER Triggers * You cannot specify an AFTER trigger on a view or an object view. * You cannot write either the :OLD or the :NEW value. On Thu, 2004-01-08 at 11:24, Nuala Cullen wrote: Hi All, Firstly my apologies if this seems like a very *stupid* question but I'm a tad confused (and it's late in the evening) When an AFTER INSERT trigger is fired (row level) has the row been committed to the database at this stage? If so is it ok to call a package in the trigger that selects that row and changes some values in the row? Thanks, N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
This opens a whole new can of worms. design bug specification bug 'get it out the door, now!' bug 'had a few too many porters when I wrote that bit' bug .. Jared On Thu, 2004-01-08 at 11:59, Jonathan Lewis wrote: - Original Message - Roughly, a bug would seem to be code that falls into one of two categories: * code that doesn't do what the developer intended * code that generates errors Several years ago I raised an issue with Oracle support where something was clearly going wrong - can't remember what, too long ago - and got told that I couldn't get the issue logged as a bug because the code was performing to specification. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trigger Question
Dick, you cannot do that in an AFTER trigger. Jared On Thu, 2004-01-08 at 11:54, Goulet, Dick wrote: Wolfgang, Yes you may, within the trigger only, change values of that row only. it's known as :new.column_name := whatever; Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 2:39 PM To: Multiple recipients of list ORACLE-L I'm sure I will be corrected if I'm wrong. Answers inline At 12:24 PM 1/8/2004, you wrote: Hi All, Firstly my apologies if this seems like a very *stupid* question but I'm a tad confused (and it's late in the evening) When an AFTER INSERT trigger is fired (row level) has the row been committed to the database at this stage? No. You could raise an error as part of what the trigger does in order to reject the action. If so is it ok to call a package in the trigger that selects that row and changes some values in the row? a) it is not so and b) you can not do anything with that row (or that table for that matter) in either the trigger or any called package or procedure. You'll get a mutating table error. Thanks, N. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: data warehouse vs regular database??
The Ralph Kimball answer: A DW is a collection of data marts. A Data mart is typically a fact table surrounded by a collection of dimension tables. The Bill Inmon answer: A DW is a system designed to collect data from an enterprise for the purpose of creating data marts. It is not normally queried by end users, that is what the DM's are for. Regardless of which viewpoint you hold, both are characterized by data being time sensitive: facts are stored with date. Then again, there are databases that do not really resemble either of these, but are nonetheless used as a DW. Where does your database get its data from? If it comes from other databases and/or systems, then it is likely a DW. Google for data warehouse institute, Ralph Kimball and Bill Inmon, and you will find plenty of info. If you want to learn about DW, Kimball's The Data Warehouse Toolkit is a good place to start. HTH Jared On Wed, 2004-01-07 at 09:04, Janet Linsy wrote: Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Difference on ArchiveLog (I'm rewriting the question)
Hmm... Given the amount of data to work with, I would chalk it up to coincidence. I washed my car on Tuesday morning, Tuesday afternoon it rained. Washed it again on Wednesay, it rained again. Didn't wash it Thursday, no rain. If you could establish this pattern for at least 3 successive weeks, you could probably be an advisor to weather.com. There's no pattern in this data. Jared On Wed, 2004-01-07 at 16:14, Tanel Poder wrote: Is your system overloaded e.g. there is a continuous queue of transactions waiting? In that case, with bigger redologs, full checkpoints happen less frequently, allowing database to work faster, thus generating more redo. But, othervise, the archive generation shouldn't be dependent on redolog size. How are you measuring your archive size, just counting number of files/entries from v$archived_log or summing up real sizes of archivelogs? (these may differ noticeably, especially when frequent manual logswitches occur or archive_lag_target is set). Tanel. - Original Message - From: Mauricio Vlez To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 07, 2004 10:49 PM Subject: Difference on ArchiveLog (I'm rewriting the question) Hello Everybody I'm rewriting the question, Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily. I changed the size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily. I think I'ts not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vlez -- Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: table reorganizations
I'm surprised at these responses. Please don't take offense. It appears that you have received some very informative answers in addition to the facetious ones. ( which I *did* expect. Mladen never lets me down. ) To reiterate the point of responses to your question: Running a SQL query to indicate that a table should be reorged to based upon the amount of free space it finds simply doesn't supply enough data to indicate that it's actually necessary. It probably isn't. There are a lot of tuning authorities that make hard and fast rules about how to find problem areas by simply running a few queries. It is unfortunately, not that simple. Or for people like Cary Millsap, Gary Goodman, Steve Adams, Jonathan Lewis and a number of others, it is, fortunately for them, not that simple. ;) Jared On Wed, 2004-01-07 at 12:49, Shrake, Jolene wrote: I'm surprised at these responses. I'm asking what sql statement most people use to identify tables that need reorganization because of holes. We had an Oracle consultant here and he uses Select table_name, blocks-((num_rows*avg_row_len/block_size)*(1+(pct_free/100))) blkdiff From dba_tables Where blkdiff 100; To determine reorganization need. What sql statement is used by others? Jolene -Original Message- Sent: Wednesday, January 07, 2004 2:25 PM To: Multiple recipients of list ORACLE-L I usually recommend Gospel by Jonathan for its completeness and a wide range of subjects. The book you mentioned is great for beginner as well. As for the number 42, I'll continue using it until this Saturday (1/10/2004) when it will become 43. Inflation is not as big as you think. PS: --- I was born on 1/10/1961, and that makes January 10th so special. I don't have to work on that great day, mostly because it's Saturday. On 01/07/2004 03:09:53 PM, Thater, William wrote: Mladen Gogala scribbled on the wall in glitter crayon: Lemme guess: you just started on your new job as a DBA? You are another person to which can only wholeheartedly recommend Jonathan's book. As for your questions, the answer is 42. actually, if she's just starting out, i'd recommend Marlene, Rachel and Jim's book first, then Jonathan's. and are you sure it's not 57 now due to inflation? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] -- -- Perfection of means and confusion of ends seem to characterize our age. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Shrake, Jolene INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Re[1]: OCP question from Boson practice tests
My guess would be that one could pass the exam just by working with Oracle for a couple of years and comparing that to some practice questions, one True. I took the beta OCP tests in 1997, with about 150 questions per test. They were free at OOW, so it seemed like a good price. Three years experience, no problem. Of course, some of my answers were probably incorrect, in accordance with my misconceptions at the time, but they were good enough to pass the test. ;) Jared On Wed, 2004-01-07 at 14:34, Niall Litchfield wrote: Hi all I have a problem with a lot of the commentary on the OCP that I have read here and elsewhere, especially that which focusses on specific questions and the, ahem, 'product features' associated with them. My problem is this. To me the OCP, or rather the OU courses and the associated revision (= what the hell did I do 2 months ago I've got a test now) work necessary to pass the OCP were particularly helpful in illuminating areas in which I was, now what is the expression - ah yes, brain-dead. MTS and connection pooling for example, wonderful stuff, what a good idea. Don't use it myself, don't know how it works and keep getting the acronym confused with Microsoft Transaction Server. Oh what you mean maybe I should at least recognize the term and the idea behind it. Oh very well then. My guess would be that one could pass the exam just by working with Oracle for a couple of years and comparing that to some practice questions, one wouldn't do especially well but 60% or so will pass you. Doing the courses, especially if you get one of those educators who insist on knowing how the thing actually works as well as what the course notes say will be an even better investment. Of course criticism of the OCP based on the fact that it values version specific syntax over DBA/Developer principles is right on the money IMO. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Upgrade
True, but some of use linux to manage those databaeses on MS. On Tue, 2004-01-06 at 04:44, Mercadante, Thomas F wrote: Now now all you MS bigots. Just leave us alone. There are several of us on this list who are forced into using MS because of management decisions. And our systems are running just fine. Just leave us alone. You don't see us posting all of the other op systems problems (all 2 of them). thank you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 06, 2004 6:09 AM To: Multiple recipients of list ORACLE-L I'm confused: did you REALLY expect anything out of microslop to work according to expectation? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Dick, What kind of a nautical person are you??? the NT box will not even make a good anchor because the sides are flat and it will drag on the bottom during a small wind or current. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Upgrade
Yes, I find it highly amusing that the Linux client for Windows Terminal Services (rdesktop) is in some ways easier to use than the Windows client. Have not had need for TightVNC. How do you use it? On Tue, 2004-01-06 at 07:09, Jesse, Rich wrote: Citrix Metaframe, rdesktop, and TightVNC help a bunch, too. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, January 06, 2004 8:59 AM To: Multiple recipients of list ORACLE-L True, but some of use linux to manage those databaeses on MS. On Tue, 2004-01-06 at 04:44, Mercadante, Thomas F wrote: Now now all you MS bigots. Just leave us alone. There are several of us on this list who are forced into using MS because of management decisions. And our systems are running just fine. Just leave us alone. You don't see us posting all of the other op systems problems (all 2 of them). thank you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 06, 2004 6:09 AM To: Multiple recipients of list ORACLE-L I'm confused: did you REALLY expect anything out of microslop to work according to expectation? Cheers Nuno Souto -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (long) Top level heaps/subheaps
explain. Thanks in advance Syed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (long) Top level heaps/subheaps
Yeah I know, did it again. On Tue, 2004-01-06 at 10:19, Mladen Gogala wrote: The name is Breitling. Wolfgang Breitling. Not to be confused with Bond. James Bond. On 2004.01.06 12:34, Jared Still wrote: * to satisfy curiosity * to have a better understanding of how Oracle works Most DBA's probably don't need to know this stuff. Most performance problems will not likely require you to know any of this. If you spend a lot of time solving other people's 'unsolvable' Oracle performance problems, as Steve Adams, Jonathan Lewis, Cary, Millsap, Gary Goodman, Wolgang Breitling ( Hope I spelled his name correctly this time), or many other consultant types on this list then this kind of thing will be very useful to you. Ditto if you have a large number of instances to deal with, and run into tricky tuning problems. Jared On Tue, 2004-01-06 at 08:24, Guerra, Abraham J wrote: Hi all, Why would anybody care about all these heap stuff? How does it help performance Thanks. Abraham Guerra -Original Message- Sent: Tuesday, January 06, 2004 10:04 AM To: Multiple recipients of list ORACLE-L Well, a heap is just a bunch of memory (allocated in contiguous extents) and you can practically allocate any size of chunk of memory from it (with some restrictions). A regular heap has freelist and LRU list mechanisms for managing space in it as well as memory allocation/releasing routines which you can then call. Oracle uses its generic heap manager code (KGH) for managing it's memory. Once you allocate a chunk from heap it's up to the allocator what he does with it. It can just use it for some kind of static data, but can also create another heap in these chunks it allocated, this heap may use different heap manager code for managing its memory if needed (for example shared pool reserved area and large pool behave a little differently, they don't have LRU list mechanisms). If you take any heapdump using alter session set events 'immediate trace name heapdump level x' ; then top level heaps show parent= in their descriptors. Note that this top call heap has allocated chunks for heap with descriptor address 06B51DB0 (callheap) and also you see that callheap has a parent heap with descriptor address 06B52790. HEAP DUMP heap name=top call heap desc=06B52790 extent sz=0x213c alt=92 het=32767 rec=0 flg=2 opc=2 parent= owner= nex= xsz=0xfffc EXTENT 0 addr=071D0004 Chunk 71d000c sz= 112perm perm alo=112 Chunk 71d007c sz=65412free EXTENT 1 addr=07170004 Chunk 717000c sz= 232perm perm alo=232 Chunk 71700f4 sz=60724free Chunk 717ee28 sz= 1352freeable callheap ds=06B51DB0 Chunk 717f370 sz= 1072freeable callheap ds=06B51DB0 Chunk 717f7a0 sz= 1072recreate callheap latch= ds 6b51db0 sz= 3496 ct=3 [snipped] HEAP DUMP heap name=callheap desc=06B51DB0 extent sz=0x424 alt=32767 het=32767 rec=0 flg=2 opc=3 parent=06B52790 owner= nex= xsz=0x53c EXTENT 0 addr=0717EE34 Chunk 717ee3c sz= 1332freeable qkkele EXTENT 1 addr=0717F37C Chunk 717f384 sz= 572perm perm alo=388 Chunk 717f5c0 sz= 444free Chunk 717f77c sz= 36freeable qkkkey EXTENT 2 addr=0717F7BC Chunk 717f7c4 sz= 28perm perm alo=28 Chunk 717f7e0 sz= 956free Chunk 717fb9c sz= 52freeable event string Total heap size= 3420 FREE LISTS: Bucket 0 size=76 Bucket 1 size=268 Chunk 717f7e0 sz= 956free Chunk 717f5c0 sz= 444free Bucket 2 size=1036 Total free space = 1400 UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS: Chunk 717f384 sz= 572perm perm alo=388 Chunk 717f7c4 sz= 28perm perm alo=28 Permanent space= 600 ** If making these full heapdumps puts too much strain on your system, then it might be easier to use event HEAPDUMP_ADDR which allows to dump heaps only with specified descriptor address. There are other options as well, such is X$KSMHP table to query any heap (which is, blah, highly unsupported) or attaching directly to SGA shared memory segment and reading from there. Sorry for too long post, I'm currently too lazy to do anything useful... Tanel. - Original Message - To: Multiple recipients
Re: oracle client on PC's
What is a 'wire-protocol' ODBC driver? Jared On Tue, 2004-01-06 at 11:54, Justin Cave wrote: At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote: Rather than installing the Oracle client on every client PC, we have been: - installing client on 1 PC - copying directory to a network server - extract the registry for oracle key - fix registry that was extracted to reference the network drive - load registry on client PCs - add the network pc as a search drive to the client pc. We are now experiencing problems over the WAN and looking at ways to eliminate the Oracle dll overhead. Short of installing Oracle on every client PC, what are our options? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (long) Top level heaps/subheaps
Piece of cake using vi, perl, or even pl/sql.
vi: 1000iWolfgangENTERESC
perl: print qq{Wolfgang\n} x 1000;
pl/sql: typically more verbose, left as an exercise for the reader.
Oh, you didn't mean paper did you? Not sure I still
know how to do that.
;)
Jared
On Tue, 2004-01-06 at 12:19, Wolfgang Breitling wrote:
Since we're both going to be in Dallas in March I'll have to have you write
my name 1000 times ;-)
At 01:04 PM 1/6/2004, you wrote:
Yeah I know, did it again.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
DBA tasks
What does a DBA do? What should a DBA do? Interesting short list, or maybe not so short. http://dbasupport.com/oracle/ora9i/resolutions.shtml -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Convert to Locally-Managed Tablespaces
yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle client on PC's
Ah, Merant is just down the street, sort of. Maybe they'll loan me one. :) Thanks for the explanation. The concept isn't new, but the terminology is. Jared On Tue, 2004-01-06 at 14:09, Grant Allen wrote: -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 07:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared It's an ODBC driver that either speaks the native network protocol for the DB by itself, or talks via a very thin layer to a server side component that then translates. Both options mean no typical DB client is required on the machine running the ODBC app. Merant/DataDirect/Whatever-they're-called-this-week make quite a few of these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora1652 question...
John has already shown you how to generate a trace when an error is encountered via the 'events' mechanism. If you would like to see what events are available, peruse the file $ORACLE_HOME/rdbms/mesg/oraus.msg if you are on *nix. If you are on win32, the file is unfortunately not available. Start with error code 1. There may or may not be an explanation for an event in that file. Jared On Tue, 2004-01-06 at 15:44, John Kanagaraj wrote: Chris, There are two options: 1. Easier, but requires a bounce : Add the following event into init.ora event=1652 trace name processstate level 10 This will dump the processstate for processing that encounter an ORA-01652. And you can even add the following to capture 1555 and 4031 errors event=1555 trace name errorstack level 3 event=4031 trace name errorstack level 3 **BUT**, keep _all_ 'event' lines together in the file (just as with utl_file_dir entries) 2. Harder (requires coding/testing), but better control and options: Create a System-level ON SERVERERROR trigger and check for 1652 (among others) and record all the details into either alert.log (via dbms_system.ksdwrt call), database table, utl_file etc. Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 2:10 PM To: Multiple recipients of list ORACLE-L Subject: ora1652 question... Is there an event to set where I can identify any sql that receives a 1652 error message? There is some process running each night in a reporting database that has been generating this error for the past week. I figured someone would complain. That didn't happen so I went and asked the reporting people if any of the reports were blowing up. They said no. I just set up statspack and will run that every 10 minutes tonight. I also have a query that will capture the session info on sessions currently sorting that I will run every 10 minutes. Neither of the techniques are very direct. I would imagine there is an event to set so that I can generate a trace file. Any other suggestions of nailing this down would be appreciated. ..and so I don't have to ask about events anymore...where do I find what event means what? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Job question
I can answer that for you, as I had a discussion with them 2+ years ago. 2 reasons: * They don't pay nearly enough for a senior DBA. The job requirement is really for a junior, and the pay is probably OK for that position. * They lost 50% of their business last year, and unless they do something innovative, or get really lucky, they won't recover from it. The person they are replacing is a former co-worker: he retired and is now in Hawaii. :) Jared On Sun, 2004-01-04 at 09:54, Don wrote: Metro One Telecommunications (Beaverton, Oregon) keeps advertising for an Oracle DBA. Any idea what is going on there that they can't seem to hang on to folks? I see that their stock price has has dropped to almost worthless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: stress testing
The patch I refer to is one I made that didn't make it into the most recent version of yapppack. YP uses an array as internal storage, and walks through it with a for i in 1..n loop. Since arrays are sparsely populated there is a fair chance of hitting an array element that does not exist. The patch consists of rewriting the loop with array.first/next/last in a while loop to avoid the problem. Yes, it is high level, but it can pinpoint time periods that you may want to investigate. Jared On Mon, 2004-01-05 at 06:19, Poras, Henry R. wrote: Jared, Are you talking about yapppack? I've been using that for a while (nice display. Though like statspack it is system wide so I usually just look for high level stuff and changes). Not aware of a patch though. With most peoplesoft applications I have seen, the bottlenecks aren't database related, though I still need to get all appropriate data. That means application server, OS (NT for app server, Sun for Oracle), web server, ... stuff too. I'm still trying to find what numbers the tool itself gathers, and if/how it analyzes the stuff. In the meantime, I've been reviewing some of the papers on orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and Throughput). Thanks. Henry -Original Message- [EMAIL PROTECTED] Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared Poras, Henry R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Convert to Locally-Managed Tablespaces
On a gig of data, you could easily export the data and re-import into new locally managed tablespaces. An alternative is to use the dbms_space_admin package to convert DD managed tablespaces to locally managed. This is what I will need to use on our systems, as there are about 400 gig of data and indexes. 200 gig of data is too large to export/import, at least it is for this project. So dbms_space_admin it will be. IIRC one of the drawbacks of using dbms_space_admin to convert is that you won't be converting to nice uniform extent sizes for existing data. The DD data for the existing extents is simply converted to bitmaps. The advantage of getting extent mgt out of the DD should outweigh that IMO. There may be other drawbacks, I haven't started on this project yet. I'm sure someone else on the list can respond with some experiences. For 1 gig of data though, I personally would just go the export/import route. HTH Jared Paula Winkler [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/05/2004 02:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Convert to Locally-Managed Tablespaces Hi all, I'm not sure if this question has been posted or not. I inheritated an Oracle9i (9.2.0.4) database which contains all dictionary-managed tablespaces. This small database is approx. 1 GB and resides on a HP server. I plan to convert all the dictionary-managed tablespaces to Locally Managed tablespaces. What is the best approach to accomplish this? Thank you in advance for your help! - Paula W. Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: oaktable people
I've heard that Steven Feuerstein has a new book on the way, though I have been unable to find any reference to it. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/05/2004 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oaktable people
That would be nice. It's already indispensible. Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/05/2004 04:19 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: oaktable people oh yeah. James Morle sent me an email today and said he may expand his really good book to 2 volumes... - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, January 05, 2004 6:49 PM Subject: Re: oaktable people I've heard that Steven Feuerstein has a new book on the way, though I have been unable to find any reference to it. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/05/2004 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oaktable people
He didn't, but nonetheless I thought it was something that you and others might be interested in. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/05/2004 04:19 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: oaktable people when did fuerstein join oaktable? http://www.oaktable.net/pageServer.jsp?body=members.jsp btw, are the only Americans members of Oracle or former members of Oracle? - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, January 05, 2004 6:49 PM Subject: Re: oaktable people I've heard that Steven Feuerstein has a new book on the way, though I have been unable to find any reference to it. Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/05/2004 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:oaktable people Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HOTSOS Conference
While perusing the HOTSOS site, I noticed that the deadline for the discounted registration for the HOTSOS conferences ends after tomorrow. If you're thinking of going, you may want to check it out. Along those same lines, how many listers will be there? We could get together on Tuesday evening for dinner/drinks if any are interested. Possibly some of you with Dallas connection can recommend a suitable location. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Convert to Locally-Managed Tablespaces
Tanel, That's a good idea. I briefly considered this, but didn't really dig into it. The systems I need to do this on is our SAP systems, and downtime is a precious commodity, especially for production. I just may try this on our test system. The problem with SAP of course, and many other ERP's is that there are 22k+ tables, which could consume a bit of time. The amount of fragmented space that would be recovered is probably not worth the trouble of this procedure, depending on how much time it takes. I see that you too need to keep the original tablespace names, is this SAP per chance? If you have already performed a test of this, what kind of times are you seeing, along with relevant platform information, and the number of tables/indexes? Jared On Mon, 2004-01-05 at 16:49, Tanel Poder wrote: Hi! This is what I will need to use on our systems, as there are about 400 gig of data and indexes. 200 gig of data is too large to export/import, at least it is for this project. So dbms_space_admin it will be. I'm about to do a reorg+conversion of a 250GB 8.1.6 database in next week, here's what I'll do (there is practically no free space for temporary usage): 1) Export index definitions (normal export with rows=n) 2) Drop all indexes 3) use alter table move with parallel 16 and nologging to move all tables to old index tablespaces (the indexes consumed more space than tables) 4) drop and recreate data tablespaces 5) use alter table move again to move tables back (the segments have to reside in original tablespaces, otherwise I could have skipped this step) 6) drop and recreate index tablespaces 7) get index definitions out of exportfile and modify them to add parallel nologging (with big sort area size) 8) rebuild indexes 9) do a full backup It might help to recreate index tablespaces even before step 3, to speed up parallel table moving a bit.. Maybe you want to test this Jared, this approach is much faster than export/import, because everything can be done with direct path operations and nologging (import doesn't have direct path facility, so regular array inserts are used, which always require logging as well). Also, your tables/datablocks will be optimized after moving them (which is not the case with dbms_space_admin) and you don't have to have any space for reorg in case your cleared index tablespace can temporarily accommodate your data. IIRC one of the drawbacks of using dbms_space_admin to convert is that you won't be converting to nice uniform extent sizes for existing data. Yes, and if your tablespace is fragmented, the fragmentation will remain there, despite your conversions (of course, smaller extents might be able to use some of this fragmented space later on). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFA document
You may also be interested in Bill Burke's OFA on Steroids http://www.oracleguru.com/docs/ofa_guidelines.doc On Sat, 2004-01-03 at 15:04, Pete Finnigan wrote: Hi everyone I need to reference the official OFA document in a training course I am writing and google and otn / metalink have not turned it up for me yet. Does anyone know a URL for this paper? Thanks in advance Kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cache a table
This thread started on 10/21/2003, with a *lot* of comments. No time to read it all, so I'll just work with what appears here. Have considered that this table is simply used a lot and remains in the cache because it belongs there due to frequent access? SQL with high LIO's? Jared Ravi Kulkarni [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 07:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cache a table That was what we expected. This is a highly active PeopleSoft Database. Will it take several months to push those blocks out ? Though not true, it appears the nocache had no effect at all .. -Ravi. --- Bobak, Mark [EMAIL PROTECTED] wrote: Well, that's not really a surprise, is it? If you do CACHE first, and cache all the tables blocks, then do NOCACHE, Oracle isn't going to immediately explicitly flush those blocks. I'd expect that as demand on the buffer cache increased, the blocks would age out. Oracle almost always follows the delay any work I can till later, cause with any luck, I won't have to do it later, either! rule. If you set the table to NOCACHE and then try doing other activity which will impose a load on the buffer cache, I'd expect to see (at least some of) those blocks age out. -Mark -Original Message- From: Ravi Kulkarni [mailto:[EMAIL PROTECTED] Sent: Wed 12/31/2003 6:34 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Cache a table Hi Richard, Did you test the effect of Nocache after caching ? What we noticed is cache followed by nocache is not making the blocks to be flushed out. This has been that way for months now in a production database of ours. Thx, Ravi.
Re: stress testing
As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared Poras, Henry R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: order by
It is for the same reason that 'select empno from emp' without and order by, also returns the same results. Take a look at $ORACLE_HOME/sqlplus/demo/demobld.sql Didn't you ask this same question earlier this week? Jared On Thu, 2004-01-01 at 01:14, [EMAIL PROTECTED] wrote: List can you please explain to me why select empno from emp order by empno ; is the same as select empno from emp order by sqrt(3.14); but not the same as select empno from emp order by dbms_random.value; What does sort by a random value do ? and why isn't dbms_random.value in the documentation for 9i Release 2 ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 29, 2003 03:34 [EMAIL PROTECTED] wrote: Hello list, Can someone please explain to me why the following order by clauses are valid and yield the same results : select empno, deptno from emp order by sqrt (1) ; and select empno, deptno from emp order by sqrt ( 3.14234 ) ; The docs say that in the order by clause you could specify only (a) column names or (b) positional parameters or (c) expressions involving the columns A constant falls under the c) category. It's an expression, which involves anything you want. That said, I fail to see any practical use . -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
Wolfgang, First off, sorry for mangling your name in the previous post. I too will make notes inline. On Tue, 2003-12-30 at 22:14, Wolfgang Breitling wrote: Note inline At 10:29 PM 12/30/2003, you wrote: If my data changes, and I analyze it, CBO should still find reasonable execution paths for the current data. If the CBO were infallable we wouldn't have this discussion. There are many reasons why even the most up-to-date statistics can lead to less than optimal access plans. My point is not necessarily with the frequency of statistics gathering but with the untested activation of new statistics, which is the hallmark of scheduled analyze jobs, as it carries the same risk as any untested change. If my data does not change, and I analyze it, CBO should have the same set of statistics as it did previously. If your data didn't change, or didn't change enough to make a difference in access plans, wouldn't you agree that the exercise of gathering statistics was futile and useless. I didn't dispute that. My point is, it shouldn't matter. One thing that may help to see another perspective is to consider the lone DBA in a medium sized company that doesn't have the luxury of spending much time trying to determine if stats should be run. That DBA may also be involved in development projects, maintenance and monitoring of the databases in 3 sites, maintaining licenses, running change control, and a few other goodies. (yes, that would be me) I automate as much of this as possible. No, stats don't need to be run frequently, but it shouldn't really matter if they are run periodically. I administer several SAP databases and use brconnect to manage the statistics. It does a fair job of only running dbms_stats when needed. ie. though there are 22k tables it may only cause 30 of them to be analyzed, as it did this week. brconnect is setup to run weekly, I check the logs occasionaly, one less thing to worry about. In a previous job we had a large team of DBA's and it was possible ( I had more time) to exercise more control over things like this. Other non-SAP database have automated jobs to run collect the stats weekly. Hasn't caused a problem so far, while on one of those databases, going for some time without an analyze does seem to cause some problems, IIRC. There are ideal ways to do things, but sometimes compromises are necessary. In a situation like this I will either automate stats gathering, or it likely will never be done. And then there's the fleet of RX-7's in my garage that demand attention, and of late I much prefer working on them to running maintenance Oracle jobs at work. :) Jared Is that not true, or is there some other piece missing here? If the current statistics produce access plans that render the required data in the time stipulated by your SLAs, why the urge to change something. You are getting dangerously close to symptoms of CTD. If, on the other hand, there are performance problems, they should be analyzed case by case and at that time the possibility that newer statistics will change the access plan and improve the performance should be explored. Jared -- Author: Jared Still INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Has anyone used this Perl Module? Oracle-Trace-1.06
FYI, you will need to load several other modules. Make sure you are using Perl 5.8.1+ Add the following line to Oracle/Trace.pm in the source dir: use FileHandle: This as of Oracle::Trace 1.06. Haven't actually use it yet. Jared On Tue, 2003-12-30 at 18:19, Michael Thomas wrote: Hi, I was wondering if anyone has used this Perl module successfully, and what you thought? http://search.cpan.org http://search.cpan.org/~rfoley/Oracle-Trace-1.06/ I noticed its relatively new. Happy Holidays. Mike Thomas __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Has anyone used this Perl Module? Oracle-Trace-1.06
Tha author says to use vs. 1.07. CPAN however only has vs. 1.06. I've asked the author how to obtain 1.07, haven't heard yet. Jared On Wed, 2003-12-31 at 02:14, Michael Thomas wrote: Sorry, the last email got truncated for some reason. Here is the rest: - Now I'm stuck at 'make test', my best results are: $ make test /usr/bin/perl.exe -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/TraceName main::a_ftr used only once: possible typo at t/Trace.t line 26 t/Traceok 3/8 # Failed test (t/Trace.t at line 29) # expected 4 entries (26 - (header + children)) got: 0 t/Traceok 5/8 Can't call method statement on an undefined value at t/Trace.t line 43. # Looks like you planned 8 tests but only ran 7. # Looks like your test died just after 7. t/Tracedubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4, 6, 8 Failed 3/8 tests, 62.50% okay Failed Test Stat Wstat Total Fail Failed List of Failed --- t/Trace.t255 65280 84 50.00% 4 6 8 Failed 1/1 test scripts, 0.00% okay. 3/8 subtests failed, 62.50% okay. make: *** [test_dynamic] Error 2 It looks like these results are scrambled because I don't see test1, test2, test7 but I'm getting credit as passed. I figure only 3 and 5 really passed. I stopped here, trying to decide if I should update the perl version on my server, to continue. If you got a good 'make test' then I'll proceed. Regards, Mike Thomas __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*net message from client severly impact the Parse call of an
Sorry, you can't send binary attachments to this list. Jared On Tue, 2003-12-30 at 23:34, Hatzistavrou John wrote: Dear All, I am faced with the following situation. Oracle 8.1.7.4. 64 bit , Solaris 8 There is a loader java process that when is executed against a test database(dwdsa)the response time is as expected to be. However when it is executed against the production instance (dwods) it is 2,5 to 3 times slower. I have traced the session on both occasions and reading the book of Carry Milsap I have spotted that the WAIT for SQL*Net message from client is very high for the PARSE call of an INSERT statement, whereas for the test instance there is no delay. I cannot however explain what might be the cause of this. Can somebody sched some light into this problem. Attached please find the SQL 10046 trace with level 8 a) Production trace (parser_dwods.zip) b) Test trace parser_dwdsa.zip Kind Regards, Hatzistavrou Yannis The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: undotbs01.dbf just keeps growing
Whats the best way to go about identifying any large transactions? Ask the developers and users. As for the size of the UNDO TBS, check and modify your retention times as suggested by Anjo, and control the autoextending of the datafiles. Jared On Wed, 2003-12-31 at 01:39, John Dunn wrote: Thanks Jared You should probably investigate why it continues to grow so large Whats the best way to go about identifying any large transactions? John -Original Message- Sent: 31 December 2003 04:34 To: Multiple recipients of list ORACLE-L The data file(s) for your undo tablespace is likely set as autoextend with an unlimited size. Run the attached script to check it. If so, you can use this to put a limit on it: alter database datafile 'your file name' autoextend on next 200m maxsize 2000m; Adjust the numbers for your system. You should probably investigate why it continues to grow so large. I haven't yet converted our production databases to UNDO, having only recently migrated to 9i, so I don't have any useful advice past this. There are others that will be able to offer more for this. ( Dan Fink, where are you? This might even get Kirti to take a break from his book for a few minutes ) HTH Jared On Tue, 2003-12-30 at 03:29, John Dunn wrote: I have recently installed Standard Engine 9.2 on AIX 5.2 and notice that the undotbs01.dbf file just keeps on growing. It is now over 1 GB. What could be the reason for this? Can I limit it's size and would this cause a problem too? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
