orarrp question
gurus,
i want my users to print their report directly to their printer rather than
to the server.
so i've installed orarrp.exe in my computer and updated the nt web
application server 6iserver.conf to include application/x-orarrp rrpp
rrpa rrpr rrpt rrpi .
to test if it's working , a form is created that will call an oracle
report and specifies that it shld be output to file w/ file extension rtf.
This sample is the same as the one in the technet. the form has a push
button to start the report and create a timer to monitor its
progress...when i run the form nothing happens...
grace.rdf is tested working for client server and web. Is there
something wrong in my code?
pls help...
here's thecode In when button pressed trigger,
declare
report_id report_object;
htimertimer;
vcfilevarchar2(255);
vcresult varchar2(20);
BEGIN
--call_form('GETARGUS');
break;
vcfile := 'test.rrpr'; -- rich text format
report_id := find_report_object('c:\suysing\grace.rdf'); -- path where
the grace.rdf report can be found in web app. server
set_report_object_property(report_id,report_execution_mode,batch);
set_report_object_property(report_id,report_destype,file);
set_report_object_property(report_id,report_desformat,'rtf' );
set_report_object_property(report_id,report_desname,'c:\app\'||vcfile);
set_report_object_property(report_id,report_server,'Rep60_Web');
:global.reporthandle := run_report_object(report_id);
:global.printoutpurt := vcfile;
htimer := create_timer('Printer_Queue','15000',repeat);
end;
In when timer expired ( form trigger);
declare
vcstatus varchar2(20);
vctimername varchar2(30);
htimertimer;
begin
vctimername := get_application_property(timer_name);
if vctimername = 'PRINTER_QUEUE' then
vcstatus := report_object_status(:global.reporthandle);
if vcstatus in ('RUNNING','OPENING_REPORT','ENQUEUED') then
null;
elsif vcstatus = 'FINISHED' then
web.show_document('http://web/app/'||:global.printoutput,'_blank');
delete_timer(vctimername);
else
message('report fialed');
delete_timer(vctimername);
end if;
end if;
end;
Best regards,
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: grace lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Context search
Title: Context search Hi all, Colud u please anyone help me in, What is Context search? How to implement the context search? Thanks and Regards, Bathmasivaraj A, Software Engineer, Atos Origin India. Ltd., Email : [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: Oracle Designer issues and opinions
Well, there are 100% Oracle shops and only Oracle DB shops. I've used Oracle Designer in 100% Oracle shops and other sesign tool in Oracle DB only shops. My main negative point with Designer it that it's never up to the database level, the latest database functionnality are never included in the latest Designer version. --- Raghav Vinjamuri [EMAIL PROTECTED] a crit: Hi, This could be a FAQ-type question, however, I have been unable to find much of relevance ... I have been asked by a manager about any known issues and opinions of Oracle Designer. How much widespread is the usage of Oracle Designer product? Are there any known issues? Any strong opinions on the usage or not? Thanks in advance, -Raghav _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghav Vinjamuri INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stephane Paquette DBA Oracle [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Context search
Title: Context search hi, go to http://technet.oracle.comand browse the docs for interMedia Theone that will probably be the most helpful is "Oracle8i interMedia Text 8.1.5 - Technical Overview " http://technet.oracle.com/sample_code/products/intermedia/htdocs/text_samples/Lite/Samples/imt_815_techover.html hth, Marin "When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking,because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..." Herman Hesse, "Siddhartha" - Original Message - From: Bathma Sivaraj To: Multiple recipients of list ORACLE-L Sent: Monday, February 26, 2001 09:50 Subject: Context search Hi all, Colud u please anyone help me in, What is Context search? How to implement the context search? Thanks and Regards, Bathmasivaraj A, Software Engineer, Atos Origin India. Ltd., Email : [EMAIL PROTECTED] [EMAIL PROTECTED]
RE: Context search
Title: RE: Context search Thanks a lot. -Original Message- From: Marin Dimitrov [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Context search hi, go to http://technet.oracle.com and browse the docs for interMedia The one that will probably be the most helpful is Oracle8i interMedia Text 8.1.5 - Technical Overview http://technet.oracle.com/sample_code/products/intermedia/htdocs/text_samples/Lite/Samples/imt_815_techover.html hth, Marin When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking, because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ... Herman Hesse, Siddhartha - Original Message - From: Bathma Sivaraj mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, February 26, 2001 09:50 Subject: Context search Hi all, Colud u please anyone help me in, What is Context search? How to implement the context search? Thanks and Regards, Bathmasivaraj A, Software Engineer, Atos Origin India. Ltd., Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: questions: security on the u
Oh Mitchell, You have to set s-bit permission should be 6755 --something like that.When user updates a record he is ultimately writing to datafiles.At that time he should assume as file-owner.That means only thru sqlplus or thru some other application only he can write to the file,Neither he can remove nor he van directly write to the file.The solution is simply s-bit.Somr time back there was a discussion on s-bit by check hamilton.Otherwise take his advice.. Cheers, GANTI --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you We reserve the right to monitor all e-mail communications through our network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:Big Dump file (12gb) from nt to
Hi hessu, Your export might have been right one,Which unix r u using .can you give info.. There is a command strings in AIX which gives all the printable characters of any object-file or dumpfile.So try similar command in your unix. and give the following at the command prompt strings "dumpfile"|grep table_name (the table you are worried) It may take few minutes.because of the file-sizeBut it'll give some result. Ignore any error line-length can't be more than 2048 chars. etc.Otherwise you can use AWK. Otherwise narrow your import parameter file to that table only,,,And give show=y paramater...I am not sure this'll work b'cause imp not able to read the table_name itself. ANYWAY try with strings command and let me know Cheers Ganti Hi all, I am facing some problems while trying to import the huge file (12gb) from nt db to unix db. The error I'm receiving is like this: IMP-9: abnormal end of export file IMP-00033: Warning: Table "XXX_" not found in export file... I am using the pipe but still it fails. Here is the syntax for import imp SYSTEM/XX FROMUSER=XXX TOUSER=XXX BUFFER=15000 IGNORE=Y TABLES=XXX FILE=./XXX LOG=./imp.log And the table is on that file... Br and thanks, Hessu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Heikki Jantunen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you We reserve the right to monitor all e-mail communications through our network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tuning, RAID5, and fragmentation
I would try to benchmark the system to show where the bottleneck(s) is(are). Probably I/O, possibly the CPU if you are using NT RAID5 instead of a hardware solution. If your machines aren't real servers, then the disk controller will slow things down as well, in many PCs there is one controller for everything, even if you have two slots for plugging devices like hard disks. It just flip flops between the two constantly. At least benchmarking will help get rid of the perception that "Oracle is slow". Is this on NT? If it is RAID5 implemented at the NT level, the MS SQL Server 7 Administration Training Kit manual, p. 128 says that its disadvantage is that is "uses system processing resources". So you may be overutilizing your CPU as well. RAID5 is good for reading data, but not for writing because the parity info has to be updated. To avoid having to defrag or coalesce your extents, just make sure all your extents are exactly the same size within the tablespace, and that the extents are a multiple of your db_block_size. There is an Oracle paper on this concept, if you want it send me an e-mail. I guess this isn't Oracle Enterprise Edition... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: dana mn [SMTP:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2001 6:20 PM To: Multiple recipients of list ORACLE-L Subject:Tuning, RAID5, and fragmentation Presuming a DBA is forced to use RAID5, what elements of tuning become irrelevant? (in the sense that if you're stuck with RAID5, warts and all, then trying to tune X, Y, and Z would be a waste of time / ineffective). Load balancing files would be one thing.. no way to put indexes and tables on different disks (ditto redo log file members, etc) with one massive RAID5 volume. What about fragmentation and coalescing? Are these still a concern for tablespaces located on RAID5 volumes? Has anyone written an article about Oracle and "living with RAID5"? I'm finding that a customer has several Oracle databases on systems with nothing else but RAID5 storage for everything. Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana mn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Speeding up Java on NT
Hi, Are there any patches to go with the 8i databases? We can patch the RDBMS, I was wondering if there were patches anywhere for the Java components. I didn't find any in oracle-ftp.oracle.com. I would like to see Java run faster on NT. (Please don't tell me that the solution would have been for Sun to accept Microsoft J++ !) Just wondering, I always want to make the databases run faster, and 8i seems to be a bit of a beast. TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone using CA products?
[begin rant] I spent a week and a half (while doing regular work, of course) trying to just INSTALL the ManageIT Framework, and couldn't make the client console and the server exchange messages. I could see all the devices on my network, but I couldn't send a simple message from the server to the client, or the other way around, I can't remember now and I de-installed the whole thing. Finally CA support (sounding a little annoyed at me for asking my sales rep why they hadn't called me back) said: "You just want to use the DBA tools? You don't need the framework for that! It's nice to have, but not necessary." Strangely, their trial kit manuals all list how to install the Framework before listing how to install the DBA tools. A Framework CD ships with every DBA tool they sell - so now I have three of those CDs. Maybe they could have mentioned in their documentation somewhere that the framework is not necessary. I also get the impression that the people who packaged the instructions weren't there to see how their own software installs. Sorry if I sound a bit harsh, but if I was trying to sell a package that costs thousands of dollars, I would make darn sure before I ship it that it is easy to install, easy to configure. And I prefer useful documentation in black and white on 8 x 11 sheets of paper than glossy brochures with instructions that don't accurately describe how to install the software. I also find that while trying out DBA tools, all the vendors seem to assume that this is the only thing you are doing, as if before you started testing their product you were doing nothing at all. 2-week keys for trial software are more a hassle than a help - it discourages people from installing software. It always seems to take them 2 or 3 days to come up with an up-to-date key, which causes other problems. I have a test NT server here which blue screened after one trial key expired, and after two re-installs of NT and Oracle 8.1.6., I keep getting blue screens (6 in two days). I will have to restore the server using our enterprise backup system and pray that the server won't blue screen on me right after the restore finishes. What a hassle. I remember when software companies tried to put keys on their software in the eighties, and a company (called copywrite I think) kept coming out with hacks to overcome these keys, because they were preventing people from making backup copies of their diskettes. I know they don't want us to use unlicensed software, but this is going too far, they are discouraging people from evaluating their software. It has to hurt sales. Why not put 2-month keys on their trial software? No one would use a product like this for just 2 months, it seems to me. Heck it would take at least a month just to configure everything, iron out all the bugs, and make sure the product "fits" the environment. [end rant] Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Subject:Anyone using CA products? I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: Big Dump file (12gb) from nt to
Comments inline. [EMAIL PROTECTED] wrote: Hi hessu, Your export might have been right one,Which unix r u using .can you give info.. There is a command strings in AIX which gives all the printable characters of any object-file or dumpfile.So try similar command in your unix. and give the following at the command prompt strings "dumpfile"|grep table_name (the table you are worried) It may take few minutes.because of the file-sizeBut it'll give some result. Ignore any error line-length can't be more than 2048 chars. etc.Otherwise you can use AWK. Go and get a real copy of strings, its part of binutils, compile it on your platform and not be limted by the stupid 2K buffer, you can't expect to see much if you're doing anything with range partitions. Range partitions each range can have its own storage clause, you that 2K gets eaten up pretty quickly. SNIP Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Anyone using CA products?
Thom, Well at least someone outside of my current employer does not appreciate these folks. BTW: We're having a CA day here, minor mess up in the disk array we've lost 8 development DB's Dick Goulet Reply Separator Author: "Thomas A. Lowery" [EMAIL PROTECTED] Date: 2/25/2001 8:35 PM If anyone from CA attempts to sell you what was called Cool:* (Cool:Gen, Biz... not sure of the new names, was Sterling product) run, run away quickly. It's a sure way to bring your development to a halt, and send good dba's looking for employement else where. On Fri, Feb 23, 2001 at 02:05:41PM -0800, [EMAIL PROTECTED] wrote: Ron, Common on now, this is suppose to be at least a polite list. There was no call for the use of foul language. OH, sorry you don't work over here, CA is a four letter work here used only in EXTREME circumstances like when the fire dept accidentally sets off the fire suppression system in the computer room on a Friday late afternoon. Reply Separator Author: "Smith; Ron L." [EMAIL PROTECTED] Date: 2/23/2001 1:00 PM I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? -- Thomas A. Lowery[EMAIL PROTECTED] http://tlowery.hypermart.net _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas A. Lowery INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
EJB Oracle Sequence
Hello , One of our developers have some issues regarding sequences in Oracle Here is what he is looking for "I'm trying to use CMP for beans that map to tables in which the primary key is an integer that comes from an Oracle SEQUENCE. How do I get the container to get the next number from the appropriate SEQUENCE on a create?" Oracle 8.1.6 on Linux Any help.(**( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TEMP tablespace segment management
Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP tablespace segment management
find out from dba_tablespaces what the current pctincrease value is set to. Then alter the storage for that tablespace to be what it was previously. Regards Lee -Original Message- Sent: 26 February 2001 15:25 To: Multiple recipients of list ORACLE-L Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
difference between Enterprise Edition Standard Edition
Dear all ! I know that this has been asked answered 1000s times ,but , as usual , "it's never there when u need it" . So , please : where can i get a list of features of "Oracle8i Enterprise Edition"that "Standard Edition" does not have ? Thanks a lot in advance .
RE: EJB Oracle Sequence
This issue should be addressed by appropriate deployment descriptor, and implementation essentially depends on development tool. CMP :-(. Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, February 26, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Hello , One of our developers have some issues regarding sequences in Oracle Here is what he is looking for "I'm trying to use CMP for beans that map to tables in which the primary key is an integer that comes from an Oracle SEQUENCE. How do I get the container to get the next number from the appropriate SEQUENCE on a create?" Oracle 8.1.6 on Linux Any help.(**( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Anyone using CA products?
I am using Platinum DesktopDBA. I got an upgrade with no problem and the sales team even came over here to visit and make sure I was satisfied. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:05 PM Ron, Common on now, this is suppose to be at least a polite list. There was no call for the use of foul language. OH, sorry you don't work over here, CA is a four letter work here used only in EXTREME circumstances like when the fire dept accidentally sets off the fire suppression system in the computer room on a Friday late afternoon. Dick Goulet Reply Separator Author: "Smith; Ron L." [EMAIL PROTECTED] Date: 2/23/2001 1:00 PM I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EJB Oracle Sequence
In sql code we would do the following select my_table_s.nextval into my_variable from dual; insert into my_table values(my_variable,.) And then use my_variable for whatever you need it for. "Apps Sol" [EMAIL PROTECTED] 02/26/01 10:25AM Hello , One of our developers have some issues regarding sequences in Oracle Here is what he is looking for "I'm trying to use CMP for beans that map to tables in which the primary key is an integer that comes from an Oracle SEQUENCE. How do I get the container to get the next number from the appropriate SEQUENCE on a create?" Oracle 8.1.6 on Linux Any help.(**( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP tablespace segment management
or take it offline and online again. Joan -Original Message- Lee Robertson Sent: Monday, February 26, 2001 10:52 AM To: Multiple recipients of list ORACLE-L find out from dba_tablespaces what the current pctincrease value is set to. Then alter the storage for that tablespace to be what it was previously. Regards Lee -Original Message- Sent: 26 February 2001 15:25 To: Multiple recipients of list ORACLE-L Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TEMP tablespace segment management
Hi, If it is set to temporary, why bother. If you don't have enough increase the size. Because oracle will reuse the extents in a temporary tablespace freeing it up won't solve a "cannot allocate extent" problem. Otherwise you could do an alter tablespace tablespace default storage (pctincrease 1) and than alter it back to what it was. Jack SRAJENDRAN@nlf s.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: TEMP tablespace segment management om 26-02-2001 16:25 Please respond to ORACLE-L Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the
RE: TEMP tablespace segment management
Srini, Answer to your question is NO, as far as I know. Why don't you define your temporary tablespace as 'TEMPORARY' assuming your database is at least 7.3 ! Example: alter tablespace temp temporary; If you do so, the tablespace cannot be used to hold any permanent segments, only for temporary segments created during queries. When the query completes, the space used by the temporary segment within the the temporary tablespace is not dropped. Instead, the space used by the temporary segment is available for use by other queries; this allows the sorting operation to avoid the costs of allocating and releasing space for temporary segments. [Ref : Advanced Tuning and Administration] HTH, Shantanu --- lerobe - Lee Robertson [EMAIL PROTECTED] wrote: find out from dba_tablespaces what the current pctincrease value is set to. Then alter the storage for that tablespace to be what it was previously. Regards Lee -Original Message- Sent: 26 February 2001 15:25 To: Multiple recipients of list ORACLE-L Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shantanu Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re:Anyone using CA products?
We have used Desktop DBA for about 4 years. For the last 2 years I tried to get upgrades. The help desk kept saying an upgrade was coming. Finally I emailed CA and said I was dropping support. A salesman called a day or so later and wanted to come out and "get to know me". I explained how I had been trying to get upgrades. He said the product had been renamed and the help desk was not up to date. To make a long story short I am just getting a key today (maybe) for an evaluation copy of ManageIT. It took just over two months from the time I got a call from the sales rep. The new product had better be pretty click or CA is history. Ron -Original Message- Sent: Monday, February 26, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I am using Platinum DesktopDBA. I got an upgrade with no problem and the sales team even came over here to visit and make sure I was satisfied. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:05 PM Ron, Common on now, this is suppose to be at least a polite list. There was no call for the use of foul language. OH, sorry you don't work over here, CA is a four letter work here used only in EXTREME circumstances like when the fire dept accidentally sets off the fire suppression system in the computer room on a Friday late afternoon. Dick Goulet Reply Separator Author: "Smith; Ron L." [EMAIL PROTECTED] Date: 2/23/2001 1:00 PM I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle 8i On solaris
Hm. Well, the installation guide for 8.1.7 says it only works on Solaris 2.6 or 2.7. So maybe version 10 is not even supported? In fact, from the Certify section of Metalink (which is SLOOW today but is at least working), you get the following: --- Certify - Product Version and Other Selections: Oracle Server - Enterprise Edition On Sun SPARC Solaris Critical Notes For Oracle Server - Enterprise Edition General Notes For Oracle Server - Enterprise Edition On Sun SPARC Solaris: 32-bit/64-bit: Solaris Sparc 2.7 and 2.8 can be either 32-bit or 64-bit. If the Server product is 64-bit then the required O/S must be 64-bit. --- So, I guess the only advice I can offer is -- "good luck!" Diana -Original Message- Sent: Saturday, February 24, 2001 2:40 PM To: Multiple recipients of list ORACLE-L but hey!!! is an ICG available for Oracle 8i on Solaris 10??? " am about to install Oracle 8i Enterprise on Sun Solaris version 10." Please let me know more about Solaris 10! - Original Message -- Diana Duncan [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Diana Duncan [EMAIL PROTECTED] Date:Fri, 23 Feb 2001 15:11:06 -0800 Subject:RE: Oracle 8i On solaris Follow the installation guide VERY CAREFULLY. Most people fail to install Oracle on Unix because they don't read the instructions. You must modify kernal parameters and do other Unix admin steps prior to installation. One thing to ignore (at least in my opinion) -- the instruction to create an "oinstall" user. I've found this causes more trouble than it's worth when it comes to patching. Just use the "oracle" user in the "dba" group. Go to technet.oracle.com for the installation guide. Regards, Diana -Original Message- Sent: Friday, February 23, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Hi everyone: I am about to install Oracle 8i Enterprise on Sun Solaris version 10. Any Practical documentation or site which could help me on installing and configuring this system will be appreciated. I was away from Unix for a while. I have already checked the Oracle.com. I appreciate your help in advance. Majid -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Majid Kazemi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Re:Anyone using CA products?
Ruth, It's probably because you work for a government agency. I used to work for the federal government, and have found that a lot of things have changed since I went to private industry. Support and dealings with some vendors (not to mention any names) have changed dramatically. That's still not enough to make me want to go back to that sweatshop. By the way, CA is less than helpful here, on the Oracle or the DB2 side of the house. Durinda Jones Yellow Technologies -Original Message- Sent: Monday, February 26, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I am using Platinum DesktopDBA. I got an upgrade with no problem and the sales team even came over here to visit and make sure I was satisfied. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:05 PM Ron, Common on now, this is suppose to be at least a polite list. There was no call for the use of foul language. OH, sorry you don't work over here, CA is a four letter work here used only in EXTREME circumstances like when the fire dept accidentally sets off the fire suppression system in the computer room on a Friday late afternoon. Dick Goulet Reply Separator Author: "Smith; Ron L." [EMAIL PROTECTED] Date: 2/23/2001 1:00 PM I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle DBA evolution path - please share your opinion
Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not needa dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance !
RE: Anyone using ...
I've worked in a non-profit organisation with Oracle on Novell, I had an awful service from Oracle. I've worked in a huge Oracle site, Oracle reps were very attentive --- Brian Wisniewski [EMAIL PROTECTED] a crit: The similiarities in your comments between CA and Oracle are scary. I'm working part-time for a client to get Oracle installed and configured for a new service they are going to provide to their clients. This is their first Oracle experience. They spent around $300K on software and licenses and that was for the server and partitioning option. They waited for a few weeks to get the CD's and kept calling and was always told it was on the way. They received the CD's, too bad they were for Solaris and they are running on Win 2000. They sent the Solaris CD's back and asked for the correct ones and then they finally received 2 CD's which the sales person had BURNT ON HIS CD BURNER from his personal collection because according to him there is a 3 month back log on NT/2000 CD's! They didn't receive the documentation or fail safe cd's which they need. Needless to say their experiences with Oracle Corporation so far has not ingrained in them a very high level of confidence in the company. It probably didn't help the situation any when I brought it an original 8.1.7 cd for NT/2000 that I had received for FREE weeks ago from Technet. :) - Brian --- "Malkuns, Skip" [EMAIL PROTECTED] wrote: CA is also a 4 letter word around here also. The support is very poor and they have so much big company paperwork/politic issues it is tough to get anything from them. I have been waiting for months to get product upgrades. Sign this, fill out this, call here, go there. We finally dropped a number of their products. Our sales rep turn over is heavy, so it seems you have to start over everytime a new rep shows up. And of course their new pricing structure has gone thru the roof... Skip __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stephane Paquette DBA Oracle [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can Oracle7 and Oracle8 co-exist?
Hi Scott, Nice to hear from you again. I am migrating several warehouses on the same server from 734 to 817. If I use a separate owner then I won't have to worry about running different profiles when I sign on. (heh I'm getting older with some gray hairs and I am liable to forget which set of databases I'm working on). I also can set up separate cron jobs under the different owner sign-ins and easily migrate one warehouse at a time. I don't really see any drawbacks to using different owners even if it isn't a requirement. Ben Poels Queen's University Kingston, Ontario (613)533-2449 -Original Message- Canaan Sent: Friday, February 23, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Ben, This is no problem. They don't need to have different owners. If you are running Oracle Applications 10.7, and you want to use an Oracle 8i instance to house it, then you must do this type of install. You will have 2 Oracle homes, each with it's own database listener and all associated files. They will be installed in separate directories, by default. You will need to have a way to setup your environment when you login to pick the Oracle home you want to use and setup all of the environment variables correctly. Ben Poels wrote: Hi, I want to install Oracle 8.1.7 on the same AIX 4.3.2 box which is already running Oracle 7.3.4.5. I will use a separate Oracle owner and Oracle home for the new 8.1.7 software. Has anybody had any problems with these two versions co-existing on the same platform? I have them both installed now but before I spend a lot of time trying to break it I thought I'd check to see whether or not this has worked out at other sites. Thanks, Ben Poels Queen's University Kingston, Ontario -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: RE: Callout...SOLVED!
--- "Mohan, Ross" [EMAIL PROTECTED] wrote: From: "Mohan, Ross" [EMAIL PROTECTED] To: Rocky Welch [EMAIL PROTECTED] Subject: RE: Callout...NOT SOLVED! Date: Mon, 26 Feb 2001 12:48:11 -0500 BINGO. congrats on the fix! (don't forget to tell the list the compiler was broken...) thanks, and take care. -Original Message- From: Rocky Welch [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 12:46 PM To: Mohan, Ross Subject: RE: Callout...NOT SOLVED! Hi Ross, Just fixed it. The cc compiler, although being reported as installed, was not. I installed Forte with the demo license, compiled the extproc.so library and all seems to be well now. Thanks alot for your input. Have a great week! -Rocky --- "Mohan, Ross" [EMAIL PROTECTED] wrote: what's the status on this? I vote for inconsistent/incomplete compiler/C environment, but w/o more info, cannot be sure in any case, love to hear your solution, when/if it appears -Original Message- From: Rocky Welch [mailto:] Sent: Friday, February 23, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Callout...NOT SOLVED! Thanks, Ross. I issued the command you suggested (the which cc comand) and it found the compiler just fine. If I relink the oracle executables it works fine. Any other thoughts? --- "Mohan, Ross" [EMAIL PROTECTED] wrote: did you install the c compiler? ( You'd think Scott would put one there, but he might be too busy getting fitted for a custom Hannibal mask to cover his fat mouth yapping about Microsoft.) If so, which one? where is it located? Do a "which cc" and if it doesn't find your compiler, you need to either install it, or edit the mk file to redirect to an extant compiler. solaris seems to know about, but doesn't appear to find /usr/ucb/cc amazing.the "dot in dot com" -Original Message- Sent: Friday, February 23, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi Gang, I'm trying to compile the callout shared library under Solaris 2.8 and Oracle 8.1.6. I'm receiving the message below. Any ideas? TIA, Rocky ptcprodb cd $ORACLE_HOME/plsql/demo ptcprodb cp $ORACLE_HOME/rdbms/demo/demo_rdbms.mk $ORACLE_HOME/plsql/demo ptcprodb make -f demo_rdbms.mk extproc_callback \ SHARED_LIBNAME=extproc.so OBJS=extproc.o /export/oracle/product/8.1.6/bin/echodo cc -c -K PIC -I/export/oracle/product/8.1.6/rdbms/demo -I/export/oracle/product/8.1.6/rdbmsc cc -c -K PIC -I/export/oracle/product/8.1.6/rdbms/demo -I/export/oracle/product/8.1.6/rdbms/public -I/export/oracle/product/8.1.6/pc /usr/ucb/cc: language optional software package not installed *** Error code 1 make: Fatal error: Command failed for target `extproc.o' ptcprodb __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail.
AW: AW: Slow performance of code using dblinks ver 8.1.6.2
Hi! Sorry, just a few questions more instead of an answer. Do you have the same NLS settings on both instances? Are there joins between local tables and/or remote tables in your select statement? What does the result set ( how many rows, columns ) of your select look like? regards A.H. -- Von: Mohammad Rafiq[SMTP:[EMAIL PROTECTED]] Gesendet: Freitag, 23. Februar 2001 22:00 An: Multiple recipients of list ORACLE-L Betreff: Re: AW: Slow performance of code using dblinks ver 8.1.6.2 Thanks for your only response from the list. Same code is running in 15 minutes using db_links between 7.3.4.5 databases but very very slow when running from 8.1.6.2 to 7.3.4.5 database. This is basicaly an Ananymouse PL/SQL block which select rows from 7.3.4.5 database and insert into a table 8.1.6.2 database...If you or any list guru has any idea ,please help/comment. Have a nice weekend... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 22 Feb 2001 10:31:46 -0800 Hi! Got similar problems concerning database links, mainly slow performance, about 10% of the throughput compared to same processing without db_links. There seems to be no - or at least only poor - useful documentation for database links and/or about tuning their performance. Would be a nice new thread for ORACLE-L : "Database Links: Tuning / Problems / Tips Traps ..." The only thing that helped ( in our case) , was to rewrite the code, in order to "partition" the old big program ( which did all ) into a bunch of small programs ( each doing now only a few things). Also consider rewriting your programs in such a way, that you can have multiple instances of them running simultaneously. You know, "divide et impera". But I'm sure, there must be a secret switch somewhere deep in Oracle's guts, Iabelled "Boost DB_LINK Performance". I just haven't found it yet ;-) A.H. -- Von: Mohammad Rafiq[SMTP:[EMAIL PROTECTED]] Gesendet: Donnerstag, 22. Februar 2001 15:56 An:Multiple recipients of list ORACLE-L Betreff: Slow performance of code using dblinks ver 8.1.6.2 Hi All I am placing my following question once again as no response received so far.I just wanted to know any possible problem when using db_links from 8.1.6.2 database to 7.3.4.5 database. No specific reference found at metalink Thanks Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 21 Feb 2001 07:15:30 -0800 Platform HP 11.0.32 Database 8.1.6.2 Recently we have migrated our Datawarehouse application/database from HP-10.20/Oracle 7.3.4.5 to above platform and testing code to check any possible problem/performance issues. General complaint is about those code using dblinks/network. These codes were running fine in previous environment. We are getting data from 7.3.4.5 databases. Please advise where to look to fix this issue. As per Unix Admin packet size/other network configuration is same as other boxes with HP-10.20 and version 7.3.4.5. In one situation a 15 minutes job takes more than 5 hours and still not finishing. Any pointer/help shall be appreciated. Regards Rafiq _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
CoCreate WorkManager
To ALL, I've been informed that a consultant from CoCreate is coming next Monday to install their document and work manager server stuff. It needs an Oracle backend DB, so that's were I got called in. I've gotten a message from the consultant that makes absolutely no sense outside of that fact that he wants a user names "medmgr" with GOD privileges. Anybody out there with any experience with this stuff?? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Re:Anyone using CA products?
Like I said, we only have Platinum DesktopDBA and the State of Vermont is to frugal to but anything else, leastwise not for me. Platinum does some very neat things that OEM can't do. The consultants recommended this tool and I had it when I came and I upgraded when we moved to 8.0.6. I have gotten good support so far. Knock on wood, cross you heart and spit, it will keep on being good. Ruth - Original Message - To: "Ruth Gramolini" [EMAIL PROTECTED]; "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 26, 2001 12:36 PM Ruth, What I really did not appreciate from CA was their push to "integrate" all of these products with their "intelligent Nugents" and the "Jasmine infrastructure". This is "suppose" to give you an integrated environment where the DBA's job will be "highly automated". But the price tag could gag a herd of elephants! The estimate from the sales person for us was around $10M with a $1.5M per year maintenance agreement. Also, I'm somewhat sure that CA has set up their Nugents correctly for their own RDBMS, but a colleague (no name please, there's enough egg on her face to last a lifetime+) up the road called a month ago. The last SQL statement in her Development DB's alert log (by the way this instance was being "watched" by a fully functional Nugent) said "DROP TABLESPACE SYSTEM INCLUDING CONTENTS;", after that were all ORA- something errors. Therefore I'm not too sure about CA's intelligence. Dick Goulet Reply Separator Subject:Re: Re:Anyone using CA products? Author: "Ruth Gramolini" [EMAIL PROTECTED] Date: 2/26/2001 8:15 AM I am using Platinum DesktopDBA. I got an upgrade with no problem and the sales team even came over here to visit and make sure I was satisfied. Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 23, 2001 5:05 PM Ron, Common on now, this is suppose to be at least a polite list. There was no call for the use of foul language. OH, sorry you don't work over here, CA is a four letter work here used only in EXTREME circumstances like when the fire dept accidentally sets off the fire suppression system in the computer room on a Friday late afternoon. Dick Goulet Reply Separator Author: "Smith; Ron L." [EMAIL PROTECTED] Date: 2/23/2001 1:00 PM I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services
RE: Anyone using CA products?
A simple little thing - I asked for the Oracle 8i Data Dictionary poster. The QA Specialist said that she would be happy to send it to me and of course it hasnt arrived yet - about a year... I can really live without the poster but it tells me something about the company. If they said they didn't supply it or run out of it or whatever else excuse that they can not send it, I would have had more respect for them. What's the point of making yourself looking very bad with such a little thing. It looks like the support is not much different... Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA evolution path - please share your opinion
Sure everything will be point and click! But it means nothing! Who will open tars, report bugs, download patches, etc?! When we're using Oracle 7, Oracle said that Oracle 8 will work by itself, tune itself, low cost maintenance, etc. So, tell me what happened? Also in my opinion DBA duties includes database architect. -Original Message- Sent: Monday, February 26, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for 2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not need a dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AW: AW: Slow performance of code using dblinks ver 8.1.6.2
Andreas,
Thanks for questions.
Yes, NLS param are almost same except 8i new parameters. There is no join
between local and remote tables however joining on all tables at remote
machine.
Following is the customized code:Same code runs in 15 minutes between
7.3.4.5 databases but took hours between 8.1.6.2 and 7.3.4.5 databases.
Any clue
Regards
Rafiq
DECLARE
v_amount_applied_late1 number;
v_amount_applied_late2 number;
v_adjustment_amount number;
v_amt_due_rem_inv number;
v_mtx_acctno varchar2(3);
cursor c_invoice is
(
select cust.customer_name cust_name,
cust.customer_number cust_no,
ctt.name invoice_type_inv ,
ps.payment_schedule_id payment_sched_id_inv,
ps.class class_inv,
ps.due_date due_date_inv,
ps.acctd_amount_due_remaining amt_due_remaining_inv,
ps.trx_number invnum,
ceil(to_date(sysdate,'DD-MON-RR') - ps.due_date) days_past_due,
ps.amount_adjusted amount_adjusted_inv,
ps.amount_applied amount_applied_inv,
ps.amount_credited amount_credited_inv,
ps.gl_date gl_date_inv,
decode( greatest(-,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(0,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_curr,
decode( greatest(1,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(10,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd10,
decode( greatest(11,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(20,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd20,
decode( greatest(21,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(30,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd30,
decode( greatest(31,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(60,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd60,
decode( greatest(61,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(90,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd90,
decode( greatest(91,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd91
from
[EMAIL PROTECTED] ctt,
[EMAIL PROTECTED] cust,
[EMAIL PROTECTED] ps,
[EMAIL PROTECTED] gld,
[EMAIL PROTECTED] c
where ps.gl_date = to_date(sysdate,'DD-MON-RR')
andps.customer_id+0 = cust.customer_id
andps.cust_trx_type_id = ctt.cust_trx_type_id
andps.gl_date_closed to_date(sysdate,'DD-MON-RR')
andps.customer_trx_id+0 = gld.customer_trx_id
andgld.account_class = 'REC'
andgld.latest_rec_flag = 'Y'
andgld.code_combination_id = c.code_combination_id
UNION ALL
select cust.customer_name cust_name,
cust.customer_number cust_no,
initcap('Payment') invoice_type_inv,
ps.payment_schedule_id payment_schedule_id_inv,
ps.class class_inv,
ps.due_date due_date_inv,
nvl(-sum(app.acctd_amount_applied_from),0) amount_due_remaining_inv,
ps.trx_number invnum,
ceil(to_date(sysdate,'DD-MON-RR') - ps.due_date) days_past_due,
ps.amount_adjusted amount_adjusted_inv,
ps.amount_applied amount_applied_inv,
ps.amount_credited amount_credited_inv,
ps.gl_date gl_date_inv,
decode( greatest(-,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(0,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_curr,
decode( greatest(1,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(10,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd10,
decode( greatest(11,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(20,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd20,
decode( greatest(21,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(30,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd30,
decode( greatest(31,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(60,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd60,
decode( greatest(61,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(90,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd90,
decode( greatest(91,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),
least(,
ceil(to_date(sysdate,'DD-MON-RR')-ps.due_date)),1,
0) amt_pd91
from [EMAIL PROTECTED] cust,
[EMAIL PROTECTED] ps,
[EMAIL PROTECTED] app,
[EMAIL PROTECTED] c
where app.gl_date+0 = to_date(sysdate,'DD-MON-RR')
and ps.trx_number is not null
andps.customer_id = cust.customer_id(+)
andps.cash_receipt_id+0 = app.cash_receipt_id
andapp.code_combination_id = c.code_combination_id
andapp.status in ( 'ACC', 'UNAPP', 'UNID')
andnvl(app.confirmed_flag, 'Y') = 'Y'
andps.gl_date_closed to_date(sysdate,'DD-MON-RR')
and(app.reversal_gl_date to_date(sysdate,'DD-MON-RR') OR
app.reversal_gl_date is null )
andnvl( ps.receipt_confirmed_flag, 'Y' ) = 'Y'
GROUP BY cust.customer_name,
cust.customer_number,
cust.customer_id,
ps.payment_schedule_id,
ps.due_date,
ps.trx_number,
ps.amount_adjusted,
ps.amount_applied,
RE: Oracle DBA evolution path - please share your opinion
Our shop uses SQL Server, Oracle NT, and Oracle on Unix. Each has it's place. We purchase all our software, so we use whatever the vendor is more comfortable with. If you want to focus on Oracle make sure it is Oracle Financials. There are fewer DBA's who know Financials and they get more money because of that. -Original Message- Sent: Monday, February 26, 2001 1:11 PM To: Multiple recipients of list ORACLE-L If you are really worried about SQL Server, go ahead and learn it. It won't take too long, and it won't cost you all that much. Learning it would only help if you are doing consulting work though, I think. Shops that use Oracle are not as likely to bother with SQL Server, but that's just a guess on my part. Do you want to do consulting, work for a large company with enough money to pay you, or wear many hats in a smaller shop? It depends on what your goals are and your personal preference. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle DBA evolution path - please share your opinion Sure everything will be point and click! But it means nothing! Who will open tars, report bugs, download patches, etc?! When we're using Oracle 7, Oracle said that Oracle 8 will work by itself, tune itself, low cost maintenance, etc. So, tell me what happened? Also in my opinion DBA duties includes database architect. -Original Message- Sent: Monday, February 26, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for 2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not need a dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
Re: RE: Can Oracle7 and Oracle8 co-exist?
Hi! can you please ( I beg) tell me which platform supports (in the sense of Oracle having certified it) both Oracle 7.3.4 and Oracle 8.1.7? - Original Message -- "Ben Poels" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Ben Poels" [EMAIL PROTECTED] Date:Mon, 26 Feb 2001 10:11:18 -0800 Subject:RE: Can Oracle7 and Oracle8 co-exist? Hi Scott, Nice to hear from you again. I am migrating several warehouses on the same server from 734 to 817. If I use a separate owner then I won't have to worry about running different profiles when I sign on. (heh I'm getting older with some gray hairs and I am liable to forget which set of databases I'm working on). I also can set up separate cron jobs under the different owner sign-ins and easily migrate one warehouse at a time. I don't really see any drawbacks to using different owners even if it isn't a requirement. Ben Poels Queen's University Kingston, Ontario (613)533-2449 -Original Message- Canaan Sent: Friday, February 23, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Ben, This is no problem. They don't need to have different owners. If you are running Oracle Applications 10.7, and you want to use an Oracle 8i instance to house it, then you must do this type of install. You will have 2 Oracle homes, each with it's own database listener and all associated files. They will be installed in separate directories, by default. You will need to have a way to setup your environment when you login to pick the Oracle home you want to use and setup all of the environment variables correctly. Ben Poels wrote: Hi, I want to install Oracle 8.1.7 on the same AIX 4.3.2 box which is already running Oracle 7.3.4.5. I will use a separate Oracle owner and Oracle home for the new 8.1.7 software. Has anybody had any problems with these two versions co-existing on the same platform? I have them both installed now but before I spend a lot of time trying to break it I thought I'd check to see whether or not this has worked out at other sites. Thanks, Ben Poels Queen's University Kingston, Ontario -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
STS software for oracle8
Hi Friends Does any body have STS software for oracle8, Please kindly send to this email address [EMAIL PROTECTED] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA evolution path - please share your opinion
Since version 4 and 5, it is constantly claimed by Oracle that things will become smoother with new version but in reality all new versions come with new features and more complexites. Inspite intoducing tools like Enterprize Manager, DBA has to be involved in all aspect of System Maintenance. With the advent of Internet access, maintenance of large and 24*7 databases becoming more sensative. In my humble opinion, demand for experienced DBA's may be growing and not declining in coming future. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 26 Feb 2001 10:25:31 -0800 Sure everything will be point and click! But it means nothing! Who will open tars, report bugs, download patches, etc?! When we're using Oracle 7, Oracle said that Oracle 8 will work by itself, tune itself, low cost maintenance, etc. So, tell me what happened? Also in my opinion DBA duties includes database architect. -Original Message- Sent: Monday, February 26, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for 2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not need a dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA evolution path - please share your opinion
I agree, right now it is one of the best growing job markets. Computers will be around forever, and until they can operate themeselves, learn on their own and take care of themselves when they break, there will always be a need for people like us. Kev -Original Message- Rafiq Sent: Monday, February 26, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Since version 4 and 5, it is constantly claimed by Oracle that things will become smoother with new version but in reality all new versions come with new features and more complexites. Inspite intoducing tools like Enterprize Manager, DBA has to be involved in all aspect of System Maintenance. With the advent of Internet access, maintenance of large and 24*7 databases becoming more sensative. In my humble opinion, demand for experienced DBA's may be growing and not declining in coming future. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 26 Feb 2001 10:25:31 -0800 Sure everything will be point and click! But it means nothing! Who will open tars, report bugs, download patches, etc?! When we're using Oracle 7, Oracle said that Oracle 8 will work by itself, tune itself, low cost maintenance, etc. So, tell me what happened? Also in my opinion DBA duties includes database architect. -Original Message- Sent: Monday, February 26, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for 2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not need a dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA evolution path - please share your opinion
I disagree. So does Parade magazine from yesterday's Sunday paper (for all you in the US that get it - it said that DBA demand is increasing 70% per year if I recalled the article correctly. I don't have it at work now, so please correct my numbers if you have it). -Original Message-From: andrey [mailto:[EMAIL PROTECTED]]Sent: Monday, February 26, 2001 11:41 AMTo: oralist@lists; [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: Oracle DBA evolution path - please share your opinion Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not needa dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance !
RE: Oracle DBA evolution path - please share your opinion
Nope, you are correct. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Glenn TravisSent: Monday, February 26, 2001 3:47 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle DBA evolution path - please share your opinion I disagree. So does Parade magazine from yesterday's Sunday paper (for all you in the US that get it - it said that DBA demand is increasing 70% per year if I recalled the article correctly. I don't have it at work now, so please correct my numbers if you have it). -Original Message-From: andrey [mailto:[EMAIL PROTECTED]]Sent: Monday, February 26, 2001 11:41 AMTo: oralist@lists; [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: Oracle DBA evolution path - please share your opinion Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not needa dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance !
pro*c install ?
DBA's, Can anyone give me some tips on installing/configuring pro*c on AIX/8.1.6. I've looked at the install manual, technet, metalink, etc??? ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle DBA evolution path - please share your opinion
Kevin Kostyszyn wrote: I agree, right now it is one of the best growing job markets. Computers will be around forever, and until they can operate themeselves, learn on their own and take care of themselves when they break, there will always be a need for people like us. Kev -Original Message- Rafiq Sent: Monday, February 26, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Since version 4 and 5, it is constantly claimed by Oracle that things will become smoother with new version but in reality all new versions come with new features and more complexites. Inspite intoducing tools like Enterprize Manager, DBA has to be involved in all aspect of System Maintenance. With the advent of Internet access, maintenance of large and 24*7 databases becoming more sensative. In my humble opinion, demand for experienced DBA's may be growing and not declining in coming future. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 26 Feb 2001 10:25:31 -0800 Sure everything will be point and click! But it means nothing! Who will open tars, report bugs, download patches, etc?! When we're using Oracle 7, Oracle said that Oracle 8 will work by itself, tune itself, low cost maintenance, etc. So, tell me what happened? Also in my opinion DBA duties includes database architect. -Original Message- Sent: Monday, February 26, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Dear List ! Some background : i've been around Oracle for several years , i'm DBAing for 2+ years now , i have written some java code (jdbc , some XML etc) , perl , PL/SQL , Tcl/Tk , a lot of UNIX scripting . .Where do i go to from here ? Many people say that the profession of Oracle DBA is going to be less demanded in future , because of : 1) either other DB ( like less-expensive MS SQL Server or free MySQL) will occupy the market , especially in small enterprises ; 2) or Oracle will "improve" the DB management and make it "point and click" , so you do not need a dedicated Oracle DBA at all or you need less Oracle DBAs . So , the bottom line is : what should i learn now ? how can i extend my expertise ? In which fields ? Please share your thoughts ! Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Everything evolves. It is only natural that software will become smarter, especially with Oracle attempting to move more product into smaller businesses. I am an independent and work with both large and not so large companies. I am busier that ever. I developed my Java, application and server side skills using affordable tools, I am Cisco certified as well. I don't demand huge fees for consulting, and I am in demand and doing very well. It is all about evolving. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Weber
Event 10351 -- Async I/O on Solaris
Hi, list. Has anyone used "event 10351" ? I'm checking for Async I/O on Solaris 2.6, Oracle 7.3.4 It works just fine over Raw Devices and It does not over FS (as usual). I can see this on a OS trace. But searching on metalink I've found this: "Event 10351 is also used to get information whether Oracle is using this aio calls or not. " I've tried it (with level 2) and the result was this: *** SESSION ID:(5.1) 2001.02.26.18.17.41.000(ssfiasi) do_asy_ok = 1, nreqs = 8(ssfsync) entry, nreqs = 8, start = 0, flags = 0x2 Does "do_asy_ok" mean that async i/o is not working? Can I see more info about this, how can I find it? Over raw devices I get the same output. *** SESSION ID:(5.1) 2001.02.26.18.28.32.000(ssfiasi) do_asy_ok = 1, nreqs = 8(ssfsync) entry, nreqs = 8, start = 0, flags = 0x2 thanks
orarrp question
gurus,
i want my users to print their report directly to their printer rather than
to the server.
so i've installed orarrp.exe in my computer and updated the nt web
application server 6iserver.conf to include application/x-orarrp rrpp
rrpa rrpr rrpt rrpi .
to test if it's working , a form is created that will call an oracle
report and specifies that it shld be output to file w/ file extension rtf.
This sample is the same as the one in the technet. the form has a push
button to start the report and create a timer to monitor its
progress...when i run the form nothing happens...
grace.rdf is tested working for client server and web. Is there
something wrong in my code?
pls help...
here's thecode In when button pressed trigger,
declare
report_id report_object;
htimertimer;
vcfilevarchar2(255);
vcresult varchar2(20);
BEGIN
--call_form('GETARGUS');
break;
vcfile := 'test.rrpr'; -- rich text format
report_id := find_report_object('c:\suysing\grace.rdf'); -- path where
the grace.rdf report can be found in web app. server
set_report_object_property(report_id,report_execution_mode,batch);
set_report_object_property(report_id,report_destype,file);
set_report_object_property(report_id,report_desformat,'rtf' );
set_report_object_property(report_id,report_desname,'c:\app\'||vcfile);
set_report_object_property(report_id,report_server,'Rep60_Web');
:global.reporthandle := run_report_object(report_id);
:global.printoutpurt := vcfile;
htimer := create_timer('Printer_Queue','15000',repeat);
end;
In when timer expired ( form trigger);
declare
vcstatus varchar2(20);
vctimername varchar2(30);
htimertimer;
begin
vctimername := get_application_property(timer_name);
if vctimername = 'PRINTER_QUEUE' then
vcstatus := report_object_status(:global.reporthandle);
if vcstatus in ('RUNNING','OPENING_REPORT','ENQUEUED') then
null;
elsif vcstatus = 'FINISHED' then
web.show_document('http://web/app/'||:global.printoutput,'_blank');
delete_timer(vctimername);
else
message('report fialed');
delete_timer(vctimername);
end if;
end if;
end;
Best regards,
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: grace lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: process parameter
hi all, How and where to define or change the OS ( AIX 4.3.3) semaphore parameters. Some unix admins please help me... I'm able to see the active semaphores using ipcs -s . But how to modify them if required Regards, Raman Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Yes. It not only depend on your system resources like RAM but most dependent on semaphores defined on your unix system. Besides before increasing it you have to see your sessions requirement. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 23 Feb 2001 11:21:43 -0800 what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of process to be set. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP tablespace segment management
Since 8 you can issue an alter session set events 'immediate trace name DROP_SEGMENTS level ts#+1';. Given that the ts# is the number of tablespace. And you can know that from the table sys.ts$. You have temporary tablespace since 8i. I mean the ones you create with create temporary tablespace.These ones deallocate extents when the transaction finishes. Regards. -Mensaje original- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 26 de febrero de 2001 16:25 Para: Multiple recipients of list ORACLE-L Asunto: TEMP tablespace segment management Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LONG RAW into BLOB
hi all .. i wanna ask something ... how can i insert my LONG RAW field value .. into BLOB field ? how to do that ? regards abimanyu "I'll be back!" Arnold Schwarzenegger -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: process parameter
Raman, You will need to use the "smitty" facility. Just type "smitty" on the unix prompt and then do what ever you want to do in system admin. Rgds, Raja -- On Mon, 26 Feb 2001 18:05:24 raman.yagna wrote: hi all, How and where to define or change the OS ( AIX 4.3.3) semaphore parameters. Some unix admins please help me... I'm able to see the active semaphores using ipcs -s . But how to modify them if required Regards, Raman Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Yes. It not only depend on your system resources like RAM but most dependent on semaphores defined on your unix system. Besides before increasing it you have to see your sessions requirement. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 23 Feb 2001 11:21:43 -0800 what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of process to be set. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: process parameter
why need to change the semaphores ??.. isnt AIX uses kernal extensions for the same ? -- From: Viraj Luthra[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Subject: Re: process parameter Raman, You will need to use the "smitty" facility. Just type "smitty" on the unix prompt and then do what ever you want to do in system admin. Rgds, Raja -- On Mon, 26 Feb 2001 18:05:24 raman.yagna wrote: hi all, How and where to define or change the OS ( AIX 4.3.3) semaphore parameters. Some unix admins please help me... I'm able to see the active semaphores using ipcs -s . But how to modify them if required Regards, Raman Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Yes. It not only depend on your system resources like RAM but most dependent on semaphores defined on your unix system. Besides before increasing it you have to see your sessions requirement. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 23 Feb 2001 11:21:43 -0800 what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of process to be set. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
ignore this test !!!!
test PS: Hampir lupa, kamu sudah punya pacar belum? Mau temenin aku Cari Cinta ngga di www.naver.co.id? Get your free E-mail account at http://www.detik.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: process parameter
hi, what exactly is smitty utility? please clarify -Original Message- Sent: Tuesday, February 27, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Raman, You will need to use the "smitty" facility. Just type "smitty" on the unix prompt and then do what ever you want to do in system admin. Rgds, Raja -- On Mon, 26 Feb 2001 18:05:24 raman.yagna wrote: hi all, How and where to define or change the OS ( AIX 4.3.3) semaphore parameters. Some unix admins please help me... I'm able to see the active semaphores using ipcs -s . But how to modify them if required Regards, Raman Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Yes. It not only depend on your system resources like RAM but most dependent on semaphores defined on your unix system. Besides before increasing it you have to see your sessions requirement. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 23 Feb 2001 11:21:43 -0800 what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of process to be set. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: rammohan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: process parameter
Hi, Sorry for unix related question Software Installation and Maintenance Software License Management Devices System Storage Management (Physical Logical Storage) Security Users Communications Applications and Services Print Spooling Problem Determination Performance Resource Scheduling System Environments Processes Subsystems Applications RS/6000 SP System Management AIX System Backup Recovery/6000 Using SMIT (information only) Under which option can i find about semaphores and where this information will be stored.( file ) Regards, Raman Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Raman, You will need to use the "smitty" facility. Just type "smitty" on the unix prompt and then do what ever you want to do in system admin. Rgds, Raja -- On Mon, 26 Feb 2001 18:05:24 raman.yagna wrote: hi all, How and where to define or change the OS ( AIX 4.3.3) semaphore parameters. Some unix admins please help me... I'm able to see the active semaphores using ipcs -s . But how to modify them if required Regards, Raman Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Yes. It not only depend on your system resources like RAM but most dependent on semaphores defined on your unix system. Besides before increasing it you have to see your sessions requirement. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 23 Feb 2001 11:21:43 -0800 what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of process to be set. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Unix Cron job help
Dear Lister: I have two cron jobs which run at 10:30 PM 2:00 AM, job A performed a DB hot backup and job B will put those backup files into tapes. The problem is job B is based on the success completion of job A. How can I write the unix script for job B to do this check ? Please help. T.I.A. David Jones ITResource _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
