Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction
Here I am presenting the Oracle tutorials on Various Oracle products
These articles will be really help in understanding the oracle products and getting started on Oracle system
Oracle Mobile Warehousing Application( Oracle MWA) is a important components of Oracle E-buisness Suite and it is used in warehouse to scan items.In this section , i am sharing the information for MWA Oracle MWA/MSCA Services Configuration file for 11i Configuration file is used to set server related properties. Setup mwa.cfg file as follows: 1. …
Oracle MWA/MSCA Services Read More »
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 …
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 »
