Re: Oracle web application
On Sat, 18 May 2002, Keith Carney wrote: > I am a beginner in Oracle and I need help. > I need to implement a interactive connection of oracle with web. I need to > save data from web to database, make a kind of processing and send a > response to the web. I have no idea even how to make the implementation. Can > somebody help me ? Keith: I would consider PHP (http://www.php.net). It is very powerful, and very fast. It is low overhead as compared to Java, and stored PL/SQL, as well as many other web development solutions. Basically you have PHP scripts embedded in HTML pages or templates which get executed by Apache in a similar way that CGI's used to. Actually PHP is compiled into the Apache server, or as a dynamically loaded module. My biz site runs on it: http://www.iheavy.com. HTH, Sean -- 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: TEST
Title: TEST What are you testing? -Original Message-From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: TEST TESTING ...
RE: MTS and Dedicated Server
Title: RE: MTS and Dedicated Server Hi... 1) Just comment or remove the init.ora parameters related with mts. 2) Configure the database as MTS. By default all connections uses dispatchers. If you want to made a dedicated connection, configure ur tnsnames.ora accordingly. Means add the attribue SHARED_SERVER = YES in the CONNECTION_DATA tns parameter. HTH. Nirmal. -Original Message- From: Eriovaldo Andrietta [SMTP:[EMAIL PROTECTED]] Sent: 08 ÑÈíÚ ÇáÇæá, 1423 04:18 PM To: Multiple recipients of list ORACLE-L Subject: MTS and Dedicated Server Hi friends : I just finished to install my database with shared server option, so i have some parameters like mts_ My question : 1.) How can I do for to take out this option and put the database in Dedicated Mode ? 2.) What can I do for use two kinds of options simultaneity: Shared and Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
TEST
Title: TEST TESTING ...
Re[4]: Compressing Export Dumps
Hello Simon, I did such exports sequentially (using cron jobs) therefore i had no problems with it. Try to look at locks maybe your sessions are blocking each other. Did you use parameter CONSISTENT=Y ? Saturday, May 18, 2002, 6:03:18 PM, you wrote: SW> Hi Sergey and all, SW> Tried to impliment the on-the-fly gzip but some breakages!! SW> I created 7 different pipes and 7 different export jobs. SW> The first job run manually completed successfuly but all the SW> croned jobs are stuck -the daemon fired them off but nothing is taking place! SW> The Log files are empty and the zipped dumps are no where to be seen! SW> A "ps -ef|grep exp" shows that the jobs are active. It's now coming to 10 SW> Hrs. SW> Any known issues with multi-occurences of pipe-files/gzip etc ? SW> Thanks SW> -Original Message- SW> Sent: Friday, May 17, 2002 5:18 AM SW> To: Multiple recipients of list ORACLE-L SW> Hello Simon, SW> The command mknod p does the same thing as mkfifo (it just calls mknod SW> p). SW> I did large exports many times using gzip. So, it's your decision SW> whether to use compress or gzip. I did not have any troubles SW> at all. You don't have to remove the pipe and can easily reuse it SW> whether you want. SW> Thursday, May 16, 2002, 8:43:25 PM, you wrote: SW>> Sergey, SW>> Thanks for the mkfifo idea. I've also come across "mknod myfifo p;compess SW> < myinfo >>> myinfo.Z" SW>> I'm looking at the two options, yet to ascertain whether second method SW> works SW>> with gzip. SW>> Do you know of any known troubles (Block/File corruption) with first SW> method ? SW>> Do I have to "rm yourinfo" or I can re-use the piping file ( as in SW> ascript) ? SW>> Thanks once again, SW>> Simon SW>> -Original Message- SW>> Sent: Thursday, May 16, 2002 2:48 PM SW>> To: Multiple recipients of list ORACLE-L SW>> Hello Simon, SW>> You can make it like this: SW>> mkfifo yourfifo SW>> gzip outfile.dmp.gz & SW>> exp ... file=yourfifo SW>> rm yourfifo SW>> Thursday, May 16, 2002, 4:38:40 PM, you wrote: SW>>> Hi all, SW>>> My export dumps are too big (80 GB) for my filesystem and I'm looking SW> for SW>> a SW>>> way SW>>> to compress them on the fly -ie without taking *.dmp to disk first but SW>>> straight *.dmp.gz SW>>> Anybody with an idea on how to archive this ? SW>>> Thanking you, SW>>> --- SW>>> CSW -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov 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 web application
Keith - Usually you need to create some sort of application that will respond to user requests, extract data from Oracle, and format an HTML page to send back to the user. That is basically what you described in your email. How that program interfaces to Oracle will depend on what programming language you choose. Usually your program is executed by a software called a "web server" or an "application server". Before you need to worry about Oracle, you need to learn a lot more about Web programming. If by "web" you mean the Internet, then you also need to learn about Web security. If your application is within your company intranet, then this concern isn't so significant. Suggestions: Find someone in your company that is an experienced Web programmer, and discuss your situation with them. That will teach you a lot quicker. Go to http://www.google.com, and type terms like "HTML Tutorial". A good site I found was http://www.mcli.dist.maricopa.edu/tut/. This won't teach you about connecting to a database, but you've got learn the basics before you progress on to advanced topics. http://www.computerworld.com/departments/technology/quickstudies offers explanations of some of the important concepts so simple even a manager can understand. If you encounter more specific questions, write back Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 18, 2002 11:43 AM To: Multiple recipients of list ORACLE-L hi, I am a beginner in Oracle and I need help. I need to implement a interactive connection of oracle with web. I need to save data from web to database, make a kind of processing and send a response to the web. I have no idea even how to make the implementation. Can somebody help me ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Carney 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: DENNIS WILLIAMS 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: Do you ever have days where you dont want to think ?
> -Original Message- > > In fact, I would be > curious to compare the join on the inline-view with a MINUS to the hash > anti-join. Assuming all correct indexes, it is comparing two index fast > full scans plus sort plus index search to two table full scans (more or > less). There was a time when I used that approach. Not talking about MINUS in general since I still find cases for that, but flipping a NOT IN / NOT EXISTS into an IN or EXISTS sitting on top of a MINUS in a sub-query, just like in your example (except you used an in-line view): select a.f1, a.f2, a.f3, a.f4 from (select f1 from table1 minus select n1 from b) a2, table1 a where a.f1 = a2.f1 But this was back in 5, 6, and early 7 and I had to use a sub-query since in-line views weren't there yet (7.2, officially?). And though the in-line view gives us more join methods to choose from, I still haven't been able to produce a case where it was the best. The biggest thing I see is the double hit on table1 (table scan or it's indexes (full or fast full)). May have had something to do with the way CBO handle NOTS back in the earlier versions? NOT real sure. Anyway, I remember a long time ago recommending the above (but using a sub-query). And I think it was Tim Sawmiller who asked why the heck I did it that way. I said because it's "faster" than a NOT IN / NOT EXISTS. He asked for an example, and I couldn't provide one. His point was well taken (we were up to V7 by then and I'm guessing pre 7.2 since I didn't try the in-line view route). In fact, someone else also recommended the approach, and he had asked both of us to provide an example, and neither one of us could make it the faster approach. So yeah, I started to re-think that approach. FWIW, I had to tune a package not too long ago that used the construct above for all their anti-joins. Most were running for minutes, anywhere from 5 minutes to 30 minutes. Going to a NOT IN (with always_anti_join set to hash) dropped all of them to a matter of seconds (and I think I had to go to a correlated NOT EXISTS on a couple others due to their nature, and the outer join null key for a couple of others since they didn't meet the requirement for a hash-aj). But knowing the technique above has been useful in the past, I have tried on several occasions to build test cases where it beat all other approaches. I haven't been able to build one. Obviously that doesn't mean there aren't cases where it could be the best, maybe just my lack of successfully thinking of and building a case where it would be the best. So, I am still curious if there are still conditions, and what those conditions are, where that approach is "the best". I just haven't been able to come up with one -- maybe another sign of my aging and losing my faculties. But at least I didn't work on V4 or prior like some of the *really* old folks on the list ;-) Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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: {9i New Features: Online Reorg or DBMS_REDEFINITION Package}
Got Oracle Update from Xephon today (May
2002).
The lead article is about online redefinition by Sameer
Wadhwa
from NuGenesis Technologies.
His article agrees with you.
Yechiel AdarMehish
- Original Message -
From:
JOE
TESTA
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, May 14, 2002 8:58 PM
Subject: {9i New Features: Online Reorg
or DBMS_REDEFINITION Package}
Welcome to the next installment of 9i New Features, today's topic is
Online changes of objects, specifically we'll cover the new package called
DBMS_REDEFINITION.
The spec for this package is located where all of the other package
sources are:
ORACLE_HOME/rdbms/admin. The file is dbmshord.sql
So what does this package give us? Well it gives the capability to
do online reorganization of a table. Ok so now if you're not confused,
you should be :)
In easy to understand terms, in the past when you wanted to move a
table to a new tablespace, drop a column, add a column, change a column
datatype, it require a exclusive lock on the table during the operation(which
if it was a large table could lock it up for a long time). Well that is
no longer the case, those kinds of changes can be done while DML is still
being applied to the object.
Let's take for an example something that all of us have been asking for
YEARS, the rename of a column.
Look at this code, I've included comments within it so its pretty much
self-explanatory and you can run it against your 9i database to see what if it
really works.
-- BEGINNING OF SCRIPT
---
set serveroutput on size 10;
-- let's drop a couple of tables so if we re-run we won't get
errorsdrop table sales;drop table sales_temp;
-- create a new table, handful of columns with the last one named
incorrectly.
create table sales(sales_id number not null, sales_amount
number(10,2) not null, salesman_id number(5) not
null, tax_amount number(5,2) not null, bad_column_name
varchar2(20) not null);
-- add a PK since for online reorg it's required
alter table sales add primary key(sales_id)
-- insert some data
insert into sales values(1,20,4,5.70,'bogus');insert into sales
values(2,30,6,6.70,'no way');insert into sales values(3,40,7,7.70,'XX
way');insert into sales values(4,50,8,8.70,'YY way');insert into sales
values(5,60,9,9.70,'ZZ way');insert into sales values(6,70,1,0.70,'AA
way');insert into sales values(7,80,2,1.70,'BB way');insert into sales
values(8,90,3,2.70,'CC way');insert into sales values(9,10,4,3.70,'DD
way');insert into sales values(10,25,5,4.70,'EE way');
-- commit the data
commit;
-- run the proc to see if this table can be reorganized online, if we
get an error,-- then its not possible, otherwise we're
good to go.
execute dbms_redefinition.can_redef_table(USER,'SALES');
-- we must create the temp table for this reorg to happen manually,
either with a -- create table statement or via a create
table as select(no rows please to be copied)-- this exercise is
going to be to do a rename on the column, so we need to
create-- the table making sure we have the new column
name
create table sales_temp(sales_id number not
null, sales_amount number(10,2) not null, salesman_id
number(5) not null, tax_amount number(5,2) not
null, good_column_name varchar2(20) not null);
-- have to have a PK on the temp table also.
alter table sales_temp add primary key(sales_id);
-- lets desc the original to see what it looks like before
prompt this is the sales desc before the changedesc sales;
-- ok lets fire up the redefinition, the parms are(SCHEMA, OLD_TBL,
TEMP_TBL,-- then column mapping, notice we're mapping
bad_column_name to good_column_name).
execute
dbms_redefinition.start_redef_table(USER,'SALES','SALES_TEMP',
-'sales_id sales_id, sales_amount sales_amount, salesman_id salesman_id,
-tax_amount tax_amount, bad_column_name good_column_name');
-- at this point its YOUR responsiblity to put the triggers, other FK
constraints(disabled)-- and indexes on the "temp" table before
calling the next part to do the "switch".
-- DO THE OTHER INDEXES, ETC HERE
-- ok time to finish up
execute
dbms_redefinition.finish_redef_table(USER,'SALES','SALES_TEMP');
prompt this is the definition of sales AFTER the changedesc
sales;select * from sales;
--- END OF SCRIPT
---
So what you think, pretty kewl(geek kids spelling)?
Check out the docs on dbms_redefinition for limitations, etc, don't want
to give you allthe answers.
Until next time all hate mail to /dev/null , all good stuff
to [EMAIL PROTECTED]
Connecting to DB from behind a firewall.
Dear list ! It's an Oracle 8.0.5 on Win NT question: We want to put our database server behind a firewall. The problem is the clients that need to connect to our DB from the "outer world". Now , i know that the Oracle listener can choose any port when passing the connection to the Oracle server. That means , that theoretically all the ports should be open on the firewall in order to allow client connections. Sounds illogical. So, is there a way to limit the ports range used by the listener when passing the connections to the Oracle server ? I do not want to use "connection manager" etc.. thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS and Dedicated Server
Yes you just need to do that. Then your server will only accept Dedicated connections. All DBA Operations should be performed on a dedicated connection to the database so if you have enabled MTS you can still connect to a dedicated server process via the listener by saying srvr = dedicated in the tns entry. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Sunday, May 19, 2002 5:18 PM To: Multiple recipients of list ORACLE-L Hi friends : I just finished to install my database with shared server option, so i have some parameters like mts_ My question : 1.) How can I do for to take out this option and put the database in Dedicated Mode ? 2.) What can I do for use two kinds of options simultaneity: Shared and Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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: Ganesh Raja 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).
MTS and Dedicated Server
Hi friends : I just finished to install my database with shared server option, so i have some parameters like mts_ My question : 1.) How can I do for to take out this option and put the database in Dedicated Mode ? 2.) What can I do for use two kinds of options simultaneity: Shared and Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
