ඔබේ අනාගතය දැනගන්න (Know ur Future)
Download this software to know it

Download


uploader:
retuom (elakiri.com)

Labels:



Download Now!

Labels:

--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!..

Labels:

Cyclomatic Complexity

0 Comments Posted by Hirushan De Silva at 8:01 AM

Labels:



Angel -SLIIT Talent Show 2009

0 Comments Posted by Hirushan De Silva at 8:18 AM

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

Labels:

SLIIT DCCN III - LAB 10 Answer

0 Comments Posted by Hirushan De Silva at 6:52 AM

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

Labels:

Labels:



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

Labels:


This is the best Emulator
to play JAR (Mobile Games)
on to your PC.........

You just need to do is to
open that JAR file with this
software..........

Enjoy Playing JAR games with this.........

Download!

Labels:

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.

Download!

 

Technorati Tags:


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:

Download!


Speedup Your Typing 2.9.4

0 Comments Posted by Hirushan De Silva at 5:39 PM

Technorati Tags:

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).

Download Now!


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

Part 1

Part 2

Part 3

Technorati Tags:


Pepakura Designer v3.0.3b

0 Comments Posted by Hirushan De Silva at 11:51 AM

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

 

Download

password : sherwood@cw

Labels: