miracle173

1,308 reputation

bio	website
	location	Austria
	age
visits	member for	1 year, 11 months
	seen	2 days ago
stats	profile views	74

Oracle : 7.3.4, 9.2, 10.1, 10gXE, 10.2, 11.2
Mysql : 5.5, internals
Sqlserver : 2012, 2008 R2, 2008, 2005, 2000
DB2 9.7
PostgresSQL
Microsoft Windows System Error Codes
Linux errno.h
Java Java 7
Other: Sqlfiddle pastebin
Articles
Editing Help; allowed HTML; Reference
T.J.Teorey, D.Yang,J.P.Fry: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model

	1,308 reputation	bio	website		visits	member for	1 year, 11 months
28 badges		location	Austria		seen	2 days ago

summary answers questions tags badges favorites bounties reputation activity

294 Actions

suggestions reviews revisions comments badges posts accepts all

Apr 2	revised	which process has created a load spike on my server last week? minor corrections
Apr 2	suggested	suggested edit on which process has created a load spike on my server last week?
Mar 12	comment	Oracle 11g listener fails with ORA-12514 and ORA-12505 errors you actually eyplained the solution: the automatic regristration of the database to the default LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))' (where hostname is the network name of the machine) did not work because there is a problem to reach the machine under this name. Maybe there is an entry in the alert.log or in some sqnlnet.log (%ORACLE_HOME%/network/log/) about the registration problem of the database
Mar 12	comment	Oracle 11g listener fails with ORA-12514 and ORA-12505 errors two notes: "the listener seems fine": I don't think so because it does not display a service named "XE" "I can ping the XE service": tnsping connects to the listener but it does not bother about services. so you can only show if the listener is up and running but you cannot use ist to check if the listener has registered a service. So tnsping "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))" will succeed if a listener is running on port 1521 of localhost even if the service does not exist.
Feb 13	comment	Is there any way to break out of the string and inject SQL without using a single quote in oracle? @Vincent Malgrat: "Not using bind variables destroys performance" is wrong.It is true that recompilation of a statement can be avoided by using bind variables. Also the shared pool will be flood by a lot of similiar statements if you don't use bind variables. Nevertheless the optimizer has less information for building a plan if one uses bind variables instead of literal values. There are situations where there should be selected different plans depending on the values of the bind variables (or the literal values).
Feb 5	comment	Oracle Table Design, Storing Small Values Yes, but I wanted to know how much percent of the whole database space you will save?
Feb 5	comment	Oracle Table Design, Storing Small Values how much percent of space will you save in your database by defining these columns as CHAR(1) instead of NUMBER(1)?
Feb 4	comment	Many to Many and Weak Entities "the album cannot exist without an artits" may be true in a historical sense but I think it is questionable in conceptual data modelling.
Jan 28	comment	Can I use a foreign key index as a shortcut to getting a row count in an INNODB table? why does this question refer to foreign keys in the title?
Jan 26	comment	Importance of ER Diagrams +1 but do you knowany figures or studies that supports your claims about the the problems of communicationg using graphical languages?
Jan 26	comment	Importance of ER Diagrams +1 but which other ways od documentation and communication are used in regard to databases?
Jan 24	comment	what is relation between sql server back file size and space required for restoring database why the size of the logfiles only?
Jan 24	comment	Factoring out subselect (with clause) ends in ORA-00904 meanwhile if found syntaxes
Jan 24	answered	Factoring out subselect (with clause) ends in ORA-00904
Jan 23	comment	Factoring out subselect (with clause) ends in ORA-00904 Where does the error occurr in your query? I wrote an answer that shows how to find this when using sqlplus. But more important: can you simplify the query and reproduce the error anyway? Simplifying means: remove joins from the where clause, remove expressions from the were-clause (or the whole were-clause if possible), remove fields from the select-list.
Jan 23	answered	Reflexivity axiom for inferring functional dependencies
Jan 22	answered	How do I go about creating this SQL query?
Jan 22	comment	How do I go about creating this SQL query? this will return data if there are three ratings for a film by one reviewer
Jan 22	comment	How do I go about creating this SQL query? it would be useful if you implement tables with sample data at sqlfiddle.com
Jan 17	comment	What is the difference between a “record” and a “row” in SQL Server? +1 for posting the references and your thoughts about the joe celko quote. The "short answer" I simply ignore.