Question : We are currently evaluating possibilities to store generic data structures. We found that at least from a functional […]
Tag: oracle-11g
Select performance problems with conditional index vs non-conditional on large volume table
Question : We are trying to change some indexes on a large-volume table to be conditional indexes (function-based indexes) to […]
How to add a new listener on a new port and restrict it to one instance only
Question : I am running oracle 11.2.3 and we have a server with multiple instances running. All of them are […]
Pivot rows into multiple columns
Question : I have a SQL Server instance that has a linked server to an Oracle server. There is a […]
Hibernate Query Running Slow
Question : I am currently facing a problem with a slow running Hibernate query that is being kicked off from […]
Way to track data deleted from database
Question : I’m using Oracle 11g database in archivelog mode and auditing is not enabled. Two days before, a few […]
How do I import data into oracle 11g r2 using a `.dmp` file and a `.par` file?
Question : How do I import data into a new installation of oracle 11g r2 using a .dmp file and […]
Oracle – Search a value in all columns of a table
Question : Here is my issue. I have a Oracle table which contains 53 columns. And i would like to […]
Supporting Multiple Oracle Clients
Question : I have an application where the data repository is moving to Oracle 11g. This means we need the […]
Difference in database dump file size
Question : Actually I am bit confused with my database export, while i exporting it shows “Total estimation using BLOCKS […]