RE: Oracle Sessions for Toad 11
Bert Scalzo <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <228D4BD15697E04CAF6CD482362F2ACE102C2F09@ALVMBXW01.prod.quest.corp> |
You can also check options for use noparallel hint in schema browser to keep memory space and session utilization lower. Then there's also the option to run things in threads - again using more resources. From: [email protected] [mailto:[email protected]] On Behalf Of John Dorlon Sent: Monday, October 10, 2011 10:41 AM To: [email protected] Subject: [toad] RE: Oracle Sessions for Toad 11 Dave, it is probably the "Options|Editor|Syntax Highlighting" options that is creating the 2nd session. Try unchecking those and see if it makes a difference. From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Bert Scalzo Sent: Monday, October 10, 2011 10:37 AM To: [email protected]<mailto:[email protected]> Subject: [toad] RE: Oracle Sessions for Toad 11 That error is simple - your SGA/PGA does not have sufficient memory space for process to initiate/allocate its space needs within the SGA/PGA. As for Toad and sessions, that depends on your option settings among many other things - so need much more info .... From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Reed, David A. Sent: Monday, October 10, 2011 10:12 AM To: [email protected]<mailto:[email protected]> Subject: [toad] Oracle Sessions for Toad 11 I have noticed in Toad 11 using the Session browser that multiple Oracle sessions are being associated with a team member's connection to schemas with only the schema browser opened. How does Toad 11 open sessions for a connection to any schema? In maybe a related issue, we are seeing an ORA-04031 errors that we haven't seen since we were using Oracle 7 15 years ago. Any thoughts? We are on Oracle 10 Rev 2. TIA, Dave Reed David Reed Principal Engineer Integrated Systems Engineering and Process Improvement Design Process Software CWHQ2 318D Westinghouse Electric Company Suite 252 1000 Westinghouse Drive Cranberry Township PA 16066, USA Phone: +1 (412) 374-6739 Fax: +1 (412) 374-4575 Email: [email protected]<mailto:[email protected]> Home Page: www.westinghousenuclear.com