Team LiB   Previous Section
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

package variables, Perl 
packages
    ActivePerl for DDL::Oracle 
    extracting DDL from  [See ddl_oracle.pl]
    Perl 
    PPM ActivePerl, advantages of 
    prebuilt, installing Perl on Unix from 
        .gz suffix and 
    required by Cygwin 
        downloading 
pager parameter (dbup.conf) 
parameter files, created by defrag.pl command 
parameter_diff_rpt
    example output 
    reporting changes to initialization parameters 
parameter_rpt, reporting on initialization parameters 
parameters
    binding to SQL statements 
    configuring 
    initialization, reporting changes to 
    reporting changes to 
Params::Validate
    installing on Win32 
    Mason and  2nd 
parentheses (()), Perl regex metacharacter 
password encryption
    via TCP socket, pwd.pl 
password server 
    client module communicating with 
    installing as Unix daemon or Win32 service 
    installing kss_NT.pl 
    loading parameters 
    PDBA  [See PDBA password server]
    PDBA repository and 
    scanning command line for options intended for 
passwords
    batch, problems with 
    encrypted, retrieving 
    encrypting  [See also password encryption]
        PDBA Toolkit scripts 
    generating in PDBA::DBA 
    inherent problems with 
    Karma security, TermReadKey.pm 
    managing via pwd.pl 
    Oracletool security levels 
    PDBA Toolkit password-control modules 
    security of 
PATH variable
    gnuplot and 
    installing Perl and 
    resetting when building Perl for oracle user 
    separator in, determining 
pathsep method (PDBA module) 
PDBA Extensions (PDBAx) 
PDBA module 
    adding usage method to 
    configuring 
    methods 
PDBA password client
    configuring 
        creating configuration file for 
PDBA password server
    configuring 
        encrypting passwords 
        securing pwd.conf 
        setting passwords 
        setting TCP port 
        setting up password server users 
        setting up per-account authorization 
    running on Unix 
    running on Win32 
        Windows NT 4.0/2000 
PDBA repository 
    allotting storage space for 
    changing date format in reports 
    creating baseline for 
    DBD::Oracle and 
    installing 
        access to V$PARAMETER/V$INSTANCE parameters 
        copying pdbarepq.conf 
        editing pdba_tbs8i.sql 
        tablespace creation 
    loading with data 
    Oracle data dictionary and 
        tables in 
    overhead 
    password server and 
    specialized tables in 
    table structure 
    viewing data 
    zzz  [See also reports, of database changes][See also reports, of database changes]
PDBA Toolkit (Perl DBA Toolkit) 
    building database repository with  2nd  [See also PDBA repository]
    configuring 
        password client 
        password server 
        PDBA module 
        PDBA::CM 
    connection manager 
    downloading 
    example behaviors to modify 
    extending  2nd 
        zzz  [See also PDBA::OPT PDBA::PWC][See also PDBA::OPT PDBA::PWC]
    installing
        on Unix 
        on Win32 
    methods  [See PDBA::DBA]
    modules  2nd  3rd 
        modifying 
        PDBA module 
        PDBA::CM 
        PDBA::ConfigFile 
        PDBA::ConfigLoad 
        PDBA::Daemon 
        PDBA::DBA 
        PDBA::GQ 
        PDBA::LogFile 
        PDBA::OPT 
        PDBA::PidFile 
        PDBA::PWC 
        PDBA::PWD 
        PDBA::PWDNT 
        Win32::Daemon 
    password client  [See PDBA::PWC]
    password client for NT  [See PDBA::PWDNT]
    passwords, managing  [See PDBA::PWD]
    programs in 
    repository  [See PDBA repository]
    required modules, directory for on Unix 
    security, script installation order 
    utilities  [See PDBA module]
    utilities logging  [See PDBA::LogFile]
PDBA Toolkit scripts  2nd 
    baseline.pl, collecting baseline data dictionary data 
    checksums and 
    chkalert.pl, monitoring alert log with 
    create_user.pl 
    database administration  2nd 
    dba_jobsm.pl 
        configuring 
        functions/formats description 
        modifying 
        script description 
    dbup.pl/dbup_NT.pl
        monitoring database connections 
        testing monitor 
    ddl_oracle.pl 
    directory for on Unix 
    directory paths for 
    dropping user accounts 
    dup_user.pl 
    extending toolkit 
    extracting DDL and data 
    functions/formats, line-by-line description of 
    idxr.pl, rebuilding indexes 
    installing 
    killing sniped sessions 
    kss.pl
        installing on Unix 
        installing on Win32 
    line-by-line description of 
    logging by 
    maintaining indexes 
    managing extent usage 
    managing user accounts 
    maxext.pl 
    modifying 
    monitoring 
    monitoring alert log with 
    monitoring database connections 
    monitoring databases 
    mucr8.pl 
    password encryption 
    pdba_tbs8i.sql 
    repository 
    spdrvr.pl
        command-line options 
        implementation of 
        options and tags 
        parameters 
        PDBA-generated SQL used with 
        predefined reports 
        reporting parameter changes 
        viewing repository data 
    sqlunldr.pl 
    SXP 
    sxp.pl 
        command-line options 
        password/privilege messages 
        unique constraint error 
    sxpcmp.pl 
        example output 
    sxprpt.pl 
    tablespace creation 
