Category Archives: oracle

What is ‘SERIALLY REUSABLE’ in oracle package ?

SERIALLY_REUSABLE packages let you design applications that manage memory better for scalability. If a package is not SERIALLY_REUSABLE, its package state is stored in the user global area (UGA) for each user. Therefore, the amount of UGA memory needed increases linearly with … Continue reading

Posted in oracle | Leave a comment

what features are not available in oracle express edition ?

  Enterprise Edition (EE) – The flagship Oracle offering with a vast array of tools and features for the large corporation. Standard Edition (SE) – Oracle SE contains the basic database management functions for small- and medium-sized shops at a far lower … Continue reading

Posted in oracle | Leave a comment

Find objects size in MB (TABLES, INDEXES, PARTITIONS etc)

summary Finding object size in Oracle database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in Mbytes. The scripts … Continue reading

Posted in oracle | Leave a comment

What is ETL in Sql ?

What is ETL: ETL stands for Extract, Transform, Load. Extract means to read data from source, Transform means to apply business logic on data & in last load means to add or load data on other server. ETL (Extract, Transform … Continue reading

Posted in oracle, sql | Leave a comment

How do I find duplicate values in a table in Oracle?

To find duplicate value we need the sql group by & having clause as below. SELECT V.FIELD_NAME1, COUNT(*) FROM TABLE_NAME V GROUP BY V.FIELD_NAME1 HAVING COUNT(*)>1 How query works? First it will group the same value by non-clustered index i.e. virtual … Continue reading

Posted in oracle, sql | Tagged | Leave a comment

What is clustered & non-clustered index in oracle?

Clustered index & Non-clustered index A clustered index the table records are physically stored on the basic of that index, A table can have only one clustered index because of physically stored to the table. A Non-clustered index that is … Continue reading

Posted in oracle, sql | Tagged , | Leave a comment

How to get table size in MB oracle ?

select segment_name,segment_type,bytes/1024/1024 MB from dba_segments where segment_type=’TABLE’ and lower(segment_name)=’your_table_name’;

Posted in oracle, sql | Tagged | Leave a comment