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 »
Triggers are an important construct in Oracle. These are the codes that are fired when a row is updated, inserted, or deleted in the Oracle table. Let’s find out how to check trigger status in Oracle, how to check trigger definition in Oracle, How to find all Trigger in the table, and many more How …
Oracle database is a complex system and objects are interrelated and have dependencies. Like a package may depend on a certain Oracle table, view or synonym. So objects may go invalid in case of deployments of new objects, alter table commands, packages, views, and synonyms. Now let’s find out how to find the invalid objects …
ASM Failure Groups and Redundancy 1)For systems that do not use external redundancy, ASM provides its own internal redundancy mechanismand additional high availability by way of ASM failure groups2) It is also collection of disk and is considered as subset of disk group.3)Disk group redundancy can beNormal – It is Two-way mirroring requiring at least …
How ASM Failure Groups and CSS provide high availability Read More »
OTA(Oracle Transport Agent) for XML gateway is an important feature. we will be discussing here how to enable OTA in R12, R12.1 and R12.2 and 11i. EBS 11i In EBS Release 11i instances where OTA was utilized, OTA ran under Jserv having its properties set in the files found in the directory:$IAS_ORACLE_HOME/Apache/Jserv/etc11.5.9 – jserv.properties11.5.10/11.5.10.2 – …
A schema in Oracle consists of tables, index, Log segments, Lob Index, table partition and index partition. The schema size in Oracle depends on the size of all these objects. Let’s check how to find the size of the schema in Oracle How to find the size of schema in Oracle The below query will …
Size of schema in oracle Read More »
