MiDBA
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Sunday, May 25, 2008
白狐
曾经沧海难为水,除却巫山不是云。
取次花丛懒回顾,半缘修道半缘君。
Newer Post
Older Post
Home
About Me
MiDBA
View my complete profile
Save your time!
Enter your search terms
Web
midba.blogspot.com
Submit search form
Translate
Popular Posts
Ubuntu login loop
Upgraded to Ubuntu 15.10 from 15.10, resolved blank screen by playing with gdm/lightdm. Finally lightdm is my choice, which works with the v...
ORA-19806: cannot make duplex backups in recovery area
when running "backup filesperset 10 archivelog all not backed up 2 times;", encountered below error : channel ORA_DISK_1: starti...
CRS-5019:All OCR locations are on ASM disk groups [DATA], and none of these disk groups are mounted.
In my case , from ASM alert.log , actually it is due to ASM failed to start because of ORA-00600 as shown below. ORA-0060...
about RMAN compression
got two useful articles about compression. Marked here 11g Release 2 RMAN Backup Compression Oracle 11g Release 2 – RMAN compressi...
bash commands for QNAP
This is useful. find /share/Multimedia/ –name *.m4a | while read foo; do rm “$foo” ;done https://www.ripcaster.co.uk/node/772
Purging the Audit Trail
Database audit records for statement, privilege, and object auditing are stored in the table SYS.AUD$. Depending on how extensive your audit...
Shrink datafile
数据库缩小表空间一例 - 在路上...... - ITPUB个人空间
two good AWR articles
--to use AWR http://www.dbapool.com/articles/061906.html --to check AWR retention select * from DBA_HIST_WR_CONTROL; --to estimate AWR size ...
Human Error Preventives
Being a DBA or system administrator, simple ENTER may bring us into a nightmare. It is unavoidable, however what we can do is to prevent ...
ORA-00600 [qmxtrScalarIsRewritable:dft] during expdp
Hit below two errors during running exp & expdp. After increase shared pool size , the program gone. About to export specified users ......
Labels
10g
(35)
11g
(13)
12c
(9)
4.3
(1)
ACHI
(1)
AIX
(3)
Android
(1)
APEX
(8)
Architecture
(2)
ASM
(3)
audit
(1)
automation
(1)
AWR
(4)
backup and recovery
(15)
Basic
(22)
Best Practices
(3)
bind variable
(2)
BIOS
(1)
Bleeding Case
(20)
bug
(3)
career
(2)
case
(7)
centos
(4)
character set
(1)
cloud control
(11)
clusterware
(1)
Concept
(1)
cron
(1)
Cygwin
(1)
Data Guard
(13)
data management
(6)
DBConsole
(5)
dbua
(2)
delphix
(2)
Edge
(2)
Error latch
(1)
events
(1)
Exam
(1)
Experience
(2)
firmware
(1)
flashback
(3)
Fun
(1)
Fundamental
(36)
HDD
(1)
health check
(1)
Hidden Parameter
(2)
Howto
(2)
install
(1)
instantclient
(1)
ITIL
(2)
itpub
(2)
ITSM
(2)
Java
(1)
jmeter
(1)
joomla
(2)
knives
(3)
knowledge gained
(1)
labs
(5)
latch
(1)
Lazarus
(2)
life
(6)
Linux
(36)
Listener
(3)
LogMiner
(1)
management
(5)
migration
(7)
mind
(1)
mview
(3)
mysql
(3)
NewFeature
(3)
ODBC
(1)
OEM
(9)
oerr
(27)
opatch
(2)
ora600
(1)
OS
(1)
outline
(1)
Partition
(4)
performance
(5)
PGA
(2)
PL/SQL
(5)
postgresql
(1)
Price
(1)
programming
(1)
qnap
(2)
question
(2)
RAC
(6)
raw device
(3)
Recovery
(23)
RHCE
(1)
RMAN
(50)
SAP Basis
(1)
scripts
(1)
security
(7)
Server-Generated Alert
(2)
shared server
(3)
Software Engineering
(4)
sql developer
(3)
sql*plus
(2)
sqlnet
(1)
sqlserver
(13)
SSD
(2)
SSD IO
(1)
standards
(1)
statistics
(5)
statspack
(2)
Stock
(1)
storage
(2)
timesten
(2)
tips
(45)
Tools
(38)
Trace
(3)
Tuning
(17)
Ubuntu
(24)
Unix
(5)
vertica
(1)
vmware
(2)
vnc
(1)
WhatIs
(1)
XServer
(1)
zabbix
(1)
Blog Archive
►
2019
(5)
►
December
(1)
►
October
(4)
►
2018
(6)
►
January
(6)
►
2017
(31)
►
December
(2)
►
November
(1)
►
September
(1)
►
August
(12)
►
July
(1)
►
June
(6)
►
May
(3)
►
April
(2)
►
March
(2)
►
February
(1)
►
2016
(42)
►
December
(1)
►
November
(2)
►
September
(3)
►
August
(2)
►
June
(3)
►
May
(11)
►
April
(11)
►
March
(2)
►
February
(4)
►
January
(3)
►
2015
(24)
►
December
(2)
►
November
(6)
►
October
(2)
►
September
(12)
►
July
(2)
►
2014
(15)
►
August
(2)
►
July
(2)
►
June
(1)
►
May
(1)
►
April
(5)
►
March
(2)
►
February
(2)
►
2013
(81)
►
December
(1)
►
November
(1)
►
October
(8)
►
September
(4)
►
August
(3)
►
June
(3)
►
May
(1)
►
April
(16)
►
March
(19)
►
January
(25)
►
2012
(30)
►
December
(3)
►
November
(1)
►
August
(5)
►
July
(4)
►
June
(3)
►
April
(10)
►
March
(2)
►
January
(2)
►
2011
(25)
►
October
(4)
►
September
(7)
►
August
(4)
►
June
(2)
►
May
(2)
►
April
(6)
►
2010
(72)
►
December
(1)
►
November
(6)
►
October
(2)
►
July
(26)
►
June
(6)
►
May
(2)
►
April
(12)
►
March
(7)
►
January
(10)
►
2009
(43)
►
December
(4)
►
November
(3)
►
September
(2)
►
August
(8)
►
July
(6)
►
May
(4)
►
April
(3)
►
February
(1)
►
January
(12)
▼
2008
(93)
►
October
(2)
►
September
(11)
►
August
(13)
►
June
(5)
▼
May
(30)
Merge Join caused Cartesian Product
structure of redo.log is exactly the same as its a...
DBMS package for tracing
白狐
the after images
redo log size
Determining the Bad Source of statistics
About Histogram
Abandom Notepad++
block's life of Full Table Scan
remove external procedures
Database checkpoint
rows returned order
object's precedence
Ojbect Namespace
reconfig DB Console HTTP port number
example of index suppressed
ORA-16014: log 2 sequence# 12 not archived, no ava...
Useful v$acive_session_history
Create DB Control
对ORACLE DBA 这份职业的看法
Effect of creating missing index
large pool for shared server + sga_target
Check current sql execution plan and historical plan
Import statistics failed due to object out of synch
sga_target and its compoents
RHEL/CentOS5 suspend
centos 5 can't suspend
VMware-player-2.0.2-59824.exe caused system keepin...
How to check datatype length
►
April
(32)
►
2007
(89)
►
December
(3)
►
November
(3)
►
October
(3)
►
September
(5)
►
August
(3)
►
July
(21)
►
June
(36)
►
May
(15)
►
2006
(6)
►
November
(1)
►
October
(4)
►
September
(1)
►
2005
(4)
►
October
(4)
Structured Data
Oracle Database Real-World Performance & Scalability Blog
vongtes 学习笔记