Alex Poole

1,230 reputation

1412

bio	website	stackexchange.com/users/98359
	location	United Kingdom
	age	41
visits	member for	2 years, 4 months
	seen	1 hour ago
stats	profile views	61

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.

	1,230 reputation	bio	website	stackexchange.com/users/98359	visits	member for	2 years, 4 months
1412 badges		location	United Kingdom		seen	1 hour ago

summary answers questions tags badges favorites bounties reputation activity

119 Actions

suggestions reviews revisions comments badges posts accepts all

Feb 21	answered	Virtual Oracle server for education?
Feb 20	comment	How can I allow an Oracle database to be accessed remotely? Do you have a listener running on the machine that has the database, an if so are you connecting to the right port?
Feb 20	answered	SQL Data aggregation
Feb 20	comment	SQL Data aggregation Can you provide your table structure, some sample data and expected output?
Feb 17	answered	ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Feb 15	comment	ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Is the database crashing when you get the `ORA-03113`; and is there anything in the alert log?
Feb 15	revised	How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora added 162 characters in body
Feb 15	answered	How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora
Feb 14	awarded	Commentator
Feb 14	comment	ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes @FrustratedWithFormsDesigner - that's just my guess, but yes. Seems more likely than the posted query being pulled out of a PL/SQL block I think.
Feb 14	comment	ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes From the OP's previous question it looks like `lc_history2` is a view, so maybe that calls a function that produces output?
Feb 14	answered	How can Oracle use a Range Scan here?
Feb 14	revised	How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora? Added another link
Feb 14	answered	How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?
Feb 13	awarded	Talkative
Feb 12	comment	Alter in PL SQL Loop `using` is normally want you want for dynamic SQL, in combination with bind variables, to avoid SQL injection. As you've discovered though, you can't use bind variables with DDL statements, hence you have to fall back to concatenation in this case.
Feb 8	awarded	Yearling
Feb 3	comment	SQL from/where or join? @a1ex07 - still true in 11g (11.2.0.2, anyway).
Feb 3	comment	Does DBMS_STATS.AUTO_CASCADE ever work? Or I could try it myself, of course... as suspected, it does still gather the index stats if table stats are gathered before the index is created.
Feb 3	comment	Does DBMS_STATS.AUTO_CASCADE ever work? The first time you run it, this might be reasonable as the `AUTO_CASCADE` is based on the table stats being stale, not the index stats; so it would interesting to see if it does the same if you gather table stats before creating the index. Based on the subsequent runs it doesn't look like it will make a difference though.