I know that I need advanced compression option if I compress table for
all operations. Do I need advanced compression license if I compress just
LOB columns? The problem is licensing, I can't exceed the licenses
allotted and the company didn't purchase the advanced compression option.
DB version is:

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production


SQL> select action,version,comments
2 from dba_registry_history;

ACTION VERSION COMMENTS
------------------------------ ---------- -------------------------
APPLY 11.2.0.2 Patchset 11.2.0.2.0
APPLY 11.2.0.2 Patchset 11.2.0.2.0
APPLY 11.2.0.2 PSU 11.2.0.2.2
APPLY 11.2.0.2 PSU 11.2.0.2.3



--
http://mgogala.byethost5.com

On Thu, 28 Jul 2011 01:10:14 +0000, Mladen Gogala wrote:


OK, I found it. The news is not good: http://tinyurl.com/3nowq5k
I quote:
About Deduplication

SecureFiles Intelligent Deduplication, available with the Oracle Advanced
Compression Option, enables Oracle Database to automatically detect
duplicate LOB data within a LOB column or partition, and conserve space
by storing only one copy of the data.

Note that you must have a license for the Oracle Advanced Compression
Option before implementing SecureFiles Intelligent Deduplication. See
Oracle Database Licensing Information for more information.

Same applies to compression. Bummer.
--
http://mgogala.byethost5.com

On Jul 27, 11:50*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
Unfortunately, a lot of the better new features are all extra-cost
options. It can be pretty difficult to keep track of what is OK to
use since so much of the extra-charge items come included with the
database like the AWR. It is there and Oracle automatically collects
data but if you want to look at it you need the EM Diagnostic and/or
Performance Pack options.

HTH -- Mark D Powell --

On Mon, 01 Aug 2011 08:26:46 -0700, Mark D Powell wrote:

That is why my management asked me to find a way to decrease the number
of Oracle licenses. I first was investigating PgSQL, but that was a dud.
I'm in the process of investigating MongoDB for our DW, which would
likely relinquish some RAC and partitioning licenses. Oracle became so
darned expensive that this project got the highest priority.


--
http://mgogala.byethost5.com

Mladen Gogala <no (AT) email (DOT) here.invalid> wrote in newsan.2011.08.01.16.11.53
@email.here.invalid:

Maybe DB2 can be a viable alternative?
From 9.7 onwards it has a rather good "Oracle compatibility mode", so you
can run existing PL/SQL with almost no changes.

HTH

--
Jeroen

In article <Xns9F34EAC54B818TheBossUsenet (AT) 194 (DOT) 109.133.246>,
TheBoss (AT) invalid (DOT) nl says...



Is there an equivalent to the "web pl/sql toolkit" on DB2?


--
jeremy

On Tue, 02 Aug 2011 09:19:54 +0100, Jeremy wrote:


That is not really important. I am not sure why were web functions
integrated with the database in the first place? Relational database must
be good at storing and retrieving the data, not deal with the user
interface. Web is a UI and doesn't really belong to the RDBMS world. My
personal preference for dealing with web is a scripting language like PHP.
I am not sure that turning a database into web server makes much sense.
As of version 10, it is possible to do just that, by using
DBMS_XDB.SETHTTPPORT. Unfortunately, management of this "web server" is
convoluted and complex, I definitely do prefer Apache to do my web
serving. There are programs for checking Apache logs, there are
additional modules like PHP, Perl and Python, there are monitors and
programs that secure it and programs that will help you configure it.
There is nothing like that within Oracle RDBMS. As a web server Oracle
RDBMS is far inferior to Apache and even to IIS.



--
http://mgogala.byethost5.com

In article <pan.2011.08.02.12.49.51 (AT) gmail (DOT) com>, gogala.mladen (AT) gmail (DOT) com
says...
Actually Mladen you missed the point (not that I explicitly stated what
that point was - left for the reader to guess!) - the "web pl/sql
toolkit" is a set of PL/SQL packages which are then utilised by an
apache (Oracle HTTP Server) plug-in (mod_plsql)

My interest was stirred at the idea that a PL/SQL application might run
on DB2 - and if there was a way in which a web application built using
the web pl/sql toolkit might also be able to run.

Oracle does have an HTTP server built-in (I forget its name) - but that
is additional to the web pl/sql toolkit.

--
jeremy

On Tue, 02 Aug 2011 14:13:38 +0100, Jeremy wrote:

Ah, you have Apex applications? Now, that will need rewriting.
Fortunately, something like Django, Cake of Symfony can be a rather good
replacement. I admit, Apex is a great idea for a vendor lock. People are
using it to develop simple reports and forms in a really fast manner, but
they are completely and utterly non-portable. And being faithful to
Oracle is getting really expensive these days.



--
http://mgogala.byethost5.com

On Tue, 02 Aug 2011 14:17:08 +0000, Mladen Gogala wrote:

This is "or Symfony". All of the above are application generators using
open source scripting languages. My personal preference here is Symfony,
because I know it.



--
http://mgogala.byethost5.com