RE: [Q] Public and private rollback segment?
Additionally: 'create rollback segment...' defaults to 'private' and the only time when I needlessly use a keyboard is to send a message like this one -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: [Q] Public and private rollback segment? This is my understanding of "private" versus "public" rollback segments: Private RBS can be brought online only via explicit ALTER ROLLBACK SEGMENT xxx ONLINE command. The "init.ora" parameter ROLLBACK_SEGMENTS is only a list for the automatic execution of ALTER ... ONLINE command at databaseinstance startup, so it is essentially the same as an explicit ALTER ... ONLINE command... Public RBS can also be brought online via explicit ALTER ... ONLINE or "init.ora" parameter ROLLBACK_SEGMENTS, if you wish... Public RBS can also be brought online at instance startupaccording to the formula using the parameters (TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT). In an OPS/RAC environment, this allows each instance to select as many public RBS from a "pool" of public RBS. The mechanism still works even in non-OPS/RAC environments too... The use of public RBS is not restricted to OPS/RAC, but it doesn't make much sense without it... it doesn't make much sense *with* OPS/RAC either, but that's just my opinion... The upshot is that the only difference between public and private RBS is this additional ability to forego the onlining at instance startupvia the ROLLBACK_SEGMENTS parameter or subsequently via ALTER ... ONLINE statements. Instead, at instance startup the simple formula using TRANSACTIONS and TRANSACTIONS_PER_ROLLBACK_SEGMENT is used. Since these are all static parameters and the difference in functionality occurs at only one point-in-time (i.e. instance startup), it really is purely a matter of style. I see no advantage to using public RBS at all... Corrections? Comments? Questions? - Original Message - From: "Baker, Barbara" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 10:09 AM Subject: RE: [Q] Public and private rollback segment? Can't remember where I copied this from, but I believe it came from metalink. I don't have a version associated with it, so things might have changed in v9. HTH Barb Public vs. Private Rollback Segments A common misconception about `Private' rollback segments is that they are segments reserved for a particular use or a particular transaction. The only difference between Public and Private rollback segments is in relation to the Parallel Server Option. A public rollback segment can be acquired implicitly by any instance in a parallel server environment. A private rollback segment must be explicitly acquired by a particular instance using the rollback_segments parameter. If not using OPS, the difference between the two is insignificant. -- From: dist cash[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: [Q] Public and private rollback segment? We have ORACLE 8.1.7.4 running on NT. My questions are: 1. What difference between public rollback segment and private segement?2. what is benefit on public segment than private segment?3. does public segment only use on "paraller server (RAC)"?Thanks. _ Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.asp-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: Baker, Barbara 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
RE: Can I index this query? slightly OT-just InterMedia Text option
Jesse, since you o have such a good experience, could you please comment on the following: I have installed InterMedia Text (8.1.7 on Win2K sp.2) and 400MB has grown to 4.5 GB. There are 4 required indices, two for each table - on English and French version of varchar2(2000). Number of data base objects (user + ctxsys schemas) is 4 times larger. Search is perfect, inserts are using 100% CPU and killing the server. What have I done wrong? Do you have any idea? By the way, I have read TFM. TIA inka -Original Message- Sent: Wednesday, October 16, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I don't think it's really that big of a step. Until a rewrite of our 3rd-party inventory system (i.e. we didn't write the damn thing), we have to rely on part description stored in two separate tables (don't ask!) in order to search for parts. By installing and adding a Context/Intermedia/Text/whateverthehell index, we've gone from a two-table FTS (200K total rows on moderately wide tables) to sub-second index access. The difficulties in getting to this point are: 1) Understanding Oracle Text concepts. Read the book! 2) Being able to change the SQL to use the OText special CONTAINS clause. 3) Understanding the data to be able to setup your thesaurus correctly. 4) Determining if/when to rebuild the index. It took me about a week of research and testing before installing and using it (of course that week's work was spread over three weeks!), and a day or two of tweaks afterwards. In my case, I needed to also create some replication-like triggers and tables to combine data from our two tables into a single, indexable, searchable table. Fire it up! We've been pretty happy with the results (except when a user wants to return every row with a Z in the string...sigh). GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Judge: ...and I'm no slouch myself. Ty: Don't sell yourself short, Judge. You're a tremendous slouch. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: Can I index this query? You could always consider something like OracleText to assist with these kind of searches, but thats a big step.. hth connor --- Carle, William T (Bill), ALCAS [EMAIL PROTECTED] wrote: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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
RE: Can I index this query? slightly OT-just InterMedia Text opt
Thank you. You are lucky, I have an Intel system with 1 CPU and 1 36GB drive. This box is running Oracle 8.1.7, IIS and custom developed applications. The drive is 94% full, there is no support for o/s or IIS or applications. The connection to the database is done over odbc, there are also some dblinks here and there and everywhere. There is a Web developer, who is the ultimate owner of the sail, the boat and the sailor. Actually there is no sailor. I look after this database out of the goodness of my heart. -Original Message- Sent: Wednesday, October 16, 2002 3:10 PM To: Multiple recipients of list ORACLE-L opt Unfortunately Inka, I don't know if I can help you. There are so many other people on this list that are much more adept at perf tuning than I, it ain't even funny. Our single OText index only takes up 70MB total, and the indexed column has very low maintenance with less than 50 inserts/updates per day (no deletes). This is fine for a 6-way HP K570, even though the CPUs are only 200Mhz PA-RISC. If I had to guess, though, I'd say most folks here would have you start with a thourough 10046 trace on the SQL. Sorry I can't be of more help! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Can I index this query? slightly OT-just InterMedia Text option Jesse, since you o have such a good experience, could you please comment on the following: I have installed InterMedia Text (8.1.7 on Win2K sp.2) and 400MB has grown to 4.5 GB. There are 4 required indices, two for each table - on English and French version of varchar2(2000). Number of data base objects (user + ctxsys schemas) is 4 times larger. Search is perfect, inserts are using 100% CPU and killing the server. What have I done wrong? Do you have any idea? By the way, I have read TFM. TIA inka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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).
Not Oracle DBA problem:APPS 11/ WinNt: HRMS export of query results generates FRM-99999 error 2 with Explorer 5 on win2000
Good morning, if it is good, which I doubt... It is not Oracle database problem, unfortunately is showing within Oracle, so...need I say more? I wonder if any of you had a misfortune (which I truly hope one had) of running into the PC set-up problem, which generates the error: FRM-9: Failed to execute command. Command =iexplore server:80/OA_HTML/bin/fndvfile.exe?id Full Details: CreateProcess:iexplore.exe server:80/OA_HTML/bin/fndvfile.exe?id error=2 I have checked MetaLink - there are similar problems - nothing worked for this case. Error is generated during ActionExport (query results). I have added to PATH C:\Program Files\Internet Explorer; and restarted that PC. That function works on another Windows2000 PC, and stopped working after a new PC was set up. Since I do not know how to spell PC, I would appreciate some directions where to look to compare both. Could it be an authorisation problem? Should user account be created locally and added to the Local Administration Group? It seems that there is only domain account. Microsoft experts in here are rather well...junior, so I need desperately some help. Since it is so distant relation to Oracle, the blessed soul who can help me, please contact me at [EMAIL PROTECTED] This way the rest of company will be spared. inka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: Verrrry interesting article at MetaLink
Jared, Yes, you should be both. Well, this not a legal advise, just my personal view: I would find a layer, who specialises in the intellectual property laws, sue Oracle ... and settle. Add a clause to the header, which will allow for usage of your scripts the way you mean it. For all those of you, who may be in the similar situation, here is an anecdote from my previous life. When times were less certain and rules adhered to seldom and far apart, the way to protect oneself in case of a future legal dispute was: - write (by hand) on whatever you created - seal in the envelope - send to oneself by the registered post - put into a safe without opening Sad but real. inka -Original Message- Sent: Thursday, October 10, 2002 3:13 AM To: Multiple recipients of list ORACLE-L Dear list, I found something rather interesting on MetaLink today. While doing a little research on UTL_FILE, I came across document # 1050919.6. This document deals with how to dump a table to an ascii file. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1050919.6 I began to think the code looked a little familiar. Then I saw the temporary file name of '_dtmp.sql', which was rather reminiscent of file names I use. Further perusal revealed that the comments were written by yours truly, and match word for word those I added to the dump.sql script years ago. See for yourself: http://www.cybcon.com/~jkstill/util/zips/dump.sql I don't know whether to be flattered or upset. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: Write caching controllers
Brian, I would not worry about it. To preclude any chance of data loss requires not having any data to loose in the first place. I lost files using EMC Symmetrix, yet I have bought more. inka -Original Message- Sent: Wednesday, October 09, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Good morning all! I have a question regarding use of write-caching RAID controllers. As an NT systems/network admin of some years, and an Oracle 8i DBA-in-training, I had done some homework and gather that both Oracle and industry best-practices suggest avoiding write-caching controllers if possible (to preclude any chance of data loss). As a result, I had recommended we purchase dual non-caching controllers on the new Compaq ML530s we are about to buy. Compaq has discontinued the model controller we requested, and now all their controllers include write caching (battery-backed, of course). We are running a couple of ~10GB instances, not terabyte OLTP - so should I just go with it and not be so anal about the caching?? Thanks and Regards, Brian NT 4.0 SP6a Oracle 8.1.7.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian 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: Inka Bezdziecka 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 clone a DB ?
On the source database run: alter database backup controlfile to trace; Edit trace file according to the file system, save it as name.sql and run it on a target database. Change init.ora where required (e.g. number of control files, rollback segments automatically brought on line, archiving destination and so on). inka -Original Message- Sent: Monday, October 07, 2002 5:33 AM To: Multiple recipients of list ORACLE-L Guys , i want to clone DB1 on host HOST1 to HOST2. i have installed oracle on HOST2 with the default DB created. the disk layout on HOST1 is different from that of HOST2. the environment is 8.1.6/win2k. the files to be copied are all datafiles , log files and control files. ami right ? since the disk layout is differnet , how should i rename the datafiles/log files/control files ? can someone throw light and explain me all the steps involved in detail ? Thanx in advance. -- 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: Inka Bezdziecka 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).
Oracle Alert #42: possible DoS
Good morning, if it is good, which I doubt... I wonder if anyone knows details of that vulnerability. I have a listener listening on ports , which are not open on the firewall. Since an attack brings down a listener only, I do not think it is relevant in this case. Am I correct? inka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: Database is 32 or 64 Bit ? - Clarification
you need to 'describe' v$session, not to 'select' from it SQL desc v$session -Original Message- Sent: Friday, October 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi Qs What do you mean by raw(4) / raw(8) ? Does it mean Length of the Field Data Value ? From my Database :- SQL select saddr from v$session where rownum 2 2 / SADDR 313941C0 CASE - Assuming on receiving a Database from a 3rd party 1) My Existing Installed ORACLE_HOME software is 64 - Bit 2) Assuming the Database Sent is a 32-Bit Database ( which i am Ignorant of ) Qs When i Bring up this 32-Bit Database using my 64-Bit Oracle Software will SADDR Still show raw(4) values ? Thanks -Original Message- Sent: Friday, October 04, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I posted the note below a few weeks ago, hope it helps John Listers, Here is a little summary of commands to identify the bit version of an o/s and 2 methods of identifying whether a database is a 32 bit or 64 bit installation Operating System Compaq Tru 64 - will be 64 bit HP-UX /usr/sbin/swlist | grep -E '32|64' returns HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment if 64 bit Sun isalist -v If the return contains the phrase 'sparcv9' then it is a 64 bit o/s Oracle Version To check Oracle version - 2 methods do a file on $ORACLEHOME/bin/oracle returns either ELF-32 or ELF-64 executable Within sqlplus desc v$session and look for the definition of saddr (if raw(4) then 32 bit else if raw(8) 64 bit) -Original Message- Sent: 04 October 2002 07:53 To: Multiple recipients of list ORACLE-L Given a Database . It is 32 Bit or 64 Bit , how can it be found ? Assuming Cold Backup of Database Sent from Elsewhere -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: 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: VIVEK_SHARMA 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backups
PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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: Gene Sais 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to get rid of a column default value ?
update table set column = null -Original Message- Sent: Friday, October 04, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE 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: Inka Bezdziecka 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).
http://orafaq.com/archive/oracle-l
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: anydata datatype update help
Rachel, do you know which system privilege of resource did the trick? inka -Original Message- Sent: Friday, October 04, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Stephane, if there is a new function, then it is hidden so deeply in the docs that even I can't find it. And I'm pretty good and coming up with creative search patterns. ANYDATA is an object, a way of storing different types of data in a single column. You store the data type metadata with the column. More information on this... when the other DBA ran the PL/SQL routine in a different account which had resource instead of just connect privileges, it ran interesting! Rachel --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel, First time I hear about the ANYDATA type but I like to share my ignorance and I guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind properly, Oracle needs two things : a) a pointer to the start of the memory area b) something to tell how big this memory area is. Either it's a 'well known' type, or you must use an end marker (typically, a '0' with character strings), or you must explicitly give a size. IMHO Oracle blows up because b) is missing. If you can insert, there must be some way of telling it how large the variable is. I can't see why it would be specific to an update (except if the PL/SQL engine is buggy, which obviously it is, but even more so than appears to the eye). Are you sure that there is not some obscure new function ... ? HTH __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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: Inka Bezdziecka 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: Performance monitoring - mostly: further derailment
Thank you Rachel. Jared, here is what I meant: select 100 * (a.value + b.value - c.value) / (a.value + b.value) from v$sysstat a, v$sysstat b, v$sysstat c, v$sysstat d where a.statistic# = 37 and /* db block gets */ b.statistic# = 38 and /* consistent gets */ c.statistic# = 39 and /* physical gets */ d.statistic# = 40 /* physical writes */ ; It had been for years the most important thing to measure - if the number was over 80%, everyone was happy. If I remember correctly, Oracle Education Services taught it at the advanced level of dba courses. If anyone remembers the beginning of this tread, the issue at hand is not how to measure performance, but what are the 10 metrics one can measure. After the first note or so, there was still a plea for the list. To add to a discussion, which derailed from the original plea for the list: Good or bad performance has very little to do with ratios, numbers, importance of transactions (by the way: from whose point of view?) Well performing system is such, that allows ALL supported by it business functions to achieve their objectives for the less possible amount of money. If a program, which produces monthly report for shareholders is poorly written from the art of programming point of view, creates a report formatted as per specifications, including colours, ready to be delivered on time - the system is performing well. Even if that program runs 5 hours except 5 minutes, as long as it is not in a way of anything else. Computers are expensive, useless gadgets when they are not working. In addition, managers are neither educated in technical nuances nor need to be. Somebody, maybe another dba, or an editor of an in-flight magazine has written somewhere that there are ten Oracle database parameters that should be measured. So, to keep all parties happy, one should produce the list, meet with users to find out what is not performing up to their expectations. When this is known, use both, common sense and the list to find out what and how can be changed. If anything, because many times the only acceptable to the business solution is: learn to like it. Amen. grandma inka -Original Message- Sent: Wednesday, October 02, 2002 9:39 PM To: Multiple recipients of list ORACLE-L we're hiring a hosting company to manage and monitor our production apps... they handed me their spreadsheet of Oracle things to monitor... I finally found wait events on that list. Buffer cache hit ratios were high on the list and flagged as critical nuh uh, didn't have time to gently explain (with the two by four) that that was going to be unacceptable. But I will have loads of time tomorrow. What scares me is that this list was compiled by experienced DBAs. --- [EMAIL PROTECTED] wrote: Buffer Cache Hit Ratio? What's that? Inka Bezdziecka [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/02/2002 08:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Performance monitoring Well ... if you need short reports, look for: 1. waits 2. buffer cache hit ratio 3. dictionary hit ratio 4. library hit ratio 5. latches 6. parsing/execution ratio 7. data file i/o 8. shared pool memory distribution 9. session contention 10. session memory usage inka -Original Message- Sent: Wednesday, October 02, 2002 7:08 AM To: Multiple recipients of list ORACLE-L Thak's Mark I agreed, but they have gotten an idea to get only couple most important measurements from db, because they don't want to have a huge reports with all possible statistics. Very understandable, but as You wrote, there isn't any absolutely top ten. In any case, I have to do this (stupid) list, so give Your best shot, please. t.Jorma Ps. I heard, that Dave Ensor from BMC, has once presented that kind of list? -Original Message- Sent: 02 October, 2002 12:23 To: Multiple recipients of list ORACLE-L Jorma, Performance tuning is a complex subject. There really isn't a list of 10 things to watch for. Every system is different. I would (attempt to) summarize tuning by these five steps: 1.) Have a capacity/performance target in mind. If you don't know where you're going, how will you know if you have gotten there? 2.) Monitor your response times as load increases. Can you achieve your response time target at the specified load? If so, you're done, successful test, congratulations. If not, continue to next step. 3.) Actively monitor what's going on in the database, while it's happening. It's always easier to see it in real time than just looking at random StatsPack snapshots taken at 5 or 10 or 15 minute intervals. (Not that I'm saying StatsPack shouldn't be collected. I'm just saying don't rely on StatsPack as your only source of info about
RE: how to find out the patch applied on different env.
Have you tried ftp://oracle-ftp.oracle.com/apps/patchsets/PATCHSET_COMPARE_TOOL/ ? I think it is not using applptch.txt. inka -Original Message- Sent: Tuesday, October 01, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Dear all, I have a situation where I need to find out the patches applied on different Oracle Application 11i (11.5.5) env. We have two environment PROD and TEST. It seems that there are some patches applied to TEST in the past few months. I would like to know what patches are applied on TEST env: Database stack Application stack $APPL_TOP Technology stack (Forms, reports, Jinitiator). There is neither manual logging system where I can find the patch details nor locating the files applpatch.txt or applptch.txt on the server. Is there any other way I can easily find out the difference between those two instances in respect to patches? Thanks in advance. Michael Sesuraj OCP. _ 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: sesuraj m 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: Inka Bezdziecka 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: Performance monitoring
-- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: SQLLdr help needed
I am not sure if it helps, but I would use: - FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '' - COMMENTS position(n:n+2000) where n=the offset of the first character of the field COMMENTS including delimiters - ROW_POCESSED SEQUENCE(MAX,1) inka -Original Message- Sent: Wednesday, October 02, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Hi All, Oracle 8.1.6 WinNT I have been trying to use sqlldr and I am getting following error Record 1: Rejected - Error on table INTERVIEW, column COMMENTS. end of logical record found when reading length of varying length field Here is sample record and control file. Any ideas why I get this error. MetaLink says TRAILING NULLCOLS should correct. The field it is complaining is second to last field in input file. 37901|01/01/1970 04:59:10||LDMARCHI||| LOAD DATA INFILE 'd:\oracle\admin\tmwktst3\scripts\BDUMPI2.txt' BADFILE 'd:\oracle\admin\tmwktst3\scripts\INTERVIEW.bad' insert INTO TABLE INTERVIEW FIELDS TERMINATED BY '|' TRAILING NULLCOLS (PROFILE_NO, INTERVIEW_DATE DATE 'MM/DD/ HH24:MI:SS', FU_DATE DATE 'MM/DD/', OPERATOR CHAR, SOURCE CHAR, APPEARANCE CHAR, FAMILY CHAR, LANGUAGE_SKILLS CHAR, CAREER_PLANS CHAR, MALPRACTICE_HIS CHAR, ECONOMICS1 CHAR, ECONOMICS2 CHAR, MET_WITH CHAR, COMMENTS varchar(4000) SUBSTR(:COMMENTS,1,2000), ROW_PROCESSED) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: Tool to load data
go to quest software home page www.gets.com -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tool to load data How do I get it for a trial? David -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tool to load data TOAD has a GUI SQL Loader interface. It lets you use a wizard to create the CTL file, then you can later just re-load that file and execute the load. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 02, 2002 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: Tool to load data Hi all, I'd like to know if there is some tool we can use to automate loading data into database using SQLLDR either via GUI or scripts. I need to allow someone to loginthe system to bulk load data without worrying he destroys database. Any advices will be appreciated. Regards,David
RE: Indexing SYS tables
Oracle Corporation has a peculiar habit of providing scripts and solutions which it does not support officially. One of them is moving sys.aud$ out of SYSTEM tablespace. See note 1019377.6 on MetaLink. inka -Original Message- Sent: Tuesday, October 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Rich, I think you're crazy adding indexes SYS tables. I would *never* add anything to sys objects. What are you going to do the first time something goes wrong and you call Oracle support and you mention you added an index and they say - hey, you're on your own! Not to mention that when you perform an upgrade, that this index may either get lost or be in the way. No, a totally bad idea. If anything, I would copy the audit records to a local table in your schema, and then index that baby anyway I'd like. That way, the system objects are the way that Oracle inteneded them to be. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 01, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: extremely long parse time
Title: RE: extremely long parse time It is useddiagnosing optimiser problems. The trace showsthe optimiser access path.One of those "should NOT be used unless explicitly requested by support"and not documented features. inka -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01, 2002 1:56 PMTo: Multiple recipients of list ORACLE-LSubject: RE: extremely long parse time I know what a 10046 trace does. What's a 10053 trace? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:42 PM To: [EMAIL PROTECTED] Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Importance: High Matt, Have you done a 10053 trace on this query? Jared "Adams, Matthew (GEA, MABG, 088130)" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? "analyze table sys.X delete statistics"? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: extremely long parse time We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt
RE: MIcrosoft Blackmail
Title: OT: MIcrosoft Blackmail Well, regardless of MS tactics, the last paragraph reads: "Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING. " What is better than RD projects? At the end one wins no matter what. Knowingmore does not hurt, does it? inka -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 10:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: MIcrosoft Blackmail Exactly. In other words, thank the MS-sales-dweeb for his time, and tell him "bye-bye now", "no-more-sales-for-you". Tom Mercadante Oracle Certified Professional -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: MIcrosoft Blackmail What exactly is your problem? Lets say that you are a factory that sells paper. You need to buy a computer system. One supplier also sell printers and the other advocate paperless office. All things being equal, which one will you give your business to?? Yechiel AdarMehish - Original Message - From: Thomas Jeff To: Multiple recipients of list ORACLE-L Sent: Thursday, September 26, 2002 1:13 AM Subject: OT: MIcrosoft Blackmail This came to our DBA team today. I'd appreciate your thoughts. I'm not a business guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice by MS? It is important from an Architecture point of view that we understand all the various approaches to "web services" (also known as "grid computing" -- see my recent report). Microsoft's dot Net initiative is their approach to this grand overarching software strategy. There is a second reason why we might be interested specifically in dot Net. Subsidiary XYZ earns $xyz a year for us from Microsoft by [performing certain services], etc. Microsoft has told our management that one of their criteria for evaluating their vendors will be how good of a MS customer is the potential vendor. Specifically, has the vendor bought in to the dot Net strategy. Now we aren't going to make our global enterprise solutions strategy decisions based upon that point alone, but it's not something we are going to ignore either. Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING.
RE: MIcrosoft Blackmail
Title: OT: MIcrosoft Blackmail Don't you think that the constant search for the nirvana of us all - a perfect solution to somebody else's problems includes pulling off the shelf that report written a long time ago? In addition,reports are just side effects of "knowing better". Are they not? I have been learning new, newer and the newest since the down of time.When dinosaurs roamed through the thousands of square meters of computer rooms hostingmagic machines with less computing power than garage door openers of today and whenrubber mallets werebasic tools of all smart computer operatorsit was easy to know it all. Now adding one to the fifth digit after the decimal point on the knowledge scale of anyone butMr.Data is a challenge. Getting a chance to know better seems like a pretty good deal to me, even if a dreaded report has to be produced. After all, it is at least one of reasons why we all subscribe to this list - to know better. grandma inka -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: MIcrosoft Blackmail you obviously have not wasted enough time with tasks like this. they really suck. you end up spinning your wheels for a week, all for nothing. your report ends up on somebody's shelf someplace - never read. and 6 months later, they ask the same questions. the biggest task that a body needs to learn is how to duck these research projects. unless you *really* like doing them. Tom Mercadante Oracle Certified Professional -Original Message-From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: MIcrosoft Blackmail Well, regardless of MS tactics, the last paragraph reads: "Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING. " What is better than RD projects? At the end one wins no matter what. Knowingmore does not hurt, does it? inka -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 10:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: MIcrosoft Blackmail Exactly. In other words, thank the MS-sales-dweeb for his time, and tell him "bye-bye now", "no-more-sales-for-you". Tom Mercadante Oracle Certified Professional -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: MIcrosoft Blackmail What exactly is your problem? Lets say that you are a factory that sells paper. You need to buy a computer system. One supplier also sell printers and the other advocate paperless office. All things being equal, which one will you give your business to?? Yechiel AdarMehish - Original Message - From: Thomas Jeff To: Multiple recipients of list ORACLE-L Sent: Thursday, September 26, 2002 1:13 AM Subject: OT: MIcrosoft Blackmail This came to our DBA team today. I'd appreciate your thoughts. I'm not a business guy, just a plain old Apps DBA, but this really pisses me off. Is it common practice by MS? It is important from an Architecture point of view that we understand all the various approaches to "web services" (also known as "grid computing" -- see my recent report). Microsoft's dot Net initiative is their approach to this grand overarching software strategy. There is a second reason why we might be interested specifically in dot Net. Subsidiary XYZ earns $xyz a year for us from Microsoft by [performing certain services], etc. Microsoft has told our management that one of their criteria for evaluating their vendors will be how good of a MS customer is the potential vendor. Specifically, has the vendor bought in to the dot Net strategy. Now we aren't going to make our global enterprise solutions strategy decisions based upon that point alone, but it's not something we are going to ignore either. Therefore, I support investigating SQL server, Biz Talk, and dot Net, but I emphasize the word INVESTIGATING.
RE: RAC (Real Application Clusters)
I have a ZX3 Focus (lady driven, low mileage, autumn red) which I gladly exchange for a Ferrari (any colour) or Aston-Martin (only racing green). Are you interested? -Original Message- Sent: Thursday, September 26, 2002 12:03 PM To: Multiple recipients of list ORACLE-L RAC isn't meant to be cheap. It is a fault-tolerant technology. You cannot buy a Ferrari or Aston-Martin for $15,000 with only 2.5% APR. As a matter of fact, when you are buying a red Ferrari, you are probably not even going to mention APR. That is a difference between Ford Focus or Dodge Neon and a Ferrari. On the other hand, Neon or Focus probably do have better gas mileage. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: RAC (Real Application Clusters) Glenn - I have a question you could ask. Oracle talks about how RAC will allow Oracle to make better use of cheap computers. To me the weak point is how much bandwidth you have between the nodes. If you have a gigabit fiber optic connection between the nodes, it might work well, but suppose you have a shared LAN? To me, RAC would work quite nicely in a clustered server, but then we've strolled away from cheap, haven't we? This point is keeping my hardware people from buying into the concept. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, September 26, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am visiting Oracle next week and will be getting a dog-and-pony show on Oracle 9i and RAC (Real Application Clusters). Does anyone have any experience or comments on this product/technology? Can you suggest some burning questions I can pose to Oracle when we get the demos? This is a technical overview and we will be seeing conversions (Apps and non-Apps environments) as well as failure scenarios. Any advice/comments are welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Inka Bezdziecka 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: RAC (Real Application Clusters)
Checking the syntax? I had a friend ones, who used to say that I had a heavy accent even when I wrote. So there. Well, more and more often B'essDBAFH-driven straight to the nuthouse. Ladies drive to an insane asylum. Am I correct? -Original Message- Sent: Thursday, September 26, 2002 2:08 PM To: Multiple recipients of list ORACLE-L lady-driven? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 11:55 AM I have a ZX3 Focus (lady driven, low mileage, autumn red) which I gladly exchange for a Ferrari (any colour) or Aston-Martin (only racing green). Are you interested? -Original Message- Sent: Thursday, September 26, 2002 12:03 PM To: Multiple recipients of list ORACLE-L RAC isn't meant to be cheap. It is a fault-tolerant technology. You cannot buy a Ferrari or Aston-Martin for $15,000 with only 2.5% APR. As a matter of fact, when you are buying a red Ferrari, you are probably not even going to mention APR. That is a difference between Ford Focus or Dodge Neon and a Ferrari. On the other hand, Neon or Focus probably do have better gas mileage. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: RAC (Real Application Clusters) Glenn - I have a question you could ask. Oracle talks about how RAC will allow Oracle to make better use of cheap computers. To me the weak point is how much bandwidth you have between the nodes. If you have a gigabit fiber optic connection between the nodes, it might work well, but suppose you have a shared LAN? To me, RAC would work quite nicely in a clustered server, but then we've strolled away from cheap, haven't we? This point is keeping my hardware people from buying into the concept. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, September 26, 2002 10:04 AM To: Multiple recipients of list ORACLE-L I am visiting Oracle next week and will be getting a dog-and-pony show on Oracle 9i and RAC (Real Application Clusters). Does anyone have any experience or comments on this product/technology? Can you suggest some burning questions I can pose to Oracle when we get the demos? This is a technical overview and we will be seeing conversions (Apps and non-Apps environments) as well as failure scenarios. Any advice/comments are welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Inka Bezdziecka 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
RE: DBA place in the business (was RE: DBA work load)
and DDBA, and ODBA, and DA, and DM, and DWA, and DWM ... any more? -Original Message- Sent: Thursday, September 26, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Have you gone through what's the difference between an application DBA and a database DBA? yet? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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 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: Inka Bezdziecka 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-03113 with dbms_output and sysdate
Seems like not a network then. Have you read a note 1020463.6 (mind you, it is a bit dated)? inka -Original Message- Sent: Tuesday, September 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L I will try that. The confusing part is I can run : select TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') into datevar from dual; dbms_output.put_line( datevar); and it works fine. I can run all my other sql scripts without error. I'd be surprised if it was a network error, but I'm willing to look at anything. steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 1:23 PM It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: Steve Perry 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: DBA work load
-Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: DBA work load
It is your own fault. You should have called all interested parties with details as soon as that problem was resolved. And remember: if by any chance the problem resolution takes all night, call hourly with the progress report. -Original Message- Sent: Wednesday, September 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Yes, of course. If, like last night, I needed to dial in from home for 2 hours then I get compensated by coming in early the next day to answer questions about what happened. -Original Message- Sent: Tuesday, September 24, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: DBA work load
than a month or two. He replied that he was now entering his third month in just such an environment... ..I think he lasted another 3 months or so, but ultimately with the inevitable result. A truly heroic performance, but somewhat reminiscent of Wile E Coyote trying to scramble back to the cliff's edge, having been lured into thin air by the Road Runner... --- Of course, if you don't have a 24x7 environment enforced by service-level agreements, then your mileage may vary. Obviously, there are environments that get by quite well on 1, 2, or 3 DBAs, but I am certain that they are not truly 24x7 nor is instability in those environments... But the point is that the job of database administrator is like any other critical support role. Only the medical profession is so criminally idiotic as to expect and demand 30- and 40-hour shifts from its most valuable personnel... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 23, 2002 7:43 PM I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want Industry Standards, like how many Databases can one DBA manage. Or how many GB/DBA or endusers/DBA? Does anyone keep these kind of stats? thanks __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tony ynot 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: Sujatha Madan 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: Inka Bezdziecka 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-03113 with dbms_output and sysdate
It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') ); 6 7END; 8 9 / TUE, SEP 24 12:59:21002 PL/SQL procedure successfully completed. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 24, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but still no help. Nothing shows up in the alert log and there are no trace files. I have the work around, but I want to find out why/how to fix it and the root cause. Can I set an event and get more information about it when the error happens? That's the direction I'm headed. Thanks, Steve oracle 8.1.7.3 on Win NT 4.0 svc pack 6 sys(38)@INS declare 2 3 begin 4 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS YYY') ); 6 7 end; 8 / ERROR: ORA-03114: not connected to ORACLE declare * ERROR at line 1: : end-of-file on communication channel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Perry 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spool Oracle Tables into Excel Format
I have never thought that I would ever suggest using GUI tool over a command line. Perhaps there is a first time for everything. So, may I add to the list of good advices: use T.O.A.D. from http://www.quest.com/toad/ Disclaimer: I am not in any form affiliated with Quest Software nor I try to enforce or market its products. I have just found that I am too lazy to use SQL*Plus all the time. inka -Original Message- Sent: Monday, September 23, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Bob, All of the options stated by people from this list are excellent. One thing that was not mentioned was that Excel can read any type of text file. It will notice that it is a text file, and will provide you with the opportunity to declare what the column delimiter is. What this means is that you can use any character as a field delimiter, tell Excel what that column is, and it will convert the file for you. By default, Excel likes the TAB char as a column delimiter. So, you can write your query as such: select column1||char(10)||column2||char(10)||column3||char(10) from table_name. Spool the output and name the file newfile.txt; start Excel, and file|open the file and follow the help wizard. I do this all the time. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 20, 2002 4:33 PM To: Multiple recipients of list ORACLE-L All, Is it possible to create Oracle reports into Excel format ? Is it possible to spool Oracle tables into Excel format? Thanks in Advance Bob __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: SNP uses 60% of CPU on Windows2000 - please help
Thank you for all the help. I agree that something is wrong and I will keep looking for it when new fires, with higher priorities, are put out. This morning another problem occurred (luckily!!!) on that server, and the server was re-booted. So far CPU usage oscillates between 1% and 50%, and it is not oracle.exe, which utilizes it. Once more thank you all. inka -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: _spin_count Revealed
Well ... although you are correct, you forgot to mention that there is a hidden table sys. fence$, leftover from the archaic time, which (table, not time) has a column drift# (Boolean) and one row. Default value is FALSE and unless changed manually to TRUE, the_centripedal_acceleration parameter works only up to 1K spin. In addition one has to alter session set nls_territory= western before updating fence$. inka -Original Message- Sent: Wednesday, September 18, 2002 2:19 PM To: Multiple recipients of list ORACLE-L All I'm saying is that the parameter wouldn't have nearly as much effect as the _centripedal_acceleration parameter, which as we all know keeps the bits from flying off of HDs, especially the 15K spin. I believe it's undocumented now, since setting it to false caused corruption from bit loss. (how's that?) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: _spin_count Revealed Such a drag to detract from a good story using facts... ...which is how the whole discussion got started... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 9:18 AM I doubt the _counter_corriolis_effect parameter would do much: http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka 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: Lost ofall redo logs
The most important - do not panic. Than, read note 94119.1 on MetaLink. Here is a part of it: Recovery with missing online redo logs Missing online redo logs means that somehow you have lost your redo logs before they had a chance to archived. This means that crash recovery cannot be performed, so media recovery is required instead. All datafiles will need to berestored and rolled forwarded until the last available archived log file is applied. This is thus an incomplete recovery, and as such, the recover database command is necessary. (i.e. you cannot do a datafile or tablespace recovery). As always, when an incomplete recovery is performed, you must open the database with resetlogs. Note: the best way to avoid this kind of a loss, is to mirror your online log files. Recovery with missing archived redo logs If your archives are missing, the only way to recover the database is to restore from your latest backup. You will have lost any uncommitted transactions which were recorded in the archived redo logs. Again, this is why Oracle strongly suggests mirroring your online redo logs and duplicating copies of the archives. Recovery with resetlogs option Reset log option should be the last resort, however, as we have seen from above, it may be required due to incomplete recoveries. (recover using a backup control file, or a point in time recovery). It is imperative that you backup up the database immediately after you have opened the database with reset logs. The reason is that oracle updates the control file and resets log numbers, and you will not be able to recover from the old logs. The next concern will be if the database crashes after you have opened the database with resetlogs, but have not had time to backup the database. How to recover? Shut down the database Backup all the datafiles and the control file Startup mount Alter database open resetlogs This will work, because you have a copy of a control file after the esetlogs point. Media failure before a backup after resetlogs. If a media failure should occur before a backup was made after you opened the database using resetlogs, you will most likely lose data. The reason is because restoring a lost datafile from a backup prior to the resetlogs will give an error that the file is from a point in time earlier, and you don't have its backup log anymore. Good luck. inka -Original Message- Sent: Wednesday, September 18, 2002 4:44 PM To: Multiple recipients of list ORACLE-L What about mirrored redo group members? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 4:30 PM Hi people... What to do if I have LOST ALL REDO LOGS and i don´t have any backup? Thanks in advance! : Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Bra5il [EMAIL PROTECTED]http://www.upf.br : -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert 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: Igor Neyman 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
RE: SNP uses 60% of CPU on Windows2000 - please help
Thanks, my problem is that I hardly know how to spell Windows. Performance monitor shows Paging file usage at zero. On Oracle side I altered system and set job_queue _process = 1. when I run select vb.name NOME, vp.program PROCESSNAME, vp.spid THREADID, vs.sid SID, vs.program from v$session vs, v$process vp, v$bgprocess vb where vb.paddr '00' and vb.paddr = vp.addr and vp.addr = vs.paddr; I got an output: NOMEPROCESSNAME THREADIDSID PROGRAM PMONORACLE.EXE 15801 ORACLE.EXE DBW0ORACLE.EXE 14042 ORACLE.EXE LGWRORACLE.EXE 15843 ORACLE.EXE CKPTORACLE.EXE 15884 ORACLE.EXE SMONORACLE.EXE 15925 ORACLE.EXE RECOORACLE.EXE 15966 ORACLE.EXE SNP0ORACLE.EXE 16007 SNP2ORACLE.EXE 262435 dllhost.exe SNP3ORACLE.EXE 25328 dllhost.exe ARC0ORACLE.EXE 163611 ORACLE.EXE SNP4ORACLE.EXE 178418 dllhost.exe SNP5ORACLE.EXE 644 23 dllhost.exe As far as I know, dllhost.exe is ASP execution engine. So the culprit may be on the application side, not Oracle. Does that make any sense? inka -Original Message- Sent: Tuesday, September 17, 2002 10:49 AM To: Multiple recipients of list ORACLE-L I have had times on Win NT boxes when the CPU went to 100%. My experience is that this happens when the OS is thrashing the swapfile (writing it into and out of memory on a continuous basis). If the disk I/O is also very high then that may be what's happening. However, 800M free out of 2G does not look too bad. If you don't have the high disk I/O then the SGA is probably not the issue. I don't want to push you in the wrong direction either. HTH Inka Bezdziecka To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] IBezdziecka cc: @cupe.caSubject: RE: SNP uses 60% of CPU on Windows2000 - please help Sent by: root 09/16/2002 03:38 PM Please respond to ORACLE-L The server has 2GB, free at the moment 800MB. Do you think that SGA size may have something to do with it? -Original Message- Sent: Monday, September 16, 2002 2:58 PM To: Multiple recipients of list ORACLE-L How much physical RAM do you have and how much are you using? Check the Task Manager on the performance tab under MEM Usage to get that figure. Inka Bezdziecka To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] IBezdziecka cc: @cupe.caSubject: SNP uses 60% of CPU on Windows2000 - please help Sent by: root 09/16/2002 01:13 PM Please respond to ORACLE-L Hello, I run into a problem, which I cannot solve myself and would greatly appreciate any help. Oracle 8.1.7.0.0 utilises 99% of CPU on a Windows2000 server, which also has to run MS IIS and a few applications. There are 9 user connections (from MS IISv.5, using Oracle ODBC). There are no waits, no locks, basic statistics values are very good. I found the SNP process executing queued jobs using 60% of CPU. There are no queued jobs (current, broken or any other) in the neighbourhood, never mind on that server. The sql_text shows: BEGIN sys.dbms_ijob.remove(:job); END; It seems, that the high
RE: SNP uses 60% of CPU on Windows2000 - please help
That was the starting point of entire problem. An IIS administrator came to me complaining that Oracle.exe uses 99% of CPU. Indeed, it does. What is actually wrong with oracle.exe using 99% of CPU? Every other process shows 00 under CPU and small numbers under time. I am getting to think that I was sent on a wild goose chase. That web site is up and response time is not worse that it has always been. The server is very slow in processing o/s management requests (starting performance monitor or sql*plus, or something of a sort) - well ... Thank you anyway. inka -Original Message- Sent: Tuesday, September 17, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Go to your Task Manager again and pick the processes tab. Click on 'CPU' to sort the processes by CPU usage or 'CPU Time to get who has run up the most CPU usage since you last booted the system. All of your Oracle treads run in one process, ORACLE.EXE. The dllhost.exe should be there as a separate process. Though from what you show in your query I could be wrong. Inka Bezdziecka To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] IBezdziecka cc: @cupe.caSubject: RE: SNP uses 60% of CPU on Windows2000 - please help Sent by: root 09/17/2002 01:28 PM Please respond to ORACLE-L Thanks, my problem is that I hardly know how to spell Windows. Performance monitor shows Paging file usage at zero. On Oracle side I altered system and set job_queue _process = 1. when I run select vb.name NOME, vp.program PROCESSNAME, vp.spid THREADID, vs.sid SID, vs.program from v$session vs, v$process vp, v$bgprocess vb where vb.paddr '00' and vb.paddr = vp.addr and vp.addr = vs.paddr; I got an output: NOME PROCESSNAMETHREADID SID PROGRAM PMON ORACLE.EXE 1580 1ORACLE.EXE DBW0 ORACLE.EXE 1404 2ORACLE.EXE LGWR ORACLE.EXE 1584 3ORACLE.EXE CKPT ORACLE.EXE 1588 4ORACLE.EXE SMON ORACLE.EXE 1592 5ORACLE.EXE RECO ORACLE.EXE 1596 6ORACLE.EXE SNP0 ORACLE.EXE 1600 7 SNP2 ORACLE.EXE 2624 35 dllhost.exe SNP3 ORACLE.EXE 2532 8dllhost.exe ARC0 ORACLE.EXE 1636 11 ORACLE.EXE SNP4 ORACLE.EXE 1784 18 dllhost.exe SNP5 ORACLE.EXE 644 23 dllhost.exe As far as I know, dllhost.exe is ASP execution engine. So the culprit may be on the application side, not Oracle. Does that make any sense? inka -Original Message- Sent: Tuesday, September 17, 2002 10:49 AM To: Multiple recipients of list ORACLE-L I have had times on Win NT boxes when the CPU went to 100%. My experience is that this happens when the OS is thrashing the swapfile (writing it into and out of memory on a continuous basis). If the disk I/O is also very high then that may be what's happening. However, 800M free out of 2G does not look too bad. If you don't have the high disk I/O then the SGA is probably not the issue. I don't want to push you in the wrong direction either. HTH Inka Bezdziecka To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] IBezdziecka cc: @cupe.caSubject: RE: SNP uses 60% of CPU on Windows2000 - please help Sent by: root 09/16/2002 03:38 PM Please respond to ORACLE-L The server has 2GB, free at the moment 800MB. Do
RE: problems creating a context index
Check on MetaLink note: 147362.1; also extproc might have been deleted (see Security Alert 29) inka -Original Message- Sent: Thursday, September 12, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Hello All; I am being plagued with an error I can't get my hands around when I try to recreate a context index. The index existed previously, but when I tried to sync new data I got an error, then I attempted rebuilding the index from scratch and got the same error (see below). I checked the $ORACLE_HOME/lib directory and found the library that the error indicates as missing. Any help would be greatly appreciated! sql statements executed: call Ctx_Ddl.Drop_stoplist ('my_stoplist') / call Ctx_Ddl.create_stoplist('my_stoplist') / drop index TFNR_DISPLAY_NAME_IDX_C / create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) indextype is ctxsys.context parameters ('stoplist my_stoplist') / error returned: Call completed. Call completed. drop index TFNR_DISPLAY_NAME_IDX_C * ERROR at line 1: ORA-01418: specified index does not exist create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: ConText error: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open failed: No such file or directory ORA-06512: at CTXSYS.DRUE, line 122 ORA-06512: at CTXSYS.TEXTINDEXMETHODS, line 34 ORA-06512: at line 1 Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reorganizing a database
You can drop/re-create users and tablespaces, and import users. Down timealso depend on i/o bus and disk system. inka -Original Message-From: Brooks, Russ [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: Reorganizing a database Hi, We are creating a 45GB database from a restore of a current system. My boss has requested that I reorganize the entire new database. I have my doubts that this will provide as much benefit as he seems to expect, but they are adamant that this is what they want. One of the desired effects is to resize all the datafiles to uniform sizes and distribute some I/O. I'm thinking of using a full export as the base of this activity, splitting the export. This will be done on an HP L class with 2 500MHz processors and 3 GB of memory. What is the best way of accomplishing this as quickly and painlessly as possible? I've looked through Metalink and various books without finding a good general procedure for changing the location and sizes of the datafiles during the import. About how long should this take (ballpark)? Thanks, Russ
RE: Misinformation Ranting
Have you brought to that meeting some basic storage statistics? If she is a decision maker, the only thing to do is to provide solid and dry technical information. Expected outage time of SAP including. inka -Original Message- Sent: Tuesday, September 10, 2002 4:29 PM To: Multiple recipients of list ORACLE-L RANT I've just spent 30 minutes with our SAP administrator trying to convince her that we really don't need to reorganize the tables in our production SAP database. Due to some misinformation in an Oracle Press book, 'Oracle Unleashed' I think, she is equating number of extents with fragmentation. The text she referred me to is in fact discussing 'migrated rows' though that term is never used. She has become convinced that if the extents allocated for tables are not all in contigous space, some very nasty fragmentation will occur. I tried taking it down to disk and explaining that an OLTP system with hundreds of users won't really see much benefit from this, but she wasn't really ready for that. :) Her concern is that there are 29000 extents in an index tablespace. This might have something to do with there being 3400 indexes in said tablespace. Total 'wasted' ( honeycomb ) space in this 250 gig DB is 20 meg. Not much to gain there. The text of the book states that you should expect a '10 to 20 percent performance increase' by reorganizing the tables/indexes. No data to back it up of course. This is on a database that performs very well most of the time, outside of a couple of custom reports that run too long. No complaints from users about slowness. Arrghhh! I just had to vent to the list, cuz there's no one here that understands. \RANT Jared -- 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AW: Oracle Application Server BUT how about 11i
Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which is just a web server) as one of components. It requires two Oracle RDBMS technology stacks: 8.0.6 and 8.1.7 - it is very likely that for the latest release a database itself can be upgraded from 8.1.7 to 9i. If you need details check appsnet.oracle.com -Original Message- Sent: Thursday, August 29, 2002 11:59 AM To: Multiple recipients of list ORACLE-L I'm confused too. What's 11i?? Is this an SAP-like application? How does it tei to 9i DB and 9i AS? Thanks for any input. ltiu Stefan Jahnke wrote: Hi I always thought iAS refers to a whole suite of things. The webserver (which is an Apache in iAS) is one component. But there is more to it like J2EE containers, a servlet engine, mod_perl (?), messaging and other stuff (haven't really into anything besides J2EE EJB containers, the web server and the servlet engine..). regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] *visit our website: http://www.bov.de http://www.bov.de/* *subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp* *Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar? Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns an unter 0 18 03 / 73 64 62 73!* Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- *Von:* Alessandro Guimaraes [mailto:[EMAIL PROTECTED]] *Gesendet:* Donnerstag, 29. August 2002 15:23 *An:* Multiple recipients of list ORACLE-L *Betreff:* Re: Oracle Application Server Hi, IAS - Apache OAS- SpyGlass OAS and iAS are webservers. iAS is basically the same as OAS, but the major difference is the listener is an Apache, and from cartridges to modules. iAS is more or less the 'next generation' of OAS as Oracle8i was the next generation of Oracle8. Regards, Alessandro Guimaraes *From:* Boivin, Patrice J mailto:[EMAIL PROTECTED] *To:* Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] *Sent:* Thursday, August 29, 2002 5:28 AM *Subject:* RE: Oracle Application Server there was a discussion re. the OWS/OAS/OWAS/iAS versions a week or two ago on this list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- *From:* sultan [mailto:[EMAIL PROTECTED]] *Sent:* Thursday, August 29, 2002 3:50 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Oracle Application Server Hi friends I would like to know is there any difference between Oracle Application Server and Oracle 9i Application server.? If there is difference ,then what is the First version of Oracle 9i Application Server? The term is confusing me. Any one clarrify me please. Thanks in advance syed -- 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services
RE: AW: Oracle Application Server BUT how about 11i
It has always been. SAP is just one of ..., as is Oracle - and none will go away for the foreseen future. The common competitor is, or would like to be, Microsoft with its acquisition of Great Plains. -Original Message- Sent: Thursday, August 29, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Thanks. So does this mean 12i or 13i will be a combo between the Oracle DB and the Oracle E-Biz (can I hear people say integration)? If this happens then SAP is toast! ltiu Inka Bezdziecka wrote: Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which is just a web server) as one of components. It requires two Oracle RDBMS technology stacks: 8.0.6 and 8.1.7 - it is very likely that for the latest release a database itself can be upgraded from 8.1.7 to 9i. If you need details check appsnet.oracle.com -- 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-3120 querying across a DB-Link from a 9i2 db to and 8.1.7
It is a known problem; see note 19796.1 on MetaLink -Original Message- Sent: Wednesday, August 28, 2002 11:59 AM To: Multiple recipients of list ORACLE-L We get ORA-03120 errors when using Windows SQLPlus 8.0.6 connecting to a 9.2.0.1 Database and querying across a DB-Link to an 8.1.7 database. Server Database : 9.2.0.1 on Solaris 2.8 Client SQLPlus : 8.0.6 on Windows Target DB which DB-Link connects to : 8.1.7.2 on Tru64 A Public Database link in the 9.2.0.1 database on Solaris has been created to connect to the 8.1.7.2 Database on Tru64. When running the query SELECT * FROM TAB@R11TEST_LINK using a 9.2.0.1 SQLPlus [ie on the server], there are no errors. If the client connects from a Windows PC running SQLPlus 8.0.6 to the 9.2.0.1 database and then queries across the link, with the same query SELECT * FROM TAB@R11TEST_LINK we get the ORA-03120 error. If we SET ARRAYSIZE=1, we get one record before the error. If we SET ARRAYSIZE=100, we get the error immediately. ORA-03120 : two-task conversion routine: integer overflow Anyone seen anything similar ? I do have TAR open currently. Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).