The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...

learn more… | top users | synonyms

3
votes
1answer
2k views

Why is add timestamp column with default not null so slow in Oracle 11g?

In Oracle I need to add a new column with type timestamp with time zone to a large table (80 million rows). I cannot have more than 30 - 60 seconds of downtime when I run it in production. This ...
0
votes
2answers
4k views

What is the difference between Schema and Database in Oracle?

In oracle, Datafile are system files where actual data is stored.The collection to datafile make Tablespace and atlast database is collection of tablespaces Correct me if I am wrong on the concepts ...
1
vote
2answers
153 views

Inner Join Performance

This is my first question on this forum, so be patient... My question is about the most efficient way to build a query on the following table: create table OpenTrades( AccountNumber number, ...
0
votes
0answers
33 views

How to replicate an Oracle 11g DB on AWS

Our client gave us an RMAN back for Oracle Enterprise 11.2.0.3 and we wanted to replicate it on AWS We are unable to do so because the default AWS server runs 11.2.0.1 and we do not have a licensee ...
2
votes
4answers
2k views

Why can't I drop this Oracle datafile - even though it seems empty?

This system is Oracle 11.2.0.3.0, using ASM. We had an issue where there seemed to be a corruption issue of some kind - every time a row tried to get inserted into the table, we'd get the following: ...
0
votes
0answers
233 views

Archive Logs not applied on Primary Database

I have a oracle database and some archive logs in the primary database have not been applied. When I run SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG order by SEQUENCE# I get the following ...
0
votes
0answers
138 views

INDEX SKIP SCAN performance on Index where first columns only contain 1 value

We're running an Oracle 11.2.0.3 database and have a table with above 10 columns in it. There is a non-unique index over all these columns. For simplicity in this example, lets assume the columns are ...
1
vote
1answer
1k views

Object changed during datapump

If some object is being changed when data pump is run how will that object go into datapump file?
0
votes
0answers
91 views

Oracle after insert trigger vs update performance in plsql block

I want to know whether an after insert trigger is better than an insertion statement followed by update statement in plsql block.
0
votes
1answer
5k views

ora 20001 error in oracle dbms scheduler

i have written a test job like begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_job' ,job_type =>'plsql_block' ,job_action => 'null' ,enabled => true ); end; / after a while when ...
2
votes
1answer
1k views

ORA-00922 encountered in Oracle 11gR2 installer

I've just run the installer for Oracle 11gR2 on a Windows Server 2008 (64-bit) OS. I encountered the "ORA-00922: missing or invalid option" error at the last stage of installation when it was doing ...
2
votes
0answers
533 views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
1
vote
1answer
989 views

Oracle 11gR2 + RedHat 6.5 cannot start sqlplus

I cannot start sqlplus I've read everything I found, tried everything and still I am getting "command not found" I have a user oracle, I did export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 ...
0
votes
1answer
72 views

SYSDBA privileges of viewing users table

Is there anyway which would restrict sysdba from watching the users tables. It sounds ridiculous but we sort of need this functionality. We only want sysdba to act as administrator only, no peeping ...
1
vote
0answers
199 views

Running materialized view refresh in parallel

I have a large materialized view that is refreshed periodically (complete refresh) and I would like to do it in parallel. I can already run the query part in parallel but the problem is (much slower) ...
0
votes
0answers
148 views

Strange behavior with context index on matarialized view

We are experiencing a very strange behavior with a materialized view on oracle. Here is the statement that we've used to create the materialized view: CREATE MATERIALIZED VIEW MY_MATERIALIZED_VIEW ...
0
votes
0answers
977 views

Uninstalling Oracle Database Products: Which & How to?

Long time reader, first time poster. For our client's project we are using Oracle 11g. It's a simple C# web application so we are using Oracle's most basic components. Now my project team has been ...
0
votes
0answers
528 views

Impdp over DB_LINK failing with ORA-31631

I am getting below error message while trying to execute impdp between our SIT and UAT environments: ORA-31631: privileges are required ORA-39149: cannot link privileged user to non-privileged user ...
1
vote
0answers
299 views

Oracle Scheduled Job Stays in State RUNNING

I have an Oracle 11.2g on which I use Scheduled Jobs to get some regular work done. There are around 15 jobs running 24/7. The time interval at which those jobs run varies between 1 second for some ...
1
vote
0answers
108 views

plsql procedure gets invalidated

procedure involving dblinks gets invalidated regularly .we need to recompile every time.How to find what is causing the problem in my case procedure p1()--resides in db1 is begin .... select col1 ...
0
votes
0answers
1k views

Oracle 11g Instance that won't start

I'm in need of some help with an Oracle 11g instance that won't start. First of all, this is development instance so if it won't start it's not the end of the world, but it does have some useful data ...
5
votes
1answer
167 views

Why does the CBO not chose a lower cost skip scan without stats?

In the script below, the CBO chooses an INDEX FAST FULL SCAN over an INDEX SKIP SCAN (this is illustrated by the queries with the UNION ALL but you can demonstrate it is true with just explain plan ...
0
votes
1answer
92 views

MS Access migration from Oracle to SQL server?

Let me start off by saying I'm relatively new to databases etc. I have been asked to undergo a project is which I will attempt to migrate about 100 or so existing MS access 2003 databases from using ...
1
vote
1answer
2k views

First query running in PL/SQL Developer results the error

When I run first query in PL/SQL Developer I got the error: Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable statistics in the preference ...
0
votes
2answers
672 views

How can I limit a hierarchical query to the point where there are multiple children?

This question is related to my previous question about hierarchical queries. I have a hierarchical query in Oracle 11gR2 that returns something like this: - Level 1 - Level 2 - Level 3 - ...
2
votes
2answers
2k views

How can I select rows from a hierarchical query with the lowest level?

I have a hierarchical query in Oracle 11gR2 that returns something like this: Parent (Level 1) Child (Level 2) Grandchild (Level 3) Child (Level 2) Grandchild (Level 3) Grandchild (Level 3) ...
2
votes
2answers
439 views

SQL query for next occurrence of specific date

I am working on a function for our database that contains contract data. Each contract expires on a certain date, and then each contract has an expiration type that determines what happens after that ...
0
votes
0answers
182 views

Problem with a trigger (Oracle 11gR2)

I converted the trigger into a "Compound" trigger; this is my first attempt using a compound trigger. Here is my new code: --select * from user_errors; CREATE OR REPLACE TRIGGER ai_fin_transaction ...
0
votes
0answers
152 views

Where can I download jvm files for oracle on ubuntu

I want to install Java packages for oracle, and I found following files in the internet. @?/javavm/install/initjvm.sql; @?/xdk/admin/initxml.sql; @?/xdk/admin/xmlja.sql; @?/rdbms/admin/catjava.sql; ...
3
votes
1answer
6k views

Oracle Automatic Memory Management - SGA_MAX_SIZE

When using Automatic Memory Management, what value should SGA_MAX_SIZE be? Should it be 0? These are my current settings, and I'm unsure whether to leave SGA_MAX_SIZE or set it to 0. ...
1
vote
1answer
1k views

ORA-12516 but max_utilization not reaching limit

Our app began to raise ORA-12516, TNS:listener could not find available handler with matching protocol stack errors, and I'm trying to diagnose why. The workload has not changed, so I think we might ...
1
vote
3answers
5k views

Installing scott schema for oracle 11g express

I want to install scott schema, a sample database in oracle. But in express edition, I can't find out it. Please help me install it on Oracle 11g express. I'm a newbie, pls help me
0
votes
1answer
41 views

Why is the OCR&Vote disk group servicing SCAN name

I have installed 11g R2 Grid Infrastructure followed by database software only installation. I have not created any database yet. When I open asmca->diskgroup, I can see the diskgroup which I have ...
0
votes
2answers
10k views

TNS-12535: TNS:operation timeout

I have Windows Server 2008 R2 with Oracle Client 11.1.0.7.0 client installed. TNSPing to 100% available databases (accessible from other machines, i.e. I can do TNS ping to these databases from other ...
1
vote
0answers
85 views

Oracle forms and report 6i compatibility issue

Please advise,is there any compatibility issues with windows server 2008 64 bit and oracle forms and reports 6i? I am being asked to buy a new server with 32bit processors by my support provider. Are ...
1
vote
1answer
93 views

Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?

A database application I'm working with uses Oracle scheduled jobs to perform certain tasks. The DBA insists that hard-coding the schema name in the procedures that organise these jobs improves ...
0
votes
1answer
111 views

Striping IO with datafiles on different physical mounts

I have a server with three directly attached disk controllers. Each of these can provide internal redundancy and IO-striping accross disks, but I'm wondering what is the best way to configure the ...
1
vote
2answers
576 views

Oracle becomes too slow after system crash [closed]

I am using Oracle 11.2 as a database for my application. For this purpose I should import my data (around 100m records) to this database. For this purpose I used SQL Developer. Unfortunately at the ...
0
votes
1answer
2k views

Oracle Enterprise Manager - Where do I find the error logs?

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: In english: "Internal Error has occurred. Check ...
1
vote
0answers
122 views

Multiple handler entries in lsnrctl services output

This what I get for an lsnrctl services. LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-APR-2014 10:01:43 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to ...
1
vote
0answers
2k views

Truncating Table Partitions Containing Data and Global Indexes

I have to truncate a partition (392,000 records) of a table with 20.000.000 records. At the moment, I'm making a truncate table and rebuilding indexes. But the table has 37 indexes and it takes 20 ...
1
vote
2answers
119 views

Oracle result cache behaviour

Oracle by default caching the query results and function results(Buffer cache). I have noticed this with AutoTrace utility, where the physical reads are huge on first execution, but from next ...
0
votes
0answers
36 views

SCAN verification error during 11gr2 installation

Hi All, I am getting the following warning when installing RAC DB (11.2.0.4). Does any one has idea what could be the reason? I have tried to search from Metalink but no help. Can I proceed with ...
0
votes
1answer
155 views

How to change the output encoding of Oracle command line tools to UTF8?

I am using a german oracle 11.2.0g install, which has some command line tools communicating with some non-ascii characters (ü, ö, etc.). These are written out in iso8859-1 encoding, but I need them as ...
1
vote
2answers
63 views

Not able to select the disk during Oracle 11g Installation

Hi All, During the 11g installation on Win 2012, I am not able to select the available disks which are already stamped using ASM. Any idea what could be the reason? I have tried to select using ...
0
votes
2answers
78 views

Hide zero hours and minutes with NLS_DATE_FORMAT

I'm currently using date format: alter session set nls_date_format = 'DD.MM.YYYY HH24:MI'; The (cosmetic) problem is that this always displays time even if it's zero, for example: "27.03.2014 ...
1
vote
0answers
42 views

is there a DB client which supports oracle editions?

We are using a clever feature or oracle 11gr2 called edition-based redefinitions. This means each stored proc and view looks different depending on the edition you set in the session. There are ...
0
votes
2answers
59 views

CASE_SENSITIVE on ORACLE DB

I have a ORACLE DB and when i try inserting "INDIA" and "india" as values into column which is carrying unique constraints on it , it is allowing the value to insert . It looks like case sensitive ...
1
vote
1answer
3k views

How To Export-Import Database in Oracle 11g(Application Express Edition)?

I am beginner in Oracle 11g. I have created a database in oracle 11g(Application Express). I want to export this database with all data(whole workspace) and import this to another computer where I ...
3
votes
1answer
112 views

connection issue / Oracle Express 11g in windows7 32bit

I have an issue with Oracle Express 11g in windows7 32bit. Everytime when I try to conncet to the database I get this error message. How can I fix it please!