oracle forums

anyone having issues with forums.oracle.com ? I guess they did some
kind of upgrade over the weekend, now I can't even get the site to
load.

"Ben" schreef in bericht
news:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
> anyone having issues with forums.oracle.com ? I guess they did some
> kind of upgrade over the weekend, now I can't even get the site to
> load.

Same here....

Shakespeare

On Aug 25, 11:01*am, "Shakespeare" wrote:
> "Ben" schreef in berichtnews:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>
> > anyone having issues with forums.oracle.com ? I guess they did some
> > kind of upgrade over the weekend, now I can't even get the site to
> > load.
>
> Same here....
>
> Shakespeare

OTN is definitely having issues today, Aug. 25, 2008. On occassion
you will even get a web page acknowledging the issue. Oracle is
working on it. Again.

-- Mark D Powell --

Mark D Powell wrote:
> On Aug 25, 11:01 am, "Shakespeare" wrote:
>> "Ben" schreef in berichtnews:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>>
>>> anyone having issues with forums.oracle.com ? I guess they did some
>>> kind of upgrade over the weekend, now I can't even get the site to
>>> load.
>> Same here....
>>
>> Shakespeare
>
> OTN is definitely having issues today, Aug. 25, 2008. On occassion
> you will even get a web page acknowledging the issue. Oracle is
> working on it. Again.
>
> -- Mark D Powell --
Downloads are working OK, but I get an error when trying to access the
forums. Unbreakable, eh?

Palooka

On Aug 25, 11:54*am, Palooka wrote:
> Mark D Powell wrote:
> > On Aug 25, 11:01 am, "Shakespeare" wrote:
> >> "Ben" schreef in berichtnews:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>
> >>> anyone having issues with forums.oracle.com ? I guess they did some
> >>> kind of upgrade over the weekend, now I can't even get the site to
> >>> load.
> >> Same here....
>
> >> Shakespeare
>
> > OTN is definitely having issues today, Aug. 25, 2008. *On occassion
> > you will even get a web page acknowledging the issue. *Oracle is
> > working on it. *Again.
>
> > -- Mark D Powell --
>
> Downloads are working OK, but I get an error when trying to access the
> forums. Unbreakable, eh?
>
> Palooka- Hide quoted text -
>
> - Show quoted text -



doesn't aggravate me as much as some of the shoddy sql used in
development of sqldeveloper 1.5.1, just try to expand a users tables
tree in a semi large to large schema, come back to it in an hour or so.

On Aug 25, 9:38*am, Ben wrote:
> On Aug 25, 11:54*am, Palooka wrote:
>
>
>
>
>
> > Mark D Powell wrote:
> > > On Aug 25, 11:01 am, "Shakespeare" wrote:
> > >> "Ben" schreef in berichtnews:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>
> > >>> anyone having issues with forums.oracle.com ? I guess they did some
> > >>> kind of upgrade over the weekend, now I can't even get the site to
> > >>> load.
> > >> Same here....
>
> > >> Shakespeare
>
> > > OTN is definitely having issues today, Aug. 25, 2008. *On occassion
> > > you will even get a web page acknowledging the issue. *Oracle is
> > > working on it. *Again.
>
> > > -- Mark D Powell --
>
> > Downloads are working OK, but I get an error when trying to access the
> > forums. Unbreakable, eh?
>
> > Palooka- Hide quoted text -
>
> > - Show quoted text -
>
> doesn't aggravate me as much as some of the shoddy sql used in
> development of sqldeveloper 1.5.1, just try to expand a users tables
> tree in a semi large to large schema, come back to it in an hour or so.

It seems to be up now, with some number of posts from when it wasn't
for me. Slow.

jg
--
@home.com is bogus.
http://oracleofbacon.org/cgi-bin/mov...&g23=on&g27=on

On Aug 25, 8:38*pm, Ben wrote:
> On Aug 25, 11:54*am, Palooka wrote:
>
>
>
> > Mark D Powell wrote:
> > > On Aug 25, 11:01 am, "Shakespeare" wrote:
> > >> "Ben" schreef in berichtnews:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>
> > >>> anyone having issues with forums.oracle.com ? I guess they did some
> > >>> kind of upgrade over the weekend, now I can't even get the site to
> > >>> load.
> > >> Same here....
>
> > >> Shakespeare
>
> > > OTN is definitely having issues today, Aug. 25, 2008. *On occassion
> > > you will even get a web page acknowledging the issue. *Oracle is
> > > working on it. *Again.
>
> > > -- Mark D Powell --
>
> > Downloads are working OK, but I get an error when trying to access the
> > forums. Unbreakable, eh?
>
> > Palooka- Hide quoted text -
>
> > - Show quoted text -
>
> doesn't aggravate me as much as some of the shoddy sql used in
> development of sqldeveloper 1.5.1, just try to expand a users tables
> tree in a semi large to large schema, come back to it in an hour or so.

