skip to main
|
skip to sidebar
Oracle Study Notes by Denis
I am starting to study SQL Server as well
Friday, September 22, 2006
unix tool vmstat - show how the machine is utilzed
This article showed how to interpret the vmstat on AIX
Automated Oracle Tuning Initial Procedures - Part 2
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Like this Facebook page:
Database Administration Digest
About Me
View my complete profile
Twitter
Recent Comments
Blog Archive
►
2016
(1)
►
March
(1)
►
2015
(4)
►
April
(1)
►
March
(3)
►
2014
(11)
►
October
(1)
►
June
(2)
►
April
(3)
►
March
(2)
►
February
(1)
►
January
(2)
►
2013
(14)
►
October
(1)
►
September
(4)
►
August
(2)
►
July
(2)
►
June
(3)
►
May
(1)
►
March
(1)
►
2012
(11)
►
November
(1)
►
October
(5)
►
August
(1)
►
July
(2)
►
April
(1)
►
January
(1)
►
2011
(19)
►
December
(1)
►
November
(2)
►
October
(3)
►
September
(3)
►
May
(1)
►
April
(1)
►
February
(7)
►
January
(1)
►
2010
(22)
►
October
(1)
►
September
(1)
►
August
(2)
►
May
(3)
►
April
(7)
►
March
(5)
►
January
(3)
►
2009
(85)
►
December
(1)
►
November
(4)
►
October
(3)
►
September
(4)
►
August
(6)
►
July
(6)
►
June
(9)
►
May
(8)
►
April
(13)
►
March
(12)
►
February
(7)
►
January
(12)
►
2008
(62)
►
December
(11)
►
November
(9)
►
October
(7)
►
September
(7)
►
August
(8)
►
July
(3)
►
June
(16)
►
January
(1)
►
2007
(123)
►
December
(5)
►
November
(10)
►
October
(11)
►
September
(23)
►
August
(10)
►
July
(14)
►
June
(10)
►
May
(13)
►
April
(10)
►
March
(4)
►
February
(5)
►
January
(8)
▼
2006
(70)
►
October
(1)
▼
September
(11)
Lab: Using Statspack Under Oracle XE
unix tool vmstat - show how the machine is utilzed
Solaris OS commands
Fundamental II Ch 9 - User-Managed and RMAN-Based ...
Fundamentals II Ch 8 - Oracle Recovery Manager Ove...
Partitioned Table and Index
Fundamental I Ch9 - Managing Users, Security, and ...
Fundamental I Ch8 - Managing Tables, Indexes, and ...
Fundamentals I Ch7 - Segments and Storage Structures
An example - Snapshot too old
Row chaining and Row Migration
►
August
(29)
►
July
(22)
►
June
(7)
Label Cloud
_b_tree_bitmap_plan
(1)
01 - Performance Tunning
(2)
11g
(3)
ADG
(1)
alert log
(1)
alter table
(2)
analytic function
(3)
anti-join
(4)
archived log
(2)
ASM
(7)
ASSM
(1)
autotrace
(1)
AWK
(2)
AWR
(2)
backup
(5)
Big Data
(1)
bind variable
(4)
block corruption
(1)
boobooke
(1)
buffer hit ratio
(1)
bug
(1)
bulk collect
(4)
cancel-based recovery
(1)
case when
(3)
CBO
(9)
CentOS
(1)
clone
(5)
Cloud Computing
(1)
cluster
(1)
collection
(1)
concepts
(1)
configuration
(2)
connect by
(3)
constraint
(3)
control files
(2)
cursor
(1)
cursor variable
(2)
cursor_sharing
(2)
data dictionary
(1)
data files
(2)
data pump
(2)
data type
(1)
Database Control
(1)
database design
(1)
database link
(1)
DataGuard
(7)
DB Console
(1)
DBA command syntax
(7)
DBA General
(2)
DBA script
(2)
DBA_TAB_COL_STATISTICS
(1)
DBA_TAB_STATISTICS
(1)
DBID
(1)
DBMGRL
(1)
DBMS_JOB
(2)
DBMS_METADATA
(1)
DBMS_SCHEDULER
(1)
DBMS_SQLTUNE
(1)
DBMS_STATS
(8)
DBNEWID
(1)
DBSNMP
(1)
dbverify
(1)
deadlock
(1)
direct-path insert
(1)
duplicate row
(2)
email
(1)
errorstack dump
(1)
execution plan
(4)
exp
(2)
expdp
(1)
FGA
(1)
fine grained access
(1)
flashback
(4)
FORALL
(1)
GoldenGate
(4)
GTT
(1)
hanganalyze
(1)
I/O
(3)
imp
(2)
impdp
(1)
incarnation
(1)
index
(4)
index fast full scan
(1)
index rebuild
(3)
initialization parameter
(1)
installation
(7)
intelligent agent
(1)
interview
(4)
IOT
(1)
Java
(1)
join
(1)
Just Learned
(1)
kill
(1)
kopm$
(1)
latch
(2)
latency
(1)
library cache lock
(2)
library cache pin
(1)
listener.ora
(2)
Load Balancing
(1)
lock
(3)
logminer
(1)
MariaDB
(1)
materialized view
(4)
migration
(2)
MISC
(1)
mistake
(3)
multi-column index selectivity
(1)
MySQL
(1)
nologging
(1)
OCP
(44)
OCR
(2)
OEM
(1)
OGG
(1)
online redifinition
(1)
ORA-00600 [20022]
(1)
ORA-01555
(1)
ORA-01652
(1)
ORA-01722
(1)
ORA-14047
(1)
ORA-27101
(1)
ORA-27102
(1)
Oracle 12c
(1)
Oracle Advanced Replication
(5)
Oracle internal
(1)
Oracle Net
(1)
oradebug
(2)
package
(1)
parallel execution
(2)
parallel_index
(1)
parse
(1)
partition
(4)
patch
(3)
performance troubleshooting
(4)
performance tunning
(6)
pfile
(1)
pivot
(1)
PL/SQL
(13)
PL/SQL Package
(2)
Plan Guide
(1)
privilege
(1)
processstate dump
(1)
ps
(1)
RAC
(9)
rank
(1)
raw device
(1)
RBO
(1)
recovery
(9)
recyclebin
(1)
redo log
(2)
ref cursor
(2)
reference
(4)
regular expression
(1)
relink
(1)
relocate data files
(1)
reorganize
(1)
replication
(22)
resource manager
(1)
restore
(1)
RLS
(1)
RMAN
(22)
row_number()
(1)
ROWID
(2)
Runstat
(1)
schedular
(1)
scripts
(2)
Segment Advisor
(1)
self join
(1)
semi-join
(3)
sequence
(3)
session_cached_cursors
(1)
shared pool
(2)
SharePlex
(2)
shell scripting
(7)
snapshot too old
(1)
Solaris
(2)
sort
(2)
SPA
(1)
SQL
(24)
SQL Function
(1)
SQL Loader
(1)
SQL Plan Baseline
(3)
SQL Plus
(3)
Sql Profiles
(2)
SQL Server
(10)
sql tuning
(32)
SQL_TRACE
(2)
SQLPATH
(1)
SSH
(1)
standby
(8)
startup
(1)
statspack
(5)
storage
(1)
streams
(5)
switchover
(1)
SYSDATE
(1)
systemdump
(1)
table function
(2)
tablespace
(2)
TABLOCK
(1)
TAF
(1)
tempfile
(1)
tempoary table
(1)
temporary tablespace
(2)
test case
(5)
tip
(7)
TKPROF
(1)
TO_DATE
(1)
transaction
(1)
transaction isolation level
(1)
transaction read only
(1)
transportable tablespace
(3)
trigger
(1)
troubleshooting
(5)
unique index
(1)
unix
(8)
update
(2)
upgrade
(3)
v$lock
(1)
v$pwfile_user
(1)
v$session_longops
(1)
v$sql
(1)
v$sqlarea
(1)
VCS
(1)
video lecture
(1)
virtual box
(1)
virtual private database
(1)
VMware
(1)
wait event
(4)
My Blog List
Tanel Poder's blog: Core IT for geeks and pros
Testing the Silk Platform in 2024: Achieving 20 GiB/s I/O Throughput in a Single Cloud VM
1 week ago
Oracle Scratchpad
4096 Columns
2 weeks ago
Kerry Osborne's Oracle Blog
Speaking At Oracle CloudWorld
2 months ago
Oracle related stuff
Oracle 19c RU Release Update 19.19 nice little enhancement: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES columns populated
1 year ago
Cary Millsap
How Slow Programs Are Like Christmas: a Sales Pitch
1 year ago
Dion Cho - Oracle Performance Storyteller
Interesting case of the restriction of global hints
13 years ago
Oracle Links
Alejandro Vargas's Blog
Ask Tom
Database Journal
DBA Support
Doug's Oracle Blog
ITPUB Personal Space - Tangbufan
Jeff Hunter's DBA/Development Website
OakTable
Oracle 10gR2 Document Library
Oracle FAQ's
Random Post
No comments:
Post a Comment