index_S

 
[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  

 


Perl for Oracle DBAs
Perl for Oracle Dbas
ISBN: 0596002106
EAN: 2147483647
Year: 2002
Pages: 137

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net