pdba.conf 
PDBA.ppd 
PDBA::CM 
    configuration file  [See cm.conf]
    configuring 
    RaiseError/AutoCommit 
    SYSDBA/SYSOPER, login cases for 
PDBA::ConfigFile 
    simplifying configuration 
PDBA::ConfigLoad 
    loading script configuration files 
    referring to config variables by package name 
PDBA::Daemon 
    creating Unix daemon in Perl 
    using Unix daemons in Perl 
PDBA::DBA 
    creating user accounts 
    generating passwords in 
PDBA::GQ 
    modifying 
PDBA::LogFile 
    methods 
    PERMS attribute 
PDBA::OPT  2nd  3rd 
    command-line overrides for 
    password server and 
PDBA::PidFile 
PDBA::PWC  2nd 
    password server and 
    using in Perl scripts 
    on Win32  [See PDBA::PWDNT]
PDBA::PWD 
    PDBA password server and 
PDBA::PWDNT 
PDBA_HOME variable
    PDBA Toolkit and 
        default on Unix 
        installing on Win32 
        Unix configuration files 
    retrieving value of 
        code example 
    setting from command line 
pdba_tbs8i.sql 
pdbaHome method (PDBA module) 
    code example 
pdbarep_create.log 
pdbarep_create.sql 
pdbarepq.conf  2nd 
PDBAx (PDBA Extensions) 
percent sign (%)
    Perl in Mason template 
    Perl variable notation 
performance
    Apache::DBI and 
    Apache::Registry and 
    CGI scripts  2nd  3rd  [See also Apache::Registry]
    limiting resource consumption 
    Mason and 
    Perl and 
    perl_mod 
    sniped sessions and  2nd 
    statistics, reporting via DBD::Chart 
Perl 
    "use strict" line in 
    advantages of 
    Apache and 
        zzz  [See also mod_perl][See also mod_perl]
    applications, servicing users/requests 
    arrays 
        determining size of 
    boolean variable type and 
    built-in functions 
    built-in string-handling functions 
    communicating with PL/SQL 
    connectivity with PL/SQL 
    contexts 
        list 
        scalar 
        void 
    corporate world and 
    creating Unix daemon 
    creating Win32 daemon  2nd 
    data munging  [See data munging]
    data parsing  [See SchemaView-Plus]
    data structures, converting to/from strings 
    debuggers 
    distribution with shared libperl, determining whether running 
    documentation
        perldoc command 
        resources 
    downloading 
        from CPAN 
    driver for SQL*Plus 
    embedding into
        Apache  [See mod_perl]
        C 
        Embperl templates 
        Mason template 
        Oracle 
        PL/SQL 
    FAQ documents 
    finding installation of 
    GUI extensions 
    guide to  [See also Perl scripts, program\/subroutine parameters]2nd 
    hash structures, saving in platform-independent files 
    hashes 
    installing 
        under Cygwin 
        on Unix 
        on Win32 
    limitations of 
    manpage documents 
    modules  [See modules]
    object orientation in 
    obtaining online information 
    operating system documentation 
    origins of 
    references 
        anonymous arrays\/hashes 
        arrow notation 
        ref operator 
    regexes
        alternation/memory 
        delimiters in 
        greediness of 
        grep vs. 
        history of 
        interpolated strings 
        metacharacters 
        scalar/list context results 
        string-handling functions and 
    resources for futher information 
    scalars 
    scripts  [See Perl scripts]
    security, web resource for modules 
    source, installing Perl on Unix from 
    storing data structures in 
    tools for DBAs 
        connectivity tools 
        modules and applications 
        scripts 
        table of 
    upgrading 
    using Unix daemons 
    using Win32 services 
    versions of 
    web access in  [See LWP.pm]
    web extensions 
    on Win32 
    writing ad hoc SQL reports 
    XML and 
        XML parsers 
perl -MCPAN command
    PDBA Toolkit, installing modules required by 
