A database in ARCHIVELOG mode copies redo log entries in the achive log files. Archive log number and size is a metric of a database transactions load in time. Use the following query to monitor the Archive log production per…
Fast Recovery Area is used for various components such as duplicates of control files and redo logs, backups, archive logs and flashback logs. If a database is in ARCHIVELOG mode and there is no space left in FRA, the database…
Use the following statements to find partitioned tables with non aligned indexes. Unaligned indexes forbid partition switch.
DataPump is an excellent tool to transfer data between databases. Since Autonomous Databases don’t provide access to their OS there is a difficulty to use datapump to import or export data. This is bypassed by using a storage bucket. To…
To access the Autonomous Database using CloudShell you need to set the following parameters: export ADBID=ocid1….. –This is the OCID of the Autonomous database. export WNAME=wallet.zip —This is the wallet file. export WPWD=password — This is the password of the…
Use the following statement to see all columns covered by indexes on a table:
Automatic Partition SET ANSI_NULLS, QUOTED_IDENTIFIER ON; <br>GO <br>use <Database> <br>Declare <br>@nextRange date, <br>@sql nvarchar(3000), <br>@maxBoundary date, <br>@tableList varchar(1000) ='Table1,Table2,Table3', <br>@tableName varchar(100), <br>@partitionFunction varchar(100), <br>@partitionScheme varchar(100), <br>@PartitionedTables as cursor , <br>@debug bit =0, <br>@monthsPartitionFuture smallint =7,<br>@filegroup = 'Primary' ; <br>set @PartitionedTables…