Questions tagged [Oracle] (487)

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...

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...

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...

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.

actually yesterday I tried to register there, but never happened :( z.s. what are these services and to fully supported NetBeans'ω, as kenai.com?

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...

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.

Question: Do I understand correctly that nowhere, except in Q&A I'm this place I can not? Oracle XE 11 BETA available for downloadwww.oracle.com/technetwork/database/express-editio... 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...

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 ...

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.