What is Oracle RAC interconnect The RAC interconnect is a very important part of the cluster environment it is on of the aorta’s of a cluster environment. The interconnect is used as physical layer between the cluster nodes to perform heartbeats as well as the cache fusion is using it. The interconnect must be a […]
Oracle RAC interconnect Read More »
What is Single Client Access Name (SCAN) in Oracle It is a new Oracle Real Application Clusters (RAC) 11g Release 2 feature that provides a single name for clients to access Oracle Databases running in a cluster. The benefit is that the client’s connect information does not need to change if you add or remove
How to configure Single Client Access Name (SCAN) in Oracle Read More »
Generally A select from the BYTES column in DBA_SEGMENTS for the table shows the table segment and its size. select bytes/1024/1024 ,segment_name from dba_segments where segment_name=’&1′ and segment_type=’TABLE’; But does not include LOB (CLOB or BLOB) segments sizes.To calculate the total size for the table and the associated LOBS segments a sum of the following
How to find space usage of lob segments in Oracle database Read More »
Recently I encountered a oracle table which has 50 column and I need to analyze the each column for the particular row. It was tough viewing those 50 columns in the rows, So I created below PLSQL block to convert the rows into column. This takes table name as the input and print one rows
How to converts rows into column in Oracle table Read More »
ORA-29285: file write error is one of the errors which may get while doing file handling operation in the oracle database File handling operations are creating a new file on the Operating system, updating or modifying it. This function is used quite often in PLSQL for file manipulation Reason and Resolutions for ORA-29285 (1) Unix
How to resolve ORA-29285: file write error Read More »
ORA-29280: invalid directory path is a common error when doing file handling operations in the Oracle database Reason and Resolution for the error (1) This occurs if the directory specified does not exists in utl_file_dir init.ora parameter sqlplus / as sysdba show parameter utl_file_dir /tmp, /usr/tmp/ SQL> declare F_LOG utl_file.file_type; begin F_LOG := utl_file.fopen(‘/u500′,’j’, ‘w’);
How to Solve ORA-29280: invalid directory path Read More »
