Create a separate user account for each employee in Windows 10 lets each person adjust his or her individual profile settings. To create a new user account in Windows 10, follow these six steps. 1. Right-click the Windows Start menu button 2. Select Control Panel 3. Select User Accounts 4. Select Manage another account 5. Select Add a new user in…
Author: siteadmin
RMAN Backup using ShellScript
In a real time, we will not take Oracle database backup manually everyday. Some of the tasks can be automated like RMAN backups. In this post, we will see how to automate RMAN backup using shellscript and I personally use shellscript for import/export, rman backup and for monitoring alerts. • Create Backup directory• Create RMAN…
TableSpace Management In Oracle
Tablespace management in Oracle involves various activities and considerations to ensure efficient storage, performance, and availability of database objects. Here are some key aspects of tablespace management in Oracle: 1. Creating a new tablespace To create a new tablespace, use the CREATE TABLESPACE SQL command. Define the tablespace name, data file(s) location, size, and other…
SQL Server Architecture
SQL Server is a popular relational database management system (RDBMS) developed by Microsoft. It is designed to store, retrieve, and manage data efficiently. SQL Server has a multi-tiered architecture that comprises several components, each responsible for specific tasks. Here’s an overview of its architecture: Overall, this detailed explanation covers the main components of the SQL…
Flash Recovery Area(FRA) Manage in Oracle
To effectively manage the Flash Recovery Area (FRA) in Oracle, you need to monitor its space usage, configure its size appropriately, and ensure backups and archived redo logs are being managed efficiently. Here are some essential steps and best practices for managing FRA: 1. Monitor FRA Space Usage Regularly monitor the space usage of the…
FRA In Oracle
In the context of Oracle, FRA stands for “Flash Recovery Area.” It is a feature introduced in Oracle Database 10g that provides a centralized and automated location for managing backup and recovery-related files. The FRA simplifies the backup and recovery process by managing backup files, archived redo logs, and other recovery-related files, making it easier…
Oracle Database Startup Modes
In Oracle, the “startup” command is used to start the Oracle Database instance after it has been shut down. There are different types of oracle database startup modes available, depending on the situation and the level of recovery required. Here are the common types of startup in Oracle: 1. Normal Startup This is the standard…
Oracle Database Shutdown Modes
In Oracle, a “shutdown” refers to the process of stopping the Oracle Database instance. There are several types of shutdowns available, depending on the purpose and the level of activity in the database. Here are the common types of shutdowns in Oracle: 1. Shutdown Normal This is the regular and graceful way to shut down…
Add or Create A New ASM Disk
Adding or creating a new ASM (Automatic Storage Management) disk involves several steps. ASM is a feature of Oracle Database that manages database files and provides striping and mirroring for better performance and redundancy. Here’s a general outline of the process to add or create a new ASM disk: 1. Identify the Disk First, identify…
Speeding Up Windows OS: 7,8,10 and 11
Speeding up Windows OS involves optimizing system performance, reducing startup times, and improving overall responsiveness. Here are some tips and optimizations that can help enhance the performance of your Windows PC: Remember to back up your important data before making significant changes to your windows OS system. Additionally, the effectiveness of these tips may vary…