SYS@orcl AS SYSDBA> select distinct bytes/blocks from user_segments; BYTES/BLOCKS ------------ 8192 SYS@orcl AS SYSDBA> SYS@orcl AS SYSDBA> select block_size, tablespace_name from dba_tablespaces; BLOCK_SIZE TABLESPACE_NAME ---------- -------------- ...

SYS@orcl AS SYSDBA> alter system archive log current 2 ; alter system archive log current * ERROR at line 1: ORA-16038: log 1 sequence# 1 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/re ...

数据库不能open SYS@orcl AS SYSDBA> startup mount; ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 889195920 bytes Database Buffers 2298478592 bytes Redo Buffers 16904192 bytes Datab ...

有灾备库的主库报错 ORACLE Instance test- Archival Error. Archiver continuing. 查看METLAINK，解释如下： The Problem here is that the Primary Database is switching Logs too frequently. Using ARCH to send the archives, every time there’s a log switch the Primary has to send the Archivelog to ...

转载：http://www.xifenfei.com/1812.html 今天在一台服务器的日志文件中，发现如下信息： Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.1.0.7.0 – Production Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.1.0.7.0 – Production Ora ...

一：版本信息 操作系统版本：Red Hat Enterprise Linux Server release 6.8 (Santiago) 数据库版本：11.2.0.4.0 (RAC) 二：错误描述 今天在启动一套RAC数据库的第二个节点的时候报了如下错误： [oracle@hisdb02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 19 23 ...

https://www.kingston.com/cn/ssd/dwpd 硬盘每天写入 (DWPD) 计算让我们可以利用硬盘的 TBW 规格，根据用于指定 TBW 的 JEDEC 工作负载 [1] ，计算在保固期内（或不同的数年时段内）每天可以写入硬盘用户存储容量的次数。 硬盘每天写入 = 固态硬盘的 TBW (TB) * 1000 365 天 * 年数 * 固态硬盘用户容量 (GB) ...

ORA-01654:unable to extend index表空间不够报错 http://blog.sina.com.cn/s/blog_a57562c80101ewo9.html 2016-1-8 ORA-1652: unable to extend temp segment by 128 in tablespace解决方案 https://blog.csdn.net/stevendbaguo/article/details/50484505 案例解决：一次oracle掉电的处理过程[转] (2012-08-19 23:38:0 ...

Hugepages and Large Pages If you run a Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global Area (SGA) is greater than 8 GB, you should configure HugePages. Oracle promises more performance by doing this. A HugePages configuration means, that the linux ke ...