https://skysql.com/2024/10/01/build-a-gen-ai-app-in-minutes-with-skysql-mariadb-vector-and-llamaindex/


#db #dba #ai #mariadb #sql

@unixmens

مقاله ای که در مورد staging نوشتم . تقدیم دوستان

نویسنده : یاشار اسمعیل دخت

#database #stage #staging #oracle #dba #mariadb #mysql #article

#yashar_esmaildokht


https://t.iss.one/unixmens

How Postgres 17 improves IN queries

In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements.

In Postgres 17 it takes an array and eliminates the need for multiple scans.

#dba #postgress #index #db
@unixmens

Selecting the right database is crucial for building robust workflows tailored to your needs. Databases are the backbone of efficient data storage, retrieval, and management.

Different database types serve unique purposes:

• Spatial Databases: Ideal for geospatial data.

• Time-Series Databases: Perfect for monitoring and analytics.

• Vector, Graph, Document, and Relational Databases: Each offers specialized capabilities for diverse workflows.

For scalability and speed in high-demand environments, consider:

• NoSQL Databases

• Columnar Databases

• In-Memory Databases

Additionally, Object-Oriented Databases provide flexibility for managing complex data structures.

Choose wisely to ensure seamless integration and enhance the precision of your workflows.


#database #devops #dba


https://t.iss.one/unixmens

▎Common Oracle Errors and Fixes

1. ORA-12154: TNS: Could not resolve the connect identifier specified
Cause: Database connection string can't find the service name.
Fix: Check your tnsnames.ora file for typos or missing service names. Even a misplaced parenthesis can cause issues.

2. ORA-00600: Internal error code
Cause: A serious internal error occurred.
Fix: Review the alert.log and trace files for details. Use Oracle’s ORA-00600 Lookup Tool for deeper insights.

3. ORA-01722: Invalid Number
Cause: Attempting to convert a non-numeric string to a number.
Fix: Verify data types in SQL queries, especially with conversions like TO_NUMBER.

4. ORA-03113: End-of-file on communication channel
Cause: Sudden connection drops indicate network or server issues.
Fix: Investigate server crashes, network disconnections, or unexpected process terminations.

5. ORA-01000: Maximum open cursors exceeded
Cause: Too many open cursors without closing them.
Fix: Optimize your code to ensure cursors are closed and adjust the OPEN_CURSORS parameter if necessary.

6. ORA-12560: TNS: Protocol adapter error
Cause: Connectivity issue due to improperly running Oracle services.
Fix: Ensure Oracle services are active and verify your environment variables.

7. ORA-12505: TNS: Listener does not currently know of SID given in connect descriptor
Cause: Configuration mismatch with the listener.
Fix: Use lsnrctl status to check listener configuration and ensure the SID matches in listener.ora.

8. ORA-04031: Unable to allocate memory in the shared pool
Cause: Memory allocation issues in the shared pool.
Fix: Increase the shared pool size or flush it with ALTER SYSTEM FLUSH SHARED_POOL.

9. ORA-01555: Snapshot too old
Cause: Insufficient undo tablespace during undo operations.
Fix: Increase undo tablespace size or optimize queries to reduce excessive undo generation.

10. ORA-00936: Missing expression
Cause: Syntax errors in SQL statements.
Fix: Review SQL syntax for missing or misplaced operators, keywords, or parentheses.




#orace #dba #error

https://t.iss.one/unixmens

دوستان پرسیده بودن در oracle 19c چه ویژگی های جدیدی داریم و پاسخ من


#oracle #dba

@unixmens

END: این بلوک حاوی دستورات SQL اصلی Stored Procedure است.
* SELECT * FROM Customers WHERE CustomerName LIKE CONCAT('%', name, '%');: این دستور SQL مشتریانی را برمی‌گرداند که نام آن‌ها مشابه پارامتر ورودی name است. CONCAT در MariaDB برای الحاق رشته‌ها استفاده می‌شود. این معادل % + name + % در SQL Server است.
* DELIMITER ;: این خط جداکننده‌ی دستورات را به حالت پیش‌فرض ; برمی‌گرداند.


نحوه‌ی اجرا:

بعد از ایجاد این Stored Procedure، می‌توانید آن را با استفاده از دستور زیر اجرا کنید:

CALL GetCustomersByName('John');

این دستور، Stored Procedure را با پارامتر ورودی 'John' اجرا می‌کند و مشتریانی را که نام آن‌ها شامل "John" است را برمی‌گرداند.


به خاطر داشته باشید که قبل از اجرای این کد، باید مطمئن شوید که جدولی به نام Customers با ستونی به نام CustomerName در پایگاه داده‌ی خود دارید. همچنین، دسترسی‌های لازم برای ایجاد Stored Procedure را داشته باشید.


#dba #tips

@unixmens

