Oracle DBA Centre

Knowledge Byte

Main Menu

  • Home
  • DBA-Admin
    • AdminTasks
    • Installation
    • Patches
    • Upgrades
  • RAC
    • Installation
    • Admin
    • Cluster
    • Upgrade
    • TroubleShooting
  • DataGuard
    • Installation
    • Admin
    • DataGuard-Broker
    • Failover
    • Switchover
  • Backup&Recovery
    • Backup
    • Recovery
    • Admin
  • Performance
  • Scripts
  • SQL
  • Linux
    • Installation
    • Admin
    • Misc
  • Storage
    • Performance
    • Commands
  • Misc
    • Misc
    • OEM
    • Space
    • Golden Gate
    • Replication
    • Oracle Errors
    • Duplication

Create Resource Plan

exec dbms_resource_manager.create_plan( -
'DB_CONSOLIDATE_PLAN', -
'Plan for database consolidation');
/

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Posts (Atom)

About the Author

Arif Malik
View my complete profile

Oracle 11g

Oracle 11g
Certified Professional

Search

Catergories

  • SubMenu Data Guard Broker Administration
  • SubMenu Data Guard Switchover
  • SubMenu Data Guard Failure Adminstration
  • SubMenu Oracle Data Guard Administration
  • SubMenu Install Oracle Data Guard
  • Oracle Database 11gR2 Installation on Oracle Linux 7 (OL7) - Non ASM
  • SubMenu Install Oracle Golden Gate 12 on Linux
  • SubMenu Oracle Golden Gate 12.2.0.1 commands
  • Install Oracle Golden Gate 12.2.0.1
  • GoldenGate - Install & Configure
  • Golden Gate command examples
  • GoldenGate commands
  • Archivelog Mode On RAC
  • Create Oracle RAC 11gR2 on OEL6 using VirtualBox
  • Oracle Linux 6 Installation
  • Create Oracle Database 11gR2 RAC on Oracle Linux 6.3 using VirtualBox
  • DataGuard - Cheatsheet
  • DataGuard - Switchover
  • DataGuard - Monitoring Redo Transport Services
  • DataGuard - Role transitions Physical Standby DB
  • Linux - How to Resolve INS-06006 Passwordless SSH connectivity not set up between the following node(s)
  • DataGuard:Creating a DG Broker Configuration
  • RAC:Remove a Node from an Existing Oracle RAC 11g R2 Cluster on Linux
  • RAC:Step by Step of Deleting / Removing Node(s) fr...
  • OEM: Managing OEM Database Control with emca for R...
  • How to Install and Deinstall DBconsole
  • DataGuard Startup & Shutdown Physical Standby
  • Data Guard - Shutdown Dataguard/Standby DB
  • Data Guard - Reinstate a failed over Data Guard using Flashback database
  • Log Gap Detection and Resolution
  • How to Create and Enable an Oracle Data Guard Broker Configuration
  • Remove a Data Guard Broker configuration
  • Create DataGuard Broker
  • DBMS_REDEFINITION
  • Control Files - Management
  • Alert & Trace files - Monitor
  • Dropping Database
  • Suspending Database
  • Quiescing Database
  • SQLNET.ORA
  • Setting up Oracle Net Services Tracing on the Client and Server
  • Duplicate a Database Using RMAN in Oracle Database 11g Release 2
  • Cold Backup
  • Duplicate DB using RMAN Backups - Step by Step
  • Create Duplicate DB using Cold &Hot RMAN backup
  • Oracle DB Quick Cloning
  • Oracle 11g RMAN Cloning using Backup Duplicate command
  • Active Database Duplication using RMAN 11gR2
  • Difference between Undo/Redo
  • Manual Database 11.1.0.6 creation
  • Purging trace and dump files with 11g ADRCI
  • Purge Trace & Dump files using ADRCI
  • Backup Database in NOARCHIVELOG
  • Enable-Disable Archive Log mode
  • Create RMAN Catalog
  • DataPump11g-Export
  • Admin-Tasks
  • Schedule Window Resource Plan
  • Enable Resource Plan Window
  • Enable Resource Plan
  • Create Resource Plan directive
  • Create Resource Plan
  • Resource Manager-8i
  • Resource Manager-Enhancements11g
  • DBMS_SCHEDULER-Enhancements11g
  • DBMS_SCHEDULER-10g
  • Resource Active Plan
  • List jobs running
  • List job Info
  • Show Job Class info
  • Show Windows info
  • Scheduler Window Group details
  • List Scheduler info
  • List running jobs
  • List job schedules
  • Shows Scheduler Job Credentials
  • ADR Maintenance & Log Tidy scripts
  • CRS Status
  • Monitor CRS Stack
  • Session Trace
  • User SQL Trace
  • Tidy Oracle Logs
  • Populate Table with Volume Data
  • Show Jobs
  • Add Message to Alert/Trace files
  • Monitor Temp Space
  • Show Installed DB components
  • Hidden-Parameters
  • List-Patch
  • CreateEmptyDB-Manual
  • Patch-Conflict
  • ADRCI-Purge-Trace-Dump-Files
  • Cleanup-Logfiles-Linux
  • Purge-Trace-Dump-Files-11g
  • Manage-AuditFiles-11gR2
  • Flashback-Database
  • Trace-SQL-Session
  • Script-Library
  • SQL-Library
  • DataPump-Ex2
  • DataPump-Ex1
  • Audit
  • Enable Audit
  • Home
  • DataGuard
  • SubMenu-Install-OracleDB
  • Submenu Oracle Upgrades
  • install-oracle11g-on-linux-with-asm-Video
  • Upgrade-11.2.0.3-12.1
  • Oracle-Upgrade-11g-12c-Videos
  • Install-Oracle11g-ASM-Linux
  • Test-HTML
  • Install
  • DataGuard
  • PL SQL Optimier
  • Papers & Articles
  • Storage
  • Home
  • ASM Clustering
  • Q&A
  • Troubleshooting
  • Home
  • Upgrade 10.2-11.2 Database
  • SubMenu Oracle RAC Administration
  • SubMenuOracle RAC Cluster Administration
  • SubMenu Script Library
  • SubMenu Storage Performance
  • SubMenu SQL Library
  • SubMenu Linux Installation
  • SubMenu Linux Admin
  • Submenu Backup
  • SubMenu Misc
  • SubMenu Performance
  • Sub Menu Duplication
  • Sub Menu Golden Gate
  • Sub Menu OEM
  • SubMenu RAC Installation
  • Install Oracle11g OL5 ASM Linux
  • Install-Oracle11g-ASM-Linux6.3-VBox
  • Installing Oracle Database 11g R2 on Linux with AS...
  • Create RAC OEL
  • Oracle Database 11gR2 Installation without ASM On ...
  • Backup to Tape using Netbackup
  • Full Database backup using Netbackup
  • RenameDB
  • Manually-Create-XML
  • Upgrade-12c

My Links

  • gmail
  • Oracle Community
  • Yahoo mail

Blogroll

  • The Oracle Instructor
    Pickleball & Longevity
  • Alejandro Vargas' Blog
    Moving Databases from ASM to ZFS on Exadata
  • Jaffar's (Mr RAC) Oracle blog
    Exadata X8M - World's Fastest Database Machine
  • Oracle DBA - Tips and Techniques
    Pluggable Database Cloning using Snapshot Copy
  • AskDba.org Weblog
    Identifying PostgreSQL Bloat and fixing it without downtime
  • The Tom Kyte Blog
    Upcoming Events...
  • Oracle Database - Oracle Database
  • EXPLORING ORACLE

Archive-Folders

  • Archive-Site

Total Pageviews

Subscribe To Blog

Posts
Atom
Posts
All Comments
Atom
All Comments

Popular Posts
Awesome Inc. theme. Powered by Blogger.

Cluster Map