The social network for Oracle people
-
Thoa
- Female
- Ho Chi Minh
- Vietnam
- Blog Posts (3)
- Discussions (1)
- Events
- Groups (1)
- Featured Photos (3)
- Photo Albums
- Featured Videos
Gifts Received
Thoa has not received any gifts yet
Thoa's Page
Latest Activity
Thoa posted a blog postAutomatic SQL Tuning
1. Enable Automated Maintenace Tasks & Accept SQL Profilessqlplus / as sysdbaSQL> exec dbms_auto_task_admin.enable();SQL> exec dbms_sqltune.set_auto_tuning_task_parameter( 'ACCEPT_SQL_PROFILES', 'TRUE');SQL> exit;2. Drops any existing profiles on queries executed by the SCOTT user./astsetup.sh3. Execute a workloadsqlplus scott/tigerSQL> @scott_workload.sqlSQL> exit;4. Force the opening of next maintenance window right now./ast_run.sh5. Execute the scott_workload.sh script…See More
Thoa left a comment for Thoa"Life's a piece of cake, Life's a bunch of flowers, Life's a happy song :)"
Thoa posted a blog postDuplicating an Active Database
1/ Create a initialization parameter (initdup.ora) for the Auxiliary instance as following: DB_NAME=dup DIAGNOSTIC_DEST='/u01/app/oracle' DB_FILE_NAME_CONVERT='+DATA/orcl/datafile/','+DATA/dup/datafile/','+DATA/orcl/tempfile/','+DATA/dup/tempfile/'…See More
Eddie Awad liked Thoa's blog post Duplicating a Database Without Recovery Catalog or Target ConnectionThoa posted a blog postDuplicating a Database Without Recovery Catalog or Target Connection
1/ Take a backup of the target database (orcl) RMAN > backup incremental level 0 database plus archivelog; 2/ Move the backup pieces to '/home/oracle/backup' of a new server using commands like scp,ftp… 3/ Copy the password file (orapworcl) from the target database to $ORACLE_HOME/dbs and rename it orapwdup 4/ Create a…See More
Thoa left a comment for oraclebase"Hi Tim Hall, I just join community site yesterday. I am glad to see you here. Your website is a great site. Thanksss...
Thoa"
Thoa replied to Frank Ebo Quansah's discussion OCP 10g Material for Studies in the group dba"find out material for IT books from http://4shared.com"
Thoa joined Parag Sharma's group
dba
A community that brings you to the top. Don't feel shy to ask anything relating database. We are not just community member.
Profile Information
- About Me:
- I am working as Oracle Instructor in HCM, or Hanoi City, Vietnam.
Thoa's Blog
Automatic SQL Tuning
1. Enable Automated Maintenace Tasks & Accept SQL Profiles
sqlplus / as sysdba
SQL> exec dbms_auto_task_admin.enable();
SQL> exec…
Posted on July 11, 2012 at 8:00pm
Duplicating an Active Database
1/ Create a initialization parameter (initdup.ora) for the Auxiliary instance as following:
DB_NAME=dup…
Posted on July 10, 2012 at 10:00am
Duplicating a Database Without Recovery Catalog or Target Connection
Posted on July 9, 2012 at 7:30am
Comment Wall (1 comment)
- At 11:14am on July 10, 2012, Thoa said…
Life's a piece of cake, Life's a bunch of flowers, Life's a happy song :)
© 2013 Created by Eddie Awad.
