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 »
We will be discussing Oracle indexes, types of indexes in oracle with example, and how to create index in oracle in this post. I will through light on all the options on how to create an index in oracle. I hope you will like this post. I will be looking forward to feedback on this …
Oracle Indexes and types of indexes in oracle with example 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 »
All the below scripts are present in $AD_TOP/sql ADZDDBCC.sql This sql is for database compliance checker, shows violations of the database object development standards described later in this document. Warning: this script takes a long time to run. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDDBCC.sql ADZDSHOWED.sql This sql show database editions and current edition. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDSHOWED.sql …
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 »
