O'Reilly logo

Advanced Oracle PL/SQL Programming with Packages by Steven Feuerstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4.3. Installation Instructionss

This section describes how to install the PL/Vision Lite product and to use the PL/Vision Online Reference and the other files on the companion disk (view disk content online at http://examples.oreilly.com/advoracle).

4.3.1. What's On the Disk?

You'll see the following four files on the disk provided with this book (view disk content online at http://examples.oreilly.com/advoracle):

disk.id

Contains label information (product name and version number)

plvlite.001

Compressed PL/Vision Lite software and online companion reference

read.me

Instructions for acquiring a non-Windows version of PL/Vision Lite

setup.exe

Executable file that installs the PL/Vision Lite program files (contained in plvlite.001).

4.3.2. Storage Requirements

To determine how much space you will need in the SYSTEM tablespace to install the PL/Vision packages, I ran the following script in my own PL/Vision account:

SELECT type, 
       SUM (source_size) source_size, 
       SUM (parsed_size) parsed_size, 
       SUM (code_size) code_size
  FROM user_object_size
 WHERE name LIKE 'PLV%'
    OR name = 'P'
 GROUP BY type
 ORDER BY code_size DESC
/

This script accesses the USER_OBJECT_SIZE data dictionary to sum up the total size of source code (source_size), parsed code (parsed_size), and compiled code (code_size). The results are shown below (and may vary according to the final state of the code at time of publication):

SQL> start plvsize SEF TYPE SOURCE_SIZE PARSED_SIZE CODE_SIZE --------------- ------------------ ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required