Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

0
votes
1answer
56 views

Database Configuration In DB2 and Oracle

what is the equivalent in Oracle for these field (taken from DB2)? Interval for checking deadlock (ms) (DLCHKTIME) Lock timeout (sec) (LOCKTIMEOUT) Thanks,
0
votes
0answers
31 views

How can I calculate database disk usage in Oracle? [duplicate]

I'd like to get the real disk usage of a database, i.e. the amount of megabytes or gigabytes (could be any) that the tables use with all of their respective rows.
1
vote
1answer
397 views

Oracle OS Authentication only works on certain databases/clients

We currently face a problem where Oracle OS authentication only works on certain client/server combinations. The environment consists of a development client with its own database server (excluded ...
1
vote
0answers
79 views

Amazon RDS for Oracle Offsite Backup

Am considering Amazon RDS to host our Oracle database. Ideally, I'd like to have my daily backup and as many of the transaction logs as possible since copied to an external location in case of Amazon ...
0
votes
1answer
106 views

What are the side effects of raising the PROCESSES system parameter?

We have a legacy application (ERP) that, because of technical issues, spawns a new OS process (.exe - ms windows clients) for each screen requested by the user. Also, each company branch (> 20) has ...
4
votes
3answers
2k views

OCIEnvCreate failed to create environment handle after installing oracle_fdw

I have installed oracle_fdw successfully. After I create extension oracle_fdw and foreign table it shows the following error. Is this a server configuration problem? --env Oracle : 10.2.0.1 ...
1
vote
1answer
16k views

How to run procedure in Oracle SQL developer

Hello I have a table named CITY in oracle SQL developer, my problem is how to run the procedure -- start the script SET SERVEROUTPUT ON SET LINESIZE 400 SET TIMING ON CREATE OR REPLACE PACKAGE BODY ...
4
votes
2answers
11k views

What is Key Preserved Table concept?

I read in the Oracle Documentation about key-preserved table in Updating Join Views Section. However, I didn't find any simple to way understand it. I hope to receive some simple conceptual details ...
0
votes
0answers
54 views

Logical or in oracle PL/SQL

I have this code: declare error1 number; error2 number; error3 number; begin error1 := 1; error2 := 0; error3 := error1 | error2; -- should be error3 = 1 end; But I dont know how to ...
0
votes
1answer
6k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
0
votes
1answer
1k views

What does enable mean in Oracle DDL constraint?

My understanding is the different between NOT NULL and NOT NULL ENABLE is that the later will also be be applied to existing data in the table. If then you are starting from scratch is there ...
0
votes
1answer
81 views

How do I resolve “ORA-23293: Cannot rename a column which is part of a join index?”

Disclaimer: I am a developer, not a DBA, but this question seems more appropriate for DBAs than for StackOverflow. Now to my question: We have a table in an Oracle Exadata schema that uses a numeric, ...
0
votes
0answers
2k views

ASM drop disk hangs (STATE DROPPING)

I have added disk into the RAC system by the following way: I have disk /dev/sdh1. Marked it as an ASM disk: --On node 1 oracleasm createdisk DISK7 '/dev/sdh1'; --On node 2 oracleasm ...
1
vote
1answer
124 views

How can I delete rows in an oracle table from xml input parameter?

> CREATE OR REPLACE PROCEDURE PRC_OPEN_PERIOD > ( InputXml in VARCHAR2,Tmode in varchar2,pOUT OUT number ) > IS > v_count NUMBER(38) := 1; > v_inner NUMBER(38) := ...
0
votes
0answers
4k views

ORA-03137: TTC protocol internal error

I have 11g 2-node RAC. My alert.log contains several ORA-03137 errors: Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_10679.trc (incident=149362): ORA-03137: TTC protocol ...
5
votes
3answers
6k views

Trouble killing sessions then immediately dropping users in Oracle 11g XE

I would like to be able to kill active sessions by a given user, and then drop that user, and do so within a single database call. Here is what I have so far: DECLARE cursor c is select * ...
1
vote
3answers
901 views

PreparedStatement caching size on Oracle and SQL Server

I understand that PreparedStatements are complied and cached by database servers. I would like to know if all the preparedStatements are complied and cached on the server, in which case what is the ...
-1
votes
3answers
223 views

Recovering Oracle Database using RMAN [closed]

I am an accidental DBA..I have to restore an oracle database using RMAN utility. I don't know anything about backups and restoration and this is my first assigned task. Are there any good forum(s) ...
0
votes
2answers
144 views

Does Oracle RAC require that the Ethernet aliases be in a different IP range than the base addresses?

Let's say I have 3 nodes running RAC. The base addresses (eth0 interfaces) for those nodes are in the 192.168.1.0/24 range. From what I've seen RAC requires that you create Ethernet alias interfaces ...
3
votes
2answers
456 views

General tool to load dump files [closed]

I am a big fan of Postgres both for its price but also for its features. I am going to have to need to upload into it both Oracle dump and SQL Server files. I will try to ask and beg for plain .csv ...
0
votes
0answers
965 views

Oracle profile: PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

Let's say I have configured PASSWORD_REUSE_TIME=1 and PASSWORD_REUSE_MAX=5 for Orale user profile. My initial understanding was that it should prevent the user from using the same password until he ...
0
votes
1answer
43 views

How to find a session with a specific command

I have an Oracle instance with some active sessions from different users. How can I find the SID/SERIAL of a specific session given that this session is surely running a specific SELECT I know?
2
votes
2answers
2k views

Why does the same query run faster the second time I run it?

I noticed when running a SQL query it is faster the second time than the first. So my question is, in Oracle SQL Developer where can you see the statistics that explain this behaviour?
2
votes
1answer
107 views

PL/SQL doesnt return rows

Please help me debug this: Working: When I execute: set serveroutput on declare middle_name varchar2(30); begin middle_name := '0000000231'; for x in ( select ...
0
votes
0answers
93 views

How Oracle DB maintains client identification

I know in 'dedicated server' mode we have one user process for each client and pool of user process in 'shared server' mode. in either case How oracle maintains the client identification ? Please ...
0
votes
2answers
179 views

Return items not found in database in Oracle

I've been given a list of employee names (several hundred), and I need to look them up, and return their employee number. However, the names given are not necessarily exactly as they appear in the ...
1
vote
0answers
1k views

Oracle 11g DBMS_CRYPTO invalid identifier

I'm trying to encrypt a column and I found many tutorials that use DBMS_CRYPTO. However, when I test this, it says DBMS_CRYPTO is an invalid identifier. I was using SYSDBA account. I've searched the ...
2
votes
2answers
122 views

Oracle database Architecture

I need to know to correct order between these following steps, it's hard to find information on the internet on what happens first, i'd be really grateful if someone could give me the answer A. ...
6
votes
2answers
7k views

SQL Server Express vs. Oracle Express Edition vs DB2 Express-C

I have been trying to compare the features of the SQL Server Express, Oracle XE and DB2 Express-C, but find it difficult to compile all the differences into one place. Especially the current ...
0
votes
1answer
134 views

How can I use package classes and call packages from Oracle11gr2 stored procedure in certain schema?

When a stored procedure begins with 4 create or replace procedure user0.import 5 is 6 f1 utl_file.file_type; compiler throws an error Error(6,6): PLS-00201: identifier 'UTL_FILE' must be ...
0
votes
2answers
2k views

How can I change the connection descriptor used by Oracle Enterprise Manager?

I've recently changed the SERVICE_NAME of my 11g database and Enterprise Manager can no longer connect to it: 2014-01-08 10:36:06,047 [HTTPThreadGroup-3] ERROR eml.OMSHandshake ...
0
votes
1answer
926 views

ORA-12899 when inserting from sqlplus, but ok with jdbc

Inserting 'ééééé' into a column defined as varchar(5) runs fine from squirrel sql client (jdbc). But doing the same insert from sqlplus fails with ORA-12899 (too long value). NLS_CHARACTERSET is set ...
0
votes
0answers
1k views

Oracle Transaction recovery: lock conflict caught and ignored

In alert log there are a lot of "Transaction recovery: lock conflict caught and ignored" statements. I've found some information, that this error is caused when there is an active dead transaction. ...
0
votes
1answer
2k views

ORA-01410: invalid ROWID

I get ORA-01410: Invalid ROWID error when executing the following piece of code: DECLARE CURSOR c1 IS SELECT e.empno, e.ename, e.sal, d.dname ...
4
votes
1answer
185 views

Two different databases on the same RAC cluster

We have an Oracle 11gR2 RAC cluster with 4 nodes. 2 nodes are dedicated to one database that's devoted one application and 2 nodes are dedicated to a completely separate database that serves a ...
4
votes
1answer
5k views

Good video tutorials/series for learning Oracle? [closed]

I am a better learner with visual content. Therefore I actively seek video tutorials when I start learning a subject. For oracle below links are my finds. I would like some additions to these. ...
4
votes
2answers
153 views

Virtual Oracle server for education?

I am currently a College Student and am taking an introduction to Oracle 10G. I cannot seem to make it to class all of the time and am curious to ask if there is any Virtual Oracle Server or something ...
3
votes
1answer
182 views

How to become a DBA…the non-standard route (not beginning as sysadmin or dev)? [closed]

Background: I'm a recent BS graduate who's found myself in an extraordinary situation. I've fallen into something of an entry-level Oracle DBA role straight out of the college box. At my small ...
-1
votes
1answer
480 views

What must I already know to get profound knowledge in Oracle [closed]

I've been working with relational database systems for about 4 years, 2 years in Oracle particularly. I've been able to do pretty much everything I've needed so far but I know that the knowledge I ...
2
votes
2answers
10k views

RMAN list archivelogs that are needed for to recover specified backup

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed. Now, I want to determine what archivelogs should I backup to be sure that my ...
0
votes
2answers
2k views

why archived log size is small but fast recovery area still has a lot free space

when recovery database I met a strange problem,my recovery script as follow: RUN { SET UNTIL TIME 'DEC 25 2013 09:00:00' ; RESTORE DATABASE; RECOVER DATABASE; } but rman report as ...
1
vote
0answers
1k views

Oracle 12c Enterprise Manager Database Express Subsequent Installation von Windows Server 2012

I have an Oracle 12c database instance which was installed without the option for configuring the "Enterprise Manager (EM) Database Express" How can i install it subsequent for a running instance? ...
0
votes
0answers
337 views

Execution time vary for the same query

I have a query which looks like this: select * from ORDERDOC, ORDERPOSITION where ORDERDOC.id = ORDERPOSITION.orderId --some other conditions; Execution plan looks like this: 0 SELECT ...
0
votes
1answer
1k views

how to reduce the size of the datafiles of a oracle DB?

we use a oracle db (11g release2) and the undo tablespase exists of two datafiles and requires 48 GB. But we just need this size for the boot and the import. Currently we just use 10 % from the ...
1
vote
1answer
66 views

Oracle DB client request process

Can any body please explain how Oracle DB handles the client request ? is it creates new user process for every connection to db ? I had look in oracle docs, seems there is concept 'Dedicated and ...
5
votes
2answers
846 views

Oracle partition by interval using persian calendar

Oracle supports Persian (Jalali) calendar in DDL queries, I can easily say: select to_char(register_date, 'YYYY-MM-DD', 'nls_calendar=persian') from my_table; I created a table as: create ...
14
votes
3answers
709 views

Oracle is not using a unique index for a long key

I have a table with 250K rows in my test database. (There are a few hundred millions in production, we can observe the same issue there.) The table has an nvarchar2(50) string identifier, not null, ...
1
vote
2answers
176 views

Capturing Table Changes without killing the server

I have an Application that uses Oracle. Among many things, this application has timesheet entry. Supervisors enter their employee's hours, allocating to charge codes, under the appropriate rate ...
7
votes
2answers
423 views

Where to start with Oracle?

This question only needs one answer: a list of great resources for getting started with Oracle, including Database Administration, PL/SQL and SQL. You may find your question has been closed as a ...
-1
votes
2answers
82 views

Partitioning in Oracle 11g

If I alter the partitioning in oracle and trying to retrieval the data,is necessary to mention the partition name or not?