step1 enter RMAN command $ rman target / step2 check all archivelog RMAN> crosscheck archivelog all; step3 list all invalid archivelog RMAN> list expired archivelog…
This chapter describes how to optimize connection performance. This chapter contains the following topics: Configuring Session Data Unit Determining Bandwidth-delay Product Configuring I/O Buffer Space…
start/stop database srvctl start/stop database -d instance_name [grid@node1 ~]$ srvctl status database -d devdb Instance devdb1 is running on node node1 Instance devdb2 is running…
Test 64K read speed with system cache dd if=/dev/zero of=/…/test bs=64k count=100000 Test 64K read speed without system cache dd if=/dev/zero of=/…/test bs=64k count=100000 oflag=direct…
We must plug in U disk after RHEL6.5 had been installed to server, otherwise the server can not boot on the next time. The reason…
For additional information on handling corruption, see the BC expert notes on corruption and see MOSC Note 1088018.1 – Handling Oracle Database Corruption Issues. Also see how to…
Create main tablespace create tablespace TEST datafile ‘/home/oracle/app/oracle/oradata/TEST/test.dbf’ size 1000M autoextend on next 500M maxsize unlimited; Create main temp tablespace create temporary tablespace TEST_TEMP tempfile…
select * from ( Select a.tablespace_name, to_char(a.bytes/1024/1024,’99,999.999′) total_bytes, to_char(b.bytes/1024/1024,’99,999.999′) free_bytes, to_char(a.bytes/1024/1024 – b.bytes/1024/1024,’99,999.999′) use_bytes, to_char((1 – b.bytes/a.bytes)*100,’99.99′) || ‘%’ use from (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name)…