Archive for June, 2007

STEPS OF FAILOVER AND RESTORATION FROM 10G FILE SYSTEM TO 10G RAC WITH ASM

System Description
—————————————-
##################################################################################
RAC 10g with ASM(Primary):-
——————————————-
Node 1:- Instance Name:-pagasm1 IP:-172.17.240.91 Hostname:-pag1 Service Name:-pagasm
Node 2:- Instance Name:-pagasm2 IP:-172.17.240.92 Hostname:-pag2 Service Name:-pagasm
10g File system(DR)
—————————–
Instance Name:-pagasm Service name:-pagasm Hostname:-01hw105894 IP:-172.17.240.208
##################################################################################
########################################### FOR FAILOVER #########################
1) Remove the physical connection between the primary and DR site
[…]

PCT_USED Column Not getting updated in DBA_TABLES View?

Hi,
pctused and pctfree are the oracle block properties which decides the performance of the queries on tables.
By defination,
PCTFREE is percent of the space which is reserved free for the future updates on the rows contained in the oracle block. default value being PCTFREE=10
PCTUSED is the maximum percent of the space which should be occupied or […]


Close
E-mail It