Question : i have installed oracle binaries at two different location on Oracle Linux , /u01 & /u02 when i […]
Tag: oracle
Starting an Oracle database without a spfile & pfile?
Question : How can I start an Oracle database if both the spfile and pfile are not present, and a […]
Which parameters and metrics to look at when CDC based replication is causing high load?
Question : I’m investigating the reasons why a Tungsten Replicator extractor is causing heavy load on an Oracle 11g database. […]
Open source tools for Oracle schema compares [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
Why my index don’t update?
Question : I have created this index ORACLE/VIDEO# create index titolo_index 2 on titolo(titolo) 3 indextype is ctxsys.context 4 ONLINE […]
Oracle 11g XMLType Experience
Question : We are currently evaluating possibilities to store generic data structures. We found that at least from a functional […]
What is an Effective Way to Count the Number of Pages in Oracle?
Question : We’ve implemented paging in our PL/SQL procedures by building a dynamic SQL query and then selection only a […]
Tuning a query to fetch all the records in a day with certain status
Question : We are currently using Oracle Database: Consider a table TRANSACTION with the fields TRAN_ID, STATUS, CREATED_TIME, …. The […]
Using Wildcard with `IN (‘%’)`?
Question : Is it possible to modify the (‘%’) to return a single row for the following query, i.e. while […]
no matching unique or primary key for this column-list
Question : My parent table Create table spare( Sid int , Sname varchar(20), Mid int, primary key(Sid,Sname), foreign key(Mid) references […]