t_ault_2_structures_affect_insta
Oracle Wait Event Tuning
Easy Oracle SQL
You're Fired
Easy Oracle PL/SQL Programming
Easy HTML-DB
Easy Oracle PHP
Oracle,
Set the Environment
Oracle, Using CTAS with
an Index Hint
Oracle, Move the Trace
File
Oracle, Change
default file permissions with umask
Oracle, Standard
command history
Oracle,
Re-sequencing table rows to reduce disk I/O
Oracle, Using CTAS
with the order by Clause
Oracle, Change file
owners in UNIX
Oracle, Get
the free space limits
A
Real-Time Check for Oracle Problems
Oracle, Web
Server Alert Report
Oracle,
Managing the UNIX environment for the oracle user
Reporting
on the Oracle Disk Architecture
Oracle, Reducing
disk I/O in UNIX
Oracle Performance and disk I/O
Oracle, Get the
e-mail lists, large enviroments
Oracle, Get
the UNIX home directory
Oracle, Copy
tnsnames.ora to all UNIX Servers
Oracle,
Mark the dialect differences for file space commands
Oracle,
Monitoring UNIX disk I/O,
Oracle, Useful UNIX
Aliases for Oracle
Oracle, Get
the fully-qualified UNIX path names for directories
Oracle, Two
Alternatives for Using CTAS
Oracle,
Cleanup old holding files
Oracle,
Preliminary checking and set-up
Large
Blocks and Oracle Indexes
Oracle,
Terminate the script if the database is down
Oracle,
Defining the STATSPACK table
Oracle,
Extending STATSPACK for Disk I/O Data
Oracle9i and
multiple block sizes
Linux, Get Process Status,
kdeinit, CMD, ps
Linux, Paging and
Swapping Devices, swapon, swap disk, cat
Linux, Viewing Kernel
Parameters, msgmax, sysctl
Linux, Interactive
Statistics Using TOP Utility, display, system, process
Linux,
Displaying Multi-Processor Statistics, mpstat, interval, value
Linux, Displaying
Virtual Memory Statistics, vmstat, report, interval
Using netstat for Linux, ICMP, DGRAM
Linux, Display your Linux File System , eide, df, mount
Linux, Kill Process,
pgrep, signal, terminate
Linux, Switch to a
Different User, su command, root logon
Linux, Create a
complex alias shortcut, command
Getting Help with Linux,
man, syntax, pcpu
Linux, CPU Related
Information, processor, bogomips, fpu
Linux, Display Number
Processors in Server, grep, cpuinfo, wc
Linux, Displaying total
memory on Linux system, meminfo, buffers, ram
Linux, Top Memory and CPU
users, ps, gdmgreeter, aux
Linux,
Administration Files, root user powerful administrative
Linux Directory
Management, program, tree, structure
Linux, Directory Structure,
GUI, module, grub
Linux, Create empty
file, touch command, timestamp
Oracle physical I/O Myths,
exposed
Allocating
Oracle Objects Multiple RAM Data Buffers
Oracle,
Installing STATSPACK, captured statistics
Oracle, Insert,
Delete and Partitioning Operations
Oracle, Dangerous
Older technology
shift Oracle
bottlenecks, cheap solid state disks
Oracle, SSD Average
Transaction Time
Oracle, Locating Slow Disk
ASH, snapshot, wait events
Oracle, Problem
Super-large Disks
Oracle Logical I/O Slow
Chasm between
bandwidth, performance
Database
Characteristics files moved SSD
Oracle RAC Cache
Fusion, I/O Bandwidth
Oracle, Using AWRRPT
Reports, HTML based versions
Oracle, ATA
Configurations, SSD and SATA
Finding
Baselines, Oracle9i STATSPACK, Oracle10g AWR information
Oracle
Bandwidth Saturation, sub-optimal disk configuration
Oracle,
Removing Bandwidth Saturation, SSD
SQL Server, Data Lifecycle
Management, DML, ILM, Layer
SQL Server,
Modeling Peak Efficiency, Availability, Speed
SQL Server,
Object Resource Availability, blocking lock tree
SQL Server,
Data - Code Positioning, object definitions
SQL Server,
Access Path Effectiveness, efficiency
SQL Server, Design
Success, efficiency, performance model
SQL Server,
The Impact of Availability, performance model
SQL Server, Impact of
Speed, peak efficiency risk
SQL Server,
Laying Strong Foundation, database tuning guideline
SQL Server, Physical
Database Design Overlooked, modelers RDBMS RAD
SQL Server, Number
One Performance Myth, coding codes
SQL
Server, Logical - Physical Data Management
SQL Server,
Addressing Problems Performance Testing, OLTP DML
SQL Server,
Performance Testing Solutions, database unbreakable
SQL Server,
Link Change Control Performance, Database Synchronization
SQL Server,
Establishing Smart Monitoring Plan, statistical data
SQL Server,
Cursory Monitoring, DBCC dynamic management
SQL Server, 24 x
7 Monitoring, Ad-hoc enterprise database monitor
SQL Server,
Build versus Buy, cursory analytic monitoring, SQL
SQL Server,
Ratio Analysis, performance counters, efficiency
SQL Server,
Diagnosing Storage, System Problems
SQL Server, Proactive
Action, PLM
SQL Server,
Bottleneck Analysis, wait-based
SQL Server,
Storage Bottlenecks, database space, sp_spaceused
SQL Server,
Quick SQL Server Storage Primer, data_spaces filegroups
SQL Server, Physical
I/O Crisis, disk configuration iops
SQL Server,
Monitoring SQL Server, Bottleneck, Workload, Ratio, Analysis
SQL Server, Error Log
Analysis, bottlenecks, counts
SQL Server,
Deadlocks, application design issues
SQL Server,
Examining Session Waits, diagnostic metrics
SQL Server,
Server Workload Analysis, SQL Server health
SQL Server,
Examining CPU Activity, T-SQL code
SQL Server,
Database Workload Analysis, dbactivity_overview
SQL Server,
Getting Database I/O Details, iostall fn_virtualfilestats
SQL Server,
Forecasting, Monitoring, Tuning
SQL Server,
Reducing Backup Recovery Impact
SQL Server, Proper
Database and Log File Placement
SQL Server, Bad
SQL, various database monitors
SQL Server, System
Waste, database-driven applications
SQL Server, Global SQL
Metrics, auto-param sp_recompile
SQL Server, SQL
Statement Analysis, stored procedures
SQL Server,
Creating Traces, up_wl_trace_sql SQL Agent
SQL Server,
Viewing Trace Information, fn_trace_gettable function profiler
SQL
Server, Ratio-based Analysis, performance
SQL Server,
Self-Managing Databases
SQL Server,
Accurate Ratio Analysis Techniques, cntr_value
SQL Server, Memory
Ratios, buffer plan cache up_memory_status
SQL Server,
Buffer Cache Performance, hit ratio page_life query
SQL Server,
Self-Managing Meaning, automatic problem diagnosis
SQL Server,
Self-Managing, require trained DBA
SQL
Server, Real Benefits Self-Managing Databases
SQL Server, Using
Filegroups, transaction log files
SQL Server,
Optimization Toolbox, Query Analyzer tool
SQL Server,
Obtain Baseline, performance query stored code
SQL Server, Table Index
Scans, partitioning
SQL Server,
Indexes Fillfactor, settings DBCC page_splits
SQL Server, Unused
Indexes, waste storage Tuning Wizard
SQL Server,
Physical Design Revisions
SQL Server,
Clustered Indexes, table purge fragmented
SQL Server,
Pinning Tables, DBCC PINTABLE UNPINTABLE
SQL Server,
Rewrite Benchmark, UNION query performance
SQL Server,
Object-Based Solutions, Denormalizing subqueries
SQL
Server, Intelligent Indexing, fillfactor tables clustered
SQL Server,
Nasty Join Operations, Cartesian product
SQL Server,
Storage Structure Planning, RAID technology
SQL Server, Index
Database Tuning Wizard, Advisor
SQL Server, ODS API,
functions SRV_PROC pointer
SQL Server, Default
values, SP XP
SQL
Server, Dependency Walker, Input Output parameters
SQL
Server, Unicode Compilation, Win32 functions
SQL Server,
Unicode Character Set, Consortium unified
SQL Server, Using
Query Analyzer, debug SP, testing TSQL
SQL Server,
ASCII Character Set, American Standard Code
SQL Server, Handling
different data types, boolean
SQL
Server, Execution Extended Stored Procedures, SP, UDF
SQL Server,
Parameter Management, srv_parname XP
SQL Server
2005, extended stored procedures
SQL Server,
Precompiled headers, pch stdafx
SQL Server,
Registering XP from Enterprise Manager, GUI
SQL
Server, Security / Connection Management, XP_ODBC
SQL Server, Named
parameters, ODS XP
SQL
Server, Exporting function, standard boilerplate code
SQL Server,
Implementation, framework XP_NETSEND code
SQL
Server, Applications XP_SMTPSENDMAIL, table
SQL
Server, Implement encapsulation C++ classes
SQL Server, Choice
Mail Library, SMTP MAPI XP
SQL Server, Implementation
Details, ADO EOF MSDN
SQL Server,
XP_NET_SEND Jobs, Administrator
SQL Server, Code
Highlights, parameters CDO macros CC
SQL Server,
Using framework, Appwizard SDK MFC ATL DLL
SQL
Server, Provide automatic conversion parameter data types
SQL
Server, Encapsulate verification setup parameters
SQL Server, Testing
Code, Script EXEC
SQL Server, Track
Memory Leaks, runtime heap allocations
SQL Server, Using CDO
Windows 2000, DLL JScript
SQL Server,
XP_NET_ADDNAME, NetBIOS UNICODE SDK
SQL Server,
Asymmetric Encryption / Decryption, RSA DSA
SQL Server,
XP_HTMLENCODE2, EscapeXML ATL Unicode framework
SQL Server,
XP_CRYPTOAPI Usage, TSQL HMAC SDK
SQL
Server, Symmetric Encryption / Decryption, Stream Ciphers CBC
SQL Server,
Applications XP_CRYPTOAPI, UDF functions
SQL Server,
MS CryptoAPI based Public Key Implementations
SQL Server,
Applications XP_HTMLENCODE, varchar nvarchar
SQL Server, Helix
Stream Cipher, CryptoAPI MAC
SQL Server,
CRC32 Checksum Algorithm, CRC dwCRC
SQL Server, MS
CryptoAPI Hash Algorithm Implementations CSP
SQL Server,
XP_PLAYSOUNDMEMORY, TSQL PlaySound XP_NOTIFY
SQL Server, Hashing,
hash value data collision - resistance
SQL Server,
XP_PLAYSOUNDFILE, XP_STOPSOUND, XP_PLAYSOUNDALIAS
SQL Server,
Blowfish - TEA Block Cipher, CBlowFish ECB mode
SQL Server, MS CryptoAPI based Signing / Verification
Implementations
SQL Server, MD4,
MD5, SHA, Hash Algorithm
SQL Server,
Referential Integrity, DRI Declarative
SQL Server,
Aggregate functions, SUM alphanumeric numeric
SQL Server, Data types data structure use, Timestamp
Uniqueidentifier
SQL Server,
Binary, Varbinary data type fixed variable
SQL
Server, Constraints, CHECK Column-level integrity
SQL Server,
User-Defined Data Types, UDT nullability NULL
SQL Server, Char
stores fixed length ASCII data
SQL Server,
Derived table, subqueries JOIN WHERE clause
SQL Server, Joins,
ANSI SQL-92 syntax inner outer cross
SQL Server,
Data Integrity, mechanism Entity Domain Referential
SQL Server,
Variant data type, reference SP PROPERTY
SQL Server, Outer
right, join clause rows tables
SQL Server, Real ,
floating point numeric valid values mantissa
SQL Server,
Decimal numeric, precision scale
SQL Server,
Temporary tables, tempdb output rows
SQL Server, With
Check Option, CREATE VIEW pubs column
SQL Server,
Data types code use, Cursor Table statements
SQL Server,
Nchar stores fixed length Unicode data DATALENGTH
SQL
Server, UNIQUE, constraint CLUSTERED order_id
SQL Server, Foreign
Key, column primary tables
SQL Server, About NULL
TSQL, SET option ANSI_NULLS
SQL Server, Inner
join, equi-join ON clause rowset
SQL Server, Self
join, filter tables aliases inner
SQL Server, debug
toolbar, ESP Stack EBP base EIP Pointer
SQL
Server, Clustered Non-clustered Indexes, order data
SQL Server,
Ideas prevent injection, attacks single quote
SQL
Server, Enforcing referential integrity, cascade DRI migration
SQL Server,
prevent script injection, buffer overflow exploit
SQL
Server, Referential Integrity triggers, cascade DRI
SQL Server,
Pages Extents, storage Mixed Data Heaps
SQL Server,
Avoiding buffer overflows, security coding strlen
SQL Server,
Security tools, NGSS Software benign hacking
SQL
Server, Web application script injection, ASP PHP versions
SQL
Server, Port security, IANA Server Network Utility
SQL
Server, Enforcing referential integrity, cascade DRI migration
SQL Server,
Script injection MSDOS commands, xp_cmdshell
SQL Server,
injection dynamic, SP validate_user filtered login password
SQL
Server, Security Considerations, filtering disrupt code multiline
SQL Server,
Cross-site scripting - XSS, Javascript VBScript webmail
SQL Server,
Collation, LCID ID ASCII CS AS BIN Pref CI AI
SQL Server
Injection, hacking technique Query Analyzer
Oracle,
fixed-size areas pinned objects, memory packages
Oracle, Tuning -
Buffer Cache, blocksize recycle pool areas
Oracle, Use RECYCLE
Pool, ALTER LOB database buffer
Oracle, Memory
Tuning, Database internals performance
Oracle, Use KEEP Pool,
LRU database buffer initialization parameter
Oracle,
Installation Use STATSPACK, tablespace PERFSTAT
Oracle, Shared Pool
Summary, usage reused sizing
Oracle, Monitoring
Library - Data Dictionary Caches
Oracle, Disk I/O -
Shared Pool, Pcode versions DTP
Oracle, Shared Pool, MTS,
related memory areas monitor
Oracle, Large Pool
Sizing, parallel query option processes
oerr on Windows
AWR tuning book:
Oracle 64-bit servers
Oracle Server
Consolidation
Oracle Server Metrics
and SQL Execution
Oracle CPU & I/O costing
Oracle Network Tuning
Oracle SDU and TDU parameters
Oracle database caching
Oracle RAID
Oracle and Direct I/O
Oracle Blocksize and Disk
I/O
Oracle Index Blocksize
Oracle Multiple
Blocksizes
Oracle Improving
SQL execution plans
db_block_size with multiple
block sizes
Oracle: Reducing disk I/O with
SSD
Oracle file i/o scripts
Oracle Automating KEEP
Pool Assignment
Large Blocks and Oracle
Instance Caching
Oracle 10g Block Space Usage
Oracle Tuning
from Performance Benchmarks
Oracle SQL Tuning Goals
Oracle Sample Size
with dbms_stats
