Skip to Main Content
Advanced Oracle PL/SQL Programming with Packages
book

Advanced Oracle PL/SQL Programming with Packages

by Steven Feuerstein
October 1996
Intermediate to advanced content levelIntermediate to advanced
687 pages
16h 41m
English
O'Reilly Media, Inc.
Content preview from Advanced Oracle PL/SQL Programming with Packages

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 --------------- ------------------ ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin

Publisher Resources

ISBN: 1565922387Supplemental ContentCatalog PageErrata