Search results for query: *

Thank you for your replay, jimirvine! What's the full name of P&T manual? I searched it on tahiti.oracle.com, but didn't find it? What is the keyword I should use to search? Thanks.

For performance purpose, is it a good practice to execute an 'analyze table' command after inserting a large number of a records into a table in Oracle 10g, if there is a complex query following the insert? For example: Insert into foo ...... //Insert one million records to table foo. analyze...

The query is like: select * from foo, t where foo.name in (select name from bar where id in ( select id from car where date < sysdate ) ) and foo.a = t.b; I want the innermostsubquery 'select id from car ...' to be executed first, and the subquery 'select name from bar ...' to be execute...

jimbopalmer, many thanks. Your reply makes things clearer to me, but I still have a confusion. I wrote another example: First, create table test (id number); Then, I started two transactions: Transaction 1 Transaction 2 Time1: insert into test values (1)...

One thought: In the statement, "A query in a transaction can see the changes made by previous DML statements in the same transaction, but cannot see the changes of other transactions begun after its own transaction.", does 'its own transaction' means the query transaction or the transaction the...

In fact, Transaction 1 is a transaction, because by default the setAutoCommit is set to false in my sqlplus. To make my example less confusing, I rewrote the example: First, create table test (id number); Then, I started two transactions: Transaction 1...

I found one statement from http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/consist.htm#i5704 that is very confusing: "A query in a transaction can see the changes made by previous DML statements in the same transaction, but cannot see the changes of other transactions begun...

I was told that when fetching rows which contain CLOB columns using Oracle JDBC, the fetch size is always set to 1, no matter what fetch size you set in the program. Is it true? Can anyone give me a URL that discusses this problem? For example, the following code fetches CLOB rows from a...

I just wonder whether there is some configuration option that segments the tablespaces into small pieces.

I used "select count(*) from user_free_space" to see how many user_free_space records are in a 10g DB. The result is 20000+. But, on several 9i databases, the total number of the user_free_space records is only several hundred. Why there is such a big difference? Thanks.

I have a question about how to configure the log4j properties, so each time the application starts, the log file will be cleaned up first, instead of logs being appended to the existing log file content. My configures is like below...

To enable remote debugging, we launch the java application using the options: -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=4000 -Xdebug -Xnoagent -Djava.compiler=NONE The '-Djava.compiler=NONE' option slowed down the application, since it turned off the just-in-time compilation. My...

The -Djava.compiler=NONE option is supposed to disable JIT. But my experiment showed that -Djava.compiler=NONE took no effect in Java 5. Here is the program Main.java: public class Main { public static void main (String [] args) { for (int repeat = 0; repeat < 25; ++ repeat) {...

Where can I find the documentation for java application launcher for java 6? I want to know the full description of the java options. I went to http://java.sun.com/javase/6/docs/technotes/tools/windows/java.html. But it doesn't seem to be a full description of the java application launcher. For...

I defined one field in one table with a special charset collate setting: `name` text character set ascii collate ascii_bin NOT NULL I wrote a Java program use java.sql to retrieve data from the 'name' field. But the statement: name = rs.getString("name"); returned some garbage like...

But, I still want the user have the write privileges on the other 99 tables. I only revoke the write privileges on the table 'a' for the user. To address this problem, is it a right way that I grant a select privilege on the table 'a' for the user?

There are 100 tables in a database, named 'db'. I want to make one table called 'a' readonly to a user 'tom'. How can I make it happen? Previously, I used grant command to assign ALL privilege to the user: grant ALL on *.* to tom@% Thanks.