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
18 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question ...
0
votes
2answers
32 views

Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?

Oracle has a favorite numerical class called NUMBER. It is a 22 byte value that just seems ludicrous in an index. I have some values that would easily fit in a 6 byte integer and would therefore fit ...
0
votes
0answers
6 views

Only 'SESSION REC' in ACTION_NAME column

I was asked to generate a report of operations performed on certain Oracle 9i tables in a given period of time. When I query the DBA_AUDIT_TRAIL table I only get SESSION REC in the ACTION_NAME ...
0
votes
1answer
34 views

Can Oracle have too much RAM?

Our database is slow in some very important use cases. I have traced it to a problem with some queries performing full text searches and single row accesses on a lot of records (db file sequential ...
1
vote
0answers
21 views

Oracle listener configuration

I have oracle 11.2.0 installed on linux. And I have arcgis server 10.2 on the same machine. I created an geodatabase. But when i try the sde functions like sde.st_asText i got: -ORA-28575: unable to ...
0
votes
0answers
13 views

ORA-19809 & ORA-12560

Following some maintenance on our server (change raid battery + reboot) my database (Oracle 11g) is not available anymore. I m a newbie in Oracle and I have been through the forum and I can t find the ...
0
votes
0answers
16 views

Oracle database as a single synchronization point for two separate web applications [migrated]

I am considering using an Oracle database to synchronize concurrent operations from two or more web applications on separate servers. The database is the single infrastructure element in common for ...
1
vote
0answers
33 views

Oracle: built in SQL pretty-print?

Oracle has some packages that will dump objects in SQL format, such as dbms_metadata.set_transform_param. One option that can be set is to "pretty print" the SQL. Is there anything in Oracle that ...
-3
votes
0answers
35 views

Whats is the maximum size a relational database can handle before considering switching to a NoSQL database [on hold]

Whats is the maximum size a relational database can handle before considering switching to a NoSQL database? How much oracle with partition can store? What should I consider in my analysis?
-2
votes
0answers
28 views

How to check state of oracle databse [on hold]

I have error during starting database - corrupted file. I want to chcek state of database if its mount or nomount. V$database open_mode is not avaiable because db is not open. My db is 11.2.
0
votes
1answer
44 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. ...
-1
votes
0answers
32 views

Why connection in sqldeveloper to machine in the same network fails? [on hold]

I have windows machine with Oracle DB XE 11.2. When I start sqldeveloper on the other windows machine, use the same credentials and put as hostname ip of machine with DB, sqldeveloper cannot ...
0
votes
0answers
37 views

Slow running Oracle query caused by unnecessary full table scan

I'm by no means an expert with Oracle, but I know enough in terms of how to analyze explain plans and perform basic optimizations. However, this time, Oracle has stumped me with it's explain plan. ...
0
votes
0answers
35 views

Script to automatically Identify tablespaces above threshold and bring it back to below threshold value

I am facing all the tablespaces crossing threshold problem in all most all the databases we have in our environment. Because of this much manual effort is been needed. I am able to identify the ...
0
votes
1answer
36 views

Stack trace of oracle sql execution

Is there a way to get the stack trace of the SQL query that is given in awr, I mean a way to check the flow of the query from which package or procedure that it has been triggered? tkprof and awr both ...
0
votes
0answers
13 views

Best way to insert html content into clob column in oracle [on hold]

I want to write a stored procedure to save html content into clob column of a table. sample html text below: <p font style='font-size:12px;' face='Arial'> Last modified: April 30, 2014 (<a ...
0
votes
0answers
22 views

alter database open - Oracle11g [on hold]

Because of some issues i had faced I'm trying the below query on oracle 11g. But its throwing error. Could anyone please help Query:alter database open ERROR at line 1: ORA-00600: internal error ...
0
votes
0answers
20 views

ORA-01033: ORACLE initialization or shutdown in progress [on hold]

I'm facing the below error while trying to login to database. Oracle services were up and running but was not able to login. Error:ORA-01033: ORACLE initialization or shutdown in progress I tried to ...
0
votes
0answers
29 views

In USER_INDEXES but not in USER_IND_COLUMNS

I can't believe I don't know this but what type of index (Oracle) would have an entry in the USER_INDEXES view and not in the USER_IND_COLUMNS view? I see two system entries in USER_INDEXES. Here is ...
3
votes
1answer
29 views

Migration From Oracle to PostgreSQL Encoding Errors

I'm working on migrating data from an oracle database to a postgresql database. I running into a problem where I export the data from oracle, using sql developer, and importing it into postgresql. ...
0
votes
0answers
16 views

Toad Error using Proxy Connection

I created a login for a user two days ago to an oracle database and altered another user so this new user could do a proxy connection as that user. Everything worked fine that day and the user was ...
0
votes
1answer
38 views

SQL select with unique_list - losing an item

I have an oracle database and I have the following problem: If I make an select like this: SELECT fk_proddes_id,fk_id_cod_deseu, LISTAGG (TO_CHAR (cod_eliminare), ',') WITHIN ...
1
vote
2answers
42 views

Compressing partition - what about index?

To save space on disk I want to compress some partitions of my tables: alter table TEST_TAB move partition TEST_TAB_2014 compress for all operations; I have also indexes on this partition. Should I ...
0
votes
1answer
22 views

oracle database - sql for counting the columns with the same id with the one in current row

I have an oracle database and a few tables and with this query: select rap.DENUMIRE,a3.ID,op.FK_ID, (SELECT COUNT(*) FROM ANEXA3_TABEL1_ROWS) AS count from ANEXA3_TABEL1_ROWS a3 inner join ...
0
votes
0answers
34 views

Oracle query optimization time

Is there any way to get how long it takes the optimizer to optimize a query in Oracle?
0
votes
0answers
19 views

Accounting Program Error [closed]

I have Oracle Application R12 running on 11g. The error occurs in Accounting Program when we are running Create Accounting session in Payable Module. When we click on Diagnostics it gives this ...
0
votes
2answers
34 views

how to prevent any update to my database before a exp operation?

I want to migrate my database from AIX to Red Hat vai exp/imp. how to prevent clients make any update to my database during the migration progress ?
0
votes
0answers
12 views

RMAN multilple channels

When to use multiple channels in RMAN? Is it effective only when backup is performed to multiple physical disks or tapes? I've found only that every channel is different session opened by RMAN in ...
-1
votes
1answer
24 views

Return Distinct Set of Values Based on MAX Date

I'm new to SQL and I am really struggling to put a specific query together. Let me start my question by explaining what fields & tables I am dealing with. Table A Table B The unique key is ...
0
votes
0answers
22 views

hierarchical query

I have a Oracle table that has child and parent rows similar to the example below P_JID has the parent's JID, it can go as far as 4 levels JID P_JID NAME STATUS ...
0
votes
0answers
20 views

Unable to open display to specific user in Red Hat 6.4 [closed]

I am trying to install Oracle database 11g in my Red Hat 6.4 and the installer abort with a warning followed by a error message: Warning ">>> Could not execute auto check for display colors ...
0
votes
1answer
33 views

Is there any way to trace the optimizer's work in Oracle?

Just like the MEMO structure in SQL Server which is kind of a "paper trail" of steps the optimizer takes in optimizing the query, is there anything in Oracle through which I can see what are the ...
6
votes
2answers
74 views

What is an Oracle ASSEMBLY?

What is an Oracle ASSEMBLY, in the context of Oracle SQL? It's listed in GV$SQLCOMMAND. Although GV$SQLCOMMAND is not a perfect guide to "real" SQL statements - for example it has UPSERT instead of ...
0
votes
1answer
32 views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 ...
0
votes
0answers
22 views

Oracle user in DBA_USERS_WITH_DEFPWD but not user tables/views [closed]

Oracle documentation says that "DBA_USERS_WITH_DEFPWD displays all users in the database that are still using their default passwords." So what does it mean if there is a user listed in the ...
0
votes
1answer
50 views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
0
votes
1answer
28 views

Oracle can't drop index with . in name?

I am trying to drop an index that has a dot(.) in its name and can't seem to do it (I'm logged in as the SYSTEM user, which owns the index). Any ideas? SQL> select index_name,owner,status from ...
0
votes
0answers
24 views

Sql*PLUS: Output each field as a new line

Right now the configuration I have is the following: set pagesize 0; SET NULL *NULL*; SPOOL output/output.txt I am outputing the results to a text file in order to run a function on the file to ...
0
votes
1answer
54 views

How to restore 11gR2 fullbackup to 12c database in rman

I need to transfer my database from Oracle 11gR2 to 12c database. It will be in same computer. I took full backup of Oracle 11gR2 database. Then I remove Oracle 11gR2. I installed Oracle 12c and I ...
0
votes
0answers
32 views

Monitoring active query step using only pure sql

I would like to monitor actively running query on Oracle. What I mean is to gather info about: Actually running step. (What is currently db engine doing in this query) Actual query plan used in ...
0
votes
1answer
22 views

Select max value from many to many tables

i have next tables in may data base: I want to select the book that has the max number of pages for each author. I did this : select auteur.nomauteur, auteur.prenomauteur ,livre.Title, ...
0
votes
1answer
22 views

migration of oracle xe 10 to xe 11 fails with wrong paths used in the import

I'm following the documentation to upgrade an OracleXE 10.2 database to OracleXE 11.2. The export succeeded without any problem, the import (on another machine with XE 11) fails though. The log file ...
1
vote
0answers
43 views

How to identify concurrency issues in Oracle 11g?

For a short period in time we had a concurrency issue that lead to subsequent faults in our application (Java, Spring, Hibernate). Since we are using dictionary managed tablespaces, I first thought ...
0
votes
1answer
21 views

What is the query to get the process limit on Oracle 11g?

I'm getting the error: Maximum Number Of Process Exceeded I want to see (using a query) what the setting is in my database for the process limit. My question is: What is the query to get the ...
0
votes
1answer
42 views

Sql*Plus ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

I installed Sql*PLUS on a cloud Oracle Linux Environment in order to access an remote database. I used the installation instructions provided as an answer here: ...
2
votes
0answers
24 views

what is causing the reads in this configuration?

i have a setup here where we use a Solaris 10 x86, zpool for oracle12c-redo-log using mirrored disks and mirrored ZIL. logbias="latency", recordsize=128: pool: xxxxxx01_redo00 state: ONLINE scan: ...
0
votes
1answer
25 views

Replace nested “select with count” with outer join? is this possible?

SELECT c.classid , c.classname , (select count(s.id) from students s where s.classid = c.classid and status = 'failed') as noOfFailed, (select count(s.id) from students s where ...
1
vote
0answers
19 views

SQL - Optimize table population with dynamic queries

I need to optimize the following pl/sql procedure. So, fundamentally my question is: There is a way you can do a bulk insert in a pl/sql that could be more efficient than loop through an associative ...
0
votes
2answers
33 views

Failed to connect to oracle SQL Plus [closed]

I tryed to connect to SQL Plus as the admin "System", I'm sure that the password I wrote was correct but the connection failed. I also tried to connect with Scott/tiger but it failed as well. What can ...
3
votes
0answers
33 views

Can an active session in oracle be dead?

I have a time consuming query which populates a materialized view. It has been running for 18 hours - which was not expected. SELECT STATUS FROM V$SESSION WHERE SID=194; The above query shows the ...