MiDBA
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Wednesday, August 23, 2017
something new related AWR setting in 12c multitenant DB
12c Consolidated AWR report with PDBs
Enabling Automatic AWR Snapshots on PDB
below is not unique to 12c, but advanced ...
To see AWR settings query DBA_HIST_WR_CONTROL
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
solutions for handling RMAN-08138
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
reduce AWR retention but hit ORA-13541
Need to reduce AWR retention due to no disk space in this development database. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 ...
wrong agent token when start cloud control agent
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
Zabbix 3.4 for Postgresql 9.6 installation in Centos 7
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty....
spare6 in sys.use$
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
convert low_value and high_value for date datatype in column's index statistics
1. The dictionary view of dba_tab_col_statistics https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_2089.htm#REFRN20275 No...
Re-Configure data guard broker after re-create physical standby database
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
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...
OUI abort during 11g Release 2 installation
SEVERE: [FATAL] An internal error occurred within cluster verification framework Unable to get the current group. The relevant platform is H...
backup related views
【管理篇备份恢复】备份恢复相关视图和参数(一) - 与青春有关的日子 - ITPUB个人空间 - powered by X-Space
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)
some links for APEX 5.0 upgrade to 5.1
something new related AWR setting in 12c multitena...
Create stacked bar in APEX 5.1
install sql server 2017 RC2 in CentOS 7.3
Install sqlcmd and bcp the SQL Server command-line...
30 Things to Do After Minimal RHEL/CentOS 7 Instal...
auto dbstart stop in centos 7 (systemd)
SQL server audit related links
SQL commands for getting bind variable value
Using bind variables in SQL*Plus
amazing server side result cache (2) - benchmark
amazing server side result cache (1)
►
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)
►
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 学习笔记