AW: [suse-oracle] Performance testing

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

AW: [suse-oracle] Performance testing

AW: [suse-oracle] Performance testing

2004-07-14 - By Maurice Kemmann

Reply: 1 2

Hi,

Am Di, den 13.07.2004 schrieb Anton Dischner um 10:36:

> please take this for a very basic benchmark in SQL*Plus,
> please share your results:
> ...

at first i would like to thank you all that have answered my questions.
Anton gave me a little script for testing. Which i tried in the
following environment :

- HP ML370
- 2x CPU 1 GHz Xeon 256kB Cache
- 1 GB RAM
- all HDs on one SCSI bus
- RedHat 3 ES
- Oracle 10g without any patches
- no tuning at all

You find the results in the attachment to this mail. I will test 8i
later this week and i will try to tune my 10g database but this may take
a while because i do not know much about 10g in the moment. I guess
there are a lot differences to 8i.

Have fun,

Maurice

--
OpenIT GmbH tel +49 211 239 577-0
Maurice Kemmann fax +49 211 239 577-10
Jahnstr. 18 email kemmann@(protected)
D-40215 D�sseldorf http://www.openit.de

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting