Visit Our UNIX and Linux User Community


Perl-to-Oracle performance: DBI-pack visa 'sqlplus' usage


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Perl-to-Oracle performance: DBI-pack visa 'sqlplus' usage
# 8  
Old 11-17-2009
adderek, jim mcnamara
I've get your opinion that the DBI is faster than the 'pipe'-solution and that the way to work in Oracle much more important than the way to bring the requests upt to Oracle.
I have considered the sql*loader as a good option.
Thank you for that!

Generally speaking, I've get that the difference of involve the Oracle considerable insignificant relatively to the way of processing the Oracle staff.
So, more convenient and easy to handle (from coding side) way is reasonably more appropriate!

(I am interested in all other 'funny staff', like 'exadata', tkprof, '..developer', TOAD and 'clustered tables' and even much expressed by so wide ... referred area! Smilie
I hope that for some readers it would be a good guideline to learn Oracle tools and market.
One of the smart ways to hide information is to provide it with tones of unrelated information. )

Anyway, thank you for participation and your advance opinions!
# 9  
Old 11-17-2009
MySQL

Quote:
Originally Posted by jim mcnamara
I've been coding in Oracle since version 2, in 19-um-whatever. I'm older than dirt.
Wow... So there was Oracle 2? Smilie
Quote:
Originally Posted by jim mcnamara
Learn to use tkprof. PL/SQL developer. TOAD.
I would add Oracle SQL Developer (which has superb functionality but is an unstable memory hog... which is free where way better Toad-non-freeware costs a lot).
Quote:
Originally Posted by jim mcnamara
Read a Tom Kite book.
Tom Kyte from asktom? Then it might be a great book indeed.
I would add books by Steven Feuerstein (although it is mostly about PL/SQL).

Thanks for the post and for the summarize Smilie

Previous Thread | Next Thread
Test Your Knowledge in Computers #838
Difficulty: Medium
Both SMTP and HTTP are valid application layer protocols used as transport for SOAP.
True or False?

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl Oracle DBI through Apache problem

Experts, I've been struggling with making a Perl Oracle DBI script to work through my Apache webserver. Mysql DBI scripts work fine, but I'm having issue's with Oracle. The oracle script works on command line, but I'm getting an "Internal Server Error" with apache Sourcing the oracle... (0 Replies)
Discussion started by: timj123
0 Replies

2. Shell Programming and Scripting

Perl DBI error

Hi All, I installed DBI module in a non INC location and using it in my script via "use lib". But it throw the below error at the "use DBI" step. Please help Usage: DBI::_install_method(dbi_class, meth_name, file, attribs=Nullsv) at /xx/xxx/xxxxx/xxxxx/oracle/lib/DBI.pm/oracle/lib/DBI.pm line... (2 Replies)
Discussion started by: prasperl
2 Replies

3. Shell Programming and Scripting

perl: help with DBI

Hi there, I have a bit of code similar to below (which ive actually got from perldoc, but mine is similar enough) $sth = $dbh->prepare(q{ SELECT region, sales FROM sales_by_region }); $sth->execute; my ($region, $sales); # Bind Perl variables to columns: $rv =... (4 Replies)
Discussion started by: hcclnoodles
4 Replies

4. UNIX for Advanced & Expert Users

Perl's DBI Module on OS X - uninstallable?

i've been struggling with installing the Perl DBI & DBD modules all weekend, and I'm getting close, but no cigar as of yet. When I run the perl script db.pl I get the following mismatch error: Mon Apr 19 09:43:29 EDT 2010 /Library/Perl/DBD-mysql-4.011 -> peterv@MBP17.local<515>$: db.pl | tee... (0 Replies)
Discussion started by: peterv6
0 Replies

5. Shell Programming and Scripting

connect to MySQL from Perl using DBI

Hi, I want to connect perl with the mysql to select and so on but the connection don't work code #!/usr/bin/perl BEGIN { # PERL MODULES WE WILL BE USING use DBI; $dbh = DBI->connect('DBI:mysql:C:\Program Files\MySQL\MySQL Server 5.0\data\db1','','pass') or die $DBI::errstr;} #... (1 Reply)
Discussion started by: eng_shimaa
1 Replies

6. Shell Programming and Scripting

Installing Perl DBI and DBD

Hi, i have some queries on installing the Perl DBI and the DBD Oracle. I know that i have to install the DBI first. I have the source files in a folder in my home directory.The commands to install arecd /home/DBI Perl Makefile.PL make make installI would like to know, after executing these... (4 Replies)
Discussion started by: new2ss
4 Replies

7. Programming

perl dbi to oracle getting disconnect_all for oracle dbi help

hi i am trying to connect to an oracle database using dbi and i get this :: Driver has not implemented the disconnect_all method. at /opt/perl/lib/site_perl/5.8.0/sun4-solaris/DBI.pm line 575 END failed--call queue aborted. for all i know, the script was working earlier, but has... (1 Reply)
Discussion started by: poggendroff
1 Replies

8. Shell Programming and Scripting

PERL DBI module install

We ran into an issue trying to install DBI and DB2 modules for perl for AIX from the link http://www-306.ibm.com/software/data/db2/perl/ We tried to install the DBI module using bash# perl -MCPAN -e 'install DBI' command. However we ended up with the following error. Stop. ... (3 Replies)
Discussion started by: jerardfjay
3 Replies

Featured Tech Videos