MiDBA

Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!

Wednesday, October 26, 2011

alter system register to speed up dynamic registration

【LISTENER】使用“alter system register;”解决动态监听注册缓慢问题 - secooler 快乐的DBA - ITPUB个人空间 - powered by X-Space
Posted by MiDBA at 1:32 PM
Labels: tips

Monday, October 24, 2011

7 Linux Grep OR, Grep AND, Grep NOT Operator Examples

7 Linux Grep OR, Grep AND, Grep NOT Operator Examples


Posted by MiDBA at 12:06 AM
Labels: Linux

db_block_checking overhead.

11g中的db_block_checking参数 | Oracle Clinic – 提供专业Oracle技术支持,性能调整及数据恢复服务

Furthermore, if there are few indexes, I believe more overhead needed.

I do have data loading performance issues in data warehouse, after enable  DB_ULTRA_SAFE = DATA_AND_INDEX


Posted by MiDBA at 12:03 AM
Labels: 11g

Sunday, October 02, 2011

more redo size generated when undo tablespace is insufficient and rollback as result

oracle新人关于redo和undo的疑惑 - Oracle专题深入讨论 - ITPUB论坛 - it168旗下专业技术社区


Posted by MiDBA at 10:28 PM
Labels: Fundamental, tips
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

MiDBA
View my complete profile

Save your time!

Google

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...
  • Oracle Character set
    转:Oracle数据库字符集问题解析 - chensrao的个人空间 - ITPUB个人空间 - powered by X-Space
  • Delphix cron
    Delphix cron used by replication job is  Quartz CronTrigger scheduler And below is its format. Format A cron expression is a string...
  • 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
  • OCM list
    Admiring ... http://www.oracle.com/technology/ocm/index.html
  • About _log_io_size
    _LOG_IO_SIZE specifies the max number of redo blocks to write out per IO request. By default the value is 1/3 of log buffer size, number in...
  • (no title)
    :: 极限 Linux ::成就DBA职业生涯
  • 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 ...
  • About Long datatype
    LONG A legacy datatype that exists for backward compatibility. It stores variable-length alphanumeric data up to 2GB in size. There are many...
  • Displaying Oracle 10046 Trace File in SQL developer
    Good know that SQL Developer can display 10046 Trace file in nice view,  as an alternative to using the TKPROF program. To open a .trc fil...

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)
      • alter system register to speed up dynamic registra...
      • 7 Linux Grep OR, Grep AND, Grep NOT Operator Examples
      • db_block_checking overhead.
      • more redo size generated when undo tablespace is i...
    • ►  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 学习笔记