Database » Ask Tom MOST RECENT ARTICLES

« Expand/Collapse

Ask Tom MOST RECENT ARTICLES (10 unread)

October 13, 2008
11:17
using dimensions for query rewrite
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Hi Tom, I have one question about dimensions. Is a dimension some metadata about dimension tables in my star/snowflake schema, or can dimensions be used for query rewrite. Can you briefly explain (or provide some example)? Thanks a lot....
11:17
Can I do mutlithreaded programming in PLSQL
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Can I do multithread programming in Oracle proceudres? By the way, I think dbms_pipe has similar functions as dbms_alert's signal functions, what's the difference? Which one is much better if I want to use them to write a program which ...
October 10, 2008
1:26
Is there a way to convert the 0.12 to 0.15 , 0.16 to 0.20 etc decimals
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Hi I have the following data 1.11 0.11 0.99 0.14 I need to round this value to the following values 1.15 0.15 1.00 0.15 can you help me out in getting a solution for the same. Thanks in advance. </code>
October 09, 2008
3:40
Multiple concatenated column indexes or single column indexes?
» ‎ Ask Tom MOST RECENT ARTICLES

When I design tables, I've always added indexes to the columns that were used in WHERE clauses in queries. If the columns were used in multiple WHERE-clause combinations, I index each one of the columns that are being used. I found an application w...
October 07, 2008
12:46
Indexes require recreation post IBM Global Mirroring
» ‎ Ask Tom MOST RECENT ARTICLES

Tom, Env. Oracle 9.2.0.7, HP-UX 11i, SAN IBM-DS8100. We implemented IBM's Global Mirroring for our DR process. I'm not sure if this information is relevant, but never the less i thought of posting it. Global mirroring is basically 1. Cr...
October 04, 2008
0:08
Steps to follow when migrating from a lower to higher version
» ‎ Ask Tom MOST RECENT ARTICLES

Tom, Could you just point out the steps or thing to be considered when migrating from a lower version to higher version? Just an example, when migrating from 9i to 11g. I have seen many articles, but none of them say very clearly what to do step b...
0:08
Inserts with APPEND Hint.
» ‎ Ask Tom MOST RECENT ARTICLES

<code>insert /*+ append */ into t select rownum,mod(rownum,5) from all_objects where rownum <=1000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- -----...
0:08
Investigate Wait events & Poor response times using Statspack report.
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Hi Tom, Here is Statspack report that was obtained when the end-users complained about the poor reponse times in the system. Please advice on the following: (1) The Top wait event i.e. Latch Free. (2) Latches Activity. During this peri...
0:08
questions on LONGS
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Can you perform string functions on the datatype LONG? </code>
0:08
Determining which query caused deadlock.
» ‎ Ask Tom MOST RECENT ARTICLES

<code>Our application is causing deadlocks. After doing research I'm almost certain it is due to not having an index on a couple of foreign key columns. *** 2002-11-04 09:17:47.998 *** SESSION ID:(12.346) 2002-11-04 09:17:47.960 DEADLOCK DETE...

← $Pete Finnigan's Oracle security weblog Databases News →

Database » Ask Tom MOST RECENT ARTICLES

Feeds

Ask Tom MOST RECENT ARTICLES (10 unread)