This might be not an SQL issue, but a client-side issue: for each
schema object they will instantiate a bunch of different class
instances and it takes time and memory, and then it all needs to be
iterated and painted... Just a guess - I don't use sqldev and didn't
inspect the SQL it issues.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On Aug 26, 2:50*am, "Vladimir M. Zakharychev"
wrote:
> On Aug 25, 8:38*pm, Ben wrote:
>
>
>
>
>
> > On Aug 25, 11:54*am, Palooka wrote:
>
> > > Mark D Powell wrote:
> > > > On Aug 25, 11:01 am, "Shakespeare" wrote:
> > > >> "Ben" schreef in berichtnews:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>
> > > >>> anyone having issues with forums.oracle.com ? I guess they did some
> > > >>> kind of upgrade over the weekend, now I can't even get the site to
> > > >>> load.
> > > >> Same here....
>
> > > >> Shakespeare
>
> > > > OTN is definitely having issues today, Aug. 25, 2008. *On occassion
> > > > you will even get a web page acknowledging the issue. *Oracle is
> > > > working on it. *Again.
>
> > > > -- Mark D Powell --
>
> > > Downloads are working OK, but I get an error when trying to access the
> > > forums. Unbreakable, eh?
>
> > > Palooka- Hide quoted text -
>
> > > - Show quoted text -
>
> > doesn't aggravate me as much as some of the shoddy sql used in
> > development of sqldeveloper 1.5.1, just try to expand a users tables
> > tree in a semi large to large schema, come back to it in an hour or so.
>
> This might be not an SQL issue, but a client-side issue: for each
> schema object they will instantiate a bunch of different class
> instances and it takes time and memory, and then it all needs to be
> iterated and painted... Just a guess - I don't use sqldev and didn't
> inspect the SQL it issues.
>
> Regards,
> * *Vladimir M. Zakharychev
> * *N-Networks, makers of Dynamic PSP(tm)
> * *http://www.dynamicpsp.com- Hide quoted text -
>
> - Show quoted text -

I'm certain it's the sql they used. There are several posts on the
forum referencing the poor design for large schemas. I tried to view
the explain plan for it but after I saw it was about 10 pages long I
didn't go any further.

and I was going to post links to some of the posts, but alas the
forums website is broken again.

"Ben" wrote in message
news:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
> anyone having issues with forums.oracle.com ? I guess they did some
> kind of upgrade over the weekend, now I can't even get the site to
> load.

Same problem today.

On Aug 26, 2:16*pm, "Matthias Hoys" wrote:
> "Ben" wrote in message
>
> news:c6ac5946-6ddd-4164-85f6-a901f7298d95-at-l42g2000hsc.googlegroups.com...
>
> > anyone having issues with forums.oracle.com ? I guess they did some
> > kind of upgrade over the weekend, now I can't even get the site to
> > load.
>
> Same problem today.

Yeah, still seeing it. Got this on metalink, refreshing after a try
again later message:

ORA-29262: bad URL
Debug:


1: begin
2: DECLARE
3: lv_sortBy NUMBER;
4: lv_saveButton BOOLEAN;
5: lv_srcVal NUMBER;
6: lv_text varchar2(400);
7: vSql VARCHAR2(4000);
8: BEGIN
9:
10: lv_text := replace(:P_SRCHTXT, '##', ':');
11: lv_text := utl_url.unescape(lv_text);
12: lv_srcVal := :P_SOURCE;
13: :P_SRCHTXT := lv_text;
14: htp.p('');
18:
19: if (lv_srcVal >4) then
20: lv_text := '';
21: end if;
22: lv_text := ml2_util.urlencode(lv_text);
23:
24: begin
25: lv_sortBy := to_number(:sortBy);
26: exception
27: when others then
28: lv_sortBy :=sure_api.c_orderByQueryScore;
29: end;
30: BEGIN
31: IF to_number(:saveButton) = 0 THEN
32: lv_saveButton := TRUE;
33: ELSE
34: lv_saveButton := FALSE;
35: END IF;
36: exception
37: when others then
38: lv_saveButton := FALSE;
39: end;
40:
41: IF UPPER(:ST) = 'SC' THEN
42: :ST := 'R';
43: :P_SRCHTXT := null;
44: :F130_P0_SRCH_TEXT := null;
45: htp.p('');
48: END IF;
49:
50: IF ( (upper(:forums) = 'TRUE') and
(ml2_priv.hasAccess(ml2_priv.grantCodeForumAccess) = FALSE) ) then
51: :forums := 'FALSE';
52: END IF;
53:
54: kno_main.newPreDoAdvancedQuery(
55: p_name =>:name
56: ,p_alltext => REPLACE(:alltext, '$colan',':')
57: ,p_anytext => REPLACE(:anytext, '$colan',':')
58: ,p_exctext => REPLACE(:exctext, '$colan',':')
59: ,p_nontext => REPLACE(:nontext, '$colan',':')
60: ,p_docId => :docid
61: ,p_knowledge => :knowledge
62: ,p_bug => :bug
63: ,p_forums => :forums
64: ,p_archive => :archive
65: ,p_product_id => roduct_id
66: ,p_platform_id => latform_id
67: ,p_update => :update
68: ,p_numHits => NVL(:numHits, 100)
69: ,p_sortBy =>
NVL(lv_sortBy,sure_api.c_orderByQueryScore)
70: ,p_ss => :ss
71: ,p_st => NVL(:st,'R')
72: ,p_saveButton => lv_saveButton
73: ,p_sss => :sss
74: ,p_type => :type
75: ,p_callFrom => 'ML'
76: ,p_filterCrit => :filtcrit
77: ,p_filterVal => :filtcritval
78: );
79:
80: :name := NULL;
81: :alltext := NULL;
82: :anytext:= NULL;
83: :exctext:= NULL;
84: :nontext:= NULL;
85: :docid:= NULL;
86: :knowledge:= NULL;
87: :bug:= NULL;
88: :forums:= NULL;
89: :archive:= NULL;
90: roduct_id:= NULL;
91: latform_id:= NULL;
92: :update:= NULL;
93: :numHits:= NULL;
94: :sortBy := NULL;
95: :ss:= NULL;
96: :st:= NULL;
97: :saveButton := NULL;
98: :sss:= NULL;
99: :type:= NULL;
100: :filtcrit:= NULL;
101: :filtcritval:= NULL;
102: END;
103: end;

jg
--
@home.com is bogus.
Please send that PL/SQL standards document.