--execute UTLXPLAN.sql & SampleDB.sql
select c.clno, c.name
from client c, purch p
where c.clno = p.clno and p.qty>1000;
--the following will find the better query plan
explain plan for
select c.clno, c.name
from client c, purch p
where c.clno = p.clno and p.qty>1000;
--to see the query plan
select * from PLAN_TABLE;
--to format the output use the utlxpls_mod.sql file
--to see the values
alter session set optimizer_mode=all_rows;
alter session set "_optimizer_cost_model" = cpu;
--after altering again explaing the plan & select * from PLAN_TABLE, then run the utlxpls_mod.sql, then your cost values should be there
--getting another query plan
explain plan for
select t.*
from trading t
where t.exchange='Tokyo';
--PLAN_TABLE
Plan Table
--------------------------------------------------------------------------------
| Operation and options | Object | cost | cpu_cost | io_cost |
--------------------------------------------------------------------------------
| SELECT STATEMENT | | 4 |125588 | 3 |
| TABLE ACCESS FULL |TRADING | 4 |125588 | 3 |
--------------------------------------------------------------------------------
TABLE ACCESS FULL - since there is no index in the table, when you create index the cost will be reduced.
--creating index for the trading table
create index index_3 on trading(exchange);
--after creating the index the cost reduces
Plan Table
--------------------------------------------------------------------------------
| Operation and options | Object | cost | cpu_cost | io_cost |
--------------------------------------------------------------------------------
| SELECT STATEMENT | | 3 |21735 | 2 |
| TABLE ACCESS BY INDEX ROWID |TRADING | 3 |21735 | 2 |
| INDEX RANGE SCAN |INDEX_3 | 2 |14443 | 1 |
--------------------------------------------------------------------------------
--to drop an index
drop index [index_name];
--all the indexes will be stored inside the user_indexes table
select index_3
from user_indexes
where table_name='TRADING'
/
--if you used simple letters for trading when creating the table, you have to use capital letters while selecting the index [TRADING]
select index_name
from user_indexes
where table_name='TRADING'
/
INDEX_NAME
------------------------------
INDEX_3
SYS_C0023391
--SYS_C0023391 is the system generated index, and is created for primary keys.
--INDEX_3 is the index we created
select DBMS_METADATA.GET_DDL('INDEX', u.index_name)
from user_indexes u
where table_name = 'TRADING'
/
DBMS_METADATA.GET_DDL('INDEX',U.INDEX_NAME)
--------------------------------------------------------------------------------
CREATE INDEX "DIT7C1_0055"."INDEX_3" ON "DIT7C1_0055"."TRADING" ("EXCHANGE")
CREATE UNIQUE INDEX "DIT7C1_0055"."SYS_C0023391" ON "DIT7C1_0055"."TRADING" (
--creating index for client table
create index index_3 on client
DBMS 7 answer provided by Russel Dharmarathne!..
Part 1:
Router1 configuration.......
router(config)#router ospf 1
Router(config-router)#network 172.16.10.0 0.0.0.255 area 0 //backbone area (same domain)
Router(config-router)#network 10.10.10.196 0.0.0.3 area 0
Router(config-router)#network 10.10.10.200 0.0.0.3 area 0
Router2
Router(config)#router ospf 1
Router(config-router)#network 10.10.10.192 0.0.0.3 area 0
Router(config-router)#network 10.10.10.196 0.0.0.3 area 0
Router(config-router)#network 192.168.10.0 0.0.0.255 area 0
Router 3
Router(config)#router ospf 1
Router(config-router)#network 10.10.10.192 0.0.0.3 area 0
Router(config-router)#network 10.10.10.200 0.0.0.3 area 0
Router(config-router)#network 172.16.10.32 0.0.0.31 area 0
Part 2:
Router#show ip route
Part 3:
Router#show ip ospf database
Router ID's :
Router 1:
OSPF Router with ID (172.16.10.1)
Router 2:
OSPF Router with ID (192.168.10.1)
Router 3:
OSPF Router with ID (172.16.10.33)
Part 5:
PC>tracert 172.16.10.33
Shortest Path
R1,R2,R3--------------
Router(config)#hostname R1
Enable Secret Password:
Router(config)#enable secret class
Configure a password of cisco :R1,R2,R3
R3(config)#line console 0
R3(config-line)#password cisco
R3(config-line)#login
Configure a password of cisco for vty connections. R1,R2,R3
R1(config)#line vty 0 4
R1(config-line)#password cisco
R1(config-line)#login
Enable OSPF using process ID 1 on all routers for all networks:
R2(config)#router ospf 1
R2(config-router)#network 192.168.20.0 0.0.0.255 area 0
R2(config-router)#network 10.1.1.0 0.0.0.3 area 0
R2(config-router)#network 10.2.2.0 0.0.0.3 area 0
R1(config)#router ospf 1
R1(config-router)#network 192.168.10.0 0.0.0.255 area 0
R1(config-router)#network 192.168.11.0 0.0.0.255 area 0
R1(config-router)#network 10.1.1.0 0.0.0.3 area 0
R2(config-router)#network 209.165.200.0 0.0.0.3 area 0
R1(config)#router ospf 1
R1(config-router)#network 192.168.10.0 0.0.0.255 area 0
R1(config-router)#network 192.168.11.0 0.0.0.255 area 0
R1(config-router)#network 10.1.1.0 0.0.0.3 area 0
Configure a loopback interface on R2.
R2(config)#interface lo 0
R2(config-if)#ip address 209.165.200.225 255.255.255.224
R2(config-if)#no shutdown
Configure IP addresses for the VLAN 1 interface on each switch.
Switch 1:
Switch(config)#interface vlan 1
Switch(config-if)#ip address 192.168.10.2 255.255.255.0
Switch 2:
Switch(config)#interface vlan 1
Switch(config-if)#ip address 192.168.11.2 255.255.255.0
Switch 3:
Switch(config)#interface vlan 1
Switch(config-if)#ip address 192.168.30.2 255.255.255.0
Configure each switch with the appropriate default gateway.
Switch 1:
Switch(config)#ip default-gateway 192.168.10.1
Switch 2:
Switch(config)#ip default-gateway 192.168.11.1
Switch 3:
Switch(config)#ip default-gateway 192.168.30.1
Task 2: Configuring a Standard ACL
R1(config)#ip access-list standard std-1
R1(config-std-nacl)#deny 192.168.11.0 0.0.0.255
R1(config)#interface fastEthernet 1/0
R1(config-if)#ip access-group std-1 in
Task 4:
R2(config)#ip access-list standard task-4
R2(config-std-nacl)#permit 10.2.2.0 0.0.0.3
R2(config-std-nacl)#permit 192.168.30.0 0.0.0.255
R2(config-std-nacl)#deny any
R2(config)#line vty 0 4
R2(config-line)#access-class task-4 in
R1#telnet 10.1.1.2
Cisco ACL Editor and Simulator
Cisco ACL Editor and Simulator can create Standard and Extended ACLs, edit Standard and Extended ACLs and simulate their use on a Cisco Router. You can save both Standard and Extended ACLs in their respective files and export all the ACLs to the Clipboard for pasting into HyperTerminal!
Features
Create Standard ACLs
Create Extended ACLs – Using IP, TCP, UDP and ICMP Protocols.
Edit Standard and Edit Extended ACLs
Visually Simulate Standard ACLs
Visually Simulate Extended ACLs
Save Standard ACLs as .sacl as XML
Save Extended ACLs as .eacl as XML
Export Standard and Extended ACLs – Ready for HyperTerminal
Download 30 day trial
Mobile Phone—>> Web Camera
Whenever you need a high-quality web camera, just take your Symbian
phone from a pocket! With Mobiola Web Camera software you can throw
away your bulky USB webcam. It works with most Windows applications and
online services, very simple to install and easy to use.
- Transforms your mobile phone into high-quality PC webcamera.
- Works through WiFi (NEW!), Bluetooth or USB.
- Screen Capture functionality, when device screen can be demonstrated on PC real-time.
- Cool video effects, to have fun with your friends. - NEW!
- Works with Skype, Yahoo, YouTube, MSN, AOL IM, ICQ and many others.
- Compatible with Windows Vista/XP/2003/2000.
Technorati Tags: Software
Deep in the heart of the desert, far from civilization, there's a hidden treasure cave. People say that priceless treasures of unseen beauty are hidden there, but the cave is locked and no one can enter. Can you finesse the stones and unlock the treasure cave? Fresh and fun match-3 game with addicting mechanics, beautiful graphics and rich music. Break the walls, collect the treasures and build up your own land to make your dream come true! Unique bonuses and challenging obstacles will provide hours of amusement and pure fun!
System requirements:
Windows 98/ME/2000/XP/Vista
DirectX 7
800 MHz
256 MB RAM
Download Links:
Technorati Tags: Software
The most important and basic score is "words per minute", or "wpm" for short. Often, this is a corrected score, where each error made during the test reduces the "words per minute" by one. Another common score is an accuracy percentage -- which is simply the number of words you got right compared to how many you typed. For instance, 90% accuracy means you averaged 9 out of 10 words right.
So, how fast can you type? The simple typing test calculator below will calculate your speed (words per minute).
Description:
VMware Workstation makes it simple to create and run multiple virtual machines on your desktop or laptop computer. You can convert an existing physical PC into a VMware virtual machine, or create a new virtual machine from scratch. Each virtual machine represents a complete PC, including the processor, memory, network connections and peripheral ports.
VMware Workstation lets you use your virtual machines to run Windows, Linux and a host of other operating systems side-by-side on the same computer. You can switch between operating systems instantly with a click of a mouse, share files between virtual machines with drag-and-drop functionality and access all the peripheral devices you rely on every day.
Release name: VMWare.Workstation.v6.5.3.185404.Incl.Keygen
Technorati Tags: Software
Pepakura Designer makes it easy to design original papercraft patterns by importing 3D model data. No special knowledge is required for making papercraft patterns. All you have to do is prepare the 3D model. You may use some 3DCG software released from other developers to make the 3D models for unfolding.
Windows 2000/XP/Vista
password : sherwood@cw
