Friday 28 February 2020
Sunday 16 February 2020
Databases, IFTTT
08:50
Resource Manager
Oracle Database Resource Manager enables you to limit database resources. Oracle Database Resource Manager lets you specify how much of the resources you want to assign. It provides granular control of database resources allocated to users, applications, and services. It can be used to guarantee certain session a minimum and maximum amount of CPU. Limiting parallelism, active session pools to control maximum number of sessions within the group. The most interesting features is manage runaway sessions and switch groups. Manage runaway sessions help us with terminating user session whenever a session or call consumes more than specified resources. Any session in a particular group can be switched to another group if the session consumes more than specified resource.
Elements of Oracle Database Resource Manager
1. Resource consumer group
2. Resource plan
3. Resource plan directive
Resource consumer group is collection of user based on their need. SYS_GROUP and OTHER_GROUPS are two predefined groups. User SYS and SYSTEM belongs to SYS_GROUP and all other users within a plan that do not belongs to any group falls in OTHER_GROUPS.
Resource plan is the directives stating how the resource should be shared among the consumer groups.
The set of Reource plan directive determines how resources will be distributed among the users with in a Resource Plan.
Create dummy table for testing.
Copying data from same table to the table.
Create Service for single instance database.
Start service.
Check if service is listed on listener or not
Create pending area. If any already existing pending area.
Create Resource Manager Plan.
Create Plan Directives
Mapping services SRV_DEV to Resource Consumer Group.
Validate pending area.
Submit pending area.
Create tnsnames.
Connecting user using tnsnames.
Check current user is logged in using the services.
Execute cpu intensive query as user DILLI.
Show oracle resource related parameters.
Noticed CPU load has increased and PID 2519 has consumed 99.9% of CPU.
Set resource manager plan to DAY_PLAN.
Noticed CPU usage has decreased to 3.7% load.
Revert back the resource manager plan.
Noticed CPU% has increased to 99.9% for PID 2519.
Friday 14 February 2020
Feed, Ubuntu
19:14
Permanent Account Number (PAN) will become inoperative if it is not linked with Aadhaar by March 31, 2020, the Income Tax department has said.
The deadline for linking of PAN and Aadhar has been extended several times and the current deadline ends on 31 March, 2020.
Till January 27, 2020, over 30.75 crore PANs have already been linked to Aadhaar. However, 17.58 crore PANs are yet to be linked with the 12-digit biometric ID.
Feed, Ubuntu
19:14
to promote electronic toll collection, the Central government decided to offer FASTag for free from February 15. The Ministry of Road Transport and Highways today waived the cost of FASTag of ₹100 for a 15-day period. The new rule will be effective from February 15 to February 29, the ministry said.
"In order to further increase digital collection of user fee via FASTag at NH fee plazas, the National Highways Authority of India (NHAI) has decided to waive off the FASTag cost of ₹100 for NHAI FASTag between February 15 and 29, 2020," the government said in a statement.
Vehicle owners can visit any authorised point-of-sale location with a valid Registration Certificate (RC) of the vehicle to purchase the FASTag free of cost. However, the security deposit and minimum balance applicable for the FASTag wallet shall remain unchanged, the government said.
Source :
https://www.livemint.com/news/india/no-fastag-fee-for-the-next-15-days/amp-11581505616063.html
Feed, Ubuntu
19:14
Microsoft’s new Windows 10X operating system for dual screens (First Look)
Microsoft released its first emulator for Windows 10X today, allowing developers to get a first look at the new operating system variant for dual-screen devices. Microsoft wants to give developers a head start on optimizing apps before devices launch later this year, so this basic emulator provides an early look at Windows 10X before it’s finalized.
Feed, Ubuntu
19:14
๐ฆBank of Baroda (BoB) has revised interest rates on fixed deposits (FDs) with effect from 10 February 2020.
Bank of Baroda latest FD interest rates (below ₹2 crore) for general public
▶7 days to 14 days 4.50%
▶15 days to 45 days 4.50%
▶46 days to 90 days 5.00%
▶91 days to 180 days 5.00%
▶181 days to 270 days 5.50%
▶271 days & above and less than 1 year 5.50%
▶1 year 6.00%
▶Above 1 year to 400 days 6.00%
▶Above 400 days and upto 2 years 6.00%
▶Above 2 years and upto 3 years 6.00%
▶Above 3 years and upto 5 years 6.25%
▶Above 5 years and upto 10 years 6.00%
๐กFor Senior Citizens :
๐ก The bank offers special interest rate on FD for senior citizens. Senior citizens get an additional interest of 0.50% on domestic term deposits of less than ₹2 crore for all tenors.
Feed, Ubuntu
08:44
What size should I make a partition to appear as a standard number e.g 10gb 100Gb perfect
For every 10GB add 8MB.
For every 100GB add 80MB.
For Perfect 100GB Drive.
100GB Drive = 100 X 1024 = 102400MB (Displayed as 99.99GB)
Perfect 100GB Drive = 10 x 10240 + 10 x 8 = 102480MB (Displayed as 100.00GB)
Friday 7 February 2020
Feed, Ubuntu
01:49
SBI cuts interest rates on fixed deposits (FDs).
The bank slashed Term Deposits rates by 10-50 bps in the Retail segment and 25-50 bps in the Bulk segment," SBI said in a statement.
From 10.02.2020
▶7 days to 45 days 4.50
▶46 days to 179 days 5.00
▶180 days to 210 days 5.50
▶211 days to less than 1 year 5.50
▶1 year to less than 2 year 6.00
▶2 years to less than 3 years 6.00
▶5 years and up to 10 years 6.00
SBI offers senior citizens’ an additional 50 basis point interest rate across all tenures. ๐ผ
⏩7 days to 45 days 5.00%
⏩46 days to 179 days 5.50%
⏩180 days to 210 days 6.00%
⏩211 days to less than 1 year 6.00%
⏩1 year to less than 2 year 6.50%
⏩2 years to less than 3 years 6.50%
⏩3 years to less than 5 years 6.50%
⏩5 years and up to 10 years 6.50%
Subscribe to:
Posts (Atom)
