Is there a way to define diffrent archive processes for primary and
standby databases.I am asking this because most of the time our
production db gets stuck as its not completed archiving as the archive
processes are busy writing to the standby.

i would like to display a clob field (approx 4k chars) in full in sql
plus worksheet.
googled around and had a look at Oracle SQL Plus manual and couldn't
find anything relevant (plenty for long fields however) or worked.

I want to export like 80 tables from a big tablespace. I have oracle
10g. How can i use the export utility to do export and do the
filtering?.
Thanks

I am new to Oracle and studying for 9i DBA Fundamentals II.   I have
downloaded and installed Version 9.2.0.1.0 on my Windows XP environment but
I can't find the "cmctl" utility.   According to the docco its supposed to
be a component of  Oracle Net Services.

Hi, I have looked at a lot of websites but could not find an answer so
maybe you can help me out here.
Is there a way to hold system properties in the database instead of
holding them in the resorce file?  Does something like that exist in

what is the maximum value supported for
db_file_multiblock_read_count.Is it equal to the max I/ that your OS
can support?
ss

I have a very basic question about oracle database structures. I am
coming from MS SQLServer where I have three "databases", each database
has three "tables". I can access any table from any database from a SQL
connection where each database has its own connection. Once connected ...

I want to bind an array to the following sql statement using oci
SELECT UUID FROM TEST WHERE TYPE=:VAL
UUID is INTEGER
TYPE is CHAR(1)

I am working with a web application which needs to connect to an Oracle
database.  For this, I am running everything locally (Windows 2K, Apache
and Oracle 9i) and all features seem to be working fine.
All I need now is the syntax for the Net*SQL connection (from the web

I have a java program that prompts the user for his/her login name.  I
want to use the login name to find out which of the many schemas in my
database he/she is allowed to see and present that list in a drop down
menu.

Hey, all.
Been on vacation for a few weeks, and now I'm back beating this RMAN
beast into submission as best I can.
I've retraced my steps to the goal of performing a TSPITR (8i on AIX

What's the best (most performant) way to loop over a string value
character by character?
We've implemented it like this:
 for i in 1 .. length(v_str) loop

I have an oracle process at high utilization. It is running at about 98%
as reported by top utility under unix, all the time. What steps can I
take to resolve this? I do have access to em online.
I am running oracle 10g under Solaris 9 on Sparc.

I inherited a 9.2.0.4 database on a W2000 / 4GB box:
The spfile is like below:
SGA_MAX_SIZE=950M
Cache = 167M

Oracle 9.2.0.7.0 on Win2003
Stumbled on to this, and don't have an explanation:
Connected as SYSTEM, with the standard, out-of-the-box DBA role:
system@NPSTDB.WORLD> select count(*) from sys.link$;