Category Archives: learning

Select Any Dictionary vs Select_Catalog_Role

Allways we want give to a user access to data dictionary and system views, we find two  privileges to grant select any dictionary and grant select_catalog_role with both we acomplish with the job, but, why there two options? are the same options? no, they arent the same and one is not over. Is a role vs direct privilege and yes is diferent.

Continue reading

Advertisements

Oracle BEST Practices III

1- Put your Database into ARCHIVELOG Mode
2- Use DBMS_STATS for statistic collection
3- Using Recovery Manager(RMAN) for Backup and Recovery needs
4- Resumable Statements and Space Allocation
5- Maintenance of Global Partitioned Indexes
6- Default Tablespaces
7- PL/SQL Bulk Operations
8- Locking Issues
9- Oracle System Event Triggers
10- Autonomous Transactions
11- Defining Application Services for Oracle Database 10g
12- Cost Based Optimizer Best Practices and Advised Strategy

Continue reading

Tom Kyte Madrid Seminars

Thanks to Tom and of course Oracle, In 2012 Tom kyte could visit Madrid and shared a little of his knowledge, Oracle call this day
“A day with Tom Kyte” start at 9:00 to 17:30 in that time we could
ask to tom a lot of question.

Continue reading

Oracle DBA Responsibilities

I can resume this post and say DBAs have three basic tasks: backup, BACKUP, BACKUP!!. Although data integrity is clearly the first job, if the data isn’t good doesnt matter if the database is available or database perfomance is fast.

So first and principal task is Establish and maintain backup and recovery policies and procedures

Continue reading

Oracle BEST Practices II

1- Put your Database into ARCHIVELOG Mode
2- Use DBMS_STATS for statistic collection
3- Using Recovery Manager(RMAN) for Backup and Recovery needs
4- Resumable Statements and Space Allocation
5- Maintenance of Global Partitioned Indexes
6- Default Tablespaces
7- PL/SQL Bulk Operations
8- Locking Issues
9- Oracle System Event Triggers
10- Autonomous Transactions
11- Defining Application Services for Oracle Database 10g
12- Cost Based Optimizer Best Practices and Advised Strategy

Continue reading