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