[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 |