fyi: On 6 Apr 2001, at 22:33, The Sacramento Oracle Users Group wrote: > To: <[EMAIL PROTECTED]> > From: "The Sacramento Oracle Users Group" <[EMAIL PROTECTED]> > Date sent: Fri, 6 Apr 2001 22:33:56 -0700 > Subject: [sacoug] Oracle7 to Oracle8i: What changed for the DBAs and >the Application Developers > > [ Double-click this line for list subscription options ] > > Dear ORACLE Professional, > > This message contains the information on scope, venue and speakers for > individual parts of the three part of series being sponsored by SacOug on > Oracle7 and Oracle8i. > > * Part 1 on April 19 will introduce us to the domain of change. > * Part 2 on April 26 will address the changes in PL/SQL. > * Part 3 on May 3 will address the changes in Data Administration. > > The venue is > Classroom RVR 1012(4/19 and 4/26) and Lobby Suite, University Union(5/3) > California State University, Sacramento > 6000 J Street, Sacramento > (directions on website) > > > > The arrival of Oracle8i, with its Web and Java integration, is a dramatic > development for Oracle customers. In some ways, Oracle8i is like any other > Oracle release, packed with new products and features that customers need to > learn about. > > But in other ways, Oracle8i, the "Internet database," is something very > different. Its capabilities range far beyond traditional database > boundaries. It presents Oracle users with new models for developing > applications and doing business. Up until now many ORACLE developers and > database administrators have been working effectively with SQL, PL/SQL, and > various Oracle tools. With ORACLE 8i, they are now faced with the need to > learn a whole variety of new and constantly changing technologies: Java, > XML, and many other Internet-related technologies. > > Beginning Thursday night, April 19, The Sacramento ORACLE User Group, in > conjunction with the Computer Science Department of the California State > University, Sacramento, produces a three part series exploring in detail the > issues involved with the move from ORACLE 7 to ORACLE 8i. Seating is > limited to the first 25 who register. You may register at: > <http://www.sacoug.org/html/events.htm>. > "Oracle7 to Oracle8i: What changed for the DBAs and the Application > Developers" > > * Part 1 on April 19 will introduce us to the domain of change. > * Part 2 on April 26 will address the changes in PL/SQL. > * Part 3 on May 3 will address the changes in Data Administration. > > Here is more detail: > > |----------------------------------------------------------------------- > | Part I - Introduction to Oracle8i > | Date: April 19, 2001 > | Time: 7:00 - 10:00 PM > | Venue: Classroom RVR 1012 > | California State University, Sacramento > | 6000 J Street, Sacramento > | (directions on website) > > This first lecture lays the foundation for the presentations to follow. > First the challenges presented to developers in ORACLE 7 will be briefly > presented. Features in PL/SQL and for database administration in Oracle 7 > need improvement. > > This lecture will have two sections. The first section introduces the > relevant features of PL/SQL and their shortcomings in ORACLE 7. You will > learn how Dynamic SQL and PL/SQL tables in ORACLE 8i addresses these > shortcomings. The second part provides introduction to some of the > frustrations of database administration in Oracle7. You will learn how the > partitioned views, autoextension of extents, and tuning features of Oracle 7 > need further enhancements. > > Speaker: Ravi Verma, Practice Manager, Annams Systems Corporation Ravi’s > experience with Oracle spans over 12 years beginning with Oracle 5. Most of > these years have been in the role of a DBA and a developer. Prior to joining > Annams Ravi worked with Oracle corporation where he led data modeling > effort for customizing Oracle Manufacturing Applications for Automative > industries. Since joining Annams Systems Corporation he has handled many > successful data warehousing projects. Bluelight.com the online division of > Kmart is one of his accounts where he leads the database design and on-going > tuning effort of very large Oracle8i databases. > > Teaching is his favorite pass time. He has taught Database Administration > course at UC Davis Extension. He is working with the Computer Science > Department of the Sacramento State University to design courses for working > professionals in IT industry. > > |----------------------------------------------------------------------- > | Part II - The New Face of PL/SQL > | Date: April 26, 2001 > | Time: 7:00 - 10:00 PM > | Venue: Classroom RVR 1012 > | California State University, Sacramento > | 6000 J Street, Sacramento > | (directions on website) > > ORACLE 8i, the long-awaited "Internet database," offers more than 150 new > features -- many of them designed to make its popular database programming > language, PL/SQL, faster, more powerful, and easier to use. This change > presents a challenge to the developer. The major Oracle8i PL/SQL features > include the following: > * Autonomous transactions -> Commit or roll back changes without affecting > the "main" transaction in the rest of your session. > * Invoker rights -> At compilation time, you can now decide whether a > program (or all programs in a package) should run under the authority of the > definer or the invoker of that program. > * Native dynamic SQL -> This native implementation of dynamic SQL is faster > and easier than the DBMS_SQL built-in package. > * Bulk binds and collects -> This major performance improvement allows you > to process multiple rows in a single operation. > * System-level database triggers -> With this feature and Advanced Queuing > (AQ), you can take advantage of the publish/subscribe capabilities of ORACLE > 8i. > * Fine-grained access control -> This feature lets you implement security > policies with functions and then use those functions to implement row-level > security on tables or views. > * Many new and enhanced built-in packages -> New packages include DBMS_JAVA, > DBMS_PROFILER, DBMS_TRACE, and more. DBMS_UTILITY, DBMS_AQ, and others have > been enhanced as well. > * Calling Java methods from within PL/SQL -> You build simple Java classes, > load them into the Oracle8i database, and leverage those classes from within > your PL/SQL code. > * A variety of performance improvements > > Some PL/SQL developers are uneasy about what the introduction of Java means > to their applications -- and their programming future. But the two languages > are expected to work well together in Oracle8i. You'll be able to take > advantage of all the power of Java without giving up the performance and > usability advantages of PL/SQL. > > Speaker: Tim Frazier, Vice President, Annams Systems Corporation – Tim > Frazier was President (and founder) of Sunflower Systems prior to joining > Annams Systems Corporation. He joined Annams in the wake of acquisition of > Sunflower Systems by Annams. The Sunflower Assets is The only choice for > state-of-the-art asset management software with many federal agencies as its > clients. > Tim Frazier was part of Oracle Consulting branch of Oracle Corporation > before he left to form Sunflower Systems. > Tim Frazier is a wizard with PL/SQL. His product Sunflower Assets is a > marvel in the most ingenious use of PL/SQL for web enabling an application. > > > > > |----------------------------------------------------------------------- > | Part III - The New Face of Database Administration > | Date: May 3, 2001 > | Time: 7:00 - 10:00 PM > | Venue: Lobby Suite, University Union <- NOTE: Venue Change > | California State University, Sacramento > | 6000 J Street, Sacramento > | (directions on website) > > The speaker will discuss the following topics relevant to the DBAs of the > new world: > > * Partition Tables offer major performance boost for data warehouses and > OLTP systems. > > * Parallel DML enables application to update, insert, delete data from > partition tables in parallel. > > * Better memory management - new buffer cache management, user memory > management > > * Index only tables - great for lookups in the OLTP and OLAP > > * Net8 - much improved performance > > * New Datatypes - LOB > > * Objects > > * Security and Password management > > * CARTRIDGES ( i.e.TIME SERIES) > > Speaker: Ravi Verma, Practice Manager, Annams Systems Corporation > ---end--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).