tech
-
Control DDL Commands in Oracle Databases
This article discusses implementing a database-level trigger to manage and restrict DDL operations by limiting access to specific users. Unauthorized users attempting DDL actions will encounter a custom error message. The trigger code is provided, along with examples of error stacks generated from prohibited actions such as adding a column or truncating a table. This…
-
watch Command in Unix
The content outlines the use of the “watch” command to monitor an Oracle ZDM migration process on Azure. It demonstrates how to query job status at regular intervals, providing details about the job ID, user, type, execution times, and system metrics. The command’s functionality enhances visibility into the migration process.
-
Step-by-Step Guide to Fdupes on macOS
-
Streamline Banking Documents: Smart Rules in DEVONthink
The author advocates for automating document management in light of increasing digital artifacts. They highlight risks of poor tracking and propose using DEVONthink for better organization. A specific use case involves creating a ‘Smart Rule’ to automatically sort bank documents by date for archiving, enhancing efficiency and accessibility.
-
Using Sieve: Resetting Email Filters Effectively
The article discusses the use of Sieve, an email filtering tool, to manage incoming emails effectively. It outlines techniques for resetting filters, sorting emails into designated mailboxes based on specific criteria, and setting expiration dates for emails. Various examples illustrate these processes, emphasizing maintenance and organization.
-
How to Detect Unused PL/SQL Objects in Oracle
To identify unused PL/SQL code in an Oracle database, several methods are recommended. Strategies include auditing PL/SQL execution, using DBA_DEPENDENCIES views to track dependencies, and analyzing execution data through DBMS_PROFILER. A process for safely removing unused code should be established, including renaming suspected units and ensuring backups before deletion.
-
Understanding RAC One Node: Benefits and Drawbacks
RAC OneNode is an Oracle RAC feature that allows a single database instance on one node with easy relocation options. It enhances high availability and simplifies management but is less effective for heavy workloads and multi-node performance. Its complexities in licensing and potential downtime during relocations are notable drawbacks.
-
Top Factors for Oracle Database Migration Success
To migrate Oracle database instances to Oracle Database on Azure, key criteria include database size, workload characteristics, version compatibility, application dependencies, performance requirements, high availability, security compliance, current infrastructure, customization complexity, migration strategy feasibility, backup procedures, and cost implications. Assessing these ensures effective migration planning.
-
Oracle Database: Constraints Tutorial
This article compiles various queries and code blocks used to manage disabled constraints in a database schema. It includes SQL statements to identify and enable these constraints. The content will be updated regularly with new insights, and it lists the tested database versions, starting with Oracle Database 23ai.
-
Ensuring PL/SQL Code Integrity with Checksums
The content explains how to implement a checksum for PL/SQL procedures to detect unauthorized modifications. It details steps for generating a checksum using Oracle’s DBMS_CRYPTO, storing it for future verification, and comparing it against current values. This approach helps ensure the integrity of PL/SQL procedures over time.
-
User maintenance on macOS
-
Setting up Oracle Base Database Service on OCI
Oracle Base Database service is a for pay offering on OCI but it is quite reasonably priced and suitable for setting up test environments. Still the setup is relatively complex and the scope of this article is the out line the main steps used. Setup the Network Decide the compartment to be used. In my…