AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 45 min 41 sec ago

SQL Plan Baselines questions

Tue, 11/25/2014 - 00:00
Tom, We have an application(situation), where one of the query is performing poor which is written without analytics, when used analytics it was far better. we dont have time to make this code change right now immediately, so thought of using SPM...

Oracle database In Memory

Tue, 11/25/2014 - 00:00
Hello Tom, I seen a new feature for Oracle 12c : In-Memory database cache. I seen it's a new memory area to organize data in column format for BI/DWH queries. I would like to know how Oracle decides when use the data from In-memory area or from...

Number of Connections per GUI

Tue, 11/25/2014 - 00:00
Tom, we are a small software company that has developed a customer-facing Graphical User Interface (GUI) that connects to a customer-hosted Oracle 11g database. This is a two-tier, classic client/server setup. The GUI uses Oracle Data Provider (ODP...

Linguistic Indexes

Tue, 11/25/2014 - 00:00
Tom, Can you explain what is the need for the "Table access by rowid" here? why dont the index act like skinny version of table here? <code> rajesh@ORA11G> create table t 2 as 3 select a.*, object_name x 4 from all_objects a; Tab...

How to get FULL Result Set in a Variable

Tue, 11/25/2014 - 00:00
Hello Tom, We are developing an application internally, for which I am using Oracle PL-SQL. As part of a specific function, I am trying to execute a SELECT * command using PL-SQL, store the output of this command in a variable, and display it. ...


Tue, 11/25/2014 - 00:00
Tom: I am practising "Set DB_FILE_MULTIBLOCK_READ_COUNT to Reduce Full-Scan Costs" from Effective Oracle by design in Oracle 10g database. I am aware that things changes over the version of oracle. q1 - below is what i got from Trace file in 1...


Tue, 11/25/2014 - 00:00
Tom, I was trying to tune one of the sql written in Ansi syntax without toughing using dbms_advanced_rewrite API. but ended up with the below error, Can you help me what i am missing here? <code> rajesh@ORA10G> declare 2 l_src long; ...

Indexes Maintenance in a Managed Hosting Setup

Mon, 11/24/2014 - 00:00
Hi Tom, We have a Oracle Standard Edition installed in a managed hosting environment. The various clients access data pertinent to them using CLIENT_ID column added to each table ( when a client issues "SELECT * FROM MYTAB", it actually becomes...