共 170 篇文章 |
|
2 3 OWNER SEGMENT_NAME EXTENT_ID FILE_ID BLOCK_ID BLOCKS------------------------------ ------------------------------- ---------- ---------- ---------- ----------YHQT YHQTEST_4 0 10 152 8YHQT YHQTEST_4 1 10 160 8YHQT@ orcl >SELECT DISTINCT dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(row... 阅2 转0 评0 公众公开 24-05-16 22:12 |
SQLNET.ENCRYPTION_SERVER=requiredSQLNET.ENCRYPTION_TYPES_SERVER=<encryption algorithm>SQLNET.CRYPTO_CHECKSUM_CLIENT = [ accepted | rejected | requested | required ] SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = <crypto_checksum_algorithms>SQLNET.CRYPTO_CHECKSUM_SERVER = [ accepted | rejected | requested | required... 阅2 转0 评0 公众公开 24-04-30 14:17 |
为Oracle 服务器和客户端配置网络数据加密和完整性_sqlnet.crypto_checksumOracle 高级安全加密。Oracle Advanced Security 使用众所周知的Diffie-Hellman 密钥协商算法来执行加密和数据完整性的安全密钥分发。vi sqlnet.ora ## 配置加密 SQLNET.CRYPTO_CHECKSUM_SERVER = required SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= (SHA1) #(可选)在加... 阅8 转0 评0 公众公开 24-04-30 14:12 |
shell复制代码orapki wallet add -wallet /home/oracle/wallets/server_wallet -trusted_cert -cert /home/oracle/cert.txt -pwd Zjzs_123# /home/oracle/wallets/server_wallet服务端wallet路径# /home/oracle/cert.txt 上传的客户端cert.txt路径# -pwd Zjzs_123 客户端产生的cert.txt的秘钥客户端认证服务端秘钥服务端产生的cert.txt 下载到... 阅24 转0 评0 公众公开 24-04-25 10:58 |
''''''''||chr(10)||''''''''spool off'''''''' from (select dbid,instance_number,snap_id b_snap_id,lead(snap_id,1,0) over(partition by instance_number order by snap_id) e_snap_idfrom dba_hist_snapshotwhere begin_interval_time... 阅3 转0 评0 公众公开 24-04-21 19:34 |
阅1 转0 评0 公众公开 24-04-21 16:51 |
19791273这个bug的fix,会对update操作禁用space search cache,避免性能过载。有些蒙圈了,我们重新梳理这两个bug,首先,第二个bug(13641076),是说当存在一个并发未提交的大数据量delete操作时,insert操作会消耗大量逻辑读,原因就是在ASSM下寻找段空闲空间时需要访问的space search cache是基于游标的,下次使用新游标,会导致space searc... 阅8 转0 评0 公众公开 24-04-21 00:00 |
Wed Nov 03 06:38:58 2021Archived Log entry 220714 added for thread 2 sequence 33828 ID 0xbc36136c dest 1:Wed Nov 03 06:39:51 2021ORA-1628: max # extents 32765 reached for rollback segment _SYSSMU30353_261227539$ ORA-1628: max # extents 32765 reached for rollback segment _SYSSMU30353_261227539$ ORA-1628: max # extent... 阅1 转0 评0 公众公开 24-04-14 19:41 |
(Y/N) yBBED> sum applyCheck value for File 3, Block 240:current = 0xaf65, required = 0xaf65--//再次查询数据SQL> alter system flush buffer_cache;System altered.SQL> select rowid, t1.* from t t1 where rownum = 1;ROWID ID NAME------------------ ---------- ----AAAWDkAABAAAXHhAAA 1 test <======有可以通过undo找... 阅9 转0 评0 公众公开 24-02-25 21:17 |
I_WRI$_OPTSTAT_IND_OBJ#_ST rebuild online;EXEC dbms_stats.gather_table_stats(ownname => ''''''''SYS’,tabname => ''''''''WRI$_OPTSTAT_HISTHEAD_HISTORY’,cascade => TRUE);EXEC dbms_stats.gather_table_stats(ownname => '''''... 阅17 转0 评0 公众公开 23-12-21 17:53 |