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]

scalability, mod_perl 
scalar values, in Perl  2nd 
scheduled jobs, checking on 
SchemaDiff  2nd 
    downloading 
    installing 
    running 
schemas
    comparing/generating
        zzz  [See also SchemaDiff][See also SchemaDiff]2nd 
    dumping, example of 
        zzz  [See also sqlunldr.pl][See also sqlunldr.pl]
    examining/saving  [See SchemaView-Plus]
    tracking changes to  [See PDBA repository reports, of database changes]
SchemaView-Plus  2nd 
    installing on Unix 
    installing on Win32 
scripts
    CGI  [See CGI scripts]
    configuration files
        changing  [See PDBA::ConfigLoad PDBA::ConfigFile]
        loading  2nd 
        locating 
    created by defrag.pl command 
    for DBA tasks, avoiding cutting/pasting  [See DDL::Oracle]
    PDBA Toolkit  [See PDBA Toolkit scripts]
    Perl  [See Perl scripts]
    web  [See embedded web scripting]
Secure Sockets Layer (SSL), modules used with LWP.pm 
security  [See also passwords]
    batch job passwords and 
    Cygwin and 
    EXTPROC and 
    ls() subroutine as example of risk 
    OPS$ Oracle accounts 
    Oracletool  2nd 
    passwords and 
    PDBA password server and 
    PDBA Toolkit, script installation order 
    Perl, web resource for security modules 
    pwd.conf 
        %instanceAuth data structure 
SELECT statements (Oracle) 
selectall_arrayref method (Perl DBI) 
selectall_hashref method (Perl DBI) 
selectcol_arrayref method (Perl DBI) 
selectrow_array method (Perl DBI) 
Senora  2nd 
    DataDictionary plug-in, ls option 
    downloading 
    flexibility of 
    installing 
    options, Unix-style 
    plug-ins, table of 
    running 
    SQL*Plus and 
sequence_rpt, reporting on sequences 
serverName parameter (chkalert.pl) 
sessions
    limiting resource consumption 
    sniped, killing 
        with PDBA Toolkit scripts 
SHARED_POOL_SIZE parameter (Oracle) 
sleepTime parameter (kss.conf) 
Solaris
    installing Perl from prebuilt package 
    installing StatsView on, ps -ef command 
        zzz  [See also StatsView, installing][See also StatsView, installing]
Solaris 8 
    installing Apache::OWA 
SourceForge.net, Perl open source resource 
spdrvr.pl 
    command-line options 
        date options 
        options and tags 
        report-specific options 
        -report_list option 
        text options 
    implementation of 
    parameters 
    PDBA-generated SQL used with, example of 
    predefined reports 
    reporting parameter changes 
    viewing repository data 
split function (Perl) 
split operator (regex) 
sprintf function (Perl) 
    formats for 
SPX report, comparing execution plans 
SQL
    cache, warning about excursions into 
    collecting for PDBA repository 
    execution plans  [See SQL execution plans]
    execution, troubleshooting slowdown  2nd 
    scripts  [See SQL scripts]
    statements  [See SQL statements]
    tracking in V$SQLTEXT data dictionary view  2nd 
SQL execution plans
    and cache examination  [See OraExplain]
    comparing 
    reporting on  2nd 
SQL explain plan  [See SXP]
SQL Query Tool 
SQL scripts
    adding to Oracletool 
    created by defrag.pl command 
    repository of  [See Orac]
SQL statements
    binding parameters to 
    collecting/storing from data dictionary 
    examining  2nd 
    generating XML files from 
    number of rows processed by 
SQL*Loader 
SQL*Net 
SQL*Plus
    alternative to  [See Senora]
    dropping user accounts, limitations of 
    Perl compared to 
    Perl DBI tools 
    Perl driver for 
    Senora and 
    writing ad hoc SQL reports 
SQL*Plus Driver  [See spdrvr.pl]
sqlunldr.pl  2nd 
    command-line options, table of 
    features of 
square brackets ([]) 
    Perl 
    Perl regex metacharacter 
square brackets-caret sign ([^]), Perl regex metacharacter 
square brackets-exclamation points ([! . . . !]), Perl in Embperl template 
square brackets-hyphens ([- . . . -]), Perl in Embperl template 
square brackets-plus signs ([+ . . . +]), Perl in Embperl template 
SSL (Secure Sockets Layer), modules used with LWP.pm 
<<START_DATE_PK>> tag (spdrvr.pl) 
STARTUP_EXTPROC_AGENT, debugging external procedures setup 
statement handle metadata, Perl DBI 
statement handles, creating 
statistics, gathering  [See StatsView]
StatsView  2nd 
    downloading 
        gnuplot installation 
        PNG installation 
        PNG, need for 
        zlib installation 
    installing 
        ps -ef command 
        sv program 
    installing Tk::GBARR 
Storable
    downloading 
Storable package  2nd 
    required by Mason 
Storable.pm
    Embperl on Unix, storing data structures in Perl 
    interface with Apache 
strings
    functions for handling in Perl 
    interpolated in Perl regexes 
subroutines, Perl scripts 
substitution operator, regexes 
substr function (Perl) 
suffixes of regexes 
sv program (StatsView) 
svplus program 
SXP (SQL explain plan)
    repository tables 
    scripts 
sxp.pl  2nd  3rd 
    command-line options 
    password/privilege messages 
    unique constraint error 
sxpcmp.pl  2nd  3rd 
    example output 
sxprpt.pl  2nd  3rd 
sys_privs_diff_rpt, reporting on changes to system privileges 
sys_privs_rpt, reporting on system privileges 
SYSDBA/SYSOPER, login cases for with PDBA::CM 

Team LiB   Previous Section