Опубликовано ср, 11/20/2019 - 14:21 пользователем talifa
column "Схема" format a15;
column "Таблица" format a15;
SELECT a.owner "Схема",
a.table_name "Таблица",
b.bytes "Размер (Мб)",
TRUNC((a.blocks * 100) / b.blocks) "Занято(%)",
b.extents "Экстентов"
FROM dba_tables a,
(
SELECT owner, segment_name, SUM(bytes)/1024/1024 bytes,
SUM(blocks) blocks, COUNT(*) extents
FROM dba_extents
Опубликовано ср, 01/14/2015 - 16:36 пользователем talifa
SQL> STARTUP;
ORACLE instance started.
Total System Global Area 2.1379E+10 bytes
Fixed Size 2185160 bytes
Variable Size 1.0133E+10 bytes
Database Buffers 1.1207E+10 bytes
Redo Buffers 36151296 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01578: ORACLE data block corrupted (file # 3, block # 240)
ORA-01110: data file 3: 'G:\APP\ORACLE\ORADATA\ORUSX2\UNDOTBS01.DBF'
При попыке пересоздать
Опубликовано пт, 10/11/2013 - 14:03 пользователем talifa
Here is a script that will display the contents of the TEMP tablespace.
set pagesize 60 linesize 132 verify off
break on file_id skip 1
column file_id heading "File|Id"
column tablespace_name for a15
column object for a15
column owner for a15
column MBytes for 999,999
Опубликовано пт, 08/09/2013 - 16:13 пользователем talifa
SQL> sho parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 86700
undo_tablespace string UNDOTBS1
SQL> select sum(bytes)/1024/1024 from dba_undo_extents;
SUM(BYTES)/1024/1024
--------------------
4199.5
Опубликовано пн, 07/01/2013 - 11:16 пользователем talifa
Смена UNDO TABLESPACE Во-первых, необходимо узнать текущие UNDO параметры:
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO