Good afternoon,
I'm in 9i. Has someone an explanation to this discrepancy ??:
SQL> select count(distinct dbms_rowid.rowid_block_number(rowid)) blocks
 2  from tname;

We have a query that performs lots of logical I/O's. Here is the stats
part
of a tkprof analysis:
call     count       cpu    elapsed       disk      query    current

                I just wanna know is there any way to load LOB data
from a file into Oracle table using SqlLoader? I have gone through the
docs which says something about the LOBFILE parameter. but i am not
able to frame my control file properly.

I'm using Oracle 9i and I have some stored procedures returning
Cursors. I'd like to test a SP by just calling it an see if there
is a result in the cursor. The problem is that in some cases I
don't know the format of the result cursor or in some cases the

I desperately try to understand why appears a merge cartesian join in a
query
changing the select fields.
The query is

how is it possible with Oracle 10g to get whether the actual sysdate is
in summer or in winter time?
Does anybody know about a good description regarding Oracle10g and the
daylight saving technics?

It's a given already that 10.2 has so far been kind of a slow rollout
by oracle in terms of delivering the product to various platforms.
Absent so far are ports to sun x86 and the mac os.
Is oracle still going to deliver the product to these platforms?

Hi, all.
I'm working through a bunch of scenarios in RMAN 10g (AIX5.2). I've
done backups, restores, partial recoveries, all work fine.
I'm trying to do TSPITR. I'm unable to get RMAN to restore only to a

I am trying to estimate the amount of swap/memory i have to use in my
hp-ux box running several oracle instances.
I think that this issue is very related to the number of concurrent
users and the activity of them in the database.

My firm bought a new machine with 4 procesor - we had a machine with 2  
procesors . Which parameters on init.ora should I change when I install  
ORA and import database to new machine ? Or somewhere else ? OS is  
SunSolaris , Oracle is 8.1.7.

I am working on an Access 2002/Oracle vba automated overnight process.
The problem is there is one user with rights to a certian set of tables
and another user with a certain set of tables.  I can't run the
overnight process with just one login.  Currently, I am having problems

I am trying to setup a single table stream and get to the point where I
have to setup supplemental log data for that table.
alter table ub_objects.test add supplemental log data (all) columns;
ERROR at line 1:

Top 5
Event            Waits        Time (s)    % Total Elapsed Time
latch free        6,788,898    334,102        69.52
CPU time                145,702        30.32

Hi newsgroup,
I'm in charge of installing an _experimental_ grid environment using
Oracle10g on SLES9.
Sadly I'm new to Oracle at all and now several questions arise.

I installed Oracle Data Miner on Linux platform (oracle data mining
option in Oracle database + Oracle data miner software), but oracle
data miner can not establish a connection to oracle database server. i
followed the instruction for installation and configurations but i do