RE: RE: OCP 9i New Features for DBAs
Jared, I didn't make a detailed list but where I clearly noticed the inaccuracies was in the sample exam questions at the back of the book e.g. In which version of Oracle was hash partitioning introduced? A) 7 B) 8 C) 8i D) 9i Answer D. The real answer as we know is C. Which statement is true about the TIMESTAMP WITH TIME ZONE datatype? A) It represents absolute time. B) In addition to the date and time, you can store the time zone displacement (offset), which requires additional bytes of storage. C) In addition to the date and time, you can store the time zone displacement (offset), without consuming additional bytes of storage. D) You can use the NLS_TIMESTAMP_TZ_FORMAT initialisation parameter to specify the default timestamp format for retrieval. Answer C. The real answer is B. What this means is that you need to checkout the answers when marking yourself just to be on the safe side. I must point out that on a couple of occaisions the book was right when I initially thought it was wrong. Cheers, Chris -Original Message- Sent: 20 November 2003 18:35 To: Multiple recipients of list ORACLE-L Chris, Care to share details on the inaccuracies? Jared Dunscombe, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/20/2003 02:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: OCP 9i New Features for DBAs Ryan, I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to
RE: ora-600 / ora-00604 during migrate
Problem solved thanks to ots Event 1399 solved it, necessary during migrate Regards, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: Thursday, November 20, 2003 21:46 Aan: 'Jeroen van Sluisdam' Onderwerp: RE: ora-600 / ora-00604 during migrate Jeroen - I think at least for the U.S. that the form says something like critical business impact. I have had a test database treated as a priority 1. At this point you could try calling on the phone and asking to change the priority. Or you could file another TAR and ensure it gets rated a priority 1. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:42 PM To: DENNIS WILLIAMS; '[EMAIL PROTECTED]' -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden: donderdag 20 november 2003 21:41 Aan: 'DENNIS WILLIAMS'; '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Dennnis, Priority 2. I have tried export but after 3 days of experimenting And not getting results I switched to this scenario How could I persuade them to go to priority 1 if this isn't A production situation? Tnx, Jeroen -Oorspronkelijk bericht- Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Verzonden: donderdag 20 november 2003 21:24 Aan: '[EMAIL PROTECTED]' CC: '[EMAIL PROTECTED]' Onderwerp: RE: ora-600 / ora-00604 during migrate Jeroen - What priority did Oracle assign the TAR? Given the seriousness of your situation, you should get it rated a priority 1. Is there any possibility you can export/import your data instead of performing a migration? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 20, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hi, I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4 Error occurs during issueing alter database open resetlogs migrate All previous steps (all according to the migrate manual): Migprep Mig Alter database convert Succeeded successfully Details: HP-UX 11.11 Source-DB 7.3.4.5 (HP11 version) Target 9.2.0.4 Error in alert-file: Errors in file /var/opt/oracle/product/admin/VU_2/bdump/vu_2_smon_8589.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003 Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_9760.trc: ORA-00600: internal error code, arguments: [16608], [2], [0], [0xC000234BAB80], [], [], [], [] I could find one similar notice on metalink but it didn't describe what they did to resolve this. I entered a tar, but probably too late for today. I need help urgently because this is causing Major problems in our timeschedule for testing and going live as planned in 2 weeks. Hope you can help soon, Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam 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: pl/sql question and owa_pattern question
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive tasks. 'Native compiling', ie turning PL/SQL in C,
might improve performance. However, in my view the best performance gains you may get
is by, so to speak, pushing the bulk of the processing deeper into the kernel (which
isn't by the way exclusive of native compiling). Using a function such as INSTR() will
be much more efficient than looping on characters.
I would suggest something such as :
- First use TRANSLATE() to replace all the characters you want to get rid of by a
single, well identified character, say # (use CHR() || ... for non printable
characters - you can build up the string of characters to translate in the
initialisation section of a package rather than typing it).
- Start with initializing your string to LTRIM(string, '#')
- Then as long as pos := INSTR(string, '#') isn't 0,
get your token as substr(string, 1, pos - 1) then assign ltrim(substr(string, pos
+ 1), '#') to string (very similar to what you were planning to do with owa).
This will be probably much faster than a character-by-character loop and calls to an
owa package.
HTH,
Stephane Faroult
- --- Original Message --- -
From: Guang Mei [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thu, 20 Nov 2003 19:39:55
Hi:
In my pl/sql program, I want to process each word
in a string. The
string is selected from a varchar2(300) column. The
delimit that separates
the words is not necessary space character. The
definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9,
A-Z,a-z)
and
2. the character is not one of these: '-.,/*_'
Now my program is basically checking each
character, find the delimit, and
rebuild each word. After that I process each
word. The code looks like
this:
---
str := This will be a long string with length
upto 300 characters, it
may contain some invisible characters';
len := length(str)+1;
for i in 1..len loop
ch := substr(str,i,1);
if (not strings.isAlnum(ch) and
instr('-.,/*_', ch)1) then
if word is not null then
-- do some processing to variable word !
word := null;-- reset it
end if;
else
word := word || ch; -- concat ch to word
end if;
end loop;
---
I think It's taking too long because it loops
through each characters. I
hope I could find a way to speed it up. I don't
have experiience in
owa_pattern, but I thought there might be a way to
do it here:
str := This will be a long string with length
upto 300 characters, it
may contain some invisible characters';
newstr := str;
pos := 1;
while pos != 0 loop
pos := owa_pattern.amatch(newstr, 1, '\W');
-- how can I mask out
these '-.,/*_' ???
word := substr(newstr, 1, pos-1);
-- do some processing to variable word !
if pos != 0 then
newstr := substr(newstr, pos+1);
end if;
end loop;
--
My simple tests showed that owa_pattern call is
much slower than direct
string manupilation. But I would like to try it in
this case if I could
easily get the wrods from the string. Any
suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Data Guard
Hello. I'm trying to setup standby database on w2k, Oracle 9.2.0.4 (win). When I create configuration and press next on step where we set destination of datafile to be copied to an error occures: READY_A 'perlglob' is not recognized as an internal or external command, operable program or batch file. glob failed (child exited with status 1) at - line 3468. What is this and where can I find solution? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Re: IOT Tuning Question
Zhu Chao, You are right to say that with a heap organized table you also have the index to encumber the SGA and indeed you are right to say that, as I put it, what I said is not totally correct. I should have been more specific. The reference to _partitioned_ IOTs implicitly associated them to full partition scans in my mind, because the case I was referring to was some massive swoop among a lot of data, with many scans. In such a case, then indexes in general, and IOTs in particular, tend to stay much longer than required in memory, which may become a problem over time with long running processes (while table blocks are prime candidates for replacement after full scans). Quite obviously, if you are doing mostly indexed accesses, the picture may be different. I don't think that with 3 columns, unless they are well-filled VARCHAR2(4000) columns (you never know, with 3rd party software ...) overflow will be much of a problem. I'd rather fear contention, but of course it depends on the level of concurrency. SF - --- Original Message --- - From: zhu chao [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 20 Nov 2003 17:50:11 Hi, Jay: Since your table is just a table with 1M records and you have only three columns(all of them are pk), so using IOT is really an good candicate. The space save is not important because 1M records with three columns typically consumes several megabytes, which is not important at all these days. If your table is heavily DMLed, then using IOT reduced the DML to the base table, so less IO generated and less redo. I do not think SF's words are correct. IOT is indices, right. But Regular tables with indexes also consumes memory in SGA, and the index on the regular do the same thing as IOT table does. And the base table itself also consumes SGA memory. Overflow in IOT(oracle 8i) is just heap organized, in 9i it is also index organized(from my test), so if your table has overflow segment, and you insert more and more data into the table, IOT *WILL* be less efficient and you need to move the overflow segment to make the table efficient. Regards. zhu chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 21, 2003 12:30 AM Jay, On the paper, your table is indeed a good candidate for an IOT - it will save you the space used by the table (you will only have the primary key index). However, there may be gotchas. I have noticed in the past that IOTs, being primarily indices, have a tendency to be a bit 'sticky' in the SGA. I have seen massive processes wading through enormous amounts of data significantly slowing down over time with an IOT, and my interpretation was that the IOT was slowly filling up the SGA, letting fewer and fewer space to the rest. Also, think carefully about partitioning; it depends on how you query your table, mostly. It will be beneficial during inserts if you insert your rows in a random fashion in all partitions. Using a reverse key is also something you may want to consider if you have no range scan, it will help with contention. I don't think that there is an obviously good solution; it needs testing. HTH, SF - --- Original Message --- - From: Jay Wade [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 20 Nov 2003 07:44:59 Hello: I'm looking at trying to tune a 3rd party app and was wondering if anyone could tell me if my assumptions are on base. The table contains three columns, each is part of the primary key, with about 1 million + rows. I figured that it would be an ideal candidate for using a partitioned IOT, but since records are frequently inserted am I correct in assuming that it would be better to use regular partitioned table using a primary key? Since this is a 3rd party application I can't change much of the layout, if anyone has any ideas it would be greatly appreciated. Regards, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Health Template-OT
Dennis .. You are right ...but what can we do if someone demands for such a report .. They want to analyze and track every info . Shibu -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Thu 11/20/2003 12:34 AM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: Database Health Template-OT Shibu I agree with Ryan, that in a technical sense this is bogus. But I also feel there is a grain of truth in it. Often at its core the question has to do with comfort, and if recent incidents have caused a loss of comfort, then you get some sharp questions to answer. My strategy would be to increase the level of comfort, but don't commit yourself to wasting a lot of time once the sense of comfort returns. Here is what I would consider legitimate: 1. Install an alert log scanner that will email you when an error occurs. There are several free ones available on-line. 2. If you've experienced a recent crash, demonstrate you are taking serious actions to ensure this problem doesn't recur. Actions like monitoring. Here is what I consider bogus: 1. Constantly monitoring the buffer cache hit ratio. Marginal - run STATSPACK at regular intervals. I have had situations where the database would suddenly hang or freeze or slow-down. I found that a couple of STATSPACK snapshots could provide a wealth of information about what was going on at the time of the incident. Now, my strong preference is to be notified so I can manually trigger these snapshots, but if it makes someone feel better and get off my case if I have them run at regular intervals, then I'm okay with that. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 7:50 AM To: Multiple recipients of list ORACLE-L Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. winmail.dat
RE: Database Health Template-OT
Hi , I was sending statspack report ..but there is request for more and more .. .. That's how i started searching for a generalised report ... Regards, Shibu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thu 11/20/2003 6:59 PM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: Database Health Template-OT Hi Shibu- Can we share your template so as to be able to fill in the gaps, and also get an idea of what you think a healthy DB should be like? CSW Simon. -Original Message- Shibu MB Sent: Wednesday, November 19, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB 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).
Need Details Reg: Time_stamp
Hi Group, Greetings! I have two databases, both has different time zones. Say Database A has EST. Database B has IST Every two hours I'm getting the database statistics from Database A and loading it to B. While loading I'm loading the data with IST. I want to load the statsitics in EST. How can I do that? TIA Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar 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 Health Template-OT
Hi , . I was sending him thestatspack report ..but ..u know .. he don't understand that .. and is asking for more reports he wants even the export dump file size ...:).. so i thought i will get a detail template from someone else who is alreading have such a detail report ... Shibu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wed 11/19/2003 7:35 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Database Health Template-OT these are bogus. its just about giving your boss some BS, so he goes away. Been there, done that. the only useful stuff to send him would be polling the alert log for 'ORA' errors, checking for chained rows as a percentage of total rows, and check to see how much free space is in each datafile. you can also send him statspack stuff, but he wont be able to read it. might want to send him a max users count and stuff like that. but that really isnt a 'health' check. what are you sending him now? hit ratios? Those are garbage. Even though the damn OCP test says to use them(im still annoyed by that).. its garbage. From: Shibu MB [EMAIL PROTECTED] Date: 2003/11/19 Wed AM 08:50:07 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database Health Template-OT Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it . Thanks in advance Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. winmail.dat
RE: Development vs. Production DBA
LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: Oracle Magazine Awards
Title: Message The President of our local user group, Peter Smith, won the PL/SQL Developer of the Year award. We had our user group meeting yesterday afternoon. (I had previously arranged to have the Oracle Rep bring about 20 copies of the Oracle Magazine). We had fun publicly humiliating him with it (asking for signed autograph copies, using them as door prizes, etc) !! - Babette -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED] Sent: 2003-11-20 3:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Magazine Awards And also an increase in the price ot their Oracle license. ;o) Dave -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Magazine Awards Congratulations to all the award winners! Btw, do they get any cash awards or just a piece of paper? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Magazine AwardsCongratulations to the following folks that appeared in the 2003 Editors Choice Awards ( I finally received my issue of the mag ) Arup Nanda - DBA of the Year Tony Jambu - Consultant of the Year Mogens Nogaard - Educator of the Year Tom Kyte - Oracle Book Author of the Year There were many other, I only mentioned those that I have had the opportunity to meet and/or converse with via email, or sometimes even in person. ( all of these conditions allow me to drop their names when the opportunity arises ) Congratulations folks! ( I don't know if all of them frequent this list ) Jared
Re: Re: IOT Tuning Question
Zhu/SF: Thanks for your insight. I was under the impression that Oracle did not recommend IOT for tables that where not fairly static. Would the reasoning for this not being an issue in this case be due to oracle now having to only maintain the IOT table blocks instead of the table blocks and the associates index blocks? The three table columns all being number datatypes which I think will help avoid the overflow issue. In monitoring the tables it appears that approximately 150,000 rows are added each week through a batch process. It also seems as though they are not using any type of buld loading functionality. If I rebuild to IOT on locally managed tablespaces will fragmentation be an issue? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 21, 2003 4:54 AM Zhu Chao, You are right to say that with a heap organized table you also have the index to encumber the SGA and indeed you are right to say that, as I put it, what I said is not totally correct. I should have been more specific. The reference to _partitioned_ IOTs implicitly associated them to full partition scans in my mind, because the case I was referring to was some massive swoop among a lot of data, with many scans. In such a case, then indexes in general, and IOTs in particular, tend to stay much longer than required in memory, which may become a problem over time with long running processes (while table blocks are prime candidates for replacement after full scans). Quite obviously, if you are doing mostly indexed accesses, the picture may be different. I don't think that with 3 columns, unless they are well-filled VARCHAR2(4000) columns (you never know, with 3rd party software ...) overflow will be much of a problem. I'd rather fear contention, but of course it depends on the level of concurrency. SF - --- Original Message --- - From: zhu chao [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 20 Nov 2003 17:50:11 Hi, Jay: Since your table is just a table with 1M records and you have only three columns(all of them are pk), so using IOT is really an good candicate. The space save is not important because 1M records with three columns typically consumes several megabytes, which is not important at all these days. If your table is heavily DMLed, then using IOT reduced the DML to the base table, so less IO generated and less redo. I do not think SF's words are correct. IOT is indices, right. But Regular tables with indexes also consumes memory in SGA, and the index on the regular do the same thing as IOT table does. And the base table itself also consumes SGA memory. Overflow in IOT(oracle 8i) is just heap organized, in 9i it is also index organized(from my test), so if your table has overflow segment, and you insert more and more data into the table, IOT *WILL* be less efficient and you need to move the overflow segment to make the table efficient. Regards. zhu chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 21, 2003 12:30 AM Jay, On the paper, your table is indeed a good candidate for an IOT - it will save you the space used by the table (you will only have the primary key index). However, there may be gotchas. I have noticed in the past that IOTs, being primarily indices, have a tendency to be a bit 'sticky' in the SGA. I have seen massive processes wading through enormous amounts of data significantly slowing down over time with an IOT, and my interpretation was that the IOT was slowly filling up the SGA, letting fewer and fewer space to the rest. Also, think carefully about partitioning; it depends on how you query your table, mostly. It will be beneficial during inserts if you insert your rows in a random fashion in all partitions. Using a reverse key is also something you may want to consider if you have no range scan, it will help with contention. I don't think that there is an obviously good solution; it needs testing. HTH, SF - --- Original Message --- - From: Jay Wade [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 20 Nov 2003 07:44:59 Hello: I'm looking at trying to tune a 3rd party app and was wondering if anyone could tell me if my assumptions are on base. The table contains three columns, each is part of the primary key, with about 1 million + rows. I figured that it would be an ideal candidate for using a partitioned IOT, but since records are frequently inserted am I correct in assuming that it would be better to use regular partitioned table using a primary key? Since this is a 3rd party application I can't change much of the layout, if anyone has any ideas it would be greatly appreciated. Regards, Jay
RE: Database Health Template-OT
always ... always start with requirement ... have _them_ tell you what _they_ need. This is entirely different than what you can provide. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, November 21, 2003 7:11 AM To: Multiple recipients of list ORACLE-L Hi , I was sending statspack report ..but there is request for more and more .. .. That's how i started searching for a generalised report ... Regards, Shibu ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: _wait_for_sync , dirty buffer flushing and direct reads in parallel
Just to clarify: I don't advise any one trying this in production. There is a (small) chance that in case of instance failure you could end up with a corrupt database. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 10:24 PM parallel Hi! It seems that my post of performance gain by setting the parameter has got lost somewhere. Anyway, a step in Oracle Apps upgrade process, which involved running about 3 scripts (probably more than 10 DDLs and commits in it), ran about 3-4 hours, while without this optimization, it ran for 8 hours. This helped to speed up commits greatly. But with small number of large transactions it wouldn't help - for that you'd have to check out the _disable_logging parameter... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 5:30 PM in parallel Hi! Yup, I was bold enough to use this parameter during production upgrade only because it worked well in several tests and simulations. Cheers, Tanel. Well, some disk writes need to wait for the LGWR to flush the corresponding redo to disk. So now you can have a situation that the blocks that are dirty are on disk (without a commited transaction) but the redo is not yet. So if you crash in that period, you can't recover. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 2:59 PM parallel Anjo, I also thought it affects only lgwr sync, but Jonathan Lewis once told that it affects any disk writes... If it affects only lgwr, then great, I can make Apps upgrades, which do really lots of DDLs and small transactions, quite much faster that way... Thank you, Tanel. _wait_for_sync basically meant that a session is waiting for the sync of the redo by the lgwr. Normally the redo log writer writes to disk and then notifies the session that the transaction is completed. By setting this to false, you no longer wait for the redo to go to disk. That has no impact on your situation. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 11:20 PM query Hi! I've sometimes used setting _wait_for_synclse during Apps upgrade projects, to upgrade performance. (As long as your database doesn't crash during the parameter is set to false, no problems should occur). I just started wondering, what would be the case if a parallel query starts during someone is modifying data... As I understand, when doing parallel query: 1) the dirty blocks which are supposed to be read by PQ in direct mode, are flushed to disk 2) PQ reads the blocks in direct mode But when _wait_for_sync is set, the writes get acknowledged immediately (or acknowledgement is not waited for). Could this result in the unlikely situation, that PQ issues the flush command to dirty buffers and starts to read them, but actually reads the old images of the blocks, since it thinks the write has already occurred? (actually, this doesn't touch only PQ, it's possible to have direct reads to PGA in serial mode too...) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk 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
RE: Using miss-spelled hint changes explain plan ...
Now, wouldn't you think that was intentional ... ?? Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, November 20, 2003 8:35 PM To: Multiple recipients of list ORACLE-L BTW, you mis-spelled miss-spelled :-) ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Development vs. Production DBA
the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: Boivin, Patrice J [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
RE: Oracle Magazine Awards
yeah I saw that he deserves it! --- [EMAIL PROTECTED] wrote: The President of our local user group, Peter Smith, won the PL/SQL Developer of the Year award. We had our user group meeting yesterday afternoon. (I had previously arranged to have the Oracle Rep bring about 20 copies of the Oracle Magazine). We had fun publicly humiliating him with it (asking for signed autograph copies, using them as door prizes, etc) !! - Babette -Original Message- Sent: 2003-11-20 3:21 PM To: Multiple recipients of list ORACLE-L And also an increase in the price ot their Oracle license. ;o) Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 1:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Magazine Awards Congratulations to all the award winners! Btw, do they get any cash awards or just a piece of paper? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Magazine Awards Congratulations to the following folks that appeared in the 2003 Editors Choice Awards ( I finally received my issue of the mag ) Arup Nanda - DBA of the Year Tony Jambu - Consultant of the Year Mogens Nogaard - Educator of the Year Tom Kyte - Oracle Book Author of the Year There were many other, I only mentioned those that I have had the opportunity to meet and/or converse with via email, or sometimes even in person. ( all of these conditions allow me to drop their names when the opportunity arises ) Congratulations folks! ( I don't know if all of them frequent this list ) Jared __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: Database Health Template-OT
Just FWIW - I set up dozens of alerts on our systems, monitoring conformance to corporate standards. So, naming standards, presence / absence of triggers, responsibility assignements in metadata, access privs consistent with those assignements etc etc. For every alert test, there will be a numeric result, from 0 up to the maximium potential (eg the total population against which each alert exception is being tested). So the results can be expressed as percentages. And the consolidated results of all tests is also expressed as a percentage - ergo, the 'database health quotient'. Well of course potentially totally misleading (must understand scope, which damagement may not), but as a qualitative indicator, it has some use. Certainly these alerts help to draw attention to sleepers. You will note these alerts do NOT check the physical parameters of the db installation, rather the data and metadata. They could of course treat the former in the same way, however. peter edinburgh Guys, For management reporting has anyone considered OEM V9?? Has anyone installed it - do you know that it provides a number of reports already defined that can be setup to be run periodically and available on the web - all with the installation of the OEM V9? but it's OEM, i've never managed to get it configured to run other than stand alone. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] -- -- Anyone who is capable of getting themselves made President should on no account be allowed to do the job. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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]
RE: RE: Development vs. Production DBA
not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: Boivin, Patrice J [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss 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
Oracle 10g Migration
Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." ** ==
RE: RE: Development vs. Production DBA
I don't normally like to get into these turf battles, but in this case I have to agree with Patrice. Most developers are looking strictly at their current project with no regard for anything they've done in the past or that others around them are doing. Also I find that a significant number of developers have an attitude that what they did in the past is sufficient for the future no new functionality in the database or elsewhere is needed. Believe it or not, we still have a test engineering programmer who uses Turbo Pascal. My greatest frustration is people who demand to write applications strictly in a client server mode. They see no benefit into encapsulating processes that are very database intensive into packages/procedures/functions. So instead of one round trip to the database they have to do 30 or 40 and wonder why they can't get sub second response from their application. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:14 AM To: Multiple recipients of list ORACLE-L not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: Boivin, Patrice J [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
Re: Oracle 10g Migration
Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10g Migration
Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Development vs. Production DBA
I'm going to keep this response in my in-box to forward to developers when they complain about their poorly tuned database. Goulet, Dick DGoulet To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @vicr.com cc: Sent by: Subject: RE: RE: Development vs. Production DBA ml-errors 11/21/2003 09:39 AM Please respond to ORACLE-L I don't normally like to get into these turf battles, but in this case I have to agree with Patrice. Most developers are looking strictly at their current project with no regard for anything they've done in the past or that others around them are doing. Also I find that a significant number of developers have an attitude that what they did in the past is sufficient for the future no new functionality in the database or elsewhere is needed. Believe it or not, we still have a test engineering programmer who uses Turbo Pascal. My greatest frustration is people who demand to write applications strictly in a client server mode. They see no benefit into encapsulating processes that are very database intensive into packages/procedures/functions. So instead of one round trip to the database they have to do 30 or 40 and wonder why they can't get sub second response from their application. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:14 AM To: Multiple recipients of list ORACLE-L not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: Boivin, Patrice J [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a
RE: RE: Development vs. Production DBA
Title: RE: RE: Development vs. Production DBA But if you make them stored procedures, you might be giving up some vestige of control. CAN'T give up control... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, November 21, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Development vs. Production DBA I don't normally like to get into these turf battles, but in this case I have to agree with Patrice. Most developers are looking strictly at their current project with no regard for anything they've done in the past or that others around them are doing. Also I find that a significant number of developers have an attitude that what they did in the past is sufficient for the future no new functionality in the database or elsewhere is needed. Believe it or not, we still have a test engineering programmer who uses Turbo Pascal. My greatest frustration is people who demand to write applications strictly in a client server mode. They see no benefit into encapsulating processes that are very database intensive into packages/procedures/functions. So instead of one round trip to the database they have to do 30 or 40 and wonder why they can't get sub second response from their application. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:14 AM To: Multiple recipients of list ORACLE-L not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: Boivin, Patrice J [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development
Re: Oracle 10g Migration
From what I read, and learned from the private sources, it's going to be a direct migration. Of course, I don't have 10g , so I can't tell for sure. This tight lid on the software is, in my humble opinion, ridiculous. My next answer to an oracle sales person will be that I have to keep the tight lid on our purchasing decision so that I can't tell anything to him. Oracle should allow us to download the beta version and see for ourselves. I guess that Larry always knows better. On 11/21/2003 09:49:26 AM, Goulet, Dick wrote: Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ:
RE: Oracle 10g Migration
Oracle Database 10g provides a fairly easy upgrade path for users of older Oracle versions. The following versions can directly be upgraded to Oracle Database 10 g: Oracle Database 8.0.6 Oracle Database 8.1.7 Oracle Database 9.0.1 Oracle Database 9.2 If your database version is not in the preceding list, then you must first upgrade to one of these versions, after which you can upgrade to Oracle Database 10 g. This is from a PDF on technet - Oracle DB 10g new features -Original Message- Sent: 21 November 2003 14:49 To: Multiple recipients of list ORACLE-L Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nigel Bishop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10g Migration
According to the presentation by Dave Foster of Oracle at the last UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2. Also, the new dbassistant has an undo feature, to rollback the upgrade. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Friday, November 21, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: RE: Development vs. Production DBA
i was on a project last year where the lead didnt let us make stored code. she thought it 'cluttered the database'. what can you do? lots of incompetence out there. worst when its the boss. From: April Wells [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 09:54:33 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Development vs. Production DBA But if you make them stored procedures, you might be giving up some vestige of control. CAN'T give up control... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Friday, November 21, 2003 8:40 AM To: Multiple recipients of list ORACLE-L I don't normally like to get into these turf battles, but in this case I have to agree with Patrice. Most developers are looking strictly at their current project with no regard for anything they've done in the past or that others around them are doing. Also I find that a significant number of developers have an attitude that what they did in the past is sufficient for the future no new functionality in the database or elsewhere is needed. Believe it or not, we still have a test engineering programmer who uses Turbo Pascal. My greatest frustration is people who demand to write applications strictly in a client server mode. They see no benefit into encapsulating processes that are very database intensive into packages/procedures/functions. So instead of one round trip to the database they have to do 30 or 40 and wonder why they can't get sub second response from their application. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:14 AM To: Multiple recipients of list ORACLE-L not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: Boivin, Patrice J [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a production DBA, my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs.
RE: RE: Development vs. Production DBA
Title: RE: RE: Development vs. Production DBA Just don't grant execute. ;-) - Alan Davey Senior Analyst/Project Leader Oracle 9i OCA; 3/4 OCP w) 973.267.5990 x458 w) 212.295.3458 -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Friday, November 21, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Development vs. Production DBA But if you make them stored procedures, you might be giving up some vestige of control. CAN'T give up control... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, November 21, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Development vs. Production DBA I don't normally like to get into these turf battles, but in this case I have to agree with Patrice. Most developers are looking strictly at their current project with no regard for anything they've done in the past or that others around them are doing. Also I find that a significant number of developers have an attitude that what they did in the past is sufficient for the future no new functionality in the database or elsewhere is needed. Believe it or not, we still have a test engineering programmer who uses Turbo Pascal. My greatest frustration is people who demand to write applications strictly in a client server mode. They see no benefit into encapsulating processes that are very database intensive into packages/procedures/functions. So instead of one round trip to the database they have to do 30 or 40 and wonder why they can't get sub second response from their application. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:14 AM To: Multiple recipients of list ORACLE-L not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: "Boivin, Patrice J" [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a "production DBA", my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-LI don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs.
Compare the *size* of different schemas
I'm wondering if someone has a better solution than mine (see below) to the following: We have a number of schemas that get cloned from our production schema (more on that later). I need to be able to compare the size of the production schema to the target schema and determine how much the objects have grown. The part I'm working on/struggling with is how to determine whether or not the target tablespace has enough space to handle the additional space required. What I have so far: I have a statistics database that I've modified to store object information for each schema (which database/tablespace it came from, how big it is now, how big the next extent will be, etc). I've also got the query that says this schema is x bytes/blocks larger in the production database than the target database. From this I'm able to figure out how many extents will be needed in the target database to handle the size growth. My problem: I can't just compare the size of the next extent to the largest free chunk in the tablespace. While that's useful information it won't alert me if I've only got room for one extent but will need two. If the target schemas were refreshed regularly then this might work since any given object should not have extended more than once (or a small number of times) but sometimes weeks or months go between refreshes. Along the same lines I can't add all of the extents and try to fit them in the total free space because the blocks may not be contiguous. (We have a mixture of extent sizes, I'll convert someday, really I will!) In addition, if there are 5 tables that have grown I'd like to be able to determine if table 1 is going to use up all of the free space and tables 2-5 won't have enough space to extend. Etc. My 'best' solution: Build a table of existing free space for each target database/tablespace and do mock updates attempting to mimic Oracle's behavior then, from that, determine if I will run out of space. This seems cumbersome and time-consuming but it's the only reasonably accurate solution I've come up with. Does anyone have a better idea? Has anyone done something similar? Some background about our environment: Currently we're exporting/importing to get the production data into the other schemas. In some instances we drop the tables first then import, in others we truncate then import. In the future some of the tables that are being truncated will be incrementally updated (unless the structure changes then they'll be dropped and re-imported). The table structures are identical, in general the initial and next extents are identical but that isn't true for all objects. The target schemas are used for development, test, reporting, etc. Thanks for taking the time to read this! Linda -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seley, Linda 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: Compare the *size* of different schemas
Linda, a stupid question: why are you comparing extents instead of number of records? If my memory serves me right, there used to be things like NUM_ROWS and AVG_ROW_LEN in ALL_TABLES or DBA_TABLES. All you need is to run DBMS_STATS regularly and, voila, you've got yourself an accurate rowcount. What is more, you can turn on segment compression on the non-production copies, if the database version is 9.2 or more. That will lower the space in the QA and development copies, at the expense of performance, of course. On 11/21/2003 10:14:43 AM, Seley, Linda wrote: I'm wondering if someone has a better solution than mine (see below) to the following: We have a number of schemas that get cloned from our production schema (more on that later). I need to be able to compare the size of the production schema to the target schema and determine how much the objects have grown. The part I'm working on/struggling with is how to determine whether or not the target tablespace has enough space to handle the additional space required. What I have so far: I have a statistics database that I've modified to store object information for each schema (which database/tablespace it came from, how big it is now, how big the next extent will be, etc). I've also got the query that says this schema is x bytes/blocks larger in the production database than the target database. From this I'm able to figure out how many extents will be needed in the target database to handle the size growth. My problem: I can't just compare the size of the next extent to the largest free chunk in the tablespace. While that's useful information it won't alert me if I've only got room for one extent but will need two. If the target schemas were refreshed regularly then this might work since any given object should not have extended more than once (or a small number of times) but sometimes weeks or months go between refreshes. Along the same lines I can't add all of the extents and try to fit them in the total free space because the blocks may not be contiguous. (We have a mixture of extent sizes, I'll convert someday, really I will!) In addition, if there are 5 tables that have grown I'd like to be able to determine if table 1 is going to use up all of the free space and tables 2-5 won't have enough space to extend. Etc. My 'best' solution: Build a table of existing free space for each target database/tablespace and do mock updates attempting to mimic Oracle's behavior then, from that, determine if I will run out of space. This seems cumbersome and time-consuming but it's the only reasonably accurate solution I've come up with. Does anyone have a better idea? Has anyone done something similar? Some background about our environment: Currently we're exporting/importing to get the production data into the other schemas. In some instances we drop the tables first then import, in others we truncate then import. In the future some of the tables that are being truncated will be incrementally updated (unless the structure changes then they'll be dropped and re-imported). The table structures are identical, in general the initial and next extents are identical but that isn't true for all objects. The target schemas are used for development, test, reporting, etc. Thanks for taking the time to read this! Linda -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ:
RE: Compare the *size* of different schemas
We aren't running statistics against these schemas. When we were they caused extremely poor performance so they were removed. I haven't been able to get sign-off yet on re-instating them in test. Given that it's an ASP system with relatively few tuned queries I think it's likely that they'd continue to cause us grief. We're currently on 8.1.7 but even then we couldn't do compression for QA/reporting if it would impact performance at all. Development, maybe, depending on the the impact. Thanks! Linda -Original Message- Sent: Friday, November 21, 2003 8:29 AM To: Multiple recipients of list ORACLE-L Linda, a stupid question: why are you comparing extents instead of number of records? If my memory serves me right, there used to be things like NUM_ROWS and AVG_ROW_LEN in ALL_TABLES or DBA_TABLES. All you need is to run DBMS_STATS regularly and, voila, you've got yourself an accurate rowcount. What is more, you can turn on segment compression on the non-production copies, if the database version is 9.2 or more. That will lower the space in the QA and development copies, at the expense of performance, of course. On 11/21/2003 10:14:43 AM, Seley, Linda wrote: I'm wondering if someone has a better solution than mine (see below) to the following: We have a number of schemas that get cloned from our production schema (more on that later). I need to be able to compare the size of the production schema to the target schema and determine how much the objects have grown. The part I'm working on/struggling with is how to determine whether or not the target tablespace has enough space to handle the additional space required. What I have so far: I have a statistics database that I've modified to store object information for each schema (which database/tablespace it came from, how big it is now, how big the next extent will be, etc). I've also got the query that says this schema is x bytes/blocks larger in the production database than the target database. From this I'm able to figure out how many extents will be needed in the target database to handle the size growth. My problem: I can't just compare the size of the next extent to the largest free chunk in the tablespace. While that's useful information it won't alert me if I've only got room for one extent but will need two. If the target schemas were refreshed regularly then this might work since any given object should not have extended more than once (or a small number of times) but sometimes weeks or months go between refreshes. Along the same lines I can't add all of the extents and try to fit them in the total free space because the blocks may not be contiguous. (We have a mixture of extent sizes, I'll convert someday, really I will!) In addition, if there are 5 tables that have grown I'd like to be able to determine if table 1 is going to use up all of the free space and tables 2-5 won't have enough space to extend. Etc. My 'best' solution: Build a table of existing free space for each target database/tablespace and do mock updates attempting to mimic Oracle's behavior then, from that, determine if I will run out of space. This seems cumbersome and time-consuming but it's the only reasonably accurate solution I've come up with. Does anyone have a better idea? Has anyone done something similar? Some background about our environment: Currently we're exporting/importing to get the production data into the other schemas. In some instances we drop the tables first then import, in others we truncate then import. In the future some of the tables that are being truncated will be incrementally updated (unless the structure changes then they'll be dropped and re-imported). The table structures are identical, in general the initial and next extents are identical but that isn't true for all objects. The target schemas are used for development, test, reporting, etc. Thanks for taking the time to read this! Linda -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please
Oracle and Firewall
Hi, We are using Oracle817 on Windows with netscreen firewall.I have been noticing after some times applications start connecting form 1521 to 1034 and so.IS this normal ?I want port 1521 Only in use. How to fix this problem? thx -Seema _ Gift-shop online from the comfort of home at MSN Shopping! No crowds, free parking. http://shopping.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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: NT/WINDOWS 2000 resources for ORACLE
Niall and all other colleagues, Thanks very much for your input on this subject. Very nice and productive info so far. I agree that it is more click and select requirement but I needed some more insight which I got it. There are 2 good books for Oracle on Windows 2000 in the market and are good for learning as well. I shall say again 'Jared, you are great to keep this fantastic list alive all the time.' This is a great source for sharing knowledge. knowledge is power lets share it. Have a nice weekend. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Nov 2003 12:50:15 -0800 Comments interleaved -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of M Rafiq Sent: 20 November 2003 15:45 To: Multiple recipients of list ORACLE-L Subject: NT/WINDOWS 2000 resources for ORACLE Hi, In coming weeks I have to work on a project to Support Oracle databases on NT/Windows 2000. I have unix background supporting Oracle adatbases on a smaller scale hence not much skill was rqquired. Its windows - its all clicky clicky clicky - no skill required :( I shall appreciate your guidance/experience to point right resources for NT/Windows 2000 1)for connectivity tools Probably the most common tools would be vnc or pcAnywhere. Terminal Services is adequate (we use it) but some console commands do not work as expected with TS. 2)NT administratiion tools/books/white papers Check out msdn.microsoft.com. 3) Job schedular juct like crontab in unix. There is a scheduled tasks applet (might require a certain level of IE) for job scheduling. Fairly straightforward. There is a command line version at which works but is horrible imo. 3)performance tuning with Windows prospective Similar I imagine to Unix. Keep os and swap away from each other and Oracle. Don't run any services (daemons) you don't need. Don't install anything you don't need. Dedicate the server to oracle. Performance measurement on windows is done via a tool called perfmon, which works on a 'counters' basis. That is you add 'counters' which are performance metrics to the tool and display the results on screen or write them to a log for later analysis. Counters include things like %CPU, DISK/SEC, Memory usage etc. You can tell these are nearly all counts or ratios :(. 4)batch scripting - most important for me. Is any site contains readily available common scripts. I've not seen one. Note that you can install unix emulators or perl (and then hassle Jared...) if you so desire. My preference is vbscript. 5)Any other issues to tackle The rate at which 'critical' patches for the OS come out. For this reason alone I'd expect to do scheduled maintenance on the server at least every 42 days. Subscribe to the ms security mailing list and check windows update regularly (but install manually). Once UKOUG is over my next project will be an Oracle on Windows whitepaper, but don't expect to see it before Jan/Feb next year. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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). _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Compare the *size* of different schemas
Linda, When I saw your reference to 'cloning' below, I first thought you were taking physical copies of your files. Perhaps this is something you might want to consider in the future. For one thing, you just have to add up file sizes to see how much space is required on the target machine. With exp/imp I think that you would make your life much simpler using first COMPRESS=N when exporting and then just checking total sizes. You will no longer need big contiguous chunks - having as much space on the target database as on the source database will usually be enough. I don't see why you want to get down to the extent level - it looks like an overkill. HTH SF - --- Original Message --- - From: Seley, Linda [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 21 Nov 2003 07:14:43 I'm wondering if someone has a better solution than mine (see below) to the following: We have a number of schemas that get cloned from our production schema (more on that later). I need to be able to compare the size of the production schema to the target schema and determine how much the objects have grown. The part I'm working on/struggling with is how to determine whether or not the target tablespace has enough space to handle the additional space required. What I have so far: I have a statistics database that I've modified to store object information for each schema (which database/tablespace it came from, how big it is now, how big the next extent will be, etc). I've also got the query that says this schema is x bytes/blocks larger in the production database than the target database. From this I'm able to figure out how many extents will be needed in the target database to handle the size growth. My problem: I can't just compare the size of the next extent to the largest free chunk in the tablespace. While that's useful information it won't alert me if I've only got room for one extent but will need two. If the target schemas were refreshed regularly then this might work since any given object should not have extended more than once (or a small number of times) but sometimes weeks or months go between refreshes. Along the same lines I can't add all of the extents and try to fit them in the total free space because the blocks may not be contiguous. (We have a mixture of extent sizes, I'll convert someday, really I will!) In addition, if there are 5 tables that have grown I'd like to be able to determine if table 1 is going to use up all of the free space and tables 2-5 won't have enough space to extend. Etc. My 'best' solution: Build a table of existing free space for each target database/tablespace and do mock updates attempting to mimic Oracle's behavior then, from that, determine if I will run out of space. This seems cumbersome and time-consuming but it's the only reasonably accurate solution I've come up with. Does anyone have a better idea? Has anyone done something similar? Some background about our environment: Currently we're exporting/importing to get the production data into the other schemas. In some instances we drop the tables first then import, in others we truncate then import. In the future some of the tables that are being truncated will be incrementally updated (unless the structure changes then they'll be dropped and re-imported). The table structures are identical, in general the initial and next extents are identical but that isn't true for all objects. The target schemas are used for development, test, reporting, etc. Thanks for taking the time to read this! Linda -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seley, Linda 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). --- -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and Firewall
Hi Seema, Take a look on this document #131524.1 on Metalink. You will have to add an entry in the registry to force the connection to only use the port 1521 USE_SHARED_SOCKET=TRUE Luc -Original Message- Sent: November 21, 2003 11:21 AM To: Multiple recipients of list ORACLE-L Hi, We are using Oracle817 on Windows with netscreen firewall.I have been noticing after some times applications start connecting form 1521 to 1034 and so.IS this normal ?I want port 1521 Only in use. How to fix this problem? thx -Seema _ Gift-shop online from the comfort of home at MSN Shopping! No crowds, free parking. http://shopping.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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). application/ms-tnef
RE: Compare the *size* of different schemas
Thanks for replying. I can't do clones (we do for our apps database) because one schema in the production database becomes 6 (soon to be 12) schemas in a single QA database. In addition we can't refresh them all at the same time (nor do we have the space to have 12 separate databases). I do use compress=N. The problem is table x has added 3 new extents since the last export. They're relatively small but the target tablespace may or may not have free blocks of that size available. It may be overkill but it's killing me (or should I say QA wants to kill me everytime the import fails). :-) I'm going to attempt to move the 'create uniform sized tablespaces' up on my todo list, but probably won't even get to play with it until next year sometime (like March). Linda -Original Message- Sent: Friday, November 21, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Linda, When I saw your reference to 'cloning' below, I first thought you were taking physical copies of your files. Perhaps this is something you might want to consider in the future. For one thing, you just have to add up file sizes to see how much space is required on the target machine. With exp/imp I think that you would make your life much simpler using first COMPRESS=N when exporting and then just checking total sizes. You will no longer need big contiguous chunks - having as much space on the target database as on the source database will usually be enough. I don't see why you want to get down to the extent level - it looks like an overkill. HTH SF - --- Original Message --- - From: Seley, Linda [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 21 Nov 2003 07:14:43 I'm wondering if someone has a better solution than mine (see below) to the following: We have a number of schemas that get cloned from our production schema (more on that later). I need to be able to compare the size of the production schema to the target schema and determine how much the objects have grown. The part I'm working on/struggling with is how to determine whether or not the target tablespace has enough space to handle the additional space required. What I have so far: I have a statistics database that I've modified to store object information for each schema (which database/tablespace it came from, how big it is now, how big the next extent will be, etc). I've also got the query that says this schema is x bytes/blocks larger in the production database than the target database. From this I'm able to figure out how many extents will be needed in the target database to handle the size growth. My problem: I can't just compare the size of the next extent to the largest free chunk in the tablespace. While that's useful information it won't alert me if I've only got room for one extent but will need two. If the target schemas were refreshed regularly then this might work since any given object should not have extended more than once (or a small number of times) but sometimes weeks or months go between refreshes. Along the same lines I can't add all of the extents and try to fit them in the total free space because the blocks may not be contiguous. (We have a mixture of extent sizes, I'll convert someday, really I will!) In addition, if there are 5 tables that have grown I'd like to be able to determine if table 1 is going to use up all of the free space and tables 2-5 won't have enough space to extend. Etc. My 'best' solution: Build a table of existing free space for each target database/tablespace and do mock updates attempting to mimic Oracle's behavior then, from that, determine if I will run out of space. This seems cumbersome and time-consuming but it's the only reasonably accurate solution I've come up with. Does anyone have a better idea? Has anyone done something similar? Some background about our environment: Currently we're exporting/importing to get the production data into the other schemas. In some instances we drop the tables first then import, in others we truncate then import. In the future some of the tables that are being truncated will be incrementally updated (unless the structure changes then they'll be dropped and re-imported). The table structures are identical, in general the initial and next extents are identical but that isn't true for all objects. The target schemas are used for development, test, reporting, etc. Thanks for taking the time to read this! Linda -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seley, Linda 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
RE: pl/sql question and owa_pattern question
Hi Stephane:
Thanks for your good suggestion. I compared the method you suggested and the orginal
one and it indeed boosted the performance (in my simple test). However the ONLY
problem I am having is that by doing TRANSLATE, I lost the original delimits. The new
method (you suggested) correctly extract the words (and sent for processing), But
after processing I need to put processed-words back to the orginal string with orginal
demilters un-changed. I tried to track to position of delimit from the orginal string
by doing
global_pos := global_pos + pos ;
in my while loop, but ltrim(substr(string, pos + 1), '#') will make global_pos
wrong when ltrim trims '#'. Any work-around?
TIA.
Guang
-Original Message-
Stephane Faroult
Sent: Friday, November 21, 2003 4:19 AM
To: Multiple recipients of list ORACLE-L
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive tasks. 'Native compiling', ie turning PL/SQL in C,
might improve performance. However, in my view the best performance gains you may get
is by, so to speak, pushing the bulk of the processing deeper into the kernel (which
isn't by the way exclusive of native compiling). Using a function such as INSTR() will
be much more efficient than looping on characters.
I would suggest something such as :
- First use TRANSLATE() to replace all the characters you want to get rid of by a
single, well identified character, say # (use CHR() || ... for non printable
characters - you can build up the string of characters to translate in the
initialisation section of a package rather than typing it).
- Start with initializing your string to LTRIM(string, '#')
- Then as long as pos := INSTR(string, '#') isn't 0,
get your token as substr(string, 1, pos - 1) then assign ltrim(substr(string, pos
+ 1), '#') to string (very similar to what you were planning to do with owa).
This will be probably much faster than a character-by-character loop and calls to an
owa package.
HTH,
Stephane Faroult
- --- Original Message --- -
From: Guang Mei [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thu, 20 Nov 2003 19:39:55
Hi:
In my pl/sql program, I want to process each word
in a string. The
string is selected from a varchar2(300) column. The
delimit that separates
the words is not necessary space character. The
definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9,
A-Z,a-z)
and
2. the character is not one of these: '-.,/*_'
Now my program is basically checking each
character, find the delimit, and
rebuild each word. After that I process each
word. The code looks like
this:
---
str := This will be a long string with length
upto 300 characters, it
may contain some invisible characters';
len := length(str)+1;
for i in 1..len loop
ch := substr(str,i,1);
if (not strings.isAlnum(ch) and
instr('-.,/*_', ch)1) then
if word is not null then
-- do some processing to variable word !
word := null;-- reset it
end if;
else
word := word || ch; -- concat ch to word
end if;
end loop;
---
I think It's taking too long because it loops
through each characters. I
hope I could find a way to speed it up. I don't
have experiience in
owa_pattern, but I thought there might be a way to
do it here:
str := This will be a long string with length
upto 300 characters, it
may contain some invisible characters';
newstr := str;
pos := 1;
while pos != 0 loop
pos := owa_pattern.amatch(newstr, 1, '\W');
-- how can I mask out
these '-.,/*_' ???
word := substr(newstr, 1, pos-1);
-- do some processing to variable word !
if pos != 0 then
newstr := substr(newstr, pos+1);
end if;
end loop;
--
My simple tests showed that owa_pattern call is
much slower than direct
string manupilation. But I would like to try it in
this case if I could
easily get the wrods from the string. Any
suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
Re: Oracle and Firewall
Seema, This is a typical misconception on the workings of Net8. Port 1521 is only used to contact the listener, after that the listener might: a) create a server process which listens on a port other than 1521 OR b) pass the connection to a prespawned server process, again on a different port. The new port could be 1034, for example. The client process is then notified that the server process is listening on port 1034 and the client process then starts communicating through the new port. Therefore what you see is normal. In fact it is the biggest proble in building a firewall around the database server; it just have to have too many ports (and mostly unpredictable) open. Here are a few options: (1) use firewall around the subnet where both app/web server and db server exist; not a firewall between them. (2) Use TCP Node checking to restrict Net8 traffic to the db server only from the app server. (3) Use Connection Manager. USing CM, known ports are used for communication, typically 1630 and 1631 (or is it 1634?) and only those can be opened up for connection. (4) Use Shared Servers. The connectiosn pass through the dispatchers. Since the ports used by them can be known, those ports can be opened up. (5) Use SSH redirection. (6) Use a commercial firewall product that can perform proxy-redirection, which preserves the port number in all established connections, even though actual ports used may be different. If anyone has any more options, I would love to know. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 21, 2003 10:59 AM Hi, We are using Oracle817 on Windows with netscreen firewall.I have been noticing after some times applications start connecting form 1521 to 1034 and so.IS this normal ?I want port 1521 Only in use. How to fix this problem? thx -Seema _ Gift-shop online from the comfort of home at MSN Shopping! No crowds, free parking. http://shopping.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL comparison addition: Resolution...
A few weeks ago I had a problem with the following query not returning rows:
Select count(*) .
from global.client_dim a
where a.reports_login = sys_context('userenv','session_user');
even though the following query indicated a match (thanks to whomever
suggested I dump the fields):
SQL select sys_context('userenv','session_user'),
2 dump(sys_context('userenv','session_user')), a.reports_login,
3 dump(a.reports_login)
4 from global.client_dim a
5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN;
SYS_CONTEXT('USERENV','SESSION_USER')
DUMP(SYS_CONTEXT('USERENV','SESSION_USER'))
REPORTS_LOGIN
--
DUMP(A.REPORTS_LOGIN)
REPORTS_DELTA
Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65
REPORTS_DELTA
Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65
I said I would post the resolution to this.
It ended up being a bug in 9203. Not sure which bug.
Support insisted that we patch to 9204 and the problem went away.
Thanks for everyone's help.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: pl/sql question and owa_pattern question
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
(specifically for our application). When there are lots of db calls (select,
insert, update and delete), pl/sql package is faster than correponding perl
program (I made sure sqls are prepared once and used bind variables in perl.
All code were executed on the unix server, no other programs were running,
etc). That's why we stick to pl/sql because our app need the performance.
Others may have different results, it all depends on what the code does.
Guang
-Original Message-
Mladen Gogala
Sent: Thursday, November 20, 2003 11:14 PM
To: Multiple recipients of list ORACLE-L
I don't know about PL/SQL but here is how I would get separate words from a
big string:
#!/usr/bin/perl -w
use strict;
my (@ARR);
while () {
chomp;
@ARR = split(/[^0-9a-zA-Z_\.,]/);
foreach (@ARR) {
print $_\n;
}
}
There is something called DBI and it can be used to insert separated words
into the database, instead
of printing them. The bottom line is that perl is an excellent tool for
parsing strings and all sorts of string
manipulation.
On 2003.11.20 22:39, Guang Mei wrote:
Hi:
In my pl/sql program, I want to process each word in a string. The
string is selected from a varchar2(300) column. The delimit that separates
the words is not necessary space character. The definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9, A-Z,a-z)
and
2. the character is not one of these: '-.,/*_'
Now my program is basically checking each character, find the delimit, and
rebuild each word. After that I process each word. The code looks like
this:
---
str := This will be a long string with length upto 300 characters, it
may contain some invisible characters';
len := length(str)+1;
for i in 1..len loop
ch := substr(str,i,1);
if (not strings.isAlnum(ch) and instr('-.,/*_', ch)1) then
if word is not null then
-- do some processing to variable word !
word := null;-- reset it
end if;
else
word := word || ch; -- concat ch to word
end if;
end loop;
---
I think It's taking too long because it loops through each characters. I
hope I could find a way to speed it up. I don't have experiience in
owa_pattern, but I thought there might be a way to do it here:
str := This will be a long string with length upto 300 characters, it
may contain some invisible characters';
newstr := str;
pos := 1;
while pos != 0 loop
pos := owa_pattern.amatch(newstr, 1, '\W');-- how can I mask out
these '-.,/*_' ???
word := substr(newstr, 1, pos-1);
-- do some processing to variable word !
if pos != 0 then
newstr := substr(newstr, pos+1);
end if;
end loop;
--
My simple tests showed that owa_pattern call is much slower than direct
string manupilation. But I would like to try it in this case if I could
easily get the wrods from the string. Any suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an
Re: Using miss-spelled hint changes explain plan ...
This makes sense. Imagine the problems if the CBO scanned for any valid hint in comment code after SELECT. A developer inserts /*+ Removed the following hint due to poor performance FULL(A) */ to indicate that the hint was causing performance problems. Lo and behold, the problems continue. Daniel Wolfgang Breitling wrote: Maybe not so much an undocumented feature than documentation that is open to interpretation. It is documented that the optimizer will ignore malformed hints. It is just not made clear that everything after that malformed hint up to the end of the comment is ignored as well. BTW, you mis-spelled miss-spelled :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink 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: pl/sql question and owa_pattern question
Guang,
Well you are almost there ... you need fifo structure namely a pl/sql array
1. create a local pl/sql array to store the delimiter (store the ascii value of the
delimiter to be safe) my_array (varchar2(5))
2. as you find a delimiter insert into the first position in the array and replace the
delimiting character with #
3. lather.rinse.repeat.
when it is time to put it back
use a loop
nIndex := 0;
nPos := 0;
loop
npos := instr(my_str,'#',1);
exit when npos := 0;
nIndex := nindex + 1;
my_str := substr(my_str,1,nPos-1) || chr(my_array(nIndex)) || sybstr(my_str, nPos+1);
end loop;
something like this should help, proof-read though ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Friday, November 21, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Hi Stephane:
Thanks for your good suggestion. I compared the method you suggested and the orginal
one and it indeed boosted the performance (in my simple test). However the ONLY
problem I am having is that by doing TRANSLATE, I lost the original delimits. The new
method (you suggested) correctly extract the words (and sent for processing), But
after processing I need to put processed-words back to the orginal string with orginal
demilters un-changed. I tried to track to position of delimit from the orginal string
by doing
global_pos := global_pos + pos ;
in my while loop, but ltrim(substr(string, pos + 1), '#') will make global_pos
wrong when ltrim trims '#'. Any work-around?
TIA.
Guang
-Original Message-
Stephane Faroult
Sent: Friday, November 21, 2003 4:19 AM
To: Multiple recipients of list ORACLE-L
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive tasks. 'Native compiling', ie turning PL/SQL in C,
might improve performance. However, in my view the best performance gains you may get
is by, so to speak, pushing the bulk of the processing deeper into the kernel (which
isn't by the way exclusive of native compiling). Using a function such as INSTR() will
be much more efficient than looping on characters.
I would suggest something such as :
- First use TRANSLATE() to replace all the characters you want to get rid of by a
single, well identified character, say # (use CHR() || ... for non printable
characters - you can build up the string of characters to translate in the
initialisation section of a package rather than typing it).
- Start with initializing your string to LTRIM(string, '#')
- Then as long as pos := INSTR(string, '#') isn't 0,
get your token as substr(string, 1, pos - 1) then assign ltrim(substr(string, pos
+ 1), '#') to string (very similar to what you were planning to do with owa).
This will be probably much faster than a character-by-character loop and calls to an
owa package.
HTH,
Stephane Faroult
- --- Original Message --- -
From: Guang Mei [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thu, 20 Nov 2003 19:39:55
Hi:
In my pl/sql program, I want to process each word
in a string. The
string is selected from a varchar2(300) column. The
delimit that separates
the words is not necessary space character. The
definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9,
A-Z,a-z)
and
2. the character is not one of these: '-.,/*_'
Now my program is basically checking each
character, find the delimit, and
rebuild each word. After that I process each
word. The code looks like
this:
---
str := This will be a long string with length
upto 300 characters, it
may contain some invisible characters';
len := length(str)+1;
for i in 1..len loop
ch := substr(str,i,1);
if (not strings.isAlnum(ch) and
instr('-.,/*_', ch)1) then
if word is not null then
-- do some processing to variable word !
word := null;-- reset it
end if;
else
word := word || ch; -- concat ch to word
end if;
end loop;
---
I think It's taking too long because it loops
through each characters. I
hope I could find a way to speed it up. I don't
have experiience in
owa_pattern, but I thought there might be a way to
do it here:
str := This will be a long string with length
upto 300 characters, it
may contain some invisible characters';
newstr := str;
pos := 1;
while pos != 0 loop
pos := owa_pattern.amatch(newstr, 1, '\W');
-- how can I mask out
these '-.,/*_' ???
word := substr(newstr, 1, pos-1);
-- do some processing to variable word !
if pos != 0
Re: pl/sql question and owa_pattern question
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of those things.
Fortunately, you can mix the two. Without DBI, perl scripts simply
woudn't be very useful. Of course, there are things that are faster
then even the fastest perl script. Lexer written in C is one of them
and you don't need much work to write one, either, but using OCI is
not easy. OCI is a library written to confuse the enemy, not to help
developer. Using plain and simple regex or PCRE within a C program
is the same thing as above, but slightly more complicated then a lexer.
For the specific task of manipulating patterns and resolving regular
expressions, I use perl almost exclusively because I find it an optimal
tradeoff between ease of use and performance. If performance is a
paramount, as in real time application processing, then you'll have to
resort to C and, possibly, write an external procedure and, thus,
enabling oracle to use C regex calls or even pcre. I was toying with the
idea of enabling oracle to use PCRE but I gave up when I read that 10g
will have that included.
On 11/21/2003 11:59:31 AM, Guang Mei wrote:
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
(specifically for our application). When there are lots of db calls (select,
insert, update and delete), pl/sql package is faster than correponding perl
program (I made sure sqls are prepared once and used bind variables in perl.
All code were executed on the unix server, no other programs were running,
etc). That's why we stick to pl/sql because our app need the performance.
Others may have different results, it all depends on what the code does.
Guang
-Original Message-
Mladen Gogala
Sent: Thursday, November 20, 2003 11:14 PM
To: Multiple recipients of list ORACLE-L
I don't know about PL/SQL but here is how I would get separate words from a
big string:
#!/usr/bin/perl -w
use strict;
my (@ARR);
while () {
chomp;
@ARR = split(/[^0-9a-zA-Z_\.,]/);
foreach (@ARR) {
print $_\n;
}
}
There is something called DBI and it can be used to insert separated words
into the database, instead
of printing them. The bottom line is that perl is an excellent tool for
parsing strings and all sorts of string
manipulation.
On 2003.11.20 22:39, Guang Mei wrote:
Hi:
In my pl/sql program, I want to process each word in a string. The
string is selected from a varchar2(300) column. The delimit that separates
the words is not necessary space character. The definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9, A-Z,a-z)
and
2. the character is not one of these: '-.,/*_'
Now my program is basically checking each character, find the delimit, and
rebuild each word. After that I process each word. The code looks like
this:
---
str := This will be a long string with length upto 300 characters, it
may contain some invisible characters';
len := length(str)+1;
for i in 1..len loop
ch := substr(str,i,1);
if (not strings.isAlnum(ch) and instr('-.,/*_', ch)1) then
if word is not null then
-- do some processing to variable word !
word := null;-- reset it
end if;
else
word := word || ch; -- concat ch to word
end if;
end loop;
---
I think It's taking too long because it loops through each characters. I
hope I could find a way to speed it up. I don't have experiience in
owa_pattern, but I thought there might be a way to do it here:
str := This will be a long string with length upto 300 characters, it
may contain some invisible characters';
newstr := str;
pos := 1;
while pos != 0 loop
pos := owa_pattern.amatch(newstr, 1, '\W');-- how can I mask out
these '-.,/*_' ???
word := substr(newstr, 1, pos-1);
-- do some processing to variable word !
if pos != 0 then
newstr := substr(newstr, pos+1);
end if;
end loop;
--
My simple tests showed that owa_pattern call is much slower than direct
string manupilation. But I would like to try it in this case if I could
easily get the wrods from the string. Any suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this
RE: Oracle and Firewall
Arup Nanda scribbled on the wall in glitter crayon: (1) use firewall around the subnet where both app/web server and db server exist; not a firewall between them. (2) Use TCP Node checking to restrict Net8 traffic to the db server only from the app server. (3) Use Connection Manager. USing CM, known ports are used for communication, typically 1630 and 1631 (or is it 1634?) and only those can be opened up for connection. (4) Use Shared Servers. The connectiosn pass through the dispatchers. Since the ports used by them can be known, those ports can be opened up. (5) Use SSH redirection. (6) Use a commercial firewall product that can perform proxy-redirection, which preserves the port number in all established connections, even though actual ports used may be different. If anyone has any more options, I would love to know. Oracle has worked wit a number of firewall venders to allow their firewalls to detect NET8 traffic. that way it can be set up to pass traffic between two nodes with a simple rule. and i'm sorry but i'm out of the network set up side so i don't know the current list of firewall venders this works with, but it would pay to check with yours and see if this is available. you sometimes need to either add a plug in or update the firewall itself. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Maniac: An early computer built by nuts... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pl/sql question and owa_pattern question
Would extproc_perl fit well enough, though, until 10g is here?
On Fri, 21 Nov 2003, Mladen Gogala wrote:
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of those things.
Fortunately, you can mix the two. Without DBI, perl scripts simply
woudn't be very useful. Of course, there are things that are faster
then even the fastest perl script. Lexer written in C is one of them
and you don't need much work to write one, either, but using OCI is
not easy. OCI is a library written to confuse the enemy, not to help
developer. Using plain and simple regex or PCRE within a C program
is the same thing as above, but slightly more complicated then a lexer.
For the specific task of manipulating patterns and resolving regular
expressions, I use perl almost exclusively because I find it an optimal
tradeoff between ease of use and performance. If performance is a
paramount, as in real time application processing, then you'll have to
resort to C and, possibly, write an external procedure and, thus,
enabling oracle to use C regex calls or even pcre. I was toying with the
idea of enabling oracle to use PCRE but I gave up when I read that 10g
will have that included.
On 11/21/2003 11:59:31 AM, Guang Mei wrote:
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
(specifically for our application). When there are lots of db calls (select,
insert, update and delete), pl/sql package is faster than correponding perl
program (I made sure sqls are prepared once and used bind variables in perl.
All code were executed on the unix server, no other programs were running,
etc). That's why we stick to pl/sql because our app need the performance.
Others may have different results, it all depends on what the code does.
Guang
-Original Message-
Mladen Gogala
Sent: Thursday, November 20, 2003 11:14 PM
To: Multiple recipients of list ORACLE-L
I don't know about PL/SQL but here is how I would get separate words from a
big string:
#!/usr/bin/perl -w
use strict;
my (@ARR);
while () {
chomp;
@ARR = split(/[^0-9a-zA-Z_\.,]/);
foreach (@ARR) {
print $_\n;
}
}
There is something called DBI and it can be used to insert separated words
into the database, instead
of printing them. The bottom line is that perl is an excellent tool for
parsing strings and all sorts of string
manipulation.
On 2003.11.20 22:39, Guang Mei wrote:
Hi:
In my pl/sql program, I want to process each word in a string. The
string is selected from a varchar2(300) column. The delimit that separates
the words is not necessary space character. The definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9, A-Z,a-z)
and
2. the character is not one of these: '-.,/*_'
Now my program is basically checking each character, find the delimit, and
rebuild each word. After that I process each word. The code looks like
this:
---
str := This will be a long string with length upto 300 characters, it
may contain some invisible characters';
len := length(str)+1;
for i in 1..len loop
ch := substr(str,i,1);
if (not strings.isAlnum(ch) and instr('-.,/*_', ch)1) then
if word is not null then
-- do some processing to variable word !
word := null;-- reset it
end if;
else
word := word || ch; -- concat ch to word
end if;
end loop;
---
I think It's taking too long because it loops through each characters. I
hope I could find a way to speed it up. I don't have experiience in
owa_pattern, but I thought there might be a way to do it here:
str := This will be a long string with length upto 300 characters, it
may contain some invisible characters';
newstr := str;
pos := 1;
while pos != 0 loop
pos := owa_pattern.amatch(newstr, 1, '\W');-- how can I mask out
these '-.,/*_' ???
word := substr(newstr, 1, pos-1);
-- do some processing to variable word !
if pos != 0 then
newstr := substr(newstr, pos+1);
end if;
end loop;
--
My simple tests showed that owa_pattern call is much slower than direct
string manupilation. But I would like to try it in this case if I could
easily get the wrods from the string. Any suggestions?
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City
