Method 1: Using SQL*Plus password command
If you connected as sys and trying to reset the password for other user it will not ask for old password.
SQL> connect / as sysdba
Connected.
SQL> show user
How long needed For Google Adsense Approval for Blogspot? I Got In 2 Months for my new blog! 10 Guaranteed Tips!
Getting adsense approval will take atleast 12-48 hours from adsense team after you send a request. But some certain things you have to take care before sending a request for your fresh blog to the adsense team. In earlier days getting the Adsense approval was quite easy. That’s what I heard from my friends. But nowadays it is not easy to get approval from the Adsense team.
Les Paul Interactive Music Google Doodle – With record option still available with doodle collection
Google showed one of the wonderful doodle on Les Paul’s 96th birthday. That was the first interactive doodle from Google. You can play the guitar and record. The recorded one can be played later J Whoever not seen this doodle or never tried to record your play, still you can see and enjoy the doodle in the Google doodle collection.
How the Optimizer chooses Between Indexes and Full-Table Scan
The rule-based optimizer will almost always favor an access path involving an index to one involving full-table scan. This is because in the absence of any information about the sizes of tables, the index-based access path is the safer choice. A full-table scan might be faster than an index lookup in some circumstances- say 50% faster.
Choosing the best indexing strategy
Oracle’s default index type - the B*Tree index is suitable for improving access for a wide range of queries. B*Tree indexes can optimize exact lookups and range quires and can sometimes be used to resolve queries in their own right and without reference to the underlying table.
Creating indexes on Nullable Columns
Its usually wise to define the columns referenced in the where clause as NOT NULL so that indexing these columns can be effective. However, it can be worthwhile to use NULL values in an indexed column if the following conditions apply:
- The column is almost always NULL.
Oracle 11g RESULT_CACHE Hint : Faster Performance Queries, Advantages, Benefits
RESULT CACHE: Prior to oracle 11g, database stated with caching the data block in memory and which used to construct the result set for user queries. Even though the data blocks are cached in SGA, it needs to be reconstructed for the query output which takes time and resource.
