onebetter.com

A typical cause is fragmentation of the shared pool due to a lack of sharable SQL. But that is not the sole cause (e.g. have a look at Metalink note 556140.1).
See also yaodba

…i would suggest going back to the basics – the oracle server concepts manual. once you’ve read that, read it again. next read the developers guide, next read the performance tuning guide…just keep reading…read tom’s books also! once you think you’ve read enough, come back here, and start trolling through performance related questions that tom has already answered. finally if you still have a question, ask it then. from AskTom

SQL> select t.grantor, t.grantee, t.privilege from all_tab_privs t where t.table_name = ‘USER_DATA_PUMP’;

GRANTOR GRANTEE PRIVILEGE
——– ———- ———-
SYS JANH READ
SYS CMDAVID READ
SYS RICK READ
SYS CMADMIN READ
SYS JANH WRITE
SYS CMDAVID WRITE
SYS RICK WRITE
SYS CMADMIN WRITE

8 rows selected.

SQL> select * from all_directories;

OWNER DIRECTORY_NAME
—————————— ——————————
DIRECTORY_PATH
——————————————————————————————————————————————————
SYS WORK_DIR
/fs01/app/oracle/product/10.2/db_1/work

SYS USER_DATA_PUMP
/fs05/oradata/offdev/exports

SYS DATA_PUMP_DIR
/fs01/app/oracle/product/10.2/db_1/rdbms/log/

8 rows selected.

This is a test of the oracle feedburner

 

 feed burn test - temp [3:58m]: Play Now | Play in Popup | Download

On a new install of Enterprise Manager 10.1 we would get random failures caused by the dbsnmp account getting locked(timed) due to failed login attempts exceeding the default profile’s setting of ten.

This is caused by the dbsnmp user connecting with the wrong password more than 10 times in a row which forces an account lockout. With the account locked out EM can’t connect to the database. The database is still up and fine.

To work around the problem I have created a new profile and assigned that profile to the dbsnmp user and unlocked the account as shown below.

SQL> create profile dbsnmp limit failed_login_attempts unlimited;

Profile created.

SQL> alter user dbsnmp profile dbsnmp;

User altered.

SQL> alter user dbsnmp account unlock;

User altered.

-Rick

This is another test entry on the way to the blogger for something to see and edit. I will find some informantion on Oracle Open World Oracle search engine expands access to third-party data sources Well that is not really from the openworld but it is a cool post for Secure Enterprise Search.

1. a numbered list
   
2. and another item
   
3. last one

This seems to be able to format stuffs his is a testing post for the oracle blog. This blog post is just a test and has nothing here at the moment. So this is the updated part that I have just edited in Elicit and it seems really cool. I would like to see how well the linker and other things work tohis is a testing post for the oracle blog. This blog post is just a test and has nothing here at the moment. So this is the updated part that I have just edited in Elicit and it seems really cool. I would like to see how well the linker and other things work tohis is a testing post for the oracle blog. This blog post is just a test and has nothing here at the moment. So this is the updated part that I have just edited in Elicit and it seems really cool. I would like to see how well the linker and other things work tohis is a testing post for the oracle blog. This blog post is just a test and has nothing here at the moment. So this is the updated part that I have just edited in Elicit and it seems really cool. I would like to see how well the linker and other things work tohis is a testing post for the oracle blog. This blog post is just a test and has nothing here at the moment. So this is the updated part that I have just edited in Elicit and it seems really cool. I would like to see how well the linker and other things work to

Now some other edits are added to this post.

This is a testing post for the oracle blog. This blog post is just a test and has nothing here at the moment. So this is the updated part that I have just edited in Elicit and it seems really cool. I would like to see how well the linker and other things work too. EMC to Cut Back on Acquisitions, Focus on Business

 Other Media: Download