Database DevOps engineers manage complex database ecosystems, encompassing technologies like SQL, RAC, Exadata, and OCI. The role requires deep technical expertise, strong problem-solving skills, and the ability to juggle multiple priorities under pressure – a constant need to orchestrate high-performing, reliable database solutions. This involves managing infrastructure, troubleshooting performance issues, and ensuring high availability and scalability. Effective communication and collaboration are essential for coordinating with developers, operations teams, and stakeholders to meet evolving business needs and navigate competing priorities. Responsibilities extend to automation and ensuring the seamless delivery of database solutions. Are you a highly skilled Database DevOps engineer with experience across diverse platforms? If so, we want to hear from you!

#dba

https://t.iss.one/unixmens

ما در داتین در پارک فن آوری پردیس پوزیشن باز برای کارشناس دیتابیس (اوراکل dba) داریم .
تیم ما بیشتر متمرکز هست بر فعالیت های app dba :
schema management
sql tuning
partitioning & indexing
oracle performance tuning
oracle security
database design
plsql programing


در صورتی که توانایی های استفاده از سرویس ها و نرم افزار های زیر را نیز دارید به عنوان پلاس برای ما محسوب میشه و فرصت استفاده از این توانایی ها نیز در تیم ما هست :
oracle goldengate
oracle data guard
oracle rman
postgres dba
python

شرایط کار :
حضور کامل در شرکت در تایم اداری
امکان دورکاری در صورت تایید مدیر
حداقل ۲ سال سابقه کار مرتبط با اوراکل


امکانات داتین (پارک فن آوری پردیس):
صبحانه ،ناهار، شام
برگزاری دوره های آموزشی
آنکالی
سرویس ایاب و ذهاب
اتاق استراحت
اتاق بازی(ps5)

فرصت کار و کسب تجربه در دیتابیس های بزرگ و دیدن چالش هایی جدید فراهم‌ هست .

حداقل نیازمندی برای جذب تو این تیم :
-تسلط به معماری instance اوراکل (pga ,sga)
تسلط به کتاب oracle administration workshop 1
نیاز به تجربه عملیاتی نیست و آموزش های لازم در حین کار داده میشه
-تجربه کاری در محیط عملیاتی و آشنایی به ریسک ها و دغدغه های این محیط
-

لطفا رزومه خودتون به
[email protected]
ارسال کنید
#jobs #oracle #dba #linux

@unixmens

Oracle Audit Vault and Database Firewall (AVDF) is a comprehensive security solution designed to protect sensitive data in Oracle databases and other database environments. It combines auditing, monitoring, and protection capabilities to help organizations secure their databases against unauthorized access and potential threats.

▎Key Features of Oracle Audit Vault and Database Firewall:

1. Database Auditing:

• Comprehensive Auditing: AVDF collects and consolidates audit data from various databases, including Oracle and non-Oracle databases, providing a centralized view of database activity.

• Policy-Based Auditing: Organizations can define specific auditing policies to monitor critical actions, such as changes to sensitive data or unauthorized access attempts.

2. Real-Time Monitoring:

• Database Firewall: The solution includes a firewall that monitors and filters database traffic in real-time, blocking unauthorized access attempts and SQL injection attacks.

• Alerts and Notifications: Security teams can receive alerts for suspicious activities, allowing for prompt investigation and response.

3. Threat Detection:

• Anomaly Detection: AVDF uses machine learning algorithms to detect unusual patterns of database activity that may indicate potential security threats.

• Predefined Rules: The system comes with a set of predefined security rules that help identify common attack vectors.

4. Compliance Reporting:

• Regulatory Compliance: AVDF assists organizations in meeting compliance requirements for regulations such as GDPR, HIPAA, PCI-DSS, and others by providing detailed audit logs and reports.

• Custom Reporting: Users can generate custom reports based on specific criteria to support compliance audits.

5. Data Protection:

• Sensitive Data Discovery: AVDF helps identify and classify sensitive data within databases, enabling organizations to apply appropriate security measures.

• Data Masking: The solution can mask sensitive data in non-production environments to protect it from unauthorized access during testing or development.

6. Centralized Management:

• Single Interface: AVDF provides a single management console for monitoring and managing security across multiple databases, simplifying administration tasks.

• Integration with Existing Security Tools: The solution can integrate with other security products and SIEM (Security Information and Event Management) systems for enhanced visibility.

▎Use Cases:

• Regulatory Compliance: Organizations in regulated industries can use AVDF to ensure they meet compliance requirements related to data security and auditing.

• Data Security Posture Improvement: By implementing AVDF, organizations can strengthen their overall data security posture and reduce the risk of data breaches.

• Incident Response: Security teams can leverage the real-time monitoring capabilities to quickly respond to potential threats and mitigate risks.

In summary, Oracle Audit Vault and Database Firewall provides organizations with a robust framework for securing their database environments through comprehensive auditing, real-time monitoring, threat detection, and compliance reporting. It is particularly valuable for businesses that handle sensitive data and need to adhere to strict regulatory requirements.



#oracle #database #devops #dba #linux #mysql #sqlserver #system

https://t.iss.one/unixmens