- Resource Profile
- Autonomous transaction
- Temporary tables
- Hot backup
- User creation
- Sequence creation
- How to change IN Parameter value inside a plsql procedure
- Plsql objects
- Prioritize the triggers
- Difference Char and Varchar2
Resource Profile : You can set up
limits on the system resources used by setting up profiles with defined limits
on resources. Profiles are very useful in large, complex organizations
with many users. It allows you to regulate the amount of resources used
by each database user by creating and assigning profiles to users. Using
Oracle8 password attributes where added into profiles as well.
Profiles
are a named set of resource limits. By default, when you create a user,
they are given the default profile. The default profile provides
unlimited use of all resources
Autonomous transactions
are used when you wan to roll-back some code while continuing to process an
error logging procedure.
The term "automous
transaction" refers to the ability of PL/SQL temporarily suspend the
current transaction and begin another, fully independent transaction (which
will not be rolled-back if the outer code aborts). The second transaction
is known as an autonomous transaction. The autonomous transaction functions
independently from the parent code.
An autonomous transaction has the
following characteristics:
- The child code runs independently of its parent
- The child code cannot commit or rollback & parent resumes
- The parent code can continue without affecting child code
Temporary tables improve
the speed of queries that perform complex summarization activities, and how to
speed up two-stage queries that perform both summarization and comparison
activities
Oracle Hints: NOCOPY, Autonomous transaction
No comments:
Post a Comment