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]
DAD (Database Access Descriptor) Data Definition Language [See DDL] data dictionary, Oracle loading baseline data into PDBA repository PDBA repository and Data Manipulation Language (DML) data munging components of conversion methods CPAN modules conversion date mathematic numeric text conversion XML guide to how it works inter-database transfer MySQL source Oracle target regexes and resource for further information data warehouse applications, limiting resource consumption Data::Dumper, required by Mason Data::Flow, required by Oracle::OCI data_sources method (Perl DBI) Database Access Descriptor (DAD) database connectivity monitoring with dbup.pl/dbup_NT.pl %uptime hash parameters monitoring with PDBA Toolkit scripts polling Database Driver for Oracle [See DBD::Oracle] database handles attributes, Perl DBI Perl DBI SQL and cleanup statement handle methods database repository, building with DBA Toolkit database server, checking on databases administering cutting/pasting scripts, avoiding [See DDL::Oracle] with PDBA Toolkit scripts [See PDBA Toolkit scripts] Unix system administration and [See StatsView] zzz [See also Oracletool][See also Oracletool] automating administration tasks checking availability of connections zzz [See also Apache::DBI database connectivity][See also Apache::DBI database connectivity] closing down pooling monitoring [See also Karma]2nd with Oracletool with PDBA Toolkit scripts Oracle limiting resource consumption NULL values and space problems on Oracle DDL from Oracle8i, reverse-engineering [See DDL::Oracle] relational, operations of [See OCI, relational functions] reporting status of jobs in schemas [See also SchemaDiff; sqlunldr.pl] comparing dumping examining/saving [See SchemaView-Plus] targets, retrieving list of tracking changes to [See PDBA repository reports , of database changes] transfering among example of data munging MySQL source Oracle target datatypes, cookie manipulation date/time information -dateformat option leap seconds in calendar modules Oracle date format, XML::XMLtoDBMS and parsing 2nd 3rd PDBA repository reports, changing in date/time utilities Date::Calc Date-Calc 5.0 API languages supplied with methods in system_clock method, figures provided by Date::Calendar Date::Format, XML::XMLtoDBMS and Date::Manip installing on Unix on Win32 Manip.cnf Date::Parse, XML::XMLtoDBMS and -dateformat option (sqlunldr.pl) DB_BLOCK_BUFFERS parameter (Oracle) dba_jobs.conf dba_jobs.pl dba_jobsm.pl 2nd configuring example report generated by functions/formats description modifying adding passwords to config file configuring parameters script description dbaAddresses parameter (chkalert.pl) DBD drivers, retrieving list of DBD::Chart 2nd downloading installing on Unix on Win32 libraries required loading for ActivePerl modules required preparing Unix downloads required using Apache with using Perl/Tk applications with DBD::mysql driver DBD::Oracle architecture compared to Oracle::OCI cursors , binding documentation provided for downloading 2nd extproc_perl and handling LOBs installing under Cygwin environment variables error hit list limitation of methods for Perl DBI online documentation for patch provided with extproc_perl download 2nd patching setting variables PDBA repository and Perl DBI and coding with Oracle::OCI relationship to Oracle::OCI versions of 2nd zzz [See also Perl DBI][See also Perl DBI] DBD::Proxy dbdimp.c file, patching DBD::Oracle dbgextp.sql file, debugging external procedure setup DBI::ProxyServer packages required dbignore.pl dbiproxy daemon running Perl DBI by proxy dbish/dbishell programs DBMS_OUTPUT package dbms_output_enable method (DBD::Oracle) dbms_output_get method (DBD::Oracle) dbms_output_put method DBD::Oracle) dbup.conf DBA on-call schedule email addresses operational parameters test configuration dbup.pl dbup.pl/dbup_NT.pl command-line options, table of configuring setting DBA on call setting pager and email addresses upDays/upHours parameters uptime requirements Date::Manip and password server and testing monitor dbup_NT.pl dbup_service.pl 2nd DDL (Data Definition Language) extracting with ddl_oracle.pl generating Oracle and time boundaries and DDL::Oracle 2nd 3rd as batch and list processor download example scripts, table of downloading installing on Win32 on Unix mailing list using as batch and list processor, defrag.pl using Orac with example program ddl_oracle.pl 2nd command-line options, table of scripts generated by, table of DEBUG_EXTPROC package debugging external procedure listeners gdb program and installing Oracle::OCI on Unix Perl GUI debuggers Perl GUI tools for, download sites Perl scripts setting tracing level defrag.pl command parameters, files created by scripts created by Deterministic Finite Automaton (DFA) developer PDBA role DFA (Deterministic Finite Automaton) Digest::MD5 directory paths for PDBA Toolkit supporting modules/scripts on Unix alert log create_user.conf creating to log files dba_jobsm.pl installing Perl on Unix for PDBA Toolkit with configuration files on Win32 scripts Win32 CGI scripts disconnect method (Perl DBI) DJ Delorie's GNU Programming Platform (DJGPP) DJGPP (DJ Delorie's GNU Programming Platform) DML (Data Manipulation Language) DML statements, preparing do . . . until loops , Embperl syntax do method (Perl DBI) dollar sign ($) Perl hashes Perl regex metacharacter Perl scalars Perl variable notation dollar sign-number sign ($#) Perl syntax dollar sign- underscore ($_) implicit use in regexes pronoun in Perl dot character (.), Perl regex metacharacter 2nd downloading ActivePerl, latest build Apache Unix version Win32 version Apache::DBI Apache::OWA Apache::Request Apache::Session Apache::SessionX Bit::Vector C::Scan Crypt::Blowfish Crypt::IDEA Crypt::RC4 Cygwin Cygwin packages Data::Flow Date::Calc Date::Calendar Date::Manip DBD::Chart DBD::Oracle 2nd DDL::Oracle expat program extproc_perl FreezeThaw Karma libapreq libnet library libxml2 libxslt LWP.pm Mail::Sendmail Mason MIME::Base64 MLDBM mod_perl Number::Format Open Perl IDE ora_explain.PL Orac Params::Validate PDBA Toolkit PDBA.ppd PDBAx Perl source from CPAN Perl DBI 2nd Perl/Tk PNG recode library SchemaDiff Senora StatsView gnuplot installation PNG installation PNG, need for zlib installation Storable 2nd Time::HiRes TimeDate Tk::GBARR Win32::Daemon XML::Dumper XML::LibXML XML::LibXSLT XML::Parser XML::SAX XML::XMLtoDBMS XML::XPath zlib drop method (PDBA::DBA) drop_user.pl 2nd dump_results method (Perl DBI) dup_user.pl 2nd dynamic SQL utilities
|