How can i check table lock in oracle database?

Hi Oracle Gurus, We are experiencing a strange Oracle database
server(Windows 2003) behaviour
When we try to start Oracle database from services -- It does not start
the database and in Oradim.log we see following error -- ORA-12560:

I attempted 10g XE installation and it failed (was frozen for a couple
of hours so I aborted and rebooted). After that I tried to remove
install folder but couldn't as system complains about admin privilege
(I am in Administrator group!).

delete from ASSORTMENT
 where  ASSORTM not in ( select min(ASSORTM)
                                        from ASSORTMENT
                                        group by  ASSORTM2 )

I am writing a database trigger and if I encounter any exception I
raise error using
raise_application_error (-20001, <error message>);
The error message is displayed on the Oracle Applications 11i Standard

We have a large (100's gigs) OLTP (v9) database which is propreitary to
a vendor.  We would like to extract data near real time for reporting
when the system becomes unavailable.
Ideally we would extract on the inserted or updated data versus pulling

In order to find which segment is waiting I ran this statement with
system user.
Select EVENT,P1TEXT,P2TEXT,P1,P2,P3 From v$session_wait where
sid=<sessionid>

I read something about seqence there but still not clear please give
some light on it
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements
6a.htm#4062
Within a single SQL statement containing a reference to NEXTVAL, Oracle

We are running into large numbers needing to be stored in some columns.
Does increasing the precision of a NUMBER increase the storage size?
What are the consequences of using NUMBER without precision or scale?

need to write "binary" data, specifically a record separator byte
(x1E), to a file.  When I do so using "UTL_FILE.put_line(file_handle,
HEXTORAW("1E"));" I end up with an ASCII hex string of "1" "E", two
bytes not one with 0x1E followed by "newline."

Gentlemen,
this is the official page about thtead safety :
http://oraclesvca2.oracle.com/docs/cd/B10501_01/appdev.920/a96584/oci09adv.htm#456379
I don't understant how it works.

is there something like SUM, but for strings?
I can do
    SELECT SUM(colname)
    FROM mytable

Hey, all...
I am in the process of capacity planning for an Oracle server
(currently at 8.1.7.4, soon to go to 10g)
We're in the process of rolling rman into our environments, but it has

One question if it seem worth answering..
To avoid disk contention we normally have different Tablespace for
indexes and tables.
Now let us say we have two very large tables with no fragmentation &

Group,
I am using Oracle 9206 on windows.  I have a corrupted block on system
tablespace.  And I am using block level recovery (RNAN) to resolve this
problem.