I'm doing some investigations
because of query plan changing in the same session (from NL Index RS to
HJ FTS), and got question about Hash_Join_Area_Size when
work_area_policy=auto.

oops, accidentally posted this to .misc...
In sqlplus you can shutdown a node in a rac cluster via
   connect sys@node3
   shutdown immediate

In sqlplus you can shutdown a node in a rac cluster via
   connect sys@node3
   shutdown immediate
Is there a way to start up a node as well?

Why is it so hard for Oracle to give proper documentation, instead of
putting hundreds of columns into their V$ views that even they do not
understand.
I want to know 1 thing:

Greetings from SQLSTAR!!!!!
We are happy to Announce that SQLSTAR in now authorised by Oracle to
conduct 10g New Features just @ Rs:8000/- *
--

I had a disk failure so that the databases (ASM and actual database)
cannot see the disks.  Therefore the diskgroup DATA is unmounted and
cannot be remounted.
I'm ready to start over from scratch, I dropped the non-ASM database,

If I connect to scott/tiger@FOO, is it possible to get
a copy of the FOO TNS definition?
I'm doing some connection testing, and I want to print
out TNS of the current connection so I can verify I'm

Current:Grid Control 10.2.0.4
Proposed: HA Grid Control 10.2.0.5 on new servers (using Load
Balancer)
We have historical data in our current grid db repository. Anyone know

We are developing an application in Oracle 10.2.0.3.0.
For the sake of performance we are using a materialized view which
contains denormalised data for Items.
There is a Comment table to keep a history of all comments for Items.

All of the examples for table functions I have come across use an
object type declared at schema level.
Is it possible to use table functions within a package using types
declared in pl/sql only.

this question pertains to 10.2.0.1 +
Say we have a database which runs on a server which is ALWAYS set to
GMT.
We have users of a web application in two timezones - say today this is

I used to use orana.info blog aggregator to remain of top ever increasing
number of interesting blogs. I first noticed that it skipped the recent
interesting notes by Jonathan, like "Hints on Hints" or "One SQL". Also
Tanel's note about free DBA_HIST AWR views in 11g wasn't ...

Is there anyway to use a tablename in subquery like this:
SELECT * FROM ( SELECT tablebame FROM TABLE);
Thanks.
Jia Lu

iam getting the following error while importing the dump in 10204.
illegal lob length marker 65279
bytesread = 00000000000
TABLE = CHK_RSLT

I'm looking at some Oracle documentation and they are not really clear
on that the following items are in V$SESSION & V$PROCESS:
V$SESSION - process
V$PROCESS - pid & spid