Here we will first create a tablespace and then we will create a user for that tablespace.
create tablespace ahsan
add datafile 'e:\ahsan.dbf' size 100 m;
create user ahsan identified by welcome
default tablespace ahsan temporary tablespace temp;
grant create session, connect, resource to ahsan;
Hence now you are ready with the new tablespace and a new user that belongs to the ahsan tablespace;
Recently, I switched to Mac from Windows machine. I had a challenge to make Mac development environment as similar to Windows development environment. Being a java developer I usually use Oracle database. So I tried to install it first on my mac, then I found somehow that Oracle does not support my mac version. Then I had to install Parallels Desktop to make it work.
I proceeded this way
1. Install Parallels Desktop, You can find how to do it on parallels support center.
2. Install Oracle 10g database on Parallels Desktop, It is smooth, so no problem.
3. Steps to install InstantClient and Sqlplus package on mac to access Parallel's oracle DB.
4. Download InstantClient and SqlPlus packages from Oracle download site.
5. Extract these two packages to a single directory like I chose /Applications/OracleClient
6. Copy tnsnames.ora file from parallels oracle installation to the Mac's /Applications/OracleClient directory you chose for installing InstantClient and SqlPlus.
7. Modify your .bash_profile to indicate these entries
PATH=/Applications/OracleClient:${PATH}
export PATH
ORACLE_HOME=/Applications/OracleClient
export ORACLE_HOME
DYLD_LIBRARY_PATH=/Applications/OracleClient
export DYLD_LIBRARY_PATH
TNS_ADMIN=/Applications/OracleClient
export TNS_ADMIN
8. Check for the IP of the Parallel's Desktop machine and note it.
9. Check for the IP of the Mac machine and note it.
10. open vi editor and edit /etc/hosts file for Mac machine to reflect the IP obtained from parallels desktop machine(Step 7)
192.168.128.82 ahsan-javed.mydomain.com
(Note:ahsan-javed.mydomain.com is the machine name that was given in my office network.)
11. open notepad and edit C:/Windows/System32/drivers/etc/hosts file for Parallels Desktop to reflect the IP obtained from Mac machine (step 8)
192.168.128.132 ahsanjaved
(Note: ahsanjaved is the machine name I assigned to parallels desktop while installing Windows XP on it.)
12. Go to Windows Control Center and disable firewall/enable 1521,1158 and 5506 ports for communication between Parallels Oracle and Mac machine.
13. Now go to shell and type sqlplus. it should ask you for username and password. Here you go connected.
To view open cursors on oracle
No of Open cursors on Oracle(Admin permission is required)
select count(*) from v$open_cursor;
To see open_cursors parameter on oracle db.
show parameter open_cursors;
To set open_cursors parameter on oracle db.
alter system set open_cursors=700 scope=memory;
To see the sql query associated with cursor
select sid, sql_text from v$Open_cursor order by sid, sql_text;
To select number of open cursors, machine name, operating system and user name executing the query, run the following
SELECT v.value as numopencursors ,s.machine ,s.osuser,s.username
FROM V$SESSTAT v, V$SESSION s
WHERE v.statistic# = 3 and v.sid = s.sid ;
To rebuild unusable indexes on Oracle schema we can use this simple script.
This script first checks for all unusable indexes in the entire schema and then rebuild them to VALID state.
set serverout on
set head on
set echo on
declare
str varchar2(500);
begin for i in (select index_name,status from user_indexes where Status='UNUSABLE')
loop
str:='alter index ' || i.index_name || ' rebuild unrecoverable' ;
execute immediate str;
dbms_output.put_line('rebuilt index ' || i.index_name);
end loop;
end;
/
Microsoft has recently launched its tech news aggregator platform called /Web. It is a platform for getting all technology related news in a consolidated manner. They allow contents from all other platforms as well. This site is beautifully designed into 6 sections where you can find relevant contents.
Inspiration
Methods
Business
Events
Blogs
Products
You can subscribe to the all articles at this link.
Today I had to find sum of nth column entries from one of my csv files. I just googled and found a nice way of doing it using awk.
Suppose my input csv file is named as test.out and I have to find sum of all nth column entries of it.
I just created an awk script file named test.awk for setting the FS variable and providing the summation logic to awk.
#test.awk
BEGIN {FS=","}
{ sum+=$COL}
END { print sum }
Then every thing is easy
Use the awk command as follows with input file test.out. Replace 8 with any column index you want.
awk -f test.awk COL=8 < test.out
Google India has released a new service called Google SMS channel. This service lets you connect to all kind of news services, blog updates, cricket score, rss reader sync features at one single stop. While you can create any public channel, you can also create private channels for your family members and frieds. All you have to go to http://labs.google.co.in/smschannels link and create a nick name for you and enter your mobile no along with the name of the channel. Once created your friends and family member can subscribe to this channel and can send the messages to the channel without paying anything to the carrier services. You can also subscribe to this channel using web or mobile. While using mobile sign up you will have to give your mobile no. to proceed further.
SMS Commands
Almost everything that you can do on the website can be done over SMS. Detailed in the table below is the list of SMS commands and what they do.
All you have to do is to send SMS to 9870807070 with following content
on
off
delete
send
Today, I was perplexed with a problem related to a partitioned table in oracle. My concern was to determine when I drop a partition of a table what happens the indexes on that table. I figured it out like this.
I created a partitioned test table as follows
CREATE TABLE TEST (
COLUMN1 NUMBER(9),
COLUMN2 NUMBER(9),
)
PARTITION BY LIST (COLUMN1)
(PARTITION LOW_PART VALUES (-1)
);
I created local bitmap indexes on COLUMN1 column of this table using a stored procedure
EXEC CREATE_BITMAP_INDEXES('TEST', 'COLUMN1');
This procedure created a local bitmap index IX_TEST_COLUMN1 on this table.
I then queried oracle about the state of bitmap indexes just created by this query
SELECT INDEX_NAME, STATUS FROM USER_IND_PARTITIONS WHERE PARTITION_NAME = 'LOW_PART';
SQL>
INDEX_NAME STATUS
--------------------- ---------------------
IX_TEST_COLUMN1 USABLE
Hence the created bitmap index is in usable state just after creation.
Now I inserted lots of data into this table from another staging table
INSERT /*+ APPEND */ INTO TEST
(COLUMN1, COLUMN2)
(SELECT COLUMN1, COLUMN2 FROM TEST_STAGING);
COMMIT;
Again I queried oracle about the state of local bitmap index.
SELECT INDEX_NAME, STATUS FROM USER_IND_PARTITIONS WHERE PARTITION_NAME = 'LOW_PART';
SQL>
INDEX_NAME STATUS
--------------------- ---------------------
IX_TEST_COLUMN1 USABLE
Again this index is in usable state. Hence local indexes status does not change upon insertion of data.
Now I tried to be tricky. I just created a new partition named as HIGH_PART on the table TEST.
ALTER TABLE TEST ADD PARTITION HIGH_PART VALUES (1000);
I then again queried oracle about the state of bitmap indexes
SELECT INDEX_NAME, STATUS FROM USER_IND_PARTITIONS;
SQL>
INDEX_NAME STATUS
--------------------- ---------------------
IX_TEST_COLUMN1 USABLE
Hence the created bitmap index is in usable state even after new partition addition.
Now I dropped the default partition as follows
ALTER TABLE TEST DROP PARTITION LOW_PART;
I then again queried oracle about the state of bitmap indexes
SELECT INDEX_NAME, STATUS FROM USER_IND_PARTITIONS;
SQL>
INDEX_NAME STATUS
--------------------- ---------------------
IX_TEST_COLUMN1 USABLE
Hence it is verified that local bitmap indexes on a partitioned table does not become unusable on
1. insertion of data
2. addition of new partition(When you add a partition, actually, a new partition is created for the local bitmap index as well)
3. drop of a partition (When you drop a partition, actually, the corresponding partition from the local bitmap index is dropped as well)
So when and which kind of indexes become unusable.
If you have global indexes on a partitioned table, it will become unusable when
1. you are trying to drop a partition.
2. you are splitting a partition to two new partitions
3. you are moving partitions
In that cases you will have to explicitly rebuild those global indexes as follows.
ALTER INDEX G_IX_TEST_COLUMN1 REBUILD PARTITION HIGH_PART;
Here it is assumed that G_IX_TEST_COLUMN1 is a global index on HIGH_PART partition of TEST table.
Recently I came across a problem of viewing the oracle sql queries results using sqlplus. I selected for this query
"select * from mytable"
Now my table contains 3000 rows. The result contains header breaks repeated after every 14 lines. so it looked very cluttered. I wanted to have it in nice format without any headers repeated. I just googled it and found a very nice command "pagesize"
I used it as follows
set pagesize 3000.
It sets the no of records to be shown at a time on sqlplus pompt without showing headers break. so I was now able to run my same query and it ran like charm.
Voila....no more cluttered line breaks...:)
Google has launched a new product from their ad management suite, called Ad Manager. This free and currently beta service is a framework for webmasters, helping them to sell their ad space. It sounds like an interesting offering for all those who directly sell their ad space on some of their sites. Google in return would then make money simply due to the chance that you will (completely optionally) accept their AdSense ads to show whenever you don’t have advertisers yourself.
Google Ad Manager seems to have been in development at Google at least since late 2006.
If you have an AdSense account, you can sign in to Ad Manager today. If not, apply for an AdSense account now. A Google AdSense account is a technical requirement for creating an Ad Manager account.
Ad Manager can help you sell, schedule, deliver, and measure both directly-sold and network-based inventory. It offers an intuitive and simple user interface, Google serving speed and reliability, and significant cost savings. Best of all, Ad Manager can be optionally integrated with Google AdSense to offer you an automated way to maximize the revenue of your unsold and network-managed inventory.
Today, while searching for java I found that google.com now offers google suggest feature on its home page. It means that Google suggest feature has been now available to google site after graduating from google labs. The Google Suggest feature originally started as a 20% project in 2004, and has since expanded to Google Labs, Toolbar, Firefox search box, Maps and Web Search for select countries, the iPhone and BlackBerry, YouTube, and now Google.com.
As you type into the search box, Google Suggest guesses what you're typing and offers suggestions in real time. This is similar to Google's "Did you mean?" feature that offers alternative spellings for your query after you search, except that it works in real time. For example, if you type "bass," Google Suggest might offer a list of refinements that include "bass fishing" or "bass guitar." Similarly, if you type in only part of a word, like "prog," Google Suggest might offer you refinements like "programming," "programming languages," "progesterone," or "progressive." You can choose one by scrolling up or down the list with the arrow keys or mouse.
Google has a new tool for quick translations.
All you need to have to do is just search for "translate", followed by a word or an expression and the optional "into English". For example, you can search for [translate désormais] and Google shows the entry from an automatically-generated bilingual dictionary.
Unfortunately, you can't use the search box as a shortcut for Google Translate because full texts aren't yet translated. The bilingual dictionary is only available for the following language pairs: English <-> French/Italian/Spanish/Portuguese/German/Russian/Chinese/Korean/Hindi. It's interesting that Google shows results from Google Image Search next to the translations.
Hi, ever tried to send mail from unix command prompt that contains multiple files as attachments, here is how you can do it in just a single command.
(uuencode file1.oldname file1.newname; uuencode file2.oldname file2.newname;
uuencode file3.oldname file3.newname; uuencode file4.oldname file4.newname) |
mailx -s "Subject of the mail" xyz@abc.com
Above snippets sends the file1, file2, file3 and file4 to the xyz@abc.com as attachments in a mail with a subject "Subject of the mail".
I have used a uuencode command that takes files as input and encode them over the network. The file1.oldname appears as file1.newname to the receiver when he/she opens the attachment.
You can send single file as an attachment as follows
mail -s "Subject of the mail" xyz@abc.com < file1
Google has recently launched a free media planning tool called AdPlanner.
It is supposed to be competitor tool of comscore's Media Metrix or Neilson's @Plan. This tool is invitation only and you have to verify your identity to google before signing up. It has some basic reports that shows you data for UV’s, Reach, Page Views and adSense related informations in case the sites contain adSense adverts. It also contains target audience feature but that is specific to US only. I think they will be enhancing it in future. As opposed to AtPlan and Media Metrix, Google's AdPlanner does not support mixing of audience data based on different demographic information. They support a higher no of demographic data as well. Also AdPlanner does not give any input on how the sites outside their own network will be catered out, especially in case if they are good target for advertising.
A few months ago we announced that we were testing a new product called Knol. Knols are authoritative articles about specific topics, written by people who know about those subjects. Today, we're making Knol available to everyone.
The web contains vast amounts of information, but not everything worth knowing is on the web. An enormous amount of information resides in people's heads: millions of people know useful things and billions more could benefit from that knowledge. Knol will encourage these people to contribute their knowledge online and make it accessible to everyone.
The key principle behind Knol is authorship. Every knol will have an author (or group of authors) who put their name behind their content. It's their knol, their voice, their opinion. We expect that there will be multiple knols on the same subject, and we think that is good.
With Knol, we are introducing a new method for authors to work together that we call "moderated collaboration." With this feature, any reader can make suggested edits to a knol which the author may then choose to accept, reject, or modify before these contributions become visible to the public. This allows authors to accept suggestions from everyone in the world while remaining in control of their content. After all, their name is associated with it!
Knols include strong community tools which allow for many modes of interaction between readers and authors. People can submit comments, rate, or write a review of a knol. At the discretion of the author, a knol may include ads from our AdSense program. If an author chooses to include ads, Google will provide the author with a revenue share from the proceeds of those ad placements.
We are happy to announce an agreement with the New Yorker magazine which allows any author to add one cartoon per knol from the New Yorker's extensive cartoon repository. Cartoons are an effective (and fun) way to make your point, even on the most serious topics.
Everyone knows something. See what people are writing about, then tell the world what you know: knol.google.com
BOSS (Build your Own Search Service) is Yahoo!'s open search web services platform. The goal of BOSS is simple: to foster innovation in the search industry. Developers, start-ups, and large Internet companies can use BOSS to build and launch web-scale search products that utilize the entire Yahoo! Search index. BOSS gives you access to Yahoo!'s investments in crawling and indexing, ranking and relevancy algorithms, and powerful infrastructure. By combining your unique assets and ideas with our search technology assets, BOSS is a platform for the next generation of search innovation, serving hundreds of millions of users across the Web.
Midori has been reported to be a possible commercial successor to the Singularity operating system, a research project started in 2003 to build a highly-dependable operating system in managed code.
Microsoft is working on a managed-mode operating system, code-named Midori. Managed mode is a computer program code that executes under the management of a virtual machine, unlike an unmanaged code, which is executed directly by the computer's CPU.
Midori has been reported to be a possible commercial successor to the Singularity operating system, a research project started in 2003 to build a highly-dependable operating system in which the kernel, device drivers, and applications are all written in managed code.
According to Microsoft, Midori is being designed from the ground up to tackle challenges that cannot be met by simply evolving its existing technology. Midori's proposed design is Internet-centric and provides an overall "connectedness" between applications and devices. When Windows was first designed,there was no "Internet" as we understand it today, and things were added later in patches. With the Midori however, it will focus on concurrency for both distributed applications and local ones.
Eric Rudder, Senior Vice President for technical strategy at Microsoft and an alumnus of Bill Gates' technical staff, is heading up the effort.
No time frame for development has been set for Midori as its considered a 'research project' at the moment, according to Microsoft technical fellow Burton Smith. A spokesperson added that Midori is one of many projects in incubation at Microsoft Research.
Source: Techtree.com
Google Inc. is working on plans to start a venture-capital arm, according to several people briefed on the discussions.
The group will be led by David Drummond, Google's senior vice president of corporate development and chief legal officer, according to two of these people. Google has hired William Maris, a 33-year-old former entrepreneur who has worked as an investor, to help set up the venture. How the group will be structured and what sort of investments it is likely to target remain unclear.
Google executives previously have bandied about the idea of launching a venture-capital unit, and the plans could still fall through. Mr. Maris couldn't be reached for comment.
The move would make Google the latest technology giant to take on a more-formal role in seeding start-ups. Intel Corp. has had a large venture-capital arm for years, as have Motorola Inc., Comcast Corp. and many others. In the consumer-Internet area, Walt Disney Co.'s Steamboat Ventures has invested in a number of Web start-ups. So has Amazon.com Inc., which has funded a number of young companies without structuring a formal fund.
Their track records have been mixed. Corporate venture-capital arms have been hampered by challenges that traditional venture-capital businesses don't face. Venture capitalists invest in private start-ups at an early stage, usually in hopes of a big payout if the company is sold or if its stock goes public.
Many start-ups fear that taking corporate money limits their options and comes with strings that could turn away other potential investors -- such as a right to buy the company at a later date. Some funds with less competitive compensation have struggled to retain managers, and corporate venture funds often don't allow senior employees to invest personal money in their funds, while other venture funds typically do.
Corporate venture capitalists' share of overall venture-capital dollars invested in U.S. companies fell to 7% in the first half of 2008 from 8.4% in 2007, according to PricewaterhouseCoopers and the National Venture Capital Association. Corporate venture capitalists were involved in roughly 20% of the venture-capital deals signed during the first half of 2008, compared with 21% in 2007.
With an abundance of venture-capital money available today, Google will have to convince entrepreneurs that it has something to offer that other investors don't. It has several advantages, including a brand admired by start-ups and the ability to offer sizable technical resources.
The Mountain View, Calif., Web giant has long preferred to buy companies rather than invest in them, and has plenty of cash to keep doing so. But it has invested millions of dollars in companies ranging from Current Communications, which offers broadband Internet over power lines, to Meraki, a wireless-Internet-equipment manufacturer. The company said last year that it intends to invest hundreds of millions of dollars in renewable-energy projects in conjunction with its philanthropic arm, Google.org. Google also has launched a number of informal funding programs, including contests for software developers.
The new venture could help formalize those efforts and could help Google expand the footprint of some of its online-software products geared at small businesses. Other corporate venture funds have made investments as a way to gain experience in new product areas and markets.
Yahoo is making a number of changes to its default search experience tonight to add more structured data to results. Yelp, Yahoo Local and LinkedIn SearchMonkey widgets are being added to search results automatically, eliminating the need for users to go into the search gallery and add them manually.
SearchMonkey is a key part of Yahoo’s attempts to embrace the semantic web and open standards in general.
With SearchMonkey, site owners create “applications” for Yahoo search that can be installed by users in the same sense that Facebook applications can be installed. Each application modifies results for a certain URL specification (for example, all reference pages on Wikipedia or product pages on Amazon). Modifications include both changes to the basic elements of a search result (the title and description) and additions such as an image, deep links, and key/value pairs.
Users can also add additional widgets via the Yahoo Search Gallery.
Here’s the Yelp search result example we used in our first post about SearchMonkey:
Cuil - The Next "Google Killer"?
With the recent press about Cuil, the latest "Google-Killer Search Engine", it seems that we've forgotten the lessons from the late 90s. Cuil's claim to fame appears to be:
It was founded by Ex-Googlers
They claim to have a larger web-page index than Google
The first point is somewhat interesting, but not exactly a path to success. As for the second point, I'd like to say: (1) How do you know that? (2) What does that mean? (3) So?
How Do You Know That?
Google doesn't release the size of its index.
What Does That Mean?
How did they count the size of Google's index? If two urls have identical content, are those the same page? What if the content is merely very similar? Suppose the only difference is that Google isn't indexing the duplicate pages (or, say, the spammy pages), does it matter that Cuil's index is bigger?
So?
Bigger isn't better. I thought we'd learned that back in the late 90s. For most queries, it doesn't matter if the search engine returns 30 results or 1000. You' generally don't go past the 3rd page. What really matters is the ranking of the pages. If the page you wanted is on the 15th page, it might as well not be there at all.
How Cuil Actually Stacks Up:
Interface:
Pros: Slick and pretty. The content drill down is nice - although it doesn't always display relevant things. I also like having the page numbers locked at the bottom so that I don't have to scroll.
Cons: Ranking of results is unclear. There's 3 columns and the rows don't line up with each other. When I'm trying to actually find a good page, I'm not sure where to read.
Speed, Reliability, Performance
Pros: Speedy
Cons: Searches frequently fail. I got "no results" when I tried searching for "Google Talk". I tried the same search a second time and it worked.
Search Result Quality
Selection Criteria for Sample Queries: All queries were selected from my Google Web History, and were queries in which I was attempting to answer a question.
Query #1 (an error I am getting with Google App Engine): error 403 cpu quota exceeded
Cuil: No Results
Yahoo: #1 Result is Google App Engine article about it
Google: #1 Result is a Google Group question about this. #3 (or #5) is the Google App Engine article
Winner: with Google as a close second.
Answer: Common Error. Try using python's profiling.
Query #2: send pdf to kindle
Cuil: Show articles mentioning that you can do this, but not telling me how.
Yahoo: #1 Result is a discussion about it.
Google: #1 Result is a link to Amazon explaining how to do this.
Winner: Google
Answer: Your Kindle has an email address that you email the pdf to.
Query #3: 99 luftballoons translation
Cuil: #1 Result is a translation
Yahoo: #1 Result is someone asking for a translation
Google: #1 Result is a translation
Winner: Cuil & Google (tie).
Answer: It's about war. And red balloons. :-)
Query #4: "imagine no religion" billboard seattle
Cuil: No results
Yahoo: #1 Result is blog post mentioning it. #2 Result is press release about it.
Google: #1 Result is press release about it. #2 Result is blog post mentioning it.
Winner: Google, with Yahoo as a close second
Answer: This billboard was put up by the Freedom From Religion Foundation.
Query #5: percent female math majors in US
Cuil: No results
Yahoo: #1 is a seemingly-relevant but dead link. #2 also seems relevant, but not a direct answer. #3 is about carbon monoxide levels at death. Hmm...
Google: #1 is related article that contains an answer to the question. #2 is a very relevant study, and the summary (which is as far as I read) indirectly answers the question. #3 is about a particular school's gender ratio.
Winner: Google.
Answer: 48% of math majors in the US are female.
Bonus Query: cuil
Cuil: Nothing even remotely related to the search engine.
Yahoo: #1 result is the search engine.
Google: #1 result is the search engine.
Winner: Google and Yahoo. Poor Cuil...
Answer: Google and Yahoo both know what Cuil is (as well as what each other). Cuil, sadly, does not.
Conclusions
While Cuil may claim to have a larger search index, the number of "no result" searches certainly suggest lesser web coverage. The flashy interface is mostly just that - flashy. It's pretty, but the three column layout leave your eyes wandering all over the page unsure of which result is meant to be the most relevant. A more cynical person might even suggest that the three column layout helps mask the fact that Cuil may not know an appropriate ranking.
If you want to get real traction as yet-another-search-engine, you'd better attack a different market from Google (or Baidu in China, or Yahoo in Japan, etc) or you'd better be substantially better than Google. Just being better isn't good enough, and Cuil has a long way to go even on that end.
Posts
All Comments
