public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectTableAllocatedBytesCommandText;
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
command.AddSimpleParameter("PARTITION_NAME", _partitionName.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectViewSelectCommand;
command.InitialLONGFetchSize = Int32.MaxValue;
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("VIEW_NAME", _objectIdentifier.Name.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = String.Format(OracleDatabaseCommands.SelectIndexDescriptionCommandText);
command.AddSimpleParameter("TABLE_OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
command.AddSimpleParameter("COLUMN_NAME", String.IsNullOrEmpty(_columnName) ? null : _columnName.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectColumnStatisticsCommandText;
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
command.AddSimpleParameter("COLUMN_NAME", _columnName.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = _commandText;
command.AddSimpleParameter("OBJECT_TYPE", _objectType);
command.AddSimpleParameter("NAME", _objectIdentifier.Name.Trim('"'));
command.AddSimpleParameter("SCHEMA", _objectIdentifier.Owner.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = BuildCommandText(OracleDatabaseCommands.SelectTableSubPartitionsDetailsCommandTextBase, _includeInMemorySettings);
PartitionDataProvider.InitializeCommand(command, _subPartitionOwner);
command.AddSimpleParameter("PARTITION_NAME", _partitionDataModel?.Name);
command.AddSimpleParameter("SUBPARTITION_NAME", _subPartitionDataModel?.Name);
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectIndexColumnDescriptionCommandText;
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
command.AddSimpleParameter("COLUMN_NAME", String.IsNullOrEmpty(_columnName) ? null : _columnName.Trim('"'));
_indexes = DataModel.IndexDetails.ToDictionary(i => OracleObjectIdentifier.Create(i.Owner, i.Name));
}
public override void InitializeCommand(OracleCommand command)
{
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
if (String.IsNullOrEmpty(_columnName))
{
command.CommandText = String.Format(OracleDatabaseCommands.SelectTableCommentCommandText);
}
else
{
command.CommandText = String.Format(OracleDatabaseCommands.SelectColumnCommentCommandText);
command.AddSimpleParameter("COLUMN_NAME", _columnName.Trim('"'));
}
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectSessionsStatisticsCommandText;
command.AddSimpleParameter("SID", DataModel.SessionId);
DataModel.StatisticsRecords.Clear();
}
public override void InitializeCommand(OracleCommand command)
{
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
if (String.IsNullOrEmpty(_columnName))
{
command.CommandText = OracleDatabaseCommands.SelectTableConstraintDescriptionCommandText;
}
else
{
command.CommandText = OracleDatabaseCommands.SelectColumnConstraintDescriptionCommandText;
command.AddSimpleParameter("COLUMN_NAME", _columnName.Trim('"'));
}
command.InitialLONGFetchSize = 32767;
}
public async Task Start(CancellationToken cancellationToken)
{
_debuggedSessionCommand.CommandText = OracleDatabaseCommands.StartDebuggee;
_debuggedSessionCommand.AddSimpleParameter("DEBUG_SESSION_ID", null, TerminalValues.Varchar2, 12);
var debuggedSessionIdParameter = _debuggedSessionCommand.Parameters[0];
await _debuggedSessionCommand.ExecuteNonQueryAsynchronous(cancellationToken);
_debuggerSessionId = ((OracleString)debuggedSessionIdParameter.Value).Value;
TraceLog.WriteLine($"Target debug session initialized. Debug session ID = {_debuggerSessionId}");
await Attach(cancellationToken);
TraceLog.WriteLine("Debugger attached. ");
var attachTask = Synchronize(cancellationToken).ContinueWith(AfterSynchronized, cancellationToken, TaskContinuationOptions.OnlyOnRanToCompletion);
_debuggedAction = DebuggedCommand.ExecuteNonQueryAsynchronous(cancellationToken);
TraceLog.WriteLine("Debugged action started. ");
await attachTask;
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectCompilationErrorsCommandText;
command.AddSimpleParameter("OWNER", _owner);
command.AddSimpleParameter("NAME", _objectName);
}
private static void InitializeCommand(OracleCommand command, OracleObjectIdentifier partitionOwner)
{
command.AddSimpleParameter("TABLE_OWNER", partitionOwner.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", partitionOwner.Name.Trim('"'));
command.InitialLONGFetchSize = HighValueMaxLength + 1;
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectCursorExecutionStatisticsCommandText;
command.AddSimpleParameter("SQL_ID", _sqlId);
command.AddSimpleParameter("CHILD_NUMBER", _childNumber);
}
public async Task <bool> IsRunning(CancellationToken cancellationToken)
{
_debuggerSessionCommand.CommandText = "BEGIN IF dbms_debug.target_program_running THEN :isRunning := 1; ELSE :isRunning := 0; END IF; END;";
_debuggerSessionCommand.Parameters.Clear();
_debuggerSessionCommand.AddSimpleParameter("ISRUNNING", null, TerminalValues.Number);
await _debuggerSessionCommand.ExecuteNonQueryAsynchronous(cancellationToken);
var isRunning = ((OracleDecimal)_debuggerSessionCommand.Parameters[0].Value).Value;
return(Convert.ToBoolean(isRunning));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = String.Format(OracleDatabaseCommands.SelectExecutionPlanTextCommandTextBase, _resolveAdaptivePlan ? "ADAPTIVE" : null);
command.AddSimpleParameter("SQL_ID", _sqlId);
command.AddSimpleParameter("CHILD_NUMBER", _childNumber);
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectTableDetailsCommandText;
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("TABLE_NAME", _objectIdentifier.Name.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectUserAdditionalData;
command.AddSimpleParameter("USERNAME", DataModel.Schema.Name.Trim('"'));
}
private static void AddDebugParameters(OracleCommand command)
{
command.AddSimpleParameter(ParameterDebugActionStatus, null, TerminalValues.Number);
command.AddSimpleParameter("BREAKPOINT", null, TerminalValues.Number);
command.AddSimpleParameter("INTERPRETERDEPTH", null, TerminalValues.Number);
command.AddSimpleParameter("LINE", null, TerminalValues.Number);
command.AddSimpleParameter("OER", null, TerminalValues.Number);
command.AddSimpleParameter("REASON", null, TerminalValues.Number);
command.AddSimpleParameter("STACKDEPTH", null, TerminalValues.Number);
command.AddSimpleParameter("TERMINATED", null, TerminalValues.Number);
command.AddSimpleParameter("DBLINK", null, TerminalValues.Varchar2, 30);
command.AddSimpleParameter("ENTRYPOINTNAME", null, TerminalValues.Varchar2, 512);
command.AddSimpleParameter("OWNER", null, TerminalValues.Varchar2, 30);
command.AddSimpleParameter("NAME", null, TerminalValues.Varchar2, 30);
command.AddSimpleParameter("NAMESPACE", null, TerminalValues.Number);
command.AddSimpleParameter("LIBUNITTYPE", null, TerminalValues.Number);
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectTableInMemoryAllocatedBytesCommandText;
command.AddSimpleParameter("OWNER", _objectIdentifier.Owner.Trim('"'));
command.AddSimpleParameter("SEGMENT_NAME", _objectIdentifier.Name.Trim('"'));
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectProfileDetails;
command.AddSimpleParameter("PROFILE", DataModel.Name);
}
private static void AddDebugParameters(OracleCommand command)
{
command.AddSimpleParameter(ParameterDebugActionStatus, null, TerminalValues.Number);
command.AddSimpleParameter("BREAKPOINT", null, TerminalValues.Number);
command.AddSimpleParameter("INTERPRETERDEPTH", null, TerminalValues.Number);
command.AddSimpleParameter("LINE", null, TerminalValues.Number);
command.AddSimpleParameter("OER", null, TerminalValues.Number);
command.AddSimpleParameter("REASON", null, TerminalValues.Number);
command.AddSimpleParameter("STACKDEPTH", null, TerminalValues.Number);
command.AddSimpleParameter("TERMINATED", null, TerminalValues.Number);
command.AddSimpleParameter("DBLINK", null, TerminalValues.Varchar2, 30);
command.AddSimpleParameter("ENTRYPOINTNAME", null, TerminalValues.Varchar2, 512);
command.AddSimpleParameter("OWNER", null, TerminalValues.Varchar2, 30);
command.AddSimpleParameter("NAME", null, TerminalValues.Varchar2, 30);
command.AddSimpleParameter("NAMESPACE", null, TerminalValues.Number);
command.AddSimpleParameter("LIBUNITTYPE", null, TerminalValues.Number);
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = String.Format(OracleDatabaseCommands.SelectExplainPlanCommandText, DataModel.TargetTableName);
command.AddSimpleParameter("STATEMENT_ID", DataModel.ExecutionPlanKey);
}
public override void InitializeCommand(OracleCommand command)
{
command.CommandText = OracleDatabaseCommands.SelectTablespaceDatafiles;
command.AddSimpleParameter("TABLESPACE_NAME", DataModel.Name);
}