RE: Americas Cup
That $95mill should be the profit sharing for Oracler employees... What a waste! -Original Message- Sent: Monday, January 20, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Larry Ellison has spent 95 million (US) attempting to become the challenger to Team New Zealand for the Americas Cup. Unfortunately did not make the grade... http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 .html Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fowler, Kenneth 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: Wong, Bing 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: PMON seems to not close sessions in a timely manner eg Max
Mine is 8.1.7.2 on HP.
In init.ora, processes=1000 sessions=1000 mts_servers=8, mts_max_servers=20,
dispatcher=10
I have not seen maximum process reached but have seen Deadlock: MTS Max
Servers (20) reached because applications had more than usual connections
once in a while. But that's ok with the applications.
Bing
-Original Message-
Sent: Tuesday, December 24, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
Well, I had placed the db is MTS mode and still hit the max
processes(50)
#MTS_DISPATCHERS=(protocol=tcp)(dispatchers=5)(pool=on)(tick=1)
(connections=1000)(sessions=4000)
#MTS_MAX_DISPATCHERS=32
#MTS_SERVERS=5
#MTS_MAX_SERVERS=64
#MTS_SERVICE=MYDB
#MTS_LISTENER_ADDRESS =
(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MYSERVER))
And was able to have only shared connections as opposed to direct
connections
EG shows server=shared
select username, program, server from v$session
where audsid=userenv('sessionid');
I think Ive read all the docs I can find on multi threaded server but
did not see anything about creating a service or adding a dispatcher, Im
of the understanding that placing the above in my init.ora file, that
creates the dispatcher when I bounce the db? In this case as far as I
see my MTS service is MYDB.. Eg my SID
So, I must be missing something... I'd sincerely appreciate any
suggestions ... Examples?? From all the docs I see this is all that's
needed, obiviously not - Please advise
Thanks
bob
Add a dispatcher, configure MTS, min server processes and add
an Oracle service for this MTS.
An then let this app connect to Oracle through the MTS service.
Regards,
Waleed
-Original Message-
Sent: Tuesday, December 24, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L
processes(50) reached
I have a developers stored procedure making repeaded calls
(logons/request for data and logoff)
Each call takes only seconds but it seems like PMON dosnt
close the process in a timely manner, leaving what look to be
ghost process. If a few users hit the same app the processes
go to = 50 then I get the dreaded ORA-nnn max processes (50) reached
I can watch processes increse and decrese with v$session
and v$process, they just dont seem to close quick enough.
(however, they do eventually close)
Any ideas what to look for. Ive searched Google and for
parameters for PMON to no avail, hence I bring my delimma to the list
I think I'd like to tell PMON how frequently to check for
completed requests.
thanks and happy holidays
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
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: Khedr, Waleed
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: Bob Metelsky
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: Wong, Bing
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
RE: Row cache locks on INSERTs with a sequence
Title: RE: Row cache locks on INSERTs with a sequence Let me guess - they did not say sorry to you. -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 12:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Row cache locks on INSERTs with a sequence Thanks for the replies. And, good guess Jonathan. We've already made some changes to the stored procedure implementing the INSERT statement. Upon investigation, I found that the table involved is used as a staging table in a batch process. Instead of truncating the table at the start of the load process, they were performing a DELETE. The table had 0 rows, was 38MB in size, and had 300 extents. The index underlying the PK constraint on this table had 632 extents. In addition, looking at the code and table design, found that they did not need a sequence at all. The column utilizing the sequence was simply a dummy number not involved in defining any keys in the live table. Merely using an internal counter in a PL/SQL loop would have sufficed. Nice. The developers were adamant to management that the DBA team was at fault, did not know how to manage the database, etc; and now they are skulking in the corner avoiding us. -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Row cache locks on INSERTs with a sequence If the wait times on the latch were significant, I think I'd check that the inserts were high volume inserts into tables with a very small extent sizes and lots of indexes, also with very small extents. I wouldn't have thought it was anything to do with sequences. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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] Date: 20 December 2002 16:56 We are continually seeing sessions hanging on row cache locks, which in turn appear to be on dc_segments: SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - - -- -- -- - 29 row cache lock cache id 13 mode 0 request 5 105 row cache lock cache id 13 mode 0 request 5 The offending SQL statement is an INSERT of the following form: INSERT INTO TABLE (A,B,C,D...) VALUES (:b1, :b2, :b3, SEQUENCE.NEXTVAL,..) The sequence in question has it's cache value set to the default of 20. The developers keep insisting that it's a shared pool issue. I've researched Metalink and not come up with a whole lot. I've ran statspack and it has rendered advice with respect to the fact that a lot of new sequence values are being acquired, therefore the sequence cache size needs examination. -- 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).
RE: export porblem ???
Do you have COMMIT=Y? Drop the indexes first and then import. Then create the indexes. -Original Message- Sent: Monday, December 16, 2002 8:34 PM To: Multiple recipients of list ORACLE-L Are you importing indexes? How many indexes there are on table #17? Is the DB in archive log mode? Is the archiver getting stuck? - Kirti -Original Message- Sent: Monday, December 16, 2002 8:29 PM To: Multiple recipients of list ORACLE-L guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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.com -- Author: Deshpande, Kirti 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.com -- Author: Wong, Bing 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: alert log suppression
Title: RE: alert log suppression If it is LMT, coalescing is ignored. -Original Message-From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: alert log suppression Coalescing LMTs is unnecessary ! - Kirti -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" [EMAIL PROTECTED] wrote: Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: image storage confusion ??
I would test it on raw disk device because it avoids double buffering. -Original Message- Sent: Tuesday, December 03, 2002 2:49 AM To: Multiple recipients of list ORACLE-L Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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.com -- Author: Wong, Bing 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 will Oracle 10i be out?
I heard that the white paper has not yet been published internally... -Original Message- Sent: Thursday, November 07, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pall, Tom [Contractor] 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.com -- Author: Wong, Bing 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: ORA-1078 During a 9iR2 Install
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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.com -- Author: Wong, Bing 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: Adhoc queries and limiting the amount of records queried...
This is what I do in my shop since they allow(not me) ad hoc queries... I modified the user id that run ad hoc queries to default to a TEMP tablespace which is rather small. :) They failed most of the time and I receive no complains. :) Bing Wong Open Systems Database Administrator x25721 This e-mail may contain material that is confidential. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies received. -Original Message- Sent: Tuesday, October 29, 2002 11:59 AM To: Multiple recipients of list ORACLE-L many shops prohibit ad-hoc queries in busy OLTP databases and many of those have datawarehouses where ad-hoc is allowed. IMHO that's the only way prevent ad-hoc queries from causing problems in your OLTP environment. SQL select * form users where clue 0; no rows selected -Original Message- Sent: Tuesday, October 29, 2002 1:29 PM To: Multiple recipients of list ORACLE-L I just wanted to ping the list to see what other people have done to control or constrain adhoc query users??? We have a group that is struggling with the adhoc query piece that's in production. Some of the users end up firing off insane queries. The group is trying to find a way to limit the amount of records queried for, so that a wild query doesn't hose the database. Appending a ROWNUM to the WHERE clause is one idea. Using USER PROFILEs is another. Any other thoughts?? Dare I ask...this custom app also runs on SQL Server, so SQL Server ideas would also be appreciated. Many thanks!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG 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.com -- Author: Wong, Bing 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 DBA vs JAVA programmer???
If you are single, get a job wherever it offers and then move back to your favorite place. Try not to be out of job for too long if you can. I have friend got laid off here in CA and got a job in Orlando, FL. And he has family. Bing Wong Open Systems Database Administrator x25721 This e-mail may contain material that is confidential. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies received. -Original Message- Sent: Friday, October 25, 2002 3:44 PM To: Multiple recipients of list ORACLE-L My only comment is ... New Jersey over Colorado Are you mad woman -Original Message- Sent: Friday, October 25, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Hi all, I need your idea. I got laid off as an Oracle DBA (3 yrs experience), and it's hard to find a DBA position here(I'm in Colorado). I had couple of years experience programming (3 yrs) in VB, and currently learning JAVA. I'd like to know is JAVA market still hot? (I can relocate to New Jersey, any memeber in New Jersey? how is the market over there, for Oracle DBA or JAVA programmer?) What do you think which position is better, Oracle DBA or Java programmer? Based on compensation, workload, market demand, etc, etc ... Thanks a lot! Janet __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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.com -- Author: Kevin Lange 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.com -- Author: Wong, Bing 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: Can I index this query?
If that content is statics, create a column that called TRACKINGEVENTID stores 'TrackingEventId='. Is EVENTID the same as TRACKINGEVENTID? Partition it by QUEUETYPE so that it only goes after one patition instead the entire table if partition does not affect other SQLs. Bing Wong -Original Message- Sent: Tuesday, October 15, 2002 2:10 PM To: Multiple recipients of list ORACLE-L Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null?Type - EVENTID NOT NULL NUMBER(10) VER NOT NULL NUMBER(10) QUEUETYPE NOT NULL CHAR(16) PUBLISHER NOT NULL CHAR(16) CREATETIMENOT NULL DATE LASTREADTIME DATE REMOVETIME DATE CONTENTS NOT NULL VARCHAR2(4000) The users do a query that looks like this: SELECT EventId, QueueType, Publisher, CreateTime, LastReadTime, RemoveTime, Contents, Ver from EventQueueEntry where QueueType = 'CodeUpdate' AND Contents LIKE '%TrackingEventId=27668677%' ORDER BY EventId The queuetype field has only 3 different values. The value in the contents field is close to being unique (high cardinality) but, as you can see, they are picking off a value somewhere in the middle of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS 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.com -- Author: Wong, Bing 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 I post a preview of Oracle9i RMAN Backup and Recovery
Me too. Bing Wong Open Systems Database Administrator This e-mail may contain material that is confidential. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies received. -Original Message- Sent: Friday, September 27, 2002 5:03 PM To: Multiple recipients of list ORACLE-L Recovery Hand I would love to read that . bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:08 AM Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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.com -- Author: Ruth Gramolini 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.com -- Author: BigP 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.com -- Author: Wong, Bing 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 Call C Routine from PL/SQL
H... My shop used it once and caused memory shortage because the external process frequently did not terminate. Application team removed the logic. Bing Wong Open Systems Database Administrator x25721 This e-mail may contain material that is confidential. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies received. -Original Message- Sent: Tuesday, September 17, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Read up in the standard PL/SQL Reference manual on external procedures. It will explain everything very well... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 10:23 AM Hi Everybody, I want to call C Program routine from PL/SQL. What all things I need to do. Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S K 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.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing 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: Hot Backup using EMC /BCV splits
Can you tell us what is the size of the database that is using EMC/BCV or other Hardware vendor splits mechanism? Thanks. Bing Wong Open Systems Database Administrator x25721 -Original Message- Sent: Thursday, August 15, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Nat, We have a similar backup strategy using a homegrown split procedure on Compaq Tru64. We split while all tablespaces are in backup mode as our's is a controller based split and takes 5-6 minutes. After all, if the split is going to take place after the tablespaces are taken out of backup mode, why put them in backup mode at all?!? I personally would not rely on the hardware to keep the database consistent during a split, but then again, I don't have any experience with EMC. HTH Mike -Original Message- Sent: Thursday, August 15, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount on another machine and backed up from it. What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4. According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency. What do you all think. What is the recommended procedure. TIA, Nate -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Re:MTS performance is too bad.
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MICHAEL.SALE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS performance is too bad.
What is your maximum MTS servers? -Original Message-From: Bunyamin Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: MTS performance is too bad. I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin
RE: the ora certified masters cert, yet again
want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Good Tool for Entity Relationship Diagram
How about ERwin by CA? We use a lot. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/14/02 3:13 PM Hi, One of our databases is custom based application. Is there any good tool I can use for ER Diagram. Thank your! Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 experts, a simple question for you
calendar_date calendar_month calendar_qtrcalendar_year
200201011 1 2002
200301011 1 2003
Mh...
The calendar_date(or changed to calendar_day) should be just the day of the
month since you already have calendar_year. It seems that you are storing
everyday's day.
Or get rid of calendar_year and calendar_month since calendar_date contains
month, and year?
-Original Message-
Sent: Monday, May 20, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of calendar_year,
wont validate.
- the question i have is this, should month really be like 2002-01 with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wong, Bing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: TEMP tablespace growing abnormally -Sort Area
Is your TEMP tablespace set to TEMPORARY or PERMANENT? -Original Message- Sent: Tuesday, May 14, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Forgot to tell you that myparameter for sort_area_size= apx. 8GB -Original Message- Sent: Tuesday, May 14, 2002 8:02 PM To: '[EMAIL PROTECTED]' Hi all, Having a bad start of week. My temp tablespace is growing abnormally -from 3GB - 32 GB (Filled up disk). DB is 81700 on Tru64 Unix, 120GB in size, appx 150 front-End users running billing application for appx 200,000 customer base. Initially set-up as OPS but undone though init.ora file still has PARALEL_SERVER=TRUE, only one node is active. I've seen a refernce to OPS in relation to de-allocation of extents but can't get further. Any help will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Normalization-Outdated?
Normalization process should be done at the logical level, but it can be denormalized at the physical level to support must have transaction processings. -Original Message- Sent: Wednesday, May 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L To speak to that point; we are the state tax department. We received and send mail, hundreds of pieces. Our original tax appliation required us to go to at least10 tables to get an address because it was completely normalized. When we go the new and improved version this was denormalized for the sake of design and speed. Storage is cheap now, but bad coding can take more resources than you have. Just my $.02, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 12:08 PM List- My Opinion: The purpose of Normalization is to reduce redundant storage. It is a trade off between affording redundancy(as far as you can?)and avoiding to many joins later. It can not be true accross the board. Designers should go by the merit/requirements of the application. If database is normalized as and where it is possible(i.e. up to Boyce-Codd Normal Form); it might become a nightmare while trying to run BUSINESS OBJECTS/COGNOS/etc against it. As Hanna just mentioned joining 17 tables. AT my present work place I am dealing with a db which is so poorly designed. Now to be able to support BUSINESS OBJECT the developers are kind of taking band aid approach - asking for denormalizing the db tables with so called WORK TABLES - It is serving two purposes, saving them from coding nightmares and improving apps performance. As far as RI is concerned I have seen in places they do not use RI rather loves to maintain data integrity by using triggers. My opinion on this - This is more of a preference than to do with any technicality. I am for RI. Shaibal From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Database Normalization-Outdated? Date: Wed, 01 May 2002 04:03:29 -0800 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SIMPLE QUESTION
If this is unix, do this... 1. backup the log if you need it 2. issue this command listener.log (this will initialize the log) -Original Message- Sent: Wednesday, May 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Prod problem, please help!!!
be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipients named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 is wrong with this export?
Just run like this. It will ask for password. Assuming you are running it manually. Make sure you have ORACLE_SID set correctly. exp user FULL=N tables = ( table1, tab2, tab3, tab40,tab5,ttdsls051061,ttdsls051110,ttdsls051120,ttdsls051130, ttdinv700040,ttdinv700061,ttdinv700110,ttdinv700120,ttdinv700130, ttfgld410210,ttfgld421010,ttfgld410060,ttfgld100010,ttfgld106060, ttfgld106100\ ) COMPRESS=N direct=Y log=fullsls.log file=fullsls.dmp -Original Message- Sent: Tuesday, April 30, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Basing it on my Solaris experience the \ is a control character so the system will treat the ( and ) as part of the export command. But doesn't it need to be immediate before the ( and )? I.e., \( instead of \ (? What is the error you're getting? -Original Message- Sent: Tuesday, April 30, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I'm not working on AIX, but I use syntax exp user/passwd tables=(TABLE1,TABLE2) ... etc. Why do you use \( and \) ? JP On Tue 30. April 2002 21:38, you wrote: Hi friends, Iam exporting some of tables, but keep getting error!! Could you help.. Mine is AIX415 with oracle4.3, If I want import an individual table, what is correct form of parameters? exp user/passwd tables = \ ( table1, tab2, tab3, tab40,tab5,ttdsls051061,ttdsls051110,ttdsls051120,ttdsls051130, ttdinv700040,ttdinv700061,ttdinv700110,ttdinv700120,ttdinv700130, ttfgld410210,ttfgld421010,ttfgld410060,ttfgld100010,ttfgld106060, ttfgld106100\ ) COMPRESS=N direct=Y log=fullsls.log file=fullsls.dmp Thanks in advance Raghu. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-03113
Assuming all your OS, patches, etc.. are certified, this error is very generic. Check your ORACLE_HOME again. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/21/02 2:58 PM Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better if someone here has encountered this same problem and was able to fix it, could you email me the solution? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reorganize table
You can export and compress on the fly This unix... mknod export_pipe p compress export_pipe export_file.dmp.Z exp userid file=export_pipe log=export.log table=(big_fat_table) compress=n Try it. I hope it compress to less than 5G. -Original Message- Sent: Thursday, April 18, 2002 10:19 AM To: Multiple recipients of list ORACLE-L If you can't export, can you do ctas (create table as select..) ? Either way it's going to take a long, long time... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Subject: Reorganize table Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespaces/What a DBA can do ?
I have upgraded 8.1.6 to 8.1.7.2(32-bit) on HP-UX 11.0 64-bit machine and use LMT on all my databases. They run fine and one of the database has been running over 1 year now. -Original Message- Sent: Wednesday, April 17, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Rafiq, I upgraded an HP-UX 11.0 64-bit machine in early April. (8.1.6.3.0 to 8.1.7.3.0) It was the worst upgrade I've ever gone through, but everthing appears to be running normally. (I'm not using locally managed tablespaces yet though.) I was missing a couple of operating system patches and the machine isn't the quickest in the world (and I have 3 databases on that machine). I plan on upgrading another HP-UX 11.0 64-bit machine to 8.1.7.3.0 by the end of the month. I'm a little nervous about 8.1.7.3.0 on Solaris 7, so I'm going to do some reading before taking the databases to either 8.1.7.2.0 or 8.1.7.3.0. HTH, Julie Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: Wednesday, April 17, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Lisa, Thanks. I saw couple of messages today about problems with 8.1.7.3 on Solaris. We are also thinking to move to 8.1.7.3 on HP-UX 11 in near future but now we have to wait and see for a while. Regards Rafiq -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fisher, Julie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8.0.5 to 8.1.7.3 (fwd)
Yes, exp/imp cleans up a lot of garbage. I always use this method. -Original Message- Sent: Wednesday, April 17, 2002 3:38 PM To: Multiple recipients of list ORACLE-L An upgrade can be seen as a rare chance to do all these things, if you choose exp/imp method. That's what John is referring to. LK -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 5:12 PM To: Multiple recipients of list ORACLE-L Subject: RE: Upgrade 8.0.5 to 8.1.7.3 (fwd) On Wed, 17 Apr 2002, John Weatherman wrote: Clean up fragmentation/chaining, change block size at the same time, in my current case, chage hardware platform... All sorts of reasons. :) What do those things have to do with an upgrade? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- On Wed, 17 Apr 2002, Browett, Darren wrote: The previous DBA, also used the export/import method, and is the method I am most likely going to use. Can someone explain why anyone would opt for export/import as a path to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist of starting the instance on the new ORACLE_HOME and running an upgrade script? Why would someone undergo the disruption and complexity of a full export/import when you can just leave the data where it is? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script for identifying objects having freelists contention
I hope it works for you. set Trimspool onset Line 132set Pages 57set Newpage0set FeedBack offset Verify offset Term offTTitle offBtime offcolumn Pct Format 990.99 Heading "% Of |Free List Waits"column Instance New_Value _Instance NoPrintcolumn Today New_Value _Date No Printselect Global_name Instance, To_char(SysDate, 'FXDay DD, HH:MI') Todayfrom Global_Name; TTitle OnTTitle Left 'Date Run: ' _Date Skip 1- Center 'Free list Contention' Skip 1 - Center 'If Percentage is Greater then 1%' Skip 1 - Center 'Consider increasing the number of free lists' Skip 1 - Center 'Instance Name: ' _Instanceselect ((A.Count / (B.Value + C.Value)) * 100) Pctfrom V$WaitStat A, V$SysStat B, V$SysStat Cwhere A.Class = 'free list' and B.Statistic# = (select Statistic# from V$StatName where Name = 'db block gets')and C.Statistic# = (select Statistic# from V$StatName where Name = 'consistent gets')/Column Total_Waits Format 999,999,999,990 Heading "Buffer Busy Waits"Column DB_Get Format 999,999,999,990 Heading "DB Block Gets"Column Con_Get Format 999,999,999,990 Heading "Consistent Gets"Column Busy_Rate Format 990.999 Heading "Busy Rate"TTitle Left 'Date Run: ' _Date Skip 1- Center 'Buffer Busy Waits Rate' Skip 1 - Center 'If 5% review V$waitStat' Skip 1 - Center 'Instance Name: ' _Instance Skip 2select Total_Waits, B.Value DB_Get, C.Value Con_Get, ((A.Total_Waits / (B.Value + C.Value)) * 100) Busyfrom V$System_Event A, V$SysStat B, V$SysStat Cwhere A.Event = 'buffer busy waits'and B.Statistic# = (select Statistic# from V$StatName where Name = 'db block gets')and C.Statistic# = (select Statistic# from V$StatName where Name = 'consistent gets')/ -Original Message-From: Anand Prakash [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 2:29 PMTo: Multiple recipients of list ORACLE-LSubject: Script for identifying objects having freelists contention Does anyone have the scripts (or URL) for identifying objects having freelists contention? Thanks. Anand Prakash
RE: Locally managed tablespaces/What a DBA can do ?
simply turning the existing dictionary-managed tablespaces into locally managed tablespaces, other then maintenance, would I gain performance ? From what I read on this list, the growth of my tables is very small compared to some of the other org's, so maybe staying with dictionary-managed would be best, except for the temporary tablespace. Darren. -Original Message- Sent: April 15, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Darren - Do you have to reorganize the vendor's files now? The objective of LMT's is to make Oracle more self-managing (you === message truncated === __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: migrate from 8i to 9i
). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 taking to long
Like someone suggested, use BUFFER=10MB or more so that you have less I/O. -Original Message- Sent: Tuesday, April 09, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Parameters looks ok, Just use gzip instead of compress . File extention should be .gz instead of .Z If you can try larger recordsize than 65K ,try it. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 09 Apr 2002 06:28:20 -0800 I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE=/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z LOGFILE=/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log # # Begin compress job and export to pipe with userid and password hidden # compress /oracle_dba/expimp/adprod/exp_pipe_adprod $OUTFILE exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Names server
Names server will beobsolete in 9i, I think. -Original Message-From: Yahoo [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 11:33 AMTo: Multiple recipients of list ORACLE-LSubject: Names server Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome.
RE: Frequency of Analyze
I analyze weekly as well as rebuilding index weekly on 8.1.7.2 on HP. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/15/02 8:23 AM Can't say about recommended, but we analyze most of our tables weekly (during a slow time on Sunday) and the two tables that have lots of delete and insert activity and often vary widely in size from day to day are analyzed daily. -Original Message- Sent: Friday, February 15, 2002 10:23 AM To: Multiple recipients of list ORACLE-L What is the recommended frequency of analyzing schemas in an OLTP environment? DB size near 8 GB. Oracle 8.1.7.0.0 on NT 4. BM__MailAutoSigArslan Zaheer Dar [EMAIL PROTECTED] Database Administrator Shaukat Khanum Memorial Cancer Hospital Research Centre www.shaukatkhanum.org.pk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
can sharepool error cause sna to go down?
My developer asked me this. can sharepool error cause sna to go down? Has anyone heard of this? I don't think so. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Performance Question
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 from 8.1.6 to 8.1.7
You should upgrde to 8.1.7.2 if not 8.1.7.3 and recompile all client programs. Don't stop at 8.1.7.1. -Original Message- Sent: Monday, January 28, 2002 8:50 AM To: Multiple recipients of list ORACLE-L technet.oracle.com go look for the documentation and read --- Hamid Alavi [EMAIL PROTECTED] wrote: Hi List, I have asked this question twice but no answer at all, I don't know may be is too easy or not related at all, I just want to know what I have to do for upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have any URL or link or any sort or documentation let me know. Thanks hope this time I get an answer. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tablespace
My question is do you excusively use up 5gig? if so, does your SQL results in Cartesian product? My shop ran into this and I had developers corrected the SQL and then never happen again. I still left the TEMP tablespace which is LMT to be 700MB. -Original Message- Sent: Tuesday, January 15, 2002 9:11 AM To: Multiple recipients of list ORACLE-L Please check whether tables involved/indexes involved have degree 1. Please make it 1 if not and try. If it becomes HASH sort instead of SORT this problem happens. You can check it degree from dba_tables or dba_indexes. You may use following query while running your job to establsish what type of sort.. select user,segtype,extents from v$sort_usage; Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 15 Jan 2002 07:15:31 -0800 Best possible solution: rewrite the query and try to avoid large sorts ... or split the query, and make use of temporary tables (by using CTAS) to save results of the first part ... HTH, Remco -Oorspronkelijk bericht- Van: Sajid Iqbal [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 15 januari 2002 10:50 Aan: Multiple recipients of list ORACLE-L Onderwerp: Locally Managed Tablespace Hi all I am getting this error while running a large query, I recently created this locally managed temp tablespace... Any advice on possible solutions, the tablespace is 5 gig ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL TIA -- Saj Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pin object into shared pool
Agreed. I would use the buffer pool KEEP. -Original Message- Sent: Tuesday, January 15, 2002 2:45 PM To: Multiple recipients of list ORACLE-L and/or the new buffer pool features found in oracle 6. - Jaded DBA -Original Message- Mitchell: You don't pin tables; you pin functions, packages, and procedures. If you want a table to stay in the buffer cache for as long as possible, you use 'ALTER TABLE ... CACHE'. HTH, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HOW TO MAKE DELETION FAST
If TRUNCATE is not possible, then disable the constraints, put database in no archive log mode and delete. It should run fast. Or alter the table to be nologgin. After deletion, rebuild the indexes and analyze both tables and indexes. -Original Message- Sent: Thursday, January 10, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.
Happy New Year! Agreed! I like so much with locally managed tablespace because every extent size is uniform, therefore no fragmentation; you don't have to worry about the number of extents at the table level. I even make the temporary tablespace to be LMT. What is the acceptable extent size if you mix large tables with small tables (in terms of nbr of rows) in one tablespace? For example: you have 20 tables; 10 of them will have only less than 1000 rows, 5 of them will have less than 2 rows and the rest will have 10 rows or more. Now what is the appropriate extent size for the tablespace if you decide to create only one tablespace for all 20 tables? If you split into 3 tablespaces, then you can easily set the extent size for each. Please don't let it frustrate you! If you are very concerned with wasting space, then you should split into more tablespaces. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 1/2/02 2:15 AM Connor McDonald wrote: Dictionary managed tspaces are practically obsolete...Go with locally managed - they are the default in 9i and as of 9i.2, *all* tablespaces will default to locallly managed (including system) hth connor --- Arul kumar [EMAIL PROTECTED] wrote: Hi DBAs, I would like to know on what basis we arrive at the decision of making a tablespace as LOCALLY Managed / DICTIONARY Managed... Any Suggestions / Tips Thank you.. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald Sybasation ;-) ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
About a month ago, I upgraded from 8.1.7.1.0 to 8.1.7.2.1 (actually the banner says 8.1.7.2.0). Everything is good so far. Bing -Original Message- Sent: Wednesday, December 19, 2001 9:09 AM To: Multiple recipients of list ORACLE-L Gene, You may have a longer wait than January if you are non-Solaris. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 19, 2001 11:27 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] I am still waiting for Oracle 8.1.7.3 final release for 8.1. Then start looking at 9.1, when it comes out. [EMAIL PROTECTED] 12/19/01 10:35AM Hello, FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is the way to go. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 18, 2001 10:40 PM To: Multiple recipients of list ORACLE-L If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to 8.1.7.2.0. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/18/01 5:50 PM Your SGA has become fragmented. You would not per chance be running 8.1.7 would you? If so I would go and do some searching on Metalink. I see an upgrade in your future. You could try flushing the SGA but if its what I think it is it won't help. A restart will for a while. -Original Message- Sent: Tuesday, December 18, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Any idea what this means ? Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer) Begin * ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 3 PasswordNotification12172001.txt: No such file or directory PasswordNotification12172001.err: No such file or directory Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Help
Upgrade first to 8.1.7.2.1. Don't wait. -Original Message- Sent: Wednesday, December 19, 2001 9:09 AM To: Multiple recipients of list ORACLE-L Gene, You may have a longer wait than January if you are non-Solaris. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 19, 2001 11:27 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] I am still waiting for Oracle 8.1.7.3 final release for 8.1. Then start looking at 9.1, when it comes out. [EMAIL PROTECTED] 12/19/01 10:35AM Hello, FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is the way to go. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 18, 2001 10:40 PM To: Multiple recipients of list ORACLE-L If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to 8.1.7.2.0. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/18/01 5:50 PM Your SGA has become fragmented. You would not per chance be running 8.1.7 would you? If so I would go and do some searching on Metalink. I see an upgrade in your future. You could try flushing the SGA but if its what I think it is it won't help. A restart will for a while. -Original Message- Sent: Tuesday, December 18, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Any idea what this means ? Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer) Begin * ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 3 PasswordNotification12172001.txt: No such file or directory PasswordNotification12172001.err: No such file or directory Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED
RE: using MTS on oracle OPS, running on HP-UX
Why do you need to use MTS? Do you run out of memory? -Original Message- Sent: Wednesday, December 19, 2001 9:09 AM To: Multiple recipients of list ORACLE-L Hello, Anyone out there try and implement MTS on OPS ? We are using 64-bit HP-UX, rev 11.0, and the OPS is 8.1.6.3.0. We look to go with MTS after we are at 8.1.7.2.1, sometime next month. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Change PCTINCREAE for SYSTEM Tablespace
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to 8.1.7.2.0. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/18/01 5:50 PM Your SGA has become fragmented. You would not per chance be running 8.1.7 would you? If so I would go and do some searching on Metalink. I see an upgrade in your future. You could try flushing the SGA but if its what I think it is it won't help. A restart will for a while. -Original Message- Sent: Tuesday, December 18, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Any idea what this means ? Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer) Begin * ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 3 PasswordNotification12172001.txt: No such file or directory PasswordNotification12172001.err: No such file or directory Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BMC Patrol DBXray / CA Unicenter
Tools! Tools! Tools! Did you look at Quest at all? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/4/01 5:35 PM CA Unicenter sucks, CA support sucks. CA sucks. Stay away. -Original Message- Sent: Tuesday, December 04, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent - error ORA-24327
8.1.7.1 has bug related to memory leak on all UNIX platforms, I think. Also it has bug related to the maximum number of 536 concurrent active sessions. I had applied patch 8.1.7.2.1 and problems went away. If you have more than 300 or 400 connections, should consider MTS. Something to think about. Bing -Original Message- Sent: Wednesday, November 28, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Deepak, Processes parameter is set to 1000. Rao -Original Message- Sent: Wednesday, November 28, 2001 5:05 PM To: Multiple recipients of list ORACLE-L what is your processes parameter set to? --- Rao, Maheswara [EMAIL PROTECTED] wrote: List The environment : Oracle 817 : Solaris 7 : Memory - 4 GB. WebLogic Vesrion: 6.1 In the WebLogic Connection pool, when we try to open the connections beyond 246, we are getting this error - ORA 24327. We are not getting this error when the connection pool in the WebLogic is below 245. Any help would be appreciated. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup strategy
My hot backup is to put one tablespace in backup mode one at a time and copy that data file to disk and alter it back online. No problem Bing -Original Message- Sent: Tuesday, November 20, 2001 10:28 AM To: Multiple recipients of list ORACLE-L My fault, I should have said copy. Climbing night last night so I am dead tired. Thanks for the input. -Original Message- Sent: Tuesday, November 20, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Kimberly, You can change a tablespace to read only with no problems and you should take a backup to capture the change. Your last paragraph stated you wanted to move the datafile to the disk that the tape backup picks That will cause you problems if you move the datafile. You should copy the datafile because the Oracle knows that it is located at disk-1 not disk-2. Your users can still select from the tablespace as usual and if I remember correctly they can truncate if they have the priviledge but not delete from. I use the same method every 6 months. Archive older data to a read only tablespace that contains my archive tables. Remember, all of the tablespaces in the datafile have to be read only. ROR mª¿ªm [EMAIL PROTECTED] 11/20/01 11:40AM Just throwing something out cause I am not sure if I am thinking correctly. I have a database that is not using partitioning so we split each month out into seperate tables/indexes by month and store them in their own tablespaces. These are kinda big so we occasionally put a tablespace into read-only mode, shutdown the database, perform a cold backup right to tape. Problem is, we are putting this database into ServiceGuard. Its kind of a big pain in the butt to shutdown a database that is running in ServiceGuard yet still have the disks available. So I will now have to start handling this will the hot backup. NOTE: not using RMAN and really don't want to. Its not that I don't trust it, just not worth it in this environment. I am thinking that everything will be ok if I put the tablespace into read-only, move the datafile to the disk that the tape backup picks up during the OS backup along with a backup control file. I should then be able to recover this with no issues. Sound logical? Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup strategy
When you backup the read-only tablespace, you must backup the archive logs (if any) as well. -Original Message- Sent: Tuesday, November 20, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Ya but you don't normally backup a read-only tablespace. The whole reason I make them read-only is to ensure that I finish the backup this century. -Original Message- Sent: Tuesday, November 20, 2001 11:01 AM To: Multiple recipients of list ORACLE-L My hot backup is to put one tablespace in backup mode one at a time and copy that data file to disk and alter it back online. No problem Bing -Original Message- Sent: Tuesday, November 20, 2001 10:28 AM To: Multiple recipients of list ORACLE-L My fault, I should have said copy. Climbing night last night so I am dead tired. Thanks for the input. -Original Message- Sent: Tuesday, November 20, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Kimberly, You can change a tablespace to read only with no problems and you should take a backup to capture the change. Your last paragraph stated you wanted to move the datafile to the disk that the tape backup picks That will cause you problems if you move the datafile. You should copy the datafile because the Oracle knows that it is located at disk-1 not disk-2. Your users can still select from the tablespace as usual and if I remember correctly they can truncate if they have the priviledge but not delete from. I use the same method every 6 months. Archive older data to a read only tablespace that contains my archive tables. Remember, all of the tablespaces in the datafile have to be read only. ROR mª¿ªm [EMAIL PROTECTED] 11/20/01 11:40AM Just throwing something out cause I am not sure if I am thinking correctly. I have a database that is not using partitioning so we split each month out into seperate tables/indexes by month and store them in their own tablespaces. These are kinda big so we occasionally put a tablespace into read-only mode, shutdown the database, perform a cold backup right to tape. Problem is, we are putting this database into ServiceGuard. Its kind of a big pain in the butt to shutdown a database that is running in ServiceGuard yet still have the disks available. So I will now have to start handling this will the hot backup. NOTE: not using RMAN and really don't want to. Its not that I don't trust it, just not worth it in this environment. I am thinking that everything will be ok if I put the tablespace into read-only, move the datafile to the disk that the tape backup picks up during the OS backup along with a backup control file. I should then be able to recover this with no issues. Sound logical? Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: Startup error
I think you probably need to revisit the kernel paramters such as SEM*. -Original Message- Sent: Thursday, November 01, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Hi, I created a database (8.0.6 - HP-UX 11) and then I changed the processes parameter to 100 (initial value was 50). I then tried to start the database and I get the following error: SVRMGR startup ORA-07279: spcre: semget error, unable to get first semaphore set. HP-UX Error: 28: No space left on device Additional information: 1 SVRMGR Could someones please tell me what this means and how I should fix it. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INITRANS storage parameter
So the existing data blocks that were assigned to INITRANS=1 would not have any negative impact, right? Now I remember that was you had the problem and I read your note and kept for reference. Now I am facing the same problem. Thank you. Bing -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/26/01 2:30 AM Yes you can. But it will only be that way for new records added. We had the same problem on 8.0.5 . But that should be ok. Our problem was that , on new records, we had reads coming thru that appeared to do full table scans while the initial inserts were coming thru. This, apparently, caused a problem with the tables because locks started to build up. When we changed our initrans to 2 on all those tables, our locking problem went away. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/25/01 6:10 PM Hi, I have 8.1.7.1 running on HP-UX. One of my table is heavily being updated and I see blocking locks. I have recalled that if I change the INITRANS value from 1 to 2, the blocking locks should go away. Question I have is can I modify it in the fly without dropping and recreating the table. Thanks Bing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
INITRANS storage parameter
Hi, I have 8.1.7.1 running on HP-UX. One of my table is heavily being updated and I see blocking locks. I have recalled that if I change the INITRANS value from 1 to 2, the blocking locks should go away. Question I have is can I modify it in the fly without dropping and recreating the table. Thanks Bing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tools
you are ready to pay big $ for BMC, Quest and CA tools. -Original Message- Sent: Friday, October 19, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Does anybody know of any good monitoring tools for Oracle. We are using OEM and are not very happy. We need something to monitor the DB and alert us, and something to run jobs on a schedule or repair basis. This could save me months of research and surfing. What works for you? TIA!! Eric. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Swain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12154 -connection broking at regular intervals
How often does it commit? I am not sure if it relates. -Original Message- Sent: Thursday, October 18, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Hi, We r getting error ORA-12154 in middle of processing from our application to database server. application is doing lot of insert/update and connection is broking after about every half hour.. What can be the possible cause. DATABASE 8.1.7.1.5 OS WIN 2K Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Question about temporary segments
I would just increase that AWW_INDEX1 larger and then downsize it after rebuilt. -Original Message- Sent: Thursday, October 18, 2001 2:35 PM To: Multiple recipients of list ORACLE-L From Metalink Doc ID: 136644.996 During an index rebuild, there are two types of temporary segments involved. First, there are the temporary segments that are used to store partial sort data when the SORT_AREA_SIZE is too small to process the complete sort set. These segments are built in the user's default TEMPORARY tablespace. Second, as the index is being rebuilt, it uses a segment which is defined as a temporary segment until the rebuild is complete. Once this segment is fully populated, the old index can be dropped and this temporary segment is redefined as a permanent segment with the index name. The error you are seeing is probably due to there being insufficient room in the index's tablespace to hold both the original index and the new version concurrently. The new version of the index, currently a temp segment, will be in the tablespace where the index is required. HTH, Michael Bush Corporate Systems Database Administration (806) 337-3610 www.csedge.com -Original Message- Sent: Thursday, October 18, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Greetings All; I am confused and hope someone can straighten me out. My confusion surrounds temporary segments and where they are created. I had assumed that temporary segments were created in a user's, assigned temporary tablespace. However when I have a creation failure, for example, if I am attempting to rebuild an index that is currently in tablespace aww_index1, I received the following error: (ORA-1652: unable to extend temp segment by 1280 in tablespace AWW_INDEX1), this is telling me that the temp segment is being created in the tablespace that the permanent object exists in. Is this always the case? Is the only purpose of the user's, assigned TEMPORARY table space for sorting. Can I tell Oracle to redirect the creation of the temp segment to a different tablespace? If so how is that accomplished? Thanks in advance. Michael L. Petrus GE Auto Warranty Services 7125 W. Jefferson Av. #200 Lakewood, CO 80235 Database Administrator Phone: (303) 987 4129 Fax: (303) 987 4298 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Petrus, Mike (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Bush INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: database degrade ???
First of all, it is pain to several versions on the same box. I think export by schema owner will work. I think this is cleaner way. Bing -Original Message- Sent: Thursday, October 18, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Hi all, We installed 815, 817 on Sun 5.6. There is an 817 database, and developers requested to build an exactly same database but at 815 level. I don't think I can copy 817's backup files and create a 815 db, since the backup already has 817 characteristics. Is there a way to do degrade? If I create an 815 db, and do an export/import, how do I make sure the dmp from 817 only have 815 characteristics. Full db export won't work, is it? And does schema export has nothing to do with Oracle version, if so, I can use schema dmp file. Thank you! Leslie __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
buffer pool
Has anyone heard of partitioning buffer pool in Oracle? I don't know this. Bing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Extents size.
May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reading dbf files
I believe logminer utility can do the job. -Original Message- Sent: Tuesday, September 25, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Anyone have something that can read the oracle dbf files? A client got my name from a friend and is asking if I can recover some of his data from a corrupt file in a database that has no backup. I have heard Oracle has something to do this but charges alot to perform this for them. I would like to help them with this and get my foot in the door for more projects like setting up backups:) I believe it is all of the clients documentation for the last 3 years. Oops:) Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: partition
That'sright. But I am curious, why you partitioned it for just 2 values? How big is the table in terms of number of rows? Bing -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, September 24, 2001 8:10 AMTo: Multiple recipients of list ORACLE-LSubject: Re: partition by default you can't change the rows part key. do a alter table table_name enable row movement; then the row can move between partitions. joe [EMAIL PROTECTED] 09/24/01 10:50AM Hello, I have a partitioned table by range on a column like STATUS , where STATUS can be either say YES or NO . i do my partitionning on this STATUS column. When i do insert in this table, data are correctly inserted in the right partition BUT if I want to update the STATUS field, it returns me an error I found ambiguous: "ORA-14402: updating partition key column would cause a partition change" The "would" is confusing , does this mean it won't do it anyhow or with some special keyword would move it to the other partition. Thanks, Maya
RE: STOP THE PRESS!!
The security was probably done by insider(s). Just a guess. I think from now on, all airlines must check everyone's names and match with photo ID (after completed boarding) to ensure all legidimate passengers are on board and check all carry on luggages/car seats/strollers/wheelchairs/laptops/walkman/CD players/any thing to ensure that every item has an authorized sticker on it. Better be late then today's tragedy. bcw -Original Message- Sent: Tuesday, September 11, 2001 12:16 PM To: Multiple recipients of list ORACLE-L All, If this is an attack by outside terrorists, please don't equate Islam with terrorism, or say things like Islamic Terrorists, Islamic Terrorism etc. Islam is as far from these acts as any religion. Islam does not condone this kind of behavior and abhors these senseless acts. Thank you. mkb --- Orr, Steve [EMAIL PROTECTED] wrote: According to the news, September 11th is the anniversary of the signing of the Camp David Accord which has been a point of contention with radical Islamic Palestinians who have taken credit for the attack. 2+2=? -Original Message- Sent: Tuesday, September 11, 2001 9:50 AM To: Multiple recipients of list ORACLE-L I am wondering whether this was an attack from outside, or from people like Timothy McVeigh. It seems to be awfully well co-ordinated, how could they breach security to that extent. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Egregious coding
Title: Egregious coding Please be aware of the following note when set to FORCE... Note: Forcing cursor sharing among similar (but not identical) statements can have unexpected results in some DSS applications and if your applications use stored outlines. -Original Message-From: John Lewis [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 06, 2001 4:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Egregious coding You can put "cursor_sharing=force" in the init file. It forces the reuse of sql even without bind variables. I had the same problem with the "javoids". -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 06, 2001 4:06 PMTo: Multiple recipients of list ORACLE-LSubject: Egregious coding Has anyone thought of a clever way to fail every SQL statement that does not use a bind variable that I could switch on and off as required? I'm looking at hundreds of thousands of queries in the v$sqlarea in production. I've taken engineering management to task over this, and have gotten empty promises in return. I would love to hold a valid threat over their heads that I'm going to shut off every statement that is not coded properly. Any ideas are appreciated. Linda
RE: Egregious coding
Title: Egregious coding Ithinkit is best to escalate this to management to deal with bad SQL coding. May be your shop needs SQL coding standard? -Original Message-From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 06, 2001 4:06 PMTo: Multiple recipients of list ORACLE-LSubject: Egregious coding Has anyone thought of a clever way to fail every SQL statement that does not use a bind variable that I could switch on and off as required? I'm looking at hundreds of thousands of queries in the v$sqlarea in production. I've taken engineering management to task over this, and have gotten empty promises in return. I would love to hold a valid threat over their heads that I'm going to shut off every statement that is not coded properly. Any ideas are appreciated. Linda
RE: Logical Backup for a large database
I would suggest to export schema by schema and schedule the jobs to run different time. In the export job, use pipe file at the unix level to compress the export file. The command is as follows: To export and compress at the unix level... mknod export_pipe p compress export_pipe export.dmp.Z exp ... file=export_pipe To import and uncompress... uncompress export.dmp.Z export_pipe imp ... file=export_pipe Bing -Original Message- Sent: Monday, August 27, 2001 2:11 PM To: Multiple recipients of list ORACLE-L DBAs Last week one of my user dropped a table since we don't have any backup except for rman backup. It is not allowe me to do any recovery on 7/24 database. Anyway we recreate the table(we are lucky, this table hold parameters) This make me think of situation of lossing very important big table. We have about 1000 tables with bigget one of 8GB . Is there any idea how to perform a logical backup on a database with 150GBs. Or take a TSPITR in case of those kind of thing happen again. From my case, imp/exp looks impossibe from point of view of timing and spacing. The question will be the same for TSOITR on large database. Is there any other way to prepre those kind of situation. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: database upgrade policy?
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Optimizer Mode......how to choose the right one?
What type of transactions are running, update, insert, delete, or select? -Original Message- Sent: Tuesday, August 07, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Take a look at index_caching parameters, they can make a big difference when using cost mode, Oracle's settings are very poor. I have a good article on my site www.vampired.net under Performance which is a great discussion about making the CBO work for you and not against you. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 12:06 PM To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Optimizer Mode......how to choose the right one?
If the transaction having problem is a SELECT statement and does SORT, then I think the sort_area_size is too small. Can you show us the SQL? -Original Message- Sent: Tuesday, August 07, 2001 9:37 AM To: Multiple recipients of list ORACLE-L Hi there, Unfortunately you can't just throw things like FIRST_ROWS at a select statement to make it run faster. The person who wrote the statement should have taken into account such things as: a) Size of tables, ordering, which is the driving table b) Indexes, are the being used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF will identify potential problem areas with your database. c) Size of queries, joins etc. Too many developers do not write code to be efficient, as long as it returns the correct values it doesn't matter whether it takes 2 minutes or 2 hours... I've spent a number of hours/days/weeks/months tidying up poorly optimised code, it's an absolute nightmare for the DBAs and it doesn't look good on the developers. Cheers, Kev. (a cheesed off developer...not a DBA!) __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 07 August 2001 17:06 To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Installing Oracle 9i
100mb for redo log file is not that big? Not big if your environment is heavy in OLTP. -Original Message- Sent: Tuesday, August 07, 2001 10:58 AM To: Multiple recipients of list ORACLE-L Friends : I am installing the database Oracle 9i. And it have suggested a parameter value 100mb for redo log file. I am confused with this value, i think it is too big. The blocksize is 8192 Connections simultaneous is 100 Where am I doing any mistake ? Eriovaldo [EMAIL PROTECTED] _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: computer history stories - Now: Age discrimination?
I decided to delete most of the messages to make this list shorter. Was any one born with Smart/Einstein ability without learning? -Original Message- Sent: Monday, August 06, 2001 11:39 AM To: Multiple recipients of list ORACLE-L IQ from what I understand is COMPLETELY related to how fast you learn. IQ is your ability to learn, nothing to do with how Smart you are. Smart is how much you know, nothing to do with how you learn. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, August 06, 2001 2:06 PM To: Multiple recipients of list ORACLE-L since when did IQ have any relation to how fast you learn? some of the most brilliant people I know are slow thinkers, who take time to process what they are learning and take even more time to make sure that what they are saying is accurate before they speak. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00600 on Production DB - Need advice
This may not be related to your problem. My shop had problem with 8.1.7, HP-UX 11.0 - 32 bit. We encountered memory leak bug. Oracle knew about it and had not had a patch yet, I think. So we disable the db handle caching. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 10:58 AM To: Multiple recipients of list ORACLE-L Mondays, gotta love em, they make Fridays worth the wait. I've got a production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an ora-600 when users try to log in. I've created a TAR (3 hours ago), but haven't gotten any response. Here's the error: ERROR: ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], [], [], [], [], [ Metalink has a couple of messages stating that this is an OS problem related to the ulimit size, availability of virtual memory, and the ability to create a pga. Suggested remedy is to increase the ulimit. My SA has dismissed this as a cause. I've knocked all the users off, but still can't log in. When I run ulimit I get the following: qe2n1: /u001/app/oracle/product/8.1.7/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
