Section 2.5. Conclusion


2.5. Conclusion

This chapter has covered the interaction of cursors and PL/SQL from two different angles. The first is integral to the daily work of database administration: mechanics like cursor reuse, cursor parsing, and the often-overlooked cursor soft-parsing are required knowledge for all DBAs because they underlie virtually every Oracle application. The second is more oriented to application development; while not necessarily everyday usage for DBAs, topics like bulk fetching and REF cursors are also important for you to understand. Your job entails not only monitoring and diagnosing database problems, but also recommending development alternatives that may get your database performance back on track.




Oracle PL(s)SQL For DBAs
Oracle PL(s)SQL For DBAs
ISBN: N/A
EAN: N/A
Year: 2005
Pages: 122

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net