Oracle

Some tuning advise
Hi, I need some general advise on tuning. I am responsible for an third-party application that uses an Oracle 9.2.0 database on 2 CPU HP-UX11.11 with 4Gb mem Apparently this database has not been tuned/adapted in any way by the vendor. (a long time ago I was an Oracle DBA but I left the Oracle plane at Orac... 24 Oct 2007 14:57

trouble with RAC db start
All, Let me know your thoughts on the below. My client blew away his OCR. I did a restore of the OCR and now the db won't start. Here's the command line syntax and tail of the crs log: db001i$srvctl start database -d KGDB PRKP-1001 : Error starting instance KGDB1 on node urma-atgdb001 CRS-0215: Could not st... 12 Sep 2007 22:23

ORA-04031: unable to allocate 2097152 bytes of shared memory("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")
purohitatul(a)gmail.com wrote: On Aug 29, 11:25 pm, sybra...(a)hccnet.nl wrote: On Thu, 30 Aug 2007 05:55:19 -0000, purohita...(a)gmail.com wrote: We getting the following error in our database: ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh"... 30 Aug 2007 16:05

Oracle11 & statistics calculations
Oracle11 has some new additions to the mechanism of statistics calculation. The old GATHER_STATS_JOB is gone, it is replaced by BSLN_MAINTAIN_STATS_JOB which, unfortunately, doesn't run DBMS_STATS, it uses an undocumented package DBSNMP.BSLN_INTERNAL which maintains baselines for the AWR. I have to questions: ... 29 Aug 2007 12:14

what characterset to use?
10.2.0.2 Ent Ed, AIX5L We are planning a new database and I'm having a little confusion on what character set to use. We are not sure if in the future we may need some double byte characters. For the most part we can suffice with AMERICAN_AMERICA.WE8MSWIN1252 but it is possible that in the future we need multiby... 2 Sep 2007 18:25

OID/LDAP problem - Any help with a fix would be appreciated
Oracle servers on Windows servers crash after converting to OID from TNS name resolution. Open a command prompt window (note: I have not seen this in the Windows version of SQL Plus or TOAD. You must use a DOS command prompt window). Make sure the windows workstation has SQLNET.ORA configuration that will use OID... 22 Aug 2007 14:43

OS_CPU_WAIT_TIME
Hi All, Does anyone know OS_CPU_WAIT_TIME means in V$OSSTAT. My clients system's OS_CPU_WAIT_TIME shows very very large number like "73,803,038,900" while CPU usage % does not so high... Is it meaningless information? Oracle Reference Manual shows OS_CPU_WAIT_TIME as following. - Total number of hundredths of a... 5 Aug 2007 12:04

Oracle Reports Server 10g problem
Hello! I've configured Forms & Reports Server 10g on my desktop. Forms work fine but Reports don't. I'm getting the following error message in Web browser. "Reports Error Page Mon Jul 23 14:17:38 CEST 2007 javax.servlet.jsp.JspException: REP-50002: Server is shutting down" Reports run only in Paper layout.... 23 Jul 2007 10:20

Remove DBMS_LOCK Locks
10gR2 there're many many records in "dbms_lock_allocated" from my previous testing, and I recognize the names I know they're useless now If they can/should be removed, how to do it ? DBMS_LOCK.RELEASE(<lockid>) ; returns " Parameter error" SQL> desc sys.dbms_lock_allocated Name Type N... 21 Jun 2007 15:11

dbora not start automatically database
dear all, Oracle db 10g r2 enterpise RHEL version 3. i have an error when dbora attempt to execute. That error is describe in system log in linux: My ORACLE_HOME and USER all are correct . But during boot time of pc it shows : "starting dbora : execvp no such file or directory" ....and my dbstart script not... 29 May 2007 20:10