Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 ошибка при удалении таблицы  [new]
login-password
Member

Откуда:
Сообщений: 1
не подскажите почему при попытке удалении таблицы командой
drop table digest.test004 cascade CONSTRAINTS

выдается ошибка

ERROR at line 1:
ORA-03113: end-of-file on communication channel
2 мар 06, 18:15    [2410485]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
softwarer
Member

Откуда: 127.0.0.1
Сообщений: 64018
Блог
Потому что произошла ошибка :)

Обычно в таких случаях следует посмотреть в alert.log, увидеть там до боли знакомую ORA-600 и отправиться на металинк искать лекарство.
2 мар 06, 18:33    [2410557]     Ответить | Цитировать Сообщить модератору
Между сообщениями интервал более 1 года.
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Такая же беда. Делаю drop table....
а получаю ERROR at line 1:
ORA-03113: end-of-file on communication channel
и сервис БД останавливается (Win2000)

в bdump/alert_bd.log ни одной ошибки.

Что может быть? Как удалить табличку?
26 май 10, 14:54    [8837897]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
pravednik
Member

Откуда: Jacksonville, FL
Сообщений: 16268
беда.,

автор
в bdump/alert_bd.log ни одной ошибки.

"не верю!!!"(с) Станиславский
26 май 10, 15:00    [8837961]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
+ alert
Completed: alter database open
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 07:34:42 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 07:34:42 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 07:34:45 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 07:34:45 2010
alter database mount exclusive
Wed May 26 07:34:50 2010
Successful mount of redo thread 1, with mount id 3504926421
Wed May 26 07:34:50 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 07:34:50 2010
alter database open
Wed May 26 07:34:50 2010
Beginning crash recovery of 1 threads
Wed May 26 07:34:50 2010
Started redo scan
Wed May 26 07:34:51 2010
Completed redo scan
106 redo blocks read, 51 data blocks need recovery
Wed May 26 07:34:51 2010
Started recovery at
Thread 1: logseq 132, block 3, scn 0.0
Wed May 26 07:34:51 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 132 Reading mem 0
Mem# 0 errs 0: Y:\ORACLE\STELIS\REDO03.LOG
Wed May 26 07:34:51 2010
Completed redo application
Wed May 26 07:34:51 2010
Ended recovery at
Thread 1: logseq 132, block 109, scn 0.48088574
51 data blocks read, 51 data blocks written, 106 redo blocks read
Crash recovery completed successfully
Wed May 26 07:34:52 2010
Thread 1 advanced to log sequence 133
Thread 1 opened at log sequence 133
Current log# 1 seq# 133 mem# 0: Y:\ORACLE\STELIS\REDO01.LOG
Successful open of redo thread 1
Wed May 26 07:34:53 2010
SMON: enabling cache recovery
Wed May 26 07:34:54 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 07:34:54 2010
SMON: enabling tx recovery
Wed May 26 07:34:54 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 10:09:50 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 10:09:50 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 10:09:53 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 10:09:53 2010
alter database mount exclusive
Wed May 26 10:09:58 2010
Successful mount of redo thread 1, with mount id 3504919857
Wed May 26 10:09:58 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 10:09:58 2010
alter database open
Wed May 26 10:09:58 2010
Beginning crash recovery of 1 threads
Wed May 26 10:09:58 2010
Started redo scan
Wed May 26 10:09:59 2010
Completed redo scan
1282 redo blocks read, 269 data blocks need recovery
Wed May 26 10:09:59 2010
Started recovery at
Thread 1: logseq 133, block 3586, scn 0.0
Wed May 26 10:09:59 2010
Recovery of Online Redo Log: Thread 1 Group 1 Seq 133 Reading mem 0
Mem# 0 errs 0: Y:\ORACLE\STELIS\REDO01.LOG
Wed May 26 10:09:59 2010
Completed redo application
Wed May 26 10:10:00 2010
Ended recovery at
Thread 1: logseq 133, block 4868, scn 0.48114563
269 data blocks read, 269 data blocks written, 1282 redo blocks read
Crash recovery completed successfully
Wed May 26 10:10:01 2010
Thread 1 advanced to log sequence 134
Thread 1 opened at log sequence 134
Current log# 2 seq# 134 mem# 0: Y:\ORACLE\STELIS\REDO02.LOG
Successful open of redo thread 1
Wed May 26 10:10:02 2010
SMON: enabling cache recovery
Wed May 26 10:10:03 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 10:10:03 2010
SMON: enabling tx recovery
Wed May 26 10:10:03 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 10:15:13 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 10:15:13 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 10:15:15 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 10:15:16 2010
alter database mount exclusive
Wed May 26 10:15:20 2010
Successful mount of redo thread 1, with mount id 3504917364
Wed May 26 10:15:20 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 10:15:20 2010
alter database open
Wed May 26 10:15:21 2010
Beginning crash recovery of 1 threads
Wed May 26 10:15:21 2010
Started redo scan
Wed May 26 10:15:22 2010
Completed redo scan
127 redo blocks read, 57 data blocks need recovery
Wed May 26 10:15:22 2010
Started recovery at
Thread 1: logseq 134, block 3, scn 0.0
Wed May 26 10:15:22 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 134 Reading mem 0
Mem# 0 errs 0: Y:\ORACLE\STELIS\REDO02.LOG
Wed May 26 10:15:22 2010
Completed redo application
Wed May 26 10:15:22 2010
Ended recovery at
Thread 1: logseq 134, block 130, scn 0.48134812
57 data blocks read, 57 data blocks written, 127 redo blocks read
Crash recovery completed successfully
Wed May 26 10:15:23 2010
Thread 1 advanced to log sequence 135
Thread 1 opened at log sequence 135
Current log# 3 seq# 135 mem# 0: Y:\ORACLE\STELIS\REDO03.LOG
Successful open of redo thread 1
Wed May 26 10:15:24 2010
SMON: enabling cache recovery
Wed May 26 10:15:24 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 10:15:24 2010
SMON: enabling tx recovery
Wed May 26 10:15:24 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 10:25:38 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 10:25:38 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 10:25:40 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 10:25:41 2010
alter database mount exclusive
Wed May 26 10:25:45 2010
Successful mount of redo thread 1, with mount id 3504978917
Wed May 26 10:25:45 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 10:25:45 2010
alter database open
Wed May 26 10:25:45 2010
Beginning crash recovery of 1 threads
Wed May 26 10:25:46 2010
Started redo scan
Wed May 26 10:25:46 2010
Completed redo scan
237 redo blocks read, 55 data blocks need recovery
Wed May 26 10:25:46 2010
Started recovery at
Thread 1: logseq 135, block 3, scn 0.0
Wed May 26 10:25:46 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 135 Reading mem 0
Mem# 0 errs 0: Y:\ORACLE\STELIS\REDO03.LOG
Wed May 26 10:25:46 2010
Completed redo application
Wed May 26 10:25:47 2010
Ended recovery at
Thread 1: logseq 135, block 240, scn 0.48155290
55 data blocks read, 55 data blocks written, 237 redo blocks read
Crash recovery completed successfully
Wed May 26 10:25:48 2010
Thread 1 advanced to log sequence 136
Thread 1 opened at log sequence 136
Current log# 1 seq# 136 mem# 0: Y:\ORACLE\STELIS\REDO01.LOG
Successful open of redo thread 1
Wed May 26 10:25:48 2010
SMON: enabling cache recovery
Wed May 26 10:25:49 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 10:25:49 2010
SMON: enabling tx recovery
Wed May 26 10:25:49 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 10:28:45 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 10:28:45 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 10:28:47 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 10:28:48 2010
alter database mount exclusive
Wed May 26 10:28:52 2010
Successful mount of redo thread 1, with mount id 3504972704
Wed May 26 10:28:52 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 10:28:52 2010
alter database open
Wed May 26 10:28:52 2010
Beginning crash recovery of 1 threads
Wed May 26 10:28:53 2010
Started redo scan
Wed May 26 10:28:53 2010
Completed redo scan
109 redo blocks read, 51 data blocks need recovery
Wed May 26 10:28:53 2010
Started recovery at
Thread 1: logseq 136, block 3, scn 0.0
Wed May 26 10:28:53 2010
Recovery of Online Redo Log: Thread 1 Group 1 Seq 136 Reading mem 0
Mem# 0 errs 0: Y:\ORACLE\STELIS\REDO01.LOG
Wed May 26 10:28:53 2010
Completed redo application
Wed May 26 10:28:53 2010
Ended recovery at
Thread 1: logseq 136, block 112, scn 0.48175425
51 data blocks read, 51 data blocks written, 109 redo blocks read
Crash recovery completed successfully
Wed May 26 10:28:54 2010
Thread 1 advanced to log sequence 137
Thread 1 opened at log sequence 137
Current log# 2 seq# 137 mem# 0: Y:\ORACLE\STELIS\REDO02.LOG
Successful open of redo thread 1
Wed May 26 10:28:55 2010
SMON: enabling cache recovery
Wed May 26 10:28:56 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 10:28:56 2010
SMON: enabling tx recovery
Wed May 26 10:28:56 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Wed May 26 11:05:45 2010
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 8
All dispatchers and shared servers shutdown
Wed May 26 11:05:50 2010
ALTER DATABASE CLOSE NORMAL
Wed May 26 11:05:50 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed May 26 11:05:50 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 137
Successful close of redo thread 1
Wed May 26 11:05:51 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed May 26 11:05:51 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 26 11:06:10 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:06:12 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:09:01 2010
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 26 11:09:04 2010
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 11:09:04 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 11:09:04 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:09:07 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:09:08 2010
alter database mount exclusive
Wed May 26 11:09:12 2010
Successful mount of redo thread 1, with mount id 3504936980
Wed May 26 11:09:12 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 11:09:12 2010
alter database open
Wed May 26 11:09:13 2010
Thread 1 opened at log sequence 137
Current log# 2 seq# 137 mem# 0: Y:\ORACLE\STELIS\REDO02.LOG
Successful open of redo thread 1
Wed May 26 11:09:13 2010
SMON: enabling cache recovery
Wed May 26 11:09:14 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 11:09:14 2010
SMON: enabling tx recovery
Wed May 26 11:09:14 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed May 26 11:09:52 2010
ALTER DATABASE CLOSE NORMAL
Wed May 26 11:09:52 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed May 26 11:09:52 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 137
Successful close of redo thread 1
Wed May 26 11:09:52 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed May 26 11:09:52 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 26 11:10:11 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:10:14 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:14:47 2010
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 26 11:14:50 2010
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 11:14:51 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 11:14:51 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:14:54 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:14:54 2010
alter database mount exclusive
Wed May 26 11:14:59 2010
Successful mount of redo thread 1, with mount id 3504965742
Wed May 26 11:14:59 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 11:14:59 2010
alter database open
Wed May 26 11:14:59 2010
Thread 1 opened at log sequence 137
Current log# 2 seq# 137 mem# 0: Y:\ORACLE\STELIS\REDO02.LOG
Successful open of redo thread 1
Wed May 26 11:14:59 2010
SMON: enabling cache recovery
Wed May 26 11:15:00 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 11:15:00 2010
SMON: enabling tx recovery
Wed May 26 11:15:00 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed May 26 11:15:23 2010
ALTER DATABASE CLOSE NORMAL
Wed May 26 11:15:23 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed May 26 11:15:23 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 137
Successful close of redo thread 1
Wed May 26 11:15:23 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed May 26 11:15:23 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 26 11:15:37 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:15:39 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:15:40 2010
ALTER DATABASE MOUNT
Wed May 26 11:15:44 2010
Successful mount of redo thread 1, with mount id 3504957852
Wed May 26 11:15:44 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed May 26 11:15:45 2010
ALTER DATABASE OPEN MIGRATE
Wed May 26 11:15:45 2010
Thread 1 opened at log sequence 137
Current log# 2 seq# 137 mem# 0: Y:\ORACLE\STELIS\REDO02.LOG
Successful open of redo thread 1
Wed May 26 11:15:45 2010
SMON: enabling cache recovery
Wed May 26 11:15:46 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 11:15:46 2010
SMON: enabling tx recovery
Wed May 26 11:15:46 2010
Database Characterset is CL8MSWIN1251
Wed May 26 11:15:46 2010
ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY;
Wed May 26 11:15:46 2010
ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY;
Wed May 26 11:15:46 2010
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN MIGRATE
Wed May 26 11:23:29 2010
Thread 1 advanced to log sequence 138
Current log# 3 seq# 138 mem# 0: Y:\ORACLE\STELIS\REDO03.LOG
Wed May 26 11:28:39 2010
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed May 26 11:28:43 2010
ALTER DATABASE CLOSE NORMAL
Wed May 26 11:28:43 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed May 26 11:28:44 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 138
Successful close of redo thread 1
Wed May 26 11:28:44 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed May 26 11:28:44 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed May 26 11:28:54 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:28:56 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:28:57 2010
ALTER DATABASE MOUNT
Wed May 26 11:29:01 2010
Successful mount of redo thread 1, with mount id 3504978617
Wed May 26 11:29:01 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed May 26 11:29:01 2010
ALTER DATABASE OPEN
Wed May 26 11:29:02 2010
Thread 1 opened at log sequence 138
Current log# 3 seq# 138 mem# 0: Y:\ORACLE\STELIS\REDO03.LOG
Successful open of redo thread 1
Wed May 26 11:29:02 2010
SMON: enabling cache recovery
Wed May 26 11:29:03 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 11:29:03 2010
SMON: enabling tx recovery
Wed May 26 11:29:03 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Dump file c:\oracle\admin\stelis\bdump\alert_stelis.log
Wed May 26 11:29:54 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed May 26 11:29:54 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
nls_language = RUSSIAN
control_files = Y:\Oracle\STELIS\control01.ctl, Z:\Oracle\STELIS\control02.ctl, Y:\Oracle\STELIS\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = STELIS
dispatchers = (PROTOCOL=TCP) (SERVICE=STELISXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\STELIS\bdump
user_dump_dest = C:\oracle\admin\STELIS\udump
core_dump_dest = C:\oracle\admin\STELIS\cdump
sort_area_size = 524288
db_name = STELIS
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Wed May 26 11:29:56 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 26 11:29:57 2010
alter database mount exclusive
Wed May 26 11:30:01 2010
Successful mount of redo thread 1, with mount id 3504932085
Wed May 26 11:30:01 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 26 11:30:01 2010
alter database open
Wed May 26 11:30:01 2010
Beginning crash recovery of 1 threads
Wed May 26 11:30:02 2010
Started redo scan
Wed May 26 11:30:02 2010
Completed redo scan
86 redo blocks read, 46 data blocks need recovery
Wed May 26 11:30:02 2010
Started recovery at
Thread 1: logseq 138, block 170212, scn 0.0
Wed May 26 11:30:02 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 138 Reading mem 0
Mem# 0 errs 0: Y:\ORACLE\STELIS\REDO03.LOG
Wed May 26 11:30:02 2010
Completed redo application
Wed May 26 11:30:02 2010
Ended recovery at
Thread 1: logseq 138, block 170298, scn 0.48251526
46 data blocks read, 46 data blocks written, 86 redo blocks read
Crash recovery completed successfully
Wed May 26 11:30:03 2010
Thread 1 advanced to log sequence 139
Thread 1 opened at log sequence 139
Current log# 1 seq# 139 mem# 0: Y:\ORACLE\STELIS\REDO01.LOG
Successful open of redo thread 1
Wed May 26 11:30:04 2010
SMON: enabling cache recovery
Wed May 26 11:30:05 2010
Successfully onlined Undo Tablespace 1.
Wed May 26 11:30:05 2010
SMON: enabling tx recovery
Wed May 26 11:30:05 2010
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open

Ни одной ORA-
26 май 10, 15:05    [8838042]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Пробую удалить constraint этой таблицы, получаю:
Error:	ORA-22875
Text:	cannot drop primary key of an object table whose object identifier is primary key based
26 май 10, 15:22    [8838295]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Так таблица создавалась:
CREATE TABLE "USER"."HIERARCHY_TAB" OF "USER"."HIERARCHY" 
 ( CONSTRAINT "HIERARCHY_PK" PRIMARY KEY ("PK") DISABLE)
  OBJECT IDENTIFIER IS PRIMARY KEY 
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "DATA" ;

create or replace
TYPE "HIERARCHY" AS OBJECT
(
    PK NUMBER,
    NAME VARCHAR2(30)
);
Может это на идею натолкнет, как удалить ее теперь.
26 май 10, 15:32    [8838441]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
Торопунька
Member

Откуда: Москва
Сообщений: 300
А с датафайлом проблем не было? Просто так крашинги не случаются.
26 май 10, 15:36    [8838508]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Торопунька
А с датафайлом проблем не было? Просто так крашинги не случаются.

Нет. Проблем не было.
26 май 10, 15:38    [8838542]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Может можно какой-нибудь трэйсинг включить детальный и посмотреть потом где-нибудь отчет, что происходило, когда drop делался. Я просто не знаю тонкостей, мне бы табличку удалить(
26 май 10, 15:42    [8838603]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
SQL*Plus
Member

Откуда: Россия, Москва
Сообщений: 8136
Выполните
SELECT * FROM v$version;
и покажите результат.
26 май 10, 15:44    [8838636]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Может поможет:
Win2000
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE    9.2.0.6.0       Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
26 май 10, 15:45    [8838649]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
Торопунька
Member

Откуда: Москва
Сообщений: 300
беда.
Может можно какой-нибудь трэйсинг включить детальный и посмотреть потом где-нибудь отчет, что происходило, когда drop делался. Я просто не знаю тонкостей, мне бы табличку удалить(

user_dump_dest = C:\oracle\admin\STELIS\udump
Сюда глянуть
26 май 10, 15:48    [8838683]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Торопунька
беда.
Может можно какой-нибудь трэйсинг включить детальный и посмотреть потом где-нибудь отчет, что происходило, когда drop делался. Я просто не знаю тонкостей, мне бы табличку удалить(

user_dump_dest = C:\oracle\admin\STELIS\udump
Сюда глянуть

+ Там все файлы одинакового содержания

Dump file c:\oracle\admin\stelis\udump\stelis_ora_4448.trc
Wed May 26 12:18:30 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: stelis

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 4448, image: ORACLE.EXE


*** SESSION ID:(9.3) 2010-05-26 12:18:30.742
Thread checkpoint rba:0x00008d.00000002.0010 scn:0x0000.02e0e412
On-disk rba:0x00008d.0000073f.0000 scn:0x0000.02e0e830
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x00008d.00000003.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 926Kb in 0.35s => 0.00 Mb/sec
Longest record: 8Kb, moves: 0/2177 (0%)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 358/358 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 3752/4110 = 0.9
----------------------------------------------
*** 2010-05-26 12:18:31.508
KCRA: start recovery claims for 358 data blocks
*** 2010-05-26 12:18:31.539
KCRA: buffers claimed = 358/358, eliminated = 0
*** 2010-05-26 12:18:31.898
Recovery of Online Redo Log: Thread 1 Group 3 Seq 141 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 358/358 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 4110/4110 = 1.0
----------------------------------------------
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
26 май 10, 15:53    [8838771]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
Картинка с другого сайта.Никто не знает как таблички удаляются?
27 май 10, 07:15    [8841724]     Ответить | Цитировать Сообщить модератору
 Re: ошибка при удалении таблицы  [new]
беда.
Guest
+ ALTER SESSION SET sql_trace = TRUE;

Dump file c:\oracle\admin\stelis\udump\stelis_ora_4024.trc
Thu May 27 04:44:30 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: stelis

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 4024, image: ORACLE.EXE


*** 2010-05-27 04:44:31.014
*** SESSION ID:(13.5449) 2010-05-27 04:44:30.889
APPNAME mod='sqlplus.exe' mh=0 act='' ah=0
=====================
PARSING IN CURSOR #1 len=34 dep=0 uid=0 oct=42 lid=0 tim=6400966671 hv=1693589145 ad='6ae5d9c4'
ALTER SESSION SET sql_trace = TRUE
END OF STMT
EXEC #1:c=0,e=80,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=6400815433
*** 2010-05-27 04:46:03.356
=====================
PARSING IN CURSOR #1 len=36 dep=0 uid=0 oct=3 lid=0 tim=6493317259 hv=4100619946 ad='6ae5f5c0'
select instance_name from v$instance
END OF STMT
PARSE #1:c=0,e=1698,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=6493317252
EXEC #1:c=0,e=70,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=6493386201
FETCH #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=6493429891
FETCH #1:c=0,e=22,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=6493440818
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='NESTED LOOPS '
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=251 op='FIXED TABLE FULL X$QUIESCE '
STAT #1 id=4 cnt=1 pid=2 pos=2 obj=355 op='FIXED TABLE FULL X$KVIT '
STAT #1 id=5 cnt=1 pid=1 pos=2 obj=79 op='FIXED TABLE FULL X$KSUXSINST '
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #1 len=58 dep=0 uid=0 oct=12 lid=0 tim=6578296872 hv=0 ad='2e2f7d4'
drop table "ELIS_USER"."HIERARCHY_TAB" cascade constraints
END OF STMT
PARSE #1:c=0,e=18426,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=6578296864
=====================
PARSING IN CURSOR #2 len=198 dep=1 uid=0 oct=3 lid=0 tim=6578345182 hv=2703824309 ad='69b84618'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
PARSE #2:c=0,e=1842,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6578345174
EXEC #2:c=0,e=419,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6578397845
FETCH #2:c=0,e=123,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6578407057
=====================
PARSING IN CURSOR #3 len=51 dep=1 uid=0 oct=3 lid=0 tim=6578417169 hv=340778183 ad='69a7aaac'
select audit$,options from procedure$ where obj#=:1
END OF STMT
PARSE #3:c=0,e=767,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6578417161
EXEC #3:c=0,e=341,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6578468567
FETCH #3:c=0,e=72,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6578478190
=====================
PARSING IN CURSOR #4 len=116 dep=2 uid=0 oct=3 lid=0 tim=6578488438 hv=431456802 ad='69b874f0'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #4:c=15625,e=867,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=6578488430
EXEC #4:c=0,e=380,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6578542975
FETCH #4:c=0,e=69,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6578552428
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=68 op='TABLE ACCESS BY INDEX ROWID PROCEDURE$ '
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=115 op='INDEX UNIQUE SCAN I_PROCEDURE1 '
=====================
PARSING IN CURSOR #3 len=176 dep=1 uid=0 oct=3 lid=0 tim=6578582721 hv=4080861370 ad='69b6885c'
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order#
END OF STMT
PARSE #3:c=0,e=1199,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6578582713
EXEC #3:c=0,e=541,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6578632183
FETCH #3:c=0,e=258,p=0,cr=19,cu=0,mis=0,r=1,dep=1,og=4,tim=6578641976
FETCH #3:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6578696440
FETCH #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6578706079
FETCH #3:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6578715774
FETCH #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6578725444
FETCH #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6578734712
FETCH #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6578744058
FETCH #3:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6578753429
STAT #3 id=1 cnt=7 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #3 id=2 cnt=7 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER '
STAT #3 id=3 cnt=7 pid=2 pos=1 obj=96 op='TABLE ACCESS BY INDEX ROWID DEPENDENCY$ '
STAT #3 id=4 cnt=7 pid=3 pos=1 obj=127 op='INDEX RANGE SCAN I_DEPENDENCY1 '
STAT #3 id=5 cnt=7 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #3 id=6 cnt=7 pid=5 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
=====================
PARSING IN CURSOR #3 len=56 dep=1 uid=0 oct=3 lid=0 tim=6578822213 hv=1198893840 ad='69b63520'
select order#,columns,types from access$ where d_obj#=:1
END OF STMT
PARSE #3:c=0,e=782,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6578822205
EXEC #3:c=0,e=387,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6578869320
FETCH #3:c=0,e=105,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6578879492
FETCH #3:c=0,e=71,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6578889999
FETCH #3:c=0,e=71,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6578899819
FETCH #3:c=0,e=73,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6578909325
FETCH #3:c=0,e=47,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6578918826
EXEC #4:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6578928568
FETCH #4:c=0,e=68,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6578938074
STAT #3 id=1 cnt=4 pid=0 pos=1 obj=97 op='TABLE ACCESS BY INDEX ROWID ACCESS$ '
STAT #3 id=2 cnt=4 pid=1 pos=1 obj=129 op='INDEX RANGE SCAN I_ACCESS1 '
=====================
PARSING IN CURSOR #3 len=47 dep=1 uid=0 oct=3 lid=0 tim=6578967568 hv=1468360593 ad='69a75b74'
select actionsize from trigger$ where obj# = :1
END OF STMT
PARSE #3:c=0,e=766,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6578967561
EXEC #3:c=0,e=341,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579016435
FETCH #3:c=0,e=61,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6579026242
EXEC #4:c=0,e=100,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579036684
FETCH #4:c=0,e=69,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579047034
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=131 op='INDEX UNIQUE SCAN I_TRIGGER2 '
=====================
PARSING IN CURSOR #3 len=44 dep=1 uid=0 oct=3 lid=0 tim=6579077133 hv=2219546185 ad='69a736e0'
select action# from trigger$ where obj# = :1
END OF STMT
PARSE #3:c=0,e=767,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579077125
EXEC #3:c=0,e=324,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579133321
FETCH #3:c=0,e=87,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579144125
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=131 op='INDEX UNIQUE SCAN I_TRIGGER2 '
=====================
PARSING IN CURSOR #3 len=183 dep=1 uid=0 oct=3 lid=0 tim=6579177384 hv=1052990557 ad='69a7161c'
select baseobject,type#,update$,insert$,delete$,refnewname,refoldname,whenclause,definition,enabled,property,sys_evts,nttrigcol,nttrigatt,refprtname,rowid from trigger$ where obj# =:1
END OF STMT
PARSE #3:c=0,e=849,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579177376
EXEC #3:c=0,e=355,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579231860
FETCH #3:c=0,e=74,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6579242830
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=131 op='INDEX UNIQUE SCAN I_TRIGGER2 '
=====================
PARSING IN CURSOR #3 len=578 dep=1 uid=0 oct=3 lid=0 tim=6579280912 hv=1277302675 ad='69a6e440'
select tc.type#,tc.intcol#,tc.position#,c.type#, c.length,c.scale,c.precision#,c.charsetid,c.charsetform from triggercol$ tc,col$ c ,trigger$ tr where tc.obj#=:1 and c.obj#=:2 and tc.intcol#=c.intcol# and tr.obj# = tc.obj# and (bitand(tr.property,32) != 32 or bitand(tc.type#,20) = 20) union select type#,intcol#,position#,69,0,0,0,0,0 from triggercol$ where obj#=:3 and intcol#=1001 union select tc.type#,tc.intcol#,tc.position#,121,0,0,0,0,0 from triggercol$ tc,trigger$ tr where tr.obj# = tc.obj# and bitand(tr.property,32) = 32 and tc.obj# = :4 and bitand(tc.type#,20) != 20
END OF STMT
PARSE #3:c=0,e=4346,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579280904
EXEC #3:c=0,e=829,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579317319
FETCH #3:c=0,e=94,p=0,cr=4,cu=0,mis=0,r=0,dep=1,og=4,tim=6579317608
STAT #3 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT UNIQUE '
STAT #3 id=2 cnt=0 pid=1 pos=1 obj=0 op='UNION-ALL '
STAT #3 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS '
STAT #3 id=4 cnt=0 pid=3 pos=1 obj=0 op='NESTED LOOPS '
STAT #3 id=5 cnt=0 pid=4 pos=1 obj=21 op='TABLE ACCESS CLUSTER COL$ '
STAT #3 id=6 cnt=0 pid=5 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
STAT #3 id=7 cnt=0 pid=4 pos=2 obj=133 op='INDEX RANGE SCAN I_TRIGGERCOL2 '
STAT #3 id=8 cnt=0 pid=3 pos=2 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #3 id=9 cnt=0 pid=8 pos=1 obj=131 op='INDEX UNIQUE SCAN I_TRIGGER2 '
STAT #3 id=10 cnt=0 pid=2 pos=2 obj=133 op='INDEX RANGE SCAN I_TRIGGERCOL2 '
STAT #3 id=11 cnt=0 pid=2 pos=3 obj=0 op='NESTED LOOPS '
STAT #3 id=12 cnt=0 pid=11 pos=1 obj=133 op='INDEX RANGE SCAN I_TRIGGERCOL2 '
STAT #3 id=13 cnt=0 pid=11 pos=2 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #3 id=14 cnt=0 pid=13 pos=1 obj=131 op='INDEX UNIQUE SCAN I_TRIGGER2 '
=====================
PARSING IN CURSOR #3 len=213 dep=1 uid=0 oct=3 lid=0 tim=6579330300 hv=1199652613 ad='6ac8027c'
select u2.name, o2.name from ind$ i, obj$ o1, obj$ o2, user$ u1, user$ u2 where i.bo# = o1.obj# and o1.owner#=u1.user# and i.obj#=o2.obj# and o2.owner#=u2.user# and u1.name=:1 and o1.name=:2 and i.type#=9
END OF STMT
PARSE #3:c=0,e=2633,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579330292
EXEC #3:c=0,e=715,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579331216
FETCH #3:c=0,e=125,p=0,cr=8,cu=0,mis=0,r=0,dep=1,og=4,tim=6579331772
STAT #3 id=1 cnt=0 pid=0 pos=1 obj=0 op='NESTED LOOPS '
STAT #3 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #3 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS '
STAT #3 id=4 cnt=1 pid=3 pos=1 obj=0 op='NESTED LOOPS '
STAT #3 id=5 cnt=1 pid=4 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ '
STAT #3 id=6 cnt=1 pid=5 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 '
STAT #3 id=7 cnt=1 pid=4 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #3 id=8 cnt=1 pid=7 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 '
STAT #3 id=9 cnt=0 pid=3 pos=2 obj=19 op='TABLE ACCESS CLUSTER IND$ '
STAT #3 id=10 cnt=1 pid=9 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
STAT #3 id=11 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #3 id=12 cnt=0 pid=11 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
STAT #3 id=13 cnt=0 pid=1 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #3 id=14 cnt=0 pid=13 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #3 len=43 dep=1 uid=0 oct=3 lid=0 tim=6579333199 hv=2455283208 ad='69b3080c'
select user#,type# from user$ where name=:1
END OF STMT
PARSE #3:c=0,e=721,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579333192
EXEC #3:c=0,e=321,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579333764
FETCH #3:c=0,e=42,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6579333911
EXEC #2:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579334110
FETCH #2:c=0,e=54,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579334215
=====================
PARSING IN CURSOR #5 len=343 dep=1 uid=0 oct=3 lid=0 tim=6579335355 hv=2367942048 ad='69b7a960'
select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1
END OF STMT
PARSE #5:c=0,e=1051,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579335348
EXEC #5:c=0,e=360,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579336210
FETCH #5:c=0,e=82,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579336403
=====================
PARSING IN CURSOR #6 len=176 dep=1 uid=0 oct=3 lid=0 tim=6579336563 hv=4080861370 ad='69b6885c'
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order#
END OF STMT
PARSE #6:c=0,e=66,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579336560
EXEC #6:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579336846
FETCH #6:c=0,e=47758,p=1,cr=8,cu=0,mis=0,r=1,dep=1,og=4,tim=6579384655
FETCH #6:c=0,e=9,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579384811
FETCH #6:c=0,e=16,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579384870
STAT #6 id=1 cnt=2 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #6 id=2 cnt=2 pid=1 pos=1 obj=0 op='NESTED LOOPS OUTER '
STAT #6 id=3 cnt=2 pid=2 pos=1 obj=96 op='TABLE ACCESS BY INDEX ROWID DEPENDENCY$ '
STAT #6 id=4 cnt=2 pid=3 pos=1 obj=127 op='INDEX RANGE SCAN I_DEPENDENCY1 '
STAT #6 id=5 cnt=1 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #6 id=6 cnt=1 pid=5 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
=====================
PARSING IN CURSOR #6 len=56 dep=1 uid=0 oct=3 lid=0 tim=6579385265 hv=1198893840 ad='69b63520'
select order#,columns,types from access$ where d_obj#=:1
END OF STMT
PARSE #6:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579385262
EXEC #6:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579385515
FETCH #6:c=0,e=58,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579385623
FETCH #6:c=0,e=13,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6579385692
STAT #6 id=1 cnt=1 pid=0 pos=1 obj=97 op='TABLE ACCESS BY INDEX ROWID ACCESS$ '
STAT #6 id=2 cnt=1 pid=1 pos=1 obj=129 op='INDEX RANGE SCAN I_ACCESS1 '
EXEC #4:c=0,e=42,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579385996
FETCH #4:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579386093
=====================
PARSING IN CURSOR #6 len=189 dep=1 uid=0 oct=3 lid=0 tim=6579387016 hv=548195648 ad='69a65b40'
select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass) from user$ where user#=:1
END OF STMT
PARSE #6:c=0,e=836,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579387008
EXEC #6:c=0,e=353,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579387655
FETCH #6:c=0,e=68,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=6579387832
STAT #6 id=1 cnt=1 pid=0 pos=1 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #6 id=2 cnt=1 pid=1 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #6 len=175 dep=1 uid=0 oct=3 lid=0 tim=6579389520 hv=3073477137 ad='6993d4dc'
select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj#
END OF STMT
PARSE #6:c=0,e=1431,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579389513
EXEC #6:c=0,e=469,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579390187
FETCH #6:c=0,e=65,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6579390341
STAT #6 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #6 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #6 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS '
STAT #6 id=4 cnt=0 pid=3 pos=1 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #6 id=5 cnt=0 pid=4 pos=1 obj=130 op='INDEX RANGE SCAN I_TRIGGER1 '
STAT #6 id=6 cnt=0 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #6 id=7 cnt=0 pid=6 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
STAT #6 id=8 cnt=0 pid=2 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #6 id=9 cnt=0 pid=8 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #6 len=693 dep=1 uid=0 oct=3 lid=0 tim=6579392911 hv=1480155015 ad='69b78ba8'
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1
END OF STMT
PARSE #6:c=0,e=2090,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579392905
EXEC #6:c=15625,e=694,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579394175
FETCH #6:c=0,e=88,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579394393
=====================
PARSING IN CURSOR #7 len=348 dep=1 uid=0 oct=3 lid=0 tim=6579395458 hv=839312984 ad='69b6c37c'
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#
END OF STMT
PARSE #7:c=0,e=965,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579395451
EXEC #7:c=0,e=427,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579396194
FETCH #7:c=0,e=132,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579396448
FETCH #7:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579396518
FETCH #7:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579396564
FETCH #7:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579396608
FETCH #7:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579396659
=====================
PARSING IN CURSOR #8 len=169 dep=1 uid=0 oct=3 lid=0 tim=6579397707 hv=204386021 ad='69b51d80'
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
END OF STMT
PARSE #8:c=0,e=948,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579397700
EXEC #8:c=0,e=434,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579398399
FETCH #8:c=0,e=70,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=6579398587
=====================
PARSING IN CURSOR #9 len=151 dep=1 uid=0 oct=3 lid=0 tim=6579399495 hv=1980305124 ad='69b4ff4c'
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
END OF STMT
PARSE #9:c=0,e=817,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579399488
EXEC #9:c=0,e=435,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579400186
FETCH #9:c=0,e=68,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=6579400371
=====================
PARSING IN CURSOR #10 len=141 dep=1 uid=0 oct=3 lid=0 tim=6579401285 hv=2364027057 ad='69b254b0'
select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
END OF STMT
PARSE #10:c=0,e=822,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579401278
EXEC #10:c=0,e=397,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579401956
FETCH #10:c=0,e=117,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579402187
FETCH #10:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579402254
FETCH #10:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579402305
=====================
PARSING IN CURSOR #11 len=117 dep=1 uid=0 oct=3 lid=0 tim=6579403178 hv=1520971034 ad='69b2464c'
select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc
END OF STMT
PARSE #11:c=0,e=791,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579403171
EXEC #11:c=0,e=374,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579403814
FETCH #11:c=0,e=78,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579404003
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID OBJ#(22) '
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=44 op='INDEX UNIQUE SCAN OBJ#(44) '
=====================
PARSING IN CURSOR #3 len=71 dep=1 uid=0 oct=3 lid=0 tim=6579404989 hv=120978412 ad='69b1eaf0'
select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc
END OF STMT
PARSE #3:c=0,e=766,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579404982
EXEC #3:c=0,e=375,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579405626
FETCH #3:c=0,e=78,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579405817
=====================
PARSING IN CURSOR #12 len=191 dep=1 uid=0 oct=3 lid=0 tim=6579406742 hv=1232162599 ad='69b1b608'
select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
END OF STMT
PARSE #12:c=0,e=834,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579406736
EXEC #12:c=0,e=396,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579407386
FETCH #12:c=0,e=81,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579407587
STAT #12 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #12 id=2 cnt=0 pid=1 pos=1 obj=156 op='TABLE ACCESS CLUSTER LOB$ '
STAT #12 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# '
STAT #2 id=1 cnt=2 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '
STAT #2 id=2 cnt=2 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN OBJ#(37) '
=====================
PARSING IN CURSOR #2 len=90 dep=1 uid=0 oct=3 lid=0 tim=6579408720 hv=3302995849 ad='69b17950'
select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc
END OF STMT
PARSE #2:c=0,e=773,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579408714
EXEC #2:c=0,e=369,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579409343
FETCH #2:c=0,e=86,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579409603
STAT #5 id=1 cnt=1 pid=0 pos=1 obj=4 op='TABLE ACCESS CLUSTER OBJ#(4) '
STAT #5 id=2 cnt=1 pid=1 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #5 len=86 dep=1 uid=0 oct=3 lid=0 tim=6579410612 hv=162044583 ad='69b14244'
select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc
END OF STMT
PARSE #5:c=0,e=769,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579410605
EXEC #5:c=0,e=376,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579411241
FETCH #5:c=0,e=111,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579411464
FETCH #5:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579411521
FETCH #5:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579411561
FETCH #5:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=6579411600
FETCH #5:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579411648
STAT #4 id=1 cnt=4 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ#(18) '
STAT #4 id=2 cnt=4 pid=1 pos=1 obj=36 op='INDEX UNIQUE SCAN OBJ#(36) '
=====================
PARSING IN CURSOR #4 len=119 dep=1 uid=0 oct=3 lid=0 tim=6579412636 hv=3309219733 ad='69b10748'
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
END OF STMT
PARSE #4:c=0,e=781,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579412630
EXEC #4:c=0,e=377,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579413278
FETCH #4:c=0,e=79,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579413469
STAT #6 id=1 cnt=0 pid=0 pos=1 obj=0 op='MERGE JOIN OUTER '
STAT #6 id=2 cnt=0 pid=1 pos=1 obj=0 op='SORT JOIN '
STAT #6 id=3 cnt=0 pid=2 pos=1 obj=19 op='TABLE ACCESS CLUSTER OBJ#(19) '
STAT #6 id=4 cnt=1 pid=3 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
STAT #6 id=5 cnt=0 pid=1 pos=2 obj=0 op='SORT JOIN '
STAT #6 id=6 cnt=0 pid=5 pos=1 obj=0 op='VIEW '
STAT #6 id=7 cnt=0 pid=6 pos=1 obj=0 op='SORT GROUP BY '
STAT #6 id=8 cnt=0 pid=7 pos=1 obj=31 op='TABLE ACCESS CLUSTER OBJ#(31) '
STAT #6 id=9 cnt=0 pid=8 pos=1 obj=30 op='INDEX UNIQUE SCAN OBJ#(30) '
=====================
PARSING IN CURSOR #6 len=69 dep=1 uid=0 oct=3 lid=0 tim=6579414710 hv=2065408759 ad='69b45254'
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
END OF STMT
PARSE #6:c=0,e=782,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579414703
EXEC #6:c=0,e=333,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579415302
FETCH #6:c=0,e=37,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6579415448
STAT #7 id=1 cnt=4 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #7 id=2 cnt=4 pid=1 pos=1 obj=21 op='TABLE ACCESS CLUSTER OBJ#(21) '
STAT #7 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #7 len=146 dep=1 uid=0 oct=3 lid=0 tim=6579416544 hv=1937775682 ad='69b570a0'
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1
END OF STMT
PARSE #7:c=0,e=840,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579416537
EXEC #7:c=0,e=346,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579417178
FETCH #7:c=0,e=5308,p=1,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579422593
STAT #8 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY '
STAT #8 id=2 cnt=0 pid=1 pos=1 obj=90 op='TABLE ACCESS BY INDEX ROWID OBJ#(90) '
STAT #8 id=3 cnt=0 pid=2 pos=1 obj=108 op='INDEX RANGE SCAN OBJ#(108) '
=====================
PARSING IN CURSOR #8 len=56 dep=1 uid=0 oct=3 lid=0 tim=6579423636 hv=1433558559 ad='69b444b4'
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
END OF STMT
PARSE #8:c=0,e=767,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579423629
EXEC #8:c=0,e=338,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579424227
FETCH #8:c=0,e=66,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=6579424402
FETCH #8:c=0,e=12,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6579424465
FETCH #7:c=0,e=12,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6579424543
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY '
STAT #9 id=2 cnt=0 pid=1 pos=1 obj=90 op='TABLE ACCESS BY INDEX ROWID OBJ#(90) '
STAT #9 id=3 cnt=0 pid=2 pos=1 obj=108 op='INDEX RANGE SCAN OBJ#(108) '
=====================
PARSING IN CURSOR #9 len=198 dep=2 uid=0 oct=3 lid=0 tim=6579425642 hv=2703824309 ad='69b84618'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
PARSE #9:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579425638
EXEC #9:c=0,e=69,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579425922
FETCH #9:c=0,e=69,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579426041
STAT #10 id=1 cnt=2 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #10 id=2 cnt=2 pid=1 pos=1 obj=283 op='TABLE ACCESS CLUSTER OBJ#(283) '
STAT #10 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #10 len=343 dep=2 uid=0 oct=3 lid=0 tim=6579426338 hv=2367942048 ad='69b7a960'
select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1
END OF STMT
PARSE #10:c=0,e=56,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579426335
EXEC #10:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579426628
FETCH #10:c=0,e=70,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579426745
=====================
PARSING IN CURSOR #14 len=190 dep=2 uid=0 oct=3 lid=0 tim=6579428257 hv=1006414593 ad='69b3b50c'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #14:c=0,e=1418,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=6579428250
EXEC #14:c=0,e=375,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579428913
FETCH #14:c=0,e=74,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579429096
STAT #14 id=1 cnt=1 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ '
STAT #14 id=2 cnt=1 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# '
STAT #11 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #11 id=2 cnt=0 pid=1 pos=1 obj=286 op='TABLE ACCESS CLUSTER OBJ#(286) '
STAT #11 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #11 len=693 dep=2 uid=0 oct=3 lid=0 tim=6579435330 hv=1480155015 ad='69b78ba8'
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, decode(i.pctthres$,null,null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#=:1
END OF STMT
PARSE #11:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579435327
EXEC #11:c=0,e=102,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579435699
FETCH #11:c=0,e=206,p=0,cr=6,cu=0,mis=0,r=1,dep=2,og=4,tim=6579435963
STAT #3 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #3 id=2 cnt=0 pid=1 pos=1 obj=352 op='TABLE ACCESS CLUSTER OBJ#(352) '
STAT #3 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #3 len=67 dep=2 uid=0 oct=3 lid=0 tim=6579436996 hv=2889900621 ad='69b719cc'
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
END OF STMT
PARSE #3:c=0,e=774,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=6579436989
EXEC #3:c=0,e=354,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579437597
FETCH #3:c=0,e=67,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579437773
FETCH #3:c=0,e=16,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=6579437841
FETCH #3:c=0,e=10,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=6579437892
FETCH #11:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579437993
EXEC #3:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579438121
FETCH #3:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579438205
FETCH #3:c=0,e=9,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=6579438260
FETCH #11:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579438363
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #2 id=2 cnt=0 pid=1 pos=1 obj=362 op='TABLE ACCESS CLUSTER OBJ#(362) '
STAT #2 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #2 len=348 dep=2 uid=0 oct=3 lid=0 tim=6579438670 hv=839312984 ad='69b6c37c'
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ where obj#=:1 order by intcol#
END OF STMT
PARSE #2:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579438666
EXEC #2:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579438957
FETCH #2:c=0,e=140,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439161
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439229
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439273
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439316
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439359
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439402
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439445
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439488
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439531
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579439574
FETCH #2:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579439624
STAT #5 id=1 cnt=4 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #5 id=2 cnt=4 pid=1 pos=1 obj=21 op='TABLE ACCESS CLUSTER OBJ#(21) '
STAT #5 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #5 len=116 dep=2 uid=0 oct=3 lid=0 tim=6579439971 hv=431456802 ad='69b874f0'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #5:c=0,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579439967
EXEC #5:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579440422
FETCH #5:c=0,e=48,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579440520
EXEC #5:c=15625,e=54,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579440696
FETCH #5:c=0,e=86,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579440890
=====================
PARSING IN CURSOR #12 len=49 dep=1 uid=0 oct=3 lid=0 tim=6579441232 hv=3593001918 ad='6b3ef1d0'
select count(*) from association$ where obj# = :1
END OF STMT
PARSE #12:c=31250,e=16584,p=1,cr=35,cu=0,mis=1,r=0,dep=1,og=0,tim=6579441225
EXEC #5:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579441783
FETCH #5:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579441917
EXEC #12:c=0,e=641,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=6579442087
FETCH #12:c=0,e=1031,p=1,cr=1,cu=0,mis=0,r=1,dep=1,og=4,tim=6579443185
EXEC #9:c=0,e=69,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579444038
FETCH #9:c=0,e=67,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579444197
EXEC #10:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579444399
FETCH #10:c=0,e=52,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579444499
=====================
PARSING IN CURSOR #15 len=190 dep=2 uid=0 oct=3 lid=0 tim=6579444651 hv=1006414593 ad='69b3b50c'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #15:c=0,e=69,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579444648
EXEC #15:c=0,e=51,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579444906
FETCH #15:c=0,e=53,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579445003
STAT #15 id=1 cnt=1 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ '
STAT #15 id=2 cnt=1 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# '
EXEC #11:c=0,e=96,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579446107
FETCH #11:c=0,e=182,p=0,cr=6,cu=0,mis=0,r=1,dep=2,og=4,tim=6579446378
EXEC #3:c=0,e=54,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579446539
FETCH #3:c=0,e=45,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579446629
FETCH #3:c=0,e=15,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,tim=6579446689
FETCH #3:c=0,e=10,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=6579446739
FETCH #11:c=0,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579446821
EXEC #2:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579447002
FETCH #2:c=0,e=112,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447169
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447229
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447274
FETCH #2:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447317
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447360
FETCH #2:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447403
FETCH #2:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447446
FETCH #2:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579447494
EXEC #5:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=6579447699
FETCH #5:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=6579447795
=====================
PARSING IN CURSOR #14 len=43 dep=1 uid=0 oct=3 lid=0 tim=6579448020 hv=2611006824 ad='6b3e2c4c'
select intcol# from ustats$ where obj# = :1
END OF STMT
PARSE #14:c=0,e=4685,p=1,cr=28,cu=0,mis=1,r=0,dep=1,og=0,tim=6579448015
EXEC #14:c=0,e=269,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579448487
FETCH #14:c=0,e=557,p=1,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=6579449143
STAT #14 id=1 cnt=0 pid=0 pos=1 obj=384 op='INDEX RANGE SCAN USTATS1 '
STAT #12 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE '
STAT #12 id=2 cnt=0 pid=1 pos=1 obj=381 op='INDEX RANGE SCAN ASSOC1 '
STAT #4 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #4 id=2 cnt=0 pid=1 pos=1 obj=365 op='TABLE ACCESS CLUSTER OBJ#(365) '
STAT #4 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN OBJ#(3) '
=====================
PARSING IN CURSOR #4 len=48 dep=1 uid=0 oct=3 lid=0 tim=6579454931 hv=1723671589 ad='69943a98'
select obj# from oid$ where user#=:1 and oid$=:2
END OF STMT
PARSE #4:c=0,e=992,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579454924
EXEC #4:c=0,e=315,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579455505
FETCH #4:c=0,e=6527,p=2,cr=5,cu=0,mis=0,r=1,dep=1,og=4,tim=6579462143
EXEC #4:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579462409
FETCH #4:c=0,e=19,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=6579462483
=====================
PARSING IN CURSOR #12 len=43 dep=1 uid=0 oct=3 lid=0 tim=6579463324 hv=1449727033 ad='6b3da5d0'
select o.name from obj$ o where o.oid$ = :1
END OF STMT
PARSE #12:c=0,e=714,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=0,tim=6579463318
EXEC #12:c=0,e=294,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=6579463858
FETCH #12:c=0,e=5312,p=1,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=6579469272
27 май 10, 07:59    [8841793]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить