I support 10.1.0 databases on Solaris 8.
We have a database where we are using partitions to store and drop data
by calendar quarters.  Each quater gets a new partition in a given
table and consequently, the old partition gets dropped.

the problem is that in waves we're encountering quite a lot of sessions
waiting on latch wait event. The problematic latch is the library cache
latch and our sufferer is a simple SQL statement.
The facts are:

I am working on HP UNIX 11i and using Oracle9i. I already have set
NLS_LANG=AMERICAN_AMERICA.UTF8. My database instance is created wit
UTF8.
When I do export/import of database, do I also need to set LANG=C.utf8

we are running Oracle 9.2.0.5 and I am fairly new at this DBA stuff. I
need some clarification on space management.
1) Where can I see the number of available blocks (or bytes) from the
freelist?

I run Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
on AIX 5.2 ML07. I have very often problem with listener not accepting
connections. "lsnrctl status" hungs. ps shows hat the listener has
created another copy of itself before getting hung.

I'm supporting a web application in production which uses the PL/SQL
Web Toolkit to generate web pages. We recently upgraded to 10GR2.
However, the Web Toolkit still produces "legacy" style html (non-xhtml
compliant -- e.g. < TD > instead of < td >.). I would like to update

I have table A and it has columns: col_1, col_2, col_3, .., col_n. Is
there any performance different for insert operation if I create an
unique index on (col_1, col_2, col_3) or a unique index on (col_3,
col_2, col_1)? Is clustering_factor an issue for the insert?

we (sorrily) found out, that a
INSERT INTO <destination_table>
SELECT <attributes>
FROM TABLE (collection of object type)

Hello faculties,
  I ve lost a datafile. My db is set in archive log mode. But i set it
when the log seq num was 44. The format for archive file mentioned by
parameter as :

I've got a mental block on how to do this.
I have a date column on a table and I want to get rows where the time
is within a certain number of minutes of a target time. e.g.
where to_char(startdatetime,'HH24:MI') between targettime-window and

Some folks are having a discussion in this thread...
http://discuss.joelonsoftware.com/default.asp?joel.3.309971.11
...about databases with a lot of tables.  They've thrown around numbers
like 20, 35, 100, 223, etc.

create table t
(
 a  number,
 b  number,

I´ve a Problem with Oracle 10 R1 and need some help.
I have installed a Oracle 10 R1 on a Testsystem and imported a
Databaseuser (with Tables etc...)
now i want to update the structure of a table and droped the Primary

Is the Oracle AS certification problem for RHEL v4?
On metalink, RHEL 4 is not mentioned in the certification Matrix, but
at Red Hat's website, they mentioned that all Oracle products are
certified on this version.

We have a 8i DB containing a few ridiculously *huge* tables
("ridiculously"
because they never were partitioned) that we plan to convert into
partitioned