| Ask Tom HOT ARTICLES |
| Put this feed on your website |
| Description: |
These are the questions on Ask Tom that have the most comments |
| Format: |
RSS 0.91 |
| Url: |
http://asktom.oracle.com/pls/ask/ask_tom.hot.rss?p_count=20 |
| |
| Latest headlines |
Ask Tom HOT ARTICLES
|
multi-pass sort
2008-11-12
Dear tom,
I have a question, how does multi-pass sort work, with reference to temporary tablespace.
the following sizes are included to make the example clear.
Suppose the sort_area_size is 1 mb and i have a table t of 1gb.
I give the query as ...
|
Question on CONCAT
2008-11-11
Hi Tom,
Good Morning...
In my Procedure.
<code>CONCAT(<SQL_QUERY>,<CASE_STATEMENT>)</code> is not working
but
<code><SQL_QUER>||<CASE_STATEMENT></code> is working
Why??
|
security of full export or user export
2008-11-11
Tom - a full export is being provided to a new vendor so they may "do something" with it. A concern has been raised that the passwords for all the important schemas will be available in the export - and therefore compromise security of the original ...
|
Is there a guideline to shoeveloper privileges and roles effectively?w how to manage d
2008-11-11
Is there a guideline to show how to manage developer privileges and roles effectively?
|
Index ignored when selecting multiple columns
2008-11-11
Hopefully this is an easy one. I would like to know why an index is ignored when the SELECT clause contains multiple columns. It was my understanding that the index points to the position of the row so that whether you select one column or ten should...
|
ORA-00001: unique constraint (GIGAGAME.PLAYERINFO_IDX2) violated
2008-10-29
Hi Tom
I have problem need to help
My Company RD TESTING FIND THE PROBLEM
ORA-00001: unique constraint (GIGAGAME.PLAYERINFO_IDX2) violated
HOW CAN I RESOLVE PROBLEM
Tks
schema ???
DROP TABLE PlayerInfo;
CREATE TABLE PlayerInfo
(
CID...
|
How to tune access of "fat" tables
2008-10-29
Hello Tom,
I'm working at a client's site who has a data warehouse with partitioned fact tables with about 400 columns. Performance is not too good and I am trying to optimize the system a bit.
The client told me that most of the columns are quer...
|
Reference Information Management
2008-10-29
Dear Tom,
Many times you give link references in the answers.
How do you manage the reference/metadata information?
e.g. Do you categorize previously answered questions around domain (say analytics) then Oracle key-words/functions and their uti...
|
Restoring Stats and Execution Plans
2008-10-28
Hey Tom,
We recently had a query (using bind variables) whose plan flipped after our nightly stats gathering process due to bind variable peeking. We were hoping that by restoring stats to the previous day (on all the tables included in the query...
|
oracle is doing full table scans on a table with raw column and the column is primary key
2008-10-28
Hi Tom,
Thanks for your continuous support.
We have a table with blob data type as one column. We are using secure file option as we are using 11g. We kept the blob column in a seperate tablespace. In the main table we have a column called...
|