In the previous article, I discussed the main differentiating capabilities of the Autonomous, what makes it special on the market. In this post, I will discuss how are those capabilities implemented. First, a few considerations re implementation of the security benefits of Autonomous: No DBA access is rather controversial point of debate among the DBA community and I prefer to […]
There is no surprise that typical Database setups are the main target of the hacking attacks worldwide. The reason is obvious: cracking a database will result in access to the data which is the main ‘merchandise’ to be shared or sold on the dark corners of the World Wide Web. The examples are numerous and any successful attack results in […]
The feature was first introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled. I work on an great autonomous TP instance and it is already enabled: The feature is supported at different levels: column table schema session database statement In this post, we will […]
Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019. But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good reference usable when connectiong to one autonomous database but if we need to use several ADB’s, the instructions provided by […]
One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works. We use a table with 9 000 000 rows and seelct from it with a sample percentage of 0.0001 We […]
Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.3.0.0.0 I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a way to estimate the space benefits of defragmenting the tablespace. I will use two methods: Method 1. By calculating the theoretical size of the tables. It is outlined below in steps 19-20. The limitation of this calculation is that right now it works for tables only Method 2. By using the Segment Advisor. Outlined below in steps 21-22 1. Check the datafile does not exist at OS level: 2. Create the tablespace as user SYSTEM: 3. Check DB file getting created: 4. Login as ‘radu’ user. Create test tables in the test_tbs tablespace: 5. Check size of the DB file. Should not be changed: 11M 6. Run test SQL: Output: 7. Populate first test table with 9 million rows. Example of block used to populate the table: 8. Check size of the DB file –> 291M 9. Run the control SQL from step 6. Used –> 284M 10. Populate second test table with 9 million rows. 11. Check size of the DB file –> 526M 12. Run the control SQL from step 6. Used –> 500M 13. Delete all the rows from the first test table and commit. 14. Check size of the DB file –> 526M. Unchanged 15. Run […]
I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which was stored in a ‘protected’ location. Using SQL Developer in a foreign, non-English language was a pain so, after some […]
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud. Quite easy to implement, too: The options are:
a. First step is the database creation. Quite straightforward: b. Next step is to a connection setup connection from local client: from the main datbase page we click the DB Connection button and download the client credentials: A zip archive will de downloaded into your local client machine. In my case, the file is called: Wallet_raduatp.zip c. SQL Developer Connection: […]
Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from: https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html The installation is quite simple but we need to rememeber that, in order to have a functional client for a DBA we would need to download three packages at least: Basic Package – All files required to run […]
Recent Comments