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...
  • 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...
  • RMAN-20020: database incarnation not set
    I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
  • RMAN-03009 when CONTROLFILE AUTOBACKUP ON
    RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # de...
  • Cygwin 64 in windows 10 always stopped with Ctrl-C when select text with mouse
    Recently upgrade to windows 10 (64bit), and notice Cygwin 64 terminal mintty always stopped with Ctrl-C when select text with mouse, be it i...
  • 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...
  • drop a non-empty datafile
    SQL>  select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME                                                     ...
  • CATALOG RECOVERY AREA
    after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
  • config HTTPS for APEX 5.1 running on SE2
    In my case, self-signed certification is used. High level steps  are; 1. Relink SE Oracle binary in order to support TCPS. Skip this s...
  • DBMS package for tracing
    --using dbms_system execute dbms_system.set_sql_trace_in_session(9,190,TRUE); --You can also initiate a TRACE for the session that you are i...

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 学习笔记