Perl C library, calling 
Perl Database Interface  [See Perl DBI]
Perl DBA Toolkit  [See PDBA Toolkit]
Perl DBI (Database Interface) 
    API 
    class methods 
    combining with Perl/Tk 
    connecting to
        Oracle 
        as SYSDBA/SYSOPER 
    database handles
        SQL and cleanup 
        statement handle methods 
    DBD::Oracle and 
        coding with Oracle::OCI 
    documentation 
    downloading  2nd 
    extproc_perl and 
    functions, table of 
    guide to 
    installing 
        under Cygwin 
        on Unix 
        on Win32 
    limitations of 
    methods
        metadata-related 
        Oracle-specific 
    OCI and, code example illustrating integration of 
    OCIExtProcContext and 
    online documentation for 
    origins of 
    running
        Hello World example 
        by proxy 
    using in loop-back mode 
    variable naming conventions 
    versions of 
Perl IDEs (integrated development environments), web resources for 
Perl integrated development environments (IDEs), web resources for 
Perl Interactive Query Tool (PIQT) 
perl -MCPAN command
    interactive CPAN shell 
    loading LWP-related modules 
    loading mod_perl and related modules 
perl orac_dbal.pl command 
Perl Package Description  [See PPD]
Perl Package Manager  [See PPM]
Perl scripts
    calling subroutines 
    debugging 
    environment variables 
        lexical 
        package 
    package main 
    PDBA Toolkit and 
    program\/subroutine parameters 
    running 
        on Unix 
        on Win32 
    sending email from  2nd 
    taint mode 
    using PDBA::PWC in 
perl -v command 
Perl/Oracle
    architecture 
    use by DBAs 
Perl/Oracle architecture 
    DBD::Oracle 
    OCI 
        functions, table of 
    Perl DBI 
Perl/Tk 
    combining with Perl DBI 
    downloading 
    example programs  2nd 
    installing
        on Unix 
        on Win32 
    programs, basic structure of 
    resources for further information 
PERL_LIB library, creating during extproc_perl deployment 
perldbgui program 
perldoc command, accessing Perl documentation 
perldoc ExtUtils::MakeMaker command 
PerlFreshRestart option 
PERMS attribute (PDBA::LogFile) 
persistent connections 
pie charts, for performance statistics  [See DBD::Chart]
ping method (Perl DBI) 
PIQT (Perl Interactive Query Tool) 
PIRPC package 
PL/SQL
    advantages of Perl 
    communicating with Perl 
    connectivity with Perl 
    embedding Perl into 
    features 
    limitations of 
    zzz  [See also Perl, embedding into PL/SQL][See also Perl, embedding into PL/SQL]
PL/SQL Runtime Engine 
PL/SQL Server Pages (PSPs) 
PL/SQL Web Toolkit
    mod_perl and 
    packages in 
    zzz  [See also Apache::OWA][See also Apache::OWA]
platforms
    Apache runs on 
    creating log files independent of 
    for Perl/Oracle 
    porting Unix applications to Win32  [See Cygwin]
    retrieving types of 
PLSExtProc
    alternative use of for database context 
    patching DBD::Oracle 
plsql_errstr method (DBD::Oracle) 
plug-ins, Senora
    DataDictionary, ls option 
    SQL*Plus vs. 
    table of 
PluginMgr register command (Senora) 
plus sign (+), Perl regex metacharacter  2nd 
plus sign-question mark (+?), Perl regex metacharacter 
PNG (Portable Network Graphics) 
    DBD::Chart and 
    installing 
    StatsView and 
$port data structure (pwd.conf) 
portability, exporting/importing objects into Oracle databases 
Portable Network Graphics  [See PNG]
POSIX commands, Mason and 
PPD (Perl Package Description) 
    obtaining latest files 
PPM (Perl Package Manager) 
    Perl DBI and 
    running 
ppm command 
ppm utility 
    zzz  [See also PPM][See also PPM]
prepare method
    PDBA::GQ 
    Perl DBI 
prepare_cached method (Perl DBI) 
primary_key method (Perl DBI) 
primary_key_info method (Perl DBI) 
print method (PDBA::LogFile) 
printflush method (PDBA::LogFile)  2nd 
printif method (PDBA::LogFile) 
privileges
    developer account 
    granting while creating user accounts 
    in mucr8.conf file 
    reporting on database privilege grants 
    system, reporting on changes to 
procedures
    calling with OUT parameters 
    cookie manipulation 
    extracting DDL from  [See ddl_oracle.pl]
profile_rpt, reporting on profiles 
PROFILEs
    creating 
    setting RESOURCE_LIMIT parameter (Oracle) 
PROFILEs (Oracle) 
programs
    background  [See PDBA::Daemon Win32::Daemon]
    concurrent, preventing running of 
    Perl scripts 
PSPs (PL/SQL Server Pages) 
ptkdb program 
pwc.pl  2nd 
    command-line options for 
    zzz  [See also PDBA password client][See also PDBA password client]
%pwd data structure (pwd.conf) 
pwd.conf
    data structures 
    securing 
    zzz  [See also PDBA password server][See also PDBA password server]
pwd.pl 
    password management in 
pwd_service.pl 
    locating on Win32 

Team LiB   Previous Section