Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Execution Plan: Cost (%CPU)

871977Jul 6 2011 — edited Jul 11 2011
Hi all,

I executed this update statament:

SQL> update oe.CUST_PAYMENT_INFO set CREDIT_CARD_NUMBER='4556988708236903' where CREDIT_CARD_NUMBER='4556988708236902';

524288 rows updated.

And the execution plan is as follow: (please refer the the link bellow)

http://www.flickr.com/photos/64727565@N06/5908120477/

My question is:

What does Cost (%CPU) 1298 (1) mean?

Thank you!
Dan.

Comments

Dude!
Answer
VirtualBox can run VMs created by VMware Workstation or Server.

RHEL/CentOS/OEL:
# sudo yum install qemu

Ubuntu, Debian:
# sudo apt-get install qemu

1. Convert a VMWare Image to VirtualBox Image:
# qemu-img convert vmware.vmdk /tmp/vbox.bin

2. Use VBoxManage to convert image:
# VBoxManage convertdd /tmp/vbox.bin vbox.vdi

- Start Virtual Box
- Goto File > Virtual Disk Manager
- Click Add.  Locate and select the copied .vmdk file. Click OK.
- Create a New VM as usual using the added vmdk file
- Boot the VM


To convert virtualbox image in to vmware image you can use following:

1. Convert .vdi file in to .raw file
# VBoxManage internalcommands converttoraw vbox.vdi vbox.raw

2. Convert .raw file into .vmdk
# qemu-img convert -O vmdk vbox.raw test.vmdk
Marked as Answer by 732975 · Sep 27 2020
732975
Genius! Thank you Markus!
I've used VMware fusion (which is for mac, as you know it), but will that make any difference from the ones
created by VMware Workstation or Server ?

Edited by: user1175367 on Jul 28, 2010 3:49 PM
732975
comments as above.
Dude!
I do not use WMware Fusion on my Macbook Pro anymore since I needed Firewire support and therefore use rEFlt with native triple boot now.

Q.app, which is Qemu for MacOSX. It can be found here:
http://www.kju-app.org/

Qemu supports the following formats: qcow2 vvfat vpc bochs dmg cloop vmdk qcow host_device raw
# qemu-img.exe convert -O vmdk hdd.vdi hdd.vmdk

VMware provides a tool called VMware Converter. VMware Converter eases interoperability among VMware hosted products (Workstation, VMware Server, VMware Player, and Fusion), VirtualCenter-managed ESX Server 3.x and 2.5.x, and unmanaged ESX Server 3.x.

http://www.vmware.com/support/converter/doc/releasenotes_conv302.html

It's for Windows platform only, but below can be used to convert a Windows system running inside Virtualbox to WMware fusion on Mac.
http://www.vmware.com/download/fusion/windows_to_mac.html
732975
thank you
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 8 2011
Added on Jul 6 2011
#general-database-discussions
7 comments
2,779 views