Опубликовано ср, 11/20/2019 - 14:24 пользователем talifa
SET LINESIZE 300;
SET PAGES 300;
COLUMN host FORMAT A30;
Опубликовано ср, 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
Опубликовано ср, 11/20/2019 - 14:20 пользователем talifa
select substr(d.name,1,4),d.group_number, sum(d.total_mb), sum(d.free_mb)
from v$asm_diskgroup dg,v$asm_disk d
where d.group_number = dg.group_number
group by substr(d.name,1,4),d.group_number;
select dg.name, d.name, d.path, d.total_mb, d.free_mb
from v$asm_diskgroup dg,
v$asm_disk d
where d.group_number = dg.group_number
order by free_mb, 1, 2;
Опубликовано ср, 11/20/2019 - 14:17 пользователем talifa
select protection_level from v$database;
show parameter standby_file_management ;
select group#, bytes from v$standby_log;
select name, open_mode, log_mode from v$database;
select recovery_mode from v$archive_dest_status;
select flashback_on from v$database;
find . -name "alert*.log" -exec ls -l -h {} \;
select name from v$archived_log where rownum <10;
Опубликовано чт, 11/14/2019 - 10:12 пользователем talifa
Опубликовано ср, 11/13/2019 - 16:39 пользователем talifa
Опубликовано пт, 11/08/2019 - 13:50 пользователем talifa
The DBMS_PROFILER packages gets installed at the time of database creation by default. However prior to Oracle 10g release this package was not installed by default and needs to be created by running "profload.sql" located at $ORACLE_HOME/rdbms/admin folder.
Опубликовано пт, 11/08/2019 - 13:38 пользователем talifa
Please note all the below steps can be performed when the database is up and running without having any impact on database availability.
Опубликовано ср, 11/06/2019 - 09:38 пользователем talifa
Hugepages and Large Pages
Опубликовано пт, 11/01/2019 - 12:38 пользователем talifa
Настройка X11 forwarding используя ssh в Unix/Linux
Страницы
