Questions tagged [Oracle] (487)


The reason for the error ORA-04030: out of process memory?

Good afternoon. The question is not as simple as it may seem at first sight.. Have an environment Solaris x64. There is one (or at least should be one) instance of Oracle. RAM: 132Gb Trying to put these parameters: DB_CACHE_ADVICE = 'OFF' NLS_LENGTH_SEMANTICS = CHAR MEMORY_MAX_TARGET = 0 MEMORY_TARGET = 0 SGA_MAX_SI...
april.Heaney asked October 14th 19 at 11:57

Oracle Solaris as a router small network

Good day Prompt please, in what side to dig, in order for Oracle Solaris 11 raise the router small network. If with Linux it all clear — to raise the squid, iptables to raise, to lift dhcp, to allow forwarding of some ports and open ports 3128 and 63 on the internal interface, then how to do that in Solaris is unclear. For...
Shyann_Gulgows asked October 10th 19 at 14:25

Should the ClassLoader to be thread-safe? Does it make sense to cache the loaded classes?

In Java there is such a thing as a's Classloader, but the method defineClass() it is not synchronized, as well as methods findClass() and loadClass(), which is strange, because different threads can access these methods at the same time, resulting in re-downloading for example. Is it worth doing a custom loader is thread-sa...
Trudie.Kuphal asked October 10th 19 at 14:18

Oracle SQL, PL/SQL

In order to successfully pass an interview at a firm where I really want to get, I need to brush up on SQL. Specifically — Oracle SQL and PL/SQL. Advise the literature on this topic. The current state of knowledge — can write a simple query. No depth. Thanks for the replies.
sandra asked October 10th 19 at 12:29

and generally have all or we can hope that will come to life?

actually yesterday I tried to register there, but never happened :( z.s. what are these services and to fully supported NetBeans'ω, as
verona asked October 10th 19 at 11:11

Fail Over cluster on Windows Server 2008r2 and Oracle Fail Safe Manager

Faced with the task of setting the project on a Fail Safe cluster on the following tools: Windows Server 2008 (already configured a Fail Over cluster of two nodes) and 11g2 Oracle Standard Edition One. As far as I understand, Fail Over OS-level must deal with starting and stopping services. Why, then, provides a special to...
Aida_Tro asked October 10th 19 at 11:10

Tell me a good tutorial on Oracle

It is necessary to start to study Oracle database and immediately the question arose, what book will advise to study with 0 for beginners and it is desirable in Russian.
ryan44 asked October 10th 19 at 10:09

Oracle XE 11 BETA available for download?

Question: Do I understand correctly that nowhere, except in Q&A I'm this place I can not? Oracle XE 11 BETA available for Of Goodies — 11Gb of user data, and the kernel 11.2. The rest differs slightly: 1. 1Gb memory 2. 1 core/1 CPU 3. 1 copy 4. The lack of h...
conrad_Bernier asked October 10th 19 at 08:19

HELP: How to work with large amounts of data? Oracle or Mysql?

There is a mysql database, it is innodb table of 120 million rows and all eeedddiiieee works. Wrote a procedure, the cursor iterates through the data portion (1 million) from a large table, for each record making 10 simple queries by using the index keys in the same table if the condition passes, then an entry is inserted ...
hugh_Kun asked October 10th 19 at 02:45

Auto import data in a DBMS (Oracle or MS SQL)

Hello all, and happy / happy! :) Plz tell me the simplest way to automatically import text data to hard structures such as records in a DBMS (Oracle or MS SQL). The data being compiled in a text file on a network drive and would like to obtain them automatically in the database for further analysis.
Noel_Halvors asked October 10th 19 at 00:38