Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Translate
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
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 ...
-
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...
-
SQL> select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME ...
-
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
-
V$log_history retention is defined by MAXLOGHISOTRY when you create the database (or recreate the controlfile) MAXLOGHISTORY Clause This...
-
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
-
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....
-
1. The dictionary view of dba_tab_col_statistics https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_2089.htm#REFRN20275 No...
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)