Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kknight2046

  1. kknight2046

    analyze table after insert a large number of records?

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

    analyze table after insert a large number of records?

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

    how to write SQL hints for this query?

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

    Is it correct for oracle locking

    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)...
  5. kknight2046

    Is it correct for oracle locking

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

    Is it correct for oracle locking

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

    Is it correct for oracle locking

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

    Fetch size for CLOB data with Oracle JDBC

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

    too many user_free_space records

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

    too many user_free_space records

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

    Configure log4j properties: not append but create a new file

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

    Remove -Djava.compiler=NONE option for remote debugging?

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

    -Djava.compiler=NONE didn't disable JIT in Java 5

    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) {...
  14. kknight2046

    Where can I find the documentation for java application launcher ?

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

    charset collate problem in Java program using java.sql

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

Part and Inventory Search

Back
Top