index_P | Perl for Oracle Dbas

[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