Question : I’ve just run the installer for Oracle 11gR2 on a Windows Server 2008 (64-bit) OS. I encountered the […]
Category: Oracle
How to run procedure in Oracle SQL developer
Question : Hello I have a table named CITY in oracle SQL developer, my problem is how to run the […]
Remove ORA-01100:DATABASE ALREADY MOUNTED
Question : I am using Oracle 11g and there is a database create during installation name “xyz” and user “xyz”.Now […]
Problem with procedure performance
Question : I’m having problem in Oracle, where I have two procedures that are executed one after the other. Where […]
Count values from one table using two columns in another table
Question : I have a problem. I have table_1 (col1, col2, value) and table_2 (col1, col2). I want to count […]
ORA-01113: file 1 needs media recovery — system01.dbf
Question : The only way to recover is from media backup? I know I cannot “rebuild” system datafile, but if […]
Why different connections in database.? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Oracle SQL. Error creating type
Question : I’m learning SQL. When I try to create a type in Oracle SQL: CREATE TYPE boolean_typ AS OBJECT […]
Oracle TKPROF Insert data doesn’t match text results
Question : I’m trying to make sense of the output from a SQL Trace from an Oracle 12.2 database on […]
Using AMMM or Huge Pages for Oracle 11g R2 Database
Question : I’m running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA […]